Partner, SDO CPA LLC / CEO, Growthy
Your AR subledger says $42,000. Your general ledger says $41,450. Close can't happen with a $550 gap. Bookkeepers who work with the accounts receivable aging report already have the data they need. This guide shows how to use it to reconcile AR and get the books closed.
Accounts receivable reconciliation is one of the core month-end tasks. It's not just about matching numbers. It means every payment ties to an invoice. Every variance has a cause. Your client's cash position must be right. Unreconciled AR hides errors that compound into bigger problems at year-end.
The process takes four steps. Miss one and the gap stays open.
What is accounts receivable reconciliation?
Accounts receivable reconciliation ties the AR subledger to the GL control account. The AR subledger lists each open invoice by customer. The GL control account is the summary line on the balance sheet. Both should show the same total. When they don't, you have a variance. Reconciling AR means tracing every variance to its source. Fix each one before close. That source might be a partial payment, an unapplied credit, a timing difference, or a duplicate entry. For most small businesses, this runs monthly. A $50 gap left unresolved can become a $500 audit flag by Q4.
The AR subledger is the detail layer. It shows each customer, each invoice, and each open balance. If Acme Corp owes $1,200 and Bright Hall owes $800, the subledger shows two lines totaling $2,000.
The GL control account is the summary. It's one line on the chart of accounts, labeled "Accounts Receivable" or "Trade Receivables." It should show $2,000.
These two numbers must agree. That's what a clean AR close looks like.
Most subledger-to-GL gaps come from one of four causes:
When you reconcile, you're finding these gaps. Every dollar of unexplained difference is a gap. The books can't close with open gaps.
Unreconciled AR creates real problems for your clients.
Cash flow accuracy. If AR is overstated, your client thinks they have more receivables than they do. That shapes decisions on payroll, vendor payments, and draws.
Revenue accuracy. Duplicate invoices inflate revenue. Unapplied credits understate it. Either way, the P&L is wrong.
Year-end risk. A year-end review with unreconciled AR means explaining gaps to the CPA. That's extra billable time and a worse client experience.
Most of these problems are avoidable if reconciliation happens monthly.
The accounts receivable management hub covers how AR fits into the full monthly close cycle.
Run these four steps in order at every period-end.
Export the aged receivables report from your bookkeeping system as of the close date. The report should include:
Date-stamp the export. Don't pull it on the 28th and then close on the 31st. The totals shift and you'll reconcile the wrong numbers.
Keep the export. You'll file it with the reconciliation packet at month-end.
Open the balance sheet or chart of accounts and find the AR control account. Record its ending balance as of the same close date.
Now compare the two totals. If the subledger total matches the GL balance, you have a clean starting point. If they don't match, you have a pre-existing variance to trace before doing anything else. Don't skip this check. Fixing today's transactions on top of a pre-existing gap compounds the error.
Work through each payment received during the period. Every payment should tie to a specific invoice or group of invoices in the subledger. Watch for:
For high-volume clients, this step takes most of the time. The accounts receivable automation guide covers ways to cut the manual matching work for high-volume clients.
This step also connects to broader payment reconciliation. If your client accepts PayPal, Stripe, and ACH alongside invoices, the payment reconciliation hub covers the multi-channel case.
Create a written record of every unresolved difference before you start fixing anything. For each variance, capture:
A simple table or spreadsheet works fine. That's what a good accounts receivable reconciliation template gives you: what doesn't tie and how each item was fixed. Don't fix variances before you've logged them all. Fix as you go and you'll lose track.
Most variances trace back to four sources.
A customer owes $1,000 and pays $900. The subledger still shows a $100 open balance.
Two options:
Don't apply $900 against the full $1,000 invoice and zero it out without a record. That's a write-off. It affects revenue.
A credit memo was issued but never matched to an open invoice. The subledger shows a credit balance on the customer account.
Fix: apply the credit memo to the correct invoice in your bookkeeping system. If there's no match, the credit stays as a liability until it's refunded or used on a future invoice.
A payment came in and was deposited, but it was never matched to a specific invoice. It sits in a clearing or holding account. The bank balance went up, but the AR subledger still shows the invoice as open.
Fix: find the matching invoice and apply the payment. Then clear the holding account entry.
Unapplied cash is the top source of AR drift for high-volume clients. Even a few missed matches per month will add up by year-end.
The same invoice was entered twice. The subledger overstates AR by the invoice amount.
Fix: void the duplicate. Verify that both the GL and subledger reflect the correct single balance after the void.
Here's a concrete April close scenario.
Starting numbers:
Tracing the gap:
You review April transactions. One customer, Apex Solutions, sent a $1,000 payment on April 18. The payment cleared the bank. But in the subledger, only $450 was matched to invoice APX-1044. The remaining $550 is sitting in the "Unapplied Cash" account.
The fix:
Variance resolved. The books can close.
Growthy flags this kind of unapplied cash automatically. It matches payments to open invoices and surfaces the ones it can't resolve for review. About 85% of matches clear on the first import. Growthy doesn't send invoices, run dunning sequences, or factor receivables. For those functions, tools like Bill.com or Invoiced sit in front of the bookkeeping layer.
A reconciliation isn't done when the numbers tie. It's done when you've filed the packet.
Every month, file four documents:
These four make a complete reconciliation packet. Your client's CPA will ask for it at year-end. Filing it monthly saves hours.
If you're creating a standard accounts receivable reconciliation template for a client, the variance log is the core document. It should include columns for:
A signed variance log also helps if a dispute comes up about how a payment was applied.
AR reconciliation should clear before the trial balance locks. For monthly close, finish within the first 10 business days.
High-volume clients (100+ invoices per month) often need weekly reconciliation. It's more work each week but far easier than sorting 400 unmatched transactions at month-end.
For coordinating AR and AP close timing, see accounts receivable vs. accounts payable.
Monthly is standard for most small businesses. Clients with 50+ invoices per month or multiple payment channels should reconcile weekly. It keeps month-end cleanup manageable. Do it at minimum before every close.
The subledger is the detail: each customer, each invoice, each balance. The control account is the summary: one number on the balance sheet. Both represent the same AR total viewed at different levels. Reconciliation confirms they agree.
If the gap is under $10 and you can't trace it in 15 minutes, write it off to a general adjustment account. Document the amount and the decision. Don't let small unresolved balances stack up. $10 per month is $120 at year-end.
Partially. Bookkeeping software can match payments to invoices and flag discrepancies. Growthy matches incoming payments to open invoices and surfaces items it can't resolve for your review. The judgment calls are still yours: write off the partial, refund the credit, or follow up on aging invoices. For invoicing and dunning workflows, tools like Bill.com or Invoiced handle that layer.
Growthy is bookkeeping software, not a CPA firm. This content is educational, not professional advice.
Free during alpha. Read-only access. You review every sync.
Bobby Huang • Partner, SDO CPA LLC / CEO, Growthy
CPA firm partner who got tired of watching bookkeepers click categorize 500 times a day. Built Growthy to fix it.
View author profileGrowthy is dedicated to helping businesses of all sizes make informed decisions. We adhere to strict editorial guidelines to ensure that our content meets and maintains our high standards.
If your average customer takes 60 days to pay, you're lending them money for free. You might not notice until payroll gets tight. Late collections don't announce themselves. They creep in one overdue invoice at a time.
You sent the invoice three weeks ago. The client loved the work. Now your inbox is quiet and your bank account isn't moving.
