An aging report is an accounting document that sorts every unpaid invoice by how long it has been outstanding, grouping balances into time-based buckets so you can see at a glance who owes money and how overdue each balance is. Businesses run aging reports on both sides of the ledger: accounts receivable (what customers owe you) and accounts payable (what you owe vendors). Most cloud-based accounting software produces one in a few clicks, and the real value comes from reviewing it on a regular schedule and acting on what it tells you about cash flow and collection risk.
How the Aging Buckets Work
An aging report divides outstanding balances into columns based on how long each invoice has been open, usually measured from the invoice date. The standard intervals are:
- Current (0–30 days): not yet past due or only recently overdue. Low risk.
- 31–60 days: payment is late. Worth a follow-up call or email.
- 61–90 days: collection risk is climbing. Many businesses escalate here.
- Over 90 days: highest risk. These balances often become candidates for bad debt write-offs or third-party collection.
Some businesses age invoices from the due date instead of the invoice date. The practical difference is straightforward: on Net 30 terms, an invoice 120 days from the invoice date is only 90 days past the due date. Aging from the invoice date is more common because the invoice date is a fixed starting point that doesn’t shift when you renegotiate terms. Either method works if you use it consistently.
Each column totals the dollar amount sitting in that bucket. When a large share of receivables clusters in the 61–90 or over-90 columns, the collection process needs attention. A healthy report has the heaviest concentration in the current column and progressively smaller amounts in each older bucket.
Accounts Receivable vs. Accounts Payable Aging
The receivable side tracks every dollar customers owe you for goods or services delivered on credit. This is where most businesses get the most value, because it points to the specific customers falling behind and lets you prioritize follow-up by the age and size of each balance. The receivable aging report is also the foundation for estimating your allowance for doubtful accounts, the amount you expect never to collect. The standard method assigns a progressively higher estimated loss rate to each older bucket. Balances in the current column might carry a 1% loss estimate; invoices over 90 days past due might carry 15% or more. Multiplying each bucket’s total by its loss rate gives the allowance figure that reduces accounts receivable on the balance sheet, so your financial statements don’t overstate what you actually expect to collect.
Aging data also drives credit decisions. If a customer’s invoices consistently land in the 60-plus-day columns, that’s a reason to tighten their credit limit, require partial payment upfront, or move them to cash on delivery.
The payable side uses the same structure to track what you owe vendors. The goal flips. Instead of collecting faster, you want to pay on time without paying so early that you tie up cash unnecessarily. A clean payable aging report protects your credit with suppliers and helps capture early payment discounts. A common structure is 2/10 Net 30: a 2% discount if you pay within 10 days, otherwise the full amount is due in 30 days. That 2% for paying 20 days early annualizes above 36%, which makes it one of the cheapest sources of savings available to most businesses.
Days Sales Outstanding: The Key Metric
Days Sales Outstanding (DSO) is the single most useful metric you can pull from a receivable aging report. It tells you, on average, how many days it takes to collect payment after a sale. The formula is straightforward: divide total accounts receivable by net credit sales for a period, then multiply by the number of days in the period. For a quarterly calculation, divide the receivable balance by credit sales for the quarter and multiply by 90.
A good DSO depends on your industry and payment terms. On Net 30 terms, a DSO of 32 days means you’re collecting almost exactly on schedule. A DSO of 55 days on the same terms means customers are routinely paying nearly a month late. Construction companies commonly run DSOs of 60 to 90 days or more; retail businesses often land between 5 and 20 days. The number itself matters less than the trend. A DSO that climbs quarter after quarter signals a deteriorating collection process even when the absolute figure still looks reasonable.
Data You Need to Build One
Every aging report pulls from the same core data points in your general ledger or accounting software:
- Customer or vendor name.
- Invoice number.
- Invoice date, which anchors the aging calculation.
- Payment terms (Net 15, Net 30, Net 60, or whatever you’ve agreed to), which set the due date.
- Amount due, after any partial payments already received.
Accounting software stores this information in the receivable or payable modules and updates it as payments come in. If you’re building the report in a spreadsheet, you need to enter or export all five points for every open invoice. Missing or incorrect invoice dates are the most common source of errors, because a wrong date drops the balance into the wrong bucket and distorts the entire picture.
Generating the Report
In most cloud accounting platforms, generating an aging report takes about 30 seconds. Go to the reporting section, look for “Accounts Receivable Aging Summary” or “A/R Aging Detail,” and set an “as of” date. That date is the reference point the software uses to calculate the age of every open invoice. The summary version groups totals by customer, which is useful for a quick overview. The detail version lists every individual invoice, which is what you need when calling customers about specific overdue bills. Most platforms let you filter by customer, date range, or minimum balance.
After the report generates, compare the grand total against your general ledger’s accounts receivable balance. If they don’t match, you likely have unapplied payments, duplicate entries, or invoices that were entered but never sent. Reconciling those differences before you act on the report keeps you from chasing customers who have already paid.
If you don’t use accounting software, you can build the report in any spreadsheet. Create columns for customer name, invoice number, invoice date, due date, amount due, and the aging buckets. Use a formula that subtracts the invoice date from today’s date, then conditional logic to sort each invoice into the correct bucket. Manual reports carry more error risk: duplicate entries, unrecorded partial payments, and payments applied to the wrong customer are all common. The manual approach works for very small operations, but the time and error risk climb fast once you have more than a few dozen open invoices at any given time. Cloud accounting software with built-in aging reports runs roughly $40 to $275 per month depending on the tier.
How Often to Review It
The right frequency depends on sales volume and payment terms. High transaction volumes or short payment terms call for weekly reviews, because invoices can slip into the 60-day column fast when terms are Net 15. Lower-volume businesses on Net 30 or Net 60 can often get by with monthly reviews.
Whatever interval you choose, make it a standing calendar item, not something you do when cash feels tight. By the time you notice a cash flow problem, the aging report would have flagged it weeks earlier. Consistent reviews also give you trend data. You can spot a customer gradually paying later over three or four months instead of discovering they’re 90 days overdue all at once.
What to Do With Each Bucket
The report is only useful if you act on it. Most businesses follow this escalation pattern:
- 0–30 days past due: send a gentle payment reminder. Many invoices at this stage are simple oversights, and a brief email often resolves them.
- 31–60 days past due: follow up directly with a phone call or a firmer written notice. Ask whether there’s a dispute or a cash flow issue on the customer’s end. This is also when many businesses begin charging late fees, which commonly run around 1% to 2% of the outstanding balance per month.
- 61–90 days past due: escalate internally. Consider a credit hold so no new orders ship until the balance is paid. Evaluate whether a structured payment plan makes sense for a customer you want to keep.
- Over 90 days past due: the likelihood of collecting drops significantly. Options include turning the account over to a third-party collection agency, pursuing legal action, or writing off the balance as bad debt. Some businesses make a final demand before referring the account out.
Dollar amounts and relationships should drive your decisions. Writing off a $200 invoice from a one-time customer is a different judgment call from putting a $50,000 balance on credit hold for a client who represents 15% of your revenue.
Writing Off Bad Debt
When an invoice proves uncollectible, writing it off as bad debt removes it from accounts receivable and adjusts your financial statements to reflect reality. Under federal tax law, businesses using the accrual method can deduct bad debts, either in full for debts that are completely worthless or in part for debts that are only partially recoverable. The deduction is limited to the amount previously included in gross income.
Cash-method taxpayers face a stricter rule. Because you haven’t yet reported the unpaid amount as income, there is generally nothing to deduct. You never received the money, and you never told the IRS you earned it, so there is no write-off to take.
To claim the deduction, you have to show the debt is genuinely worthless. The IRS looks at all relevant evidence, including the debtor’s financial condition, the value of any collateral, and whether pursuing legal action would realistically result in payment. A customer’s bankruptcy filing is generally treated as evidence that at least part of an unsecured debt is worthless. You don’t have to sue every deadbeat customer before claiming the deduction, but you do need to show that collection efforts would be futile. Corporations report bad debt deductions on Form 1120, which reduces taxable income for the year the debt becomes worthless or is partially charged off.
Legal Boundaries on Collections
If you’re collecting your own invoices in your own company’s name, the federal Fair Debt Collection Practices Act generally does not apply to you. That law covers third-party debt collectors, not businesses collecting debts they originated. If you use a name other than your own in the collection process in a way that suggests a third party is involved, you can lose that exemption.
Once you hand an account to a collection agency, the FDCPA applies fully. The agency has to follow strict rules on when and how they contact the debtor, what they can say, and how they handle disputes. Choosing a reputable agency matters, because FDCPA violations by your collector can create legal exposure and damage business relationships.
Every state sets its own statute of limitations on collecting unpaid debts. Most states allow between three and six years for actions on written contracts, though some allow longer. Once the statute of limitations expires, you lose the ability to enforce the debt through the courts. Your aging report won’t track this automatically, so for any balance sitting in the over-90-day column for an extended period, confirm you haven’t run out of time to pursue it legally.
A Quiet Role in Fraud Detection
Aging reports also help expose a scheme called lapping, where an employee steals an incoming payment from Customer A, then covers the shortfall by applying Customer B’s later payment to Customer A’s account, and so on. The report can surface the pattern because lapped accounts show erratic aging behavior: balances that should be current keep cycling through the older buckets in ways that don’t match the customer’s actual payment history.
The key control is separating responsibilities. The person who opens mail and processes incoming payments should not be the same person who reviews the aging report. When one person handles both, they can manipulate the records to hide stolen payments. Having a supervisor or owner independently review the aging report on a regular schedule makes lapping schemes much harder to sustain.