How to Reconcile Accounts Receivable with the General Ledger

How to Reconcile Accounts Receivable with the General Ledger

Accounts receivable can look healthy on paper while hidden mismatches sit between customer balances and the general ledger. A payment may be applied to the wrong customer. A credit note may be missing. A journal entry may not be posted correctly. These differences can distort receivables, cash flow, revenue reporting, and month-end close.

Accounts receivable reconciliation helps finance teams compare the AR subledger with the general ledger and confirm that customer balances are accurate. This guide explains why AR reconciliation matters, how the AR subledger connects to the general ledger, what information you need, the step-by-step process, common differences, and how automation improves reconciliation quality.

Why Accounts Receivable Reconciliation Matters

Accounts receivable reconciliation matters because receivable balances affect cash flow, working capital, and financial reporting.

Relationship between customer balances and financial reporting

Customer balances feed the AR balance in the general ledger, which appears on the balance sheet as an asset.

Why unreconciled receivables affect cash flow and reporting accuracy

Unreconciled receivables can overstate expected collections, hide payment allocation issues, and create inaccurate working capital reports.

Impact of reconciliation on collections, audits, and month-end close

Clean AR records help collections teams follow up on valid balances, help auditors verify receivables, and help accounting teams close faster.

What Accounts Receivable Reconciliation Means

Accounts Receivable Reconciliation is the process of comparing customer-level AR records with the general ledger AR control balance.

Definition of accounts receivable reconciliation

It validates invoices, receipts, credit notes, write-offs, and customer balances against accounting records.

Purpose of comparing the AR subledger with the general ledger

The purpose is to confirm that detailed customer records agree with the summarized AR balance in the general ledger. 

Why reconciliation confirms the accuracy of customer balances

If the AR subledger and GL balance agree, finance teams have stronger evidence that receivable balances are complete and supported.

How the Accounts Receivable Subledger Relates to the General Ledger

The AR subledger and general ledger serve different purposes but must align. Understanding the distinction between these two accounting records is important because each serves a different role in financial reporting. If you want a deeper comparison, subledger vs general ledger reconciliation explains how these records work together during reconciliation. 

Individual customer accounts in the subledger

The subledger stores detailed customer activity, including invoices, payments, credits, disputes, and open balances.

AR control account in the general ledger

The general ledger contains the total AR control balance used for financial reporting.

Why both records should always agree

The total of all customer balances in the AR subledger should match the AR control account in the GL.

Why Differences Occur Between Accounts Receivable and the General Ledger

Differences occur when records do not update at the same time or are posted incorrectly.

Timing differences between postings

A receipt may be recorded in the subledger before the GL updates.

Missing or duplicate journal entries

Entries may fail to post, or the same transaction may be recorded twice.

Incorrect customer-payment allocation

A payment may be applied to the wrong invoice or customer account.

Manual adjustments and write-offs

Manual entries can create differences if they are not reflected in both records.

Integration issues between finance systems

ERP, billing, banking, and collection systems may use different posting rules or sync timing.

Information Needed Before Starting Accounts Receivable Reconciliation

Finance teams need complete records before starting the review.

General ledger AR balance

This is the reported AR control balance for the period.

Accounts receivable aging report

The AR aging report lists customer balances by due date and aging bucket.

Customer account statements

Customer statements show invoice, payment, and credit activity.

Cash receipt records

Cash receipts show collections received during the period.

Journal entries and adjustment records

These records show manual corrections, reclassifications, and write-offs.

Credit notes and write-off documentation

Credit notes and write-offs support reductions to customer balances.

Step 1: Confirm the Reconciliation Period

Start by defining the period and ownership.

Verify opening and closing balances

Confirm beginning and ending balances for the AR subledger and GL.

Confirm reporting cut-off dates

Make sure invoices, receipts, credits, and write-offs are included in the correct period.

Validate reconciliation ownership

Assign a preparer, reviewer, and issue owner for unresolved items.

Step 2: Compare the Accounts Receivable Aging Report with the General Ledger

This step checks whether customer-level records agree with the GL.

Match total customer balances to the AR control account

Add the AR aging report total and compare it with the GL AR control account.

Identify any balance differences

Record the difference between the subledger total and GL balance.

Separate explained and unexplained variances

Explained variances may come from timing. Unexplained variances need investigation.

Step 3: Investigate Reconciliation Differences

Investigation confirms why the records differ.

Review missing invoices and payments

Check whether invoices or receipts are missing from either the subledger or GL.

Check duplicate postings

Look for duplicate invoices, duplicate receipts, or repeated journal entries.

Validate credit memos and adjustments

Confirm that credit notes, discounts, write-offs, and adjustments are approved and posted correctly.

Review unapplied cash and payment allocations

Unapplied cash and incorrect payment allocation are common AR reconciliation issues.

Step 4: Record and Approve Corrections

Corrections should be controlled and documented.

Prepare correcting journal entries

Create entries only after confirming the cause of the difference.

Obtain approval for adjustments

Adjustments, write-offs, and reclassifications should be approved before posting.

Update supporting schedules after corrections

After corrections, update aging reports, customer records, and reconciliation schedules.

Step 5: Verify the Final Reconciled Balance

The final step confirms completion.

Confirm the subledger agrees with the general ledger

The AR aging total should match the GL AR control account after valid adjustments.

Review remaining outstanding items

Any open item should have an explanation, owner, and expected resolution date.

Complete reconciliation documentation and sign-off

Document evidence, corrections, open items, preparer details, and reviewer approval.

Example of Accounts Receivable Reconciliation

A simple example shows how AR reconciliation works.

Beginning AR balance

Assume the GL AR balance is $120,000.

Customer invoices and cash receipts

The AR aging report totals $118,500 after customer invoices, receipts, and credit notes are included.

Identification of reconciliation differences

Finance identifies one missing $2,000 invoice in the subledger and one duplicate $500 receipt in the GL.

Adjustment process

The missing invoice is added to the subledger, and the duplicate receipt is reversed in the GL after approval.

Final reconciled balance

After corrections, the subledger and GL both reconcile to $120,500.

Common Accounts Receivable Reconciliation Differences

Several recurring differences can appear during AR reconciliation.

Unapplied customer payments

Payments may be received but not applied to an invoice.

Duplicate invoices or receipts

Duplicate records can overstate receivables or collections.

Missing journal entries

A required GL entry may not post.

Credit notes not recorded

A customer credit may be missing from the ledger or subledger.

Customer disputes and payment shortfalls

Disputes and short payments leave open balances requiring review.

Timing differences between cash receipt and posting

Cash may be received before accounting records update.

How Customer Payment Issues Affect Reconciliation

Customer payment behavior often creates AR differences.

Partial payments

A customer may pay only part of an invoice.

Split payments across invoices

One payment may need to be allocated across several invoices.

Advance customer payments

Advance payments may appear before invoices are issued.

Overpayments and underpayments

Overpayments and underpayments require investigation and correct allocation.

How Credit Notes and Write-Offs Influence Accounts Receivable Balances

Credits and write-offs reduce receivable balances and require support.

Customer returns and billing adjustments

Returns or billing corrections may create credit notes.

Bad-debt write-offs

Bad-debt write-offs reduce receivables when collection is no longer expected.

Approval requirements before posting adjustments

Write-offs and credit adjustments should have approval.

Supporting documentation for audit purposes

Documentation should show customer communication, approval, reason, and posting details.

How Accounts Receivable Reconciliation Supports Month-End Close

AR reconciliation supports a cleaner close process. It is also one part of the broader general ledger reconciliation process, where finance teams validate every significant balance before financial statements are finalized. 

Validation of receivable balances before reporting

Validated receivables reduce the risk of misstated assets.

Reduction of post-close adjustments

Early reconciliation reduces late corrections.

Faster review and approval processes

Clean schedules allow reviewers to approve faster.

Greater confidence in reported receivables

Accurate AR balances improve reporting confidence.

Accounts Receivable Reconciliation in Multi-Entity Organizations

Multi-entity organizations need stronger reconciliation discipline.

Shared ERP environments

Shared systems require clear entity-level ownership and account mapping.

Multiple legal entities and customer accounts

Customer activity may span entities, regions, and currencies.

Cross-border invoicing and currency conversion differences

Exchange-rate timing can create reconciliation differences.

Centralized versus decentralized reconciliation ownership

Centralized teams need consistent standards, while local teams need clear reporting responsibilities.

Risks of Managing Accounts Receivable Reconciliation Through Spreadsheets

Spreadsheets can create control issues as AR volume grows.

Version-control issues

Multiple versions can create conflicting reconciliation results.

Formula and manual-entry errors

Manual calculations increase the chance of error.

Limited visibility into outstanding customer balances

Open items may be scattered across files.

Difficulty maintaining audit-ready documentation

Audit support can be hard to locate if records are spread across emails and folders.

Controls That Improve Accounts Receivable Reconciliation

Controls improve accuracy and accountability.

Segregation of billing, collections, and reconciliation responsibilities

Different roles reduce conflict and support better review.

Standardized reconciliation procedures

Consistent steps improve reconciliation quality.

Approval workflows for adjustments and write-offs

Adjustments should be approved and documented.

Documentation standards supporting audits

Each reconciliation should include schedules, source records, explanations, approvals, and sign-off.

Metrics That Measure Accounts Receivable Reconciliation Performance

Metrics reveal whether AR reconciliation is working.

Percentage of reconciliations completed on time

This shows close readiness.

Number of unresolved customer balance differences

Open differences show account risk.

Aging of unreconciled items

Older items require escalation.

Frequency of manual adjustments

Frequent manual entries may indicate upstream issues.

Close delays linked to receivable reconciliation issues

Close delays show where AR review needs attention.

How Automation Improves Accounts Receivable Reconciliation

Automation helps finance teams reduce manual matching and improve visibility.

Automated matching of invoices and customer payments

Systems can match invoices, receipts, credits, and customer balances.

Continuous validation of subledger and general ledger balances

Automated review can compare the AR subledger with the GL throughout the period.

Real-time visibility into reconciliation exceptions

Finance teams can track open items, owners, aging, and status.

Centralized management of supporting documentation

Automated records help centralize invoices, receipts, approvals, write-offs, and reconciliation evidence.

What High-Performing Finance Teams Do Differently

Strong finance teams resolve AR differences early.

Reconcile receivable balances throughout the reporting period

They do not wait until month-end to identify mismatches.

Resolve unapplied cash promptly

Unapplied cash is assigned and cleared quickly.

Review recurring customer discrepancies

Recurring issues are reviewed for root causes.

Assign ownership for reconciliation exceptions

Every unresolved item has an owner and expected resolution date.

Future Direction of Accounts Receivable Reconciliation

AR reconciliation is moving toward continuous validation and better exception visibility.

AI-assisted identification of unusual customer-account activity

AI can flag unusual payments, duplicate invoices, and unexpected balance changes.

Predictive detection of receivable reconciliation risks

Predictive checks can identify accounts likely to create close issues.

Continuous reconciliation across connected finance systems

Continuous reconciliation reduces period-end pressure.