Accounts Receivable Reconciliation: How to Do It Right
Academy · · 9 min read · Ledgerler Content Team
Accounts receivable reconciliation is the monthly proof that the total in your customer invoicing system actually matches the receivable balance sitting on your balance sheet. Skip it for a few months and small gaps — an unapplied payment here, a write-off posted only one side there — quietly stack up until nobody can say with confidence what customers really owe. Done properly, tying the two together takes under an hour a month for most small businesses. Here is the process, step by step, with a full worked example.
Key takeaways
- AR reconciliation compares the AR subledger (every open invoice) to the AR control account in the general ledger — they should always be the same number.
- Most gaps trace back to three causes: unapplied cash, credit memos or write-offs posted on only one side, and invoices dated right at period cutoff.
- The aging report is the working document — pull it as of the last day of the period and total it before you compare anything.
- Make it a fixed line item in month-end close, not an occasional catch-up exercise.
What accounts receivable reconciliation actually checks
Every business running any kind of invoicing keeps two records of what customers owe. The first is the AR subledger: the detailed list of every open invoice, credit memo and payment, by customer, usually living inside your invoicing or accounting software. The second is the AR control account: a single summary balance sitting in the general ledger, which is what actually appears on your balance sheet. A subledger holds the transaction-level detail behind a single control account in the general ledger, and reconciling the two means confirming that the subledger detail still sums to the control-account balance. In a healthy system these two numbers are always identical, because every posting that touches one is supposed to touch the other. Reconciliation is the routine check that this held true.
What you need before you start
Pull two things dated to the same day, ideally the last calendar day of the period: the AR aging report from your subledger, and the trial balance or GL detail showing the AR control account. Print the aged accounts receivable report as of the final day of the period, since the totals on it are what get compared to the receivable total in the general ledger (AccountingTools). If you also have a list of cash receipts and credit memos posted during the period, keep it on hand — most variances get explained by something on one of those two lists.
The reconciliation process, step by step
Step 1: Total the AR aging report
Run the aging report as of period end and total every open invoice across all customers. This report typically buckets invoices into 0-30, 31-60, 61-90 and over-90-day bands, and its grand total across all bands is the figure you are reconciling.
Step 2: Pull the GL control account balance
Take the closing balance of the AR control account from the general ledger for the same date. If your accounting system posts invoices and payments automatically to both the subledger and the GL, these two numbers should already agree; the reconciliation exists to catch the cases where something broke that link.
Step 3: Compare the two totals
If they match exactly, document that and move on — a clean reconciliation is still worth a dated record, since it is your evidence for anyone asking later. If they do not match, the difference tells you roughly where to look. A small, round-number gap often points to a single missed journal entry; a larger or oddly specific figure usually means several smaller items are stacking up.
Step 4: Investigate the variance
Work through the usual suspects in order, since most gaps come from one of these:
- Unapplied cash. A customer payment has been received and deposited, so it hit the bank and the GL, but nobody has matched it to a specific invoice in the subledger yet. It often sits in a suspense or unapplied-cash account, reducing the GL balance without reducing any single invoice in the aging report.
- Credit memos and write-offs posted on one side only. Someone journals a write-off directly against the GL control account to clear a bad debt, but the corresponding invoice is never closed out in the subledger, so it keeps showing up on the aging report as if it were still collectable.
- Cutoff timing. An invoice raised in the subledger on the last day of the month has not yet posted to the GL, or vice versa, because of a batch job or an integration that runs on a lag.
- Direct journal entries to the control account. Someone adjusts the AR control account with a manual journal entry — for a currency revaluation, say — without a matching change anywhere in the subledger.
Step 5: Post adjusting entries and document
Once you know the cause, fix the side that is wrong rather than forcing a match by adjusting whichever number is more convenient. Apply the unapplied cash to the right invoice, close out the write-off in the subledger to match the GL, or correct the cutoff posting. Keep a short written note of what caused the variance and how it was resolved; that note is what turns a one-off fix into an audit trail.
Worked example
A small B2B distributor closes June with an AR aging report totalling $184,320.00 across all customers, but the AR control account in the general ledger shows $186,750.00 — a gap of $2,430.00.
| Item | Where it sat | Amount |
|---|---|---|
| Credit memo for returned goods (Customer: Norrell Fabrication) | Posted to GL only, not yet applied in subledger | $1,800.00 |
| Customer payment received 6/29, not yet matched to an invoice | Sitting in unapplied-cash suspense account | $630.00 |
| Total variance explained | — | $2,430.00 |
Worked example: tracing a $2,430.00 gap between the AR subledger and the GL control account.
Both figures land on $186,750.00 once the credit memo is applied in the subledger and the $630.00 payment is matched to the right invoice. Neither item was a real error — the GL had recorded both correctly — but the subledger detail had fallen out of step, which is exactly what this reconciliation exists to catch before a customer gets chased for an invoice that was already credited.
Why unapplied cash is the usual suspect
Handling write-offs and credit memos without breaking the tie-out
The safest habit is to make every write-off and every credit memo a subledger transaction first, one that then flows through to the GL, rather than a direct GL journal entry that has to be remembered and mirrored manually. If your accounting system does not support that cleanly, keep a running log of any direct-to-GL AR entries during the month, and check that log specifically during the reconciliation rather than hoping it surfaces on its own.
Reconciliation and collections are not the same job, but they share a report
It is worth separating two things that use the same aging report but ask different questions. Reconciliation asks whether the subledger total matches the GL. Collections review asks whether the invoices sitting in the 61-90 and over-90 buckets are still realistically collectable, or whether they need a bad-debt reserve. Aging reports are the primary tool for generating uncollectible-account estimates at a point in time, alongside the reconciliation function (Journal of Accountancy, March 2025). As Kelly L. Williams, CPA, Ph.D., an accounting professor at Middle Tennessee State University, puts it in that same piece, aging analysis "is an essential tool for managing receivables and maintaining healthy cash flow" (Journal of Accountancy). Do both reviews from the same report at close, but keep the two conclusions — does it tie out, and is it collectable — clearly separate in your notes.
A monthly cadence that actually holds
Days sales outstanding is a useful health check to run alongside the reconciliation itself. The Hackett Group's 2025 US Working Capital Survey, covering the top 1,000 publicly traded non-financial companies, found receivables performance actually worsened slightly even as payables improved, leaving over a trillion dollars trapped in excess working capital across the group (Hackett Group, 2025). That is a reminder that AR does not fix itself just because the rest of the close looks tidy; it needs its own scheduled step.
A composite example: a 12-person marketing agency used to reconcile AR only at year end, when its accountant needed clean numbers for the tax return. By August each year, the aging report was carrying two invoices from a client who had gone quiet in March, both already written off in the GL by the bookkeeper without telling anyone in sales — so the account manager kept including them in the client's outstanding balance on client calls. Moving to a monthly reconciliation, tied to the same date as the month-end close checklist, meant the write-off surfaced within four weeks instead of five months, and stopped an awkward conversation with a client who thought they still owed money they did not.
Where this fits in your wider close
AR reconciliation is one of several control accounts worth checking every period, alongside cash, AP and payroll — see our overview of types of account reconciliation for how they fit together, and our payroll reconciliation guide and three-way match explainer if AP is your next gap to close. If unapplied cash or write-off tracking is the recurring problem, our guide to speeding up month-end close covers how to build a repeatable checklist around it, and the reconciliation template library has a ready-made AR tie-out template you can start from this month.
FAQs
How do I reconcile accounts receivable to the general ledger?
Print the AR aging report as of the last day of the period, total it, and compare that total to the balance in the AR control account in the general ledger. If the two figures match, you are done. If they do not, work through likely causes in order: unapplied cash sitting in a suspense account, credit memos or write-offs posted in one system but not the other, and invoices dated right at period end. Post an adjusting entry for anything that turns out to be a real timing or coding difference, and document what you found.
What is the difference between the AR subledger and the AR control account?
The AR subledger is the detailed record: every open invoice, by customer, with its own due date and balance. The AR control account is the single summary figure for total receivables that sits in the general ledger. In a working system, the subledger total and the control account balance are always the same number — reconciliation is simply the routine proof that they still agree.
What is an accounts receivable aging report used for in reconciliation?
The aging report groups every open customer invoice into time bands, typically 0-30, 31-60, 61-90 and over 90 days past due. Its grand total is what you compare against the GL control account balance. It also does double duty as your collections tool, since invoices ageing into the 61-90 and 90+ bands are the ones most likely to need a write-off or a credit-loss reserve.
How often should accounts receivable be reconciled?
Monthly, as a fixed step in month-end close, is the standard cadence for most small and mid-sized businesses, and it should happen for every period the books are closed, not only at year end. Higher-volume businesses, or ones running multiple AR systems that feed one GL, often reconcile weekly to keep the exception list small enough to actually investigate.
What causes accounts receivable to be out of balance with the general ledger?
The most common causes are unapplied cash (a customer payment received and deposited, but not yet matched to a specific invoice in the subledger), a credit memo or write-off posted directly in the GL without a matching entry in the AR system, invoices raised in the subledger after the GL cutoff, and manual journal entries to the AR control account that bypass the subledger entirely.
Reconciling AR monthly is a small, fixed cost that prevents a much larger one: chasing customers for money they do not owe, or missing that money they do owe has quietly gone stale. See our pricing if you are ready to bring AR, bank and payroll reconciliation into one repeatable monthly routine.