A receivables dashboard should tell you three things: how much cash is tied up, why, and whether the team is fixing it.
The core accounts receivable KPIs are DSO, best-possible DSO, average days delinquent, the collection effectiveness index, the percentage of receivables overdue and over 90 days, dispute volume and time to resolve, promise-to-pay kept rate, unapplied cash and bad debts written off. Calculate them from the aged debtors report and sales ledger each month and show the trend, not just the latest figure.
| KPI | Formula | What it tells you |
|---|---|---|
| DSO | Total receivables ÷ credit sales × days | Average days to collect |
| Best-possible DSO | Current receivables ÷ credit sales × days | DSO if everyone paid on terms |
| Average days delinquent | DSO − best-possible DSO | Days lost to late payment |
| Overdue % | Overdue receivables ÷ total receivables | Share of the ledger past due |
| Over 90 days % | Receivables over 90 days overdue ÷ total receivables | Share at real risk of loss |
Full method and a worked example are in best-possible DSO and CEI.
| KPI | Formula | What it tells you |
|---|---|---|
| Collection effectiveness index | (Opening AR + credit sales − closing AR) ÷ (opening AR + credit sales − closing current AR) × 100 | Share of collectable cash actually collected |
| Promise-to-pay kept rate | Promises paid in full by the promised date ÷ promises made | Whether chasing turns into cash |
| Contact coverage | Overdue accounts contacted this month ÷ overdue accounts | Whether the team is reaching everyone |
| Unapplied cash | Receipts not yet matched to invoices, value and age | Whether the ledger can be trusted |
| KPI | Formula | What it tells you |
|---|---|---|
| Disputed value | Value of invoices on hold for a dispute | Cash blocked by your own errors or service issues |
| Average days to resolve a dispute | Average of (date resolved − date raised) | Whether disputes are being closed |
| Credit notes as % of sales | Credit notes issued ÷ sales invoiced | Invoice accuracy and pricing problems |
| Bad debts written off | Write-offs in the period, value and as % of credit sales | Losses actually suffered |
| Credit limit breaches | Accounts over their approved limit | Whether limits are being enforced |
With an open invoice list where column E is the outstanding amount and column F is days overdue (see the aged debtors report):
Total receivables: =SUM(E:E)
Current receivables: =SUMIFS(E:E,F:F,"<=0")
Overdue %: =SUMIFS(E:E,F:F,">0")/SUM(E:E)
Over 90 days %: =SUMIFS(E:E,F:F,">90")/SUM(E:E)
For dispute time, keep a dispute log with the date raised in column B and the date resolved in column C:
add column D with =IF(C2="","",C2-B2) and average it with =AVERAGE(D2:D1000). AVERAGE ignores the blank text results, so only resolved disputes are counted. Track the count of open disputes separately, with their age. See the disputed invoice process.
Fifteen KPIs on one page means none of them get acted on. A good monthly set for most businesses is:
Every KPI should have an owner and a target based on your own terms and history. Link the targets to the routine in the credit control process.
UK reports often use "debtors", "debtor days" and "aged debtors"; US reports use "accounts receivable", "DSO" and "AR aging". The calculations are identical. If you report receivables including VAT or sales tax, make sure sales in the same ratio are on the same basis.
Applies the payments your customers make to the invoices they are paying, including part-payments and one payment for several invoices, and shows what is still owed. Runs in your browser on your own computer: nothing is uploaded.
Work out DSO and the cash tied up in late payers. Free to use online.
The Credit Control & Receivables System calculates ageing, DSO, best-possible DSO and CEI from the ledger, shapes a bad debt provision to IFRS 9 / ASC 326 logic and requires independent approval for credit limits and write-offs. Excel, no macros, one-time price.
There isn't one. DSO shows cash tied up; CEI shows collection performance; over 90 days shows risk. Read them together.
Monthly in the management pack, with overdue and dispute lists reviewed weekly by the credit control team.
Yes, for the largest customers. A total can look fine while one large account drifts.
Last updated 08 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.