Payment Collection Report
How to track payment collection rates, identify slow-paying customers, and measure the effectiveness of your invoicing process.
What this guide covers
This guide shows you how to use the payment collection report to measure how effectively your business collects payments. You will learn to read the collection rate, identify trends, and spot customers who consistently pay late.
Before you begin
- You need Owner, Admin, or Dispatcher permissions.
- The collection rate is calculated as total payments received divided by total amount invoiced for the selected period.
Step 1: Open the report
- Navigate to
/reporting. - Click the Payments tab.
- Select Collection Report from the sub-menu.
Screenshot: The payment collection report showing the collection rate percentage, total invoiced, total collected, and a trend line chart.
Step 2: Read the collection rate
The headline metric shows your collection rate as a percentage. Below it, you see:
- Total Invoiced -- the sum of all invoices in the period.
- Total Collected -- the sum of all payments received.
- Outstanding -- the difference between invoiced and collected.
Step 3: Review the trend chart
The trend chart plots your monthly collection rate over time. An upward trend means you are collecting faster; a downward trend signals potential cash flow issues.
Animation: The collection rate trend chart loading with monthly data points, with a tooltip showing the exact rate for a specific month.
Step 4: Identify slow-paying customers
Scroll to the By Customer table to see collection rates broken down by individual customer. Sort by collection rate to find customers with the lowest rates.
Step 5: Take action
For customers with low collection rates:
- Review their invoice payment terms.
- Set up automated payment reminders.
- Consider requiring upfront deposits for future jobs.
Tip: A healthy collection rate for field service companies is 85% or higher within 30 days of invoicing. If yours is lower, review your payment terms and reminder schedule.
Best practices
- Track monthly. Monthly reviews give you time to adjust your collection strategy.
- Compare to previous periods. Use the date range filter to compare this month to last month.
- Pair with the aging report. The aging report shows where overdue invoices sit; the collection report shows the overall trend.
Related articles
Did this answer your question?