Accounts Receivable Reconciliation: A Monthly Checklist

Published Updated By California Recoveries Editorial

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.

RecordWhat it should proveTypical exception
General ledgerThe financial-statement receivable balanceA journal entry posted without customer detail
Customer subledgerThe invoices, credits, and payments making up each balanceA transaction assigned to the wrong customer
Aging reportHow long open items have remained unpaidWrong invoice date or due date
Bank and cash receiptsWhich payments cleared and were postedUnapplied or unidentified cash
Credit and adjustment logWhy balances were reduced or changedApproved credit not posted
Dispute logWhich balances are genuinely contestedDispute 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

LineAmountEvidence
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$0Reviewer sign-off and date
Keep the evidence together. The reconciliation, reports, exception list, correcting entries, and reviewer sign-off should form one period-end package. That makes the process repeatable and lets another person reproduce the result.

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.