Aging accounts receivable is a report that groups every unpaid customer invoice into time-based categories, usually in 30-day increments, so a business can see how long each balance has been outstanding. It’s one of the most practical tools in accounting because it ties together three things that keep a company running: cash flow, credit policy, and the accuracy of the financial statements. When invoices start piling up in the older buckets, that’s typically the first sign collections need attention or a customer is in trouble.
What the Report Contains
Each line tracks a single customer’s unpaid balance using a handful of core data points. The customer’s name identifies who owes the money. Every open invoice appears with its dollar amount, invoice number, and the date it was originally issued. That issue date is the anchor for the whole report, because it determines how old the debt is and which bucket it falls into.
Most reports also show the customer’s payment terms (net 30, net 60, and so on) and their total credit limit. Comparing the outstanding balance against the credit limit is where the report earns its keep as a risk tool. If a customer’s unpaid invoices are bumping up against their credit ceiling, that’s a signal to tighten terms or hold new orders until the balance comes down. Accounting uses the same data to reconcile the accounts receivable subsidiary ledger to the general ledger, confirming that the total AR on the books matches the sum of all individual customer balances.
The Standard Time Buckets
Most aging reports use four categories:
- Current (0–30 days): invoices still within normal payment terms. Healthy receivable territory.
- 31–60 days: slightly past due. Worth a reminder, not yet alarming.
- 61–90 days: overdue enough to warrant direct follow-up and a closer look at the customer’s financial situation.
- Over 90 days: the danger zone. Collection probability drops significantly, and the balance may need to be reserved against or written off.
Each tier represents a higher level of risk. As a balance moves from one bucket to the next, the statistical likelihood of collecting it in full declines. Tracking that movement across several reporting periods reveals whether collection efforts are working or whether overdue balances are quietly growing.
When 30-Day Buckets Don’t Fit
Not every industry runs on a 30-day cycle. Construction companies routinely work with 45- to 65-day project timelines before an invoice is even generated, which naturally pushes receivables into later buckets. International customers, particularly in parts of Western Europe, commonly stretch payments to 60 days or more. Businesses in these situations often adjust their aging categories to match the actual rhythm of their sales. A construction firm might use 0–60, 61–90, and 90+ day buckets, while a SaaS company billing monthly subscriptions might use tighter 15-day intervals.
How the Report Drives Collections
The aging report is the working document behind the collections process. When a balance crosses from current into overdue, most businesses follow a predictable escalation, starting gentle and getting firmer.
An informal reminder usually goes out within about a week of the due date. A more formal notice follows around 15 to 30 days past due, restating the amount owed and the original terms. By 30 to 60 days overdue, the tone sharpens and the letter may reference potential consequences like credit reporting or suspended account privileges. A final notice around 90 days past due typically warns that the account will be turned over to a collection agency or referred to legal counsel if payment isn’t received by a stated deadline.
Collection energy should be concentrated on the oldest, largest balances, because those represent the most cash at risk. Patterns matter here too. A customer who consistently pays at 45 days on net-30 terms is a different conversation than one whose invoices suddenly stop getting paid at all. The first is a terms negotiation; the second is a red flag for financial distress.
Late Fees and Early Payment Discounts
Many businesses charge interest or flat fees on overdue invoices, and state usury laws cap what you can charge. Keeping the annual rate at or below 10% generally avoids legal trouble in most jurisdictions, but the fee also has to represent a reasonable estimate of the actual cost the late payment causes your business. A judge can strike down a fee that looks more like a penalty than a reflection of real damages.
The flip side is offering a carrot. Early payment discounts like “2/10 net 30” give the customer a 2% discount if they pay within 10 days, with the full amount due at 30. On a $100,000 invoice, that means collecting $98,000 twenty days early. The math works in the seller’s favor more often than you’d expect, because freed-up cash can be redeployed immediately rather than sitting in an aging bucket.
Legal Options When Collections Fail
When internal efforts don’t produce payment, businesses have a few legal routes. Turning the account over to a collection agency is common for smaller balances where litigation doesn’t make sense. For debts within the court’s jurisdictional limit, small claims court offers a relatively inexpensive way to obtain a judgment. Those limits vary widely by state, from as low as $2,500 to as high as $25,000.
One distinction trips people up: the federal Fair Debt Collection Practices Act governs how third-party debt collectors must behave, but it generally does not apply to a business collecting its own receivables. The statute defines a “debt collector” as someone who regularly collects debts owed to another party, and employees of a creditor collecting in the creditor’s own name are explicitly excluded.1Office of the Law Revision Counsel. 15 USC 1692a – Definitions There’s one exception: if your business uses a different name that makes it look like a third party is doing the collecting, the FDCPA does apply. The law also only covers consumer debts, so B2B collections fall under state commercial law instead.
Statute of Limitations
Every debt has a legal expiration date for filing a lawsuit to collect. Across the U.S., the limits range from roughly 3 to 10 years for written commercial contracts, though a few states go as short as 2 years for oral agreements or as long as 15 years for certain written instruments. The clock typically starts on the date of the last payment or the date the debt became delinquent. Making a partial payment or acknowledging the debt in writing can restart the clock in many states, which is worth knowing before you accept a token payment on a very old receivable.
Metrics Built From the Aging Report
The report feeds several metrics that tell you whether your collections operation is actually working.
Days Sales Outstanding
Days Sales Outstanding (DSO) measures the average number of days it takes to collect payment after a sale. Divide average accounts receivable by net revenue, then multiply by 365. A DSO of 45 means it takes 45 days on average to turn a credit sale into cash. Lower is better. If your standard terms are net 30 and DSO is creeping toward 50, customers are paying late, and the aging report will show exactly where the delays are concentrated.
Accounts Receivable Turnover Ratio
This one measures how many times per year a company collects its average receivable balance. Divide net annual credit sales by average accounts receivable. A ratio of 12 means you’re collecting the entire balance roughly once a month. A declining ratio over several periods signals that collections are slowing, credit terms may be too generous, or both.
Average Days Delinquent
Average Days Delinquent (ADD) isolates the collection problem more precisely than DSO alone. Subtract “best possible DSO” (using only current receivables) from actual DSO. The gap represents how many extra days, on average, invoices are sitting overdue beyond their terms. A rising ADD with a stable DSO means new sales are masking a growing delinquency problem in the older buckets.
Estimating Bad Debt on the Financial Statements
Beyond day-to-day collections, the aging report plays a direct role in preparing financial statements. Accountants assign a loss percentage to each bucket based on the company’s historical collection experience. Current invoices might get a 1% reserve, the 31–60 day bucket 5%, invoices over 90 days a 25% reserve or higher. Multiplying each bucket’s balance by its assigned percentage produces the total estimated allowance for doubtful accounts, which offsets the gross receivable on the balance sheet.
This is how the matching principle works in practice: the estimated loss is recognized in the same period the revenue was earned, not whenever the company finally gives up trying to collect. When an account is ultimately determined to be uncollectible, it’s written off against the allowance. Large write-offs reduce reported net income and signal to investors and lenders that the company’s revenue quality may be weaker than it appeared.
Companies that follow U.S. generally accepted accounting principles now estimate credit losses under the Current Expected Credit Loss (CECL) framework, which replaced the older “incurred loss” model. The shift is forward-looking: rather than waiting until a loss is probable, CECL requires businesses to estimate expected losses over the life of a receivable from the moment it’s recorded, incorporating past experience, current conditions, and reasonable forecasts.2Financial Accounting Standards Board. Measurement of Credit Losses for Accounts Receivable and Contract Assets Relying solely on historical loss rates is explicitly not enough. The aging report is still the starting point; the difference is that accountants layer in economic forecasts and adjust their percentages when conditions are changing rather than just rolling forward last year’s rates.
Deducting a Worthless Receivable on Your Taxes
Whether you can deduct a bad receivable depends entirely on your accounting method. Businesses using the accrual method have already recorded the revenue from the sale, so when the receivable turns out to be worthless, they can deduct it as a business bad debt.3Internal Revenue Service. Topic No. 453, Bad Debt Deduction Cash-basis businesses generally cannot take this deduction because they never included the unpaid amount in income in the first place. You can only deduct money you’ve already counted as earned.
To claim the deduction, you need to show the debt is genuinely worthless and that you took reasonable steps to collect. Going to court isn’t required if a judgment would clearly be uncollectible. The deduction must be taken in the year the debt becomes worthless, and a business can deduct partially worthless debts as well as fully worthless ones.3Internal Revenue Service. Topic No. 453, Bad Debt Deduction The aging report is your best documentation. An invoice that has sat in the 90+ day bucket for months, with documented collection attempts showing no response, builds the evidentiary case the IRS expects to see.