Accounts receivable KPIs: 7 performance metrics to track (with targets)

What are accounts receivable KPIs?

Accounts receivable KPIs are the performance metrics that measure how quickly and how completely a business collects the money its customers owe on credit sales. They turn a debtors list into a small set of numbers you can compare month to month: how long payment takes, how much of the collectable balance came in, and how much risk sits in old invoices.

Without them, a rising number of late payers goes unnoticed until cash is already short. With them, you can tighten credit terms, change the reminder schedule or call a customer before a small problem becomes a write-off. The seven KPIs below each come with a formula and a target. If the process itself is new to you, the guide to accounts receivable for small business covers the terms and the invoice-to-payment cycle first.

What is a good benchmark for accounts receivable KPIs?

A good accounts receivable benchmark comes from outside your own ledger, and the most useful one for a small business is how long its peers in the same market wait for payment. Xero Small Business Insights measures the average wait in five markets.

Read the Xero figure as the floor for DSO, not the target. It covers invoices that were paid, so a ledger carrying old debt sits well above it. The targets in each section below are rules of thumb; set your own from your industry, your payment terms and your own history, then beat last quarter.

What is days sales outstanding (DSO)?

Days sales outstanding (DSO) is the average number of days a business takes to collect payment after a credit sale. A DSO within about 1.5 times your payment terms is healthy, so on net 30 terms a DSO under roughly 45 days is good.

A lower DSO means cash arrives sooner and covers operating costs without borrowing. A rising DSO points to inconsistent collections, loose terms, or customers who have learned that late payment carries no consequence. The trend matters more than any single reading.

The formula divides accounts receivable by credit sales for the period, then multiplies by the number of days in it:

The DSO calculator does the arithmetic, and the DSO dictionary entry covers the formula and benchmarks in full.

What is the accounts receivable turnover ratio?

The accounts receivable turnover ratio is net credit sales divided by average accounts receivable for the period, and it shows how many times a business collected its average receivables balance. Higher is better, and a falling ratio means receivables are growing faster than sales.

A business with $1.2m of net credit sales and an average receivables balance of $150,000 turns its receivables eight times a year. Track it quarterly and read it against your terms: a business on net 30 terms that collects on time should turn receivables roughly twelve times a year.

The AR turnover calculator works it out from your own numbers.

What is an accounts receivable aging report?

An accounts receivable aging report groups every unpaid invoice by how long it has been outstanding, usually in buckets of 1 to 30, 31 to 60, 61 to 90 and over 90 days. The KPI is the share of the total balance in each bucket, and the over-90-day bucket is the one to minimise.

Aging is the metric that names customers: which accounts are consistently late, which invoices need a call rather than another email, and how much of the balance may never arrive. Xero and QuickBooks Online both produce the report; the AR aging analysis tool builds the buckets from a list of invoices.

What is the collection effectiveness index (CEI)?

The collection effectiveness index (CEI) is the percentage of collectable receivables that a business actually collected in a period. A CEI above 80% is good, and a figure near 100% means almost everything that could have been collected was collected.

CEI is the quality measure that DSO cannot give you. DSO can improve because sales rose, while CEI only improves when collections do. The formula is beginning receivables plus credit sales, minus ending receivables, divided by beginning receivables plus credit sales minus ending current receivables, multiplied by 100:

The collection effectiveness calculator walks through the formula, and the same formula sits in the controller KPI library with its benchmark and review cadence.

What is the percentage of outstanding invoices?

The percentage of outstanding invoices is the number of unpaid invoices divided by the total number of invoices issued in the period, expressed as a percentage. The lower the better, and a rising figure is an early warning before DSO moves.

Because it counts invoices rather than dollars, this KPI catches many small customers paying late while one large customer keeps the dollar figures looking healthy. Read it alongside the aging report.

What is the bad debt to sales ratio?

The bad debt to sales ratio is bad debt written off divided by total sales, multiplied by 100. Under about 1% is common for a small business, and anything creeping above that is a signal to tighten credit control.

Bad debt is the receivable that never arrives, so this ratio is the cost of the credit you extend. Review it quarterly alongside the over-90-day aging bucket, where next quarter's write-offs sit now. The bad debt expense calculator sizes it from your own ledger.

What is average days delinquent (ADD)?

Average days delinquent (ADD) is DSO minus best possible DSO, where best possible DSO is the DSO you would have if every customer paid exactly on the due date. The target is a figure trending toward zero.

ADD separates the delay you chose, by offering 30 or 60 day terms, from the delay your customers imposed by paying late. A business on net 30 terms with a DSO of 45 days has an ADD of roughly 15 days: the whole of that gap is collections performance, and it is the number a reminder schedule and late fees are built to close.

How do you monitor accounts receivable KPIs?

Accounts receivable KPIs can be monitored in accounting software reports, a spreadsheet, a dashboard tool or an accounts receivable automation app, and the right method depends on how often you need the numbers and who updates them.

Whichever method you choose, set a target for each metric, compare actuals against it monthly, and act on the gap. The controller KPI library has all seven of these metrics alongside 23 more, with a downloadable Excel list.

Which accounts receivable KPI should a small business track first?

A small business should track DSO first, because it is the single number that shows how long cash takes to arrive, then add the aging report to see which customers cause the delay. The other five add precision once those two are routine.

The KPIs improve when collections stop depending on someone remembering to follow up. Automating email and SMS reminders, late fees and customer statements pulls DSO, ADD and the over-90-day bucket down; Paidnice customers cut their average wait for payment in half within 30 days. Sign up for Paidnice and connect Xero or QuickBooks Online to read these metrics from your own ledger.

Written by

Denym Bird

Co-founder & CEO of Paidnice

Denym is a software entrepreneur and writes about accounts receivables management for small business.

LinkedIn X