Open receivables in dashboards: five KPIs for management
This article explains open receivables in dashboards: five KPIs for management in the context of German receivables management. It is written for companies, self-employed professionals, accounts receivable teams and creditors that need a clear, documented next step. Fortis Inkasso GmbH & Co. KG can support professional debt collection processes; the article does not replace case-specific legal advice.
Target operating model and KPIs
A target picture makes open receivables measurable. The central KPIs are DSO, the share of overdue items by age bracket, the average days in default, the success rate per dunning level and the write-off rate. Without these figures, any improvement remains an assertion.
Clean separation matters: cases held up by a complaint do not belong in the same statistic as genuine payment problems. Otherwise the steering signal becomes blurred. An open items list should show invoice number, due date, remaining balance, dunning level and last contact for every position. The effort is one-off; the benefit repeats with every case.
Process and responsibilities
Clear responsibilities prevent friction between sales, accounting and legal. Sales knows the customer relationship, accounts receivable knows the payment status, legal knows enforcement. The process has to define who decides when and who escalates.
An escalation matrix based on amount and age of the receivable reduces one-off decisions. Small amounts run automatically, large amounts are reviewed individually. Open receivables are reconciled with bank transactions monthly so that phantom balances never reach a reminder letter. Everything else is subordinate to this goal: five KPIs for management.
Data and systems
No automated dunning works without clean data. You need unambiguous customer numbers, maintained address and contact data, correct payment terms in the master record and automatic matching of bank transactions against open items.
An export in a clearly defined format is essential as soon as cases are handed to a service provider. An interface or a structured CSV file is far superior to a manual collection of documents. A well-maintained open items list is the basis for every DSO and ageing analysis. Small improvements here work through the entire receivables portfolio.
Controls and escalation rules
Controls ensure that defined rules are actually applied. A monthly reconciliation of open items, a sample check on dunning-level compliance and a report on cases that have sat without action longer than agreed all work well.
Every exception to the rule is justified and noted in the system. That keeps it traceable why a case was treated differently. A monthly look at the age structure reveals shifts earlier than any individual case review. The thread running through it stays the same: five KPIs for management.
30-/90-day implementation
The first 30 days are about transparency: structure open items by age, clean up master data, name the owners and document the current dunning deadlines. The goal is a reliable baseline, not a perfect system.
Fine-tuning against the KPIs follows. What demonstrably works is kept; what shows no effect is adjusted. Positions with no movement for several months belong on a separate review list. A fixed cycle is more effective than a review that only happens when someone asks for it.
