I’ve chased too many gut-feel forecasts that fell flat. You know the drill: a SaaS startup hits a growth spurt, but churn sneaks up and cash burns faster than expected. That’s why I turn to Baremetrics as my data backbone for SaaS financial modeling. It pulls real subscription metrics straight from Stripe or Chargebee, so I skip the manual entry traps.
This approach lets me forecast revenue with confidence. I blend Baremetrics’ live numbers like MRR and churn with spreadsheet assumptions for hires and costs. In 2026, with tools like Forecast+ hitting 90% accuracy for bigger subscriber bases, it’s easier than ever. Let’s walk through my exact process, from metrics to scenarios.
Why Baremetrics Fits My Forecasting Workflow
Baremetrics changed how I handle FP&A. It grabs data from payment processors and updates dashboards in real time. No more weekly CSV exports or formula errors in Google Sheets.
I start every model there because it tracks 25-plus metrics automatically. Think MRR breakdowns, ARPU shifts, and cohort retention. These feed directly into my projections. For deeper dives on Baremetrics financial forecasting, check my guide that pairs these with cohort trends.
Forecast+ stands out now. It predicts revenue based on your history, especially if you have over 2,000 paid users. I export those baselines, then build scenarios in spreadsheets. This mix keeps things tactical. You get Baremetrics’ precision on subscriptions, plus control over non-recurring items like marketing spend.
Benchmarks help too. Compare your churn to industry averages right in the dashboard. If mine spikes above peers, I dig into cancellation reasons Baremetrics collects. That insight shapes my worst-case churn rates.
Key Metrics I Pull Straight from Baremetrics
I open Baremetrics first thing Monday. The dashboard shows MRR split by new, expansion, contraction, and churned. These aren’t guesses; they’re from live transactions.
Churn comes next. Logo churn tracks lost accounts. Revenue churn hits harder because one big customer cancel tanks it. Baremetrics flags these monthly. LTV follows, calculated from ARPU and retention. I export these via CSV for my model.
Expansion MRR excites me most. Upsells and added seats boost it. Baremetrics breaks this out, so I spot patterns like plan upgrades in enterprise tiers. For details on tracking churn and revenue churn with Baremetrics, see how I protect MRR.
ARPU rounds it out. It reveals pricing health. If it dips, downgrades might lurk. I pull these weekly. Baremetrics handles the math; I focus on trends.
Here’s what I export regularly:
| Metric | Baremetrics Source | My Use in Model |
|---|---|---|
| Current MRR | Dashboard overview | Starting revenue point |
| Monthly Churn % | Churn report | Retention multiplier |
| Expansion MRR | MRR gradient | Growth upside |
| LTV | Customer analytics | Acquisition payback |
This table keeps my inputs honest. After the table, I verify against benchmarks. If LTV lags, I check retention cohorts before forecasting.
Setting Up Your Financial Model Spreadsheet
I use Google Sheets for flexibility. Start with tabs: Revenue, Expenses, Cash Flow, Scenarios. Link Baremetrics exports to the Revenue tab.
Column A lists months: May 2026 through December 2027. Row 1 headers: Beginning MRR, New MRR, Churned MRR, Expansion, Ending MRR. Paste Baremetrics’ current MRR in B2.
Formulas drive it. Ending MRR = Beginning + New + Expansion – Churned. Churned = Beginning * Churn Rate. I set churn at 4% base from Baremetrics history, but tweak per scenario.
Expenses get their tab. Salaries from headcount plans. Baremetrics doesn’t cover this, so I assume ramps: 5 reps at $120k each by Q4. Marketing at 20% of new MRR.
Cash flow pulls from both. Add runway calc: Cash / Monthly Burn. I integrate Quickbooks via Baremetrics for actuals, then project forward. Baremetrics’ guide on building a financial model matches this setup closely.
Test formulas early. Input last quarter’s Baremetrics data. If it matches reality, scale out 18 months.
Feeding Baremetrics Data into Revenue Projections
Export CSV from Baremetrics weekly. Map columns to your sheet. New MRR assumes sales velocity; I base it on prior 3 months’ average, scaled 10% for base case.
Churn needs care. Baremetrics gives historicals, but future rates vary. Base: last 6 months average. I adjust for seasonality, like Q4 dips.
Expansion assumes 15% of base MRR. Baremetrics shows if it’s consistent. For pricing tweaks, pull ARPU and plan mix. See my post on SaaS pricing performance with Baremetrics.
LTV informs CAC caps. If Baremetrics LTV is $5k, I won’t pay over $1k per customer. For cohort views, export retention curves. Multiply surviving customers by ARPU monthly.
Refresh monthly. Baremetrics’ auto-updates mean exports stay fresh. Forecast+ gives a sanity check; I compare its projection to mine.
Running Best, Base, and Worst Case Scenarios
Scenarios prevent surprises. I duplicate the Revenue tab three times.
Base case: New MRR grows 15% monthly, churn 4%, expansion $6k/month. Steady path.
Best case: New MRR 25%, churn 2.5%, expansion $10k. Aggressively optimistic.
Worst case: New MRR 8%, churn 6%, expansion $3k. Recession hits.
Chart them stacked. Base hits $500k MRR in year 1. Best doubles it. Worst stalls at $300k. Baremetrics on worst-case scenarios echoes this.
Expenses flex too. Base hires 10 heads. Worst freezes at 7. Runway drops to 9 months in worst case, so I cut marketing first.
Share via links. Board sees color-coded sheets. Baremetrics benchmarks validate assumptions.
Handling Expenses and Cash Flow Realities
Revenue shines, but cash kills. I project opex from history. Salaries 50% of burn. Baremetrics integrates Xero for actuals.
Non-recurring: Onboard $50k/quarter. Assume 80% gross margins post-variable costs.
Cash flow: Inflows lag MRR by 30 days. Outflows hit payroll dates. Ending cash = prior + inflows – outflows.
Stress test: If worst revenue hits, runway shrinks. I build a $200k buffer. For LTV tweaks, use customer lifetime value with Baremetrics.
Alerts in Baremetrics ping Slack on churn spikes. That triggers model updates.
Conclusion
Baremetrics anchors my SaaS financial models with hard metrics like MRR and churn, while spreadsheets handle the what-ifs. Best case dreams big; worst case steels you for downturns. Run these monthly, and decisions sharpen.
You spot cash traps early. Growth feels predictable. Start with a Baremetrics export today, build that base sheet, and iterate. Your forecasts will hold up when it counts.
