What aged receivables and payables quietly confess

By Peter Edwards ACMA CGMA · Chartered Management Accountant in practice

The aged listings are the most underrated documents in a pre-engagement review. A trial balance tells you the shape of the books; the aged receivables and payables tell you how the business actually behaves — whether money is collected, whether allocation happens, whether the numbers in "debtors" and "creditors" are live balances or archaeology. Four patterns do most of the confessing.

1. Customers in credit

A customer showing a negative balance on the receivables listing is a customer the business apparently owes money to — which occasionally is true (a genuine overpayment or deposit), but far more often means receipts that were never allocated to their invoices, or credit notes raised against nothing. Each one is allocation work; in aggregate they can also mean income has been double-counted — invoiced once and then recognised again when the unmatched receipt was coded to sales. Count the credit balances: it's a direct measure of how much matching discipline exists.

2. The oldest bracket carrying the weight

A healthy debtor book is front-loaded: most of the value sits in current and 30 days. When the largest share sits in the 90-days-plus column, one of three things is true — collection has stalled, the balances are disputed and nobody is resolving them, or they're simply dead: uncollectable amounts awaiting a write-off nobody wants to propose. All three matter to scope. Stalled collection is a process to build; disputes are conversations to have; dead balances are a P&L hit the owner hasn't been told about yet — and being the one to say so is part of the engagement.

3. One supplier dominating the creditors

When a single name accounts for an outsized slice of trade creditors, read it twice. Sometimes it's genuinely the key supplier. Frequently it's a related party — the director's other company, a family business, a landlord who happens to share a surname — filed among ordinary trade creditors where it doesn't belong. Related-party balances need showing as what they are; buried in trade creditors they distort every ratio a lender or successor accountant will compute, and they hide the inter-company tangle that usually accompanies them (see the director's loan guide — these travel together).

4. Suppliers in debit

The mirror of pattern one: a supplier the listing says owes the business money. Real cases exist — deposits paid, credit notes awaited — but persistent debit balances usually mean payments posted twice, payments matched to the wrong supplier, or bills that were paid but never entered. Each is a small unwinding job; a listing scattered with them is a purchase-ledger process that isn't being reconciled to statements at all.

Using the listings in scope and price

The beauty of aged-listing findings is that they arrive pre-counted: the number of customers in credit, the value in the oldest bracket, the debit balances — the listing itself quantifies the work. Fold them into the quote as per-item allocation work, a defined collections-process build, and a named conversation about write-offs. And put the listing's date in the engagement letter: these files move, and the count you priced from should be anchored in time.

Related: How to review a client's Xero books before you quote · The director's loan account: three problems wearing one name