Receivables are one of the easiest balances to overstate, and one of the first an auditor will test.
An accounts receivable reconciliation agrees the aged debtors total to the receivables control account in the general ledger at month end. Explain any difference, then review unapplied cash, customer credit balances and old items, and check that the bad debt provision is based on the same aged report. The unexplained difference must be zero before sign-off.
Run the aged debtors (aged receivables) report and the general ledger receivables balance at the same cut-off. They should agree. If they don't, the usual culprits are manual journals to the control account, cash posted to the ledger but not applied in the subledger, and revaluation of foreign currency balances.
Export receipts not yet allocated, with customer, date and amount. Match them against open invoices for the same customer and amount:
=COUNTIFS(Open!Customer,A2,Open!Amount,C2)
A result of one is usually a straightforward allocation. Zero or more than one needs a remittance advice or a call to the customer.
Credit balances are not "negative debtors" to net off. They are amounts you owe the customer. Large or old ones can be a sign of duplicate receipts, misapplied cash or a customer paying an invoice you already credited. Clear them every month.
The reconciliation proves the balance is complete. Credit control proves it is collectable. Use the same aged report for both, so the conversation with the sales team and the provision calculation start from the same numbers. See the credit control process and the expected credit loss provision matrix.
The receivables team prepares the reconciliation and clears unapplied cash. Credit control owns the old and disputed items. The controller reviews the reconciliation and the provision together. Keeping these roles separate means nobody can quietly write off an item they were supposed to collect, and the person posting cash isn't the only one checking it.
UK teams usually say "sales ledger" and "debtors control account"; US teams say "accounts receivable subledger". The steps don't change.
Applies the payments your customers make to the invoices they are paying, including part-payments and one payment for several invoices, and shows what is still owed. Runs in your browser on your own computer: nothing is uploaded.
Work out DSO and the cash tied up in late payers. Free to use online.
The Credit Control & Receivables System calculates ageing, DSO, best-possible DSO and CEI from the ledger, shapes a bad debt provision to IFRS 9 / ASC 326 logic and requires independent approval for credit limits and write-offs. Excel, no macros, one-time price.
Someone independent of cash posting and credit control, usually a senior accountant or the controller, who checks the evidence for each reconciling item.
Most often because of manual journals to the control account, cash posted in the ledger but not applied to customer accounts, or currency revaluation on one side only.
Not without investigating them. They are liabilities to the customer and often signal duplicate receipts or misapplied cash.
Unapplied cash and unreconciled items distort DSO. A clean reconciliation makes the DSO figure trustworthy.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.