Skip straight to the main guide
WrenchQuarry
More

Invoice paid rates: 2 calculations for your records

WrenchQuarry Editorial Team · Published · 11 min read

Calculate invoice paid rates by dividing paid invoices by total invoices, separately for invoices with payment terms and for all invoices.

Key takeaways

  • Use the same period for both rates.
  • Count invoices paid in full, not dollars.
  • Separate invoices that are not yet due.
  • Track collection time alongside paid rates.

If you run a service business, you probably know what you billed last month. You may also know roughly what reached your bank account. Fewer owners can say how many of their invoices were actually paid, how many are still open, and how many have quietly gone stale. That gap matters. An invoice that never gets paid is work you did for nothing, and every hour spent chasing it is an hour you did not spend on the next job.

You can compare both with two public benchmarks, and the pair shows you where to review your billing.

Nothing here replaces your own books. The goal is a clear number you can track over time, so you can tell whether a change in how you bill is helping.

Where the benchmarks come from

In a study it describes on its site, FreshBooks scanned payment terms for more than 1 million invoices from small businesses over the course of a year, along with whether the invoices were paid and how quickly payments were submitted.

Use its figures as a reference point for your own review, not as a promise about what your clients will do.

The first rate: invoices with payment terms

Payment terms are the written statement of when an invoice is due, such as a date or a number of days after the invoice goes out. The same study found that invoices that had payment terms were paid more than 88% of the time, regardless of which term was used.

You can separate that group in your own records and measure it directly.

To calculate your first rate:

  1. Choose a fixed period, such as the last full year. Use the same period for both rates.
  2. Pull every invoice issued in that period.
  3. Sort them into two groups: invoices that state payment terms, and invoices that do not.
  4. In the terms group, count the invoices paid in full and divide by the total number of invoices in that group.
  5. Express the result as a percentage.

Recent invoices need special handling. An invoice that is not yet due has not had a chance to be paid late.

The second rate: all invoices together

The second rate covers every invoice in the period, whether or not it states terms. The same study reports that all invoices taken together over a year were paid only 78.62% of the time.

That figure is lower than the first, and the gap is the useful part. A lower overall rate means the invoices without stated terms have a lower paid rate than the terms group. A narrow gap does not establish why invoices remain unpaid.

To calculate the second rate, count every invoice in the period that was paid in full, then divide by the total number of invoices. Use the same counting rule you used for the first rate.

Compare your numbers with the benchmarks

Put your two figures next to these benchmarks:

MeasureBenchmark from the study
Paid rate, invoices with payment termsMore than 88%
Paid rate, all invoices78.62%

Read your results in one of three ways.

  • Both figures are above the benchmarks. Keep the routine and watch for drift over the next few periods.
  • Your terms rate is above the benchmark, but your overall rate is below it. Review invoices without terms. Check whether they have clear due dates, whether they went out on the same schedule as the others, and whether the work and price were agreed in writing before you started.
  • Both figures are below the benchmarks. Review the whole cycle: how and when you send invoices, how you follow up, and how you confirm scope and price before work begins.

Keep the comparison in perspective. A benchmark from one study cannot tell you why your numbers differ from it. It can only show you where to look.

Illustrative example: calculate both rates

Suppose an illustrative group contains 50 invoices with payment terms, and 40 were paid in full. The terms rate is 40 divided by 50, or 80%.

Across all 80 invoices in the same illustrative period, 50 were paid in full. Divide 50 by 80 for the overall rate. It is lower than the terms rate, so review the invoices without terms next. Keep invoices not yet due separate in this example.

What to change when your rate is low

If your figures fall short, start with changes that are cheap and easy to undo.

Put a clear due date on every invoice. The study measured invoices that carried payment terms, so state yours plainly rather than leaving the due date implied. Use the same format every time so clients learn to read it. Review your invoice items before handing over a repair job alongside the due date.

Send invoices on a consistent schedule. An invoice that arrives late or in an unexpected form is easy to put aside. Sending on the same day each cycle also makes your follow-up easier to plan.

Remind clients before the due date, not only after it passes. A short, friendly note sent ahead of the due date gives the client a chance to act before the invoice becomes a problem. Keep the tone plain and helpful. If you automate this step, review your billing settings for automatic reminders.

Confirm scope and price in writing before work starts. Many unpaid invoices trace back to a disagreement about what was agreed. A short written summary at the start can prevent a dispute at the end.

Make paying easy. If a client has to call, mail a check, or guess at where to send money, the invoice can wait. Offer the payment methods you can actually process, and show them clearly on the invoice.

Test one change at a time. Change one thing on the next batch of invoices, record the result, and compare it with the batch before. If you change several things at once, you will not know which one helped.

Wording may matter too

In its data, the most effective keyword leading to full invoice payment was "Interest," which resulted in payment 92.15% of the time. Invoices that included a "thank you" were paid 89.61% of the time, and those with "please" were paid 88.07% of the time.

Read these figures carefully. They describe what appeared alongside full payment in one dataset. They do not prove that adding a word will make a client pay. Your clients may respond differently.

The word "Interest" also needs care. It only makes sense if your invoice actually explains what it refers to, such as a late-payment charge your contract allows. Whether any such charge fits your agreements and the rules where you work is a question for your contract or an advisor. A keyword should never be used to suggest a charge that was never agreed in writing.

The politeness findings are easier to act on. Plain, courteous wording costs nothing, and you can test it the same way you test any other change: keep a record, change one thing, and compare.

Track time to payment, not only whether it arrives

A paid rate tells you whether money comes in. It does not tell you when. The same study looked at how quickly payments were submitted, so timing is part of the picture.

For each paid invoice, record the number of days between the issue date and the payment date. Then look at the average, and if you can, the middle value. The middle value is less distorted by a few very late payments, which can make the average look worse than your typical client experience.

Timing matters for cash flow even when the paid rate looks fine. An invoice paid in full but months late can still strain your month, especially if you are paying staff or suppliers in the meantime.

The cost you may not be counting

The story notes that the two sometimes forget to count the unseen cost of getting paid manually. That cost includes hours spent chasing missed payments, awkward phone calls or emails to follow up, and time spent reconciling books.

None of those costs show up in a paid rate. An invoice that gets paid in the end still took effort to collect, and that effort is part of what the invoice really cost you.

Add a rough estimate of your own time to your review. Count the hours you spent on follow-up in a typical month. If your paid rate looks healthy but you spend a day each week chasing payments, the rate is hiding a real cost, and that cost is a reason to change your process.

Set up your records once

You do not need expensive software to calculate these rates. Give each row a few columns:

  • Invoice number and issue date.
  • Amount.
  • Whether the invoice states payment terms, yes or no.
  • Payment status: paid in full, partly paid, or unpaid.
  • Payment date, if paid.

With those columns in place, both rates are simple formulas. Filter the terms column, count the paid rows, and divide. Add a column for days to payment, and the timing figures follow.

If your accounting software can export invoices with a status field, start there. Export the same window each time so your periods line up.

A quarterly routine

Once a quarter, run the same short review. Consistency matters more than precision, because the trend across quarters tells you more than any single figure.

  1. Export or pull invoices for the same window each quarter, such as the most recent full year.
  2. Tag each invoice: states terms or not, paid in full or not, and days to payment for paid invoices.
  3. Calculate the terms rate and the all-invoice rate.
  4. Compare both figures with the two benchmarks and with last quarter.
  5. Choose one change to test on the next batch of invoices, such as clearer due dates on the invoices that lack them.
  6. Write the figures and the change in one place, so the next review starts from a record rather than from memory.

Keep the routine small enough that you will actually do it. A short sitting once a quarter is usually enough for a small service business, and a routine you skip is worth less than a simple one you keep.

Common mistakes

Several errors can make the comparison misleading, and most are easy to avoid.

Mixing time periods. The study measured payment over a year, so a one-year window is the closest match. A shorter window can swing sharply because of a few unpaid invoices, which makes a single good or bad quarter look like a trend.

Mixing invoices and dollars. The benchmarks are stated in terms of invoices, so count invoices, not dollars, for the rates. If you also want a dollar view, track it as a separate measure rather than blending the two.

Forgetting voided invoices. Decide how you handle invoices you cancelled or reissued. If an invoice was never a valid bill, exclude it from both calculations. If it was a real bill that you later wrote off, count it as not paid.

Always look at the terms group and the no-terms group separately.

Reading the trend over several quarters

One review gives you a snapshot. Several reviews give you a direction, and direction is what you need to judge whether your changes are working. Keep the two rates in the same table each quarter, with the date, the window, and any change you made since the last review.

Watch for three patterns. The first is a steady rise in the terms rate, which shows that more of that group's invoices are being paid. The second is a flat overall rate even while the terms rate improves. Check the size and paid rate of each group before drawing a conclusion. The third is a sudden drop in both rates.

Do not overreact to a single bad quarter. A few unpaid invoices can move a small business's rates a lot, and that movement may not reflect a change in how clients behave. When a drop appears, look at the individual invoices behind it before you change the process.

Compare your trend against the benchmarks as well, but do not chase them. The benchmarks are a reference point drawn from one study. Your own history is the better guide to whether your business is getting better.

Start with your records today

Export invoices for the last full year today.

Common questions

Do partial payments count as paid?

Count only invoices paid in full for these calculations. Keep partly paid invoices in a separate payment status.

Does adding payment terms guarantee payment?

No, the study's payment rates do not guarantee that a client will pay. Use the comparison to guide a review of your own invoices.

What should I track besides paid rates?

Track days to payment and time spent following up. These show timing and collection effort that the rates alone cannot capture.

Sources

More field guides