Overdue Percentage Calculator
Out of all the money customers owe your business, how much is already past due? That single number, the overdue percentage, is one of the most watched indicators in accounts receivable management, because a rising overdue share means slower cash flow, higher collection costs, and growing bad-debt risk. The calculator below measures it three ways: by dollar value of receivables, by invoice count, and with a full aging-bucket breakdown, and it adds a plain-language health rating so you know at a glance whether the number needs attention.
Overdue Percentage Calculator
By value, by invoice count, or by aging buckets, with a plain-language health rating.
Quick Answer
A company with $200,000 in total receivables and $50,000 past due has an overdue percentage of 25.00%, which this calculator rates Watch: on-time receivables are $150,000.00 (75.00%). The calculator above is pre-filled with this exact example. As a rough benchmark, at or below 10% is healthy, 10% to 25% is a watch zone, and above 25% needs action.
Key takeaways
- Overdue percentage = (overdue amount / total receivables) x 100. The denominator is everything outstanding, never just the overdue part.
- The aging-buckets mode is the most revealing: it shows where late balances concentrate, and a growing 90+ day bucket is the earliest bad-debt warning.
- Count-based and value-based percentages can disagree sharply when a few large invoices dominate, so check both.
- Track the trend month to month. A single reading says little; a rising one says collections are slipping.
How to use the overdue percentage calculator
The calculator opens on the By value ($) tab: enter the total receivables outstanding and the dollar amount already past due. This is the version most finance teams report, because a few large overdue invoices matter more than many small ones.
Switch to By invoice count for the operations view: enter the total number of open invoices and how many are overdue. This tells collections where the workload sits rather than where the dollars sit.
The Aging buckets tab splits receivables into current, 31–60 days, 61–90 days, and over 90 days past due. You get the overall overdue percentage plus each bucket's share of the total, which shows where the problem is concentrated. If you do not have the buckets yet, build the underlying schedule first with our aging schedule calculator. Blank buckets are treated as zero, so fill in only what you have. Press Calculate, read the health rating, then use Copy or Share to send the result to your team. Reset restores the worked-example figures.
The formula
The overdue percentage is the overdue portion divided by the total, times one hundred:
Overdue percentage = (overdue amount / total receivables) x 100
The same formula works for invoice counts: replace amounts with counts. Total receivables means everything outstanding, both current and overdue; the denominator is never just the overdue part. The on-time share is simply 100% minus the overdue percentage. In aging mode the total is the sum of all four buckets, and the overdue amount is the sum of the three past-due buckets.
Worked example
A company has $200,000 in total receivables and $50,000 past due. Overdue percentage = (50,000 / 200,000) x 100 = 25.00%. On-time receivables are $150,000 (75.00%). At exactly 25%, the health rating reads Watch: collections need tightening before the number drifts into the action zone.
Aging example: current $100,000, 31–60 days $20,000, 61–90 days $15,000, over 90 days $15,000. Total = $150,000; overdue = $50,000; percentage = 33.33% (Action needed). Bucket shares of the total: current 66.67%, 31–60 days 13.33%, 61–90 days 10.00%, over 90 days 10.00%. The growing 90+ day bucket is the warning sign here.
| Mode | Inputs | Overdue percentage | Health rating |
|---|---|---|---|
| By value | Total $200,000, overdue $50,000 | 25.00% | Watch |
| By invoice count | 1,000 invoices, 75 overdue | 7.50% | Healthy |
| Aging buckets | 100,000 / 20,000 / 15,000 / 15,000 | 33.33% | Action needed |
Every figure above reproduces exactly in the tool. Try the same inputs yourself: the calculator is pre-filled with the by-value example.
Reading your result: what the health rating means
The health rating applies the same three bands every finance team argues about, stated openly so there is no mystery:
| Overdue percentage | Rating | What it means |
|---|---|---|
| At or below 10% | Healthy | Collections are in good shape; keep monitoring monthly. |
| 10% to 25% | Watch | Tighten follow-up on late accounts before it drifts higher. |
| Above 25% | Action needed | Review credit terms, escalate collections, and consider reserves for bad debt. |
The boundaries are inclusive on the lower side: exactly 10.00% reads Healthy and exactly 25.00% reads Watch. That is a judgment call baked into the tool, disclosed here so it never surprises you. The right level varies by industry and payment terms, so watch the trend month to month rather than a single reading. A useful companion is average days delinquent: where the overdue percentage tells you how much of the ledger is late right now, days delinquent tells you how late it is on average.
Two more companion metrics complete the picture: the gross collection percentage shows how much billed revenue you actually collect, and the net collection rate adjusts for what will never be collected.
Why the aging breakdown matters more than the headline number
A single 20% overdue figure can hide two very different situations: $18,000 sitting 31–60 days out with almost nothing older, or $18,000 almost entirely over 90 days. The first is a follow-up problem; the second is a write-off problem. That is why the aging tab reports each bucket's share of the total alongside the headline percentage. The chart below shows the worked aging example: two-thirds of the ledger is current, and the 90+ day bucket already holds a tenth of everything outstanding.
Aging example: share of $150,000 total receivables
Track this shape monthly. When the green bar shrinks and the red bar grows, your percentage change in the headline number will already be telling the same story, but the chart tells you which customers to call first.
What competing calculators miss
Most overdue calculators on the web do exactly one thing: divide one overdue figure by one total and print a percentage. That is honest arithmetic, but it leaves the interesting questions unanswered.
Paidnice's overdue receivables ratio page has the crispest definition of the metric and pairs it sensibly with days sales outstanding, but its interactive widget stops at the single ratio: no aging buckets, no invoice-count view, no reading of whether the result is good or bad. Emagia's average-days-delinquent guide has a genuinely useful metric comparison table, yet offers no calculator at all. BraveCalculator's overdue percentage tool covers the basic two-input calculation with a worked example, but again only one mode, and its only guidance is a flat "keep below 10%" with no watch zone in between. InvoiceSherpa's aging guide goes deeper into the allowance for doubtful accounts, assigning estimated uncollectible percentages per bucket, which is a different metric from overdue percentage and easy to confuse with it. MDClarity's percent-of-AR-over-90-days page is a solid healthcare KPI definition, but a definition only.
The winning moves in this tool: (1) three modes on one page, because value, count, and aging answer different questions and rivals offer one; (2) a plain-language health rating with its thresholds printed openly, including the inclusive-boundary behavior at exactly 10% and 25%; (3) per-bucket shares of total inside aging mode, so concentration risk is visible instead of hidden inside one number; (4) the overdue-percentage vs. days-delinquent vs. bad-debt-allowance disambiguation that the guides blur together.
Frequently asked questions
As a rough benchmark, at or below 10% of total receivables is healthy, 10% to 25% is a watch zone where you tighten follow-up on late accounts, and above 25% means collection problems are dragging on cash flow. Those are the exact bands this calculator's health rating uses. The right level varies by industry and payment terms, so the trend matters more than any single month.
Because value, count, and aging answer different questions. By value is what finance teams report: a few large overdue invoices matter more than many small ones. By invoice count shows the collections workload: 75 overdue invoices out of 1,000 is a different week than 3 out of 10, even at similar percentages. Aging buckets show where the problem concentrates, which neither of the other two can do.
The tool treats the boundaries as inclusive on the lower side: 10.00% or below is Healthy, up to and including 25.00% is Watch, and anything above 25% needs action. That is a judgment call baked into the calculator, disclosed here so it never surprises you. If your company's policy uses stricter bands, read the percentage itself and apply your own.
Concentration. Two ledgers can both show 20% overdue while one has everything 31 to 60 days out (a follow-up problem) and the other has most of it over 90 days (a write-off problem). The aging tab prints each bucket's share of the total next to the headline percentage, so you can see at a glance whether late balances are fresh or fossilized.
No. Blank buckets are treated as zero, so enter only what you have. The one rule is that at least one bucket must be greater than zero, otherwise there is nothing to divide by and the tool asks for a positive amount. Negative bucket amounts are rejected.
Overdue percentage tells you how much of the ledger is already late right now. Days sales outstanding (DSO) tells you how long collection takes on average, including the invoices that paid on time. A ledger can have a low overdue percentage but a high DSO if terms are long, or a high overdue percentage with a decent DSO if a few accounts are very late. Track both.
No. Overdue percentage measures lateness, not collectibility. The allowance for doubtful accounts is the separate accounting estimate of what will never be paid, and under current expected-credit-loss rules companies must estimate it from historical loss rates by aging bucket. A ledger can be 5% overdue and still need a serious reserve if the 90+ day bucket keeps growing.
The tool accepts them without rounding: 2.9 overdue out of 10 invoices computes as 29.00% with 7.1 shown as on time. In practice invoice counts are whole numbers, so round your inputs before entering them. The acceptance of fractions is a quirk of the input validation, not a feature.
Add This Calculator to Your Website
Embed this calculator on your own site with the code below. Pick a size to preview it live, then copy the code.
Powered by Calculator Zilo
References
- Federal Reserve Bank of St. Louis (FRED). Delinquency Rate on Business Loans, All Commercial Banks. Accessed October 23, 2026.
- Board of Governors of the Federal Reserve System. Senior Loan Officer Opinion Survey on Bank Lending Practices. Accessed October 23, 2026.
- Board of Governors of the Federal Reserve System. Charge-Off and Delinquency Rates on Loans and Leases at Commercial Banks. Accessed October 23, 2026.
- U.S. Census Bureau. Quarterly Financial Report for Manufacturing, Mining, Wholesale Trade, and Selected Service Industries. Accessed October 23, 2026.
- Federal Deposit Insurance Corporation. Quarterly Banking Profile. Accessed October 23, 2026.
- IFRS Foundation. IFRS 9 Financial Instruments (expected credit loss model). Accessed October 23, 2026.
- Financial Accounting Standards Board. Accounting Standards Codification, Topic 310: Receivables (ASC 310; Codification access is login-walled). Accessed October 23, 2026.
- U.S. Securities and Exchange Commission. Beginners' Guide to Financial Statements. Accessed October 23, 2026.
- U.S. Small Business Administration. Manage your business finances. Accessed October 23, 2026.
- U.S. Bureau of Labor Statistics. Consumer Expenditure Survey (spending and credit-use context). Accessed October 23, 2026.