If the AP subledger and the ledger control account disagree, one of them is wrong, and the auditors will want to know which.
An accounts payable reconciliation compares the total of open supplier balances in the subledger with the AP control account in the general ledger at the same date. The difference should be zero. If it isn't, look for manual journals posted directly to the control account, timing differences in the posting run, and unposted or deleted transactions.
In most systems the subledger posts to the control account automatically, so they should agree to the cent. Differences point to something that bypassed the normal flow.
| Line | Item |
|---|---|
| 1 | Balance per general ledger control account |
| 2 | Balance per AP subledger (aged payables total) |
| 3 | Difference (line 1 minus line 2) |
| 4 | Explained items, listed one per row with evidence reference |
| 5 | Unexplained difference (line 3 minus total of line 4): must be zero to sign off |
Make line 5 the gate: if it isn't zero, the reconciliation isn't finished, whatever the date.
A subledger that agrees to the ledger can still be wrong supplier by supplier. Once a month, reconcile your largest suppliers' statements to their subledger balances. See supplier statement reconciliation for the method.
The preparer should be someone close to the payables process. The reviewer should be independent of it: a senior accountant or the controller. The reviewer checks the evidence for each reconciling item, not just the total, and challenges any item that has appeared before. A reconciliation that is prepared but never reviewed is only half a control.
UK teams usually say "purchase ledger" and "creditors control account". US teams say "accounts payable subledger" and "AP control account". The reconciliation is identical.
Supplier statement to AP ledger. Finds invoices you haven't posted, credit notes still to come, price differences, duplicate postings and payments in transit, and builds the supplier reconciliation. Runs in your browser on your own computer: nothing is uploaded.
Paste your invoice list and see likely duplicates in minutes. Free Excel file: enter your work email to download it.
The Accounts Payable Control System runs four duplicate-invoice tests, supplier master fraud checks and a three-way match on every invoice, with a payment run release gate that blocks release while exceptions are open. Excel, no macros, one-time price.
Every month, as part of the month-end close. Waiting until year end turns small timing differences into a hunt through twelve months of journals.
As a rule, no. Lock the control account against manual journals if your system allows it, and log any exception with approval.
You have paid or credited more than you owe. It is often a duplicate payment, an unmatched credit note or a payment on account. Investigate it rather than leaving it to net off.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.