Learn how to reconcile the AR subledger to the general ledger, find common discrepancies, and post adjusting entries with a monthly checklist.
Shyam Agarwal
Accounts receivable reconciliation is the process of confirming that the total of all open customer balances in the AR subledger equals the accounts receivable control account in the general ledger on the same date. When the two totals match, receivables are reported correctly. When they differ, each difference must be identified, explained, and corrected before the period closes.
AR reconciliation compares two records of the same receivables. The AR subledger lists every open invoice, payment, credit memo, and adjustment by customer. The general ledger holds a single accounts receivable control account that summarizes those transactions. In a correctly maintained system, both records show the same total at any point in time.
The subledger is the detailed record that collectors and AR staff work from. The control account is the summary figure that appears on the trial balance and the balance sheet. For a full explanation of how the subledger is structured, see our guide to the accounts receivable ledger.
The reconciliation answers one question: does the sum of every customer balance equal the GL balance on the same date? If it does, the reconciliation is complete after review. If it does not, the difference has to be explained item by item.
Accounts receivable reconciliation is important because it confirms that the receivable balance on the balance sheet is accurate and that the customer-level data used for collections is reliable. Without it, posting errors go undetected, aging reports become misleading, and the allowance for doubtful accounts may be calculated on incorrect balances.
Accounts receivable is often one of the largest current assets, so an unreconciled difference can materially misstate the balance sheet.
Collectors who work from an incorrect subledger contact customers who have already paid and miss customers who have not.
The allowance for doubtful accounts is usually calculated from the aging report, so an inaccurate aging produces an inaccurate allowance.
Auditors test receivables by tying the aging to the general ledger, and a documented monthly reconciliation shortens that testing.
Errors found within the month are easier to trace because the source documents are recent.
Accounts receivable should be reconciled at least monthly, as part of the month-end close. Companies with high invoice and payment volumes often add a weekly check that compares the aging report total to the GL balance. Year-end reconciliations require more detailed review because they support the audited financial statements.
A weekly total-to-total check does not replace the full monthly reconciliation. It catches new differences early so the month-end reconciliation has fewer items to investigate.
To reconcile accounts receivable, compare the AR aging report total to the general ledger control account balance as of the same date, identify every item that explains the difference, post correcting entries in the record where each error occurred, and document the result for review. The process has seven steps.
Confirm that all invoices, receipts, and credit memos dated on or before the period end are posted in both records.
Pull the aging summary as of the cutoff date. Its grand total is the subledger balance. The AR aging report is the standard source because it lists every open item by customer.
Run the trial balance or account detail for each accounts receivable control account as of the same date.
Subtract the GL balance from the aging total. A zero difference means the totals agree.
Compare the period's activity in both records to find the transactions that explain the difference.
Correct each error in the record where it was made. For standard entry formats, see accounts receivable journal entries.
Record both balances, each reconciling item, its cause, the correction, the preparer, and the reviewer.
The most common causes of AR reconciliation differences are manual journal entries posted directly to the GL control account, unapplied cash, timing differences between the subledger and general ledger, payments applied to the wrong customer, and write-offs or credit memos recorded in only one of the two records.
A journal entry posted directly to the GL accounts receivable account has no customer-level detail, so the GL changes while the subledger does not. Restricting direct posting to the control account prevents most of these differences.
A payment recorded in cash and the general ledger but not matched to invoices leaves those invoices open in the subledger. This is the most frequent cause of differences in high-volume B2B environments. Our guide to unapplied cash explains how these balances build up and how to clear them.
A transaction dated in one period in the subledger and in the next period in the general ledger creates a temporary difference that reverses the following month.
A payment applied to the wrong customer or invoice keeps the total correct but distorts individual balances. It is found when customers question their statements or during account reviews.
A write-off or credit memo posted in the general ledger but not in the subledger, or the reverse, creates a direct difference between the two totals.
When an ERP and a separate AR system exchange data, a failed or partial import can leave the two records out of step until the sync is rerun.
At month end, the aging report shows $1,248,500 and the GL control account shows $1,236,200, a difference of $12,300. Investigation finds two items.
First, a $9,800 customer payment was recorded in the general ledger but not applied to the two invoices it paid, so the subledger still shows them as open. Second, a $2,500 invoice was written off in the general ledger but left open in the subledger. Correcting both items in the subledger reduces the aging total by $12,300 to $1,236,200, which matches the general ledger.
| Item | Amount |
|---|---|
| Aging total | $1,248,500 |
| Less: payment recorded in GL, not applied in subledger | ($9,800) |
| Less: write-off posted in GL, invoice still open | ($2,500) |
| Adjusted subledger balance, equal to GL | $1,236,200 |
Year-end AR reconciliation follows the same method as the monthly process but applies deeper review, because it supports the audited balance sheet. In addition to matching totals, finance teams re-estimate the allowance for doubtful accounts, test sales and receipts around the year-end cutoff, review credit balances, and prepare support for auditor requests such as customer confirmations.
Year-end work is faster when every monthly reconciliation in the year was completed and approved. Reconciling items carried forward for several months are typically the first items auditors question.
When a company records receivables in more than one GL account, each control account should be reconciled to its own subledger detail rather than only in total. Common separate accounts include trade receivables, other receivables, retainage receivable, unbilled receivables, and unapplied cash.
Reconciling only the combined total can hide offsetting errors, where one account is overstated and another understated by the same amount. Reconcile each account separately, then confirm the combined total.
Auditors testing accounts receivable typically request the aging report as of the balance sheet date tied to the general ledger, the reconciliation with support for each reconciling item, the monthly reconciliations for the year with preparer and reviewer sign-off, and the calculation of the allowance for doubtful accounts.
They also commonly request lists of write-offs and credit memos with approvals, invoices and delivery documents for a sample of open balances, and evidence of cash received after year end against year-end balances. Preparing these items during the year reduces audit fieldwork and follow-up requests.
AR reconciliation becomes faster when fewer differences are created in the first place. The most effective controls are restricting manual posting to the AR control account, applying customer payments to invoices daily, and keeping collections, credit, and finance on a single source of receivables data.
Daily cash application has the largest effect, because unapplied cash is the most common reconciling item. Automated cash application matches incoming payments and remittances to open invoices as they arrive, so fewer items remain unapplied at month end.
Visibility between closes also helps. An accounts receivable dashboard shows aging totals and balance movements as they change, so unusual differences can be investigated before the month ends.
A weak AR reconciliation process shows the same reconciling items month after month, takes days rather than hours to complete, moves unexplained differences into a suspense account, or lacks documented review. Growing unapplied cash and collectors contacting customers who have already paid are also signs that the subledger is not being kept accurate.
These symptoms usually point to an upstream process problem in cash application, manual GL postings, or data synchronization between systems, rather than to the reconciliation step itself.
40%
DSO reduction70%
less manual work95%
cash match accuracyFind out exactly how much time and money your AR team can save with Quick Receivable. No commitment, no setup required.
AI-powered Accounts Receivable Automation on Salesforce, built to accelerate collections, automate workflows, and improve cash flow.