How to Find Bad Debt Expense: Formula, Methods and Journal Entries

‍Key Takeaways

• Bad debt expense estimates the portion of AR a business will never collect. It is recorded as an expense, not a loss.
• There are two methods: the allowance method (GAAP-compliant, forward-looking) and the direct write-off method (simple, not GAAP for most businesses).
• The allowance method uses either a percentage of sales or an AR aging analysis to estimate uncollectible amounts.
• Bad debt expense should be tracked monthly, not just at year-end. Monthly tracking catches portfolio deterioration early.
• Miscalculated bad debt expense distorts both the income statement and the balance sheet simultaneously.

What Is Bad Debt Expense?

Bad debt expense is the cost a business recognizes when it determines that some portion of its accounts receivable will not be collected. It is recorded as an operating expense on the income statement in the same period the original revenue was earned.

This is the matching principle at work. If a business earns $100,000 in revenue in March and estimates that $3,000 of that will never be paid, the $3,000 bad debt expense belongs in March, not in the period when the account is eventually written off.

According to Investopedia, bad debt expense is also called doubtful accounts expense or uncollectible accounts expense depending on the context. The label changes. The concept does not.

What Are the Two Methods for Finding Bad Debt Expense?

There are two approaches. Which one you use depends on the client's size, whether they follow GAAP, and how much AR history is available.

Method 1: The Allowance Method

This is the GAAP-compliant approach. It estimates bad debt before accounts actually go uncollected, using either a percentage of sales or an AR aging analysis.

Under this method, you create an allowance for doubtful accounts, a contra-asset account that offsets gross AR on the balance sheet. The journal entry is:

• Debit: Bad Debt Expense
• Credit: Allowance for Doubtful Accounts

When a specific account is eventually confirmed uncollectible:

• Debit: Allowance for Doubtful Accounts
• Credit: Accounts Receivable

The income statement takes the hit when the estimate is made, not when the write-off happens. That is the point of the method.

Method 2: The Direct Write-Off Method

This approach waits until a specific invoice is confirmed uncollectible, then records the expense directly.

• Debit: Bad Debt Expense
• Credit: Accounts Receivable

It is simpler but not GAAP-compliant for businesses with material receivables because it violates the matching principle. Revenue gets recorded in one period. The expense shows up much later. The income statement is distorted in between.

Use this only for very small businesses where bad debt amounts are immaterial.

How Do You Calculate Bad Debt Expense?

Under the allowance method, there are two calculation approaches:

Percentage of Sales (Income Statement Approach)

Take a historical average of what percentage of credit sales have gone uncollected and apply that to current period sales.

Bad Debt Expense = Net Credit Sales × Historical Bad Debt Percentage

Example: Your client has $500,000 in credit sales this quarter. Historically, 1.5% goes uncollected.

Bad Debt Expense = $500,000 × 1.5% = $7,500

Simple, fast, and works well when sales volume is consistent.

AR Aging Analysis (Balance Sheet Approach)

This is the more accurate method. It buckets outstanding invoices by age and applies a different uncollectibility percentage to each bucket based on how overdue they are.

The required allowance balance is $20,000. If the allowance account already has a $5,000 balance, you record an additional $15,000 bad debt expense this period.

The aging method is more work, but it surfaces which specific customer buckets are the problem. That makes it actionable in a way the percentage of sales method is not.

What Does Bad Debt Expense Tell You About a Client?

This is where most accountants leave value on the table. They calculate bad debt expense as a compliance entry and move on. The number itself has more to tell you.

Bad debt expense as a percentage of revenue is one of the clearest indicators of AR health. A ratio that stays flat or declines means collections are working. A ratio that climbs quarter over quarter means the client is extending credit to customers who shouldn't be getting it, or collections have gotten soft, or both.

The firms that catch this early run bad debt as a ratio every month, not just at year-end. That one habit gives you a three to four month head start on a cash flow conversation before it becomes a cash flow crisis. It's the same reason a clean accounts receivable aging report is not just a collections tool. It is an early warning system.

Where Bad Debt Expense Goes Wrong in Practice

Three errors that show up consistently:

Not adjusting for the existing allowance balance. The most common mistake. You calculate the required allowance and record that as the expense. But if the allowance account already has a balance, you only record the difference. Recording the full estimate instead of the adjustment overstates the expense.

Using the same percentage every year without reviewing it. Historical percentages drift. A client who improved collections processes two years ago should have a lower estimate. One who loosened credit terms should have a higher one. The percentage needs reviewing at least annually.

Only calculating at year-end. Bad debt calculated once a year is a compliance exercise. Calculated monthly, it becomes a management tool. If bad debt expense is jumping in Q2 relative to sales, you want to know in Q2, not when the annual accounts are being prepared.

This is where having clean, real-time AR data changes what's possible. If your still pulling AR reports manually each month to run an aging analysis across 20 clients, the calculation arrives late and the conversation happens after the fact. Accountants who have set up bookkeeping automation tools for QuickBooks can pull current AR aging on demand instead of scheduling time to build it.

And since bad debt expense affects both the income statement and the balance sheet simultaneously, errors here create double the cleanup at month-end close. Getting the allowance balance right the first time is always faster than reconciling why the balance sheet doesn't tie.

This is where Finlens helps. It runs on top of QuickBooks with no migration and gives real-time AR visibility across every client you manage, so the data you need to calculate bad debt expense is current when you need it, not a week old by the time you get to it.

Before Finlens: Pull AR aging manually for each client, build the aging buckets in a spreadsheet, calculate the allowance adjustment, and record the entry, all with data that may already be 10 days stale.

After Finlens: AR data is live. The aging analysis is always current. Finding bad debt expense becomes a calculation, not a data retrieval project.

How to find bad debt expense is a straightforward question. Having the right data underneath the calculation is where the real work is.

FAQ

What is bad debt expense in simple terms?

Bad debt expense is the amount a business estimates it will never collect from customers who owe money. It is recorded as an expense in the same period the revenue was earned.

How do you find bad debt expense?

Multiply net credit sales by your historical uncollectibility rate, or run an AR aging analysis and apply different percentages to each age bucket. The aging method is more accurate.

Is bad debt expense a debit or credit?

Bad debt expense is a debit. The offsetting credit goes to the allowance for doubtful accounts, a contra-asset account on the balance sheet.

What is the difference between bad debt expense and write-off?

Bad debt expense is the estimate recorded before accounts go uncollected. A write-off happens later, when a specific invoice is confirmed uncollectible. Under the allowance method, the write-off does not hit the income statement again because the expense was already recorded at the estimate stage.

Which method is GAAP-compliant for bad debt?

The allowance method is GAAP-compliant. The direct write-off method is not acceptable for businesses with material receivables because it violates the matching principle.

How often should bad debt expense be calculated?

Monthly for any business with significant AR. Calculating only at year-end turns bad debt into a compliance entry instead of a management tool. Monthly tracking lets you spot deteriorating AR health three to four months before it becomes a cash flow problem.

‍