Accounts Receivable Reconciliation: Process, Steps and Example

Accounts receivable reconciliation is the process of confirming that the total on your AR ledger matches the sum of every open customer invoice in your subsidiary detail, and that both agree with the cash you have actually received. You do it by comparing the AR control account balance in your general ledger against the aging report, then investigating any difference invoice by invoice until the two tie out. Done monthly, it catches misapplied payments, duplicate invoices, unrecorded credit memos and posting errors before they become a wrong balance sheet or an uncollectible surprise.

Most finance teams treat reconciliation as a month-end chore that either balances on the first try or eats an afternoon. The afternoons are the point. A reconciliation that never turns up a difference is usually one nobody is really checking, and the differences it should be catching are exactly the ones that quietly overstate what you are owed.

What is accounts receivable reconciliation?

Accounts receivable reconciliation verifies that three numbers agree: the accounts receivable balance in your general ledger, the total of open invoices in your AR subledger or aging report, and the cash you have collected against those invoices. When all three line up, your reported receivables are trustworthy. When they do not, something has been posted, matched or credited incorrectly, and the gap tells you where to look.

The general ledger holds a single AR control account: one summarized balance. The subledger holds the detail, one line per open invoice per customer. In a clean month those two are equal by definition. Reconciliation is the discipline of proving they still are, because the systems that feed them (invoicing, payments, credits, write-offs) all fail in small ways that a summary balance hides.

Why reconciling accounts receivable matters

An unreconciled AR balance is a number you are reporting to owners, lenders and the IRS that you cannot actually stand behind. The consequences are concrete. Overstated receivables inflate assets and can mask cash you will never collect. A payment applied to the wrong customer means you keep chasing someone who already paid while the real debtor drifts past due. Duplicate invoices puff up the aging report and distort DSO. And at audit or diligence, an AR ledger that does not tie to its detail is the fastest way to lose a buyer's or a lender's confidence.

The reconciliation is also where cash-application mistakes surface. If a lockbox deposit was split across the wrong invoices, or a short payment was posted in full, the ledger and the aging report drift apart. Catching that in a monthly reconciliation is far cheaper than finding it in a customer dispute six months later.

The accounts receivable reconciliation process, step by step

The mechanics are the same whether you run QuickBooks, Xero, NetSuite or Sage Intacct. Six steps, in order:

1. Pull the AR control balance. Run the general ledger or trial balance as of the reconciliation date and note the accounts receivable balance.
2. Pull the aging report as of the same date. The total of the accounts receivable aging summary should equal the control balance. Use the identical cutoff date, or the two will never match for reasons that have nothing to do with errors.
3. Compare the totals. If they agree, most of your work is done and you move to spot checks. If they differ, record the exact dollar gap: it is your target.
4. Match cash received to invoices. Tie every payment on the bank statement for the period to a specific open or closed invoice. Unmatched deposits and unapplied cash are the most common source of a difference.
5. Investigate the remaining gap line by line. Walk the differences using the discrepancy list below until each one is explained and, where needed, corrected with a journal entry, a reapplied payment or a credit memo.
6. Document and sign off. Save the two reports, the reconciling items and the adjustments, so the next person (or the auditor) can follow what you did.

A worked example

Say your general ledger shows AR of $248,500 at month end, but the aging report totals $246,000, a $2,500 difference. You work it down like this: a $1,500 customer payment was deposited and hit the bank but never applied to the invoice, so it sits in the GL but not against the aging line. A $1,200 credit memo was issued to a customer for a returned order and reduced the aging report but was never posted to the ledger. And a $200 duplicate invoice was voided in the subledger but the reversing entry never reached the GL. Apply the $1,500 payment, post the $1,200 credit memo, book the $200 reversal, and both sides land at $246,800. The reconciliation is not the subtraction; it is finding those three items.

Common accounts receivable discrepancies and what causes them

How to reconcile accounts receivable in QuickBooks and other systems

In QuickBooks Online, run the Accounts Receivable Aging Summary and the Balance Sheet as of the same date, then confirm the AR line on the balance sheet equals the aging total. When they disagree, the Open Invoices report and the Transaction Detail by Account report for the AR account are where you find the stray transaction, usually a payment recorded without being applied or a journal entry posted straight to AR. Xero, NetSuite and Sage Intacct all expose the same pair: an aged receivables report and a general ledger AR balance that should match to the penny.

One habit prevents most QuickBooks reconciliation headaches: never post a manual journal entry directly to the accounts receivable control account. It changes the GL balance without creating a matching invoice or payment in the subledger, which guarantees a difference you then have to hunt down. Keep AR moving only through invoices, payments and credit memos, and the control account stays reconcilable. If you are still building the routine, our guide to tracking accounts receivable covers the fields and cadence that make month end easier.

What is the difference between AR reconciliation and cash application?

Cash application is the act of matching an incoming payment to the specific invoices it pays. Reconciliation is the after-the-fact check that all of those matches, plus every credit, write-off and adjustment, have left the ledger and the subledger in agreement. Good cash application is what makes reconciliation quick: when every deposit is applied to the right invoice as it arrives, month end is a confirmation rather than an investigation. When cash application is sloppy or manual, reconciliation becomes the place where a month of small errors piles up. Our overview of the cash application process and the role of remittance advice explains how the matching step feeds the reconciliation.

How often should you reconcile accounts receivable?

Monthly is the standard, tied to your close. High-volume businesses (heavy invoice counts, lockbox deposits, thousands of open lines) benefit from a weekly quick reconciliation so differences are caught while they are still small and easy to trace. The rule of thumb: the longer you wait, the more transactions you have to sift to find the one that broke the balance. A month is manageable. A quarter is a project. A year is why some companies never really trust their AR number.

How automation changes reconciliation

Most reconciliation pain is really cash-application pain wearing a different hat. When payments are matched to invoices automatically and accurately as they land, and credits and adjustments post cleanly, the ledger and the aging report stay in agreement on their own, and reconciliation shrinks to a spot check. That is what cash application software is for: it reads the remittance, applies the payment to the right invoices including short pays and deductions, and reconciles back to the ledger so the two never drift far apart in the first place.

An AI accounts receivable agent takes it further by keeping the aging report accurate in real time. AccountsReceivable.ai connects to QuickBooks, Xero, NetSuite or Sage, chases every overdue invoice across email, SMS and live AI phone calls, and applies incoming cash to the correct invoices as it arrives, so the balance you reconcile at month end has far fewer surprises hiding in it. For the receivables that reconciliation cannot fix, the ones that are simply not being paid, an accurate aging report is what tells you which accounts to escalate, a point our aging report guide covers in detail. And once your receivables reconcile cleanly, extending the same discipline to your bank and processor accounts with dedicated account reconciliation software keeps the whole close tight rather than just the AR corner of it.

Frequently asked questions

What documents do you need to reconcile accounts receivable? Three: the general ledger or trial balance showing the AR control balance, the accounts receivable aging report as of the same date, and the bank statements or deposit records for the period. Credit memos, write-off approvals and any manual journal entries touching AR round out the trail.

What is an AR reconciliation, in one line? A proof that the receivables balance on your books equals the detail behind it and the cash you have collected, with every difference explained.

Who should reconcile accounts receivable? Ideally someone other than the person who applies the cash, so the check is independent. In small teams that is not always possible, in which case a monthly review by the owner or controller provides the second set of eyes. Keeping cash application, credit memos and write-offs on separate approvals is the control that matters most.