Accounts Receivable & Invoice Aging Calculator

What is accounts receivable aging and why does the bucket distribution matter more than the total?

Accounts receivable aging is the process of categorizing all outstanding customer invoices by how long they have been unpaid. Rather than tracking a single AR balance, aging analysis breaks that number into time buckets — current (0–30 days), 31–60 days, 61–90 days, and 90+ days — to show not just how much you are owed, but how much of it you are realistically going to collect.

The critical insight is that the probability of collecting an invoice declines sharply and nonlinearly as it ages. Industry benchmarks based on collection data across B2B businesses:

This means a company with $120,000 in total AR does not actually have $120,000 coming in. If $8,000 of that sits in the 90+ bucket, the expected collection on that slice is only $4,000 — not $8,000. The difference is the at-risk amount, and it's the number that belongs in a cash flow forecast rather than the gross AR balance.

Two businesses with identical AR totals can have radically different financial positions depending on their bucket distribution. A company with 85% current AR and 2% in the 90+ bucket is in a completely different position from one with 55% current and 15% in the 90+ bucket — even if both show $120,000 on the balance sheet. The aging distribution is the signal; the total balance is just the headline.

How do I calculate DSO and what does excess DSO tell me that raw DSO doesn't?

DSO formula: (Accounts Receivable ÷ Annual Credit Sales) × 365

In the default scenario: ($120,000 ÷ $600,000) × 365 = 73.0 days. This means it takes an average of 73 days from invoice to cash.

Raw DSO is useful but incomplete without context. The more diagnostic metric is Excess DSO — the difference between your DSO and your stated payment terms: Excess DSO = DSO − Payment Terms = 73 − 30 = 43 days.

Those 43 days represent free short-term credit you are extending to customers who pay late. They are the days your cash sits in someone else's account instead of yours. A company with DSO of 50 on net-30 terms has a real problem — 20 days of excess float. A company with DSO of 50 on net-60 terms is performing well — customers are paying 10 days early on average.

The same DSO number tells completely different stories depending on payment terms, which is why most AR benchmarks that compare raw DSO across companies without adjusting for terms are misleading. Excess DSO normalizes for this: it is the number of days you are financing your customers for free, regardless of what your terms are.

A useful rule of thumb: acceptable DSO is roughly 1.0–1.5× your payment terms. DSO above 1.5× signals a collections problem. DSO above 2× on net-30 terms (i.e., above 60 days) means a significant portion of your AR is effectively past due.

What does a healthy AR aging report look like, and what are typical DSO benchmarks by industry?

Healthy aging distributions follow consistent patterns across most industries:

In the default scenario, the current bucket is 62.5% — below the 75% healthy threshold — which triggers the REVIEW NEEDED signal even though the 90+ bucket (6.7%) is within normal range. This pattern typically indicates that a meaningful cohort of customers is routinely paying 15–30 days late, which is addressable through automated reminders and payment terms enforcement rather than escalation.

DSO benchmarks by industry (median, U.S. B2B):

Construction and healthcare sit highest due to structural factors — progress billing, insurance reimbursement cycles, and contract dispute resolution periods — rather than collections failures. If your DSO is within 10 days of your payment terms, you are performing better than the majority of B2B businesses. Over 50% of global B2B invoices are overdue, and the average late payment is 8–10 days beyond terms.

When should I escalate a past-due invoice, and what does the at-risk amount tell me?

The aging bucket is the trigger for each escalation step. This is the standard tiered approach used by most credit departments.

31–60 day bucket (1–30 days past due): Automated follow-up. A polite email at day 7 past due, a second at day 14, and a third at day 28. No manual escalation unless the customer has a prior late-payment history. Collection rate is still 85–90%, so the probability math strongly favors low-friction outreach.

61–90 day bucket (31–60 days past due): Personal outreach. A direct call or email from someone with commercial authority — the account manager, finance director, or a senior partner — not just the AR team. At this stage, the collection rate has dropped to 70–80%, meaning 1 in 4 to 1 in 5 invoices in this bucket will not be collected without direct intervention.

90+ day bucket (60+ days past due): Formal demand. This is where you explicitly invoke your contract terms, apply late payment interest if your agreement allows it, and place the customer on credit hold for new orders. Collection rate is below 50%. The longer an invoice sits in this bucket, the faster the probability of recovery deteriorates.

120+ days: Collection agency or legal action. Agencies typically charge 25–50% of recovered amounts, which is steep but better than writing off 100% of the balance. For invoices under $500–1,000, small claims court is often more cost-effective than a collection agency.

The $13,875 at-risk amount in the default scenario — roughly 11.6% of total AR — is the number to watch over time. If it stays below 12–15% of total AR, you have a manageable collections situation. If it climbs above 20%, you have a credit policy problem that will compound until it affects cash flow materially.

What does a late-paying customer actually cost my business — beyond the obvious cash flow impact?

Late payment has a quantifiable financing cost that most businesses never calculate. When a customer pays 43 days late on net-30 terms, they have effectively borrowed 43 days of working capital from you at zero interest.

Annual cost of late payments = (Excess DSO ÷ 365) × Annual Credit Sales × Annual Cost of Capital. In the default scenario: (43 ÷ 365) × $600,000 × 9.6% = $6,786 per year.

Expressed as a percentage of each late-paid invoice value — Effective discount per late invoice = (Excess DSO ÷ 365) × Annual Cost of Capital = 1.13%. That 1.13% is the invisible discount you extend to every customer who pays past terms. It does not appear in your pricing model, your contracts, or your P&L — but it leaves your business in the form of financing cost every month. On $600,000 in annual sales, those 43 excess days cost nearly $7,000 per year in unrecoverable cash.

The number reframes the late-payment problem. It is not just a cash flow inconvenience — it is a pricing erosion. A customer who consistently pays 43 days late is effectively negotiating a 1.13% discount on every invoice, just informally and without your consent.

Three responses that address this directly rather than chasing payments after the fact:

• Late payment interest clauses: Legal in most jurisdictions, enforceable in most B2B contracts. A standard rate of 1.5% per month (18% annually) on balances past due both discourages late payment and recovers some of the financing cost when it occurs.
• Early payment discounts: A 2/10 net-30 term (2% discount if paid within 10 days) costs you 2% but accelerates cash collection by 20 days on average for customers who take it. The annualized cost to you is about 37% — expensive as a standing discount, but effective as a targeted offer to high-value or habitual late payers.
• Credit limit enforcement: The customers who consistently populate your 61–90 and 90+ buckets are receiving unlimited credit while paying the slowest. Linking credit availability to payment history — reducing credit limits or moving to prepayment for chronic late payers — addresses the problem structurally rather than invoice by invoice.