E-Commerce Revenue Forecasting Tool

Founders, finance leads, merchandising, and growth at online retail, DTC, omnichannel, and marketplace-adjacent retail brands use this workbook when the job is traffic → revenue → cost of sales with chart readouts—without carrying a full profit and loss listing or three-statement model in the same file. You can still reflect fees or demand that behave like inputs when you sell through other surfaces—the workbook does not replace a two-sided marketplace revenue engine; for that motion at revenue-only depth, compare the Marketplace Revenue Forecasting Tool.

It fits peak-season planning, channel or promo experiments, inventory buy conversations tied to expected demand, and fundraising preparation when reviewers want to see how acquisition and conversion assumptions become monthly revenue and COGS before you invest in a heavier workbook.

If operating expenses, consolidated financial statements, and MM/YY chart packs should sit beside retail revenue in one maintained graph, move to our E-Commerce Financial Model. When you only need a five-tab assumptions-to-P&L-and-Charts listing, compare the E-Commerce Profit and Loss Statement. For subscription MRR mechanics, compare the SaaS Revenue Forecasting Tool. For GMV and take-rate marketplace revenue, compare the Marketplace Revenue Forecasting Tool. When revenue is retainer- and project-shaped for agencies or studios—not retail traffic—compare the Agency Revenue Forecasting Tool.

We ship a Google Sheets file with six tabs—the same names you see on the tab strip (see Content and Instructions if anything here disagrees):

1. Content and Instructions — How inputs and outputs connect, recommended fill order, style notes (blue inputs, yellow links, where it is safe to add rows), and sanity checks.
2. Settings — Company name, start date, currency, and the revenue path switch: sales mix (with the category and product table documented there) or average order value (AOV) with the averages the sheet describes.
3. Option 1 | Revenue Forecasting — Revenues and COGS using sales mix—traffic acquisition plus the category mix you maintain in Settings when that path is active.
4. Option 2 | Revenue Forecasting — Revenues and COGS using AOV—traffic acquisition plus average order value when that path is active.
5. Option 1 | Charts — Chart readouts (for example Orders, Revenues, Costs of sales as implemented) fed from Option 1 | Revenue Forecasting—not a second model you reconcile by hand.
6. Option 2 | Charts — Parallel chart readouts fed from Option 2 | Revenue Forecasting the same way.

The Option revenue tabs carry a multi-year monthly time series—set your start date in Settings, then follow Content and Instructions for how periods extend and how to keep totals coherent when you refresh the forecast. When leadership asks for a revenue or margin chart, you should be able to trace the figure back to a row on the active Option tab without exporting to a side file.

What is not in this file: a Profit & Loss tab listing operating expenses (payroll, rent, marketing outside the revenue grid’s scope, software subscriptions at the P&L level), balance sheet, cash flow statement, scenario toggles, breakeven, valuation modules, or a live connector to Shopify, Amazon, or ad consoles—you align channels as inputs the workbook documents, then read revenue, COGS, and charts from the same graph.

For vocabulary you reuse in memos, see e-commerce, average order value (AOV), cost of goods sold (COGS), revenue forecasting, and inventory—this template gives you a structured place to connect those ideas to a forward revenue view as the sheet implements them.

This file is built to answer “what do we sell, at what mix or AOV, against what direct cost structure, if traffic looks like this?”—so cost of sales (the COGS path on the active Option tab) moves with units, pricing, and fulfillment economics the way the sheet labels them.

Operating expenses—headcount bands, rent, broad marketing programs, SaaS tools as a full opex story—belong in a P&L-first or full model workbook when you need them beside revenue in one maintained graph. That is the moment to open the E-Commerce Profit and Loss Statement or the E-Commerce Financial Model so reviewers see revenue, COGS, and opex on the same path you intend to maintain.

Use this quick guide to pick the right file before you buy:

• Six-tab e-commerce revenue + COGS + charts (sales mix or AOV path) → this E-Commerce Revenue Forecasting Tool
• Ten-tab integrated e-commerce model with Revenues, HR, Software, Financial Statements, Charts (MM)/(YY) → E-Commerce Financial Model
• Five-tab e-commerce assumptions-to-P&L-and-Charts listing → E-Commerce Profit and Loss Statement
• Five-tab subscription MRR forecast (two engines + charts) → SaaS Revenue Forecasting Tool
• Three-tab marketplace revenue forecast (Content and Instructions, Revenue, Charts) → Marketplace Revenue Forecasting Tool
• Three-tab agency revenue forecast (Contents and Instructions, Revenue, Charts) → Agency Revenue Forecasting Tool
• General three-statement depth, scenarios, breakeven, valuation → Standard Financial Model

Each template is maintained as its own workbook—not the same file with a new cover.

E-commerce financial forecasting in the sense of full statements, operating spend, and balance-sheet depth belongs in the E-Commerce Financial Model (or the Standard Financial Model for the broadest operating-company package). This workbook stays focused on forward revenue and COGS with paired charts when that narrower scope matches the decision.

Training articles help with definitions; ad-hoc downloads help when you are only experimenting. This product is a single maintained Google Sheet where Settings, the active Option revenue tab, and the matching Charts tab share one calculation path—so merchandising can stress mix or AOV while finance reads the same totals leadership sees in Charts, without reconciling a revenue grid against a chart file that will not refresh.

We apply the same discipline across our revenue tools: named tabs you can audit, Sheets-first authoring (Excel only via export, with re-testing), and on-sheet instructions so the next person on your team can follow the same path.

1. Duplicate the master Google Sheet so store updates never overwrite your working copy.
2. Read Content and Instructions in full—including the numbered order we recommend.
3. Complete Settings first so sales mix versus AOV, periods, and currency match how you want to tell the story.
4. Work the Option 1 | Revenue Forecasting or Option 2 | Revenue Forecasting tab that matches your Settings choice, following blue inputs and on-sheet notes until traffic, conversion, pricing, and COGS assumptions are populated.
5. Open Option 1 | Charts or Option 2 | Charts for the leadership view tied to the same wiring.
6. Run a sanity pass (for example sales mix rows sum the way the sheet documents, growth rates stay believable, empty rows) before you send anything outside the company.
7. Revisit on a cadence you already use for planning—monthly for operating reviews, ahead of peak, or when a channel step-change lands—so assumptions stay honest as reality changes.

Yes, when the conversation centers on how traffic and merchandising assumptions produce revenue and COGS and you pair the spreadsheet with a short memo or slides for strategy, assortment, and market context. Spreadsheets rarely replace narrative, and diligence still expects judgment on execution, liquidity, and merchandising choices beyond what any template can encode.

If reviewers expect operating expenses on a monthly P&L with Charts in the same maintained file, compare the E-Commerce Profit and Loss Statement. When they expect linked financial statements and consolidated MM/YY charts in one ten-tab retail workbook, compare the E-Commerce Financial Model.

Yes—after you duplicate the master, it is your working file. Add categories or rows only where Content and Instructions says it is safe (often above the “…” marker the sheet uses), and keep Settings → the active Option revenue tab → the matching Charts tab wired the way the workbook documents.

If you expect a much larger chart of accounts, heavy scenario branching, or valuation blocks inside Google Sheets, you will usually be happier starting from the Standard Financial Model or the E-Commerce Financial Model so that structure is already there.

We author, test, and document this template in Google Sheets: collaboration, version history, and sharing match how most retail teams run forecasts today. Instructional screenshots in the file are Google Sheets throughout.

You can often export to Excel for a stakeholder who lives in Office. Treat that as a handoff step: re-check formulas, named ranges, and links after export—Microsoft Excel does not guarantee parity with every Sheets pattern or add-on.

If your team still keeps legacy revenue workbooks in Excel, use this file as the Sheets-native source of truth—finish the forecast in Google Drive, export when someone needs an .xlsx handoff, then re-validate totals after any round-trip so leadership is not comparing two divergent models.

Free downloads help you explore ideas quickly—many stop at a short-horizon units × price grid or a static example without the traffic → conversion → revenue story, COGS discipline, multi-year monthly grid, and paired charts this workbook documents. This file is a maintained product: structured tabs, documented flows from Settings through the active Option revenue tab into Charts, QA on the calculation path, and delivery through our storefront so we can ship fixes and improvements over time.

If you want a no-cost entry point first, explore CapEx planning or other free listings in the catalog, then upgrade when traffic-led revenue with sales mix or AOV and aligned charts is the bottleneck.