Why accounts receivable KPIs matter
Every open invoice is an interest-free loan to your customer. As long as the money is not in your account, it is missing for salaries, purchasing and investment. Accounts receivable KPIs show how much liquidity is tied up in receivables, how quickly customers pay and whether your dunning works.
For small and medium-sized businesses, a few figures calculated regularly and consistently are worth more than a report with twenty values that nobody reads. The following KPIs cover the key questions.
DSO: days sales outstanding
DSO is the best-known figure in receivables management. It answers the question: how many days does it take on average for revenue to turn into cash?
How to calculate DSO
The common formula is:
DSO = trade receivables ÷ revenue for the period × number of days in the period
A worked example: at the end of a quarter, a business has EUR 120,000 in open receivables. Revenue for the quarter was EUR 360,000 and the quarter has 90 days. This gives a DSO of 120,000 ÷ 360,000 × 90 = 30 days.
Keep in mind:
- Same basis: receivables are usually recorded including VAT. Calculate revenue on the same gross basis, otherwise DSO looks higher than it is.
- Same period: compare months with months and quarters with quarters. Seasonal swings distort the figure.
- Trade receivables only: loans or other receivables do not belong in DSO.
How to interpret DSO
A DSO of 30 days is a warning sign with a payment term of 14 days, but a good result with a payment term of 30 days. Always compare DSO with your agreed payment terms and with your own figure from the previous year. Industry benchmarks are only meaningful if payment terms and customer structure are similar.
It helps to split DSO into two parts: the best possible DSO, calculated only from receivables that are not yet due, and the remainder. The difference shows how many days are caused by late payment – the share that better dunning influences directly.
Other key accounts receivable KPIs
Receivables ageing
The ageing report groups open receivables by how overdue they are, for example not yet due, 1 to 30 days, 31 to 60 days, 61 to 90 days and older. It shows at a glance where old items accumulate. The older a receivable, the harder it usually becomes to collect.
Overdue rate
The overdue rate relates overdue receivables to total receivables. If it rises while revenue stays the same, customers are paying worse or dunning starts too late.
Collection rate
The collection rate measures which share of receivables due in a period was actually paid. It is a direct indicator of how effective your dunning is.
Dunning rate
The dunning rate shows how many invoices due had to be chased. A high dunning rate can point to weak payment discipline, but also to unclear invoices or payment terms.
Bad debt rate
The bad debt rate shows which share of revenue had to be written off. It is the last and most expensive consequence of weak receivables management.
Average days to pay per customer
DSO describes the business as a whole. For individual decisions – such as prepayment, credit limits or the tone of a reminder – you need the average days to pay per customer.
How to reduce DSO: practical measures
High DSO almost always has several causes. These levers work best in small and medium-sized businesses:
- Invoice immediately: every day between delivery and invoice adds exactly that day to DSO. Invoice right after delivery or acceptance.
- Clear payment terms: a specific date ("payable by 15 November") works better than "payable within 30 days". Check whether long payment terms are really necessary.
- Error-free invoices: missing purchase order numbers or the wrong contact person are a common reason why invoices sit unpaid.
- Reminder before the due date: a short message a few days before the due date prevents invoices from being overlooked.
- Chase early and consistently: the first reminder should come a few days after the due date, not weeks later. How to structure the levels is explained in dunning levels: stages, deadlines and fees.
- Match payments quickly: if incoming payments are only booked at month end, DSO looks too high and you may chase the wrong customers. See automatic payment matching for incoming payments.
- Easy ways to pay: bank details, payment reference and, where possible, a payment link belong clearly on invoices and reminders.
- Structured instalment agreements: a written payment plan brings more reliable payments than repeated reminders to a customer who cannot pay in one go.
How to improve DSO: measure regularly
Key figures only work if you look at them regularly. A monthly review of DSO, ageing and overdue rate plus a short list of the ten largest overdue items has proven effective. Tracking the values over twelve months reveals trends early, so you can act before a liquidity squeeze develops.
How acucollect supports your accounts receivable KPIs
acucollect, the receivables management software by RLOX (product page in German), continuously calculates the key figures from the invoices in Lexware Office, sevDesk or Odoo 19:
- Dashboard: open receivables, overdue amounts, payments received, collection rate, average payment term and dunning rate at a glance.
- KPIs per debtor: DSO, collection rate, average days to pay and a graphical receivables ageing in the digital debtor file.
- Reports: ageing analysis, payment behaviour and DSO, open items list and a comparison of debtor groups as PDF or Excel.
- Monthly results report: payments received after your reminders and the working time saved, sent by email.
- The levers automated as well: reminders before the due date, automatic dunning runs and payment plans put the measures above into practice. How this works in the process is described in dunning run: process, timing and when to pause.
