01
Different report dates
A/R Aging and Balance Sheet reports must be compared for the same date and, where relevant, the same accounting basis. A simple date mismatch can create an apparent difference.
QuickBooks • Accounts Receivable
Why Doesn't Accounts Receivable Match in QuickBooks?
When your A/R Aging report does not match the Accounts Receivable balance on the Balance Sheet, do not immediately post a plug entry. First find the transaction causing the difference.
A/R Aging
Balance Sheet
Customer Detail
Mismatch example
Find the gap
A/R
A/R Aging
$48,250
Balance Sheet
$50,250
Difference to investigate: $2,000
Do not “fix” the difference until you know what caused it.
Answer first
The two reports should tell the same A/R story—when they are built on the same basis
A common QuickBooks problem is seeing one A/R number in the customer aging report and a different number on the Balance Sheet. The gap can come from the report date, unapplied customer payments or credits, transactions posted directly to A/R, deleted or changed transactions, or historical cleanup problems.
The safest approach is to work from the difference back to the transaction, not from the desired ending balance back to a journal entry.
Common causes
9 reasons QuickBooks A/R may not match
02
Unapplied customer payments
A payment received from a customer may exist in QuickBooks without being properly applied to the related invoice. This can leave customer-level activity that needs investigation.
03
Unapplied credits or credit memos
Customer credits can reduce what a customer owes without being applied to a specific invoice. Old credits are a frequent reason A/R becomes hard to interpret.
04
Journal entries posted to A/R
Direct journal entries to Accounts Receivable can change the ledger without behaving like normal invoice-and-payment activity in the customer subledger.
05
Old opening balance problems
Historical migrations, opening balances, or prior cleanup entries can leave old A/R balances that no longer tie to the detailed customer records.
06
Deleted, edited, or re-dated transactions
Changes to invoices, payments, credits, or dates can alter the relationship between the customer detail and the general ledger.
07
Multiple A/R accounts
Businesses that created more than one Accounts Receivable account can accidentally compare one account on the Balance Sheet with a customer report that covers a different setup.
08
Transactions posted to the wrong account
A receipt, invoice adjustment, or other transaction classified outside the expected A/R flow can make customer balances and the ledger tell different stories.
09
Historical books need a structured cleanup
If a company has years of stale invoices, credits, manual entries, and unmatched payments, the mismatch may be a symptom of a larger bookkeeping problem. In that situation, correcting only the ending A/R number can make the books look cleaner while leaving the underlying records wrong.
Diagnostic workflow
Find the difference in the right order
A structured review is faster than clicking through random invoices. Work from the report-level difference into the customer transactions that created it.
1
Lock the date
Run both reports for the exact same as-of date. Record the difference.
2
Confirm the A/R account setup
Make sure the Balance Sheet account and customer reporting structure are actually referring to the same A/R setup.
3
Review unapplied cash and credits
Look for customer payments, credits, or adjustments that have not been cleanly applied.
4
Search for direct A/R journal entries
Investigate entries that hit A/R without a normal invoice/payment flow.
5
Trace old balances by customer
Prioritize large or unusually old items. Identify the original transaction before making a correction.
6
Document the correction
Keep a clear explanation of what changed, why it changed, and what supporting records were reviewed.
Important
Don't force A/R to the number you want
A journal entry may make the Balance Sheet look closer to the aging report, but it can leave individual customers with incorrect balances. That creates a bigger problem when the next payment arrives or the CPA reviews the file.
Avoid
Blind plug entries
Do not post an unexplained adjustment just to make two reports equal.
Prefer
Source-level cleanup
Correct the invoice, payment, credit, or historical entry that caused the difference.
Document
Keep an audit trail
Record the reason, date, amount, and supporting documentation for significant fixes.
Recheck
Run reports again
Confirm the detailed customer records and Balance Sheet tell the same story after cleanup.
A/R cleanup checklist
Before you close the books, confirm these items
✓
Same report date
A/R reports use the same as-of date for comparison.
✓
Old customer balances reviewed
Large and aging balances have a documented explanation.
✓
Payments applied correctly
Unapplied customer cash has been investigated.
✓
Credits reviewed
Old credits and credit memos have a clear treatment.
✓
Direct A/R entries reviewed
Journal entries touching A/R are explained and supported.
✓
Final tie-out completed
Customer detail and the Balance Sheet agree after cleanup.
Related Accountrise guides
Keep your QuickBooks books clean from both sides of the ledger
FAQ
QuickBooks A/R questions
Why doesn't Accounts Receivable match the Balance Sheet in QuickBooks?
The difference can come from report dates, unapplied payments or credits, direct A/R journal entries, historical opening balances, changed transactions, multiple A/R accounts, or other posting issues.
Can a payment make QuickBooks A/R incorrect?
Yes. A payment can exist without being properly applied to the related invoice. Review customer payment activity and unapplied cash before making an adjustment.
Should I make a journal entry to fix an A/R mismatch?
Usually, no. Start by tracing the underlying invoice, payment, credit, or historical transaction. A journal entry may change the ledger without correcting customer-level detail.
How do I clean up old Accounts Receivable in QuickBooks?
Begin with an A/R aging report, investigate old balances by customer, trace invoices and payments, review credits and unapplied cash, verify opening balances, and document approved corrections or write-offs.
Need help cleaning up QuickBooks?
Get your A/R, Balance Sheet, and customer records telling the same story.
Accountrise helps small businesses clean up QuickBooks, reconcile accounts, investigate historical differences, and build a reliable monthly bookkeeping process.
Starting at $10/hour. Final pricing depends on scope, transaction volume, complexity, and engagement requirements.