---
title: "Accounts Receivable KPIs: Definition, Formulas and Example"
description: "AR KPIs explained: formulas for DSO, best possible DSO, ADD, CEI, AR turnover, and bad debt ratio, with one worked example where every number ties."
url: https://emptyspaces.ai/glossary/ar-kpis
language: en
---

[Home](https://emptyspaces.ai/) [Glossary](https://emptyspaces.ai/glossary) AR KPIs

# What are AR KPIs? Definition, formulas, and example

Updated November 19, 2026[Accounts receivable, billing and collections](https://emptyspaces.ai/glossary#browse)

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.

| 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.

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](https://emptyspaces.ai/product/close) 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

## Related terms

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.

Best possible DSO DSO calculated using only current, not past due, receivables, showing the lowest DSO achievable if every customer paid on time.

Average days delinquent (ADD) Average days late customers pay: days sales outstanding minus best possible DSO, showing how overdue the typical payment is.

Collection effectiveness index (CEI) Percentage measuring how much collectible receivables were actually collected in a period, with 100 percent meaning everything collectible was collected.

Accounts receivable turnover ratio How many times a year a company collects its receivables: net credit sales divided by average accounts receivable.

Accounts receivable aging report Report listing unpaid customer invoices by how long they have been outstanding, such as current, 1 to 30, 31 to 60 days past due.

Full guides: [Month-end close KPIs](https://emptyspaces.ai/resources/blog/month-end-close-kpis), [FP&A](https://emptyspaces.ai/resources/blog/fpa), and [General ledger vs subledger: AP and AR reconciliation](https://emptyspaces.ai/resources/blog/ap-ar-reconciliation).

More terms: [Finance and accounting glossary](https://emptyspaces.ai/glossary)

Bring reconciled receivables into your close

Bring one reconciliation to a working session. See how our agents prepare the evidence and your team reviews and approves.

[Book a working session](https://emptyspaces.ai/contact-us)

No implementation commitment.

[All 721 glossary terms](https://emptyspaces.ai/glossary)
