A good dashboard should not only say whether the result is good or bad.
It should help understand why.
In customer cash management, many companies follow a few classic indicators: DSO, overdue amount, aged balance, cash collected. These indicators are useful. They give a global view of performance and make it possible to see whether accounts receivable is improving or deteriorating.
But they are not always enough to make the organization progress.
Why?
Because they often measure the final result, not the mechanism that produces this result.
A high DSO may come from payment terms that are too long, disputes, rejected invoices, poorly mastered portals, unmatched payments, customers in difficulty, lack of chasing or late billing.
A high overdue amount may come from bad payers, but also from internal errors, incomplete orders or untreated credit notes.
A high amount of cash collected may give a positive impression, while disputes increase, rejected invoices multiply or customer promises are less and less respected.
To progress, the company must therefore manage more precisely.
It must not only measure the result.
It must measure the mechanisms that turn sales into cash.
Managing the Result and the Mechanism
A result indicator says what happened.
DSO is at 62 days.
Overdue invoices represent 18% of outstanding balance.
Cash collected this month is 4 million euros.
These figures are important, but they arrive at the end of the chain.
A mechanism indicator says how the result is produced.
How many invoices are rejected?
How many disputes are open?
How many days does it take to resolve a dispute?
What is the delay between delivery and billing?
How many payments remain unmatched?
How many payment promises are kept?
What are the main root causes of delays?
These indicators show where to act.
Mature management combines both.
It looks at the result to know whether the company is moving in the right direction. It looks at the mechanism to know what must be corrected.
Without mechanism indicators, the organization risks commenting on symptoms without treating causes.
DSO: A Trend Indicator
DSO remains a central indicator.
It measures the number of days of revenue tied up in accounts receivable. It makes it possible to follow the average speed at which sales turn into cash.
It is useful for observing trends, comparing periods, measuring the impact of customer credit on WCR and raising awareness among management.
But DSO must be used carefully.
It does not say why cash is blocked. It does not distinguish slow customers, disputes, rejected invoices, unmatched payments or seasonality effects. It can be influenced by revenue, customer mix, countries or activities.
It must therefore be followed, but never used alone.
DSO must trigger questions.
Which customers explain the variation?
Which activities contribute the most?
What share comes from overdue invoices?
What share comes from invoices not yet due?
What share comes from disputes?
DSO is useful when it opens the analysis.
It becomes dangerous when it replaces the analysis.
Overdue: Measuring the Real Delay
Overdue refers to overdue amounts, meaning invoices whose payment date has passed.
It is a more directly operational indicator than DSO.
It shows the cash that should already have been collected.
It can be followed in absolute amount, as a percentage of total outstanding balance, as a percentage of revenue or by aging bucket.
Overdue makes it possible to see whether delays are increasing or decreasing.
But it too must be interpreted.
A high overdue amount may be made of real customer delays, disputes, non-payable invoices, unmatched payments or expected credit notes.
It is therefore useful to distinguish gross overdue from actionable overdue.
Gross overdue shows everything that is late.
Actionable overdue excludes or isolates amounts that first require an internal action: rejected invoice, expected credit note, payment received but not matched, missing document.
This distinction makes management more effective.
It avoids asking only Collections to resolve topics that depend on Billing, Operations or cash application.
Dispute Rate
The dispute rate measures the share of invoices or amounts blocked by a disagreement or contestation.
It can be calculated by number of invoices, by amount, or as a share of total outstanding balance.
This indicator is essential because disputes consume cash.
They block payments, mobilize teams, damage the customer relationship and can reduce margin when credit notes or deductions are accepted.
But the company must go further than the global rate.
It must look at dispute causes: price, quantity, quality, delivery, service, contract, penalty, credit note, deduction, VAT, missing document.
A high dispute rate does not require one single response.
If disputes come from prices, commercial transmission and billing must be improved.
If they come from quality, Operations must be involved.
If they come from penalties, contracts and execution must be reviewed.
If they come from supporting documents, documentation must be strengthened.
The dispute rate indicates the size of the problem.
The cause of the dispute indicates where to act.
Dispute Resolution Time
The number of disputes is important, but their duration matters even more.
A dispute opened and resolved in three days does not have the same impact as a dispute that remains open for four months.
Dispute resolution time measures the time needed to move from an identified dispute to a decision or effective closure.
It can be measured in average days, median days, or by buckets: less than 15 days, 15-30 days, 31-60 days, more than 60 days.
This indicator shows the organization’s ability to resolve blockages.
If disputes are aging, the problem may not be the customer. It may come from absence of owner, lack of decision, weak involvement of Operations, a credit note process that is too slow or insufficient escalation.
Resolution time must be followed by type of dispute and by owner.
How long do quality disputes remain open?
How long does it take to approve a credit note?
How long do price disputes wait for a commercial answer?
This reading makes the dashboard much more useful.
It shows not only that cash is blocked, but also where the organization slows down its release.
Rejected Invoices
The rejected invoice rate is a very powerful indicator.
A rejected invoice is an invoice that the customer cannot integrate or validate in its process.
The causes can be numerous: missing PO, wrong purchase order number, wrong entity, VAT error, incorrect currency, missing supporting document, portal filled in incorrectly, receipt not validated, non-compliant format.
Each rejection delays cash.
It requires a correction, a new upload, a new validation, sometimes a new due date.
The rejected invoice rate therefore measures the quality of billing and upstream preparation.
It can be followed by number, amount, customer, portal, activity, cause and team.
A high rejection rate is not only a billing problem.
It can reveal incomplete orders, incorrect customer data, poorly known customer requirements or undocumented commercial exceptions.
Reducing rejections is often one of the fastest ways to improve cash.
An invoice accepted the first time has a much higher chance of being paid on time.
Compliant Billing Rate
The compliant billing rate measures the proportion of invoices issued correctly the first time.
It can be considered the operational opposite of rejected or corrected invoices.
A compliant invoice is an invoice that respects expected information: right customer, right entity, right price, right quantity, right VAT, right currency, right PO, right supporting document, right channel, right payment terms.
This indicator is very useful because it measures process quality before the delay.
The higher the compliant billing rate, the less the company creates future disputes and unpaid invoices.
Conversely, a low compliance rate announces cash problems.
It is important not to measure only internal accounting compliance.
The company must measure customer compliance: can the invoice be recognized, validated and integrated by the customer?
The right objective is not only to issue an invoice.
It is to issue a payable invoice.
Billing Delay
Billing delay measures the time between the billable event and invoice issuance.
The billable event may be a delivery, a service performed, a milestone validated, a service period completed or a receipt obtained.
This delay is crucial.
An invoice issued late mechanically delays cash.
If a service is performed on the 1st of the month but invoiced on the 20th, the company has already lost 19 days of cash before the customer payment term even starts.
Billing delay therefore makes it possible to see whether the company quickly turns execution into a receivable.
It must be followed by activity, invoice type and cause of delay.
Why do we invoice late?
Missing evidence?
Milestone not validated?
Incomplete order data?
System blockage?
Manual control?
Waiting for commercial information?
The shorter and more controlled this delay is, the earlier cash begins its path toward collection.
But speed and haste must not be confused.
The objective is to invoice fast and compliant.
Outstanding Balance by Customer
Outstanding balance by customer shows how much each customer owes the company at a given moment.
It generally includes invoices not yet due, overdue invoices, sometimes orders in progress, deliveries not yet invoiced or other commitments depending on internal rules.
This indicator is essential for Credit Management.
It makes it possible to monitor credit limit usage, exposure concentration, limit overruns, customers whose outstanding balance increases quickly and risky situations.
Outstanding balance by customer must be read with several complementary pieces of information.
What is the limit?
What share is overdue?
What share is disputed?
What share is not yet due?
Which payments are expected?
What margin does this customer generate?
What is its payment history?
A high outstanding balance is not necessarily bad.
It may be normal for a large reliable customer.
But it must be understood, justified and controlled.
Managing by outstanding balance prevents sales from accumulating without a global view of the capital committed to the customer.
Risk Concentration
Risk concentration measures the share of exposure carried by a few customers, groups, countries, sectors or activities.
It is an indicator that is often underestimated.
A company may have a correct DSO and a reasonable overdue rate, while being highly exposed to a few large customers.
If the top ten customers represent 60% of outstanding balance, a difficulty with one of them can have a major impact.
Concentration must be followed by customer, customer group, country, sector, currency or channel.
It makes it possible to answer simple questions.
What happens if our largest customer pays 30 days late?
What happens if a country blocks transfers?
What happens if a sector enters a crisis?
What happens if a large group imposes a longer payment term?
Risk concentration does not mean that large customers must be refused.
It means that their exposure must be managed carefully.
The stronger the concentration, the higher the quality of monitoring must be.
Promises Kept
Payment promises are a very rich indicator.
A customer that promises and pays on the announced date gives a positive signal.
A customer that promises and does not pay gives a negative signal.
The rate of promises kept measures the reliability of commitments obtained by Collections.
It can be calculated by number of promises or by amount.
This indicator helps assess customer behavior, but also the quality of Collections.
If many promises are not kept, several causes are possible.
Customers are unreliable.
The promises obtained are too vague.
The contacts reached are not decision-makers.
Collections accepts unrealistic dates.
Blockages are not really removed.
The quality of promises must therefore be analyzed.
A good promise is dated, quantified, linked to precise invoices and confirmed by a credible contact.
Following promises kept makes it possible to distinguish manageable customers from customers that must be framed more strongly.
Cash Collected
Cash collected measures the amounts actually received over a period.
It is an essential indicator, because the final objective remains to bring cash in.
It can be followed by day, week, month, customer, team, country or activity.
It makes it possible to compare collections with forecasts, objectives, expected due dates and treasury needs.
But cash collected must be interpreted.
A month can be excellent because large expected payments finally arrive, while new delays continue to accumulate.
A month can be weak because significant due dates fall the following month, without performance being poor.
Cash collected must therefore be connected to overdue amounts, promises, cash forecasts, resolved delays and new receivables opened.
Cash collected is the most concrete indicator, but it is not enough to explain process quality.
It measures the arrival of cash. It does not always say whether the mechanism is improving.
Cash Application Backlog
Cash application backlog measures payments received but not allocated to the right invoices or accounts.
It is a fundamental indicator for the quality of accounts receivable.
An unmatched payment can leave an invoice open, distort the aged balance, deteriorate DSO, trigger an unjustified reminder, wrongly block an order and give a poor image of customer risk.
The backlog can be followed by amount, number of payments, age and cause.
Payment without reference.
Grouped payment without remittance advice.
Wrong entity.
Unqualified deduction.
Credit note not applied.
Foreign exchange difference.
Offset.
The higher or older the backlog, the less reliable the reading of accounts receivable becomes.
It must therefore be managed as a cash topic, not as a simple accounting task.
Cash received must quickly become reliable information.
Average Matching Time
Average matching time measures the time between receipt of payment and correct allocation to invoices.
It complements the backlog.
A company can receive cash quickly but take several days or weeks to apply it. During this time, invoices remain open in the accounts, reminders may continue, and indicators are distorted.
A good matching time is short, but above all controlled.
Simple payments must be distinguished from complex payments.
A payment with an exact reference can be matched automatically. A grouped payment with deductions requires analysis. A payment without remittance advice sometimes requires an exchange with the customer.
Matching time must therefore be followed by payment type and cause of blockage.
The objective is not only to go fast.
The objective is to make the customer account reliable quickly.
Fast and accurate matching improves the quality of credit decisions and reminders.
Root Causes of Delay
One of the most useful indicators is also one of the least followed: root causes of delay.
Why are invoices late?
Customer in financial difficulty.
Slow-paying customer.
Rejected invoice.
Missing PO.
Receipt not validated.
Price dispute.
Quality dispute.
Expected credit note.
Payment not matched.
Customer portal.
Incorrect customer data.
Broken promise.
Missing document.
Undocumented commercial exception.
These causes must be coded in a simple and actionable way.
The objective is not to create an overly heavy classification.
The objective is to understand where blockages are created.
If the main cause is “missing PO,” the action plan concerns the order.
If the main cause is “quality disputes,” the plan concerns Operations.
If the main cause is “unmatched payments,” the plan concerns cash application and payment references.
If the main cause is “slow-paying customer,” the plan concerns payment terms, chasing and negotiation.
Managing root causes means managing the source of blocked cash.
Resolution Time by Cause
Knowing the causes is not enough. The company must also measure how long they take to be resolved.
Is a missing PO corrected in two days or in three weeks?
Is an expected credit note issued in five days or in forty?
Is a quality dispute decided in ten days or in three months?
Is an unmatched payment allocated the next day or after one month?
Resolution time by cause shows where the organization slows down.
It makes it possible to target efforts.
It can reveal that disputes are not numerous but very long.
Or that rejected invoices are quickly corrected, but credit notes block cash for a long time.
Or that unmatched payments become old because of missing remittance advices.
This indicator makes the dashboard more operational.
It shows not only what blocks cash, but also the speed at which the company releases it.
Order Quality Indicators
Cash is prepared before the invoice.
It is therefore useful to follow certain upstream indicators.
Rate of complete orders.
Orders without mandatory PO.
Orders with missing billing data.
Orders with unapproved payment terms.
Orders with undocumented commercial exceptions.
Orders blocked because of incomplete data.
These indicators are not always present in Credit Management dashboards. Yet they directly influence future delays.
An incomplete order often produces a non-payable invoice.
A poorly documented exception often produces a dispute.
A missing PO often produces a rejection.
By measuring order quality, the company manages prevention.
It no longer only corrects problems once they appear in the aged balance.
Payable Invoice Indicators
The concept of payable invoice must also become measurable.
How many invoices are accepted the first time by the customer?
How many are rejected?
How many are waiting for receipt?
How many are waiting for a supporting document?
How many are waiting for portal validation?
How many must be corrected or reissued?
These indicators measure the company’s ability to produce invoices that the customer can truly pay.
They are particularly useful for large accounts, customers with portals, service activities and projects.
A cash-oriented dashboard must integrate this dimension.
Otherwise, the company risks asking Collections to compensate for poor billing quality.
The more payable invoices are, the more Collections can focus on real payment behaviors.
Order Block Indicators
When the company uses order blocks, they must be measured.
Number of orders blocked.
Amount blocked.
Reason for block.
Duration of block.
Orders released under conditions.
Orders lost.
Payments obtained after block.
False blocks linked to unmatched payments or internal errors.
These indicators make it possible to understand whether blocking is used correctly.
A block can protect cash.
But an unjustified block can damage the relationship and slow sales.
The company must therefore know why orders are blocked, what allows them to be released, and which causes come back often.
If many blocks come from a limit exceeded because of unmatched payments, the problem is not the customer. It is cash application.
If many blocks come from overdue invoices linked to rejected invoices, the problem is billing quality.
Measuring blocks helps improve the full mechanism.
Risk Indicators
The dashboard must also follow risk.
Customers exceeding their limit.
Uninsured exposure.
Concentration by customer or group.
Customers with broken promises.
Customers with old overdue invoices.
Customers with reduced coverage.
Customers under watch.
Customers with payment plans.
Customers transferred to litigation.
Provisions and losses.
These indicators make it possible to anticipate problems.
Customer cash management must not only look at what is already late.
It must also look at what could become difficult.
A high non-overdue exposure with a fragile customer may be more concerning than a small old overdue invoice with a stable customer.
Risk indicators complete collection indicators.
They make it possible to protect future cash.
Productivity Indicators Are Not Enough
Some companies measure Collections by the number of calls, number of emails or number of reminders sent.
These indicators can have limited interest for following activity, but they must not become central.
A large number of reminders does not mean good Collections.
It can even signal that causes are not being resolved.
The best Collections is not the one that chases the most.
It is the one that brings cash in, reduces blockages, obtains reliable commitments, resolves disputes and improves root causes.
The company must therefore favor effectiveness and resolution indicators over activity volume indicators.
Action matters, but useful results matter more.
Comment Quality
A less obvious, but very useful, indicator concerns the quality of collection comments.
A file with a vague comment such as “customer chased” does not help much.
A precise comment such as “invoice accepted by portal, payment promised on 18/06 for 45,000 euros, AP contact confirmed, to be checked on 19/06” makes management possible.
Comment quality influences continuity, escalations, reliability of promises and understanding of causes.
Some companies can follow the rate of invoices with a next action entered, the rate of dated promises, the rate of disputes with an owner, or the rate of files without comment for more than X days.
These indicators improve management discipline.
An effective dashboard does not only measure figures. It also measures the organization’s ability to manage its files.
Segmenting Indicators
A global indicator is rarely enough.
The company must segment.
By country.
By activity.
By customer type.
By strategic customer.
By invoicing channel.
By invoice type.
By sales team.
By cause of delay.
By risk level.
By collection portfolio.
Segmentation avoids mixing different realities.
A global rejected invoice rate of 4% may seem acceptable. But if one country is at 15% and the others at 1%, the action plan must be targeted.
A stable global DSO can hide a strong deterioration in one segment.
A good global rate of promises kept can hide a few major customers that are highly unreliable.
Segmentation makes it possible to move from general comment to precise action plan.
A useful dashboard shows where to act.
Avoiding Too Many Indicators
A good dashboard should not contain everything that can be measured.
It should contain what helps decide.
Too many indicators create confusion.
Teams spend more time producing figures than acting.
Management no longer knows which signals to watch.
The company must therefore choose a balanced set.
A few result indicators: DSO, overdue, cash collected.
A few mechanism indicators: rejected invoices, billing delay, disputes, resolution time, promises kept, cash application backlog, matching time.
A few risk indicators: outstanding balance by customer, concentration, risky customers, limit overruns.
A few cause indicators: main root causes of delay and resolution time by cause.
The dashboard must remain readable.
Its objective is to direct action, not to prove that everything is measured.
Example of Intelligent Reading
A company observes that its DSO increases from 58 to 66 days.
A superficial reading concludes that Collections performance is weaker.
But the enriched dashboard shows something else.
Cash collected is stable.
Overdue increases mainly on two large customers.
The dispute rate increases from 6% to 11%.
Quality dispute resolution time exceeds 70 days.
Rejected invoices remain stable.
Unmatched payments are low.
The analysis shows that the DSO increase mainly comes from unresolved quality disputes on two major accounts.
The priority action is therefore not to send more reminders.
It is to mobilize Operations, qualify the disputes, obtain payment of the undisputed amount and set resolution dates.
The dashboard made it possible to move from symptom to cause.
Example: Stable DSO but Deteriorating Mechanism
A company maintains a DSO of 55 days for three months.
At first sight, everything seems stable.
But mechanism indicators are deteriorating.
The rejected invoice rate increases.
Unmatched payments double.
Promises kept decrease.
Recent disputes increase, but are not old yet.
DSO has not moved yet, but leading signals are poor.
If the company waits for DSO to deteriorate before acting, it will react too late.
Mechanism indicators are precisely used to anticipate.
They show problems before they become visible in the global result.
Example: Sustainable Improvement
A company wants to reduce its delays.
Instead of setting only a DSO objective, it follows several indicators.
Billing delay after delivery.
Rate of invoices accepted the first time.
Amount of open disputes.
Dispute resolution time.
Rate of promises kept.
Cash application backlog.
Root causes of delay.
After three months, it sees that DSO decreases moderately, but more importantly, rejected invoices decrease, disputes are resolved faster, unmatched payments decrease and promises are better respected.
The improvement is more solid.
It does not rely only on a one-off chasing effort.
It comes from a better Quote-to-Cash mechanism.
Building an Action-Oriented Dashboard
An effective dashboard must answer three questions.
Where are we?
Why are we there?
What must we do now?
The first question belongs to result indicators: DSO, overdue, cash collected, aged balance.
The second belongs to cause indicators: disputes, rejections, delays by cause, unmatched payments, billing delays, broken promises.
The third belongs to action indicators: owners, target dates, priority customers, resolution plans, escalations, blocks, payment plans.
A dashboard that does not lead to action becomes a report.
A dashboard that identifies causes and next decisions becomes a management tool.
The right indicator is not only the one that measures.
It is the one that helps decide.
Key Takeaways
The indicators that truly drive progress do not only measure the final result.
They also measure the mechanism that produces this result.
DSO, overdue and cash collected are useful, but insufficient if they are not completed by quality, cause, risk and resolution indicators.
An intelligent dashboard should notably follow dispute rate, dispute resolution time, rejected invoices, compliant billing rate, billing delay, outstanding balance by customer, risk concentration, promises kept, cash application backlog, root causes of delay and average matching time.
The central idea is simple: manage the mechanism, not only the result.
If the company looks only at DSO, it risks commenting on a figure.
If it looks at causes, resolution times, invoice quality, promises, disputes and matching, it can act on the levers that truly bring cash in.
A good dashboard should not only say “we are late.”
It should say why, where, with whom, through which cause, and what action will make progress possible.