Essential Collection KPIs Every Australian Business Should Track
Would you drive a car without looking at the dashboard? Probably not. Yet many Australian small business owners manage their accounts receivable without tracking a single key performance indicator. They know they have outstanding invoices, but they have no idea whether their collection process is actually working.
Tracking the right KPIs transforms your collections from guesswork into a measurable, improvable process. This article covers the five essential metrics every Australian business should monitor, how to calculate them, and what benchmarks you should be aiming for.
Why Collection KPIs Matter
Your accounts receivable is essentially an investment. Every invoice you send is money you have loaned your customer. Without tracking how effectively you collect that money, you are flying blind.
Good collection KPIs help you:
- Spot problems early before they become cash flow crises
- Measure the impact of changes to your payment processes
- Set realistic targets for your team
- Compare performance across different time periods and customer segments
- Make data-driven decisions about credit policies and customer limits
The Five Essential Collection KPIs
1. Days Sales Outstanding (DSO)
DSO, also called Debtor Days, is the most widely used measure of collection efficiency. It tells you the average number of days it takes to collect payment after a sale.
How to Calculate DSO
DSO = (Accounts Receivable / Total Credit Sales) x Number of Days
For monthly DSO, use 30 or 31 days. For annual, use 365.
Example: If you have $50,000 in outstanding receivables and generated $150,000 in credit sales this month, your DSO is (50,000 / 150,000) x 30 = 10 days.
| DSO Range | Rating | Action Needed |
|---|---|---|
| Under 30 days | Excellent | Maintain current processes |
| 30-45 days | Good | Monitor trends |
| 45-60 days | Needs Improvement | Review collection process |
| Over 60 days | Critical | Urgent intervention required |
Benchmark: Most Australian small businesses should aim for a DSO under 30 days. However, this varies by industry. Consultants and professional services typically have longer cycles (45-60 days is common), while retail and hospitality should be under 15 days.
2. Collection Effectiveness Index (CEI)
While DSO tells you how long collection takes, the Collection Effectiveness Index measures what percentage of your receivables you actually collect. It is a more sophisticated metric because it accounts for the fact that some of your starting receivables may have been written off or are genuinely uncollectable.
How to Calculate CEI
CEI = ((Beginning AR + Credit Sales - Ending AR) / (Beginning AR + Credit Sales)) x 100
Example: Beginning AR was $40,000, you added $100,000 in credit sales, and ending AR is $35,000. Your CEI = ((40,000 + 100,000 - 35,000) / (40,000 + 100,000)) x 100 = 92.8%
| CEI Score | Rating |
|---|---|
| 95-100% | World-class |
| 80-95% | Healthy |
| 65-80% | Needs Work |
| Below 65% | Serious Issues |
3. Bad Debt Ratio
This metric shows what percentage of your credit sales ultimately become uncollectable. It is a direct measure of your credit risk and collection effectiveness.
How to Calculate Bad Debt Ratio
Bad Debt Ratio = (Bad Debts Written Off / Total Credit Sales) x 100
Example: You wrote off $3,000 in bad debts and had $200,000 in credit sales. Your bad debt ratio = (3,000 / 200,000) x 100 = 1.5%
Benchmark: A healthy bad debt ratio for most Australian small businesses is under 2%. If you are above 3%, your credit assessment process may need review. Industries like construction often see higher ratios due to the nature of the work.
4. Aging Concentration
This KPI breaks down your receivables by age brackets and tells you what percentage sits in each bucket. It is crucial for understanding the shape of your portfolio.
| Bucket | Healthy Target | Warning Sign |
|---|---|---|
| Current (not yet due) | 50-70% | Below 40% |
| 1-30 days overdue | 15-25% | Above 30% |
| 31-60 days overdue | 5-10% | Above 15% |
| 60+ days overdue | Under 10% | Above 15% |
If more than 15% of your receivables are in the 60+ day bucket, your collection process is failing. These invoices are at high risk of becoming bad debts.
5. Average Collection Cost
This measures how much it costs you to collect each dollar owed. It includes staff time, software costs, debt collection agency fees, and any other collection-related expenses.
How to Calculate Collection Cost
Collection Cost per Dollar = Total Collection Costs / Total Amount Collected
Example: You spent $5,000 on collection activities and collected $100,000. Your cost per dollar is $0.05, or 5 cents for every dollar collected.
Benchmark: Efficient collection processes should cost less than 5 cents per dollar collected. If you are spending more than 10 cents per dollar, automation or process improvements are likely needed.
How to Set Up KPI Tracking in Xero
Xero provides built-in reports that can help you track these KPIs. Here is how to leverage them:
The Aged Receivables Report
Located under Accounting → Reports → Aged Receivables, this report is your primary data source. Use it to calculate aging concentration and track DSO trends over time.
The Bad Debt Write-Off Report
Find this under Accounting → Reports → General to track your bad debtwrite-offs. Set up a monthly review to identify any concerning trends.
Create a Custom Dashboard
Consider creating a simple spreadsheet that pulls data from Xero monthly. Track:
- DSO (calculated monthly)
- Bad debt ratio (calculated monthly)
- Aging concentration percentages
- Total outstanding receivables
- Number of invoices overdue over 60 days
Using KPIs to Drive Improvement
Collecting data is only valuable if you act on it. Here is how to use your KPIs to improve collections:
Set Clear Targets
Establish targets for each KPI based on industry benchmarks and your business goals. Share these targets with your team and track progress weekly.
Identify Root Causes
If your DSO is rising, investigate why. Common causes include:
- Weakened payment terms
- Poor invoice design or unclear terms
- Inefficient follow-up processes
- Disputes going unresolved
- New customers with poor payment history
Measure Change Impact
Before and after any change to your collection process, measure the impact. Did implementing automated reminders improve your DSO? Did shortening payment terms reduce your 60+ day bucket?
Segment Your Analysis
Track KPIs by customer segment, industry, or invoice type. You might find that one customer segment is performing well while another is dragging down your overall numbers.
How PaidMate Automates KPI Improvement
Tracking KPIs is valuable, but the real power comes from improving them. PaidMate helps by automating your entire collection process, which directly impacts these metrics:
- Reduces DSO by sending reminders before invoices become overdue and escalating promptly when they do
- Improves CEI through consistent, professional follow-up that recovers more invoices
- Lowers bad debt ratio by catching problems early before they become uncollectable
- Reduces aging concentration by keeping invoices moving through the pipeline
Most businesses see measurable improvements within 30-60 days of implementing PaidMate. Your DSO typically drops by 5-15 days, and the 60+ day bucket shrinks significantly.
Start Tracking Your Collection KPIs Today
PaidMate not only helps you track these metrics but actively improves them through automation. Get paid faster while spending less time on follow-up.
Start Free TrialFinal Thoughts
You can not improve what you do not measure. By tracking these five essential collection KPIs, you gain visibility into your accounts receivable health and the tools to identify problems before they become crises.
Start small. Pick one or two KPIs to track this week. Build the habit of reviewing them regularly. And as you see the power of data-driven collection, expand your tracking to include all five metrics.
Your cash flow will thank you.