The 12 AR KPIs every finance team should track in 2026

The 12 AR KPIs worth tracking are DSO, best possible DSO, average days delinquent, CEI, the aging mix, percent current, the bad debt ratio, the dispute rate, average days to resolve a dispute, the cash application match rate, the promise-to-pay kept rate, and AR turnover. Together they answer how fast cash arrives, how completely you collect it, and how much of the book is at risk.

No single number tells the whole story. A finance team reads these as a set, and reads each as a trend over several periods rather than a one-off reading. Here is what each one measures, the formula, and what good looks like.

Why AR KPIs decide how much cash you actually have

Every open invoice is cash you have earned but cannot spend. AR KPIs tell you how much of that cash is stuck, for how long, and why. A company can be profitable on paper and still run short of cash because receivables are aging quietly in the background. The KPIs below are the instrument panel that makes that risk visible before it becomes a problem.

The reason to track a fixed set is consistency. When the same numbers come up every period, you stop arguing about whether last month was good and start seeing the trend. A KPI you measure once is a curiosity. A KPI you measure every period is a control. The 12 below cover the three things that matter for cash: speed of collection, completeness of collection, and risk in the remaining book. You do not need more than that, and fewer leaves blind spots.

The 12 core AR KPIs, defined

1. Days sales outstanding (DSO). The average number of days to collect after a credit sale.

DSO = (Accounts Receivable / Total Credit Sales) x Number of Days

If you carry 300,000 in receivables against 450,000 of monthly credit sales, DSO is (300,000 / 450,000) x 30 = 20 days. On net-30, that is strong. See our deeper write-up on days sales outstanding for the full method.

2. Best possible DSO. The DSO you would hit if every customer paid exactly on terms.

Best Possible DSO = (Current Receivables / Total Credit Sales) x Number of Days

It is the floor. The gap between actual DSO and this floor is pure lateness.

3. Average days delinquent (ADD). How many days late the average invoice is paid.

ADD = DSO - Best Possible DSO

If DSO is 38 and best possible DSO is 26, ADD is 12 days. That is the lateness DSO alone hides.

4. Collection effectiveness index (CEI). The share of available receivables you actually collected in a period.

CEI = ((Beginning AR + Credit Sales - Ending Total AR) / (Beginning AR + Credit Sales - Ending Current AR)) x 100

CEI strips out sales-volume swings, so it is the cleanest read on collections performance. Above 80 percent is strong, and the best teams hold the high 80s and 90s.

5. Aging mix. The share of the open book in each band: current, 1 to 30 days past due, 31 to 60, 61 to 90, and 90-plus. No formula, just the percentage in each bucket. A healthy ledger keeps most balances current and the 90-plus band thin.

6. Percent current. The portion of receivables not yet past due. Rising is good. A slide here is the earliest sign collections are slipping.

7. Bad debt ratio. The share of credit sales written off as uncollectible.

Bad Debt Ratio = (Bad Debt / Total Credit Sales) x 100

Well under 1 percent is the target for most businesses.

8. Dispute rate. The percentage of invoices (by count or value) that get disputed or short-paid. High dispute volume silently inflates DSO because disputed invoices stop moving until someone resolves them.

9. Average days to resolve a dispute. How long a dispute sits open from raised to closed. Every day here is a day the disputed cash is frozen.

10. Cash application match rate. The share of incoming payments matched to invoices automatically, without a human touching them. A low rate means staff are buried in reconciliation instead of collecting.

11. Promise-to-pay kept rate. Of the payment promises customers make, the share that actually arrive on time. It tells you whether your follow-up is converting commitments into cash or just into more promises.

12. AR turnover. How many times you collect your average receivables balance in a year.

AR Turnover = Total Credit Sales / Average Accounts Receivable

Higher means cash cycles back faster. It is the annual mirror of DSO.

Leading KPIs warn you, lagging KPIs grade you

Split the 12 into two groups. The aging mix, percent current, dispute rate, and promise-to-pay kept rate are leading indicators. They move first and tell you what is about to happen. DSO, CEI, AR turnover, and the bad debt ratio are lagging. They confirm the result after the cash has or has not arrived.

The mistake is managing only the lagging numbers. By the time DSO rises, the cause is weeks old, sitting in an aging bucket nobody worked. Watch the leading KPIs daily and the lagging ones take care of themselves. For more on the split, see our accounts receivable metrics and KPIs field guide.

How to set targets and benchmarks

Start with your own terms and your own history, not a generic industry average. A useful first target for DSO is best possible DSO plus a small buffer, since that is the most you can realistically close to. For CEI, aim above 80 and push higher each quarter. For the aging mix, set a ceiling on the share allowed in 60-plus.

Then compare to peers, carefully. Industry DSO averages drift with payment terms and seasonality, so a raw benchmark can flatter or scare you for the wrong reasons. Use them as a sanity check, never as the goal itself.

Worked example. Suppose you run net-30, carry 480,000 in receivables against 600,000 of monthly credit sales, and 360,000 of that AR is current. DSO is (480,000 / 600,000) x 30 = 24 days. Best possible DSO is (360,000 / 600,000) x 30 = 18 days. ADD is 24 minus 18, so 6 days. Your realistic DSO target is best possible DSO plus a small buffer, around 20 days, not zero. The 6-day ADD is the gap to chase, and it translates to roughly 120,000 of receivables sitting past terms at any moment. Knowing the number that way, in dollars on the floor, is what makes a target real.

Why month-end tracking is too slow

Most teams calculate these KPIs from a month-end export. That report describes last month, after the window to act has closed. Receivables age every single day, so a metric refreshed monthly is always describing a ledger that has already moved on.

The fix is to read the numbers as cash applies and invoices age, so a rising aging bucket is visible the day it forms. That is the gap an agentic AR system closes.

How Rex keeps every KPI live and acts on it

Rex is an autonomous AR agent. It keeps DSO, CEI, the aging mix, and the rest current in real time as payments land and invoices age, so the trend is visible while there is still time to act on it. More than that, Rex works the numbers. When an invoice crosses into a new aging bucket, Rex follows up. When a payment arrives, Rex applies it and updates the match rate without a human touching it. When a promise to pay is made, Rex tracks it and chases the ones that slip.

The result is that KPIs stop being a monthly report card and become the live state of work the agent is already doing across the whole ledger, escalating only the accounts that need a human decision.

Turning metrics into collected cash

A KPI is only worth tracking if it changes an action. The path from metric to cash is short when you let it be: a rising 60-plus bucket is a worklist, a low promise-to-pay kept rate is a follow-up failure, a falling match rate is staff time leaking into reconciliation instead of collection. Each number points to a specific account and a specific next step.

The teams that recover the most cash are not the ones with the prettiest dashboard. They are the ones who shrink the time between a metric moving and someone acting on it. Done by hand, that lag is days or weeks, because a person has to notice, decide, and reach out. Done continuously, it is near zero, because the work starts the moment the number moves. That is the entire case for tracking these 12 KPIs in real time rather than reading them at month-end.

See how Rex turns AR metrics into collected cash, end to end.