Allowance for Doubtful Accounts, Step-By-Step


Issue #49

Allowance for Doubtful Accounts, Step-By-Step

Happy Friday,

Welcome back to Balance Sheet. Every issue follows one real business with a problem hiding in its numbers, walks through what went wrong on the books, and shows you the fix.

Today's issue is about the allowance for doubtful accounts, the line on the balance sheet where accountants admit some customers won't pay. Danielle Okafor runs Keystone Staffing, a light-industrial staffing agency in Tulsa, and her largest client, a regional freight carrier, stopped paying with $31,000 still open. Two days earlier she had calculated a $9,600 recruiter bonus pool on profit that included every dollar of that invoice. The fix was an allowance built from an aging schedule.

Here's how it started and what it can teach you before you count your receivables as cash.

The invoice that stopped moving

Keystone places forklift operators, pickers, and loaders in warehouses across northeast Oklahoma. Clients get billed weekly on net 30 terms, and Danielle pays her recruiters a quarterly bonus equal to 10% of net income.

Q3 looked strong. Net income came in at $96,000, so the bonus pool was $9,600. Danielle had already drafted the announcement email.

Then the freight carrier's controller called. The company had filed for Chapter 11 bankruptcy protection that morning. Keystone was now an unsecured creditor, somewhere near the back of a very long line.

Danielle's first instinct was to wait and see how the bankruptcy played out. Her CPA told her that waiting was the one thing the accounting rules didn't allow.

Why accountants book the loss early

Under accrual accounting, the matching principle says expenses belong in the same period as the revenue they helped produce. Keystone earned that $31,000 in Q3, so any expected loss on it belongs in Q3 too.

The tool for this is the allowance for doubtful accounts, a contra-asset account that sits directly under accounts receivable. It reduces the reported value of receivables without changing what any individual customer owes.

Net realizable value = Accounts receivable − Allowance for doubtful accounts

Net realizable value is the amount you realistically expect to turn into cash. It's the number lenders and investors care about.

The alternative is the direct write-off method, where you expense a bad account only when it finally dies. It's simple, but it breaks the matching principle and creates wild swings in profit. The quarter that earned the revenue looks better than it was, and a later quarter takes the whole hit.

Current GAAP (the CECL standard, ASC 326) requires businesses that follow it to estimate expected credit losses this way. Tax rules work differently. The IRS generally lets you deduct bad debt only when a specific account is actually written off, so your books and your tax return will often show different numbers for the same loss.

Building the estimate

There are two common estimating methods. The percentage of sales method applies a historical loss rate to the period's credit sales. Keystone's history suggested 1.5%, and on $640,000 of Q3 credit sales, that produced a $9,600 reserve.

That number would have missed the problem completely. A flat percentage can't see one big customer going under.

So the CPA used the aging method, which sorts receivables by how long they've been outstanding and applies higher loss rates to older balances. For the freight carrier, she used specific identification and reserved 100% of the balance.

The loss rates came from Keystone's own collection history over four years, adjusted for current conditions. Freight volumes had been falling across the region, so the CPA raised the 61-to-90-day rate from 10% to 15%. Judgment calls like that are normal. Auditors simply expect you to document the reasoning.

The adjusting entry

The allowance already carried a $5,000 credit balance from earlier quarters. The adjusting entry only needs to cover the gap between that balance and the new target.

Adjustment = Required allowance − Existing balance

$42,790 − $5,000 = $37,790

Account Debit Credit
Bad Debt Expense $37,790
Allowance for Doubtful Accounts $37,790

Q3 net income dropped from $96,000 to $58,210. Net realizable value on the balance sheet came in at $243,210, which is $286,000 minus the $42,790 allowance.

The write-off that changes nothing

In November, the bankruptcy trustee confirmed that unsecured creditors would receive nothing. Keystone wrote off the account.

Account Debit Credit
Allowance for Doubtful Accounts $31,000
Accounts Receivable $31,000

This is the part that confuses new bookkeepers. The write-off creates no new expense. Accounts receivable fell to $255,000, the allowance fell to $11,790, and net realizable value stayed exactly at $243,210. The loss had already been recognized in Q3, when the CPA booked the reserve.

If the carrier ever pays something later, Keystone reverses the write-off for that amount (debit Accounts Receivable, credit the allowance) and then records the cash receipt against the receivable.

One tip if you read other companies' financial statements. A sudden jump in the allowance usually signals customers in trouble. A sudden drop deserves a question too, since shrinking the reserve is one of the easiest ways to inflate profit.

One report worth opening every Monday

Pull up your accounts receivable aging report this week. Look at everything past 60 days, then check whether any large customer has started paying later than usual.

You need a reasonable estimate of what you'll actually collect, based on payment history and what you know about your customers today.

If one client makes up a large share of your receivables, give that account extra attention. One troubled customer can change your reported profit much faster than a dozen small late payments.

And remember that recording an expected loss doesn't mean giving up on collecting the money. You can keep chasing payment while making sure your financial statements reflect the risk.

The goal is simple: your balance sheet should show what your receivables are likely to bring in, not just what you've managed to invoice.

P.S. Receivables aren't the only asset that quietly shrinks. Friday's issue follows a retailer whose stock count came up $9,400 short.

Feedback

​Subscribe to participate in polls.

If you have specific feedback or anything interesting you’d like to share, please let us know by replying to this email.

600 1st Ave, Ste 330 PMB 92768, Seattle, WA 98104-2246

​Unsubscribe · Preferences​
​

Balance Sheet

Balance Sheet is a practical accounting and business finance newsletter that helps students, young professionals, founders, freelancers, and small business owners understand the numbers behind smart business decisions.

Read more from Balance Sheet
2/10 Net 30 & The Math Of Paying Early

Issue #48 2/10 Net 30 & The Math Of Paying Early Happy Monday, Welcome back to Balance Sheet. Every issue follows one real business with a problem hiding in its numbers, walks through what went wrong on the books, and shows you the fix. Today's issue is about 2/10 net 30, the early payment discount printed on millions of vendor invoices. Tomas Becker runs Redline Collision, a 9-bay auto body shop in Sacramento, and he buys about $42,000 a month in paint, clear coat, and replacement parts on...

Trial Balance Errors Your Totals Won't Catch

Issue #47 Trial Balance Errors Your Totals Won't Catch Happy Friday, Welcome back to Balance Sheet. Every issue follows one real business with a problem hiding in its numbers, walks through what went wrong on the books, and shows you the fix. Today's issue is about the trial balance, the report that proves your debits equal your credits and very little else. Marisol Ortega runs Brightline Electric, a 12-person commercial electrical contractor in Spokane, and her trial balance matched to the...

Days Sales Outstanding and the $112,000 wait

Issue #46 Days Sales Outstanding and the $112,000 wait Happy Monday, Welcome back to Balance Sheet. Every issue follows one real business with a problem hiding in its numbers, walks through what went wrong on the books, and shows you the fix. Today's issue is about days sales outstanding, the number that tells you how long customers take to pay you. Marisol Ortega runs a commercial cleaning company in Raleigh, North Carolina, and $112,000 of her cash was sitting in her customers' bank...