Recurring vs One-Time Pricing

Excel Formulas › Cleaning & Janitorial

All versions

Recurring accounts get a per-visit discount for guaranteed volume; one-time deep cleans price higher. Comparing the two — and the annual value of recurring — guides what to chase.


Quick formula: recurring per-visit price:
=onetime_price * (1 - recurring_discount)
A recurring visit is the one-time rate less a volume discount. Annual value is that times visits per year.

The example

$200 one-time, 25% recurring off.

AB
1ItemValue
2200 × 0.75$150/visit
3× 52 visits→ $7,800/yr

The formula

The formula:

=onetime_price * (1 - recurring_discount) // one-time price less the recurring discount

How it works

How it works:

  1. One-time (deep clean, move-out) prices highest — no future volume.
  2. Recurring = one-time × (1 − discount) per visit — lower rate, steady income.
  3. Annual recurring value = per-visit × visits per year — the real prize.
  4. A recurring account’s predictability often justifies the discount — route density, no resell.

Recurring revenue is worth more than its per-visit rate suggests. A discounted recurring account brings route density, predictable scheduling, and no repeated sales effort — so its annual value (per-visit × 52) is the number to weigh against a higher one-time job. Chase one-time work to fill gaps and cash-flow; build the business on recurring contracts whose annual value compounds.

Try it: interactive demo

Live demo

One-time price, recurring discount, visits/year.

Per visit · Annual

Variations

Annual recurring value

Per-visit × visits:

=recurring_per_visit * visits_per_year

Discount given

Per visit:

=onetime_price * recurring_discount

Break-even visits

Vs a one-time:

=onetime_price / recurring_per_visit

Pitfalls & errors

Annual value. Judge recurring by the year, not the per-visit rate.

Discount for volume. The discount buys predictability and route density.

One-time premium. Deep cleans should price above recurring per-visit.

Practice workbook

📊
Download the free Recurring vs One-Time Pricing practice workbook
A pricing sheet with the annual-value, discount, and break-even variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I price recurring vs one-time cleaning in Excel?
Recurring is the one-time rate less a discount: =onetime_price * (1 - recurring_discount). $200 at 25% off is $150/visit.
What's the annual recurring value?
Per-visit times visits per year: =recurring_per_visit * visits_per_year. $150 × 52 is $7,800.
Why discount recurring work?
Guaranteed volume brings route density and no repeat selling — the steady annual value is worth the lower per-visit rate.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Cleaning bid by square footage · Recurring account churn · MRR & ARR