Accounts Receivable Reconciliation in QuickBooks Online
An A/R balance can look reasonable while hiding old invoices, misplaced payments, and credits that no one applied. Accounts receivable reconciliation gives you a reliable way to catch those issues before they distort cash flow, customer follow-up, or financial statements.
For QuickBooks Online users, the job is not a bank-style reconciliation. You compare customer-level detail with the Accounts Receivable balance in the general ledger, then trace every difference to its source.
Start with a consistent report date and accounting basis. That one discipline prevents many month-end surprises.
Know What You Are Comparing
Accounts Receivable has two connected parts. They should support each other, but they are not the same record.
The A/R subledger shows each customer's balance
The A/R subledger is the customer-level detail behind what clients owe. In QuickBooks Online, this information appears in reports such as:
- Accounts Receivable Aging Summary
- Accounts Receivable Aging Detail
- Open Invoices
- Customer Balance Detail
These reports show invoices, payments, credit memos, and other transactions by customer. If a client owes $2,400 across two invoices, that amount should appear in the customer reports until payment or a valid credit clears it.
The Aging Detail report is often the best place to investigate because it shows the individual transactions behind the total.
The general ledger control account shows one total
The Accounts Receivable account on your Balance Sheet is the general ledger control account . It is the single total that should equal all open customer balances combined.
For example, if the customer reports show $38,750 due from all customers, the Accounts Receivable line on an accrual-basis Balance Sheet should also show $38,750 as of the same date.
A clean A/R reconciliation does not mean every customer paid on time. It means the customer detail and the general ledger agree on exactly what remains unpaid.
When they do not agree, do not post a quick journal entry to force a match. First, identify why the records differ.
Run the Right Reports on the Same Date
A comparison only works when every report uses the same cutoff date. Running an aging report through August 31 and a Balance Sheet through September 1 can create a difference that is only timing.
Use accrual-basis reports for the tie-out
For accounts receivable reconciliation, use accrual-basis reports. Accrual reporting recognizes income when you create the invoice, even if the customer has not paid.
Cash-basis reports can omit or alter the presentation of unpaid invoices because cash has not arrived. That makes cash-basis reporting useful for some tax and cash-flow discussions, but it is not the cleanest view for tying customer balances to the A/R control account.
QuickBooks Online screens and report options can differ by subscription level or interface update. Look for the reporting date and accounting-method settings available in your version, then confirm each report uses the same choices.
Build a simple month-end comparison
Run these reports as of the final calendar day of the month:
| Report | What to compare | Expected result |
|---|---|---|
| Accrual Balance Sheet | Accounts Receivable balance | Matches the aging total |
| A/R Aging Summary | Total amount customers owe | Matches the Balance Sheet A/R |
| A/R Aging Detail | Open transactions by customer | Adds up to the aging summary |
| Open Invoices | Unpaid invoice detail | Supports invoice-related balances |
Save PDFs or exports of the reports before making corrections. If the books change later, you will still have proof of what differed and when you found it.
The Aging Summary gives you the headline number. The Aging Detail gives you the trail needed to solve the mismatch.
A Practical Accounts Receivable Reconciliation Process
QuickBooks Online's standard Reconcile feature is designed for bank and credit card accounts. A/R requires a report comparison and transaction review instead.
Compare totals before touching transactions
First, write down the Accounts Receivable total from the accrual Balance Sheet. Next, write down the total from the A/R Aging Summary for the same date.
If both totals agree, scan the Aging Detail anyway. A matching total can still conceal an old customer credit, a payment applied to the wrong invoice, or a balance assigned to the wrong client.
If the totals differ, calculate the exact variance. A difference of $500, $2,000, or $14,826 is a useful clue. It often points to a specific transaction or group of transactions.
Then review the A/R Aging Detail, Open Invoices report, and the Accounts Receivable register. Filter the register for the same reporting period if your version provides that option.
Trace the difference in a logical order
Work from the most common causes to the less frequent ones:
- Review unapplied customer payments and credits.
- Look for journal entries posted directly to Accounts Receivable.
- Check edited, deleted, voided, or backdated transactions.
- Review opening balance entries and historical conversion activity.
- Confirm that all reports use the same date and accrual basis.
- Investigate bad-debt write-offs, refunds, and returned payments.
Keep a reconciliation worksheet with the date, difference amount, cause, corrective action, and the person who reviewed it. That record turns a one-time cleanup into a repeatable close process.
For customer payments that remain open or sit on the wrong invoice, use this QuickBooks Online unapplied cash cleanup guide to review the customer side before changing the general ledger.
Find Unapplied Payments, Credits, and Date Errors
Many A/R differences come from transactions that are valid but incomplete. The money or credit exists, yet it has not been connected to the invoice it should clear.
Unapplied cash can leave invoices open
An unapplied payment may show as a customer credit while the original invoice still appears unpaid. This often happens when staff record a payment but do not select the invoice during the application step.
A customer may have paid $1,000 in full. Yet the aging report can still show a $1,000 invoice open and a separate negative $1,000 payment. The net customer balance may be zero, but the open invoice list and aging buckets become misleading.
Customer overpayments can also create credits. Keep them as credits until you apply them to a future invoice or refund them. Do not record the overpayment as new income.
When deposits are received before work is complete, they may belong in a liability account rather than A/R or sales. The correct treatment depends on the contract and whether the amount is refundable. Review customer deposits in QuickBooks Online before applying advance payments to invoices.
Credit memos, refunds, and incorrect dates need support
A credit memo reduces an amount a customer owes after you have billed them. A refund receipt records money returning to the customer. Those forms do different jobs, so using the wrong one can leave a confusing open balance.
Also check transaction dates. A September payment dated August 31 affects August A/R reports. An invoice dated in the wrong month can make one period appear overstated and the next one understated.
Review the original invoice, payment, credit, bank deposit, and supporting email or contract before changing dates. Avoid moving transactions merely to make a report match.
Review Direct Entries, Opening Balances, and Bad Debt
Direct entries to Accounts Receivable require more care than regular invoices and payments. They can change the control account without creating clean customer-level detail.
Journal entries can break the customer trail
A journal entry that posts to Accounts Receivable should generally include a customer name on the A/R line. Without a customer, the general ledger may change while the customer subledger does not support the change.
This issue often appears after year-end adjustments, accountant entries, or a rushed cleanup. Search the Accounts Receivable register for journal entries, then inspect each one.
Do not reverse or edit an accountant's entry without discussing it first. It may relate to an accrual adjustment, prior-period correction, or tax filing position.
If a material adjustment is needed, document the business reason, source records, account impact, period affected, and whether the entry must reverse next month.
Opening balances can create orphaned A/R amounts
When a business starts using QuickBooks Online, opening balances may be entered to establish historical totals. If the Accounts Receivable opening balance was entered without customer-by-customer invoices, the Balance Sheet can carry a balance that does not appear in the Aging Detail report.
The right fix depends on the conversion date and records available. Sometimes the answer is to recreate valid open invoices. In other cases, an accountant may need to post a supported adjustment.
Bad debt is another area where timing matters. If an invoice is no longer collectible, writing it off should clear the customer's receivable and record the proper expense or allowance treatment for your books.
The tax result can differ from the book entry. The IRS explains that cash-method taxpayers generally cannot deduct unpaid fees they never included in income, while accrual-method businesses may face different rules. Review the IRS guidance on the business bad debt deduction with your tax professional before treating a write-off as deductible.
Handle Edits, Deletions, and Returned Payments Carefully
A/R can drift after a transaction changes, even when the original entry was correct. That is why reconciliation should include a review of audit history and unusual activity.
Look for altered or removed transactions
A deleted invoice, edited payment, changed customer name, or modified account can alter the A/R control account or customer balance. Check the audit log or transaction history available in your QuickBooks Online file, particularly when a difference appears suddenly.
Focus on activity posted after the prior month was closed. A staff member may have corrected a customer payment in July but dated it back to May. The books then change in a period you thought was finished.
Locking completed periods, with appropriate access controls, reduces accidental edits. Still, a lock date does not replace monthly review.
Returned checks affect cash and A/R
When a customer's check bounces, the cleanup must reopen the receivable and reverse the cash effect. Recording another payment or another invoice can create duplicate income and hide the unpaid balance.
Match the bank reversal to the original payment. Then reopen the invoice or record the returned-payment workflow your company uses. Post any bank NSF fee separately to the appropriate expense account.
The customer should show the real unpaid amount after the returned check. If they later replace it, enter a new payment and apply it to the open invoice.
Document Adjustments Before Posting Them
A journal entry should be the final response to a confirmed difference, not the first move. A forced entry can make the Balance Sheet look clean while leaving customer records wrong.
Before posting any adjustment, retain the reports, invoices, payment records, credit memos, bank support, and explanation of the issue. State whether the correction affects revenue, a refund, bad debt, an opening balance, or another account.
The IRS small business tax guide discusses accounting methods and business tax topics that can affect year-end decisions. For material differences, prior-year corrections, bad-debt treatment, or tax-sensitive entries, consult an accountant before changing the books.
A monthly A/R review also works best alongside bank reconciliation. The bank confirms cash received. The A/R tie-out confirms that customer balances behind those receipts remain accurate.
Conclusion
Accurate accounts receivable reconciliation comes down to one clear test: the accrual-basis A/R Aging total should match the Accounts Receivable control account on the Balance Sheet as of the same date.
When the numbers differ, trace the cause through customer-level transactions before posting an adjustment. Unapplied payments, credits, date errors, opening balances, direct journal entries, and bad-debt activity all leave clues when you review the detail patiently.
A documented monthly process protects both your financial statements and the customer records your team relies on to collect payment.
