Home Baker's Order & Delivery Tracker
Custom-order bakers lose deposits, double-book Saturdays, and ship the wrong dietary build because their order book lives in a DM thread and three sticky notes. This free Excel workbook gives every order its own row — customer, items, dietary, deposit, balance, delivery details — and rolls a production calendar backwards from each delivery date. Built for the first 100 custom orders.
A six-tab Excel workbook for custom-order home bakers — cottage cake decorators, cookie artists, sourdough subscribers, and seasonal pie sellers — who run their order book out of a notebook, an Instagram DM thread, or a stack of sticky notes. The Orders tab is one row per order with customer, items, dietary requirements, allergens, deposit, balance due, delivery method and time, and status. The Production Calendar tab works backwards from each delivery date to compute Bake Day, Decorate Day, and Shop By — with red rows flashing 0–2 days out and amber rows flashing 3–7 days out. The Customers tab rolls every order up by customer name into total orders, total spend, and last-order date so repeat buyers are obvious. The Pricing Math tab is the per-order true-cost sanity check — ingredients + labor + packaging in, margin % out, with a Flag column that calls out anything below your floor. The Reference tab carries the order-status drop-down, the lead-time defaults, the FDA Big-9 allergen list, and a glossary. Built to take you through the first 100 custom orders without losing a deposit, double-booking a Saturday, or shipping a wedding cake without confirming the tree-nut policy.
- Orders tab: one row per order with order #, date booked, customer, contact, items, qty, dietary, allergens, subtotal, deposit, balance due (auto), delivery method, delivery date and time, address/pickup notes, status, days-to-delivery (auto), and notes — eight sample orders wired in across cake / cookie / sourdough / macaron / pie / cupcakes
- Drop-down pickers: Status (Inquiry → Confirmed → Deposit Paid → In Production → Ready → Delivered → Paid in Full / Cancelled), Delivery method (Pickup / Local Delivery / Courier / Mail), and Dietary (None / GF / DF / Egg-free / Nut-free / Vegan / GF+DF / Vegan+GF / Other)
- Production Calendar tab: pulls every confirmed order and computes Bake Day, Decorate Day, and Shop By — red rows flash 0–2 days out, amber rows flash 3–7 days out
- Customers tab: COUNTIF / SUMIF / MAX rollups per customer name — total orders, total spend, average order $, last-order date, plus a Preferences notes column for dietary needs and decorating quirks
- Pricing Math tab: ingredients + labor (hours × rate) + packaging columns with a Flag column — green / amber / red on orders vs. your configurable margin floor (default 50%)
- Reference tab: eight order statuses explained, lead-time defaults for cake / cookie / macaron / sourdough, the four delivery methods, the FDA Big-9 allergen list (with sesame), and a glossary
- 30 padding rows: every formula tab auto-extends so you can add orders for months without rebuilding Balance due, Days to delivery, Customer rollups, or Pricing Math
Educational tool only — not legal, tax, food-safety, or accounting advice. Cottage food laws (revenue caps, allowed sales venues, labeling, allergen disclosure) vary by state and change every legislative session; verify the current rules with your state agriculture or health department before selling. Allergen handling is the baker's responsibility — the FDA Big-9 list on the Reference tab is a starting point and is not a substitute for confirming each customer's specific requirements in writing. Cost and margin numbers are estimates from the inputs you type in; actual ingredient draw and labor will vary order to order. Consult a qualified attorney or CPA for licensing, contract, and tax questions.
Why custom orders break the way a normal product business runs
Two cakes for next Saturday are not interchangeable. One is a gluten-free birthday for a six-year-old and the other is a three-tier wedding cake for a hundred guests with a tree-nut allergy in the wedding party. Treat them as identical line items and you will buy the wrong specialty flour, double-book a Sunday delivery, or ship the wrong dietary build. Custom-order bakers need a system that holds the customer, the items, the dietary requirements, the deposit, and the delivery details together — not five sticky notes and an Instagram DM thread.
This workbook is one row per order, with the data fields a custom-order baker actually needs: customer and contact, items and quantity, dietary and allergens (separate columns — the customer's stated dietary need is not always the same as the full allergen list you must keep out of the build), subtotal and deposit (balance due solves itself), delivery method and date and time and address, and a status drop-down that walks the order from Inquiry through Paid in Full.
How the production calendar rolls backwards from delivery
For each order on the Orders tab, the Production Calendar tab computes Bake Day, Decorate Day, and Shop By by subtracting the lead-time defaults on the Reference tab from the delivery date. Most cakes default to one day for both bake and decorate; sugar flowers and tall layered builds need two to four days; macarons rest 24 hours before bake; cold-fermented sourdough takes three days from mix to delivery. Override any value on the Reference tab and every order on the calendar reprices its lead times.
Conditional formatting flashes RED on rows 0–2 days out (delivery is now or imminent — bake day is past) and AMBER on rows 3–7 days out (decorate is in the window, shop day is now or yesterday). The Active column reads the order status — anything Delivered, Paid in Full, or Cancelled drops to N and stops appearing as active work. Print the calendar Sunday night and you have your week.
How to track allergens and dietary restrictions on custom cake orders
A customer who orders a vegan cake has stated a dietary need (no animal products). The allergens you must keep out of the build to honor that order are dairy, eggs, and any honey-based glaze. They are related but not identical. The Orders tab keeps Dietary and Allergens in separate columns precisely so the customer-facing description and the kitchen-facing exclusion list do not collapse into each other.
The FDA Big-9 allergen list — expanded from eight to nine when sesame was added under the FASTER Act of 2021 (effective January 2023) — covers wheat, eggs, milk, soy, peanuts, tree nuts, fish, shellfish, and sesame, and is on the Reference tab with a one-line note about each. Always confirm the customer's exact wording in writing — text or email — and copy that wording into the Allergens column. If the order says "tree nuts" but the customer means "almond only" (a common cottage-food edge case for marzipan and macaron orders), you need that detail in writing and in the Notes column. Cross-contact in a shared kitchen is the most common allergen failure; a dedicated GF prep board or a kitchen-cleaning protocol between batches matters more than ingredient swaps.
How the per-order pricing math sanity check works
The Pricing Math tab pulls each order's subtotal from the Orders tab and asks for three inputs: ingredient cost, labor (hours × your hourly rate), and packaging. Total cost rolls up automatically; profit and margin % compute from the subtotal you quoted; the Flag column tags every order green ("OK"), amber ("Below floor — review"), or red ("Loss — reprice") based on a configurable margin floor (default 50%).
Run this BEFORE you quote, not after. The most common cottage-baker pricing mistake is flat-per-tier or flat-per-dozen pricing where wedding cakes and intricate cookie sets quietly subsidize simpler builds. A three-tier wedding cake with sugar flowers can take 22 hours of labor; an eight-inch buttercream round takes 3.5. Pricing them on the same flat-rate scale leaves the wedding cake cleared at less than minimum wage. The Flag column turns that math into a visible warning so you catch it before the order books, not when the year-end P&L exposes it.
Or skip the spreadsheet entirely
A spreadsheet remembers one order at a time. Ardent Seller remembers every customer, every recipe, every dietary preference, and every delivery date — and the production schedule, the allergen flags, and the per-order cost roll-up come out of the same data without you typing anything twice. So when Priya orders her second wedding cake, you already know she is tree-nut sensitive, that lavender-lemon was the flavor she chose last time, and that her partner picks up at the loading dock entrance.
Customer & order tracking
Every order, every customer, every dietary preference in one place — with the order history attached to the customer record so a repeat buyer is one click away from their last order.
Recipes & production runs
Build a recipe once with ingredients, labor, and packaging — the per-order cost updates automatically when a vendor price moves, and a production run decrements raw materials and stamps a batch lot.
Multi-location inventory & batch traceability
Track flour, butter, sugar, and packaging by lot and expiration date — the cottage food traceability your state regulator wants to see, without paper notebooks.
Frequently asked questions
How does a home baker keep track of custom orders?
The pattern that scales: one row per order, in a single source of truth, with status, deposit, balance due, delivery date and time, and dietary requirements all visible at once. This Excel workbook does that on the Orders tab. The most important columns are status (so future you can tell the difference between a deposit-paid booking and an unconfirmed inquiry), delivery date (so the production calendar can roll backwards from it), and dietary + allergens (so the kitchen builds the right cake). Confirm everything in writing — text or email — before you bake.
How far in advance should a home baker prep for a custom cake order?
Most custom cakes need 2–3 days of total prep: shop day (3 days before delivery), bake day (1 day before), decorate day (same day as bake or the morning of delivery for many builds). Wedding cakes with sugar flowers add 2–4 days for the flowers to dry. Macarons need a 24-hour rest between pipe and bake. Cold-fermented sourdough is a 3-day process from mix to delivery. The Reference tab in this workbook has editable lead-time defaults for all of these — the Production Calendar tab uses them to compute bake / decorate / shop dates per order.
How do I track a deposit and balance for a custom cake order?
On the Orders tab, fill the Subtotal column with your quoted total and the Deposit column with the amount the customer has paid up front. The Balance Due column subtracts deposit from subtotal automatically. Deposit policies vary widely; in our experience working with home bakers, common patterns range from a small flat amount (around $25) for a single cookie set up to 30% of subtotal for higher-stakes wedding cakes — pick a policy and apply it consistently rather than treating each order as a one-off. Update the deposit cell when the second half is collected, and the balance flips to $0; move the status to Paid in Full to log the order as fully settled.
How do I handle dietary requirements and allergens on a custom order?
Keep dietary (the customer's stated need: vegan, gluten-free, etc.) and allergens (the specific ingredients you must keep out of the build: wheat, dairy, eggs, tree nuts, etc.) in separate columns. Confirm the customer's exact wording in writing — text or email — and copy that wording into the Allergens column. Cross-contact matters as much as ingredient swaps: use a dedicated gluten-free prep board, separate utensils, and a kitchen-cleaning protocol between batches. The Reference tab in this workbook lists the FDA Big-9 (wheat, eggs, milk, soy, peanuts, tree nuts, fish, shellfish, sesame) plus cottage-food add-ons.
How many custom orders can a home baker take at one time?
It depends on your kitchen capacity, the complexity of each order, and your lead-time tolerance. A practical heuristic: count baking hours plus decorating hours plus shopping/admin time across the orders booked in a given week, and compare against the hours you can realistically work without burnout. Times vary by baker skill level and design complexity — track your own first to set defaults that match your kitchen, rather than relying on industry benchmarks. The Production Calendar in this workbook shows everything booked in the next 0–7 days at a glance, so you can decline a new inquiry before you double-book.
Do I need separate pricing for delivery versus pickup orders?
Yes — delivery costs you mileage, drive time, and (often) refrigerated transport. A common pattern is a flat delivery fee scaled to distance and cake size, or a per-mile charge above a free-pickup baseline; the right number depends on your local market and your hourly rate. Add the fee to the subtotal so the deposit and balance math works out. Track the delivery method on the Orders tab — Pickup, Local Delivery, Courier, or Mail (where cottage food law permits shipping) — and use the Address column for either the pickup window + access notes or the delivery destination + your time window. Cottage food sales tax rules vary by state, including whether delivery fees are taxable separately — check yours.
How do I price a wedding cake versus a birthday cake?
Different math. Wedding cakes are pricing by hours, not diameter — sugar flowers alone can be 6+ hours, fondant work 4+ hours, three tiers and dowels 4+ hours, plus delivery and setup at the venue. A three-tier cake is not 3× the work of a one-tier; it is more like 5–10× depending on decoration. Birthday cakes scale closer to linear because the decoration is simpler. The Pricing Math tab in this workbook lets you log ingredient, labor, and packaging cost per order — so you can see whether the wedding cake you quoted at $680 is actually clearing margin once 22 hours of labor go in. Pricing wedding cakes flat-per-tier is the single most common reason cottage cake decorators burn out.
Related resources
Recipe Scaling & Batch Calculator
A working Excel recipe scaler — enter a base recipe, set a target yield, and every ingredient auto-scales with unit conversions (oz/g/lb/ml/cups). Plus a batch-cost tab and a unit-conversion reference.
Small-Batch Production Planning Playbook
A printable six-page playbook for handmade-goods producers — five planning principles, the demand-driven batch-sizing formula, and four worksheets for sizing, run logging, weekly WIP, and post-run audit.
Product Pricing Calculator
A working Excel pricing calculator — materials, labor, packaging, and platform fees in, a defensible retail price out. Plus a batch tab that shows what 50 vs. 10 actually costs.
Cottage Food Laws by State: The 50-State + DC Quick Reference
Revenue caps, sales venues, registration rules, and the most common restrictions for all 50 states and DC — in one place, in plain English.
Should I Raise My Prices? Decision Tool
A live web tool that runs the +10% / +20% / +30% price-hike math for one product — including the volume drop that comes with each — and tells you which scenario clears the most monthly profit.
Craft Seller Startup Checklist
36 things to set up before — and after — your first sale. Inventory, pricing, and the legal essentials in one place.
Inventory Tracker Starter Kit
A working Excel inventory tracker for makers — raw materials, finished goods, packaging, and a purchase log. Reorder thresholds and a status column do the math; conditional formatting flashes red when you are below the line.