Logo Credit Management tools
FR | EN
Tools, tutorials, methods and services
To know how to get paid by your clients

Overdue ratio calculation


The % of overdue is a key performance indicator for collection only. This ratio of overdue invoices / total receivable (or % overdue) allows to follow the part of your outstanding receivables that is late in payment. It shows the performance of your bills collection process and of your collection team.

It is an anticipated indicator of future bad debts: if the result of this ratio is bad, there are big chances that you will have unpaids / bad debts in next months.

It is calculated as follows:
Overdue invoices (invoices whose due date is exceeded) / Total amount of accounts receivable.
invoices collection and recovery
For example, if your late payments are 50 K € and your outstanding € 1000 K, the ratio is 5%, which means that 5% of the amount of bills that make up your total outstanding are late. 95% of the bills are not due yet.

If 5% is a good performance, 30% for example is not one (30% of late payments is particularly high) and indicates that you have some progress to do in your customer reminders, either qualitatively (application of the recovery process) or quantitatively (regular reminders).

The goal is to have a ratio that tends to "0%", indicating that your customers pay you exactly at the due date of your bills and that you don’t have to report any late payment.
This ratio is a good complement to the DSO to track your accounts receivable management performance.
Also use this ratio to determine your "old" debts ratio by taking only the delays of more than 60 days for example. The % obtained allows to highlight the invoices on which the risk of default is high. It is possible to apply this ratio on every tranche of your ageing balance.

  • My DSO Manager

    Overdue % in My DSO Manager

    This indicator is a KPI in My DSO Manager and it is calculated automatically by the software by customer, group of customers and globally.

    It is also included in several reports as the aging balance. It can be also calculated for overdue above 30 days, 60 days and 90 days. See the online demo.

How to improve your % overdue?

Ensure that sales conditions and payment terms negotiated with your client are balanced and commit your client to pay on time.
Disputes may also cause delays in payment if they are not resolved quickly. It is therefore necessary to analyze and understand the origin of late payments and to implement corrective actions.
By improving your performance in collection management » Collect your invoices
Understand the organization of your client for invoices validation and payment.

Ask yourself: what should have been done to avoid the delay of payment?

It remains to measure the potential impact of unpaid invoices and / or accruals for bad and old debts on the profit and loss statement to get a clear idea of your performance in Credit Management.
 

Next: bad debts ratio calculation
 


Tools download:




Comment this page


Your name:
Your comment:
Your email (not published) :
What is the result of 11 4 ?

Articles on the same topic

Credit insurance overdue declaration
How to declare an outstanding to the credit insurance

The balance sheet key ratios
Analyse the balance sheet with the more significant ratios

DSO calculation
DSO calculation tool (daily Sales Outstanding). DSO is the most used credit management key performance indicator

Bad debts ratio calculation
Bad debts ratio calculation tool is a key performance indicator in credit management


My DSO Manager
Subscribe
Not yet registered? The subscription allows downloading and unlimited use of all files of Credit Management tools.
User reviews

Very interesting, helpful website!

Social networks
Find Credit Management tools on your favorite social networks