Every unpaid invoice is money you’ve already earned that you can’t spend. But until that customer pays, it can’t pay the payroll, pay a supplier or fund the next job. The longer it waits, the more of it turns into bad debt. And getting it back is calling people who don’t want to be called. Debtors and collectors are frequently left in the dark, with communication often breaking down.
The hard part is to find the problem and recover money in time. That is what collections performance indicators are for. These metrics track the speed at which invoices convert to cash and where payments could be slowed.
Collection metrics will differ by industry or sector. Based on your aging report and credit sales, you can determine each collection KPI in minutes.
No new software is required either.
But here’s the thing, most collection KPI guides are written for companies with full AR departments and the software to match.
This one is going to help owners, especially those who manage their own collections or use a bookkeeper, without a full AR team. You will get 11 KPIs with real collection calculations. You’ll also find a 90-day scorecard for whoever’s chasing payments, a one-page dashboard and precisely what to do when a number turns red.
11 Collections KPIs Every Owner Should Track
If your cash feels uneven, you might be among half of all small employers from the Federal Reserve’s 2025 small business survey. Those 51% small employers name uneven cash flow as a financial challenge. The fix starts with tracking the right collection KPIs.
For many owners, receivables are a major concern. And the right collection KPIs show you what already happened. It also warns you early of any issues.
To help you better understand, every example below uses a small office supply distributor that sells to other businesses. Customers get a net 30 payment terms. It means they have 30 days to pay each invoice.
The numbers for the last three months (90 days) look like this:
- $270,000 worth of goods sold. Customers will pay later. These are credit sales.
- $120,000 is the amount owed.
- $90,000 of that amount isn’t due yet.
- $30,000 is late.
1. Days Sales Outstanding (DSO)
Days Sales Outstanding is the average number of days it takes a business to collect payments after a sale. That’s the money it’s owed.
The time period to measure a DSO can be monthly, quarterly, or annually.
Small business owners face long-term cash flow problems with a high DSO, even when debt is paid. The important aspect is to determine the number of days it takes on average for a company’s accounts receivable to be considered cash.
To calculate DSO: Divide AR by credit sales for the period, then multiply by the number of days in that period.
DSO =
× Number of Days
The distributor has $120,000 in receivables against $270,000 in quarterly credit sales: $120,000 ÷ $270,000 × 90 = 40 days.
DSO of 40 means customers take almost 10 days longer to pay. A healthy DSO should be close to your payment terms. The lower the DSO, the faster the collections and the more optimal the cash flow.
2. Accounts receivable turnover
Also known as ART, measures how many times a year a business collects accounts receivable. This collection metric helps with financial performance. And your bank is most likely to ask for it.
To calculate:
AR Turnover =
To find average accounts receivable, add your beginning and ending receivables for the year, then divide by 2.
The distributor’s $270,000 quarter works out to $1,080,000 a year. With average receivables of $120,000, AR turnover is $1,080,000 ÷ $120,000 = 9.
Divide 365 by 9, and you get about 40.6 days, nearly the same as DSO.
Higher turnover means faster collection. AR turnover and DSO tell the same results but in different ways. DSO counts the days, and turnover counts times per year. Keep DSO on your dashboard and work out your AR turnover.
3. Best possible DSO
Best possible DSO is the days sales outstanding a business would have if every customer paid exactly on the agreed date. These are the current receivables. Invoices that aren’t due yet.
Best Possible DSO =
× Number of Days
$90,000 is in current receivables for the distributor. $270,000 is the quarterly credit sales: $90,000 ÷ $270,000 × 90 = 30 days.
On net 30 terms, that’s where it should be. It reflects your payment terms, not follow-ups.
4. Average Days Delinquent (ADD)
ADD gives you insight into the average number of days a delinquent account is overdue. Businesses prioritize collections more effectively this way. Late payers get identified. Organizations can create targeted campaigns to expedite payments.
ADD= DSO – Best Possible DSO
According to calculations, DSO is 40 days for the distributor. The best possible DSO is 30. ADD is 40 – 30 = 10 days late, on average.
If this collection metric is used consistently, it can be an early warning sign to point out problems before they happen. Thus, DSO-related measures are performance indicators.
5. Collection Effectiveness Index (CEI)
DSO shows how long it takes to collect. But CEI shows your team’s success at collecting receivables within a given period. It measures the percentage of the money available to collect in a period that was actually collected.
A 100% means everything collectible came in. A lower score means inefficiencies. CEI provides current and past due receivables to offer more effective collection metrics.
CEI =
× 100
Here is the distributor’s last month:
| Input | Amount |
| Beginning receivables | $110,000 |
| Credit sales this month | $90,000 |
| Ending total receivables | $120,000 |
| Ending current receivables (not yet due) | $90,000 |
The calculation is: ($110,000 + $90,000 − 120,000)÷(110,000 + $90,000 − $90,000) = $80,000 ÷ $110,000 = 73%.
The distributor received 73% of what it could have received.
6. Dispute rate
Dispute rate shows the percentage of receivables held up because accounts are disputed by debtors. Potential issues are identified with better billing accuracy. Knowing how your customer’s accounts payable team approves invoices before paying helps you fix the problem.
There are two ways to measure dispute rate:
a) by number of invoices
Dispute Rate =
b) By dollars
Dispute Rate =
Say one of the distributor’s customers hasn’t paid a $6,000 invoice.After three reminders someone finally explains that the invoice is missing their PO number so it was never approved. The distributor issued 150 invoices in the last quarter.
- By the count: 1/150 * 100 = 0.7%
- In dollars: $6,000 ÷ $120,000 = 5% × 100
Numbers are different, but the same argument. Dispute in collections is more significant by dollar because it shows exactly how much cash is held up.
If you want to catch billing mistakes, the invoice dispute rate is more useful.
7. Share of receivables over 60 and 90 Days
Renewables over 60 and 90 days overdue shows how much money customers owe you that is overdue by more than 60 or 90 days.
Calculate invoices over 60 days using this formula:
Share Over 60 Days =
× 100
Calculate invoices over 90 days using this formula:
Share Over 90 Days =
× 100
The distributor sorted $120,000 by how much each amount is late. This list is called an aging report. Each row is an aging bucket:
| Aging bucket | Amount |
| Current (not yet due) | $90,000 |
| 1–30 days past due | $15,000 |
| 31–60 days past due | $7,000 |
| 61–90 days past due | $5,000 |
| Over 90 days past due | $3,000 |
Add the last two rows: $5,000 + $3,000 = $8,000 is over 60 days late. That’s $8,000 ÷ $120,000 = 6.7% of the total money owed by customers. That last line alone, $3,000, is over 90 days late. That’s 3,000/120,000 = 2.5 percent.
The older the bill, the harder it is to get paid. The Commercial Law League of America reports that there is a 94% chance of collecting a bill that is 30 days past due. After 90 days this probability increases to 74%.
8. Promise-to-pay kept rate
Also known as PTP, it measures the frequency of payment commitments that consumers keep by the date they pledge to pay. This rate is an indication of how successful the conversations are.
PTP Rate =
× 100
The distributor logged 20 promises this month, and 14 were paid on the promised date: 14 ÷ 20 = 70%.
Only when the money arrives, you will count a promise. Not when a call is made. A promise broken twice in a row needs to be moved to shorter terms. Or to prepayment.
The kept rate also falls, which is why automated reminders stall once a customer disputes the bill.
9. On-time payment rate
On-time payment rate shows the average of invoices customers pay on or before the due date. It shows the total number of customers who stick to payment terms without the need of being chased.
On-Time Payment Rate =
× 100
You need to count invoices that came due in the period. An invoice that isn’t due yet, cannot be late. So leave it from the calculation.
The distributor sent 150 invoices last quarter. By quarter end, 120 of them had come due, and customers paid 84 of those on time: 84 ÷ 120 = 70%. That means 3 out of every 10 bills were late.
Why track it? It gives an early warning if fewer customers pay on time this month. You will not see it in DSO yet.
But next month, late bulls will pile up. DSO and the over-60 share will go up too. The problem is that the on-time payment rate shows up first.
When rate drops, list the late invoices, group them by the customer and send friendly reminders to them three days before the due date.
10. Bad debt ratio
Not every receivable is collected. This is why the bad debt ratio shows the percentage of receivables written off as uncollectible.
An increasing bad debt ratio is a telltale sign of poor onboarding or ineffective collection practices.
A low bad debt ratio improves profitability. Strategies such as credit checks, customer risk assessments, and early interventions can reduce the bad debt exposure immensely.
Bad Debt Ratio =
× 100
Throughout the year, the distributor made $1,080,000 in credit sales and wrote off $10,800: $10,800 ÷ $1,080,000 = 1%.
Track recovery rate next to it: if $2,700 of that $10,800 comes back later, recovery rate is 25%.
11. Cost per collection rate
Also known as cost to collect reflects how much you spend to bring each dollar a customer owes you.
Cost to Collect =
× 100
Distributor spend $1,250 on collections last month:
- $600 for the owner’s time (10 hours of calls at $60 an hour)
- $600 for a bookkeeper (20 hours at $30 an hour)
- $50 to file one small-claims case
And collected $80,000 (the same as CEI). So $1,250 ÷ $80,000 = about 1.6 cents for every dollar collected.
This collection KPI tells you when a bill costs more to chase than it’s worth. 1.6 cents is fine. Spending three hours chasing a $300 invoice at $60/hour? That’s 60 cents for every dollar.you have paid $180 to get $300 back.
When cost becomes too high, find invoices that take most time to collect, check whether it’s the same customer, and change how you bill them. Put small, regular customers on automatic card payments upfront.
Collector Performance Metrics and a 90-Day Scorecard
Collection performance metrics show how your collections are doing. Whether it’s your bookkeeper or a new virtual debt collector, judge them on results.
Activity metrics show effort: how many customers they contacted, and their right-party contact rate, meaning how often they reached the person who can actually approve payment.
Outcome metrics show results: dollars collected, promises secured, and promises kept.
Here’s a sample scorecard for a new collector’s first 90 days can look like:
| Month | Focus | Sample target |
| 1 | Reaching the right people | Decision-maker reached on 60% of past-due accounts |
| 2 | Getting commitments | Promises on most 31–90 day accounts, 75% kept |
| 3 | Moving the numbers | CEI up 5 points; over-60 share below day one |
Set real targets from your own numbers. Give more weightage to dollars collected from 31-90 days. This is where most effort changes the outcome because who does the collecting can move these numbers quickly.
At American Collection Systems, an Ohio collection agency, internal reps were missing targets. Their workflow delays piled up across higher-education and commercial accounts.
Their COO, Jonathan Hindes, brought in three pre-vetted virtual collectors. The collection costs dropped 30%. Workflow delays reduced to 40%. The agency’s liquidation rate, recovered, rose from 14.5% to over 22$ within 30 days.
How to Build a Collection KPI Dashboard in a Spreadsheet
A collection KPI dashboard puts six numbers on a page: DSO, CEI, average days delinquent, over-60 share, promise-kept rate, and bad debt ratio.
But why not all 11 collection metrics? AR turnover repeats DSO. Best possible DSO feeds ADD. Disputes, on-time payment rate, and cost to collect are for digging in when a number turns red.
- Use one spreadsheet tab.
- Each month, paste your aging report and credit sales from accounting software.
- Give every number a target and a green, yellow, or a red status. Set the cutoff in the next section.
- Match every payment to its invoice.
Unapplied cash makes receivables look bigger and throws off every number. That’s the cash application step of the accounts receivable process.
Ask your collector for a weekly report. Then you don’t need to open the aging report every day.
Start With One Number This Week
The above discussed collection metrics tells you what to do. You don’t need all the metrics on day one. Just pull your aging report this week. Work out one number: the share of what customers owe you that’s more than 60 days late.
That single figure is enough to show you the cash slipping away.
Then build from there. Add CEI next month. Set up the dashboard after that. Within the quarter, you’ll know where payments stand and which customers need a call.
Tracking these collections metrics takes minutes. But acting on them takes hours: the calls, the reminders, the disputes need to be sorted. If you don’t have those hours, you don’t have to do it by yourself. It’s best to partner with a reliable remote financial staffing for receivables and collections, like Remote Scouts. They own the follow-up while you run your business.
Whatever you decide, start now. Every invoice in your aging report is money waiting to be collected.
