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
| How was your experience with Balance Sheet today? |
|
|
|
|
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