Payments

How to Manage Customer Payments and Outstanding Balances

Sales are vanity, cash is sanity. A practical system built on the Record Payment dialog, the oldest-first outstanding list, and a follow-up cadence that actually gets you paid.

Updated ⏱ 7 min read 1,282 words β–Ά Watch video ❓ 4 FAQs πŸ‘ 1 views
How to Manage Customer Payments and Outstanding Balances
πŸ“‘ On this page 11 sections

Most small businesses do not fail because they lack sales. They fail because sales and cash arrive in different months. Every invoice you send without a tracking system is a small loan you did not agree to β€” and outstanding balances have a way of aging quietly until they are uncollectable.

The fix is not aggressive chasing. It is a boring, repeatable system: record every payment properly, know exactly who owes what and for how long, and follow up on a schedule. Here is that system, end to end, using the actual screens in LedgerBizz Standard.

Why Balances Slip Through the Cracks #

  • Payments arrive in pieces β€” a deposit, a mid-project installment, a final amount β€” and nobody sums them.
  • The method and reference are not recorded, so bank reconciliation becomes archaeology.
  • "I think they paid" replaces "the balance is $340, due 12 days ago."
  • Follow-ups happen when someone remembers, which is to say, rarely.

Each of these is a recording problem before it is a customer problem.

Every Invoice Lives in One of Three States #

StatusMeaningWhat you do
UnpaidNothing received yetWatch the date
PartialSome received, balance remainsTrack the remainder and next follow-up
PaidFully settledFile it; the receipt chain is complete

In the Documents tab you set this state at creation: choosing Partial or Paid reveals the Amount Paid field (Paid auto-fills the grand total), and the method and transaction reference are captured right there in πŸ’³ Payment Details. One honest nuance: quotations, LPOs, proformas, delivery notes, and credit/debit notes are not payment documents β€” they save as Completed, and their payment button is deliberately disabled. Receipts always save as Completed too: a receipt is proof of money received, not a running balance.

The πŸͺ™ Record Payment Dialog, Field by Field #

On any unpaid or partial invoice in πŸ“‹ Saved Documents, click the πŸͺ™ button (tooltip: Record Payment / Update Status). The dialog opens with the full picture β€” invoice number, customer, total, Already Paid, Current Balance, and status β€” then takes four inputs:

  • Payment Amount β€” as you type, the balance panel recalculates live and tells you plainly: "βœ… Invoice will be fully paid!", "⏳ Partial payment β€” balance remaining", or "⚠️ Payment exceeds balance!"
  • Payment Method β€” Cash, M-Pesa, Bank Transfer, Cheque, Credit Card, or Other.
  • Transaction Reference β€” the M-Pesa code, cheque number, or transfer ID. The placeholder says it best: "MPESA code, cheque number, etc."
  • Notes β€” anything future-you will want to know.

Save, and the invoice updates itself: balance cleared β†’ Paid; balance remaining β†’ Partial. If you enter more than the balance, the app asks you to confirm the overpayment instead of silently swallowing it.

Rule of thumb: a payment without a reference is a rumor. Record the reference every single time, even for cash.

Consider a $1,200 invoice settled in three moves:

DateMethodReferenceAmountBalance after
Nov 2M-PesaQGH7YT2K9L$500.00$700.00
Nov 10Bank TransferTRF-88412$400.00$300.00
Nov 15CashReceipt #0091$300.00$0.00

Three entries, one invoice, zero ambiguity. Every one of them is visible later in the ✏️ Edit dialog β†’ πŸ’³ Payment History & Notes panel: date, amount, method, reference, and notes, newest first. When a client asks for a statement six months later, the answer takes seconds.

Read the Outstanding List Like a Pro #

Open the Reports tab. The ⚠️ Outstanding Invoices panel lists every Unpaid and Partial invoice oldest first β€” which is exactly the order a credit controller wants, because the top row is always your most overdue debt. Each row shows the number, client, amount, and issue date; the age is the distance between that date and today.

Treat the list as your aging ladder:

Age from issue dateRisk levelTypical action
Within termsHealthyNothing β€” let terms run
Just past termsWarmFriendly reminder with the PDF re-attached
~2 weeks pastConcerningDirect call; ask if there is a dispute
~1 month pastSeriousFormal letter on letterhead; pause new credit work
Beyond thatCriticalFinal demand; renegotiate terms

The pattern to watch is not any single invoice β€” it is a customer drifting down the list. That drift is the earliest reliable warning of a bad debt. The Payment Status Distribution chart beside it shows the Paid/Partial/Unpaid mix at a glance, and the dashboard's Pending Invoices card is your daily pulse.

A Follow-Up Cadence That Actually Gets Paid #

Put this on rails so it never depends on memory:

  1. Day 0 β€” send properly. The πŸ“§ button delivers a clean PDF with your payment details and terms on it.
  2. Day due β€” gentle nudge. "Just confirming this landed safely" is a service message, not a chase.
  3. 7 days overdue β€” reminder with the PDF. Use the πŸ“§ button again, or πŸ”„ Resend from the Reports tab's Email History β€” half of late payments are lost-email problems.
  4. 14 days overdue β€” phone call. Voice dislodges what email cannot, and surfaces disputes early.
  5. 30 days overdue β€” formal letter. The Generate Letterhead button produces it on your branded stationery; state the balance, the history, and a firm date.
  6. 45+ days β€” escalate terms. Pause further credit work until the balance clears.

A template for the day-7 email (paste it into Settings β†’ Custom Email Templates):

Subject: Reminder β€” Invoice {invoice_number} from {company_name} Hi {customer_name}, a quick note that invoice {invoice_number} shows a remaining balance, now 7 days past due. I have re-attached the invoice for convenience. If payment is already on the way, thank you β€” please share the M-Pesa or bank reference so I can mark it received. Happy to help if anything needs clarifying.

Polite, specific, easy to act on. And when the money lands, the reference they send goes straight into the Record Payment dialog.

Fix Errors With Credit and Debit Notes #

Disputes are often legitimate: returned goods, a pricing error, an agreed adjustment. Do not delete history β€” correct it. In the Documents tab, set Type to Credit Note (reduces what the client owes) or Debit Note (adds an approved extra charge), pick the client, and choose the original invoice in the πŸ”— Link dropdown; πŸ“₯ Load pulls its items so the note references the same figures.

One practical note: the note documents the adjustment β€” it does not silently rewrite the invoice. Record any refunded money via the payment flow and, where the balance changes, update the invoice's status in its ✏️ Edit dialog so the list stays truthful. The original invoice, the linked note, and the payment history then read as one coherent story β€” which is exactly what you want if a dispute ever becomes formal.

Two Numbers to Watch #

Days Sales Outstanding (DSO) β€” the average days between invoicing and cash:

If you invoiced $20,000 over 90 days and $6,000 is outstanding, DSO β‰ˆ 27 days. Track it monthly; the direction matters more than the absolute value.

Collection rate β€” payments received Γ· amounts invoiced, per month. Below 90% for two consecutive months means your cadence needs tightening, not your patience.

Both numbers come straight out of the Reports date-range filter and the πŸ“₯ Export to Excel button β€” no extra bookkeeping required.

The 20-Minute Monday Routine #

  1. πŸͺ™ Record every payment received since Friday, with methods and references.
  2. Open Reports β†’ Outstanding Invoices; note anyone who moved down the list.
  3. πŸ“§ Send the day-7 reminders (template above, PDF attached).
  4. Make the two oldest-row phone calls.
  5. Glance at the dashboard: Today's Sales, Tax/VAT Due, Pending Invoices.

Twenty minutes, weekly, forever. That routine β€” not heroic all-night chases β€” is what keeps outstanding balances shrinking while sales grow.

The Bottom Line #

Getting paid is a system, and systems beat intentions. Record payments with references the day they arrive, let the oldest-first list tell you where to look, and follow up on a schedule your customers can predict. The free trial of LedgerBizz Standard includes the full payment workflow β€” run your real receivables through it for ten days and watch the "I think they paid" era end.

Watch: How to Manage Customer Payments and Outstanding Balances

See the exact screens and clicks described in this guide β€” press play, then follow along in your own copy of LedgerBizz.

YouTube
πŸ”’ Privacy-first: the player only loads after you press play.β†— Open on YouTube

Questions readers ask

4 quick answers about this guide β€” tap a question to expand it.

Cash, M-Pesa, Bank Transfer, Cheque, Credit Card and Other β€” both when creating a document and in the Record Payment dialog.

Yes. The πŸͺ™ Record Payment button adds each payment with its method and reference, shows the remaining balance live, and sets the invoice to Partial or Paid automatically.

Reports β†’ Outstanding Invoices lists every Unpaid and Partial invoice oldest first, so the top row is always your most overdue debt.

The dialog warns that the payment exceeds the balance and asks you to confirm before recording it β€” nothing is silently swallowed.

#payments#cash flow#outstanding balances#credit control#M-Pesa

Written by LedgerBizz Team

The team behind LedgerBizz β€” offline business software for documents, invoicing, stock and the paperless office. We write about the workflows we build.

More from the Journal β†’

Your paperless office starts today

Nine document types, automatic totals, encrypted email backups β€” all offline on your computer. Try LedgerBizz Standard free for 10 days.