Holiday Pre-Order Planner for Home Bakeries
Holiday week without the chaos. Take pre-orders, fill pickup slots, and know exactly what to bake, buy and box.
The Holiday Pre-Order Planner is a spreadsheet for home and cottage bakers who take Thanksgiving, Christmas or Easter pre-orders. Log each customer once. The sheet totals every item, counts bookings in each pickup slot, builds your bake plan by day, and turns your orders into a shopping list and packaging count.
WHAT'S INCLUDED
- Holiday Pre-Order Planner, SAMPLE version (a filled-in Thanksgiving example)
- Holiday Pre-Order Planner, BLANK version (reuse it for any holiday)
- Easy instructions PDF (Excel + Google Sheets)
Tabs:
- PRE-ORDERS: one row per customer. Pick a pickup slot and type quantities under each menu item (up to 10). Order total, balance due and status update automatically. Room for 300 orders.
- PICKUP SLOTS: dates and time windows with a max number of orders. Booked, spots left, items and revenue per slot. Full slots turn pink.
- BAKE PLAN: total quantity per item, quantity per pickup day with bake-by dates, how many more you can take, revenue, collected and balance due, plus a chart
- SHOPPING LIST: ingredient totals from your orders, minus what you have on hand, packages to buy and estimated cost
- PACKAGING: boxes, bags and pans needed and to buy
- MENU + INGREDIENTS PER ITEM: prices, packaging and the ingredients for one of each item
- SETTINGS + START HERE: holiday name, order deadline (with countdown) and step-by-step instructions
Works in Google Sheets and Excel (Google Sheets is free; Excel 2016+ or Microsoft 365).
HOW DELIVERY WORKS
- Instant download: right after checkout you get a download link on screen and by email.
- You receive one ZIP file. Double-click it (Mac or Windows) to unzip the files.
- Excel: open the .xlsx file. Google Sheets: go to sheets.google.com > File > Import > Upload and choose the .xlsx (step-by-step in the instructions PDF).
- Open the SAMPLE file to see how it works, then fill in the BLANK file with your own details.
- This is a digital product. Nothing will be shipped.
GOOD TO KNOW
- A computer is recommended for setup. The Google Sheets mobile app works for quick updates.
- Sample names, numbers and prices are fictional examples.
- Not affiliated with Google or Microsoft.
- For personal or single-business use. Please don't resell or share the files.
- Because this is a digital download, we can't offer returns. If a file won't open or a formula isn't working, contact us and we'll fix it or send a replacement.
- Designed with the help of AI tools; formulas tested by OvenReadySheets.
Pairs perfectly with our Bakery Order Tracker, or save with the Home Bakery Business Kit (all 6 tools).