You are cleaning up a file and the Accounts Receivable balance looks wrong. There are invoices from 2022 that will never be paid, a bunch of customers who are off by a few dollars, and someone before you "fixed" it with a journal entry. The balance sheet looks fine now. But open the A/R aging report and it does not match, and nobody can tell you why.
This is one of the most common messes in a cleanup, and it comes from a single habit: adjusting Accounts Receivable with a journal entry. It feels efficient. It quietly breaks your reporting.
Why the aging breaks
A journal entry that debits or credits Accounts Receivable moves the control account balance — the single A/R number on the balance sheet. What it does not do is touch any actual invoice. QuickBooks builds the A/R aging report from open invoices and payments, not from the control account. So the JE moves one and not the other.
The result: the invoice you were trying to clear is still sitting in the aging, aged another year, while the balance sheet already dropped. Do that a few times over a couple of years and the aging total and the A/R line on the balance sheet drift apart by the sum of every journal entry that ever hit A/R. Now your aging is useless for collections and your balance sheet is right by accident.
The right way for small balances and bad debt
For the "invoice has $4.20 left on it" cases and for genuinely uncollectible invoices, skip the journal entry entirely. Use a credit memo and apply it:
- Set up an item — call it Write-off or Bad debt — and map it to a bad debt expense account (or a write-offs / discounts account, depending on how you want it to show).
- Create a Credit Memo for that customer using the write-off item, for the exact amount left on the invoice.
- Go to Receive Payment for the same customer and apply the credit memo to the specific open invoice.
That clears the invoice out of the aging and reduces A/R on the balance sheet in the same move, so the two never drift. Date the credit memo in the period you want the write-off to land for taxes. If you write off a lot of bad debt, this also keeps the expense visible instead of burying it in a journal entry nobody reads.
If you are set on using a journal entry
Sometimes you inherit a process built on JEs, or you are moving a balance for a reason that is not a simple write-off. You can use a journal entry against A/R, but only if you do two things:
- Put the customer name in the Name column on the A/R line. QuickBooks requires it, and without it the entry cannot be matched to anything.
- Then still go into Receive Payment for that customer and apply the journal entry against the open invoice.
That second step is the one everyone skips, and skipping it is the whole problem. A JE with a customer name still does not clear the invoice on its own — it just becomes an available credit until you apply it. Apply it, and the aging and the balance sheet move together.
Finding the A/R that was already done wrong
When you take over a file, you want to know how bad this is before you quote the cleanup, not after. Two quick checks:
- Run the A/R Aging Summary and compare its total to Accounts Receivable on the Balance Sheet as of the same date. If they do not match, the gap is roughly the damage.
- Open the Accounts Receivable register (or a transaction report filtered to that account) and filter by transaction type = Journal Entry. Every JE that touched A/R is a suspect: an unapplied credit, a broken write-off, or a balance that was moved without clearing an invoice.
From there it is cleanup: apply the JEs that have a customer name to the right invoices, reverse the ones that should have been credit memos and redo them properly, and write off the genuinely dead invoices the right way. Tedious, but the aging finally ties to the balance sheet and stays that way.
Scope it before you quote it
A broken A/R aging is one of those things that looks like a five-minute fix and turns into a day. The number of journal entries against A/R, whether they have customer names, and how far back the mismatch goes all decide how many hours you are actually signing up for. Check the gap between the aging and the control account before you put a price on the job — that is where the hours hide.
Scoping a cleanup before you quote it and knowing where the other silent messes live is the difference between a profitable cleanup and one you eat in week three.