The aging method in accounting is a way of estimating uncollectible receivables by sorting every unpaid invoice into time-based buckets, then applying a higher loss-rate percentage to older balances than to newer ones. The totals feed the allowance for doubtful accounts, so the balance sheet shows receivables at what the business realistically expects to collect rather than the gross amount billed.
Building the Aging Schedule
The schedule itself is a spreadsheet. Each open invoice gets a row, each age bucket gets a column, and every dollar owed to the business lands in exactly one column. For each invoice you need the customer name, the invoice number, the issue date, the payment due date, and the outstanding balance. All of it comes from the accounts receivable subledger.
The standard columns are current (not yet due), 1–30 days past due, 31–60 days, 61–90 days, and over 90 days. Some businesses split the tail further, adding 91–120 and over-120 columns when their payment cycles justify it.
Sorting is straightforward arithmetic: count the days between today and each invoice’s due date, and drop the invoice into the matching bucket. An invoice due March 1 is 20 days past due on March 20 and belongs in the 1–30 column; the same invoice on May 15 is 75 days overdue and moves to the 61–90 bucket. Once every open invoice is placed, you total each column. Most accounting platforms generate the report automatically from posted transactions, which matters because dirty data — wrong invoice dates, unrecorded partial payments — will misrepresent which balances are truly overdue.
A healthy schedule concentrates its dollar volume in the current and 1–30 day columns. When the 61–90 or over-90 columns grow as a share of total receivables, collection is slipping and cash flow trouble usually follows.
Turning the Schedule Into an Allowance
The point of the exercise is to estimate how much of your receivables you will never collect. Under U.S. GAAP, businesses estimate expected credit losses on receivables using the framework in FASB ASC Topic 326, commonly called CECL (Current Expected Credit Losses).1Financial Accounting Standards Board (FASB). FASB Staff Q&A Topic 326, No. 2: Developing an Estimate of Expected Credit Losses On Financial Assets CECL requires forward-looking estimates built from historical loss experience, current conditions, and reasonable and supportable forecasts, not just what has already gone bad.2Office of the Comptroller of the Currency. Allowances for Credit Losses – Comptrollers Handbook The standard is effective for all entities, including private companies, for fiscal years that began after December 15, 2022.
The aging method operationalizes CECL by assigning each bucket a loss-rate percentage that rises with age. A representative set of rates might look like this:
- Current: 1% estimated uncollectible
- 1–30 days past due: 4%
- 31–60 days past due: 10%
- 61–90 days past due: 30%
- Over 90 days past due: 50%
Those percentages come from the company’s own collection history, adjusted for current conditions and any forward-looking information management can reasonably support. If a major customer sitting in the 61–90 column just filed for bankruptcy, that bucket’s rate goes higher. If the industry is seeing slower payments across the board, the rates should reflect that too.
The math is a bucket-by-bucket multiplication. A 1–30 day column holding $100,000 at a 4% rate contributes $4,000 to the allowance. Run the same calculation across every bucket, sum the results, and you have the total allowance for doubtful accounts. The accounting entry debits bad debt expense on the income statement and credits the allowance account, which offsets gross receivables on the balance sheet. Net effect: receivables appear at the amount you actually expect to convert to cash.
One feature of the aging approach is worth noting for anyone recording the entry. You are calculating what the allowance balance should be, not what to add to it. If the aging schedule says the allowance should sit at $25,000 and the account already carries a $10,000 credit balance from prior periods, the current-period bad debt expense is $15,000, not $25,000.
Aging Method vs. Percentage-of-Sales
The main alternative is the percentage-of-sales method, and the two approaches look at different financial statements. Percentage-of-sales starts with the income statement: you estimate that some fixed share of the period’s credit sales — say 2% — will go uncollected, book that amount as bad debt expense, and ignore whatever is already in the allowance account. It is fast and consistent, but it says nothing about the specific receivables on the books today.
The aging method starts with the balance sheet. It looks at what is actually owed, asks what allowance balance the age profile of those receivables justifies, and works backward to the expense. That self-correcting quality is why most accountants treat it as the more precise of the two. It also fits CECL more naturally, because bucket-level estimates give you an obvious place to layer in the forward-looking adjustments the standard requires.
Why the Allowance Is Not a Tax Deduction
The allowance for doubtful accounts does not translate to a tax deduction. The IRS does not allow a deduction for an estimated allowance; a bad debt is deductible only when a specific receivable actually becomes worthless.3Internal Revenue Service. Topic no. 453, Bad Debt Deduction This is the specific charge-off method, and it produces a permanent gap between GAAP books and the tax return.
Under Section 166, a business can deduct a debt that becomes wholly worthless during the tax year, and the IRS may permit a partial deduction for a debt that is only partly recoverable, provided the business has charged off the uncollectible portion on its books.4Office of the Law Revision Counsel. 26 USC 166 – Bad Debts You must have previously included the amount in gross income; unreported revenue produces no deductible loss when the customer doesn’t pay.3Internal Revenue Service. Topic no. 453, Bad Debt Deduction
The CECL allowance recorded under GAAP cannot be used to determine tax deductions because it represents estimated future losses rather than debts that have actually become worthless.5Regulations.gov. Bad Debt Deductions for Regulated Financial Companies A company can carry a $50,000 allowance on its balance sheet while deducting only $8,000 on its tax return for the specific accounts it wrote off that year. That gap matters for cash flow planning and for anyone reconciling financial statements to tax filings.
Reading the Schedule as a Management Tool
Once the schedule exists, the numbers do double duty. The clearest metric it feeds is days sales outstanding (DSO), the average number of days between a sale and collection. The formula divides average accounts receivable by total credit sales and multiplies by the number of days in the period. A DSO that rises quarter over quarter signals slowing collections, and the aging schedule will confirm it by showing dollars migrating into older buckets.
Trends matter more than any single snapshot. If the over-90 bucket held 3% of receivables last year and holds 8% now, that shift deserves attention even when the dollar amount still looks small. Is one customer driving it, or is the slippage spread across many accounts? Are newer customers paying more slowly than long-standing ones? Answers there shape credit policy, deposit requirements, and decisions about which customers keep their terms.
The schedule also functions as an internal control checkpoint. Its total should reconcile to the general ledger balance for accounts receivable; discrepancies flag posting errors, duplicates, and unapplied payments. Any business with meaningful credit sales should run and review the aging report at least monthly.
The Same Logic on the Payables Side
The aging concept works in reverse for money the business owes. An accounts payable aging schedule groups unpaid bills by how close they are to their due dates, and the goal shifts from estimating losses to sequencing payments and protecting vendor relationships. Late fees on overdue bills typically run 1% to 2% of the overdue amount per month, and chronically late payments can push vendors to tighten terms, demand prepayment, or stop shipping. The same schedule also flags early payment discounts that would otherwise slip past their windows, which is where a fast payables process turns into real savings.