Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesRetail & E-commercePricing & MerchandisingHoliday Season Retail Planner

SpreadsheetPricing & MerchandisingFree

Holiday Season Retail Planner

Key peak-season dates with sales targets against last year, live results, and stock cover checked against the weeks left in the season.

Shown with sample data

Colour

Holiday Season Retail Planner

Key peak-season dates with sales targets against last year, live results, and stock cover checked against the weeks left in the season.

Season target
$84,500
Planned growth on last year
17%
Sales so far
$5,120
Events hit target
1
Days to season end
43
Products to reorder
6
Overstock risks
1
Sales target vs last year by event
  • Singles’ Day$4,500
  • Black Friday$22,000
  • Small Business Saturday$6,500
  • Cyber Monday$15,000
  • Green Monday$7,000
  • Last standard shipping day$9,000
  • Christmas Eve$3,500
  • Boxing Day$11,000
  • New Year sale$6,000
Weeks of cover by product
  • Organic sencha, 250 g11.7
  • House espresso blend, 1 kg5
  • Espresso tamper, 58 mm3.6
  • Tea lover’s gift box3
  • Espresso starter gift set2.9
  • Colombia single origin, 1 kg1.3
  • Burr grinder1.3

How to use it

  1. 1Set the season end date on the Settings sheet.
  2. 2Review the key dates, add your own (local events, last shipping days) and set a target for each.
  3. 3Enter last year’s sales for the same events so growth can be calculated.
  4. 4On the Stock sheet, enter stock on hand, on order and a weekly holiday forecast for your key products.
  5. 5Reorder anything marked Reorder now immediately, and plan promotions for Overstock risk items early.

In this workbook

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

About this template

The holiday season can be a third of a retailer’s year, and it is decided by preparation. The Key dates sheet lists the trading moments from Singles’ Day to the January sales with promotion plans, sales targets, last year’s sales and live results, showing growth on last year and whether each target was hit. The Stock sheet compares stock on hand and on order with the holiday sales forecast for each product, works out weeks of cover against the weeks left until the season end date, and tells you what to reorder now and what risks being left over.

Who it’s for

  • Black Friday and Cyber Monday planning
  • Christmas and end-of-year trading
  • Setting daily or event targets against last year
  • Avoiding stockouts on best-sellers in peak season

What’s included

  • Key dates sheet: Peak-season events with targets and results.
  • Stock sheet: Stock cover for key products through the season.
  • Settings sheet: Season end and overstock rule.

How to use it

  1. 1Set the season end date on the Settings sheet.
  2. 2Review the key dates, add your own (local events, last shipping days) and set a target for each.
  3. 3Enter last year’s sales for the same events so growth can be calculated.
  4. 4On the Stock sheet, enter stock on hand, on order and a weekly holiday forecast for your key products.
  5. 5Reorder anything marked Reorder now immediately, and plan promotions for Overstock risk items early.

Tips

  • Order peak-season stock earlier than usual: suppliers and carriers get slower from October onwards.
  • Publish your last order date for delivery before the holidays and plan a promotion for the days after it (gift cards, click and collect).
  • Compare event days with the same event last year, not the same calendar date; Black Friday moves each year.
  • Plan staffing and customer service cover from your busiest days last year.

Questions

When is Black Friday in 2026?

Friday 27 November 2026, with Cyber Monday on 30 November 2026. Black Friday is the day after US Thanksgiving (the fourth Thursday of November).

How much stock should I hold for the holidays?

Enough to cover forecast sales until the end of the season plus a safety buffer, minus what is already on order. The Stock sheet compares weeks of cover with the weeks left in the season for each product.

How do I set holiday sales targets?

Start from last year’s results for each event, adjust for your growth this year, traffic trends and planned promotions, and sense-check the total against your stock and staffing.

Related searchesholiday retail plannerblack friday planning spreadsheetchristmas retail plannerpeak season sales planholiday inventory planningbfcm planner

Details

Format
Spreadsheet
Category
Pricing & Merchandising
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetPricing & MerchandisingFree

Holiday Season Retail Planner

Key peak-season dates with sales targets against last year, live results, and stock cover checked against the weeks left in the season.

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
Pricing & Merchandising
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More pricing & merchandising templates

View all
Open-to-Buy Plan2 sheets

Planned purchases

$235,600

Already on order

$145,000

Open to buy

$90,600

ABCD
1MonthDepartmentPlanned salesPlanned markdowns
2DecWomenswear$64,000$6,400
3DecMenswear$38,000$3,000
4DecAccessories$22,000$1,500
5DecHome$18,000$1,200
Plan
SpreadsheetPricing & Merchandising

Open-to-Buy Plan

Plan purchases by department and month from sales, markdowns and target stock, and see what is left to spend.

10 min setupPreview
Retail Pricing Calculator2 sheets

Average actual margin

61%

Below target

1

ABCD
1ProductChannelUnit costTarget margin
2Organic cotton teeWebsite$8.4060%
3Organic cotton teeEtsy$8.4060%
4Soy candle: cedarWebsite$6.1065%
5Soy candle: cedarAmazon$6.1065%
Pricing
SpreadsheetPricing & Merchandising

Retail Pricing Calculator

Set prices from cost with target margin, marketplace fees and psychological rounding.

10 min setupPreview
Promotion & Markdown Planner
Task
SepOctNov
Winter beanie BOGO
Autumn hoodie week
Candle bundle
Tote flash sale
Mug gift with purchase
Black Friday tees
SpreadsheetPricing & Merchandising

Promotion & Markdown Planner

Plan promotions with discount, baseline and marketing cost, then compare actual sales and profit with business as usual to see which deals to repeat, plus the units needed to break even.

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