How Do You Reconcile Accounts Receivable? Step-by-Step Guide

To reconcile accounts receivable, compare the total balance in the accounts receivable sub-ledger or aging report with the accounts receivable control account in the general ledger for the same cutoff date. If the balances do not agree, investigate the difference, identify the underlying transaction or posting issue, make the appropriate correction, and rerun the reports until the balances reconcile.

Accounts receivable reconciliation is a key accounting control because the AR balance on the balance sheet should be supported by detailed customer-level records. A consistent reconciliation process helps finance teams identify posting errors, unapplied or misapplied payments, duplicate transactions, credit memos, write-offs, and timing differences before they affect financial reporting.

How Do You Reconcile Accounts Receivable?

The accounts receivable reconciliation process can be summarized in six steps:

1. Confirm the reconciliation period and opening balance.
2. Run the AR aging report or AR sub-ledger as of the period-end date.
3. Pull the AR control account balance from the general ledger using the same cutoff.
4. Compare the two balances and calculate the variance.
5. Investigate and resolve discrepancies such as unapplied cash, credit memos, timing differences, duplicate invoices, or manual journal entries.
6. Rerun the reports, document the reconciliation, obtain review or approval, and retain supporting evidence.

The fundamental control is simple:

AR sub-ledger total = AR control account balance in the general ledger

If the two balances do not agree, the difference should be explained before the reconciliation is considered complete.

What Do You Reconcile Accounts Receivable Against?

Accounts receivable is primarily reconciled by comparing the detailed AR sub-ledger with the accounts receivable control account in the general ledger.

The detailed AR records provide the supporting information, while the GL control account provides the summarized accounting balance. The reconciliation confirms that these two views of receivables agree.

For more background, see accounts receivable reconciliation.

What Does A/R Mean in Accounting?

A/R stands for Accounts Receivable. It represents amounts owed to a company by customers for goods or services provided on credit.

Because accounts receivable is generally presented as a current asset, an inaccurate AR balance can affect financial reporting, cash-flow analysis, collections decisions, and other financial metrics.

What Is a Reconciliation Account?

A reconciliation account is a general ledger account that summarizes balances maintained in a related sub-ledger. In an accounts receivable environment, the main AR general ledger account can act as the control or reconciliation account for individual customer balances.

The detailed customer records should collectively support the balance recorded in the control account. This relationship is fundamental to the main purpose of account reconciliation and the account reconciliation process.

What You Need Before Starting an AR Reconciliation

A reliable reconciliation starts with consistent source data. Before comparing balances, gather the reports and supporting records required for the period.

• AR aging report or AR sub-ledger
• General ledger detail for the AR control account
• Prior-period reconciliation and opening balance
• Customer invoices and credit memos
• Customer payment and cash receipt records
• Write-off and adjustment records
• Relevant journal entries
• Supporting documentation for unusual or manual transactions

Use the same cutoff date, entity, currency, account scope, and relevant report filters when comparing the AR sub-ledger with the general ledger. Different reporting dates or populations can create an apparent variance even when the underlying accounting is correct.

How to Reconcile Accounts Receivable: 6 Steps

Step 1: Confirm the Period and Opening Balance

Start with the last completed reconciliation and confirm the opening AR balance for the current period. Review any unresolved items carried forward from the previous period.

Before proceeding, verify:

• The previous reconciliation was completed or outstanding exceptions are documented.
• The opening balance agrees with the prior period closing balance.
• There are no unauthorized backdated entries affecting the prior period.
• The reconciliation covers the intended entity, accounts, and reporting period.

Reviewing the prior balance helps prevent a current-period reconciliation from being used to conceal an older unresolved difference.

Step 2: Run the AR Aging Report or Sub-Ledger

Generate the accounts receivable aging report or detailed AR sub-ledger as of the period-end date. The report should provide the customer-level detail needed to support the total receivables balance.

Review the report for:

• Open invoices
• Customer payments
• Credit memos
• Adjustments
• Write-offs
• Unusual debit or credit balances
• Unapplied or partially applied payments
• Old or stale balances requiring investigation

If your process uses an aged trial balance, ensure the report is generated using the correct period-end date and account population.

See accounts receivable on the balance sheet for additional context on the AR balance.

Step 3: Pull the AR Control Account From the General Ledger

Next, retrieve the general ledger balance for the accounts receivable control account for the same reporting date.

Check that the GL report uses the same:

• Period-end date
• Legal entity
• Currency
• AR account or account range
• Accounting status
• Relevant reporting filters

The purpose is to compare like-for-like populations. If the AR aging report is dated June 30 but the GL balance is dated July 1, the resulting difference may simply reflect activity posted between the two dates.

Step 4: Compare the Two Balances

Compare the total AR sub-ledger balance with the GL control account balance.

Variance = AR sub-ledger total − GL AR control account balance

If the variance is zero, the high-level balance agrees. If the variance is not zero, create an exception record showing:

• Amount of the difference
• Debit or credit direction
• Period affected
• Potential source
• Assigned owner
• Required corrective action
• Resolution status

Do not automatically assume that a difference is an accounting error. First confirm that both reports were generated from the same period, entity, currency, and account population.

Step 5: Investigate and Resolve Differences

When the balances do not agree, investigate the variance systematically rather than searching randomly through transactions.

Start with the most common causes:

• Unapplied or misapplied payments: cash has been received but is not linked to the correct customer or invoice.
• Timing differences: a transaction was recorded in one period or system before it was recorded in another.
• Credit memos: credits were created, posted, or applied inconsistently.
• Write-offs: a write-off was recorded in one accounting layer but not reflected correctly in the related customer balance.
• Duplicate invoices: the same billing activity was recorded more than once.
• Missing invoices: an invoice exists in one record but has not reached the corresponding accounting record.
• Manual journal entries: an entry was posted directly to the AR control account without the corresponding customer-level sub-ledger activity.
• Incorrect account coding: a transaction was posted to the wrong GL account.
• Data-entry or integration errors: information was lost, duplicated, or transformed incorrectly between systems.

For broader reconciliation issues, see common challenges in account reconciliations.

How to Investigate an AR Variance

1. Confirm the difference is real by checking dates and report filters.
2. Compare the GL transaction detail with the AR transaction population.
3. Review payments and unapplied cash.
4. Check invoices and credit memos around the period cutoff.
5. Review write-offs and adjustments.
6. Identify manual journal entries affecting the AR control account.
7. Trace suspicious transactions to supporting documentation.
8. Determine whether the issue is a timing difference, accounting error, integration issue, or legitimate reconciling item.
9. Assign ownership and document the required correction.

Step 6: Correct, Rerun, Document, and Sign Off

Once the cause of the difference is known, make the appropriate correction through the approved accounting or AR process.

Depending on the issue, the correction may involve:

• Applying a customer payment to the correct invoice
• Correcting a customer or account coding error
• Posting a missing transaction
• Correcting a duplicate transaction
• Recording or applying a credit memo
• Processing an approved write-off
• Correcting an appropriate journal entry

After corrections are posted, rerun the AR and GL reports using the same cutoff and scope. The reconciliation should be considered complete only when the remaining difference is zero or each legitimate reconciling item is documented and appropriately approved.

Retain the reconciliation file, supporting evidence, exception explanations, corrective entries, preparer information, reviewer information, and approval records according to your organization’s accounting-control requirements.

When Will Accounts Receivable Be Involved in an Adjusting Entry?

Accounts receivable can be affected by an adjusting entry when an accounting error, timing issue, write-off, allowance, or other approved adjustment requires correction. The appropriate treatment depends on the nature of the transaction and the company’s accounting policies.

For example, if a collection has occurred but has not been posted correctly, the accounting records may require correction so that the customer-level AR balance and the related GL accounts accurately reflect the transaction. See the existing accounts receivable collection process resource for related context.

Common Accounts Receivable Reconciliation Differences

What to Check When AR Does Not Match the General Ledger

If your AR aging does not match the GL, use this troubleshooting sequence:

1. Check the cutoff date. Both reports must represent the same point in time.
2. Check the entity and currency. A different reporting population can create a false variance.
3. Check the AR account mapping. Confirm the aging report includes the accounts represented by the GL control balance.
4. Review unapplied and misapplied cash.
5. Review credit memos, write-offs, and adjustments.
6. Review period-end invoices. Cutoff differences can cause temporary mismatches.
7. Review manual journals to the AR control account.
8. Check unposted or failed transactions.
9. Trace the remaining difference to transaction-level evidence.
10. Correct the root cause and rerun the reconciliation.

Current reconciliation guidance similarly emphasizes the importance of matching the AR sub-ledger to the GL control account using the same reporting date and investigating unapplied cash, credits, write-offs, timing differences, and direct GL postings when differences occur.

When Should You Reconcile Accounts Receivable?

Accounts receivable reconciliation is commonly performed as part of the month-end close, before financial statements are finalized. The appropriate frequency depends on transaction volume, risk, business complexity, and internal controls.

High-volume or complex organizations may benefit from more frequent reconciliation or continuous exception monitoring rather than waiting until period end.

The important principle is consistency: define the reconciliation frequency, assign ownership, use standardized reports, investigate exceptions promptly, and retain evidence of completion.

AR Reconciliation Checklist

Use this checklist for a repeatable accounts receivable reconciliation process:

• Confirm the prior-period closing balance.
• Review unresolved prior-period exceptions.
• Confirm the current reconciliation period.
• Generate the AR aging or sub-ledger report.
• Generate the GL AR control account report.
• Confirm matching dates, entities, currencies, and account scope.
• Compare the AR sub-ledger total with the GL balance.
• Calculate and document the variance.
• Investigate unapplied and misapplied payments.
• Review invoices and period-end cutoff transactions.
• Review credit memos and write-offs.
• Review manual journal entries affecting AR.
• Resolve identified discrepancies.
• Rerun the AR and GL reports.
• Confirm the reconciliation status.
• Document supporting evidence and explanations.
• Obtain appropriate review and sign-off.
• Carry forward only approved and documented outstanding items.

Why Accounts Receivable Reconciliation Matters

A reliable AR reconciliation process does more than prove that two accounting balances agree. It provides confidence that the receivables balance supporting financial reporting is backed by detailed customer-level records.

Accurate reconciliation can help finance teams:

• Identify accounting and posting errors.
• Detect unapplied or misapplied cash.
• Improve the reliability of financial reporting.
• Support month-end and year-end close activities.
• Strengthen reconciliation controls and audit readiness.
• Improve visibility into customer balances.
• Provide a more reliable foundation for cash-flow analysis and AR reporting.

Regular accounts receivable cycle management also helps finance teams understand how billing, collections, cash application, adjustments, and reporting interact.

Common Accounts Receivable Reconciliation Challenges

Manual reconciliation becomes more difficult as transaction volumes, customers, payment channels, entities, currencies, and accounting systems increase.

Common challenges include:

• Large volumes of customer transactions
• Unapplied cash and incomplete remittance information
• Multiple ERP or billing systems
• Different payment channels
• Manual spreadsheet-based matching
• Period-end timing differences
• Manual journal entries
• Incomplete supporting documentation
• Difficulty assigning ownership for exceptions
• Limited visibility into unresolved differences

The broader accounts receivable cycle can also reveal operational issues that reconciliation alone does not solve, such as slow collections or inefficient billing processes.

Can a Growing AR Balance Be a Problem?

A growing accounts receivable balance is not automatically a problem. It should be evaluated in the context of sales, billing terms, customer payment behavior, collections performance, and other relevant business factors.

If receivables grow without a corresponding business explanation, finance teams should investigate aging, overdue balances, disputes, unapplied cash, and collection performance. See is continuous accounts receivable a problem for additional discussion.

How Can You Reduce Accounts Receivable?

Reconciliation verifies the accuracy of receivables; it does not by itself reduce the amount customers owe. Reducing AR may require improvements across invoicing, payment terms, collections, dispute management, cash application, and customer payment processes.

Related strategies are covered in how to reduce accounts receivable costs.

Advanced Accounts Receivable Management

Understanding the Accounts Receivable Cycle

The accounts receivable cycle covers the activities from a credit sale through invoicing, payment, cash application, collections, adjustments, and eventual settlement.

Understanding the complete cycle helps finance teams identify where reconciliation problems originate and where process improvements can prevent them.

What Are Other Receivables in Accounting?

Trade accounts receivable generally arise from normal customer sales on credit. Other receivables can arise from different types of transactions, such as employee-related balances, tax refunds, interest, or other amounts due to the business.

These balances may be accounted for separately from trade AR, depending on the company’s chart of accounts and accounting policies.

The Importance of AR Reporting

AR reporting provides visibility into customer balances, aging, overdue amounts, payment activity, and other information used by finance teams to manage receivables.

Reliable reporting depends on accurate underlying records. Reconciliation helps establish that the detailed receivables data and the corresponding GL balance agree.

How Automation Improves Accounts Receivable Reconciliation

Automation can reduce the amount of manual work required to collect data, compare records, identify exceptions, and document reconciliation activity.

An automated AR reconciliation workflow can support activities such as:

• Collecting data from ERP and financial systems.
• Standardizing transaction data.
• Comparing sub-ledger and GL balances.
• Matching invoices, payments, and related transaction information.
• Identifying exceptions.
• Routing exceptions for review.
• Maintaining reconciliation evidence and status.
• Providing dashboards and reporting.

Automation does not eliminate the need for accounting judgment. Exceptions involving unusual transactions, write-offs, disputed balances, accounting treatment, or policy decisions may still require human review.

For broader AR automation context, see the existing account reconciliation challenges resource.

How Emagia Supports Accounts Receivable Reconciliation

For organizations managing complex accounts receivable environments, Emagia provides automation capabilities designed to reduce manual effort across receivables processes.

Emagia can support areas such as data collection, transaction matching, cash application, exception management, and visibility into receivables activity. These capabilities can help finance teams move from highly manual reconciliation activities toward more standardized, automated workflows while retaining human review where judgment is required.

Automation is particularly relevant when AR teams work across high transaction volumes, multiple payment sources, multiple entities, or complex customer-payment relationships.

The objective is not simply to automate a reconciliation spreadsheet. It is to create a more connected process in which transaction data, matching, exceptions, accounting records, and supporting evidence can be managed through a controlled workflow.

FAQs About Reconciling Accounts Receivable

How do you reconcile accounts receivable to the general ledger?

Run the AR aging report or sub-ledger as of the period-end date and compare its total with the AR control account balance in the general ledger for the same date and reporting scope. If the balances differ, investigate the variance, correct the underlying issue, rerun the reports, and document the final reconciliation.

What are the steps in accounts receivable reconciliation?

The basic steps are to confirm the opening balance and period, run the AR sub-ledger or aging report, obtain the GL AR control balance, compare the totals, investigate discrepancies, make approved corrections, rerun the reports, and document and review the completed reconciliation.

What reports are needed to reconcile accounts receivable?

The core reports are an AR aging report or sub-ledger and the general ledger detail or trial balance for the AR control account. Supporting records can include customer invoices, cash receipts, credit memos, write-offs, adjustments, and relevant journal entries.

Why does my AR aging not match the general ledger?

Common causes include different report cutoff dates, unapplied or misapplied payments, duplicate or missing invoices, credit memos, write-offs, incorrect account coding, manual journal entries posted directly to the AR control account, and unposted or failed transactions.

What is the difference between AR reconciliation and bank reconciliation?

AR reconciliation primarily compares the detailed accounts receivable sub-ledger with the AR control account in the general ledger. Bank reconciliation compares the company’s accounting records with information from the bank. They are different controls, although customer payments and cash application can connect the two processes.

How often should accounts receivable be reconciled?

Many organizations reconcile AR as part of the monthly close. Businesses with higher transaction volumes, greater complexity, or higher reconciliation risk may choose a more frequent review or continuous exception-management approach.

What is an unapplied payment in accounts receivable?

An unapplied payment is customer cash that has been received but has not yet been correctly associated with a customer account or specific invoice. Unapplied cash can make it harder to determine which invoices have actually been settled and may contribute to reconciliation exceptions.

Can accounts receivable reconciliation be automated?

Yes. Technology can automate data collection, balance comparisons, transaction matching, exception identification, workflow routing, and reconciliation documentation. Human review remains important for exceptions requiring accounting judgment or approval.

What does it mean to reconcile accounts?

To reconcile accounts means to compare two relevant sets of financial records, identify differences, investigate their causes, make appropriate corrections, and confirm that the resulting balances agree or that legitimate reconciling items are documented and approved.

What is the purpose of an AR statement?

An AR statement summarizes transactions and outstanding balances associated with a customer for a specified period. It can support customer communication and collections, while the internal AR sub-ledger and GL control account are used for the accounting reconciliation.

Conclusion

Accounts receivable reconciliation is the process of proving that detailed customer-level receivables agree with the AR control balance recorded in the general ledger.

The most reliable approach is to use the same reporting cutoff, compare the AR sub-ledger with the GL control account, investigate every unexplained difference, correct the underlying issue, rerun the reports, and retain evidence of the completed reconciliation.

As transaction volumes and payment complexity increase, automation can help finance teams standardize data collection, matching, exception management, and reconciliation workflows while keeping appropriate human oversight for accounting decisions.