Reconciling accounts receivable: A guide for finance teams

If your books say one thing and your bank says another, you've got a reconciliation problem. Reconciling accounts receivable is one of the most important financial hygiene practices a business can maintain, and yet it's one of the most commonly delayed, avoided, or misunderstood tasks on a finance team's to-do list.

This guide breaks down exactly what accounts receivable reconciliation is, why it matters, how to do it well, and the best practices that separate high-performing revenue teams from those who spend their quarter-end scrambling to find a $3,000 discrepancy.

Whether you're a controller, a CFO, or a founder who wears too many hats, we'll walk you through everything you need to know.

What is accounts receivable reconciliation?

It confirms that every invoice issued, payment received, credit given, and outstanding balance is accurately recorded, so the AR balance on the balance sheet reflects reality.

Think of it as a balancing act.

On one side, you have your accounts receivable subledger (the detailed, customer-by-customer record of every open invoice).

On the other side, you have your general ledger (the summary-level financial record that feeds into your balance sheet).

Reconciling accounts receivable means making sure those two numbers agree.

If they don't match, something has gone wrong: a payment was posted incorrectly, an invoice was duplicated, a credit memo wasn't applied, or a write-off wasn't recorded. The reconciliation process is how you find and fix those issues before they compound.

What it involves:

• Matching records: Comparing the AR subledger (detailed list of individual customer balances) against the general ledger control account
• Verifying payments: Confirming that payments received from customers have been correctly applied to the right invoices
• Identifying discrepancies: Spotting errors like duplicate entries, unapplied payments, or missing invoices
• Reviewing aging reports: Checking how long invoices have been outstanding (30, 60, 90+ days) to flag overdue accounts
• Adjusting for credits/write-offs: Accounting for credit notes, disputes, or bad debts that reduce the balance

Here's a quick breakdown of the key terms:

Why reconciling accounts receivable matters

It's tempting to treat AR reconciliation as a box-ticking exercise. It isn't.

Here's why it actually matters.

Your financial statements depend on it. If your AR balance is overstated, your revenue and assets look healthier than they are. If it's understated, you could be missing revenue that's legitimately yours. Either way, your balance sheet and income statement are wrong, and any decisions made from those numbers are built on a shaky foundation.

It surfaces cash flow problems early. According to research by Atradius, 48% of all B2B invoices in the US are paid late. Regular reconciliation forces you to confront AR aging before invoices become bad debt, giving your team the chance to follow up while payment is still likely.

It protects against fraud and error. Duplicate payments, ghost invoices, and improper credits can go undetected for months or years without consistent reconciliation. A 2024 report from the Association of Certified Fraud Examiners found that the median loss in billing fraud schemes was $100,000, and the median duration before detection was 12 months.

It keeps your auditors happy. For businesses undergoing an audit, a clean and current AR reconciliation is non-negotiable. Auditors will look at whether your AR subledger ties to your general ledger as a basic test of internal controls.

The cost of not doing it is real. Research by GETPAID and Amalto found that incorrect invoices are responsible for 61% of late payments, and a Forrester study commissioned by Versapay found that organizations spend an average of $24,000 annually resolving manual cash application errors. Unreconciled AR is rarely a harmless administrative gap — it compounds.

How the AR reconciliation process works: A visual overview

The diagram below shows how money flows through your AR process and where reconciliation fits in.

Customer invoice issued
         │
         ▼
  AR subledger updated
  (open invoice recorded)
         │
         ▼
  Customer pays
         │
    ┌────┴────────────────────────────────┐
    │                                     │
    ▼                                     ▼
Payment applied to              Payment posted to
open invoice in subledger         general ledger
    │                                     │
    └──────────────┬──────────────────────┘
                   │
                   ▼
        ┌──────────────────────┐
        │  RECONCILIATION      │
        │  Subledger total     │
        │  vs GL balance       │
        │  Variance = $0?      │
        └──────┬──────────────-┘
               │
       ┌───────┴───────┐
       ▼               ▼
    YES: done      NO: investigate
                   → find root cause
                   → correct journal entry
                   → re-confirm zero variance

When both sides of that comparison equal zero, your books are clean.

How to reconcile accounts receivable: 7-step guide

If you're wondering how to reconcile accounts receivable, the good news is that the process is logical and repeatable once you understand the moving parts.

Here's the standard approach.

Step 1: Pull your AR aging report

Start by generating an AR aging report from your billing or accounting system. This report lists every open invoice, organized by customer and by how long each invoice has been outstanding (e.g., 0-30 days, 31-60 days, 61-90 days, 90+ days).

The total of all open invoices on your aging report is your AR subledger balance. Write that number down, because this is what you're reconciling.

Step 2: Pull your general ledger AR balance

Next, pull the AR account balance from your general ledger as of the same date. This is typically listed under current assets on your balance sheet.

Step 3: Compare the two balances

This is the core of how to reconcile accounts receivable to the general ledger. Subtract one from the other:

If the variance is zero, you're done. If it isn't, you have work to do.

Step 4: Investigate the variance

A non-zero variance means there's a discrepancy somewhere. Common culprits include:

• Payments posted to the GL but not applied to invoices in the subledger
• Invoices created in the subledger but not yet posted to the GL
• Unapplied credit memos sitting in limbo
• Write-offs recorded in one place but not the other
• Timing differences from month-end close cutoffs
• Data entry errors (transpositions, duplicate entries)

Work through the variance line by line. Match transactions between your subledger and your GL until you've accounted for every dollar of difference.

Step 5: Make correcting journal entries

Once you've identified the source of each discrepancy, record the necessary journal entries to bring the two sides into agreement. Every adjustment should be documented with a clear explanation so your team (and any auditor) can follow the audit trail.

Step 6: Confirm the balances match

Re-run your reports after posting corrections. Confirm that the AR subledger total matches the GL balance. If yes, your reconciliation is complete. File your supporting documentation and note the date.

Step 7: Review your aging for follow-up actions

Now that your books are clean, use the aging report to prioritize collections. Invoices in the 60+ day bucket deserve immediate attention. Anything in the 90+ day bucket should trigger a decision: escalate to collections, negotiate a payment plan, or consider a write-off.

How to reconcile accounts receivable in Excel

Many smaller teams still manage their reconciliation process in Excel, and there's nothing wrong with that, as long as you do it consistently. Here's a simple approach to reconciling accounts receivable in Excel:

1. Export your AR aging report from your billing system (e.g., CSV format)
2. Import it into Excel and create a pivot table summing the open balance by customer
3. Pull your GL AR balance from your accounting software and enter it into a separate cell
4. Create a variance cell using a simple formula: =SUM(AR_subledger) - GL_balance
5. Flag any discrepancies using conditional formatting (red for non-zero variances)
6. Build a reconciliation tab that documents each identified variance and its resolution

One practical tip: always date-stamp your reconciliation file and save a copy before making changes. It's easy to lose track of what the numbers looked like before corrections when you're working in a live spreadsheet.

That said, Excel has real limits. Version control is manual, collaboration is messy, and formulas break. If your AR volume is growing, it's worth exploring a more automated approach.

How to reconcile accounts receivable in QuickBooks and QuickBooks Online

QuickBooks and QuickBooks Online are among the most common accounting platforms for small and mid-sized businesses, so it's worth addressing how to reconcile accounts receivable in QuickBooks directly.

QuickBooks doesn't have a dedicated "AR reconciliation" workflow in the same way it does for bank accounts. Instead, the process involves:

1. Run the A/R Aging Summary report (Reports > Customers and Receivables > A/R Aging Summary)
2. Note the total outstanding balance at the top of the report
3. Run a Balance Sheet as of the same date and find the Accounts Receivable line
4. Compare the two numbers. In a well-maintained QuickBooks file, these should match automatically
5. If they don't match, run the Open Invoices report and the Transaction List by Customer report to find transactions that aren't properly linked
6. Look for undeposited funds or payments that were received but not applied to invoices
7. Check for voided transactions that may have created orphaned entries

For QuickBooks Online specifically, the interface is slightly different but the logic is the same. The Accounting menu gives you access to the Chart of Accounts, where you can click on the AR account and review every transaction that has hit it. Filtering by date and comparing to your aging report is the fastest way to identify discrepancies.

A common issue in QuickBooks: payments entered as bank deposits rather than customer payments. These reduce your bank balance correctly but don't apply against open invoices, creating a gap between your aging report and your GL.

How to reconcile accounts payable and receivable

It's worth briefly addressing how to reconcile accounts payable and receivable together, since the two processes are related but distinct.

Accounts payable (AP) is what you owe to vendors. Accounts receivable is what customers owe you. When you reconcile both, you're getting a complete picture of your short-term cash obligations and expected inflows.

The reconciliation process is structurally the same for both:

• Pull the subledger balance (open invoices owed to vendors for AP, open invoices owed by customers for AR)
• Pull the general ledger balance for the same account
• Identify and resolve any variances

The reason they're often done together at month-end is that your net working capital calculation depends on both. A clean AP reconciliation tells you what you owe. A clean AR reconciliation tells you what's coming in. Together, they give you a realistic view of liquidity.

One practical note: if your business both buys from and sells to the same company (a vendor who is also a customer), you may need to consider netting agreements or careful treatment of intercompany transactions to avoid double-counting.

Best practices for reconciling accounts receivable

Knowing how to reconcile is half the battle. Doing it consistently and well is the other half.

Here are the practices that separate high-performing finance teams from those who are always playing catch-up.

Reconcile at a regular cadence

The single most impactful thing you can do is reconcile on a fixed schedule, not just at year-end when your auditors are knocking. Most finance teams reconcile AR monthly, aligned with their close cycle. High-volume businesses may reconcile weekly.

The longer you wait between reconciliations, the harder it is to trace discrepancies back to their source. Memories fade, systems get updated, and small errors compound into big ones.

Keep your AR aging report current

Your AR aging report is only useful if it's accurate. That means applying payments promptly when they're received, issuing credit memos in a timely way, and reviewing unapplied cash on a weekly basis.

An aging report full of stale, unapplied entries is a warning sign, both for reconciliation accuracy and for your collections process.

Document every adjustment

Every correcting journal entry should have a clear description: what the variance was, why it occurred, and what was done to fix it. This documentation is essential for audits and is genuinely useful when the same issue reappears six months later (and it often does).

Separate the person who records from the person who reconciles

If the same person creates invoices, applies payments, and performs the reconciliation, you have a segregation-of-controls problem. This is how errors (and fraud) go undetected. Where possible, have a different team member review and sign off on the reconciliation.

Set a materiality threshold for investigation

Not every penny-level discrepancy requires a full investigation. Set a materiality threshold (e.g., any variance greater than $50 or 0.1% of total AR) and focus your investigation time accordingly. Document your threshold so it's applied consistently.

Automate where you can

Manual reconciliation is time-consuming and error-prone. A 2025 survey by MineralTree found that 85% of finance teams using automation tools report greater efficiency, with 63% seeing improved payment timeliness. Meanwhile, research by PYMNTS found that 91% of mid-sized firms with fully automated AR systems report increased savings, cash flow, and growth.

We cover how automated AR workflows can cut reconciliation time significantly in our guide to streamlining your billing operations.

Review your write-off policy regularly

Uncollectible receivables that sit on your aging report indefinitely distort your AR balance and inflate your revenue figures. Set a clear policy for when invoices move to a write-off: for example, after 180 days with no payment and no payment arrangement in place. Review and apply that policy at least quarterly.

Common AR reconciliation mistakes to avoid

Even experienced finance teams fall into these traps. Here's what to watch for:

• Reconciling to the wrong date. Your AR aging report and your GL balance must be pulled as of the exact same date, or the comparison is meaningless.
• Ignoring unapplied cash. Payments sitting in a suspense account or "unidentified receipts" bucket are a ticking clock. Apply them promptly or they'll create persistent reconciliation headaches.
• Treating the reconciliation as a formality. If you reconcile but don't investigate variances, you're just confirming that a problem exists without fixing it.
• Relying on manual processes at scale. As your invoice volume grows, manual reconciliation in spreadsheets becomes increasingly unreliable. The error rate goes up as the volume goes up.
• Not reconciling before period-end close. If you close your books before completing your AR reconciliation, you're locking in errors that will be much harder to correct later.

A quick-reference reconciliation checklist

Use this checklist at the end of each period to make sure nothing falls through the cracks:

1. Pull AR aging report as of period-end date
2. Pull GL AR balance as of the same date
3. Calculate variance (subledger total minus GL balance)
4. Investigate all variances above your materiality threshold
5. Record correcting journal entries with supporting documentation
6. Confirm both balances agree after corrections
7. Review aging for invoices 60+ days outstanding
8. Apply or write off stale unapplied cash
9. Sign off and file reconciliation documentation
10. Flag any systemic issues for process improvement

Frequently asked questions about reconciling accounts receivable

What is the difference between accounts receivable and accounts payable?
Accounts receivable is money that customers owe to your business for goods or services you've already delivered. Accounts payable is money that your business owes to vendors or suppliers for goods or services they've delivered to you. AR is an asset on your balance sheet; AP is a liability. Both require regular reconciliation to ensure your books are accurate.

How often should you reconcile accounts receivable?
Most finance teams reconcile AR monthly, aligned with their period-end close cycle. However, high-risk accounts like cash and receivables benefit from more frequent review — many teams that process high invoice volumes reconcile weekly, or even daily. The general rule: the higher your transaction volume, the more frequently you should reconcile.

What causes a discrepancy between the AR subledger and the general ledger?
The most common causes are payments posted to the GL but not applied to open invoices, invoices created in the subledger but not yet posted to the GL, unapplied credit memos, write-offs recorded in only one system, timing differences around period-end cutoffs, and data entry errors such as transpositions or duplicate entries.

How do you reconcile accounts receivable to the general ledger?
Pull your AR aging report total as of the period-end date, then pull your GL AR account balance as of the same date. Subtract one from the other. If the variance is zero, they're reconciled. If not, investigate the discrepancy line by line, post correcting journal entries, and re-confirm both totals agree.

What is an AR aging report and why does it matter for reconciliation?
An AR aging report lists all outstanding customer invoices, grouped by how long they've been unpaid (typically 0-30, 31-60, 61-90, and 90+ days). It's the primary source for your AR subledger total, which you compare against your GL balance during reconciliation. It's also a key collections management tool: the aging buckets tell you which customers to prioritize for follow-up. A 47% of US small businesses report having invoices more than 30 days overdue, making a current aging report essential for proactive cash flow management.

Can you reconcile accounts receivable in QuickBooks?
Yes. In QuickBooks Desktop, run the A/R Aging Summary report and compare the total to your Balance Sheet AR line as of the same date. In QuickBooks Online, access the AR account via the Chart of Accounts and compare transactions to your aging report. If there's a gap, look for payments entered as bank deposits rather than customer payments, unapplied credits, or voided transactions with orphaned entries.

Putting it all together

Reconciling accounts receivable isn't glamorous work, but it's foundational. It's how you catch errors before they become costly, surface cash flow risks before they become crises, and maintain the financial credibility that every business decision depends on.

The good news is that with a clear process, a consistent cadence, and the right tools, AR reconciliation doesn't have to be the painful end-of-month scramble it often becomes. Start with the basics: know your numbers, reconcile regularly, and document everything.

If you're looking to take your AR process further, explore how Alguna's revenue automation platform helps revenue teams automate billing, reduce reconciliation time, and close their books with confidence.