The short answer: accounts receivable reconciliation is the monthly process of proving that the receivables control account, customer balances, aging report, cash receipts, credits, and dispute records agree. The output should be more than a balanced number: every exception needs an owner and a dated next action.
Aging reports can look precise while hiding unapplied cash, duplicate invoices, stale credits, or balances assigned to the wrong customer. Reconciliation separates an accounting problem from a collection problem. That distinction prevents unnecessary reminders and makes the aging report reliable enough to drive decisions.
What should reconcile each month?
Start with the same period-end date across every report. Then compare the accounts receivable general-ledger control balance with the total of the customer-level subledger or aging report. California's State Administrative Manual requires monthly aging and reconciliation for state agencies. It is a useful example of the control, not a legal requirement imposed by that manual on private businesses.
| Record | What it should prove | Typical exception |
|---|---|---|
| General ledger | The financial-statement receivable balance | A journal entry posted without customer detail |
| Customer subledger | The invoices, credits, and payments making up each balance | A transaction assigned to the wrong customer |
| Aging report | How long open items have remained unpaid | Wrong invoice date or due date |
| Bank and cash receipts | Which payments cleared and were posted | Unapplied or unidentified cash |
| Credit and adjustment log | Why balances were reduced or changed | Approved credit not posted |
| Dispute log | Which balances are genuinely contested | Dispute resolved operationally but left open in AR |
Worked example: the ledger and aging report disagree
Assume the period-end general ledger shows $52,400 in receivables while the customer aging report totals $50,900. The $1,500 gap is not proof that a customer owes another $1,500. First confirm that both reports use the same cutoff date and include the same receivable accounts. Then inspect manual journal entries, unposted invoices, credits, and cash receipts around the close.
Suppose a $1,500 debit was posted directly to the control account without customer detail. Record the journal entry as the reconciling item and determine whether it belongs to a specific invoice, another account, or a correcting entry. Assign an owner and approval date before making the correction. Only after the records agree should the team use the aging report to select customers for follow-up.
A printable aging action-plan template can track the resulting exceptions and owners; the aging report guide explains how to prioritize verified balances.
The monthly AR reconciliation checklist
1. Freeze the reporting date
Run the general ledger, customer detail, and aging report for the same close date. Save the reports used. A report rerun after backdated activity may no longer support the reconciliation you signed.
2. Tie the subledger to the control account
Compare the total open customer balances with the general-ledger receivables balance. If they differ, list the variance before investigating it. Common causes include manual journal entries, interface timing, transactions posted to the wrong account, and reports using different cutoff dates.
3. Reconcile cash receipts
Match deposited payments to customer accounts and invoices. Put unidentified receipts in a visible exception list rather than allowing them to age indefinitely in an unapplied-cash account. Contact the payer for remittance details when needed.
4. Review credits and adjustments
Confirm that approved returns, pricing corrections, write-offs, and credit memos were posted to the correct account and period. Require a reason and approver for each manual adjustment. A credit still waiting in an inbox can make a valid customer appear delinquent.
5. Test the aging
Scan for negative balances, invoices with impossible dates, old credits, and sharp movements between buckets. Verify that aging is based on the agreed due date rather than a mixture of invoice date and due date. Our aging report guide explains how to turn the corrected report into priorities.
6. Separate disputes from silence
Mark genuinely disputed items and record the reason, evidence requested, owner, and promised response date. Do not let a dispute label become a permanent parking place. If the issue was resolved, update the invoice, credit, or collection status immediately.
7. Review subsequent receipts
Look at payments received shortly after month-end. A subsequent payment can confirm the balance existed and was collectible at the reporting date, while also preventing an unnecessary reminder after the close.
8. Assign every material exception
For each unresolved item, record the owner, next action, and deadline. “Researching” is not a complete status. A useful note says what is being checked, by whom, and when the result is due.
A compact reconciliation worksheet
| Line | Amount | Evidence |
|---|---|---|
| AR general-ledger balance | $_____ | Period-end trial balance |
| Customer subledger total | $_____ | Saved customer-detail report |
| Difference to investigate | $_____ | Reconciliation schedule |
| Unapplied cash included | $_____ | Deposit and remittance records |
| Approved unposted credits | $_____ | Credit approval log |
| Resolved difference | $0 | Reviewer sign-off and date |
Controls that keep the reconciliation useful
- Separate preparation and review. When staffing allows, the person reviewing should not be the only person posting receipts and adjustments.
- Use a materiality rule. Define which variances require immediate correction and which can remain on a documented exception list.
- Track recurring causes. If missing purchase-order numbers repeatedly delay payment, fix invoice creation instead of treating every delay as a new collection problem.
- Close the loop. Feed verified overdue balances into the written collection process, with owners and escalation dates.
What “done” looks like
The month is not reconciled merely because the difference was forced to zero. It is complete when the totals agree, reconciling items are supported, corrections are posted or scheduled, disputed items have owners, and the final aging report contains only real open balances. That clean report is the foundation for measuring DSO, prioritizing follow-up, and making defensible escalation decisions.
Editorial review
How this page was prepared
This guide answers a defined operational question, separates general process guidance from legal advice, and links to 2 relevant primary or authoritative sources for verification.
Examples are illustrative, not reported customer outcomes. Advertising does not control our conclusions. Read our editorial and correction standards.