Aging Schedule Inputs

$
%
Amount | Estimated uncollectible %
$
%
Amount | Estimated uncollectible %
$
%
Amount | Estimated uncollectible %
$
%
Amount | Estimated uncollectible %
$
%
Amount | Estimated uncollectible %
$
Positive = credit balance (normal). Negative = debit balance (write-offs exceeded prior estimates).
Key Formulas
Required Allowance = Σ(Bucket × Rate)
Bad Debt Expense = Required Allowance − Existing Balance
NRV = Total Receivables − Required Allowance
Ryan O'Connell, CFA
Calculator by Ryan O'Connell, CFA

Calculation Results

Required Allowance $35,500 Moderate Reserve
Total Receivables $880,000
Bad Debt Expense $30,500
Net Realizable Value $844,500
Allowance % of A/R 4.03%
Negative bad debt expense indicates the existing allowance already exceeds the required ending balance. The adjusting entry would debit the Allowance for Doubtful Accounts and credit Bad Debt Expense (or a recovery account) to reduce the allowance to the required level.

Aging Schedule Breakdown

Age Category Receivable Amount Est. Uncollectible % Est. Uncollectible $
Current (0-30 Days) $500,000 1.0% $5,000
31-60 Days $200,000 3.0% $6,000
61-90 Days $100,000 8.0% $8,000
91-120 Days $50,000 15.0% $7,500
Over 120 Days $30,000 30.0% $9,000
Total $880,000 — $35,500

Formula Breakdown

Bad Debt Expense = Required Allowance − Existing Balance
Aging-of-receivables method (balance sheet approach)

Reserve Intensity Guide

These thresholds are illustrative benchmarks only. Appropriate reserve levels vary significantly by industry, company size, and economic conditions.

Allowance % of A/R Reserve Intensity Typical Context
< 3% Low Strong credit quality, low historical losses
3% – 8% Moderate Typical commercial/industrial receivables
>8% High Elevated credit risk, aging receivables, or economic stress
Model Assumptions
  • Uses the aging-of-receivables method (balance sheet approach) per FASB standards
  • Existing allowance is assumed to be a credit balance unless a negative value is entered (indicating a debit balance from write-offs exceeding prior estimates)
  • Uncollectible percentages are management estimates based on historical experience, current conditions, and reasonable forecasts
  • Current-period write-offs and recoveries are implicitly reflected in the existing allowance balance; the calculator does not separately model them
  • Five standard aging buckets used (Current, 31-60, 61-90, 91-120, Over 120 days past due)

For educational purposes. Not financial advice. Market conventions simplified.

Understanding Bad Debt Expense & the Aging Schedule

What is the Allowance Method?

The allowance method is required by GAAP whenever bad debts are material. Companies estimate uncollectible accounts at the end of each period and record an adjusting entry to bring the Allowance for Doubtful Accounts to the required balance. This approach matches bad debt expense to the period in which the related revenue was earned.

Aging-of-Receivables Method
Required Allowance = Σ(Bucket Amount × Estimated Uncollectible %)
Bad Debt Expense = Required Allowance − Existing Allowance Balance
Balance sheet approach: targets the correct ending allowance balance

Allowance Method vs. Direct Write-Off

Allowance Method (GAAP)

Estimates bad debts before they occur.
Matches expenses to the period revenue was earned. Reports receivables at net amount expected to be collected.

Direct Write-Off Method

Records expense only when account is deemed uncollectible.
Fails to match expenses with revenues. Not GAAP-compliant when bad debts are material.

How the Aging Schedule Works

The aging schedule categorizes outstanding receivables into buckets based on how long they have been past due. Each bucket is assigned a different estimated uncollectible percentage, with older receivables carrying higher rates. This reflects the reality that the longer an account remains unpaid, the less likely it is to be collected.

  • Current (0-30 days): Lowest risk, typically 0.5% to 2% uncollectible
  • 31-60 days: Slightly elevated risk, typically 2% to 5%
  • 61-90 days: Moderate risk, typically 5% to 15%
  • 91-120 days: High risk, typically 10% to 25%
  • Over 120 days: Highest risk, typically 20% to 50%+
Important: The existing allowance balance must be factored into the adjusting entry. A debit balance (from write-offs exceeding estimates) increases the required bad debt expense, while a credit balance reduces it.

Key Concepts

  • Net Realizable Value: Total Receivables minus the Required Allowance — the amount expected to be collected
  • Contra-Asset Account: The Allowance for Doubtful Accounts reduces reported receivables on the balance sheet
  • Write-off vs. Expense: Writing off a specific account debits the allowance and credits receivables — it does not affect bad debt expense
  • Recovery: Recovering a previously written-off account reverses the write-off entry, then records the cash collection

Frequently Asked Questions

Bad debt expense is the estimated cost of accounts receivable that a company expects will not be collected. Under the allowance method required by GAAP, companies estimate this expense at the end of each accounting period based on their outstanding receivables. The expense is recorded as a debit to Bad Debt Expense and a credit to Allowance for Doubtful Accounts, a contra-asset account that reduces the reported value of accounts receivable on the balance sheet.

The aging-of-receivables method (also called the aging schedule or balance sheet approach) estimates uncollectible accounts by categorizing outstanding receivables into age buckets based on how long they have been past due. Each bucket is assigned a different estimated uncollectible percentage, with older receivables typically having higher rates. The sum of all bucket estimates gives the required ending balance in the Allowance for Doubtful Accounts. This is a common and often more refined balance-sheet approach for estimating the required ending allowance.

The allowance method estimates and records bad debt expense before specific accounts are identified as uncollectible, matching the expense to the period when revenue was earned. It requires maintaining an Allowance for Doubtful Accounts contra-asset account. The direct write-off method records bad debt expense only when a specific account is deemed uncollectible, which fails to match expenses with related revenues and does not report receivables at their net amount expected to be collected. GAAP requires the allowance method whenever bad debts are material.

A debit balance in the Allowance for Doubtful Accounts means that actual write-offs during the period exceeded the previously estimated allowance balance. This can happen when a company writes off more uncollectible accounts than anticipated. When a debit balance exists, the bad debt expense adjusting entry must be large enough to both eliminate the debit balance and establish the required credit balance, resulting in a higher bad debt expense for the period.

Net realizable value is the amount of cash a company expects to actually collect from its accounts receivable. It equals the gross accounts receivable balance minus the Allowance for Doubtful Accounts. The FASB requires companies to report accounts receivable at the net amount expected to be collected on the balance sheet. NRV provides a more realistic picture of a company's expected cash inflows than the gross receivable balance.

Companies determine uncollectible percentages based on historical loss experience (past collection patterns for each age category), current economic conditions (recession vs. expansion), industry-specific factors (some industries have inherently higher default rates), and reasonable and supportable forecasts of future collectibility. These percentages are management estimates that should be reviewed and updated each reporting period. This calculator uses user-entered estimated loss rates and does not independently model macro forecasts.
Disclaimer

This calculator is for educational purposes only and uses the aging-of-receivables method with user-provided estimates. Actual bad debt expense calculations require professional judgment, historical data analysis, and consideration of current economic conditions. The uncollectible percentages and reserve intensity thresholds shown are illustrative defaults and may not be appropriate for your specific situation. Consult a qualified accountant for actual financial reporting.

Related Calculators

Professional finance illustration representing Bond Amortization Schedule Calculator

Bond Amortization Schedule Calculator

Generate bond amortization schedules using effective interest method.

Try Calculator →
Professional finance illustration representing Inventory Valuation Calculator: FIFO, LIFO & Weighted Average Cost Comparison

Inventory Valuation Calculator: FIFO, LIFO & Weighted Average Cost Comparison

Compare inventory valuation under FIFO, LIFO, and weighted average methods.

Try Calculator →
Professional finance illustration representing Depreciation Calculator: Straight-Line, DDB, SYD & Units of Production

Depreciation Calculator: Straight-Line, DDB, SYD & Units of Production

Calculate depreciation using straight-line, declining balance, and units-of-production methods.

Try Calculator →