Downloadable tools are available at the bottom of the page

The overdue ratio measures the share of outstanding accounts receivable that has passed its contractual payment due date. Alongside Days Sales Outstanding (DSO) and the bad debt ratio, it is one of the most useful indicators for understanding the quality of a company's receivables and identifying where collection efforts are needed.

It is simple to calculate. Interpreting it correctly, however, requires more than looking at a single percentage.

How to calculate the overdue ratio

At a given reporting date, divide the value of overdue receivables by the total outstanding trade receivables, using the same perimeter, currency basis and reporting date for both figures.

Overdue ratio (%)

(Overdue accounts receivable / Total accounts receivable) × 100

Overdue receivables

Unpaid invoices with a due date earlier than the reporting date, net of correctly allocated payments and credit notes.

Total receivables

All unpaid trade receivables in scope, including amounts not yet due and amounts overdue.

Consistent scope

Use the same entity, customer population, tax treatment, currency conversion and cutoff date.

Calculation example

A company has EUR 1,000,000 in outstanding receivables, of which EUR 50,000 is past due.

Receivables at month-endAmount
Not yet dueEUR 950,000
OverdueEUR 50,000
Total receivablesEUR 1,000,000
Overdue ratio5%

The result means that 5% of the value of outstanding receivables is overdue and 95% is not yet due. It does not mean that 5% of invoices or 5% of customers are late: this indicator is based on amounts, not counts.

What is a good overdue ratio?

The objective is generally to keep the overdue ratio as low as possible. The original article contrasts a 5% ratio with a 30% ratio: in many portfolios, 30% overdue is a warning sign that requires investigation. But there is no universal threshold that can be applied without considering payment terms, sector, customer mix, billing practices and the reporting date.

A low ratio

Usually suggests a limited amount of past-due receivables. Still check for a few very old or disputed balances hidden within the total.

A high or rising ratio

Signals a need to examine customer payment behavior, disputes, invoice quality, collection processes and potential financial distress.

Watch the trend as well as the level. A ratio can increase sharply when large invoices become due, even if the collection team has not suddenly become less effective. Conversely, a surge in new sales can increase the not-yet-due denominator and temporarily improve the ratio without recovering a single overdue invoice.

Go further: overdue aging ratios

The global overdue ratio is a starting point. To assess risk, break overdue balances down by the number of days past due. For example, track receivables overdue by more than 30, 60 or 90 days as a percentage of total receivables. Each threshold is a cumulative view; the groups overlap unless you explicitly use non-overlapping aging buckets.

MeasureCalculationManagement question
Overall overdue ratioAll overdue / total ARHow much of our receivables is past due?
Over 30 days overdueAR more than 30 days past due / total ARWhich delays are persisting?
Over 60 days overdueAR more than 60 days past due / total ARWhere is the risk of non-payment increasing?
Over 90 days overdueAR more than 90 days past due / total ARWhich balances require urgent review or escalation?

For example, if EUR 20,000 of the EUR 1,000,000 portfolio is more than 60 days overdue, the over-60-days overdue ratio is 2%. This is a subset of the 5% overall overdue ratio, not an additional 2% to add to it.

Use the appropriate collection escalation process when a case requires external action, but do not assume that all older invoices are uncollectible. Some may be blocked by a solvable dispute or administrative error.

Overdue ratio vs. DSO vs. collection rate

These indicators answer different questions and should be used together. None is a complete measure of credit management performance on its own.

KPIWhat it measuresMain limitation
Overdue ratioShare of outstanding receivables past due at a point in time.Depends on portfolio composition and due-date distribution.
DSOReceivables expressed in days of sales.Also reflects negotiated payment terms and changes in sales.
Collection rateShare of the amount due for collection during a period that has actually been collected.Requires a clearly defined collection population and period.
Bad debt ratioImpact of doubtful or lost receivables, depending on the chosen definition.Often a lagging indicator and sensitive to accounting policy.

The digital DSO approach is particularly useful when these metrics can be explored by customer, business unit, collector and reason for delay, using reliable and sufficiently current data.

How to improve your overdue ratio

Late payment is not always the result of a customer deliberately refusing to pay. It may reflect weaknesses at several stages of the order-to-cash process: customer assessment, negotiation, delivery, invoicing, dispute management and collection.

1. Agree clear payment terms

Confirm due dates, invoicing requirements, purchase-order references and payment channels before supplying goods or services.

2. Eliminate avoidable disputes

Correct invoice errors quickly and identify recurring causes: pricing, delivery, acceptance or missing documentation.

3. Understand the customer's process

Know who validates invoices, who approves payments and what information the customer's accounting system requires.

4. Prioritize collection intelligently

Focus on amount, age, risk, dispute status and expected outcome rather than simply increasing the number of reminders.

5. Detect credit deterioration

Investigate deteriorating payment behavior and review credit limits or safeguards where justified.

6. Improve the underlying process

Use recurring overdue reasons to correct sales, billing and operational processes. See how cash collection can improve business processes.

Ask a simple question for every significant delay: What could have been done earlier to prevent this invoice from becoming overdue? The answer is often more valuable than another reminder.

Reporting rules and common mistakes

  • Keep the perimeter stable: compare the same entities, receivable types and accounting treatment over time.
  • Define the due date consistently: distinguish the contractual due date from an internal reminder or promise-to-pay date.
  • Exclude amounts already settled: apply cash receipts and credit notes correctly before calculating the KPI.
  • Reconcile disputed and unapplied items: do not hide disputes, but identify them separately so that the ratio can be explained.
  • Check denominator effects: major sales movements can change the ratio without changing overdue collections.
  • Segment the result: customer, entity, business line, geography and aging category reveal where action is needed.
  • Do not mistake the KPI for an employee score: a collector cannot always control invoice errors, customer insolvency or the amount falling due on a given day.

Automated reporting with My DSO Manager

My DSO Manager calculates overdue indicators across different scopes, including customers and portfolios, and supports aging-based reporting. The value of such reporting is not merely to display a percentage, but to connect it to the underlying invoices, reasons for delay and actions to take. The reliability of the result depends on the quality and freshness of the integrated data.

Frequently asked questions

Is the overdue ratio the same as the percentage of late invoices?

No. The usual overdue ratio is amount-based. A count-based ratio can be useful too, but it is a different measure and should be labelled accordingly.

Can the overdue ratio be zero?

Yes, if no outstanding invoice is past due at the reporting date. It is an objective to work toward, not a universal benchmark that every portfolio can maintain continuously.

Should we use the invoice date or the due date?

The due date. The invoice date alone does not determine whether an invoice is overdue.

Does a rising overdue ratio always mean worse collection performance?

No. It can also reflect changes in the receivables portfolio, invoice maturity, seasonality or sales. Investigate the underlying amounts and causes.

Further reading: credit management KPIs

Credit Management: principles and performance

Understand how receivables performance fits into the full credit management process.

How to calculate DSO

Compare accounting and roll-back methods and understand the cash flow impact.

Collection efficiency calculation

Assess how much of the receivables due for collection has actually been recovered.

Bad debt ratio calculation

Measure the financial consequences of doubtful and uncollectible receivables.

In summary: the overdue ratio is an excellent indicator of the quality of accounts receivable. It becomes genuinely useful when combined with aging, DSO, collection performance and a rigorous analysis of why customers pay late. The objective is not to produce more reports: it is to reduce preventable delays and collect cash.

Comments
Comment this page
Comments are subject of editor's review before publication
Do not enter sensitive data
Articles on the same topic