Free tool

Recurring revenue calculator for service businesses

Count the customers on a plan, the visits they get and the ones you lose. See what repeat work is worth each month, and what it will be in a year.

Adrian GluchowskiOwner of Superior Stain Solutions, builder of ChalkLast reviewed

Your plan customers
The visits

Repeat revenue each month

-
A year
-
Per customer, a year
-
Plan price per visit
-

In 12 months

-
Customers
-
A year
-
Customers lost this year
-

The plan discount

-
Extra visits for the same revenue
-
Average stay
-
What a customer is worth
-

The math

-

A route of repeat customers is the steadiest money a service business can have, and it is easy to measure wrongly. This calculator takes the customers on a plan, the visits they get and the price, and gives the monthly and yearly revenue they bring in. It then runs the next 12 months, with the customers you add and the ones you lose, so you can see whether the route is growing or just replacing itself.

How it works

  1. Plan price. Your regular price per visit, less the plan discount if you give one.
  2. One customer for a year. The visits a year times the plan price.
  3. Revenue now. Plan customers times one customer's year, divided by 12 for the month.
  4. Customers in 12 months. Each month you lose a steady share, then add the new customers. The calculator runs that 12 times.
  5. Revenue in 12 months. The customers you end with, the same way as step 3.
  6. The discount. What the plan discount costs you in a year, and how much more work pays it back.

The formula

  • Plan price = regular price x (1 - plan discount)
  • Monthly revenue = customers x visits a year x plan price / 12
  • Customers kept each month = (1 - yearly loss) ^ (1 / 12)
  • Customers next month = customers x kept each month + new customers
  • Extra visits to keep the same revenue = discount / (1 - discount)
  • Average stay in years = 1 / yearly loss
  • A customer's worth = one customer's year x average stay

Worked example

The calculator opens on a window cleaning route. There are 120 plan customers with 4 new ones joining each month. They get 4 visits a year at a regular $85, with a 10% plan discount. The business loses 18% of its plan customers each year.

  • Plan price: $85 - 10% = $76.50 a visit.
  • One customer, a year: 4 x $76.50 = $306.00.
  • Now: 120 x $306.00 / 12 = $3,060.00 a month, or $36,720.00 a year.
  • Each month keeps 0.82 ^ (1 / 12) = 98.36% of the customers, then 4 join. After 12 months there are 142 customers.
  • In 12 months: 142 x $306.00 / 12 = $3,621.00 a month, or $43,452.00 a year.
  • Lost this year: 18% of 120 is 22 customers.
  • The discount costs 120 x 4 x $8.50 = $4,080.00 a year. Just to keep the same revenue it needs 11.11% more visits. Keeping the same profit takes more, because each extra visit has its own cost.
  • Average stay: 1 / 0.18 = 5.6 years, so a customer is worth about $1,700.00 over the time they stay.

A lawn route. 60 plan customers, 2 new a month, 28 visits a year at $45 with a 5% discount, and 25% lost each year. That is $42.75 a visit, $1,197.00 a customer a year, and $5,985.00 a month now. In 12 months there are 66 customers and $6,583.50 a month. The discount costs $3,780.00 a year, and a customer stays 4 years and is worth $4,788.00.

Churn: the number that matters

Churn is the share of customers you lose in a year. It is the one number that decides whether a route grows. In the window example, the route adds 48 customers in a year. It loses 22 of its first 120, and a few of the new ones leave before the year is out too, so it ends at 142, about 18% larger. At 40% churn the same route loses 48 of its first 120, plus more of the new ones, and ends at 110, smaller than it started. Try it: set churn to 40 and watch the 12-month customers.

Ways to count it honestly:

  • Count the ones you drop as well as the ones who leave. A customer you fired for not paying is still a hole in the route.
  • Count a customer as lost when they skip a full cycle with no plan to come back, not at the first skip.
  • Look at it by reason. Moved away is not the same as unhappy. The second one you can fix.

The calculator turns the yearly number into a steady monthly loss so that 12 months of it add up to the yearly figure. Real losses come in lumps: after a price rise, at the end of the season, after a bad visit. Treat the 12-month number as a guide.

The average stay is 1 divided by the yearly loss, and it assumes the loss stays the same year after year. New customers often leave faster than old ones, so this is a rough number. Use it to compare plans and prices, not to promise anyone a number.

Is the plan discount worth it?

A discount takes a share off every visit, so you need more work, or less loss, to come out even. A 10% discount takes you from $85 to $76.50, and to earn the same revenue from a customer you now need 11.11% more visits (85 / 76.5 = 1.1111). That is revenue. Profit is tighter: if a visit costs you 60% of the regular price, a 10% discount cuts the profit on a visit from $34 to $25.50, and you need a third more visits to make the same profit. See what to say when the price is too high for the same math on a single job.

If the plan does not add visits, the discount is a pure cost. It earns its keep in three ways:

  • It turns a customer who calls when they remember into one who is booked ahead.
  • It lowers the number of customers who leave, which the churn line shows.
  • It fills the calendar in the slow weeks.

Put the discount at 0, note the revenue, then put it back and change the churn to the rate you believe the plan gives you. If the 12-month revenue is higher with the discount and a lower churn, it earns its cost. If you cannot say honestly what the churn would be, you are guessing, and so is the calculator.

How to design and sell the plan itself is in maintenance plans. Put the terms in writing with the lawn care or cleaning service agreement.

If you use Chalk, you can book a repeating run of visits on a job and bill each visit. See How to set up recurring visits.

FAQ

What is monthly recurring revenue for a service business?

The revenue you can expect each month from customers who are booked on a repeating plan. Here it is plan customers times visits a year times plan price, divided by 12.

How do I count a customer who pays by the visit and has no plan?

They are not part of this number unless they come back on a regular schedule. Put them in only if you can count on them.

How often should I run it?

When your prices, your plan or your customer count change, and once a quarter to see if the losses move.

Why does it show whole customers?

Because a customer is a person. The calculator keeps fractions while it runs the 12 months and rounds at the end.

Does this include one-off jobs or sales tax?

No. It is only the repeat work on a plan, before sales tax.

Sources

  • The average stay of 1 divided by the yearly loss is a standard rule of thumb. It assumes the loss rate does not change from year to year.
  • Spreading a yearly loss over 12 months with a power of 1/12 is compound math. The same result as losing the same share of what is left each month.
  • The starting numbers (customers, visits, prices, discounts and losses) are examples to replace with your own.