What Causes Accounts Receivable Balances to Be Wrong?
Accounts receivable balances go wrong for predictable bookkeeping reasons. This guide explains what causes wrong receivable balances and how to correct them so your books reflect what customers actually owe.
Accounts receivable balances go wrong for predictable reasons, and most of them are bookkeeping problems rather than customer problems. A customer pays and the payment is never recorded. An invoice is entered twice. A credit memo is never applied. A payment is posted to the wrong customer. Each one leaves your receivables overstated, your aging report inaccurate, and your cash flow picture wrong. This guide explains what causes accounts receivable balances to be wrong and how to correct them so your books reflect what customers actually owe you.
If your receivables have drifted over several months, start with our guide on how to fix messy bookkeeping records to bring your accounts current first. This article focuses on the specific causes of wrong accounts receivable balances and how to correct them.
What Wrong Receivable Balances Mean
Accounts receivable is the money your customers owe you for work you have already done or goods you have already delivered. When the balance is right, it tells you exactly what is outstanding and who owes it. When the balance is wrong, it overstates what you expect to collect, hides customers who have already paid, and makes your cash flow forecast unreliable. A wrong receivable balance is not just a number that is off. It is a signal that a payment was not recorded, an invoice was entered twice, or a credit was never applied.
The damage spreads quickly. Your aging report shows invoices past due that were actually paid. Your balance sheet overstates your assets. Your profit and loss statement may show revenue that was double counted. And your cash flow decisions rest on numbers that do not reflect what is actually coming in. Correcting the receivables is the only way to make the rest of your books trustworthy again.
Common Causes of Wrong Receivable Balances
Accounts receivable balances go wrong for predictable reasons. Understanding the cause tells you which fix to apply.
- Payments received but never recorded. When a customer pays and the payment is not entered against the invoice, the invoice stays open and the receivable stays on your books. The cash is in your bank, but your books still show the customer owes you, which overstates your total receivables.
- Invoices entered twice. When an invoice is recorded twice, the same sale appears twice in your receivables. The customer pays one invoice, but the second copy stays open and ages past due on your report even though nothing is actually owed.
- Payments posted to the wrong customer. When a payment from one customer is applied to another customer with a similar name, the wrong invoice clears and the right one stays open. One receivable goes negative while the other stays overstated, and both balances are wrong.
- Credit memos never applied. When a credit memo is issued but never applied to an open invoice, the credit sits unused and the invoice stays open. The customer has a credit, but your books show a receivable that will never be collected.
- Deposits recorded as income instead of against the invoice. When a customer deposit is recorded as income instead of applied to the matching invoice, the invoice stays open and the deposit is counted twice. Your revenue is overstated and the receivable never clears.
- Bank deposits not matched to invoices. When a bank deposit is recorded without matching it to the specific invoice it pays, the cash lands in your books but the receivable stays open. Over time, your receivables grow while your bank shows the money arrived.
How to Fix Wrong Accounts Receivable Balances
The fix for wrong receivable balances is a disciplined routine that matches every payment to its invoice, clears duplicate and misapplied entries, and reconciles your aging report to your general ledger. Work through these steps in order, every month, until your receivables reflect what customers actually owe.
1. Pull an Accounts Receivable Aging Report
Start by pulling an accounts receivable aging report for the current period. The aging report groups every open invoice by how long it has been outstanding: current, 30 days, 60 days, and 90 plus days. Scan the report for invoices that look wrong, balances that seem too high, or customers who appear to owe more than they should. List every invoice that needs attention before you start correcting anything.
Why it matters. The aging report is the fastest way to see which receivables are wrong and how old the errors are. Fixing invoices one at a time without the full picture leads to corrections that create new problems elsewhere.
Common mistake. Jumping straight into one customer account without scanning the full aging report. You fix one wrong balance and miss five others that are causing the same distortion.
2. Match Every Bank Deposit to an Invoice
Go through your bank deposits for the period and match each one to the specific invoice it pays. A deposit that lands in your bank without being applied to an invoice leaves the receivable open and overstates what customers owe you. Match every deposit to the correct customer and the correct invoice so the receivable clears when the cash arrives.
Why it matters. Receivables clear when the payment is applied, not when the cash arrives. Matching deposits to invoices is the only way to keep your aging report accurate.
Common mistake. Recording the bank deposit as income without applying it to the invoice. The cash shows up, but the receivable stays open and ages past due on your report.
3. Reconcile Your Bank and Credit Card Accounts
Reconcile every bank and credit card account to its statement before you trust any receivable balance. A payment that cleared the bank but was never recorded in your books leaves the receivable open, and you cannot tell which payments are missing until the account is reconciled. For a full walkthrough, see our guide on what bank reconciliation is and why it matters.
Why it matters. Reconciliation confirms that every payment that arrived is recorded in your books. Without it, your receivables include invoices that were already paid.
Common mistake. Trusting the bank feed without comparing it to the statement. Feeds drop and duplicate transactions, and the missing payments quietly overstate your receivables.
4. Check for Duplicate Invoices
Search for invoices that were entered twice. A duplicate invoice shows the same sale twice in your receivables, and the customer pays one copy while the second stays open and ages past due. Match amounts, dates, and customer names within the same period and remove only the duplicate, keeping the original.
Why it matters. Duplicate invoices are a frequent cause of overstated receivables. Removing the copy clears the false balance without losing the real sale.
Common mistake. Deleting both invoices instead of just the duplicate. Always keep the original and remove only the copy so the sale stays recorded.
5. Verify Payments Are Posted to the Right Customer
Review every customer account for payments applied to the wrong customer. A payment from one customer applied to another with a similar name clears the wrong invoice and leaves the right one open. One account goes negative while the other stays overstated. Move each payment to the correct customer and the correct invoice so both balances are right.
Why it matters. Misapplied payments create two wrong balances at once. Correcting the posting fixes both the negative account and the overstated one.
Common mistake. Leaving the payment where it landed because the total cash looks right. The total may match, but the individual balances are wrong and your aging report is misleading.
6. Apply Every Credit Memo
Review every open credit memo and apply it to the matching open invoice. A credit memo that sits unused leaves the invoice open even though the customer no longer owes the full amount. Apply each credit to the correct invoice so the receivable reflects what the customer actually owes after the credit.
Why it matters. Credit memos reduce what a customer owes. Leaving them unapplied overstates your receivables and makes your aging report wrong.
Common mistake. Issuing a credit memo but never applying it to the invoice. The credit exists, but the receivable never reflects it, and the balance stays too high.
7. Record Customer Deposits Correctly
Confirm that every customer deposit is recorded against the matching invoice, not as standalone income. A deposit recorded as income without applying it to the invoice counts the revenue twice and leaves the receivable open. Apply each deposit to the correct invoice so the receivable clears and the revenue is not double counted.
Why it matters. Deposits applied to invoices clear the receivable. Deposits recorded as income leave the receivable open and overstate your revenue at the same time.
Common mistake. Recording the deposit as income and leaving the invoice open. The cash is right, but the receivable and the revenue are both wrong.
8. Clear Negative Accounts Receivable Balances
Review every customer account for negative balances caused by overpayments or unapplied credits. A negative receivable means you owe the customer a credit, not that the receivable is wrong in the other direction. Record the overpayment as a credit memo and apply it to the next invoice or issue a refund so the balance reflects reality. For the broader pattern, see our guide on how to fix negative balances in bookkeeping accounts.
Why it matters. A negative receivable hides a customer credit and overstates your total receivables by offsetting it. Clearing it shows the true balance.
Common mistake. Ignoring small negative balances because the amount seems minor. Small credits accumulate and distort your total receivables over time.
9. Write Off Truly Uncollectible Invoices
Review the oldest invoices on your aging report for amounts you know will never be collected. A receivable from a customer who closed their business, disputed the charge, or went bankrupt is not a real asset. Document the reason, get approval, and remove the invoice from your receivables so your aging report reflects only what is realistically collectible. This is a bookkeeping entry, not a tax decision.
Why it matters. Old uncollectible invoices overstate your receivables and your assets. Removing them keeps your aging report honest and your balance sheet accurate.
Common mistake. Leaving old invoices open because writing them off feels like giving up. An invoice you will never collect is not an asset, and leaving it distorts your reports.
10. Compare Cash Basis and Accrual Reporting
Understand how your receivables look under cash basis versus accrual basis reporting. Under accrual, the invoice is revenue the moment it is recorded, so an uncollected receivable shows as profit without cash. Under cash basis, the sale is not revenue until the payment arrives, so the receivable does not inflate profit. A business that looks profitable on accrual but is short on cash usually has a receivables problem that cash basis reporting would reveal.
Why it matters. Each method shows a different side of your receivables. Knowing both helps you see why profit and cash do not always move together.
Common mistake. Looking at only one basis and assuming it tells the whole story. Profit on accrual with thin cash means your collections are lagging your earnings.
11. Reconcile the Accounts Receivable Ledger to the General Ledger
Confirm that the total of your accounts receivable aging report matches the accounts receivable balance on your general ledger and balance sheet. If the aging report totals one number and the general ledger shows another, a receivable was recorded in one place but not the other, and your reports disagree. Find and correct the entry that is out of balance so both reports agree.
Why it matters. The aging report and the general ledger should always agree. A mismatch means a receivable was posted incorrectly and at least one report is wrong.
Common mistake. Trusting the general ledger total without comparing it to the aging report. The total may look right while the individual balances are wrong.
12. Review Your Reports One Final Time
Once every receivable is corrected and the aging report matches the general ledger, pull your accounts receivable aging report and your balance sheet one final time. Confirm that every customer balance makes sense, that no new negatives appeared, and that your total receivables reflect what customers actually owe. A clean aging report is the proof that your corrections were complete.
Why it matters. Reports are the final check. If the balances match but the aging report still looks wrong, a correction was incomplete and a wrong balance may reappear.
Common mistake. Declaring the work done because the totals look right, without reviewing the aging report. Matching totals are necessary but not sufficient.
Two Real Small Business Examples
Example: A small landscaping company. A landscaping business owner could not understand why his accounts receivable balance kept growing even though his customers were paying on time. The bookkeeper had been recording bank deposits as income without applying them to the matching invoices. Every payment arrived, but the invoices stayed open and aged past due on the report. After matching each deposit to its invoice and clearing the paid receivables, the aging report dropped to reflect only the handful of invoices that were genuinely outstanding, and the owner could see his true receivables for the first time in months.
Example: A growing dental practice. A dental practice with three providers noticed that several patient accounts showed negative balances while others showed invoices months past due. Payments from patients with similar last names had been posted to the wrong accounts, clearing the wrong invoices and leaving the right ones open. After moving each payment to the correct patient, applying the unused credit memos, and reconciling the aging report to the general ledger, every patient balance reflected what was actually owed and the practice could trust its receivables again.
Printable Accounts Receivable Correction Checklist
Use this checklist to correct wrong accounts receivable balances and keep them accurate every month. Print it, save it, or share it with whoever handles your books.
- Pull an accounts receivable aging report and scan for wrong balances.
- Match every bank deposit to the specific invoice it pays.
- Reconcile every bank and credit card account to its statement.
- Search for and remove duplicate invoices, keeping the original.
- Verify every payment is posted to the correct customer.
- Apply every open credit memo to the matching invoice.
- Record customer deposits against the matching invoice, not as income.
- Clear negative accounts receivable balances as credit memos or refunds.
- Write off truly uncollectible invoices with documented approval.
- Compare cash basis and accrual reporting to understand the gap.
- Reconcile the aging report total to the general ledger balance.
- Pull the aging report and balance sheet one final time and confirm every balance makes sense.
Getting Started
Wrong accounts receivable balances are fixable, but they do not fix themselves. The key is to match every payment to its invoice, clear duplicate and misapplied entries, apply every credit memo, and reconcile your aging report to your general ledger so your receivables reflect what customers actually owe. If your receivables have drifted across several months, the best next step is a conversation about where your books stand today.
Ready to get your accounts receivable right? Explore our bookkeeping services and let us reconcile, correct, and maintain your receivables every month. We handle bookkeeping and payroll. We do not prepare income tax returns, offer tax planning, or perform audits, but we keep your books accurate and organized so you can run your business and your tax preparer can do their part efficiently.
Frequently Asked Questions
What causes accounts receivable balances to be wrong?
The most common causes are payments received but never recorded, invoices entered twice, payments posted to the wrong customer, credit memos never applied, and deposits recorded as income instead of against the invoice. Each one leaves a receivable open that should have cleared, which overstates what customers owe you and makes your aging report inaccurate.
Why does my accounts receivable balance keep growing even though customers are paying?
Because payments are arriving but not being applied to the matching invoices. When a bank deposit is recorded without matching it to the invoice it pays, the cash lands in your books but the receivable stays open. Over time, your receivables grow while your bank shows the money arrived, and your aging report becomes misleading.
How do I fix a negative accounts receivable balance?
A negative receivable usually means a customer overpaid or has an unapplied credit memo. Record the overpayment as a credit memo and apply it to the next invoice or issue a refund so the balance reflects what the customer actually owes. Leaving it negative hides the credit and distorts your total receivables.
Should I delete a duplicate invoice?
No. Delete only the duplicate copy and keep the original invoice so the sale stays recorded. Deleting both invoices erases the sale and breaks the reconciliation, while removing only the copy clears the false balance without losing the real transaction.
How often should I review my accounts receivable aging report?
Every month as part of your close, and more often if your receivables are large or your collections are slow. A monthly review catches wrong balances while they are small, before they compound across several customers and make your aging report unreliable.
What is the difference between cash basis and accrual for accounts receivable?
Under accrual, an invoice is revenue the moment it is recorded, so an uncollected receivable shows as profit without cash. Under cash basis, the sale is not revenue until the payment arrives, so the receivable does not inflate profit. A business that looks profitable on accrual but is short on cash usually has a receivables problem.
Can Chess Bookkeeping & Payroll fix wrong accounts receivable balances?
Yes. We match payments to invoices, clear duplicate and misapplied entries, apply credit memos, reconcile your aging report to your general ledger, and deliver accurate monthly reports so your receivables reflect what customers actually owe. We handle bookkeeping and payroll. We do not prepare income tax returns, offer tax planning, or perform audits, but we keep your books accurate and organized so your tax preparer can do their part efficiently.
Need help getting your books in order?
We focus exclusively on bookkeeping and payroll. Let's talk about where your books stand today.
Get StartedReady to simplify your books and payroll?
Schedule a consultation and let's talk about how precise bookkeeping and reliable payroll can give your business the clarity it deserves.