Pricepilot · Daily Ships · Backtest as of Sun 15 Nov 2026

At $49.00 fee + 2,000 included actions + $0.10 overage your MRR goes from $9,475 to $8,650 (-8.7%). 4 customers neutral, 19 falling, 7 rising (biggest: Bluepeak Logistics +87%). Revenue-neutral: $0.11149 overage (same fee and allowance) keeps MRR at $9,475.

Exports: Markdown · CSV · Run your own backtest

Totals

• Old MRR $9,475.00 (ARR $113,700.00) → new MRR $8,650.00 (ARR $103,800.00), -8.7%
• 4 neutral, 19 falling, 7 rising (band is a labelled heuristic)
• Revenue at risk: $1,713.00/month · Cost of first-year cap: $1,095.00/month ($13,140.00/year) · Capped MRR $7,555.00
• Falling accounts: $2,461.00/month new revenue, down $2,464.00/month
• Top customer before: Acme Dental (10.6%) · after: Acme Dental (19.3%)

Revenue-neutral solution

overageRate = (target − n×fee) / Σmax(0, actions − included) = (9475.00 − 1470.00) / 71800

Solved overage rate 0.11149 per action above 2000 included hits the target before per-customer rounding to 2 dp.

Solved price: $49.00 fee + 2,000 included actions + $0.11149 overage

Re-run at solved price: MRR $9,475.00 vs old $9,475.00 (0.0%).

Per-customer bills

Migration plan (suggested)

Suggested dates (heuristics) — adjust to your contracts and renewal dates.

• Wave 1 — neutral (suggested) — Mon 1 Feb 2027: 4 customers (Maple Mortgages, Willow HR, Northwind Clinics, Dune Travel). Bills barely change; safest first. Fix every invoice question here before wave 2.
• Wave 2 — falling (suggested) — Mon 1 Mar 2027: 19 customers (Sable Insurance, Harbour Legal, Kestrel Security, Lark Bakeries, Fern Accountants, Meadow Vets, Bramble Foods, Fjord Fisheries, Copperfield Estates, Iris Pharmacies, Jett Printers, Garnet Jewellers, Heather Nurseries, Atlas Roofing, Ember Fitness, Pinecrest Dental, Cobalt Recruiting, Hazel Opticians, Rowan Architects). These customers pay less. Confirm the revenue drop is the one in the backtest, not larger.
• Wave 3 — rising (suggested) — Thu 1 Apr 2027: 7 customers (Bluepeak Logistics, Acme Dental, Granite Finance, Marina Hotels, Juniper Health, Tern Shipping, Foxglove Media). Most reason to leave: give at least one full renewal cycle of notice and the first-year 20% increase cap shown in the table.

Next steps

1. Sun 15 Nov 2026 — Agree the price from this backtest. Check the rising accounts by name; adjust rate, fee or included actions until the riser list is one you can defend.
2. Sun 15 Nov 2026 — Create the Stripe prices in test mode. Use the exported Price JSON as a starting point; replace prod_REPLACE and mtr_REPLACE, then test in Stripe test mode.
3. Tue 1 Dec 2026 — Send shadow invoice 1 and announce. Show each customer their new-model invoice alongside the real (old-price) invoice. Send the notice draft.
4. Fri 1 Jan 2027 — Send shadow invoice 2. Second shadow month; answer questions, confirm the cap for rising accounts in writing.
5. Mon 1 Feb 2027 — Cut over wave 1 (neutral). Move neutral customers to the new Stripe prices.
6. Mon 1 Mar 2027 — Cut over wave 2 (falling). Move falling customers; watch revenue against this backtest.
7. Thu 1 Apr 2027 — Cut over wave 3 (rising, capped). Move rising customers with the first-year 20% cap applied.

Stripe set-up (starting point — test in Stripe test mode)

Input price

{
  "note": "Starting point — test in Stripe test mode. Replace prod_REPLACE with your Product ID and mtr_REPLACE with your meter ID. Fixed fee + overage: report only usage above the 2000 included actions to the overage meter (or model the allowance in your usage pipeline), so the metered price bills overage only.",
  "endpoint": "POST https://api.stripe.com/v1/prices",
  "prices": [
    {
      "nickname": "Fixed fee (monthly, includes allowance)",
      "product": "prod_REPLACE",
      "currency": "usd",
      "billing_scheme": "per_unit",
      "unit_amount": 4900,
      "recurring": {
        "interval": "month",
        "usage_type": "licensed"
      }
    },
    {
      "nickname": "Overage (per action above included, metered)",
      "product": "prod_REPLACE",
      "currency": "usd",
      "billing_scheme": "per_unit",
      "unit_amount_decimal": "10",
      "recurring": {
        "interval": "month",
        "usage_type": "metered",
        "meter": "mtr_REPLACE"
      }
    }
  ]
}

Solved revenue-neutral price

{
  "label": "solved revenue-neutral price",
  "note": "Starting point — test in Stripe test mode. Replace prod_REPLACE with your Product ID and mtr_REPLACE with your meter ID. Fixed fee + overage: report only usage above the 2000 included actions to the overage meter (or model the allowance in your usage pipeline), so the metered price bills overage only.",
  "endpoint": "POST https://api.stripe.com/v1/prices",
  "prices": [
    {
      "nickname": "Fixed fee (monthly, includes allowance)",
      "product": "prod_REPLACE",
      "currency": "usd",
      "billing_scheme": "per_unit",
      "unit_amount": 4900,
      "recurring": {
        "interval": "month",
        "usage_type": "licensed"
      }
    },
    {
      "nickname": "Overage (per action above included, metered)",
      "product": "prod_REPLACE",
      "currency": "usd",
      "billing_scheme": "per_unit",
      "unit_amount_decimal": "11.149025069638",
      "recurring": {
        "interval": "month",
        "usage_type": "metered",
        "meter": "mtr_REPLACE"
      }
    }
  ]
}

Customer notice draft

Subject: A change to how we charge — your projected bill is inside

Hi {customer} team,

I'm writing to tell you about a change to our pricing, and to show you exactly what it means for your bill before anything changes.

Today you pay per seat. From {cutover_date} we will charge based on actions instead: $49.00 fee + 2,000 included actions + $0.10 overage. We are making this change because teams are getting more done with fewer seats, and we think price should track the value you use, not headcount.

Your projected monthly bill on the new pricing (based on your recent usage): {new_bill} — you currently pay {old_bill}. {cap_line}

For the next two months you will see a "shadow" version of your invoice on the new pricing alongside your normal invoice, so there are no surprises. Nothing about your access changes, and you do not need to do anything.

If the projected number looks wrong, or you want to talk through your usage, reply to this email and I will look at your account personally.

Thank you for being a customer.

---
Fill in before sending (do not send this section):
- {cutover_date}: use the date for this customer's wave — neutral customers: Mon 1 Feb 2027; falling customers: Mon 1 Mar 2027; rising customers: Thu 1 Apr 2027 with the first-year cap.
- {cap_line}: rising customers only — replace it with "For the first year, your bill will not rise by more than 20% above what you pay today, whatever your usage does." For neutral and falling customers, delete {cap_line} (their bill is not rising, so do not promise them a cap).

Internal summary

Backtest: 30 customers move from $9,475.00/month to $8,650.00/month (-8.7%); 7 rising accounts put $1,713.00/month of increases at risk, a first-year 20% increase cap costs $1,095.00/month ($13,140.00/year), and the top customer is Acme Dental at 19.3% of new MRR.