Revenue Forecast Template Checklist
A monthly revenue forecast template that combines your trailing baseline, planned campaigns, and seasonality curves — built for both one-shot and subscription online stores.
Revenue Forecast Template
A spreadsheet model that turns historical baseline, planned campaigns, and seasonality into a monthly revenue projection you can defend.
A revenue forecast template is a structured spreadsheet that projects monthly store revenue by combining three inputs: a trailing baseline (what you'd earn doing nothing new), campaign uplifts (the incremental revenue you expect from planned promos, launches, and paid pushes), and a seasonality curve (the month-over-month index your category swings on).
A usable template separates assumptions from calculations so you can tune one number — say, Black Friday discount depth — and immediately see the impact on Q4. It works for both one-shot DTC, where revenue equals orders × AOV, and subscription stores, where MRR carries forward and churn drags it down.
Most store owners build a forecast once a year, hard-code the numbers, and then ignore it by March. The fix is structural: a template where the assumptions live in one tab, the math lives in another, and the output is a clean monthly P&L line you can drop into a board deck or a Meta budget plan.
The version below covers the four moving parts you actually argue about — baseline trend, campaign lift, seasonality index, and (for subscription brands) cohort retention. Everything else is decoration.
The most common forecast mistake
Adding campaign uplift on top of a baseline that already includes last year's campaigns. If your trailing-12-month baseline contains a Black Friday spike, and you then add this year's Black Friday lift as incremental, you've double-counted. Either strip campaign weeks out of the baseline, or model lift as a percentage delta versus the same week last year.
The build checklist
Step 1 — Pull a clean 24-month baseline. Export monthly gross revenue, orders, and AOV from Shopify or your ERP for the last two years. Two years lets you compute year-over-year growth and a seasonality index in the same sheet. If you only have 12 months of data, flag the seasonality column as low-confidence and revisit it after Q4.
Step 2 — Compute a seasonality index. For each calendar month, divide that month's revenue by the trailing 12-month average. November on a beauty store often indexes 1.6-1.9; February on apparel sits around 0.7-0.8. Average the two years to smooth out one-off spikes, and store the 12 indices as a lookup table the forecast tab pulls from.
Step 3 — Layer planned campaigns as incremental lifts. For each campaign, log start date, duration, expected reach, and an uplift percentage versus a non-promo week. Be honest: a typical sitewide 20%-off weekend adds 30-60% to that week's run-rate, not 200%. New product launches are harder — anchor them to your last comparable launch and discount by 20% for novelty bias.
Step 4 — For subscription revenue, add a cohort block. Track starting active subscribers, monthly churn rate, and new acquisitions per month. Carry MRR forward as (prior MRR × (1 - churn)) + (new subs × ARPU). One-shot DTC stores can skip this tab entirely — the template should have it hidden behind a toggle, not deleted, so you can switch models if you launch a subscription SKU later.
Revenue forecast template FAQ
For a mature store with 24+ months of history, a well-built forecast lands within ±10% on non-promo months and ±20% on Q4. Newer brands or those mid-relaunch should expect ±25-30%. If you're consistently outside those bands, the issue is usually unmodeled campaign cannibalization or a broken seasonality assumption.
Forecast both, but drive the model from orders × AOV rather than revenue directly. AOV moves with discount depth and product mix, so projecting them separately lets you stress-test what happens if you push a lower-priced SKU or run a 30%-off weekend. Revenue-only forecasts hide where the variance is coming from.
Our other templates focus on diagnosis — funnel audits, test backlogs, hypothesis logs. The revenue forecast template is a planning artifact: it answers 'what will next quarter look like?' rather than 'where are we leaking?'. The two pair naturally — diagnostic templates tell you what to fix, the forecast tells you what fixing it is worth.
Yes. The template has two modes: one-shot (orders × AOV per month) and subscription (MRR carried forward with churn and new-sub layers). Subscription brands should also model a non-recurring revenue line for one-off upsells and gift purchases, which usually run 5-15% of MRR.
Don't forecast revenue directly from spend — model it as spend × ROAS by channel, then sum into the monthly line. Use a trailing 90-day ROAS as your baseline assumption, and apply a diminishing-returns haircut (typically 10-20%) when you're planning a budget increase above 30%.
Start with category benchmarks — apparel peaks in November-December at 1.5-1.8x average; beauty at 1.6-1.9x; home goods around 1.3-1.5x; electronics at 1.7-2.0x. Replace them with your own indices as soon as you've cleared your first full year, because brand-specific patterns diverge fast from category averages.
Refresh the baseline monthly when actuals close. Re-run the full forecast quarterly, or whenever a major assumption changes — a new product line, a 20%+ shift in ad budget, or a supply constraint. Forecasts that update monthly tend to drift toward optimism; quarterly resets force a cleaner reality check.
Yes, but you'll want to forecast each market separately and consolidate at the end. Currency drift adds 3-8% noise to a single-line forecast; modeling EUR, GBP, and USD on their own tabs lets you isolate FX impact from underlying demand. Convert at a locked planning rate, not spot.
Anchor to your closest comparable SKU launch — same category, similar price point, similar promo support — and discount the first 90 days by 20-30% for novelty bias and listing-page maturation. Build three scenarios (conservative, base, stretch) rather than a single line, and revisit weekly for the first two months.
Twelve months of monthly revenue and order data, a list of planned campaigns with rough dates and discount depth, and an honest channel-level ROAS table. Anything less and you're guessing, not forecasting — at that point a simple month-over-month growth rate with a Q4 multiplier will serve you better than a complex model.
Start tracking the metric that matters
Free for 30 days. No credit card. Connect your site in 4 minutes and see the one metric driving revenue.