Skip to content

What are AR KPIs? Definition, formulas, and example

Accounts receivable, billing and collections

Definition

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.

KPIFormulaWhat it tells you
Days sales outstanding (DSO)Ending AR ÷ credit sales × days in period (or average AR)Average days to collect
Best possible DSOCurrent (not past due) AR ÷ credit sales × daysDSO if everyone paid on time
Average days delinquent (ADD)DSO − best possible DSODays 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) × 100Share of collectible AR actually collected
AR turnoverCredit sales ÷ average AR (annualized)Times a year receivables convert to cash
Percent current / past dueCurrent or past due AR ÷ total ARHow much of the book is overdue
Bad debt ratioBad debt expense ÷ credit sales × 100Share 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 2026Amount
Beginning AR, August 31$1,100,000
Add: credit sales1,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
KPICalculationResult
DSO, ending AR$1,140,000 ÷ $1,200,000 × 3028.5 days
DSO, average AR$1,120,000 ÷ $1,200,000 × 3028.0 days
Best possible DSO$800,000 ÷ $1,200,000 × 3020.0 days
ADD28.5 − 20.08.5 days
Check: past due AR in days$340,000 ÷ $1,200,000 × 308.5 days
CEI$1,160,000 ÷ $1,500,000 × 10077.3%
AR turnover, annualized$14,400,000 ÷ $1,120,00012.86 times
Check: 360 ÷ turnover360 ÷ 12.8628.0 days
Percent past due$340,000 ÷ $1,140,00029.8%
Bad debt ratio$12,000 bad debt expense ÷ $1,200,0001.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.

TermWhat it isHow it differs from AR KPIs
Collections KPIsMetrics measuring collections performance, such as DSO, collection effectiveness index, past due percentage, promise-to-pay kept rate, and average days delinquentA 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 proxyOne AR KPI, measuring speed only
Average collection periodAverage days it takes to collect receivables, calculated as 365 divided by receivables turnover or average accounts receivable divided by credit sales times daysAnother name for DSO on an annual basis
KPIMeasurable value showing how well a company or team is achieving a key objective, tracked over time against a targetThe 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.

  1. Close the subledger: Apply cash, post credits, and clear unapplied items
  2. Book write-offs and the allowance: Update the CECL estimate
  3. Tie out: Agree the AR aging to the general ledger
  4. 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