To calculate AR aging days, subtract the invoice date from your reporting date; the result is that invoice’s age in days. Do this for every open invoice on your accounts receivable ledger, group the results into standard time buckets, and you have an aging report. From there you can compute a simple or weighted average across the portfolio, flag accounts that need collection attention, and support both your bad debt reserve and any tax write-off you claim later.
What You Need Before You Start
Three inputs drive every aging calculation. The invoice date printed on each billing document, which marks day zero. Your reporting cutoff, usually the last day of a fiscal month or quarter. And the remaining balance on each invoice after any partial payments or credits. Pull all three from your accounts receivable subsidiary ledger or accounting software rather than from memory or email. An error in any one of them cascades through every number that follows.
You also need to know the credit terms extended to each customer. The aging math doesn’t change with terms, but your reading of the result does. An invoice aged 40 days is unremarkable under Net 60 and ten days late under Net 30.
Calculating Days Outstanding for a Single Invoice
The arithmetic is one subtraction. Reporting date minus invoice date equals age in days.
Invoice a customer $5,000 on October 1, run the report on October 15, and the age is 14 days. A different invoice dated June 15 with a July 30 reporting date is 45 days old. Repeat across every open invoice. Accounting software automates this, but knowing the underlying math matters when a report looks off or when you’re rebuilding the calculation in a spreadsheet.
The subtraction is doing more analytical work than it looks. Every additional day an invoice sits unpaid raises the odds it becomes uncollectible, and receivables past 90 days are substantially harder to collect than those under 60.
Aged and Past Due Are Not the Same
An invoice’s age is simply the number of calendar days since it was issued. Whether it’s past due depends on payment terms. On Net 30, an invoice becomes past due on day 31. On Net 60, that same invoice is still current at day 45. Aging reports that ignore the distinction can make receivables look worse than they are and trigger premature collection calls that damage customer relationships.
Some companies run aging from the invoice date regardless of terms and adjust mentally. Others configure the software to start the clock at the due date, so every invoice in the 1–30 bucket is genuinely one to thirty days late. Either approach works. Mixing them across customers or reporting periods makes trend comparisons meaningless.
Grouping Invoices Into Aging Buckets
Once you have an age for every open invoice, sort them into standard intervals:
- Current, 0 to 30 days. Invoices within or near standard payment terms. Healthy receivables live here.
- 31 to 60 days. Mildly overdue under Net 30. Usually worth a reminder call, not an alarm.
- 61 to 90 days. Getting stale. Most credit departments escalate at this stage.
- 91 to 120 days. Significant non-payment risk. Many companies open formal collection procedures here.
- Over 120 days. High probability of non-collection. These balances move toward write-off review or referral to a collection agency.
An invoice aged 73 days goes into the 61–90 bucket. Consistency matters because these groupings feed directly into your year-end allowance for credit losses. Under current accounting standards, aging schedule analysis is one accepted method for estimating expected credit losses on trade receivables, which makes bucket accuracy a financial reporting concern and not only an operational one.
Averaging Aging Days Across the Portfolio
An aging report tells you where individual invoices stand. To describe the portfolio in a single number, use one of two averages. The choice between them changes the answer more than most people expect.
Simple Average
Add the aging days for every open invoice and divide by the number of invoices.
Simple Average Aging Days = Total Aging Days of All Invoices ÷ Number of Invoices
Ten invoices with ages totaling 400 days give you a simple average of 40 days. The formula is clean but treats a $200 invoice and a $200,000 invoice as equally important. A handful of small, ancient invoices you haven’t written off can drag the number up and make collection performance look worse than it is. One massive invoice barely past due can mask real problems on smaller accounts.
Weighted Average
The weighted version factors in dollar amounts. Multiply each invoice’s outstanding balance by its age, sum the products, and divide by the total outstanding balance.
Weighted Average Aging Days = Sum of (Each Invoice Balance × Its Age in Days) ÷ Total Outstanding Balance
A $50,000 invoice aged 10 days paired with a $5,000 invoice aged 90 days gives a simple average of 50 days but a weighted average closer to 17, because the large, recent invoice dominates. The weighted version is the more honest portfolio view. Use it for benchmarking and board reporting. Use the simple average when hunting individual problem accounts.
Aging Days Versus Days Sales Outstanding
Aging days and DSO get confused constantly. They answer different questions. DSO measures the average number of days it takes to collect cash from credit sales across a period:
DSO = (Average Accounts Receivable ÷ Net Credit Sales) × 365
DSO incorporates sales volume. If revenue doubles while your receivable balance stays flat, DSO drops even if individual invoices are collecting no faster. Aging days look only at what’s sitting unpaid right now and how long each balance has been there. DSO is a velocity metric; aging days are a snapshot. A healthy DSO with a growing over-90 bucket means new invoices are collecting fast while old problems fester. You need both views.
Handling Credits and Partial Payments
Partial payments and credits can quietly distort the report. When a customer pays part of an invoice, reduce that invoice’s outstanding balance before running the report. The age doesn’t move because the invoice date hasn’t changed, but the dollar exposure drops, which shifts your weighted average and your bucket totals.
Unapplied credits are the harder case. A credit memo issued but not yet matched to a specific invoice can cause the report to overstate what the customer owes. Most accounting software lets you choose whether unapplied credits count against aging totals. Including them gives a truer picture of net exposure. Excluding them overstates risk but keeps loose credits visible. Pick one approach, document it, and stay consistent so month-to-month comparisons hold.
What the Aging Number Feeds Into
Accurate aging days do work beyond the collections queue. Under federal tax law, a business bad debt becomes deductible when it is wholly or partially worthless. A completely uncollectible debt qualifies for a full deduction in the year it becomes worthless. A partially recoverable debt can be deducted for the portion charged off, but only with IRS approval of the partial write-off. To claim the deduction, you have to show reasonable collection efforts, and your aging report is the paper trail that proves when an invoice went delinquent and how long you pursued it.
The IRS generally requires the specific charge-off method, meaning you deduct each individual debt when it becomes worthless rather than maintaining a general reserve. That clashes with GAAP, where you estimate an allowance for credit losses using your aging buckets and historical loss rates. The GAAP allowance is a balance sheet figure, not a tax deduction. The tax deduction arrives only when you identify a specific receivable as worthless and charge it off. A detailed aging report supports both.
If an invoice ages long enough that you refer it to a third-party collection agency, the Fair Debt Collection Practices Act governs what that collector can do, including a written validation notice sent to the consumer within five days of first contact. The FDCPA applies to third-party collectors, not to your in-house collection efforts as the original creditor, but the dates and balances you hand off need to be right. Errors in the invoice date or outstanding balance can expose the collector to liability and delay recovery of the money you’re owed.