Wauvel
Finance 101

Bad debt: when to write off a customer

← All posts
By Blake EkelundOctober 13, 2026 · 6 min read

Every aging report has them: invoices from eight, ten, fourteen months ago that everyone privately knows will never be paid. They stay on the books because removing them feels like giving up, and because the write- off lands as a hit to this month's profit.

Both instincts are wrong. Keeping a dead receivable does not preserve any chance of collecting it, and the loss you are avoiding recognising already happened — back when you booked revenue for work that was never going to be paid for.

What a stale receivable is costing you

It overstates your assets, so your balance sheet claims you own money you do not. It inflates your A/R, which distorts DSO and makes your collections look worse than they are on the accounts that matter. And it quietly poisons your forecast, because a 13-week cash flow built off open receivables will keep expecting cash that is not coming.

An aging report with three dead invoices in it
As reportedExcluding deadRead
Total A/R$284,000$212,000
Over 120 days$78,000$6,000
DSO68 days41 daysTerms are net 30
DSO of 68 days looks like a collections problem across the whole book. Strip out the three uncollectible invoices and the live receivables are being collected in 41 days - which is a completely different diagnosis.

Deciding when it is dead

There is no universal age. What matters is whether anything has changed and whether anyone is still actually pursuing it. A practical test:

  • Has the customer acknowledged the debt recently? A dispute you are working through is alive. Silence across several attempts is not.
  • Are they still trading? A closed business or one in insolvency proceedings is usually the end of it, whatever the paperwork says.
  • Is the amount worth the pursuit? Below a few thousand dollars, formal collection or legal action rarely returns more than it costs.
  • Has anyone contacted them this quarter? If not, it is not really being collected — it is being stored.

Set an age threshold as a trigger for the review rather than for the write-off itself. Something over 120 days past terms gets a decision; that decision may well be to keep pursuing it.

Free · no account · no card

Get your 2027 budget built from your QuickBooks — P&L, balance sheet and cash flow, in Excel.

Build my 2027 budget →

What the write-off does

Mechanically it removes the receivable and records a bad debt expense. Your assets fall, your profit falls by the same amount, and no cash moves — because no cash was ever going to move.

Writing it off does not forfeit your right to collect. If the customer pays two years later, you simply record the recovery then. Nothing about the accounting entry changes what you are owed legally; it just stops your books from claiming an asset you do not have.

Written off

$72k

three customers, all over a year

Cash impact

$0

the money was never coming

DSO after

41days

down from 68

Then look at where they came from

A write-off is worth something beyond a cleaner balance sheet, but only if you ask what the dead invoices had in common. They usually rhyme: the same sales channel, jobs above a certain size taken without a deposit, a particular industry, or customers onboarded during a rush.

That pattern is the actual return on the exercise. Bad debt is rarely random, and the controls that would have prevented it — a deposit, a credit check, a lower limit for new accounts, stopping work at a threshold — are cheap once you know which ones you needed.

Most bad debt starts as slow debt. Our post on getting paid faster covers the collection habits that stop an invoice reaching this point.

Need your financials for a lender, a buyer or your accountant? Get the free financials pack →

See what an AI CFO says about your own numbers.

$99/mo, everything included. Free for 14 days, no card.

Meet your AI CFO →

Keep reading

Finance 101October 11, 2026 · 7 min read

Year-end tax planning: the decisions that expire December 31

Tax planning is not tax filing. Filing reports what happened; planning changes it, and only until December 31. Here are the levers still available to a small business in Q4 and the arithmetic for deciding whether to pull them.

Read it →
Finance 101October 9, 2026 · 7 min read

What "profit" means on four different reports

Your P&L, your tax return, your bank balance and your valuation will all give you a different profit number for the same year. None of them is lying. Here's what each is measuring and which one to use for which decision.

Read it →
Finance 101October 7, 2026 · 7 min read

Fixed vs. variable: why your cost structure decides your risk

Two businesses with identical revenue and identical profit can be completely different risks, depending on how much of the cost base is fixed. Here's how operating leverage magnifies both directions, and how to choose the structure that fits your volatility.

Read it →
Finance 101October 3, 2026 · 7 min read

Contribution margin: the number that decides what to sell more of

Gross margin tells you about a product. Contribution margin tells you what one more sale is worth - and once overhead is in the mix, the two rankings disagree often enough to change what you push.

Read it →
Finance 101October 1, 2026 · 6 min read

Your year-end close starts in October

Everything that makes a year-end close painful is fixable in October and unfixable in January. Here's the work to front-load now, in the order that removes the most pain later.

Read it →
Finance 101September 29, 2026 · 6 min read

Budget, forecast, plan: three documents, three jobs

These three words get used interchangeably, and the confusion costs real money - because a business that only has one of them either can't hold anyone accountable or can't see what's coming. Here's what each is for and how they work together.

Read it →
Finance 101September 27, 2026 · 7 min read

Vendor terms: the cheapest financing you're not asking for

Moving a supplier from net 15 to net 45 is an interest-free loan you can arrange in one email. Here's what those thirty days are actually worth, when an early-payment discount beats holding the cash, and how to ask without damaging the relationship.

Read it →
Finance 101September 25, 2026 · 6 min read

Your break-even changes every time you hire

Adding a salary raises the sales floor you have to clear before you make a penny - and by more than the salary, because you only keep the contribution margin on each sale. Here's the number to run before you make the offer.

Read it →
Finance 101September 23, 2026 · 7 min read

Churn is a cash problem before it's a growth problem

Losing customers shows up in your growth rate months after it shows up in your bank account. Here's why churn is the most expensive number in a subscription or repeat-purchase business, and the ceiling it quietly sets on how big you can get.

Read it →