How to Handle Bad Debt Loops in QuickBooks: Write-Off, Recovery, and the Allowance That Never Clears

That invoice from March still sits open in your receivables. The customer stopped answering emails in May, and now it is October. Your profit looks fine on paper — but some of that profit is money you will never see. Every month you leave dead invoices in accounts receivable, your balance sheet quietly overstates what your business is actually worth.

This is the bad debt loop: invoice, chase, give up, write off — and then, months later, a check arrives from a customer you had already written off, and the loop runs backward. Handle each turn correctly in QuickBooks and your books stay honest. Handle it sloppily and you get the classic symptom: an allowance account with a balance that never clears, growing stranger every year. Here is how to run the whole loop the right way.

Why Bad Debts Loop Instead of Ending​

A bad debt is rarely a single event. It usually plays out as a cycle:

1. You book revenue and a receivable when you invoice.
2. The invoice ages past 30, 60, 90 days.
3. You decide it is uncollectible and write it off.
4. Months later, the customer pays anyway — a partial payment, a collections recovery, a surprise check.

Each stage has its own correct entry, and QuickBooks treats them differently. The businesses that get tangled are the ones that improvise a different shortcut at each stage: deleting the invoice here, posting a recovery straight to income there. Pick one consistent method and follow it every time.

Direct Write-Off vs. the Allowance Method​

Before touching QuickBooks, decide which accounting method you are using. Everything downstream depends on it.

The direct write-off method​

Simple: when a specific invoice proves uncollectible, debit Bad Debt Expense and remove the receivable. No estimates, no contra account. If you are a small cash-flow-focused business without outside investors or lenders, this is probably what you do — and for tax purposes, it is close to how the deduction actually works.

The weakness is timing. The revenue hit last quarter's income; the expense hits this quarter's. For a few small write-offs, nobody cares. For material receivables, that mismatch distorts every period it touches.

The allowance method​

The allowance method follows the matching principle: you estimate uncollectible amounts in the same period as the sale. Each month or quarter, you debit Bad Debt Expense and credit Allowance for Doubtful Accounts, a contra-asset account that sits against receivables on the balance sheet. When a specific invoice dies, you debit the allowance and credit receivables — no new expense at write-off time, because you already booked it.

This is the GAAP-compliant approach, and any lender, investor, or auditor reviewing your statements expects it. The trade-off is maintenance: the allowance is an estimate, and estimates need revisiting. That maintenance is exactly where "the allowance that never clears" comes from, as we will see below.

Which should you use? If you extend meaningful credit and anyone outside the business reads your financials, use the allowance method. If write-offs are rare and small, direct write-off is honest enough — but still write them off through a proper bad debt item rather than deleting invoices, so the audit trail survives.

Setting Up Bad Debt Tracking in QuickBooks Online​

QuickBooks Online does not automate the allowance method, so you set it up once by hand. The pieces:

1. Create the accounts​

In Chart of Accounts, create:

• Bad Debt Expense — an expense account (detail type: Other Miscellaneous Service Cost, or Bad Debts if your chart offers it).
• Allowance for Doubtful Accounts — a current-asset account with the receivables detail type, used as a contra account. Give it a name that sorts next to receivables so your balance sheet reads clearly.

Desktop users follow the same idea under Lists and the Chart of Accounts; the mechanics differ slightly but the account structure is identical.

2. Create a Bad Debt item​

Products and Services needs a non-inventory item called Bad Debt, mapped to the Bad Debt Expense account. This item is the bridge that lets a credit memo move an uncollectible invoice into expense without touching your sales figures. This step matters more than it looks: if you write off using the original sales item instead, QuickBooks reports the write-off as negative income rather than bad debt expense, and your revenue trends quietly corrupt.

3. Book the allowance estimate​

Each period, record a journal entry: debit Bad Debt Expense, credit Allowance for Doubtful Accounts, for your estimated uncollectible amount. Two common ways to compute the estimate:

• Percentage of credit sales. If 2% of credit sales historically go bad and you sold $200,000 on credit this quarter, book $4,000. Simple, and it matches expense to the sales period automatically.
• Aging schedule. Bucket receivables by age — current, 1–30, 31–60, 61–90, over 90 days — and apply rising loss rates (1%, 2%, 5%, 10%, 25%, for example). Sum the buckets for your target allowance balance, then book only the adjustment needed to reach it. More work, far more accurate, and it forces you to look at the aging report regularly.

Run the A/R Aging Summary report first; it is the raw material for the aging method and the early-warning radar either way.

Writing Off a Specific Invoice​

When an invoice is genuinely dead — customer unreachable, dispute exhausted, collections returned nothing — clear it properly:

1. Create a credit memo for that customer.
2. Use the Bad Debt item (not the original sales item), for the uncollectible amount.
3. Save, then apply the credit memo to the open invoice. The invoice closes, the receivable clears, and the amount lands in Bad Debt Expense.
4. If you use the allowance method, add the second leg: a journal entry debiting Allowance for Doubtful Accounts and crediting receivables, so the write-off consumes the allowance instead of creating fresh expense. Many small businesses on the allowance method simplify by pointing the Bad Debt item at the allowance account — pick one convention and document it.

What not to do: do not void or delete the invoice. Deletion rewrites history — the sale vanishes as though it never happened, along with the audit trail. A credit memo preserves the story: sale made, collection attempted, debt recognized as bad. If the customer ever disputes the history, or an auditor samples the account, that trail is the difference between an explanation and a problem.

Also, do not write off invoices that are merely late. "Over 90 days" is a collections problem; "the customer dissolved" is a write-off. Set a written policy — for example, write off at 120 days past due after two documented collection attempts, sooner with evidence of worthlessness — and apply it consistently.

The Loop-Back: Recording a Recovery Correctly​

Here is the turn most businesses flub. You wrote off a $3,000 invoice in June. In November, the customer resurfaces and pays $3,000. The tempting move — deposit the check straight to income — is wrong twice over: it overstates this period's revenue and leaves the customer's history showing an unpaid write-off next to a mystery payment.

Do it in two steps:

1. Reinstate the receivable. Reverse the write-off: debit Accounts Receivable, credit the allowance (or Bad Debt Expense under the direct method) for the amount recovered. In QuickBooks, the practical path is a journal entry, or re-opening via an offsetting entry against the original credit memo — either way, the customer's balance shows the invoice open again.
2. Record the payment normally. Receive Payment against the invoice, deposit to the bank. Cash in, receivable out, customer history clean.

Under the allowance method, note the elegant result: the recovery rebuilds the allowance balance, which your next aging review will draw back down to its target. The loop closes through the allowance account, which is precisely what it exists for.

Partial recoveries work the same way — reinstate only what was paid. And if a collection agency recovers funds net of its fee, record the gross recovery and book the agency's cut as a collection expense, so the customer's account reflects the full payment.

The Allowance That Never Clears: Diagnosis and Fix​

Now the chronic symptom. You open the balance sheet and Allowance for Doubtful Accounts shows a credit balance that has sat there, barely moving, for two years. Or it has a debit balance, which for a contra-asset account is a red flag. Or actual write-offs never seem to reduce it. Common causes:

Cause 1: Write-offs bypass the allowance​

The credit-memo flow posts to Bad Debt Expense by default. If nobody books the second leg against the allowance, the allowance keeps accumulating estimates while write-offs hit expense directly — you expense every bad debt twice, once in the estimate and once at write-off. Fix: route write-offs through the allowance consistently, as described above.

Cause 2: No periodic true-up​

The allowance is an estimate with a shelf life. If you booked 2% of sales in 2024 and never revisited it, the balance reflects 2024's receivables, not today's. Fix: every quarter, run the aging schedule, compute the target balance, and book the adjustment — up or down. Yes, down: if collections improved and the allowance exceeds the target, debit the allowance and credit Bad Debt Expense (a negative expense). An allowance that only ever grows is an estimate nobody maintains.

Cause 3: Recoveries posted to income​

Every recovery booked straight to revenue instead of through reinstatement starves the allowance of its natural replenishment and inflates sales. Fix: reinstate-then-receive, every time.

Cause 4: Stale specific reserves​

Sometimes the allowance balance is really one ancient judgment — a single large doubtful account reserved years ago and never resolved. Fix: review the allowance as a list of specific doubts, not just a number. Either write the account off, or release the reserve with documentation of why collectibility improved.

A healthy allowance account moves: up with estimates, down with write-offs and true-ups, back up with recoveries. If yours has not changed in four quarters, that stillness is the diagnosis.

The Tax Side: When a Write-Off Is Deductible​

Book accounting and tax accounting diverge here, and the gap surprises people.

• Accrual-basis businesses generally deduct business bad debts in the year they become wholly or partially worthless. The debt must be a genuine debt — arising from credit sales, loans to customers or suppliers, or similar business transactions — and you need evidence of worthlessness: collection letters, agency reports, bankruptcy notices, a documented dead end.
• Cash-basis businesses generally cannot deduct bad debts at all. You never reported the unpaid invoice as income, so there is nothing to deduct. Writing it off in QuickBooks clears the receivable, but it creates no tax benefit. This is the single most misunderstood point in small-business bad debt.
• Business vs. nonbusiness matters. A worthless business debt is an ordinary loss. A nonbusiness bad debt — say, a personal loan you made that went bad — is treated as a short-term capital loss, deductible only when totally worthless and subject to capital loss limits. Keep business and personal lending strictly separated in your books.

One more timing trap: tax worthlessness is judged year by year. A debt that became completely worthless last year but that you write off this year belongs to last year's return. Your write-off policy should include a year-end review of doubtful accounts so deductions land in the right year.

This is general information, not tax advice — worthlessness calls with real money attached deserve a CPA's eyes. But walking in with an aging report, a written policy, and documented collection attempts turns that conversation from archaeology into a review.

Common Mistakes That Keep the Loop Spinning​

• Writing off with the original sales item, turning bad debt into negative revenue and corrupting sales history.
• Deleting or voiding invoices instead of issuing credit memos, destroying the audit trail.
• Posting recoveries to income instead of reinstating the receivable first.
• Booking allowance estimates but never truing up, so the balance fossilizes.
• Ignoring the aging report until year-end, when collection options have decayed along with the receivables.
• Mixing methods — allowance estimates in good quarters, direct write-offs in bad ones — which makes trends meaningless.
• Forgetting sales tax. In many states, you can recover sales tax remitted on invoices that later prove worthless, either as a credit on a future return or a refund claim. A write-off without the corresponding sales tax recovery leaves money behind; check your state's rules before closing the books on a dead invoice.

Keep Your Receivables Honest From Day One​

Bad debts are not a sign of failure — any business that extends credit will eat some losses. The damage comes from letting dead receivables linger, distorting both your balance sheet and your sense of how the business is doing. Run the aging report monthly, enforce a written write-off policy, route every write-off and recovery through the same accounts, and true up the allowance every quarter. The loop never fully stops, but it stops costing you clarity.

Maintaining disciplined receivables records is easier when your accounting is transparent and version-controlled. Beancount.io offers plain-text accounting that gives you complete visibility into every entry — no black boxes, no vendor lock-in. Get started for free and see why developers and finance professionals are switching to plain-text accounting.