What percentage of invoices are paid on time?
You set payment terms for a reason. But do your customers actually follow them? Here's how to measure what percentage of invoices are paid by their due date.
The short answer
What percentage are paid on time?Neither QuickBooks nor Xero gives you this number directly. You need to compare your total invoices paid within a period to the number that were paid by their due date. Below, we'll walk you through how to get this data and calculate the rate.
Why your on-time payment rate reveals the health of your collections
You sent 45 invoices last month. 28 were paid on time. That's a 62% on-time payment rate. That means over a third of your customers are not respecting your payment terms.
DSO tells you how fast customers pay on average. The on-time payment rate tells you how many customers are paying within terms. They measure different things. You could have a good DSO (because most clients pay slightly early) but a bad on-time rate (because a handful of clients are very late on large invoices).
When your on-time rate drops below 70%, it usually means one of three things: your payment terms are unrealistic for your industry, your invoicing process has friction (unclear terms, hard-to-pay methods), or you're not following up quickly enough when invoices go past due.
What your on-time payment rate actually measures
The formula is simple:
The tricky part is that most accounting software doesn't track this metric natively. You need to compare the payment date to the due date for each invoice, which usually means exporting data and working in a spreadsheet.
- Above 85%: strong. Your terms are clear, your invoicing is clean, and your clients respect the process.
- 70-85%: typical. Some late payments are normal. But watch the trend. If this number is falling, your collection process is weakening.
- Below 70%: a problem. More than 30% of invoices are late. This creates cash flow unpredictability and makes forecasting nearly impossible.
How to measure your on-time payment rate in QuickBooks Online (5 steps)
QuickBooks does not calculate on-time payment rates. You need to export your invoice data and compare payment dates to due dates in a spreadsheet.
- 1Go to Sales → Invoices
From the left sidebar, click Sales, then Invoices. Filter by status: “Paid.” Set the date range to the last 30 or 90 days.
- 2Export the list
Click Export to download the invoice list as a CSV or Excel file. Make sure the export includes the invoice date, due date, and payment date columns.
- 3Add a “Paid On Time” column
In your spreadsheet, create a new column. For each row, use a formula like: =IF(PaymentDate <= DueDate, “Yes”, “No”). This flags each invoice as on-time or late.
- 4Calculate the percentage
Count the “Yes” values and divide by the total number of paid invoices. Multiply by 100. That's your on-time payment rate.
- 5Identify repeat offenders
Sort by the “Paid On Time” column. Filter for “No” and look at which customers appear most frequently. These are the clients who need proactive follow-up or adjusted terms.
Total time: about 20-25 minutes. The export is quick, but the spreadsheet work and analysis take real effort, especially the first time.
How to measure your on-time payment rate in Xero (5 steps)
Xero also does not track on-time payment rates natively. The process is similar: export, compare dates, and calculate.
- 1Go to Business → Invoices
From the top menu, click Business, then Invoices. Filter by status: “Paid.” Set the date range to the last 30 or 90 days.
- 2Export the invoice list
Click Export to download the data as CSV. Ensure the file includes invoice date, due date, and date paid fields.
- 3Compare payment dates to due dates
In your spreadsheet, add a column that checks whether the payment date is on or before the due date. Flag each invoice as on-time or late.
- 4Calculate your rate
Divide on-time invoices by total paid invoices and multiply by 100. Also calculate the rate by dollar value (sum of on-time invoice amounts vs. total paid amounts) for a weighted view.
- 5Look for patterns
Sort by customer to see which contacts are consistently late. Also check if invoices sent on certain days of the week or month tend to be paid later. These patterns can help you optimize your invoicing schedule.
Total time: about 20-25 minutes. Same process as QuickBooks. The data export and spreadsheet analysis are the bulk of the work.
What it takes to track on-time payment rates consistently
This metric is one of the more manual ones to track because neither QuickBooks nor Xero calculates it for you:
- It requires a monthly spreadsheet export. You can build a template that makes it faster after the first time. But you still need to export fresh data and paste it in every month.
- The trend is what matters.A single month's number can be skewed by one large late invoice. Track it over 3-6 months to see if your collection discipline is improving or declining.
- Acting on it is the hard part.A 65% on-time rate means you need to either change your terms, improve your invoicing process, or follow up faster. The report tells you there's a problem. The fix is operational.
Or track your on-time payment rate automatically
Bottomline connects to your QuickBooks or Xero account and calculates your on-time payment rate every month. No exports, no spreadsheets, no formulas:
Bottomline doesn't just give you the number. It shows the trend (is it getting better or worse?), identifies the repeat late payers, and calculates how many extra days late invoices take on average. You get the full picture of your collection health without the spreadsheet work.