Accounts receivable KPIs tell you how fast a client turns invoices into cash, how much of their receivables are at risk, and whether their collections process is working. For a bookkeeper, they also turn a month-end aging report into advice a client can act on.
Most guides to KPIs for accounts receivable are written for in-house finance teams with a dedicated collector. Your situation is different. You're looking after AR for several businesses at once, each with its own terms, customers and habits, and you need a short set of metrics you can calculate quickly from QuickBooks or Xero and explain in plain language.
This guide covers the 10 essential KPIs for accounts receivable, the formula for each, a worked example using one sample client, and a simple scorecard you can reuse across your whole book of clients.
What are accounts receivable KPIs?
Accounts receivable KPIs are metrics that measure how efficiently a business collects money owed by its customers. They track collection speed, collection effectiveness, credit risk and process quality, and they are compared against a target or the prior period.
Any number from the aging report is a metric. It becomes a KPI when it's tied to a goal, such as "keep DSO within 10 days of payment terms" or "hold the 90+ day bucket under 10% of AR." If you're new to the underlying account, Plooto's guide to AR automation explains how receivables flow from invoice to cash.
The types of accounts receivable KPIs fall into four groups:
| Group | What it answers | KPIs in this guide |
|---|---|---|
| Speed | How long does cash take to arrive? | DSO, average days delinquent, AR turnover ratio, average collection period |
| Effectiveness | Is the client collecting what's due? | Collection effectiveness index |
| Risk | How much AR may never be collected? | % of AR over 90 days, bad debt to sales |
| Process quality | Is the AR workflow clean? | Invoice accuracy rate, unapplied cash rate, electronic payment adoption |
Why AR KPIs matter for bookkeepers
AR KPIs move your role from recording receivables to improving them. Three reasons they're worth the effort:
- You see cash problems before the client does. A rising DSO or a growing 61–90 day bucket shows up weeks before the bank balance feels tight.
- They make month-end conversations concrete. "Your customers paid 13 days late on average this quarter" lands better than "collections are a bit slow."
- They support advisory work. A consistent KPI scorecard across clients is an easy, billable add-on to monthly bookkeeping.
10 essential accounts receivable KPIs (with formulas and examples)
Every example below uses the same sample client, so you can see how the KPIs relate to each other. Northside Design Co. bills on Net 30. Here are its numbers for a 90-day quarter:
| Input | Amount |
|---|---|
| Beginning AR | $48,000 |
| Credit sales in the quarter | $150,000 |
| Ending AR (total) | $54,000 |
| Ending AR that is current (not yet due) | $32,000 |
| Ending AR 1–30 days past due | $12,000 |
| Ending AR 31–60 days past due | $6,000 |
| Ending AR 61–90 days past due | $1,500 |
| Ending AR over 90 days past due | $2,500 |
1. Days sales outstanding (DSO)
DSO is the average number of days it takes a client to collect payment after a sale. It's the headline speed metric and the one most clients have heard of.
Northside: $54,000 ÷ $150,000 × 90 = 32.4 days.
What good looks like: within 10–15 days of the client's standard terms. On Net 30, a DSO in the low 30s looks healthy. But read it alongside the next KPI, because DSO alone can hide late payers.
2. Average days delinquent (ADD)
ADD shows how many days, on average, customers pay past the due date. It separates the effect of payment terms from actual lateness.
Northside: best possible DSO = $32,000 ÷ $150,000 × 90 = 19.2 days. ADD = 32.4 − 19.2 = 13.2 days.
What it tells you: Northside's DSO looked fine, yet customers are paying about two weeks late. That's the conversation to have with the client, and it usually points to weak follow-up rather than bad customers.
3. Accounts receivable turnover ratio
The AR turnover ratio counts how many times a client collects its average receivables balance during a period. Higher means faster collection.
Northside: average AR = ($48,000 + $54,000) ÷ 2 = $51,000. Turnover = $150,000 ÷ $51,000 = 2.94 per quarter, or about 11.8 a year.
What good looks like: an annual ratio of roughly 7 or more is commonly treated as healthy, though it varies by industry. For a deeper walkthrough, see Plooto's guide to the accounts receivable turnover ratio.
4. Average collection period
Average collection period converts the turnover ratio into days, so you can compare it directly with payment terms.
Northside: 90 ÷ 2.94 = 30.6 days. It uses average AR rather than ending AR, so it smooths out a lumpy month-end. Use it as a cross-check on DSO.
5. Collection effectiveness index (CEI)
CEI measures the share of collectible receivables a client actually collected in the period. Unlike DSO, it isn't distorted by a jump in sales.
Northside: ($48,000 + $150,000 − $54,000) ÷ ($48,000 + $150,000 − $32,000) = $144,000 ÷ $166,000 = 86.7%.
What good looks like: 80% or higher is solid; 90%+ is strong. Note that some online calculators use different versions of this formula. Pick one and use it consistently across clients.
6. Percentage of AR over 90 days
This KPI shows how much of the receivables balance is seriously overdue, and therefore at the highest risk of never being collected.
Northside: $2,500 ÷ $54,000 = 4.6%. Total past due is $22,000, or 40.7% of AR, so the risk is building in the 1–60 day buckets rather than at the tail.
What good looks like: under 10% for most small businesses. Watch the trend in the 61–90 day bucket, since that's next quarter's 90+ problem.
7. Bad debt to sales ratio
Bad debt to sales shows the share of credit sales a client ends up writing off. It reflects how well credit is extended in the first place.
Northside (trailing 12 months): $5,400 ÷ $600,000 = 0.9%.
What good looks like: under 1–2% of credit sales. Measure it over 12 months, because write-offs are lumpy quarter to quarter.
8. Invoice accuracy rate
Invoice accuracy rate is the share of invoices sent without needing a credit note, correction or reissue. Inaccurate invoices are one of the most common reasons customers delay payment.
Northside: (120 − 6) ÷ 120 = 95%.
What good looks like: 95% or above. You can pull the numerator from credit notes and voided invoices in the ledger.
9. Unapplied cash rate
Unapplied cash rate measures how much of the money received couldn't be matched to an open invoice at period-end. It's the KPI that shows up most in a bookkeeper's own workload.
Northside: $3,200 ÷ $144,000 = 2.2%.
What it tells you: unapplied cash inflates the aging report, makes DSO look worse than it is, and sometimes triggers reminders to customers who've already paid. Anything above 1–2% is worth fixing at the source.
10. Electronic payment adoption rate
Electronic payment adoption is the share of collections that arrive by EFT, ACH, pre-authorized debit or card rather than by cheque or cash.
Northside: $86,400 ÷ $144,000 = 60%.
What it tells you: electronic payments usually arrive faster and are easier to match automatically, so this KPI tends to move DSO and unapplied cash in the right direction. It's also one of the easiest numbers for a client to improve.
Accounts receivable KPI quick-reference
| KPI | Formula | Northside result | Rule-of-thumb target |
|---|---|---|---|
| DSO | Ending AR ÷ credit sales × days | 32.4 days | Within 10–15 days of terms |
| Average days delinquent | DSO − best possible DSO | 13.2 days | Under 10 days |
| AR turnover | Net credit sales ÷ average AR | 2.94/quarter (≈11.8/yr) | 7+ per year |
| Average collection period | Days ÷ AR turnover | 30.6 days | Close to terms |
| CEI | (Beg. AR + sales − end AR) ÷ (Beg. AR + sales − end current AR) | 86.7% | 80%+ |
| % AR over 90 days | 90+ AR ÷ total AR | 4.6% | Under 10% |
| Bad debt to sales | Write-offs ÷ credit sales | 0.9% | Under 1–2% |
| Invoice accuracy | Clean invoices ÷ invoices sent | 95% | 95%+ |
| Unapplied cash rate | Unapplied receipts ÷ cash received | 2.2% | Under 1–2% |
| Electronic payment adoption | Electronic $ ÷ total $ collected | 60% | Rising each quarter |
Targets are general starting points, not industry standards. Set each client's targets from their own terms, history and sector.
How to track accounts receivable KPIs across your clients
The simplest way to track accounts receivable KPIs is a monthly routine built on reports you already run at close. You don't need a BI tool to start.
- Pick 4–5 KPIs per client. DSO, average days delinquent, % of AR over 90 days and unapplied cash rate work for almost everyone. Add CEI or bad debt for clients who extend a lot of credit.
- Pull the same three reports each month. From QuickBooks or Xero: the AR aging summary (as of month-end), sales by customer for the period, and the undeposited funds or unapplied payments balance.
- Set a baseline. Calculate each KPI for the last two quarters before setting any targets, so the first conversation is about trend, not judgment.
- Agree targets with the client. Base them on their payment terms and history, not a generic benchmark.
- Review monthly, report quarterly. Check the numbers at each close; share a one-page scorecard with the client every quarter.
Build a simple accounts receivable KPI dashboard
An accounts receivable KPI dashboard for a bookkeeping practice can be a single sheet with one row per client. That one view tells you which clients need a collections conversation this month.
| Client | Terms | DSO (days) | ADD (days) | % AR over 90 | Unapplied cash | Electronic payments | Flag |
|---|---|---|---|---|---|---|---|
| Northside Design Co. | Net 30 | 32.4 | 13.2 | 4.6% | 2.2% | 60% | Follow-up gap |
| Client B | Net 15 | 41.0 | 22.5 | 14.0% | 0.8% | 35% | Aging risk |
| Client C | Net 45 | 47.5 | 4.0 | 2.1% | 0.5% | 90% | Healthy |
Clients B and C are illustrative. Sort the sheet by ADD or % over 90 to see who needs attention first. Color-code anything outside the agreed target, and keep a notes column for the action you recommended.
A spreadsheet works until it doesn't. Once you're recalculating a dozen clients by hand every month, the data entry becomes the bottleneck. That's when AR software that syncs payment status straight to the ledger starts to pay for itself.
How to improve your clients' AR KPIs
Most weak AR KPIs trace back to four fixable causes: slow invoicing, inconsistent follow-up, hard-to-use payment options and manual matching. Here's what to change, and which KPI each change moves.
| Change | KPIs it improves |
|---|---|
| Invoice the day work is delivered, not at month-end | DSO, AR turnover |
| Automate reminders before and after the due date | ADD, CEI, % over 90 days |
| Offer card, EFT/ACH and pre-authorized debit | DSO, electronic payment adoption |
| Put repeat customers on recurring billing or PAD | ADD, CEI, bad debt |
| Sync payments to the ledger automatically | Unapplied cash rate, invoice accuracy |
| Review credit limits for chronic late payers | Bad debt to sales, % over 90 days |
Speed up invoicing. Track time-to-invoice for each client: the days between delivering work and sending the bill. Every day of delay adds a day to DSO before the customer has even seen the invoice.
Make follow-up automatic. Northside's 13-day ADD is a follow-up problem. Scheduled reminders at, say, three days before due, on the due date, and seven days after usually close most of that gap without anyone writing an awkward email.
Make paying easy. Customers pay faster when they can pay the way they prefer. Adding credit card acceptance or pre-authorized debit for retainer clients removes the "I'll mail a cheque" delay, and lifts electronic payment adoption at the same time.
Stop matching payments by hand. Two-way sync between the payment platform and QuickBooks, Xero or NetSuite marks invoices paid as cash arrives. Unapplied cash shrinks, and the aging report you calculate KPIs from is accurate.
Track and improve AR KPIs with Plooto
Plooto's accounts receivable automation software handles the four fixes above in one place. You can send invoices, set up recurring payments and PAD agreements, accept EFT, ACH and card payments, and see each invoice's status in real time. Payments reconcile automatically with QuickBooks, Xero and NetSuite, so the numbers behind each client's KPIs stay current without manual data entry.
For bookkeeping firms, Plooto manages AR and AP for multiple clients from a single login, with client-specific approval workflows and no payment liability for your firm. See how it works on the Plooto page for accountants and bookkeepers, or start a free trial and run your next client scorecard from live data.
