Aging Buckets
Enter your receivables data, then click analyze.
Embed This Calculator on Your Website
Add this free calculator to your blog, website, or CMS with a simple copy-paste embed code.
Introduction
Roughly 30% of small business invoices are paid late, and about 8% are never collected — according to Atradius Payment Practices Barometer data across North American B2B transactions. The problem is not usually a lack of invoicing. It is a lack of systematic tracking across aging buckets. Accounts receivable aging categorizes outstanding invoices by how long they have been unpaid: current, 1 to 30 days late, 31 to 60 days, 61 to 90 days, and 90+ days. Each bracket carries a different probability of collection and a different cost of delay. This AR aging calculator quantifies the dollar value in each bucket, calculates weighted average days outstanding, and estimates bad debt risk by bracket — giving you an actionable view of which receivables need immediate attention and which are likely unrecoverable.
What This Calculator Does
This accounts receivable aging calculator organizes your outstanding invoices into standard aging buckets and calculates the weighted average days outstanding across your AR portfolio. Enter the total dollar amounts in each aging bracket (current, 1 to 30, 31 to 60, 61 to 90, over 90 days) along with your historical collection rates per bracket. The calculator returns total AR, weighted average collection period, estimated uncollectable amount by bracket, and a recommended bad debt reserve. Use it for month-end close, credit management reviews, and cash flow forecasting.
The Formula
Each aging bucket is assigned a midpoint representing the average days outstanding within that range (e.g., 15 days for the current bucket, 45 days for the 31 to 60 bucket). The weighted average multiplies each bucket's balance by its midpoint and divides by total AR to produce a portfolio-level DSO. Historical loss rates per bucket typically increase significantly with age: current receivables might have a 1% loss rate while 90+ day receivables may carry a 40% to 70% loss rate based on your collection history.
Step-by-Step Example
Categorize invoices into aging buckets
Pull your AR ledger and total outstanding amounts by bracket: Current = $145,000, 1 to 30 days past due = $62,000, 31 to 60 days = $28,000, 61 to 90 days = $14,000, Over 90 days = $9,000. Total AR = $258,000.
Apply historical collection rates
Using industry-average collection rates: Current = 99% collected, 1-30 days = 96%, 31-60 days = 85%, 61-90 days = 65%, 90+ days = 40%. Estimated uncollectable: $1,450 + $2,480 + $4,200 + $4,900 + $5,400 = $18,430 in probable bad debt.
Calculate weighted average days outstanding
Assign midpoints: Current = 15 days, 1-30 = 45, 31-60 = 75, 61-90 = 105, 90+ = 120. Weighted average = ((145,000 x 15) + (62,000 x 45) + (28,000 x 75) + (14,000 x 105) + (9,000 x 120)) / 258,000 = approximately 41.5 days.
Identify collection priorities
The 61 to 90 day and 90+ buckets represent $23,000 — only 8.9% of AR but account for $10,300 of the $18,430 estimated bad debt, or 56% of your expected losses. These accounts require immediate escalation: direct phone contact, formal demand letters, or handoff to a collection agency.
Real-World Use Cases
Month-End Close and Reserve Calculation
A controller runs the aging report at month-end to calculate the required bad debt reserve under GAAP. With $9,000 in 90+ day receivables and a historical 55% loss rate on that bucket, they record a $4,950 reserve addition, bringing total allowance for doubtful accounts to $17,200 — a figure that feeds directly into the income statement.
Credit Limit Review
An AR manager identifies a single customer with $18,000 spread across the 31 to 60 and 61 to 90 day buckets. Cross-referencing the customer's credit file, they place the account on credit hold, halting additional shipments until balances are cleared. This prevents further exposure before the account potentially defaults.
Cash Flow Forecasting
A CFO uses the aging report with collection probability rates to build a 30 and 60 day cash inflow forecast. Expected collections: 96% of $62,000 (1-30 bucket) = $59,520, plus 85% of $28,000 (31-60 bucket) = $23,800. Projected cash inflow over 60 days from AR: $83,320 — a figure used to determine whether a credit line draw is necessary.
Comparison
| Aging Bucket | Typical Loss Rate (B2B) | Priority Level | Recommended Action |
|---|---|---|---|
| Current | 1% to 2% | Low | Standard invoice follow-up at day 28 |
| 1 to 30 days past due | 3% to 6% | Low-Medium | Automated reminder at days 7, 14, 30 |
| 31 to 60 days past due | 10% to 20% | Medium | Personal outreach, payment plan offer |
| 61 to 90 days past due | 25% to 45% | High | Formal demand letter, credit hold |
| Over 90 days | 40% to 70% | Critical | Collection agency or write-off evaluation |
Common Mistakes to Avoid
Using invoice date instead of due date to calculate aging. Aging should start from the invoice due date, not the invoice issue date. A net-30 invoice issued January 1 is current until January 31. Aging it from January 1 adds 30 phantom days to its age and misclassifies healthy receivables as past due.
Applying a single flat bad debt rate to all AR instead of bucket-specific rates. A blanket 3% reserve on $258,000 AR produces a $7,740 reserve. The bucket-weighted approach in this example produces $18,430 — more than twice as much. Under-reserving leads to overstated net AR on the balance sheet and surprise bad debt charges.
Ignoring concentration risk within buckets. Two customers might each owe $45,000 in the current bucket, but one is a Fortune 500 company and one is a startup with a shrinking bank balance. Aging aggregates mask individual customer credit risk — supplement the report with customer-level review for any single account exceeding 5% of total AR.
Frequently Asked Questions
Accuracy and Disclaimer
This calculator provides estimates for planning and analysis purposes only. Bad debt rates and collection percentages vary significantly by industry, customer creditworthiness, and economic conditions. Results do not constitute accounting advice. Consult a licensed CPA for proper bad debt reserve methodology and GAAP compliance.
Conclusion
An aging report is only as useful as the follow-up actions it drives. If your 61 to 90 day bucket is growing, that is a signal to review credit terms and escalate collection contact cadence — not just record a larger bad debt reserve. After identifying high-risk receivables, cross-reference with the Bad Debt Reserve Calculator to determine whether your current reserve adequately covers probable losses. For a broader working capital view, the Accounts Receivable Days Calculator shows how your overall DSO compares to industry benchmarks.
Related Accounting & Bookkeeping Calculators
Depreciation Calculator
Calculate asset depreciation using straight-line, 200% declining balance, or MACRS methods with full year-by-year schedules, 2026 bonus depreciation (20%), and Section 179 references.
Use CalculatorAccounting & BookkeepingCash Flow to Debt Ratio Calculator
Assess business solvency by calculating the cash flow to total debt ratio, debt service coverage ratio (DSCR), free cash flow, and estimated years to repay debt using 2026 lending benchmarks.
Use CalculatorAccounting & BookkeepingAccounts Payable Days Calculator
Calculate Days Payable Outstanding (DPO) from accounts payable and COGS data, analyze early payment discount annualized returns, and assess cash conversion cycle impact using 2026 industry benchmarks.
Use CalculatorAccounting & BookkeepingBad Debt Reserve Calculator
Calculate the allowance for doubtful accounts using the aging method with customizable uncollectible rates per bucket, determine the journal entry adjustment needed, and compare against 2026 bad debt benchmarks.
Use CalculatorAccounting & BookkeepingPayroll Reconciliation Calculator
Verify gross-to-net payroll calculations with 2026 FICA rates (Social Security 6.2% on $184,500 wage base, Medicare 1.45%, additional Medicare 0.9%), federal and state withholding, and pre-tax deductions.
Use CalculatorAccounting & BookkeepingBank Reconciliation Variance Calculator
Reconcile book balance vs bank balance with deposits in transit, outstanding checks, bank fees, interest earned, NSF checks, and error corrections with journal entry output.
Use CalculatorYou May Also Find Useful
Tax Calculator
Estimate your 2026 federal income tax based on filing status, gross income, deductions, and current tax brackets. See your marginal and effective tax rates instantly.
Use CalculatorFinance & AccountingSalary to Hourly Calculator
Convert your annual salary to an hourly wage instantly. Adjust for hours per week, weeks per year, and overtime to find your true hourly rate.
Use CalculatorFinance & AccountingCommission Calculator
Determine sales commissions based on revenue, rate tiers, and bonus structures.
Use Calculator