An aged debtors report can tell you that customers still owe money even when you know they have already paid. That is not a minor reporting nuisance. If the report is wrong, credit control may chase the wrong customers, cash-flow planning may use overstated receivables and the balance sheet may contain debts that do not really exist.
The useful question is not simply, “Did the money reach the bank?” It is, “Was that payment matched to the correct customer and invoice?” A dependable aged debtors report only works when invoices, credit notes, customer receipts and bank transactions are allocated properly.
What an aged debtors report is supposed to show
An aged debtors report, also called an aged receivables report, lists amounts customers owe the business and groups them according to how long they have been outstanding. Depending on the software, the ageing may be shown as current, 30 days, 60 days, 90 days and older, or by another set of periods.
The report is useful because it separates recorded sales from cash actually collected. An invoice can exist in the accounts while the customer still owes the money. Once the customer pays, the receipt should normally be allocated against the invoice so the outstanding balance reduces or disappears.
For limited companies, GOV.UK says accounting records must include money received and spent and debts the company owes or is owed. An aged debtors report is one practical way of monitoring part of that debtor information, provided the underlying bookkeeping is current.
Your customer paid, but the aged debtors report still shows the invoice
This is one of the most recognisable problems in sales-ledger bookkeeping. The customer pays £2,400. The bank shows the £2,400 receipt. Yet the aged debtors report still shows the original invoice as overdue.
The usual explanation is not that the customer owes the money twice. It is that the bank receipt has not been matched to the invoice. The transaction may have been posted directly to sales, placed in a suspense account, allocated to the wrong customer or left as an unallocated receipt.
That creates two problems at once. The bank balance may be correct, but the customer ledger is wrong. If the receipt was also coded as new income rather than matched to the invoice, turnover may be duplicated as well.
Our guide to good bookkeeping habits explains why customer receipts should be matched to the invoices they settle rather than treated automatically as new sales.
An aged debtors report can be wrong even when the bank reconciles
A reconciled bank account does not automatically prove that the sales ledger is correct. Bank reconciliation confirms that the accounting bank balance agrees with the external bank record. It does not prove that every customer receipt has been allocated to the right invoice.
A receipt can be present in both the bank statement and bookkeeping system, allowing the bank to reconcile perfectly, while the aged debtors report still shows the customer as unpaid.
That is why bank reconciliation and debtor reconciliation are complementary controls. The bank answers, “Did the cash arrive?” The customer ledger answers, “Which invoice did that cash settle?”
Unallocated customer receipts distort the aged debtors report
Accounting software may allow a receipt to sit on a customer account without being matched to a specific invoice. In that situation the customer could have a positive receipt and an overdue invoice at the same time.
The total customer balance may even be close to zero, but the aged debtors report can still look messy because old invoices remain open. Credit-control staff may then waste time investigating invoices that have effectively been paid.
Unallocated receipts should be reviewed regularly. The payment reference, remittance advice, invoice amount and customer correspondence can often identify the correct allocation. Where the payment covers several invoices, the receipt should be split across the invoices it actually settles.
Part-payments need to remain visible
Sometimes the report is not wrong. A customer may genuinely have paid only part of an invoice. If a £5,000 invoice receives a £3,000 payment, the remaining £2,000 should continue to appear as outstanding.
A good aged debtors report should make that remaining balance clear without making it look as though the entire original invoice is still unpaid. The bookkeeping record should show the original invoice, the payment received and the amount still due.
This becomes particularly important where the customer and business disagree about the remaining amount. The bookkeeping should record the financial position evidenced by the invoices, credit notes and receipts. Commercial or legal disputes should be handled separately rather than cleared through unsupported bookkeeping adjustments.
One payment may settle several invoices
Customers often make one bank transfer covering several invoices. If the remittance is not supplied, the amount may not match any single invoice exactly.
During an aged debtors report review, the bookkeeper should identify which invoices the payment relates to rather than allocating it to the oldest balance automatically without evidence. The customer may have withheld a disputed invoice, paid a specific project or deducted an agreed credit note.
Where the allocation is unclear, it is usually better to leave a visible query than to create a neat but unsupported customer ledger. A short request for remittance information can prevent a false overdue balance from being carried forward for months.
Credit notes are another reason an aged debtors report can look too high
A customer may have returned goods, received a pricing adjustment or agreed a reduction in the amount payable. If the business has issued a credit note but it has not been entered or allocated correctly, the aged debtors report may continue showing the original invoice value.
The correct bookkeeping should preserve the original invoice and the genuine credit note, then allocate the credit against the relevant customer balance. Simply editing an old paid invoice to make the report disappear can damage the audit trail.
The same principle applies to duplicated invoices. If an invoice was entered twice, the duplicate should be identified and corrected through an appropriate bookkeeping process rather than hidden by matching an unrelated payment to it.
Advance payments can make the aged debtors report confusing
A customer may pay before an invoice is raised. That money should not be forced against an unrelated invoice merely because the software shows an available receipt.
An advance payment can remain identifiable until the correct invoice is created and the receipt can be allocated properly. Depending on the circumstances and accounting setup, it may need to appear as money received in advance rather than ordinary debtor settlement.
This is another reason an aged debtors report needs to be read alongside customer receipts and other balance-sheet accounts. A clean-looking list is not the objective. The objective is a ledger that reflects what actually happened.
Payments allocated to the wrong customer create false overdue debts
Similar customer names, shared directors, group companies and unclear bank references can all lead to a receipt being allocated to the wrong account.
One customer then appears to owe money they have already paid, while another customer may appear to have a credit balance they do not recognise. The total debtors figure may still look plausible even though the individual accounts are wrong.
A monthly aged debtors report review should therefore look for unusual customer credits as well as old unpaid invoices. A credit balance can be a clue that a receipt has been posted to the wrong customer or that a credit note has not been matched correctly.
Old invoices need investigation, not automatic deletion
An invoice that has been sitting on the aged debtors report for nine or twelve months needs an explanation. It might be genuinely unpaid. It might have been settled through a payment that was never allocated. It might have been cancelled, duplicated, disputed or covered by a credit note that was never entered.
The Office of the Small Business Commissioner provides guidance for businesses dealing with genuinely unpaid invoices, including checking the original invoice, contract, payment terms and whether an error has delayed payment.
But bookkeeping should establish first whether there is actually a debt to chase. Sending a reminder for an invoice that was paid months ago damages the customer experience and usually reveals a bookkeeping problem rather than a credit-control problem.
An aged debtors report affects cash-flow decisions
Debtors are often treated as future cash. If the aged debtors report says £80,000 is outstanding, a business owner or finance adviser may reasonably want to know when that money is expected to arrive.
If £15,000 of the report actually consists of paid invoices, duplicates or unresolved historic balances, the report exaggerates future receipts. A cash-flow forecast built from it may assume cash is coming that has already arrived or will never arrive.
The UK government’s business guidance says day-to-day bookkeeping should help a business understand what it has, what it owes and what is owed to it. A credible debtor ledger is therefore useful for both record keeping and management decisions.
Credit control depends on a trustworthy aged debtors report
Credit control should begin from a report that has already been reconciled. Otherwise staff can spend time chasing customers who have paid while genuinely overdue balances receive less attention.
Before sending a batch of reminders, review receipts that have not been allocated, recent bank deposits, credit notes and disputed invoices. The aged debtors report should then give a more reliable list of customers who genuinely require follow-up.
Where an invoice is genuinely late, the commercial team can use the agreed payment terms and correspondence to decide what action to take. The bookkeeper’s role is to make sure the financial record is current, not to invent a collection status from an unreliable ledger.
VAT can matter when a debt is genuinely bad
For VAT-registered businesses using the relevant accounting basis, a genuinely unpaid debt may eventually have VAT consequences. HMRC’s VAT Notice 700/18 explains the conditions for VAT bad debt relief.
This is another reason an aged debtors report should distinguish genuinely unpaid invoices from bookkeeping errors. A paid invoice that remains open in the ledger is not a genuine bad debt simply because the report is old.
The detailed VAT treatment depends on the facts and the applicable scheme. Where bad debt relief or a historical VAT correction may be required, the business should obtain appropriate tax or VAT advice rather than making a bookkeeping adjustment solely from the age of the invoice.
How to review an aged debtors report each month
A short monthly routine can prevent small allocation errors from turning into a ledger containing years of unexplained balances.
- Run the aged debtors report to the month-end date. Use a consistent cut-off so changes can be compared with the previous period.
- Review recent customer receipts. Confirm that bank payments have been matched to the invoices they settle.
- Check unallocated receipts and customer credits. Investigate balances that may represent payments waiting for allocation.
- Review part-payments. Confirm that only the genuine remaining amount is shown as outstanding.
- Check credit notes. Make sure genuine credits have been entered and allocated to the correct customer or invoice.
- Investigate old balances. Do not assume every old invoice is a bad debt or every customer credit is valid.
- Compare with correspondence and remittances. Use evidence to resolve ambiguous allocations.
- Separate bookkeeping queries from collection issues. Only chase a debt after confirming that the ledger balance is genuine.
This keeps the aged debtors report useful for the owner, bookkeeper, accountant and anyone responsible for cash collection.
What an aged debtors report should look like at month end
A good report does not have to contain no old balances. Some customers genuinely pay on longer terms, some invoices may be disputed and some part-payments may remain outstanding.
The standard is that every material balance on the aged debtors report should be capable of explanation. The business should know which invoices are current, which are overdue, which are disputed, which have been partly paid and which entries are still being investigated.
Long-standing customer credits should also have an explanation. They may represent overpayments, advance receipts, misallocations or refunds due. Leaving them indefinitely can make the total receivables position harder to understand.
Why year-end is too late to clean the aged debtors report
Waiting until annual accounts are being prepared makes customer-ledger problems harder to resolve. Staff may no longer remember a payment reference, the person who dealt with the customer may have left, and remittance emails can be difficult to find.
Our guide to common bookkeeping mistakes explains how unresolved transactions become more difficult to correct as time passes. The same principle applies to an aged debtors report.
A monthly review keeps the questions recent. It also means the accountant receives a debtor figure that has already been examined rather than a list containing several years of balances that must be reconstructed before the accounts can be finalised.
The aged debtors report should agree with the wider bookkeeping
Customer balances should not be reviewed in isolation. The debtor control total should agree with the underlying customer ledger, the relevant bank receipts should be reconciled, and unusual sales or credit-note movements should be understood.
For an aged debtors report to support management information, the wider bookkeeping also needs to be current. Missing invoices understate debtors. Duplicate invoices overstate them. Misposted receipts leave invoices open. Incorrect opening balances can create old debts that never belonged to the current accounting period.
Our small business bookkeeping guide explains how customer balances sit alongside bank accounts, supplier liabilities, VAT, payroll and other regular records.
When an aged debtors report becomes a bookkeeping warning sign
A report containing a few genuine overdue invoices is normal. A report containing dozens of paid invoices, unexplained credits and balances several years old indicates that the bookkeeping process needs attention.
Other warning signs include the business maintaining a separate spreadsheet because nobody trusts the accounting software, staff checking the bank manually before every customer chase, or the accountant repeatedly asking for a debtors clean-up at year end.
At that point, the problem is bigger than one aged debtors report. The sales-ledger process needs to be reviewed from invoice creation through payment allocation, bank reconciliation and month-end reporting.
Keep the aged debtors report useful throughout the year
A reliable aged debtors report should answer a simple question: who genuinely owes the business money at this date?
If a customer has paid, the report should normally stop showing the invoice as unpaid once the receipt has been processed and allocated correctly. If money is still due, the remaining balance should be clear and supported by the underlying invoice, credit notes and payment history.
Regular bookkeeping services can keep invoices, customer receipts, reconciliations and debtor balances current. Where the owner no longer has time to maintain the process consistently, outsourced bookkeeping can provide a regular monthly routine.
If your customer ledger says people owe you money that you know has already been paid, you can contact Bookkeeping Packages Ltd to discuss the condition of the records and the bookkeeping work required to put them right.
About the Author
Stuart Kerr is Managing Director of Bookkeeping Packages Ltd, an outsourced bookkeeping service supporting UK small businesses and accountancy practices. With over 20 years of bookkeeping experience, Stuart specialises in helping businesses maintain reliable financial records and useful management information.
This article is provided for general information only. Stuart Kerr is a professional bookkeeper, not a regulated financial adviser. Nothing in this article constitutes tax, legal or financial advice. Advice specific to your circumstances should be obtained from an appropriately qualified professional.