What this page is for
Debtors ageing (ledger) lists what the books say every customer owes, and Creditors ageing lists what the books say you owe every supplier, each split by how overdue it is: Not yet due, 1–30 days, 31–60 days, 61–90 days and Over 90 days.
Both reports then check themselves two ways: against the control account — receivables for debtors, payables for creditors — and against the operational records — the customer accounts, or the supplier invoices and goods received but not yet invoiced — bucket by bucket. A notice at the top says whether all three agree.
Everyone whose role can view accounting sees these reports.
How to…
How to run the report
Set As at, then press Run report.
How to read a customer's or supplier's own lines
Press their name to open their Counterparty statement.
How to find a disagreement
Where the ageing does not match the control account, any posting with no customer or supplier on it is listed under Untagged, each linking to its journal entry. Where it does not match the operational records, each bucket's difference is listed under Against the operational records, with the documents behind it.
Worked examples
Supermarket
Tumaini Supermarket's debtors ageing shows a customer KES 8,000.00 overdue in the 31–60 days bucket. The accountant opens their Counterparty statement to see which invoice it is and calls to chase it.
Restaurant and bar
The Acacia Grill & Bar's creditors ageing does not agree with the payables control account: KES 2,400.00 sits Untagged, from a journal entry posted straight to the account without a supplier on it. The bookkeeper opens the entry, finds the mistake, and corrects it with a reversal.