← All articles
SaaS10 min read

10 Common Revenue Modeling Mistakes (And the Sanity Checks That Catch Them)

The ten revenue-model mistakes I see in every founder spreadsheet — confused gross vs net, ignoring churn, fixed conversion rates, missing taxes — and the back-of-envelope checks that catch them in 30 seconds.

Sam Doshi avatar
Founder, RevenueLab · Published

I've reviewed hundreds of founder revenue models. The same ten mistakes show up in 80% of them, and each one inflates the headline number by 20–200%. Catching them isn't about being a finance person — it's about running a few back-of-envelope sanity checks before you believe your own spreadsheet. Here's the field guide.

1. Confusing gross revenue with net

A creator who quotes "$50k/month" usually means GMV: gross sponsorship invoices before the agent's 20% cut, before platform fees, before tax. Real take-home is often half that. Sanity check: write down every party that touches the money between the customer and your bank account. If you have more than two, your gross-to-net gap is bigger than you think.

2. Ignoring churn entirely

"We'll have 10,000 customers paying $50/month by year 2 = $500k MRR." Cool — at 5% monthly churn, you need to acquire 500 customers every single month just to stand still at the 10,000 mark. Most early-stage models assume zero churn and bake in a deeply unrealistic ramp. Sanity check: apply your stated churn rate to the end-of-period customer count. The number of new customers needed monthly should look terrifying.

3. Fixed conversion rates at every funnel stage

Real funnels degrade non-linearly. A 3% landing-page CR holds at 1,000 visitors; at 100,000 it usually drops to 1.5–2% because the marginal traffic is lower-intent. Models that hold conversion constant across 100× growth in spend produce numbers that never survive contact with reality. Sanity check: ramp conversion down by 20–30% at each 10× spend increase.

4. Missing taxes

US sole-proprietor creators owe roughly 15.3% self-employment tax plus federal and state income tax — a blended 28–40% effective rate. "I made $200k last year" frequently means "$120k in the bank after taxes I didn't budget for." See our creator tax guide for the full breakdown. Sanity check: multiply gross by 0.65 before you spend a dollar.

5. Forecasting against best-case CPMs

The number you saw on a screenshot from a top finance channel is not the number your gaming channel will earn. Average CPMs across niches vary by 10×. Sanity check: use the floor of your niche's range × 0.7 for year-one models. If the model still works, you have a real business. If only the ceiling × 1.0 makes it work, you have a hope.

6. Double-counting attribution

Affiliate, last-click, brand search, and organic social all legitimately claim credit for the same sale in different dashboards. Add them up naively and you'll forecast 130% of your actual revenue. Sanity check: reconcile channel reports to one source of truth (Stripe, Shopify, your books) monthly. The gap is always larger than you expect.

7. Treating one-time and recurring as the same

$50k of one-time setup fees this quarter is not equivalent to $50k of new MRR. The first stops next quarter; the second compounds. Operators routinely add them together in board decks because the total looks bigger. Sanity check: show recurring and non-recurring on separate lines, always.

8. Forecasting "good months" as the baseline

Q4 ad CPMs are 30–60% higher than Q1. Your November is not your average month. Models built off a peak month overstate annual revenue by 25–40%. Sanity check: use a trailing 12-month average, not your best month.

9. Underestimating refunds and chargebacks

Consumer products run 5–15% refund rates; info products and high-ticket coaching can hit 20%. If your model lists "revenue" as charged instead of net of refunds, you're overstating by exactly that percentage. Sanity check: subtract your refund rate from gross sales line, every period.

10. Trusting one calculator instead of triangulating

Every online calculator (including ours) has built-in assumptions. Run your numbers through 2–3 different tools and look for the agreement zone. Sanity check: see our how to use revenue calculators guide for the triangulation method, and use our multi-stream income, YouTube revenue, and CAC payback calculators as cross-references.

The honest planning advice

Build your model bottom-up, not top-down. List every line item that touches gross revenue on its way to net. Stress-test each assumption by 25% in either direction and see whether the business still works. And read the model out loud to one operator friend before showing it to investors — the mistakes above are obvious in speech and invisible on a spreadsheet.

Run the numbers
Revenue Growth Calculator

Use the free interactive calculator that pairs with this guide — no sign-up.

More related calculators

A note on accuracy. Numbers and benchmarks in this article are based on the sources documented in our methodology. They are directional estimates, not guarantees. See our editorial policy for how we research and update guides.