What are AR KPIs? Definition, formulas, and example
Accounts receivable, billing and collections
AR KPIs are metrics tracking receivables performance, such as DSO, collection effectiveness index, average days delinquent, past due percentage, and bad debt ratio. Also called accounts receivable KPIs (not augmented reality metrics), they're calculated at each close from the AR aging, credit sales, and collections, and show how fast and how completely customers pay.
- Speed
- DSO and ADD
- Effectiveness
- CEI
- Risk
- Aging and bad debt
- Calculated
- After reconciliation
What are the most important AR KPIs?
The core AR KPIs measure speed (DSO, ADD), effectiveness (CEI, percent current), risk (bad debt ratio, aging), and efficiency (cost and productivity). Use the same day count and credit-sales base every month.
| KPI | Formula | What it tells you |
|---|---|---|
| Days sales outstanding (DSO) | Ending AR ÷ credit sales × days in period (or average AR) | Average days to collect |
| Best possible DSO | Current (not past due) AR ÷ credit sales × days | DSO if everyone paid on time |
| Average days delinquent (ADD) | DSO − best possible DSO | Days lost to late payment, across all receivables |
| Collection effectiveness index (CEI) | (Beginning AR + credit sales − ending total AR) ÷ (beginning AR + credit sales − ending current AR) × 100 | Share of collectible AR actually collected |
| AR turnover | Credit sales ÷ average AR (annualized) | Times a year receivables convert to cash |
| Percent current / past due | Current or past due AR ÷ total AR | How much of the book is overdue |
| Bad debt ratio | Bad debt expense ÷ credit sales × 100 | Share of sales that proves uncollectible |
| Days deduction outstanding (DDO) | Open deductions ÷ (deductions taken in the period ÷ days in the period) | How long deductions sit unresolved |
Efficiency and process KPIs round out the set: cost per invoice, collector productivity, promise-to-pay kept rate, dispute rate, and the share of cash applied automatically.
AR KPIs example
One month of data produces every core KPI, and the results tie to each other: ADD equals past due AR expressed in days of sales.
Example: Northgate Supply sells on net 30 terms and closes September 2026 on Wednesday, September 30, 2026. It uses the allowance method under CECL. All amounts are illustrative.
| AR roll-forward, September 2026 | Amount |
|---|---|
| Beginning AR, August 31 | $1,100,000 |
| Add: credit sales | 1,200,000 |
| Less: collections | (1,150,000) |
| Less: write-offs | (10,000) |
| Ending AR, September 30 | $1,140,000 |
| Aging: current $800,000 + past due $340,000 | $1,140,000 |
| GL accounts receivable | $1,140,000 |
| Difference | $0 |
| KPI | Calculation | Result |
|---|---|---|
| DSO, ending AR | $1,140,000 ÷ $1,200,000 × 30 | 28.5 days |
| DSO, average AR | $1,120,000 ÷ $1,200,000 × 30 | 28.0 days |
| Best possible DSO | $800,000 ÷ $1,200,000 × 30 | 20.0 days |
| ADD | 28.5 − 20.0 | 8.5 days |
| Check: past due AR in days | $340,000 ÷ $1,200,000 × 30 | 8.5 days |
| CEI | $1,160,000 ÷ $1,500,000 × 100 | 77.3% |
| AR turnover, annualized | $14,400,000 ÷ $1,120,000 | 12.86 times |
| Check: 360 ÷ turnover | 360 ÷ 12.86 | 28.0 days |
| Percent past due | $340,000 ÷ $1,140,000 | 29.8% |
| Bad debt ratio | $12,000 bad debt expense ÷ $1,200,000 | 1.00% |
DSO of 28.5 days looks fine against net 30, yet almost 30% of the book is past due. That's why you read DSO with ADD and CEI. The CEI numerator, $1,160,000, is collections plus write-offs.
In QuickBooks Online, the "Accounts Receivable Aging Detail" report gives the current and past due split; NetSuite's A/R Aging Summary report shows 1-30, 31-60, 61-90, and >90 columns; and SAP S/4HANA has a Days Sales Outstanding analytical app.
For scale, Cisco's fiscal 2026 annual report on Form 10-K shows "Accounts receivable, net of allowance" of $7,470 million at July 25, 2026, and $6,701 million at July 26, 2025, against total revenue of $63,325 million. That's a mechanical DSO of about 40.8 days on average net AR, using total revenue as a proxy for credit sales.
What is a good DSO and CEI?
A good DSO is close to your average payment terms and stable or falling; there's no universal target, because terms and customer mix vary by industry.
A CEI above 80% is often cited as strong, and 100% means you collected everything collectible. Judge both against your own trend and by customer segment.
What are AR KPIs confused with?
AR KPIs are most often confused with collections KPIs and with single ratios like DSO. AR KPIs are the full set.
| Term | What it is | How it differs from AR KPIs |
|---|---|---|
| Collections KPIs | Metrics measuring collections performance, such as DSO, collection effectiveness index, past due percentage, promise-to-pay kept rate, and average days delinquent | A subset; AR KPIs also cover billing accuracy, cash application, and disputes |
| Days sales outstanding (DSO) | Average days to collect receivables: average gross accounts receivable divided by credit sales, times days in the period. Ending AR is a simpler proxy | One AR KPI, measuring speed only |
| Average collection period | Average days it takes to collect receivables, calculated as 365 divided by receivables turnover or average accounts receivable divided by credit sales times days | Another name for DSO on an annual basis |
| KPI | Measurable value showing how well a company or team is achieving a key objective, tracked over time against a target | The general idea; AR KPIs apply it to receivables |
DSO answers how long, AR turnover answers how often, and CEI answers how completely you collected what was collectible.
How do you improve AR KPIs?
You improve AR KPIs mostly upstream: send accurate invoices on time and make paying easy.
- Invoice accuracy: Fewer errors mean fewer disputes and deductions
- Payment options: A customer payment portal and ACH speed receipts
- Dunning: Remind before and right after the due date
- Cash application: Apply payments daily so aging stays accurate
- Dispute resolution: Route and close disputes fast
AR KPIs at month end
Calculate AR KPIs after receivables are reconciled, so every ratio uses closed numbers.
- Close the subledger: Apply cash, post credits, and clear unapplied items
- Book write-offs and the allowance: Update the CECL estimate
- Tie out: Agree the AR aging to the general ledger
- Publish the dashboard: Show trends by month, segment, and collector
For FP&A, forecast collections from DSO or from the aging and historical collection rates, and show how receivables drive working capital. our Close Agent ties the AR subledger to the general ledger at close and prepares the entry, and nothing posts until a named approver signs off.
Common AR KPI mistakes
The most common AR KPI mistakes come from inconsistent formulas and reading one metric alone.
- Using a universal DSO target: Compare DSO with your terms, industry, and trend
- Swapping the CEI fraction: Ending total AR goes in the numerator; ending current AR in the denominator
- Calling ADD the lateness of overdue invoices: DSO minus best possible DSO spreads delinquency over all receivables
- Dividing by total sales: Use credit sales, and label ending-AR DSO as a proxy
- Treating higher AR turnover as always good: It can mean terms are too tight