Aged Account: Aging Schedule, CECL Estimates, and Tax Write-Offs

Aged accounts receivable are customer invoices that have passed their due date and remain unpaid. Every day a balance sits past due, the odds of collecting it drop, which is why accountants sort these balances by how long they have been overdue and why auditors, lenders, and the IRS all care how the numbers look. Managing them well is part bookkeeping discipline, part collection strategy, and part tax planning.

When an Invoice Starts Aging

An account begins aging the day after its payment deadline passes, not the day you sent the invoice. If your terms are Net 30, the clock starts on day 31. Net 60 means the balance is current through day 60 and ages from day 61.

That distinction matters because a large receivables balance is not automatically a problem. Many of those invoices may still be inside their payment window. The concern is the subset that has gone past due, and the collection odds fall sharply with time. Industry experience suggests that once an invoice crosses 90 days past due, the probability of collecting falls to roughly 50 percent or less, and it keeps deteriorating from there.

A heavy concentration of very old receivables is one of the clearest warning signs of cash flow trouble. The balance sheet is carrying asset values that may never turn into cash, and the cause usually traces back to weak credit screening, sloppy invoicing, or customers in financial distress.

The Aging Schedule

The accounts receivable aging schedule is the report that makes the problem visible. It lists every customer with an outstanding balance and sorts those balances into time-based columns showing how long each has been overdue. Accounting software generates it automatically, but the logic is straightforward.

The standard columns are:

  • Current (not yet past due)
  • 1–30 days past due
  • 31–60 days past due
  • 61–90 days past due
  • Over 90 days past due

Each unpaid invoice lands in the appropriate bucket based on days elapsed since the due date, and the report totals each column. A business where 85 percent of receivables are current and only 2 percent sit in the 90-plus column is in a fundamentally different position than one where 25 percent of receivables are over 90 days old.

External auditors read this report closely, and the data drives some of the most consequential estimates on the balance sheet. The numbers feed directly into the calculation of expected losses on receivables, which affects reported assets, expenses, and ultimately net income.

Estimating What You Will Not Collect

Under generally accepted accounting principles, receivables must appear on the balance sheet at the amount you actually expect to collect, not the amount you invoiced. The gap is bridged with an allowance for doubtful accounts, a contra-asset account that reduces gross receivables down to the expected collectible amount. When you increase the allowance, the offsetting entry hits the income statement as bad debt expense.

The logic follows the matching principle: the estimated cost of customers who will not pay should be recognized in the same period as the revenue those sales generated. Waiting for a specific customer to default would overstate income in earlier periods and dump losses into later ones.

The Aging Method

Businesses typically estimate the allowance in one of two ways. The simpler approach applies a flat percentage to total credit sales for the period. It ignores the current condition of outstanding balances. The more informative approach is the aging method, which assigns a different expected loss rate to each bucket on the aging schedule. The 1–30 day bucket might carry a 2 percent loss rate while the over-90-day bucket might carry 40 percent or more. Multiplying each bucket’s balance by its loss rate and adding the results gives you the required ending balance in the allowance account.

When you later determine that a specific customer’s balance is uncollectible, you write it off by reducing both the allowance and the receivable by the same amount. Because the expense was estimated and recorded in a prior period, the write-off itself does not change net income or the net value of receivables. It clears a balance everyone already expected would not be collected.

CECL and the 2025 Practical Expedient

The current expected credit losses model under ASC 326 requires companies to estimate lifetime expected credit losses at the time a receivable is first recorded, using historical data, current conditions, and reasonable forecasts about the future.1Financial Accounting Standards Board. FASB Staff Q&A – Topic 326, No. 2 For aging-based estimates, the loss percentages assigned to each bucket should reflect not just historical experience but what economic conditions suggest about future collectibility.

In 2025, the FASB issued ASU 2025-05 to ease some of the complexity. The update offers all companies a practical expedient allowing them to assume that current conditions at the balance sheet date will not change over the remaining life of the receivable. Non-public entities get an additional option: they can factor in collections that actually occur after the balance sheet date but before the financial statements are issued, which often reduces the required allowance significantly.2Financial Accounting Standards Board. ASU 2025-05 Financial Instruments – Credit Losses (Topic 326)

A Note on Direct Write-Off

Recording bad debt expense only when a specific account is confirmed uncollectible is simpler, but GAAP does not permit it for financial reporting because it violates the matching principle. The IRS does allow direct write-off for tax purposes, so many businesses keep the allowance method on their books and use direct write-off on their returns.

Writing Off a Bad Debt on Your Tax Return

Tax treatment of a worthless receivable depends almost entirely on your accounting method. Accrual-basis businesses reported the income when the sale was made, so the IRS allows a deduction when the debt becomes wholly or partially worthless.3Office of the Law Revision Counsel. 26 USC 166 – Bad Debts The deduction belongs on the business return for the year the debt becomes worthless.4Internal Revenue Service. Topic No. 453, Bad Debt Deduction

Cash-basis businesses generally get no deduction. Because cash-method taxpayers record income only when payment arrives, there is nothing previously reported to write off, and the IRS will not let you deduct money you never claimed as revenue.

To support the deduction you need to show the debt is genuinely worthless and that you took reasonable steps to collect it. A court judgment is not required, but you do need evidence that a judgment would be uncollectible. The deduction must be taken in the year the debt becomes worthless, not earlier and not later, which is a timing question that trips up many businesses.4Internal Revenue Service. Topic No. 453, Bad Debt Deduction

Metrics That Flag a Problem Early

Two ratios give the clearest read on how well your collection process is working.

Days sales outstanding measures the average number of days between making a sale on credit and collecting the cash. Divide accounts receivable by total credit sales for the period, then multiply by the number of days in the period. If your terms are Net 30 and DSO is running at 52, customers are taking nearly three weeks longer to pay than your terms allow. A rising DSO is often the first quantitative signal that aged balances are building up.

Accounts receivable turnover measures how many times you collect your average receivables balance during a period. Divide net credit sales by average accounts receivable. A turnover of 12 means you are collecting the equivalent of your full receivables balance once a month, which is healthy for most businesses. A declining turnover ratio signals that cash is sitting in receivables longer than it should.

Neither number tells you much in isolation. The value comes from watching them over time and comparing them to your credit terms. A DSO that drifts upward quarter after quarter means something is breaking down, whether that is customer financial health, invoicing accuracy, or collection effort.

Collecting Past-Due Balances

The most effective collection strategy is one you never have to use. Strong credit screening before extending terms, accurate and timely invoicing, and clear communication of due dates keep most accounts from aging in the first place.

Once a balance is past due, structure matters more than intensity. A typical escalation pattern uses automated reminders in the first week or two after the due date, a personal phone call or email at 30 days, and a formal demand letter at 60 days. The goal is to increase pressure gradually while preserving the customer relationship where possible.

Handing the balance to a collection agency or pursuing legal action usually comes at the 90-day mark, after internal efforts have failed. Commercial collection agencies typically charge contingency fees ranging from 30 to 50 percent of the amount recovered, so the math only works when the alternative is writing the balance off entirely. Most states impose a statute of limitations on debt collection lawsuits, generally falling between three and six years depending on the jurisdiction and the type of obligation.5Consumer Financial Protection Bureau. Can Debt Collectors Collect a Debt That’s Several Years Old? Miss that window and you lose the ability to sue, regardless of how valid the debt is.

What the FDCPA Does and Does Not Cover

If you use a third-party collection agency to pursue consumer debts, the Fair Debt Collection Practices Act governs how that agency can operate. The FDCPA applies specifically to debts incurred for personal, family, or household purposes.6Office of the Law Revision Counsel. 15 USC 1692a – Definitions Business-to-business debts fall outside the statute’s scope, so commercial debt collection is not subject to the same restrictions on contact methods, timing, and disclosure.7Federal Reserve. Fair Debt Collection Practices Act That does not mean anything goes in B2B collection, but the federal regulatory framework is considerably lighter.

Turning Aged Receivables Into Cash

Aged receivables do not have to sit on the balance sheet waiting for customers to pay or for write-off. Two financing arrangements convert them into immediate cash.

Factoring involves selling your outstanding invoices to a third party at a discount. The factor typically pays 80 to 90 percent of the invoice value upfront, then collects directly from your customer. After the customer pays in full, the factor remits the balance minus its fee. In a recourse arrangement, you are on the hook if the customer never pays. In a non-recourse arrangement, the factor absorbs the credit risk, though typically only for customer insolvency, not for disputes or documentation problems.

Invoice discounting works more like a secured loan. A lender advances you a percentage of your receivables balance, and you continue collecting from customers yourself. As payments come in, you repay the lender plus an agreed-upon fee. Because the lender has less control over collections, invoice discounting generally requires a proven track record of reliable customers and is more common among larger businesses.

Both arrangements have a cost, but they can be worth it when the alternative is a cash flow gap that forces you to miss payroll or turn down new business. Trade credit insurance adds another layer: it covers losses from customer non-payment due to insolvency or protracted default, and insured receivables often qualify for better borrowing terms because lenders view them as lower risk.