Revenue Forecast Template Checklist
An 8-point checklist for building a revenue forecast template that handles historical baselines, planned campaigns, seasonality, and subscription overlays — without breaking every time you add a SKU.
Revenue Forecast Template
A spreadsheet model that projects monthly revenue from a historical baseline, planned campaigns, and seasonality assumptions.
A revenue forecast template is the working document a finance or e-commerce lead uses to commit to a monthly number. It takes a historical baseline (usually trailing 12 months of orders by channel), layers planned marketing campaigns and promotions, and applies a seasonality curve to produce a forward view of net revenue.
The better templates separate assumptions from outputs so you can stress-test sensitivity — what happens if Black Friday underperforms by 20%, or if your subscription churn ticks up a point. They also accommodate both one-shot DTC purchases and recurring subscription revenue without needing two parallel models.
Most online stores forecast revenue badly. They either extrapolate last year flat (ignoring the campaigns they've planned) or build a campaign-by-campaign bottoms-up that double-counts baseline demand. A useful template separates the two: organic baseline, then incremental lift from each named campaign on top.
The version you want is boring on purpose. Inputs on one tab, monthly output on another, and a sensitivity sheet that lets you flex three or four assumptions without rewriting formulas. If your model only works when one person opens it, it's not a template — it's a liability.
The most common modelling mistake
Forecasting total revenue as one line. You can't diagnose a miss if baseline organic, paid-driven sales, and email/SMS campaigns are collapsed into a single number. Split them — even a rough 60/25/15 attribution split makes the model 10x more useful when you're explaining a variance.
What your revenue forecast template needs
1. Trailing 12-month baseline by channel. Pull monthly net revenue split into organic/direct, paid, and owned channels (email, SMS). This is your floor — what the store does if marketing went dark. 2. A seasonality index. Convert each historical month into a percentage of the annual total. November and December usually carry 12-18% each for apparel and gifting; flatter for consumables.
3. A campaign calendar with expected incremental lift. Each named promo (BFCM, Mother's Day, product launch) gets its own row with a lift assumption — not a total revenue number. Lift is what's added on top of baseline. 4. Average order value and conversion-rate inputs per channel. If you raise AOV through bundles, the model should reflect it. Hardcoded revenue numbers are the enemy.
5. A subscription block, if relevant. Active subscribers × monthly ARPU × (1 - churn) gives you recurring revenue separate from one-shot orders. Treating subs as just "more orders" hides the churn signal. 6. Returns and refunds rate. Apparel runs 20-30%, beauty 5-10%, electronics 8-15%. Forecast gross then subtract — don't forecast net directly.
7. A sensitivity tab. Three sliders is enough: paid-spend efficiency, BFCM performance, and subscription churn. Show low/base/high revenue for each combination so leadership sees a range, not a point. 8. Version control. Lock the assumptions tab once a quarter and start a new file. Re-forecasting in the same sheet erases the audit trail of what you actually committed to in January.
Revenue forecast template FAQ
Twelve months rolling is standard for online retail. Anything beyond that is directional — too dependent on product roadmap, paid-channel pricing, and macro demand to be useful as a commit. Refresh the 12-month view monthly, and lock a 90-day commit each quarter.
Both, reconciled. Build top-down from last year's revenue × growth target × seasonality, then build bottoms-up from channel volumes × conversion × AOV. If the two are more than 10% apart, one of your assumptions is wrong — find which before publishing the number.
Anchor it to your closest comparable SKU's first-90-day curve, then haircut by 20-30% for launch risk. If you have no comparable, use category benchmarks for week-1 sell-through and model three scenarios: pessimistic, base, optimistic. Plan inventory off the pessimistic case.
Yes, but on a separate tab that rolls up into the master. Subscription revenue compounds and churns; one-shot is transactional. Mixing them in one formula obscures both. Build a subscriber-cohort tab (new, retained, churned) and feed the monthly MRR total into the consolidated view.
Treat BFCM as its own campaign row with a multi-day lift, not a seasonality bump. Last year's BFCM revenue ÷ last year's BFCM traffic gives you a conversion benchmark; apply it to this year's planned traffic. Most stores see 15-25% of Q4 revenue land in that 5-day window.
Within ±10% on the quarter is good for a store in the €1-15M range. Within ±5% on the month is rare and usually means you're under-forecasting on purpose. Track forecast vs actual every month and write down the variance reason — that's how the model gets better.
No, one template with channel splits is cleaner. What you do need is a paid-channel sub-model feeding the master: spend × ROAS = paid revenue. When the media plan changes, only the sub-model updates and the master picks it up automatically.
Two rows in the campaign tab: a conversion-rate lift assumption (e.g. +0.3 percentage points from a checkout test) and a launch month. Apply the lift to baseline traffic only, not to campaign traffic — campaigns already have their own conversion assumptions baked in.
For under €15M revenue, a well-built Google Sheet or Excel file is faster than any planning tool and easier for the team to challenge. Move to a dedicated platform (Pigment, Cube, Anaplan) when you have multi-entity consolidation or more than three people editing simultaneously.
The revenue forecast is the parent number that feeds your media plan, inventory buy, and cash-flow template. Outputs from this model (monthly net revenue, channel splits) become inputs to those. Linking them — or copy-pasting on a schedule — keeps the operating plan internally consistent.
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.