Unpaid invoices are useful records only if they show what customers genuinely owe, when payment is due and what action is needed. An accounts receivable report full of duplicates, unidentified receipts and unresolved credits can exaggerate future cash and send customers incorrect reminders.
In this article
- Check invoice due dates
- Resolve disputes or missing details
- Record agreed payment dates
- Review overdue balances
Good accounts receivable bookkeeping connects the sales invoice, delivery or service evidence, payment terms, receipts and correspondence. It lets the business distinguish a customer who is simply late from one who disputes the work or has already paid under an unfamiliar reference.
Make the starting balance trustworthy
Before chasing debt, reconcile the sales ledger with receipts. Allocate customer payments, record approved credit notes and investigate balances that look unusual. Check that the total owed by customers agrees with the corresponding balance in the accounts.
Review credit balances separately. They can indicate overpayments, credits awaiting refund or receipts assigned to the wrong customer. Do not use a negative balance on one customer to hide a debt on another unless there is a valid, documented reason for the allocation.
Check invoice dates, due dates and payment terms. An invoice dated three weeks ago with 30-day terms is different from one that was due immediately. Ageing by invoice date and ageing by due date answer different questions; make clear which report you are using.
Give the ageing report an action column
An ageing report usually groups outstanding balances into periods. Add operational information so it becomes a collection tool rather than a historical list.
| Field | Why it matters |
|---|---|
| Customer and invoice reference | Identifies the debt being discussed |
| Original amount and remaining balance | Distinguishes full from partial payment |
| Due date and days overdue | Supports prioritisation |
| Disputed amount and reason | Prevents misleading routine reminders |
| Last contact and promised date | Stops repeated, uncoordinated chasing |
| Named owner and next action | Creates responsibility |
Prioritise by amount, age and risk. A small disputed balance may need a decision, while a large invoice not yet due may warrant a friendly confirmation that it is approved for payment. Neither is solved by sending the same overdue email to everyone.
Match a partial receipt correctly
Illustrative example: a customer owes £1,200 on invoice A and £600 on invoice B. A £900 receipt arrives with a remittance stating that it relates to invoice A. Allocate £900 to A, leaving £300 on A and £600 on B.
The customer still owes £900, but the detail matters. Applying the receipt to the oldest balance without reading the remittance could leave a disputed item apparently settled and an agreed invoice apparently unpaid. Record the allocation and ask the customer where the payment belongs if the evidence is unclear.
If the customer later disputes £100 of invoice A, keep the outstanding £300 visible and identify the £100 dispute within it. Do not delete the entire remaining invoice merely because a query exists.
Chase with information the customer can use
Confirm that the invoice reached the correct person and includes any required purchase-order reference. Send a statement with the invoice copy, due date, remaining balance and payment details. Ask whether anything prevents approval and record the response.
Agree a short escalation routine: reminder, personal contact, decision on future credit and referral for further action where appropriate. Legal recovery, late-payment interest and compensation require a separate check of the contract and applicable rules; they should not be invented by a bookkeeping reminder template.
Before changing payment details or responding to a suspicious request, verify the communication through an independently established contact route. Accurate records are of little use if collection instructions are diverted to the wrong account.
Keep the cash forecast realistic
An unpaid invoice is not cash already available. Forecast receipts using expected collection dates and current evidence. Separate a reliable payment promise from a hopeful estimate, and show disputed or doubtful receipts as scenarios rather than certain inflows.
For example, an illustrative £5,000 invoice due next week may need to move out of the base forecast if the customer has not accepted the work. That adjustment changes cash planning without automatically changing the accounting value of the debt.
Review doubtful balances with the accountant. A provision, write-off and any tax or VAT relief are separate decisions requiring support; overdue status alone does not settle them. Preserve correspondence and the reason for any adjustment.
Use a consistent weekly routine
Allocate new receipts, review overdue balances, update payment promises and escalate broken commitments. Compare actual collections with the forecast so optimistic assumptions can be corrected. Track how much overdue debt is disputed, not just the total.
For support with reliable customer balances, discuss EPOS bookkeeping services. If collection delays are affecting decisions, the same records can support a conversation about cash flow planning.