Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesSales & CRMForecast & QuotaMonthly Sales Forecast

SpreadsheetForecast & QuotaFree

Monthly Sales Forecast

A 12-month forecast by product from base volume, monthly growth and seasonality, with revenue, gross profit and actuals vs forecast.

Shown with sample data

Colour

Monthly Sales Forecast

A 12-month forecast by product from base volume, monthly growth and seasonality, with revenue, gross profit and actuals vs forecast.

Forecast revenue
$586,979
Next 12 months
Gross profit
$373,235
Gross margin
64%
Actual vs forecast
0.7%
Months with actuals so far
Forecast revenue by month
  • Jan$36,682
  • Feb$34,939
  • Mar$42,159
  • Apr$44,990
  • May$45,588
  • Jun$43,845
  • Jul$42,053
  • Aug$45,081
  • Sep$50,539
  • Oct$53,703
  • Nov$66,960
  • Dec$80,440
Revenue by product
  • Pro kit$167,70029%
  • Starter kit$166,20828%
  • Refill pack$131,27122%
  • Gift bundle$66,75011%
  • Workshop seat$55,0509%

How to use it

  1. 1On the Products sheet, enter each product with price, unit cost, base units per month and expected monthly growth.
  2. 2Adjust the seasonality index for each month on the Seasonality sheet (1.00 is a normal month, 1.40 is 40% busier).
  3. 3Read units and revenue by product on the Products sheet and by month on the Monthly sheet.
  4. 4As each month closes, type actual revenue on the Monthly sheet to track variance.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Build a 12-month sales forecast the way planners do: set each product's price, unit cost, base monthly volume and growth rate, apply a seasonality index for each month, and the forecast works out units, revenue and gross profit by product and by month. Record actual revenue as months close to see variance against forecast and how the year is tracking.

Who it’s for

  • Planning stock and cash for the year ahead
  • Retail and ecommerce with seasonal peaks
  • Setting monthly sales targets

What’s included

  • Products sheet: Each product's assumptions and its forecast for every month.
  • Seasonality sheet: How busy each month is compared with an average month.
  • Monthly sheet: Forecast units, revenue and gross profit for each month, with actuals as they come in.

How to use it

  1. 1On the Products sheet, enter each product with price, unit cost, base units per month and expected monthly growth.
  2. 2Adjust the seasonality index for each month on the Seasonality sheet (1.00 is a normal month, 1.40 is 40% busier).
  3. 3Read units and revenue by product on the Products sheet and by month on the Monthly sheet.
  4. 4As each month closes, type actual revenue on the Monthly sheet to track variance.

Tips

  • Base seasonality on last year's sales by month if you have them.
  • Keep growth assumptions modest; small monthly rates compound quickly.
  • Re-forecast the remaining months each quarter.

Questions

How is each month calculated?

Base units × (1 + monthly growth) raised to the month number minus one × that month's seasonality index, rounded to whole units.

What if I sell services?

Use hours or projects as units and your rate as price.

Related searchessales forecastrevenue forecast12 month forecastseasonalityproduct forecastforecast vs actual

Details

Format
Spreadsheet
Category
Forecast & Quota
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetForecast & QuotaFree

Monthly Sales Forecast

A 12-month forecast by product from base volume, monthly growth and seasonality, with revenue, gross profit and actuals vs forecast.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Forecast & Quota
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More forecast & quota templates

View all
Weighted Pipeline Forecast2 sheets

Quarter target

$250,000

Weighted forecast

$209,200

Commit

$120,000

Weighted value by deal
$67k
$36k
$36k
$26k
$22k
Harbor Logistics, fleet suiteApex Build, estimatingNorthwind Health, analyticsBrightline Retail, POS rolloutMeridian Clinics, scheduling
SpreadsheetForecast & Quota

Weighted Pipeline Forecast

Forecast the quarter from open deals: stage probability, close month and the gap to target.

10 min setupPreview
Sales Quota Attainment Tracker2 sheets

Team attainment

45%

Projected finish

84%

Gap to quota

$347,000

Attainment by rep
81%
49%
42%
38%
27%
Priya NairMia RossiDana WuTom BeckerLeo Park
SpreadsheetForecast & Quota

Sales Quota Attainment Tracker

Bookings against quota for each rep, with pace for the days gone, projected finish, pipeline coverage and the gap to close.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ