Ledger Reconciliation

Accounts Receivable Dictionary

What is ledger reconciliation?

Ledger reconciliation is the process of checking that the detail in a subsidiary ledger agrees with the control account that summarises it in the general ledger, then explaining or fixing any difference. In accounts receivable, that means the sum of every open customer balance in the sales ledger should equal the single accounts receivable figure in the general ledger. When the two tie out, your detailed records and your headline number tell the same story.

It matters because those two sets of records are kept differently and drift apart easily. The sales ledger is built customer by customer, invoice by invoice; the control account is fed by journals and postings. A miskeyed payment, an unallocated receipt or a duplicated invoice can knock them out of line, and until you reconcile, you cannot trust either figure. Ledger reconciliation is the routine control that keeps the books honest and makes month-end something other than a guess.

Key takeaways

Detail equals control.The sum of the sub-ledger should match its control account in the general ledger.

Not the same as a bank rec.A bank rec ties cash to the bank; this ties a ledger to its own control total.

It is about allocation.Most AR differences are unallocated cash and credit notes, not lost money.

How ledger reconciliation works

You take the total of the subsidiary ledger, compare it to the balance in the matching control account, and investigate the gap line by line until every difference is accounted for. The two should be equal by design, because the control account is meant to be a running summary of the same transactions held in detail in the sub-ledger. When they disagree, the cause is almost always a transaction that hit one record but not the other, or hit one of them twice. The job is to find each one and decide whether it is a timing item that will clear or an error that needs a journal.

The work follows the same repeatable steps each period.

1
Total the subsidiary ledger

Add up every open balance in the sub-ledger, for example the aged debtors list, as at the reconciliation date.

2
Read the control account balance

Take the matching control account figure from the general ledger at the same date.

3
Compare and measure the difference

Subtract one from the other. A nil difference means the ledger reconciles and you are done.

4
Trace each reconciling item

Hunt down what makes up the gap: unallocated receipts, missing invoices, duplicate postings, unapplied credit notes.

5
Correct with journals or allocations

Allocate stray cash, apply credit notes, and post journals to fix genuine errors so both records agree.

6
Document and sign off

Record the reconciled position and the items cleared, leaving an audit trail for review and close.

The skill is in step four. A reconciled ledger is not one with a zero difference by luck, it is one where every difference is named and understood. A worked example shows the shape of it: your sales ledger totals 243,500 but the AR control account reads 248,000, a 4,500 gap. Pull it apart and you find a 6,000 customer payment received and banked but never allocated to its invoices, set against a 1,500 credit note posted to the control account but not yet applied in the ledger. Neither is missing money; both are allocation timing. Once you apply them, the ledger ties to the penny. Clean AR reporting is what makes step one trustworthy in the first place.

Ledger reconciliation vs bank reconciliation

Bank reconciliation matches your cash book to the bank statement; ledger reconciliation matches a subsidiary ledger to its own control account inside the books. They check different things. A bank rec proves the cash you think you have agrees with what the bank says you have, using an external source. Ledger reconciliation is internal: it proves your detailed records and your summary records agree with each other, with no outside party involved. You can have a perfect bank rec and still have a sales ledger that does not tie to its control account, because the two tests look at completely different relationships.

Why the source of truth matters

The confusion is common because both are called reconciliations and both hunt for differences, but the source of truth differs. In a bank rec, the bank statement is the reference point. In ledger reconciliation, neither side is automatically right; you are checking two internal records against each other and correcting whichever is wrong. This is also what sets it apart from account reconciliation in general, which simply means reconciling any one account to appropriate support. Ledger reconciliation is the specific case of tying a sub-ledger to its control total, and it is one building block of the wider balance sheet reconciliation done at period end.

AspectLedger reconciliationBank reconciliation
What it comparesSub-ledger total vs its control accountCash book vs bank statement
Source of truthNeither, both are internal recordsThe bank statement, an external source
Typical differencesUnallocated cash, credit notes, duplicatesDeposits in transit, unpresented cheques
What it provesDetail and summary agreeRecorded cash matches the bank

Common ledger reconciliation differences

For receivables, the gap between the sales ledger and the control account is almost always made up of a handful of recurring items rather than one missing number. Each one is small on its own, which is exactly why they accumulate quietly until a reconciliation surfaces them. These are the usual suspects to look for first.

Unallocated paymentsCash received and banked but never matched to the invoices it was meant to clear.

Unapplied credit notesA credit note raised in one record but not yet applied in the other.

Duplicate invoicesThe same invoice posted twice, inflating one record against the other.

Top-side journalsEntries taken straight to the control account with no matching posting in the customer ledger.

The danger is a difference that looks tiny. A 40 gap is rarely a 40 error; far more often it is a 5,000 error and a 4,960 error pointing in opposite directions and nearly cancelling out. That is why a difference of any size should be explained rather than written off as immaterial, and why posting a top-side journal to force the two figures to agree is the worst possible fix: it hides the cause while making the schedule look clean. The reliable cure is upstream. When cash is matched to invoices as it arrives and credit notes are applied promptly, the reconciling items mostly disappear, which is where AR automation earns its place by keeping the sub-ledger and the control account in step day to day rather than once a month.

How often to reconcile, and how to make it easy

Reconcile high-volume ledgers like receivables monthly at a minimum, and ideally keep them in step continuously, because small frequent checks beat one large year-end scramble every time. The longer a ledger goes unreconciled, the more items accumulate and the harder each one is to trace, since the supporting detail fades from memory and the trail goes cold. A business reconciling once a year is not really controlling its ledgers, it is auditing them after the fact and hoping nothing material has slipped.

Three habits make it painless. Build them into the way receivables are run and the monthly reconciliation becomes a quick confirmation rather than an investigation.

Habits that keep ledgers in step

Allocate cash as it arrivesMatch receipts to invoices on the day, so unallocated cash, the most common difference, never builds up.

Apply credit notes immediatelyApply each credit note the moment it is raised, in both the ledger and against the customer.

Never plug a gap with a journalTrace a stubborn difference instead, because a balancing journal hides the real error and guarantees it returns next month.

Frequently asked questions
What is ledger reconciliation?
Ledger reconciliation is the process of checking that the detail in a subsidiary ledger agrees with the control account that summarises it in the general ledger, then explaining or fixing any difference. In accounts receivable, the total of all customer balances should equal the accounts receivable control figure.
How do you reconcile a ledger?
Total the subsidiary ledger, read the matching control account balance at the same date, and compare the two. Trace any difference to its cause, such as unallocated cash or unapplied credit notes, then post journals or allocations to fix genuine errors. Document the reconciled position and sign it off.
What is the difference between ledger reconciliation and bank reconciliation?
Bank reconciliation matches your cash book to the bank statement, using an external source. Ledger reconciliation matches a subsidiary ledger to its own control account inside the books, an internal check. You can pass a bank rec and still fail to tie the sales ledger to its control account.
What causes a ledger to not reconcile?
The usual causes are payments received but not allocated to invoices, credit notes applied in one record but not the other, invoices posted twice, and journals taken to the control account with no matching customer ledger entry. Most are allocation timing rather than missing money.
How often should you reconcile ledgers?
Most businesses reconcile key ledgers monthly as part of close, with high-volume accounts like receivables reconciled more often. Frequent reconciliation keeps differences small and easy to trace, whereas leaving it until year-end lets twelve months of small items pile up.
Keep reading

Are you making these
5 invoicing mistakes?

Don't let these critical mistakes hurt your
collections - See how to fix them, today!