An aging schedule is a financial report that sorts a company’s unpaid invoices by how long they have been outstanding, grouping the balances into time buckets such as 0–30, 31–60, 61–90, and over 90 days. Businesses run it against money customers owe them (accounts receivable) and against money they owe suppliers (accounts payable). The report drives real decisions: who to call about a late payment, which bills to pay first, how much of the outstanding balance will realistically turn into cash, and how much may need to be written off.
What the Report Shows
Every line starts with the same core information: the customer or vendor name, the invoice number, the original invoice date, and the amount owed. The invoice date is the anchor. Software compares it against the reporting date, calculates how many days the balance has been unpaid, and drops it into the correct time bucket.
The reporting date matters more than people realize. Run the same schedule on two different days and you get two different pictures. A balance that looked current Monday can slip into the 31–60 day column by Friday. That’s why most businesses generate the report on a fixed cadence — weekly, biweekly, or monthly — so the snapshots line up over time. Each line should trace back to the original purchase order or contract, so anyone reviewing the report has a clear audit trail.
The Standard Time Buckets
Most aging schedules use four columns in 30-day intervals:
- 0–30 days: current invoices still within normal payment terms. These rarely signal a problem.
- 31–60 days: slightly overdue. Some are just slow payers, others are early warning signs.
- 61–90 days: significantly past due. The probability of collection drops noticeably here.
- Over 90 days: seriously delinquent. Candidates for escalated collection or write-off.
A balance can only sit in one bucket at a time. As days pass without payment, the invoice slides rightward across the report. Some businesses add a fifth column for balances over 120 days, but the four-column layout is the common starting point.
Receivable Aging Versus Payable Aging
The same structure works for both sides of the ledger, but the purpose flips.
An accounts receivable aging schedule lists customers and shows how much each owes and for how long. The goal is protecting cash inflow. When a customer’s balance drifts into the 61–90 day column, it’s a signal to pick up the phone before the debt ages further. Over time, the report also reveals patterns. If the same customer consistently pays late, you may need to tighten their credit terms or ask for a deposit up front.
An accounts payable aging schedule lists suppliers and vendors, showing what you owe each one and how long the invoice has been sitting. The goal here is managing cash outflow: paying on time to avoid late fees and keep supplier relationships intact, but not paying so early that you drain working capital. If too many balances stack up in the 60+ day columns, suppliers may start demanding prepayment or cut you off.
How Businesses Act on the Data
A report sitting in a drawer changes nothing. The value comes from tying specific actions to each bucket. On the receivable side, most businesses escalate as invoices age:
- 0–30 days: no action beyond confirming the customer received the invoice. Some companies send a friendly reminder before the due date.
- 31–60 days: a polite follow-up email or call. Most late payments get resolved here — the customer forgot, lost the invoice, or has a small dispute to clear up.
- 61–90 days: more direct contact, possibly a manager call or a formal demand letter. Some businesses pause future orders until the balance is settled.
- Over 90 days: serious collection efforts. Options include hiring a collection agency, negotiating a settlement, or pursuing legal action. This is also the point to evaluate a write-off.
On the payable side, the schedule helps treasury teams prioritize which bills to pay first. Invoices approaching a late-fee threshold or an early-payment discount get paid before those with more flexible terms. The report also helps forecast cash needs. If $200,000 in payables comes due next week and only $150,000 is on hand, someone has to negotiate an extension or secure a credit line before the shortfall hits.
Estimating Uncollectible Accounts
Not every receivable turns into cash. Accounting rules require businesses to estimate how much of their outstanding receivables they expect to lose, and the aging schedule is the primary tool.
Under the aging method (sometimes called the percentage-of-receivables method), accountants assign an estimated uncollectible percentage to each time bucket. The older the balance, the higher the percentage. A company might estimate that 1% of its 0–30 day balances will go unpaid, but 10% or more of its 90+ day balances will never be collected. Those percentages come from the company’s own historical experience. If 8% of your 90-day balances went bad over the past five years, that’s a reasonable starting point.
The total across all buckets becomes the Allowance for Doubtful Accounts, a contra-asset that reduces the value of accounts receivable on the balance sheet. The offsetting entry hits the income statement as bad debt expense, lowering reported profit for the period. If a company carries $500,000 in receivables and the aging analysis produces a $35,000 estimated loss, the balance sheet shows net receivables of $465,000.
For companies reporting under U.S. GAAP, the Current Expected Credit Loss (CECL) model under ASC 326 now governs how these estimates are built. CECL requires estimating expected losses over the life of the receivable from the moment it’s recorded, incorporating historical data, current conditions, and reasonable forecasts about the future.1Financial Accounting Standards Board. FASB Staff Q&A Topic 326, No. 1 Whether the Weighted-Average If a recession is looming and your customers sit in a vulnerable industry, CECL expects you to factor that in now, not after invoices start going bad. The aging schedule remains a central input; the analysis on top of it is more forward-looking than it used to be.
Deducting Bad Debts on Your Taxes
When a receivable genuinely becomes uncollectible, the loss can reduce your tax bill, though the IRS rules are stricter than most people expect.
A debt qualifies for deduction only when it becomes worthless, meaning there is no reasonable expectation of repayment. You need to show you took reasonable steps to collect, though you don’t have to file a lawsuit if a court judgment would be uncollectible anyway. The deduction must be claimed in the year the debt becomes worthless, not before and not after.2Internal Revenue Service. Topic No. 453, Bad Debt Deduction
Businesses using accrual accounting generally must use the specific charge-off method: individual bad debts are deducted as they become partly or totally worthless during the tax year. A partially worthless debt is deductible only up to the amount actually charged off on the books that year. A totally worthless debt is deductible for the full remaining balance. In both cases, the amount must have been previously included in gross income.3Internal Revenue Service. Tax Guide for Small Business
One boundary worth noting: the aging schedule and the tax deduction operate on different clocks. Booking an allowance under the aging method does not by itself produce a tax deduction. The IRS wants a specific debt that is actually worthless in a specific year.
Disclosure, Auditors, and the Collections Clock
For public companies, the aging schedule feeds into required disclosures. GAAP requires companies to disclose concentrations of credit risk. If one buyer accounts for 15% of your receivables and they go bankrupt, investors need to know that risk existed.
Auditors scrutinize the schedule closely. They look for invoices that have been sitting in the 90+ day column for months without being written off or reserved against, which can mean the company is overstating its assets. They also check whether the estimated loss percentages line up with the company’s actual historical write-off rates. A company claiming a 2% loss rate on 90-day receivables when its five-year average is closer to 12% will face pointed questions.
The report also intersects with debt collection timelines. Statutes of limitations on collecting debts based on written contracts range from 3 to 15 years depending on the state, with 6 years being the most common. Once that window closes, the business loses its legal right to sue for payment, so the aging schedule doubles as a practical reminder of how long you have to act.