Written by: Andrew Cohen, CFA, CPA, Managing Partner, Condesa Financial Group
Key Takeaways for AR Reconciliation
- AR reconciliation confirms that the total of all customer invoices in the subledger matches the AR control account on the general ledger, which supports accurate financial statements and clear cash-flow visibility.
- A structured seven-step process (gather records, compare balances, identify discrepancies, investigate, post adjustments, document, and obtain review) reduces month-end surprises and creates an audit-ready trail.
- Common discrepancies such as unapplied cash, duplicate invoices, timing differences, and incorrect write-offs can be diagnosed and corrected with targeted journal entries and consistent cutoff procedures.
- Standardized templates and modern automation tools can reduce manual effort by up to 75 percent while improving accuracy and freeing controllers to focus on analysis.
- SMEs that lack internal bandwidth or face recurring discrepancies can contact Condesa Financial to implement a repeatable, audit-ready month-end close process.
What Accounts Receivable Reconciliation Involves
AR reconciliation verifies that the sum of all individual customer balances in the AR subledger equals the single Accounts Receivable line item on the balance sheet, which is the GL control account. Every invoice issued, payment received, credit memo applied, and write-off recorded must appear consistently in both places.
AR reconciliation functions as a verification and control task. It differs from broader AR management, which covers invoicing, collections outreach, and cash application. Reconciliation acts as the checkpoint that confirms all upstream activities have been recorded correctly.
Reconciliation is a core control activity under the COSO Internal Control Framework, which underpins SOX Section 404, and PCAOB AS 2201 establishes that a material weakness can exist even when financial statements are not materially misstated. Any company that needs auditable financial statements should complete AR reconciliation every month.
What You Need Before You Start
Gather these items before starting the reconciliation:
- The AR aging report (subledger detail) as of period-end
- The GL trial balance for the AR control account as of the same date
- Bank statements or payment processor reports for the period
- A list of any credit memos, write-offs, or manual journal entries posted during the period
The workflow varies by system. A small business in QuickBooks Online runs the A/R Aging Summary report and compares its total to the Accounts Receivable line on the Balance Sheet. A larger organization in NetSuite uses a dedicated subledger-to-GL reconciliation report. All reports must be pulled as of the same date, because a mismatched cutoff often creates phantom discrepancies.
Companies without dedicated internal accounting expertise, or with systemic discrepancies that signal a process issue, benefit from outsourced accounting and fractional CFO support. This support provides the structure and oversight needed to close reliably every month. Contact us to learn how Condesa Financial Group supports controllers and SME owners through a clean, repeatable close process.
Step-by-Step AR Reconciliation Process
Step 1: Gather Your Records
Pull the AR aging report, the GL trial balance for the AR account, and bank statements or payment processor reports, all as of the same period-end date. Confirm that the posting period is locked or set to Close Pending before extracting data. Running reconciliation reports after the period is closed to additional subledger transactions prevents activity posted after extraction from causing discrepancies between summary and detail levels.
Step 2: Compare Total AR Subledger to GL Balance
The total of open invoices on the aging report should equal the ending balance in the GL AR control account. Calculate the variance using this formula:
AR Subledger Total − GL AR Balance = Variance
Zero variance means the reconciliation is complete. Any non-zero variance requires further work in Step 3.
Step 3: Identify Discrepancies
Common reconciling items include customer invoices recorded in the AR subledger but not yet transferred to the GL, cash receipts posted to the bank but not applied to customer accounts, credit memos entered in the wrong period, and manual journals posted directly to the AR control account. Additional causes include duplicate invoice entries, incorrect write-offs recorded in only one system, and timing differences around period-end cutoffs.
Step 4: Investigate Discrepancies
Trace each discrepancy back to its source document. In QuickBooks, use the Transaction List by Customer report to drill into individual customer activity. A common QuickBooks issue occurs when users enter payments as bank deposits rather than customer payments, which reduces the bank balance correctly but does not apply against open invoices, creating a gap between the aging report and the GL.
For each discrepancy, decide whether it represents an error that needs a correcting journal entry or a timing difference that will resolve in the next period. The most dangerous reconciliation errors are those that net out, where two offsetting mistakes make the balance look right while the underlying records remain wrong.
Teams that spend hours on manual investigation each month-end benefit from a more structured process and better tools. Contact us to discuss how Condesa’s outsourced accounting team handles this work for SMEs across the US.
Step 5: Post Adjusting Journal Entries
Post a correcting journal entry for each confirmed error. Document the reason for every entry so reviewers and auditors can follow the logic. The next section covers specific examples.
Step 6: Document the Reconciliation
Save the final reconciliation package, including the aging report, the GL balance, a variance log listing each discrepancy and its resolution, and all supporting journal entries. Filing a four-document packet, which includes the aged subledger, GL printout, variance log, and preparer sign-off, all dated as of the close date, saves hours when the CPA requests it at year-end.
Step 7: Review and Approve the Reconciliation
A second person, such as a controller, manager, or external reviewer, should review the reconciliation and sign off. Segregation of duties separates the people who prepare reconciliations, approve adjustments, apply cash, and review final balances, which creates a stronger control environment around customer receivables.
Typical AR Discrepancies and Fixes
Unapplied Cash Payments
A customer pays, but the payment is not matched to an open invoice, so the AR subledger continues to show the invoice as outstanding. Example: A $1,000 payment is received and deposited but not applied to Invoice #2045.
Fix: Apply the payment to the open invoice. The correcting entry is: Debit Cash, Credit Accounts Receivable applied to the specific invoice. Unapplied cash is the top source of AR drift for high-volume clients, and even a few missed matches per month can accumulate significantly by year-end.
Duplicate Invoices
An invoice is entered twice in the subledger. Example: Invoice #1001 for $500 is accidentally entered twice, which overstates AR by $500.
Fix: Reverse the duplicate. The correcting entry is: Debit Sales Revenue, Credit Accounts Receivable for $500. Use the original transaction date rather than the date of discovery for the reversal entry.
Timing Differences
A payment is initiated on the last day of the month but does not clear the bank until the following month. Fix: Treat this as a reconciling item rather than an error. Document it in the reconciliation notes with the expected clear date. No adjusting entry is required, because it will resolve automatically in the next period.
Incorrect Write-Offs
A bad debt is written off in the GL but not in the subledger, or the reverse occurs. Fix: Record the write-off in both places. The standard entry is: Debit Allowance for Doubtful Accounts, Credit Accounts Receivable.
Customer Disputes and Unapplied Credit Memos
A customer disputes an invoice and a credit memo is issued but not applied. Fix: Apply the credit memo to the disputed invoice. The correcting entry is: Debit Sales Returns and Allowances, Credit Accounts Receivable.
How to Tie AR Aging to the General Ledger
The AR aging report represents the subledger in detail form. To tie it to the GL, apply every cash receipt, credit memo, and adjustment to open invoices as of the reconciliation date, using a consistent cutoff.
Two approaches work for unapplied credits. You can list them as separate line items that show an open credit in the Current bucket, or you can apply them to the oldest outstanding invoice. Both approaches tie to the same customer subtotal, and the chosen method should be documented and applied consistently.
Old, stale items in the 90+ day bucket deserve specific attention. Collection probability drops sharply once an invoice passes 90 days, according to data from Crestmont Capital. Items that are genuinely uncollectible should be reviewed against the company’s bad debt policy and written off with appropriate approval, using this entry: Debit Allowance for Doubtful Accounts, Credit Accounts Receivable.
Practical AR Reconciliation Template
A standardized Excel template removes guesswork from month-end and supports a repeatable, auditable process. A well-structured AR reconciliation template includes these components:
- Header section: Reporting date, entity, currency, and preparer name
- Balance comparison table: AR subledger total, GL AR control account balance, and a variance calculation cell (
=SUM(AR_subledger) - GL_balance) - Aging analysis: Open balances bucketed into Current, 1–30, 31–60, 61–90, and 90+ days
- Variance log: One row per discrepancy, with columns for Date, Customer, Invoice Number, Invoice Amount, GL Account, Discrepancy Type, Status (Open / Resolved / Written Off), Resolution Notes, and Preparer Sign-Off
- Journal entry log: A record of all correcting entries posted, with reference numbers and supporting documentation links
Date-stamp the reconciliation file and save a copy before making changes to avoid losing pre-correction numbers when working in a live spreadsheet. Conditional formatting that highlights any non-zero variance cell in red provides an immediate visual signal that investigation is required.
Modern Automation for AR Reconciliation
Automation tools have materially changed what finance teams can do with AR reconciliation. Platforms like QuickBooks Online, NetSuite, and dedicated reconciliation software such as BlackLine, FloQast, and Trintech provide auto-matching of payments to invoices, bank feed integration, and exception flagging that surfaces discrepancies early.
The efficiency gains appear clearly in recent research. Deloitte’s 2025 Finance Operations Survey found that month-end AR reconciliation consumes an average of 87 hours per month in organizations without automation, dropping to 22 hours per month, a 75 percent reduction, in organizations with AI-powered AR automation. A 2025 survey by MineralTree reported that 85 percent of finance teams using automation tools see greater efficiency, with 63 percent seeing improved payment timeliness.
Automation works best when built on a clean, well-structured underlying process. Tools that sync directly with the GL deliver more reliable real-time accuracy than platforms that rely on manual CSV uploads. SMEs that evaluate automation should first confirm that the manual process works consistently, then layer technology on top of it.
Condesa Financial Group uses these tools daily across client engagements. Contact us to learn how our team can improve your AR process for accuracy, efficiency, and audit readiness.
Month-End Close Checklist for AR
AR reconciliation fits into a broader month-end close sequence. Use this checklist to integrate AR into that workflow:
- Pull AR Aging Summary and GL Balance Sheet as of period-end, confirming both use the same cutoff date.
- Compare totals and calculate the variance (
AR Subledger Total − GL AR Balance). - Investigate and resolve all variances above the materiality threshold, such as greater than $50 or 0.1 percent of total AR.
- Post and document all adjusting journal entries with supporting documentation.
- Review aging for invoices over 60 and 90 days and assess collectability against the bad debt policy.
- Apply or write off stale unapplied cash per company policy.
- Obtain reviewer sign-off and file the complete reconciliation package.
- Flag any systemic issues identified for process improvement in the next cycle.
Frequently Asked Questions
What are the core steps to reconcile accounts receivable?
The core steps include gathering records such as the AR aging report, GL trial balance, and bank statements, all as of the same date. Next, compare the AR subledger total to the GL AR control account balance and calculate the variance. Then identify the type and source of each discrepancy, investigate and post correcting journal entries with documentation, and document the full reconciliation package and obtain reviewer sign-off. For high-volume businesses, a preliminary review of unapplied cash and credit memos before month-end reduces the volume of discrepancies that surface at close.
What is the standard format for an accounts receivable reconciliation?
A standard AR reconciliation format includes a header with the reporting date, entity, and currency. It also includes a balance comparison table that shows the AR subledger total, the GL control account balance, and the calculated variance. The file should contain an AR aging analysis bucketed into Current, 1–30, 31–60, 61–90, and 90+ days, plus a variance log with one row per discrepancy documenting the customer, invoice number, discrepancy type, resolution, and status. A journal entry log for all correcting entries and a dated preparer and reviewer sign-off complete the package. The variance cell should equal zero before the reconciliation is considered complete.
How often should accounts receivable be reconciled?
Monthly AR reconciliation represents the standard minimum for SOX-compliant controls, and Growthy recommends completing it within 10 business days of period end. For businesses processing more than 100 invoices per month, weekly reconciliation works better because it prevents unapplied cash and duplicate entries from accumulating before close. Daily reconciliation suits very high-volume environments where even a one-week lag creates material exposure. A practical rule states that if an account can develop a material error between reconciliations that would not be caught any other way, the cadence is too infrequent.
What causes AR reconciliation discrepancies?
Common causes include unapplied cash payments, where a customer pays but the payment is not matched to an open invoice, duplicate invoice entries, and timing differences around period-end cutoffs, such as a payment initiated on the 30th that clears on the 1st. Other causes include incorrect write-offs recorded in only one system and manual journal entries posted directly to the AR control account that bypass the subledger. In QuickBooks specifically, payments entered as bank deposits rather than customer payments frequently create gaps between the aging report and the GL. Data entry errors such as transposed digits also appear often, and a discrepancy divisible by nine provides a reliable signal of a transposition error.
When should an SME consider outsourced accounting or fractional CFO support for AR reconciliation?
Outsourced accounting support makes sense when there is no dedicated internal accounting resource, when discrepancies are recurring and systemic, when the month-end close consistently runs beyond ten business days, or when the business lacks a second reviewer to provide segregation of duties. Fractional CFO oversight adds value when the business needs a clean reconciliation and also strategic guidance on cash flow, bad debt policy, and process design. These conditions align with the services Condesa Financial Group provides, which include ex-Big 4 caliber accounting and fractional CFO services at price points accessible to SMEs.
Conclusion: Turning AR Reconciliation into a Reliable Control
A structured AR reconciliation process functions as a foundational financial control rather than a simple month-end administrative task. It supports the accuracy of the balance sheet, provides a reliable view of cash flow, and protects the business against billing errors and fraud. With 48 percent of all B2B invoices in the US paid late, according to Atradius research, a current and accurate AR reconciliation serves as an early warning system for emerging cash flow risk.
Companies that lack the internal resources or expertise to manage this process reliably every month can rely on outsourced accounting and fractional CFO services for structure, oversight, and quality. Condesa Financial Group delivers ex-Big 4 caliber accounting and executive financial oversight to SMEs across the US at price points that keep the quality-to-cost ratio favorable.
Contact us to schedule a free consultation and learn how Condesa can build a clean, repeatable month-end close process for your business.
