Days Sales Outstanding is a familiar measure in accounts receivable management. It offers a useful view of receivables relative to sales, but a single number cannot explain why invoices remain open, which accounts need attention, or whether collection work is resolving the underlying problems.
A more useful B2B receivables dashboard combines financial measures with operational indicators. Each should answer a management question and lead to an appropriate action. Start with measures your team can explain and maintain. Clear definitions matter as much as the choice of metrics.
Use DSO with its assumptions in view
A common period-end calculation is:
DSO = ending trade accounts receivable ÷ net credit sales during the period × days in the period.
For example, ending receivables of $1.2 million and net credit sales of $900,000 over a 30-day period produce DSO of 40 days. This is a simplified illustration using consistent receivable and sales scope.
Other approaches use average receivables, rolling periods, or sales countback methods. Label the method and apply it consistently. Changes in sales, seasonality, customer mix, and agreed terms can move DSO even when collection practices have not changed.
Interpret DSO alongside comparable historical periods and payment terms. A portfolio dominated by net-60 customers should not be evaluated against the same expectations as one dominated by net-30 customers without adjustment.
Add overdue percentage and aging distribution
Overdue percentage shows how much of the outstanding balance has passed its contractual due date:
Overdue percentage = overdue receivables ÷ total receivables × 100.
If $240,000 of a $1.2 million portfolio is overdue, the result is 20%. Define how credits, unapplied cash, and disputed items are treated so the measure can be reconciled to its supporting records.
Aging buckets then show where that overdue exposure sits. Separate current balances from amounts 1–30, 31–60, 61–90, and more than 90 days past due, or use buckets appropriate to your business. State explicitly that aging is based on due date.
Track movement as well as totals. A stable overdue percentage can conceal balances moving into older categories while new overdue invoices replace payments received.
Use Collection Effectiveness Index carefully
Collection Effectiveness Index, or CEI, compares the reduction achieved in the collectible receivable pool over a period with the amount potentially collectible under the formula. A common calculation is:
CEI = [(beginning total receivables + credit sales − ending total receivables) ÷ (beginning total receivables + credit sales − ending current receivables)] × 100.
Using beginning receivables of $1 million, credit sales of $900,000, ending total receivables of $1.2 million, and ending current receivables of $960,000 produces CEI of approximately 74.5%.
Use matching periods and consistent account scope. Write-offs, credits, adjustments, and data changes can affect the calculation, so it should not be interpreted as a pure measure of collector effort. Investigate unusual movements before setting performance expectations. A zero denominator produces an undefined result and needs explicit handling.
Make disputes visible as operational work
Disputed balances often need action from sales, customer service, pricing, or operations. Show the amount disputed, the age of unresolved cases, and the responsible owner.
Define dispute age from a consistent event, such as the date a valid dispute was recorded. Keep invoice age available separately. A dispute opened yesterday can concern an invoice already months overdue.
Pair resolution speed with quality. Closing a case in the tracking system does not establish that a credit was posted, the invoice was corrected, or the customer paid the remaining amount.
Track payment promises with a defined denominator
A count-based kept-promise rate can be calculated as promises fulfilled by the agreed date divided by promises due in the period, multiplied by 100. Decide in advance how partial payments, revised commitments, and receipt timing are treated.
Also consider an amount-based view. Ten small fulfilled promises can mask one large missed commitment. Reconcile receipts and unapplied cash before reporting a promise as broken.
These measures are useful for directing follow-up and assessing the reliability of commitments. They should not encourage collectors to record easy promises simply to improve a percentage.
Include loss trends and account context
Review credit write-offs and recoveries over time using a defined and disclosed basis. A write-off recorded this month may relate to sales from a much earlier period, so a simple comparison with this month’s sales can be misleading.
Separate operational collection measures from accounting estimates and loss recognition. Finance should own the applicable accounting treatment and reconcile the dashboard to approved financial records.
A hypothetical dashboard that leads to action
| Indicator | Illustrative observation | Management response |
|---|---|---|
| DSO | 40 days, up from 36 | Review sales timing, terms mix, and overdue movement |
| Overdue share | 20% of receivables | Identify accounts driving the increase |
| Older aging | More exposure moving beyond 60 days | Review account plans and escalation ownership |
| CEI | 74.5% using the stated formula | Check adjustments and compare consistent periods |
| Dispute backlog | Several cases lack an assigned owner | Assign responsibility and a resolution deadline |
| Payment promises | One large commitment missed | Verify receipts and contact the customer |
These observations are fictional, not benchmarks. Segment your dashboard by business unit, region, customer group, or collector where that helps explain performance. Account for differences in portfolio difficulty before comparing employees.
Give every measure a definition and owner
Maintain a short metric dictionary describing the formula, source system, refresh timing, exclusions, and person responsible for reconciliation. Show the last update time on reports. When a definition changes, explain the effect on historical comparisons rather than presenting a methodological change as improved performance. This discipline helps finance leaders and collection managers discuss the same figures with the same understanding. Regularly reconcile a sample of dashboard accounts back to invoice records, including payments and adjustments, to confirm that the presentation still reflects the underlying portfolio.
CMS Credit Suite documents collection reporting and measures including DSO, Collection Effectiveness Index, and Average Days to Pay. Discuss your definitions and reporting needs during configuration so users understand what each measure represents.
Contact Credit & Management Systems, Inc. to discuss a B2B receivables reporting approach that connects portfolio visibility with daily action.