Written by: Andrew Cohen, CFA, CPA, Managing Partner, Condesa Financial Group | Last updated: October 18, 2026

Key Takeaways

• AR reconciliation proves the AR subledger total equals the GL control account balance by clearing every variance before month-end close.
• A seven-step process, covering reports, variance, reconciling items, corrections, re-tie, and review, keeps the reconciliation repeatable and defensible.
• Common reconciling items include unapplied cash, duplicate entries, timing differences, manual GL journals to the control account, and unposted credit memos, and each maps to a specific correcting entry.
• Workpapers must document the entity, period, preparer, reviewer, variance calculation, reconciling-item schedule, and final re-tie to zero with dated signatures.
• Condesa Financial provides outsourced accounting and fractional CFO services that deliver this reconciliation correctly every month for SMEs without an internal team.

Talk With Condesa Financial

Before You Begin: What You Need For An AR Reconciliation

The AR subledger is the customer-level detail of every open invoice, credit memo, and applied payment. The GL AR control account is the single summary balance that feeds the balance sheet. These two records must agree. Ownership of the reconciliation sits with the accounting department. The preparer should not be the same person who posted the manual journals being reviewed, because combining those roles lets errors and fraud go undetected.

Gather four source documents, all pulled as of the identical cutoff date:

• AR aging detail report
• GL trial balance filtered to the AR control account
• Cash receipts log
• Credit memo register

The procedure below works whether you run a single entity or several, on QuickBooks Online or NetSuite, at low or high invoice volume, and with manual or automated cash application. Platform-specific notes appear later.

A brief primer on related terms helps keep roles clear. Accounts payable (AP) is what the company owes vendors. Accounts receivable (AR) is what customers owe the company. The general ledger holds the summarized control balances that both subledgers must tie to. This article covers the AR side only. For aging analysis and collections context, see How To Prepare An Accounts Receivable Aging Report and Accounts Receivable KPIs: The Essential Metrics Guide.

Get Help Setting Up Your AR Reconciliation

How To Do Accounts Receivable Reconciliation Step By Step

1. Gather The AR Aging Detail And The GL Trial Balance As Of The Same Cutoff Date. Both reports must reflect the identical period-end date down to the day. Mismatched cutoff dates create false variances that consume investigation time without pointing to a real error. Lock the cutoff before pulling either report.
2. Tie The Subledger Total To The GL Control Account Balance. Place the AR aging report total next to the AR control account balance from the trial balance. In a clean file these two numbers are equal. The core reconciliation formula is: AR subledger total minus GL AR balance equals variance. A zero variance means the books are reconciled.
3. Isolate And Quantify The Variance Before Investigating. Record the dollar amount and whether the subledger is higher or lower than the GL. Knowing the size and direction of the gap helps prioritize where to look first. A $12,000 difference traced to a single journal entry calls for a different approach than a $550 difference traced to an unapplied payment.
4. Classify The Reconciling Item. Common categories are unapplied cash, duplicate entry, timing difference, manual GL journal posted directly to the AR control account, and unposted credit memo. A journal entry posted directly to the AR GL account instead of through an invoice, payment, or credit memo transaction is the most frequent cause of a subledger-to-GL mismatch, because it updates the GL balance without touching customer-level detail.
5. Post The Correcting Journal Entry Or Correct Through The Subledger Transaction. Oracle’s guidance explicitly recommends reversing a control-account journal and reposting the economic event through an invoice, receipt, credit memo, or write-off transaction in the AR subledger. A standalone correcting entry would bypass customer detail again. The correcting-entries table in the next section maps each variance type to the appropriate entry.
6. Re-Tie To Zero And Confirm The Reports Agree. After posting corrections, re-run both the AR aging report and the GL trial balance as of the same cutoff date. Confirm the variance is zero. An equal ending balance alone does not demonstrate all activity is correct. Confirm that the path to zero is supported by documented correcting entries, not an unexplained plug.
7. Document And Sign Off: Preparer, Reviewer, Date. The workpaper is not complete until a reviewer independent of the preparer has signed off. Segregation of duties in reconciliation is non-negotiable: the person who creates a manual journal should not be the same person who reconciles and certifies the account that journal affected.

Get Your AR Reconciliation Handled Monthly

Common Reconciling Items And Their Correcting Journal Entries

Each reconciling item has a specific correcting entry, and matching the item to the right entry keeps the fix from creating a new variance next period. The table below maps each common AR reconciling item to what it looks like in practice and the correcting entry that clears it. Account names used: AR control account, cash, sales returns, allowance for doubtful accounts, bad debt expense. Oracle’s reconciliation guidance and Intuit’s QuickBooks Online help documentation inform the treatment of timing items and manual control-account journals below.

Review Your Reconciling Items With An Expert

What An AR Reconciliation Workpaper Looks Like

A reviewer-ready AR reconciliation workpaper follows a consistent layout. The header identifies the entity and period-end date, then names the preparer and reviewer with their respective dates. Those fields are what make the workpaper auditable. The top section shows the GL AR control account balance and the AR subledger total side by side, with a variance line directly beneath them. A zero on the variance line after adjustments is the objective.

Below the balance comparison sits the reconciling-items schedule. Its columns are: Customer | Invoice Number | Amount | GL Reference | Status | Adjustment. Each row documents one reconciling item in enough detail for a reviewer who did not prepare the file. That reviewer should be able to understand what the item is, why it exists, and what was done to clear it. Every reconciling item should document what it is, why it exists, when it is expected to clear, and what support proves it.

The bottom section of the workpaper shows the post-adjustment re-tie. GL balance plus or minus correcting entries equals adjusted balance, which must equal the subledger total. The workpaper is complete only when both the preparer and an independent reviewer have signed and dated it.

An AR reconciliation Excel workpaper template mirroring this layout, with header block, balance comparison, reconciling-items schedule, and re-tie section, is available as a downloadable file. The template uses only SUM and IF functions and works identically in Excel and Google Sheets.

Request The AR Reconciliation Template

Worked Example: Walking A Variance To Zero

The following is an illustrative example with internally consistent numbers. It is not a benchmark or a client result.

Opening position at March 31:

• GL AR control account balance: $406,300
• AR subledger total: $412,300
• Variance: $6,000 (subledger exceeds GL)

Investigation focuses on the GL AR account activity report filtered to journal-entry source types. The scan reveals one entry, debit bad debt expense $6,000 and credit AR control account $6,000, posted directly to the control account on March 28 without a corresponding customer-level record in the subledger. The subledger still carries the $6,000 invoice as open because the write-off never flowed through the AR module.

Correction reverses the direct journal entry, debit AR control account $6,000 and credit bad debt expense $6,000. Then a $6,000 credit memo or write-off is posted against the specific customer invoice through the AR subledger, reducing both the subledger and the GL together.

Post-adjustment position:

• GL AR control account balance: $406,300
• AR subledger total: $406,300
• Variance: $0

The reconciliation ties to zero. The workpaper documents the original journal entry reference, the reversal entry reference, the credit memo number, and the reviewer sign-off. That example used generic report names; the same steps look slightly different depending on your platform.

AR Reconciliation In QuickBooks Online And NetSuite

The seven steps above work the same way in any system, but report names and where journals appear differ by platform. This section shows how the process maps to QuickBooks Online and NetSuite.

QuickBooks Online: Pull the A/R aging summary report for the subledger total and the accounts receivable line on an accrual-basis balance sheet as of the same date for the GL balance. AR reconciliation in QuickBooks Online must use accrual-basis reports run on identical cutoff dates, because cash-basis reports can omit or alter the presentation of unpaid invoices. The AR control account is mapped in the chart of accounts. Clicking into it from the Accounting menu shows every transaction that hit it, which makes it straightforward to locate journal entries posted directly to the account without a customer name.

NetSuite: The A/R aging report supplies the subledger total and the GL AR account balance comes from the trial balance for the same period. NetSuite’s A/R register report is designed specifically to support the subledger-to-GL comparison, combining posting sales and payment transactions across AR accounts. Journal entries booked directly to the NetSuite AR control account appear in the GL balance but have no customer document to age, so they never appear in the aging report and cause the aging total to be understated relative to the GL. That pattern is the most common source of a NetSuite AR reconciliation break.

AR Reconciliation Vs. Bank Reconciliation

One frequent source of confusion is mixing up AR reconciliation with bank reconciliation. Bank reconciliation ties the GL cash account to the bank statement. AR reconciliation ties the AR subledger to the GL AR control account. The two procedures are distinct and address different accounts. They overlap only when verifying that customer payments deposited at the bank were also applied correctly in the AR subledger, which confirms that the cash side and the receivables side of the same transaction are both recorded accurately.

Common Mistakes And Troubleshooting

The following errors appear repeatedly in AR reconciliations and are worth checking before you conclude that a variance is unexplainable:

• Posting A Manual Journal Entry Straight To The AR Control Account To Force A Tie. This pattern updates the GL without touching the subledger and creates a new variance in the next period. Every correcting entry should flow through a subledger transaction type, as described in the earlier steps.
• Leaving Unapplied Cash Sitting In The GL. Unapplied cash, money received but not matched to an invoice, is one of the most frequent sources of reconciliation breaks. Park unidentified payments in a suspense account, contact the customer for remittance details, and clear the suspense balance before close.
• Failing To Post Credit Memos To The Subledger. Skipped credit memos reduce the GL but never enter the subledger, which inflates the subledger total above the GL balance by exactly the credit amount. The fix is to post the credit memo through the AR module, as shown in the reconciling-items table.
• Reconciling To The Aging Report Total Without Confirming The Aging Report Is Complete. The aging report must be pulled as of the reconciliation date, not the prior business day, and must be on an accrual basis. A stale or cash-basis aging report creates variances that do not reflect real errors.
• Skipping The Reviewer Sign-Off. An unsigned workpaper is not a completed reconciliation. Segregation of duties, the principle that the person who prepares a reconciliation is not the person who approves it, is the most basic internal control in account reconciliation and the one most often missing on small teams.

Most of these mistakes are manageable in a spreadsheet up to a point. Eventually volume and complexity make them harder to catch by eye.

Talk To A Fractional CFO About Your Close

Manual Vs. Automated: When Excel Stops Being Enough

Manual Excel reconciliation is a workable approach at low invoice volume and a single entity. The process described in this article can be executed entirely in a spreadsheet with exported aging and trial balance reports. Automation earns its keep when any one of three conditions hits: transaction volume climbs, the business spans multiple entities, or cash application becomes a persistent bottleneck that leaves unapplied cash piling up between closes. Reconciliation automation is worth evaluating when more than 20% of close time goes to data matching, transaction volume exceeds 1,000–5,000 per month, or one person owns the reconciliation spreadsheet as a single point of failure. Base the decision to automate on volume and control requirements; a preference for technology alone is not a reason.

How To Evaluate Progress

A maturing AR reconciliation process shows measurable signs of improvement over time. The reconciliation ties to zero within the close window. Top-quartile finance teams complete the monthly close, including all reconciliations, within 4.8 calendar days. Reconciling items are documented and cleared within the current period rather than carried forward. The workpaper carries both preparer and reviewer signatures with dates. The same variance type does not recur month over month without a documented upstream process fix. These indicators reflect process maturity and do not represent promises of business outcomes.

Frequently Asked Questions

What Are The Four Common Reconciliation Adjustments?

The four adjustments that appear most frequently in AR reconciliations are unapplied cash, duplicate entries, timing differences, and manual GL journals to the AR control account. Each requires a different correcting action, as detailed in the reconciling-items table above.

What Are Examples Of Reconciling Items In AR?

Common AR reconciling items include unapplied cash sitting in a suspense or clearing account, unposted credit memos that reduced the GL but were never entered in the subledger, duplicate invoices that inflated the subledger total, and cutoff timing differences where an invoice or payment crossed the period boundary. Each item must be classified, documented, and cleared through a supported correcting entry before the reconciliation can be signed off.

What Is A Reconciliation Checklist?

An AR reconciliation checklist is the ordered set of steps from pulling both reports to reviewer sign-off. The steps are: gather the AR aging detail and GL trial balance as of the same cutoff date, calculate the variance, classify each reconciling item, post supported correcting entries, re-tie to zero, and obtain preparer and reviewer sign-off with dates. The checklist ensures the process is repeatable and that no step is skipped under close deadline pressure.

Can You Reconcile AR In Excel?

Yes. At low invoice volume and a single entity, Excel is a practical tool for AR reconciliation. Export the AR aging report to CSV, enter the GL AR control account balance in a separate cell, and compute the variance with a SUM formula. Flag non-zero variances with conditional formatting and date-stamp the file before making corrections. The limitation is that Excel has no direct connection to the GL, so status tracking, reviewer sign-off, and exception documentation require separate manual steps that become harder to manage as transaction volume grows.

Conclusion

A documented, repeatable AR reconciliation, with both reports pulled to the same cutoff date, every reconciling item classified, only supported correcting entries posted, and reviewer sign-off obtained, makes the month-end close defensible. The procedure replaces judgment about whether the books are approximately right with a process that proves they are exactly right. Condesa Financial Group runs this reconciliation every month for SMEs that need it done correctly without building an internal team.

Schedule A Call With Condesa Financial