You're staring at your accounts receivable aging report. Again. Your gut says this money isn't coming. Still, one ghosted you entirely. Another promised a check "next week" — that was six weeks ago. Three customers haven't paid in 90+ days. Your books still say it's revenue.
Here's the uncomfortable truth: if you're not recording bad debt expense properly, your financial statements are lying to you. And they're lying to anyone else reading them — banks, investors, potential buyers.
Let's fix that And that's really what it comes down to..
What Is Bad Debt Expense
Bad debt expense is the accounting recognition that some of your accounts receivable will never turn into cash. It's not a "we'll see.It's not a maybe. " It's the formal admission that specific invoices — or a percentage of your overall receivables — are uncollectible The details matter here..
Under accrual accounting, you record revenue when you earn it, not when you collect it. Bad debt expense closes that gap. Think about it: you've recognized the revenue. Think about it: that creates a timing problem. But the cash? Which means you've booked the sale. Still in your customer's pocket. It matches the cost of uncollectible accounts to the same period as the revenue they generated That alone is useful..
That matching principle isn't optional. It's GAAP.
The Two Methods You'll Actually Use
There are only two GAAP-approved ways to handle this. Pick one and stay consistent Small thing, real impact..
Direct write-off method — you wait until a specific account is proven uncollectible, then you write it off. Simple. Clean. Also not GAAP-compliant for financial reporting if your bad debts are material. The IRS likes it for tax returns. Your auditors won't.
Allowance method — you estimate uncollectible amounts before you know exactly which customers won't pay. You create a contra-asset account called Allowance for Doubtful Accounts. It sits right under Accounts Receivable on the balance sheet. Net realizable value = AR minus Allowance. That's the number people actually care about Simple as that..
If you're issuing financial statements that anyone outside your company will read, you're using the allowance method. Period The details matter here..
Why It Matters / Why People Care
Overstated receivables make your company look healthier than it is. That's not just an accounting technicality — it has real consequences Still holds up..
Your bank looks at your AR turnover and days sales outstanding when deciding whether to renew your line of credit. If your receivables are inflated by 15% in dead weight, your ratios look better than reality. The bank eventually figures it out. Usually when they're auditing your collateral.
Investors and buyers run quality-of-earnings analyses. Seen it happen. They'll adjust your EBITDA down for inadequate bad debt reserves. A $2M adjustment on a $10M EBITDA company changes the valuation by millions Simple, but easy to overlook..
Tax authorities care too. But your book records should follow GAAP. Schedule M-1 adjustments. Day to day, the IRS requires the direct write-off method for tax purposes — you can only deduct specific debts that become worthless during the year. That means book-tax differences. That's why deferred tax assets. Fun stuff.
The official docs gloss over this. That's a mistake.
And internally? Your sales team needs to know which customers are credit risks. Your CFO needs accurate cash flow forecasts. On top of that, your collection team needs prioritization. Bad debt expense isn't just a journal entry — it's operational intelligence.
How It Works (or How to Do It)
The allowance method has two main estimation approaches. Both are acceptable. Neither is perfect Most people skip this — try not to..
Percentage of Sales Method (Income Statement Approach)
You apply a historical percentage to current period credit sales. That percentage becomes your bad debt expense for the period. The allowance account balance is whatever it ends up being — you don't target a specific ending balance.
Say your history shows 1.Practically speaking, debit Bad Debt Expense, credit Allowance for Doubtful Accounts. This quarter you had $4.Which means 2% of credit sales go bad. 3M in credit sales. Here's the thing — bad debt expense = $51,600. Done.
Advantage: Perfect matching. Expense ties directly to the revenue that created it Not complicated — just consistent..
Disadvantage: The allowance account balance can drift. If you've been too aggressive or too conservative historically, the balance sheet number becomes meaningless. You'll need to true it up eventually.
Percentage of Receivables Method (Balance Sheet Approach)
You analyze your aging schedule and apply different percentages to each bucket. Also, current: 0. 5%. 1-30 days: 2%. 31-60: 8%. But 61-90: 25%. Over 90: 50%. That said, multiply each bucket's balance by its rate. Day to day, sum them up. That's your target ending allowance balance.
Then you adjust the allowance account to hit that target. The difference between the current allowance balance and your target becomes bad debt expense (or recovery, if you over-reserved previously).
Advantage: Your balance sheet shows a defensible net realizable value. Auditors love this.
Disadvantage: The expense amount is whatever it needs to be to hit the target. Matching gets messy. A big write-off in January might create a negative expense (recovery) in February if the allowance was overfunded And that's really what it comes down to. But it adds up..
The Aging Schedule — Your Best Friend
If you're using the receivables method (and most companies should), your aging schedule is the workhorse. Think about it: run it monthly. Minimum.
| Age Bucket | Balance | Estimated % Uncollectible | Estimated Uncollectible |
|---|---|---|---|
| Current | $1,200,000 | 0.5% | $6,000 |
| 1-30 days | $340,000 | 2% | $6,800 |
| 31-60 days | $180,000 | 8% | $14,400 |
| 61-90 days | $95,000 | 25% | $23,750 |
| Over 90 days | $62,000 | 50% | $31,000 |
| Total | $1,877,000 | $82,000 |
Your target allowance: $82,000. If the allowance account currently sits at $58,000, you record $24,000 in bad debt expense. If it's at $95,000, you record a $13,000 recovery (negative expense).
Update your percentages annually. Or when something material changes — new customer mix, economic downturn, major customer bankruptcy.
Writing Off Specific Accounts
Estimation is step one. Writing off actual dead accounts is step two. They're separate events It's one of those things that adds up..
When you finally admit Customer X isn't paying their $14,500 invoice:
- Debit Allowance for Doubtful Accounts $14,500
- Credit Accounts Receivable $14,500
Notice what's missing: Bad Debt Expense. The expense was already recorded when you built the allowance. The write-off just removes the dead receivable and reduces the allowance. Net realizable value doesn't change.
If the customer miraculously pays after write-off:
- Reverse the write-off: Debit AR, Credit Allowance
- Record the cash: Debit Cash, Credit AR
Don't skip step one. If
you debit Cash and Credit Allowance directly, you've overstated revenue (or understated expense) and inflated the allowance balance. The two-step reversal keeps the audit trail clean and the allowance mechanics intact Surprisingly effective..
Recoveries: The Rare Bright Spot
When a written-off account pays up, the accounting is straightforward but the implication is often misunderstood.
The Entry:
- Reverse Write-off: Debit Accounts Receivable / Credit Allowance for Doubtful Accounts
- Collect Cash: Debit Cash / Credit Accounts Receivable
The Result: The Allowance balance increases. Net Accounts Receivable increases. Bad Debt Expense on the income statement is untouched—that ship sailed in a prior period.
This creates a timing quirk. Practically speaking, your current period’s bad debt expense reflects current estimates. Here's the thing — the recovery inflates the allowance, which lowers next period’s required expense provision (since the target allowance is already partially funded). Still, it’s a self-correcting mechanism, provided you don’t let the allowance balance drift too high. That's why if recoveries pile up, you’ll eventually book a negative bad debt expense (a recovery gain) to draw the allowance back down to its calculated target. Don’t panic; it’s just the matching principle catching up.
Management Estimates vs. Auditor Reality
The percentages in your aging schedule are estimates. Estimates imply judgment. Judgment implies bias It's one of those things that adds up..
Optimism Bias: Sales wants lower percentages to keep expense down and commissions up. Collections wants higher percentages to justify headcount. The CFO wants stability.
The Fix: Document your basis. "We used 50% for Over 90 because our historical recovery rate on that bucket over the last 36 months is 48%, adjusted for the current recessionary indicator." That sentence defends the number. "Industry standard" does not That's the part that actually makes a difference..
Back-testing: Once a year, compare last year’s estimated uncollectible per bucket against actual write-offs that originated in those buckets Small thing, real impact..
- Estimated: $82,000.
- Actual write-offs from that population: $76,000.
- Variance: $6,000 (Over-reserved).
If you’re consistently over-reserving by 20%, your percentages are stale. Now, if you’re under-reserving, your financial statements are aggressive. In practice, auditors will test this. You should test it first.
The Direct Write-Off Method: Just Say No
For completeness: Some tiny, non-GAAP entities wait until an invoice is proven dead, then debit Bad Debt Expense and credit AR directly. No allowance account. No estimation.
Why it fails: It violates the matching principle violently. You recognize revenue in Year 1 and the related expense in Year 3. Your Year 1 profit is overstated; Year 3 takes a hit for a sale that happened eons ago. It also leaves gross AR on the balance sheet at inflated, uncollectible values until the bitter end Most people skip this — try not to..
If you’re reading this, you’re past the size where this is acceptable. Use the allowance method.
Technology: Stop Doing This in Spreadsheets
If your aging schedule lives in Excel, you have a control weakness.
Now, ). - Version control issues (which Aging_Final_v3_REAL.- Manual percentage updates that don't flow to the GL. xlsx is real?- No audit trail on who changed the "Over 90" rate from 50% to 10% the day before close Took long enough..
Your ERP (NetSuite, Sage Intacct, Dynamics, SAP, Oracle) has a native aging engine and allowance calculation module. Configure it. On the flip side, 2. Schedule the calculation to run on the last day of the month. Here's the thing — define aging buckets. Even so, 3. 1. Think about it: assign reserve percentages by bucket (or by customer risk class). Day to day, 4. Auto-generate the adjusting journal entry (JE) for review/approval Easy to understand, harder to ignore..
Not obvious, but once you see it — you'll see it everywhere.
The spreadsheet becomes the backup for the auditor, not the source of truth.
Disclosure Requirements (ASC 310 / IFRS 9)
You can’t just bury the allowance in a contra-asset line. The notes require:
- Here's the thing — Rollforward: Beginning Allowance + Provision (Expense) - Write-offs + Recoveries = Ending Allowance. 2. Even so, Policy: How you determine the percentages (historical loss rates, current conditions, reasonable & supportable forecasts). On top of that, 3. Still, Credit Quality: Often broken down by risk class (e. g.Think about it: , Investment Grade vs. Day to day, subprime) or geography, not just age. 4. In real terms, Significant Changes: Did you change the methodology? Did a major customer file Chapter 11? Disclose the impact.
Under IFRS 9 (CECL in US GAAP), the "incurred loss" model is dead. You book expected lifetime losses on Day 1. The aging schedule percentages must now incorporate forward-looking macroeconomic data (GDP forecasts, unemployment rates), not just trailing history. The mechanics of the aging table stay the same; the inputs got harder.
The Controller’s Checklist (Monthly Close)
-
[ ] Run aging report as of period end (cutoff verified) Small thing, real impact..
-
[ ] Review top 10 past-due balances individually. Are specific reserves needed on top of the formulaic bucket rates?
-
[ ] Update reserve percentages if macro triggers
-
[ ] Review top 10 past-due balances individually. Are specific reserves needed on top of the formulaic bucket rates?
-
[ ] Update reserve percentages if macro triggers change (e.g., recession indicators, industry downturn).
-
[ ] Generate and review auto-calculated allowance JE; validate reasonableness against prior periods and known defaults That's the part that actually makes a difference..
-
[ ] Approve and post allowance journal entry before financial statement close.
-
[ ] Reconcile allowance account to rollforward schedule; ensure beginning balance matches prior period ending balance.
-
[ ] Update disclosure schedules with rollforward, policy changes, credit quality metrics, and material events.
-
[ ] Archive aging schedule and supporting analysis in the ERP or document management system for audit trail But it adds up..
Conclusion
The old ways—writing off bad debt when cash goes missing, tracking receivables in spreadsheets, or skipping allowances altogether—are financial time bombs. Also, they distort earnings, obscure credit risk, and invite audit scrutiny. Modern accounting isn’t just about compliance; it’s about clarity, control, and decision-grade data.
The allowance method, powered by your ERP and grounded in ASC 310 or IFRS 9, isn’t just best practice—it’s table stakes for any company serious about accurate financial reporting and sustainable growth. If you’re still doing otherwise, you’re not just behind. You’re exposing your organization to avoidable risk.
It’s time to upgrade. On the flip side, configure your system. On top of that, calculate your allowance. Close with confidence.