Bakery Prep List Template: Daily Production Planning Without Full Inventory
A bakery prep list should answer five questions before the first tray goes in:
- What should we use first?
- What should we prep today?
- What should we skip because we already have enough?
- What should we buy next?
- What waste should the manager review later?
That is a different job from full inventory. You do not need to count every bag of flour before opening. For a small bakery, cottage bakery, or cafe with pastry prep, the better starting point is a short list of items that expire, get overprepped, run out, or cost enough to matter.
Download the Excel bakery prep list template. It includes formulas, example rows, filters, dropdowns, use-first fields, manager review fields, and food safety caveats. You can also download the CSV version if you want a plain spreadsheet starter.
Start With Key Items
The all-or-nothing inventory trap is real. You decide to get serious, build a huge cottage bakery inventory spreadsheet, then ask the team to count flour, sugar, salt, parchment, berries, cream cheese, pastry cream, cooked chicken, fillings, dough, and finished pastries every morning. The system lasts a week.
Use a smaller list first. Track the 10 to 30 items that drive daily prep decisions:
- Perishable fillings, frostings, creams, cut fruit, savory proteins, and washed produce.
- Finished or semi-finished items that carry over, such as unbaked croissants, dough, quiche mix, or sourdough loaves.
- High-cost items that hurt when you throw them out.
- Items that often run out during service.
Bulk dry goods still matter, but they usually belong in weekly purchasing checks, not the daily bakery prep sheet. Daily prep needs speed.
For a broader version of this approach, see daily prep without full inventory.
Bakery Prep List Template
Copy this simple version into paper, a whiteboard, Google Sheets, or Excel.
| Category | Item | Unit | Current Qty | Target Qty | Low Stock Qty | Qty to Prep | Earliest Expiration | Days Left | Use First? | Prep Action | Buy Next? | Waste Note | Staff Initials |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Pastry | Croissants, unbaked | count | 15 | 60 | 12 | 45 | 2026-07-04 | 2 | Yes | Prep 45 count | No | Watch proofing waste | AB |
| Dough | Sourdough loaves | count | 4 | 20 | 6 | 16 | 2026-07-05 | 3 | No | Prep 16 count | Yes | Feed starter today | AB |
| Fillings | Vanilla pastry cream | qt | 2 | 5 | 1 | 3 | 2026-07-03 | 1 | Yes | Prep 3 qt | No | Use older batch first | JR |
| Produce | Strawberries | qt | 1 | 6 | 2 | 5 | 2026-07-02 | 0 | Yes | Prep 5 qt | Yes | Bruised berries for compote | JR |
| Produce | Spinach, washed | lb | 3 | 3 | 1 | 0 | 2026-07-04 | 2 | Yes | Do not prep | No | Use existing stock | MK |
| Protein | Cooked chicken | lb | 10 | 10 | 3 | 0 | 2026-07-06 | 4 | No | Do not prep | No | Skip today | MK |
| Frosting | Cream cheese frosting | qt | 0.5 | 4 | 1 | 3.5 | 2026-07-03 | 1 | Yes | Prep 3.5 qt | Yes | Check cream cheese | AB |
| Fillings | Lemon filling | qt | 1 | 3 | 1 | 2 | 2026-07-04 | 2 | Yes | Prep 2 qt | No | Label new batch | JR |
Use this formula for the prep column:
Target Quantity - Current Quantity = Quantity to PrepIn a spreadsheet, use:
=MAX(Target Quantity - Current Quantity, 0)The MAX keeps the answer from going negative. If you target 10 lb of cooked chicken and already have 10 lb, the sheet says 0. That one zero is the point. It tells the baker what not to prep.
Why Each Field Exists
| Field | Why it belongs on the prep sheet |
|---|---|
| Category | Groups work by station, such as dough, pastry, fillings, produce, savory, or frosting. |
| Item | Names the exact batch or ingredient the team can find in the walk-in. |
| Unit | Prevents count, pounds, quarts, trays, and tubs from getting mixed. |
| Current Quantity | Forces a walk-in check before prep starts. |
| Target Quantity | Sets the amount you want ready for the day or shift. |
| Low Stock Quantity | Triggers a buy-next note before the kitchen runs out. |
| Quantity to Prep | Turns the sheet into an action list. |
| Earliest Expiration Date | Helps the team spot older batches before opening new ones. |
| Days Left | Makes date pressure visible during a busy shift. |
| Use First? | Puts First-Expired, First-Out behavior on the actual work list. |
| Prep Action | Gives the baker a plain task, such as “Prep 3 qt” or “Do not prep.” |
| Buy Next? | Connects prep work to purchasing without a second form. |
| Waste Note | Captures the review clue while the event is still fresh. |
| Staff Initials | Shows who counted, prepped, or reviewed the row. |
If you want a walk-in-only companion to this template, use the use-first list.
Manager Version
Managers need a little more context than the morning team. Add these columns when you review waste, food safety, batch history, and purchasing:
| Category | Item | Unit | Storage Location | Safety Sensitive? | Current Qty | Target Qty | Qty to Prep | Batch Date | Earliest Expiration | Actual Prepped | Waste Qty | Waste Reason | Weekly Review Note |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Fillings | Vanilla pastry cream | qt | Walk-in, top shelf | Yes | 2 | 5 | 3 | 2026-06-28 | 2026-07-03 | 3 | 1 | Expired | Lower target if this repeats |
| Pastry | Croissants, unbaked | count | Freezer A | No | 15 | 60 | 45 | 2026-07-01 | 2026-07-04 | 45 | 4 | Proofing error | Review proofing schedule |
| Protein | Cooked chicken | lb | Walk-in, bottom shelf | Yes | 10 | 10 | 0 | 2026-06-30 | 2026-07-06 | 0 | 0 | Skip prep today | |
| Produce | Strawberries | qt | Reach-in | No | 1 | 6 | 5 | 2026-07-01 | 2026-07-02 | 0 | 0.5 | Spoilage | Buy smaller packs midweek |
Keep the service sheet short. Keep the manager sheet useful. A prep cook should not have to fill 20 fields before mixing dough.
Example: Thursday Morning at a Small Bakery Cafe
It is 4:00 AM on Thursday. The lead baker sells pastries in the morning and a small savory menu at lunch. Before mixing anything new, she checks the walk-in and freezer.
Starting Inventory
| Item | Category | Target | Current Qty | Status |
|---|---|---|---|---|
| Croissants, unbaked | Pastry | 60 count | 15 count | Thawed yesterday |
| Vanilla pastry cream | Fillings | 5 qt | 2 qt | Use soon |
| Cooked chicken | Protein | 10 lb | 10 lb | Enough for lunch prep |
| Spinach quiche mix | Savory | 8 qt | 3 qt | Older batch first |
| Strawberries | Produce | 6 qt | 1 qt | Soft berries in the reach-in |
Use-First List
| Priority | Item | Why it is first | Action |
|---|---|---|---|
| 1 | Vanilla pastry cream | Older batch should be used before a new batch | Use for fruit tarts before mixing new pastry cream |
| 2 | Strawberries | Soft fruit will not improve during service | Turn into compote or use in early pastries |
| 3 | Spinach quiche mix | Existing batch is already prepped | Use current mix before making more |
Do not combine an older safety-sensitive batch with a new one unless your food safety procedure allows it and the final label uses the correct discard date. The FDA Food Code includes date-marking rules for ready-to-eat, Time/Temperature Control for Safety foods held more than 24 hours. Local rules and your inspector’s guidance control the final procedure.
Prep List
| Item | Math | Prep Decision |
|---|---|---|
| Croissants, unbaked | 60 target - 15 on hand | Prep 45 |
| Vanilla pastry cream | 5 qt target - 2 qt on hand | Prep 3 qt, label new batch |
| Cooked chicken | 10 lb target - 10 lb on hand | Prep 0, skip today |
| Spinach quiche mix | 8 qt target - 3 qt on hand | Prep 5 qt |
| Strawberries | 6 qt target - 1 qt on hand | Wait for purchase or delivery before fresh prep |
Buy-Next List
| Item | Why it is on the list |
|---|---|
| Strawberries | Current stock is below target and quality is slipping. |
| Cream cheese | Needed before the next frosting batch. |
| Eggs | Low after quiche and pastry cream prep. |
Waste Review Note
At the end of the day, the manager sees a note: “1 qt pastry cream discarded yesterday because it reached the discard date.” One discard does not prove the target is wrong. If the same item appears in the bakery waste log several days in a row, the manager should lower the target or change the menu plan.
For a fuller review process, use the restaurant waste log template.
Before and After
With a static bakery opening checklist, the baker sees “prep 60 croissants, 5 qt pastry cream, 10 lb chicken.” She might prep the whole list because that is what the paper says.
With a bakery production planning template, she checks current quantity first. The croissant prep drops to 45. The chicken prep drops to 0. The pastry cream row tells the team to use the older batch first and label the new batch. The sheet becomes a decision tool, not a memory test.
Common Mistakes
Tracking Too Much
If your first sheet has 150 rows, your team will stop updating it. Start with items that expire, get overprepped, or run out. Add more only after the morning count becomes a habit.
Setting One Target for Every Day
Friday targets rarely match Tuesday targets. Use different prep targets for weekdays, weekends, holidays, bad weather, farmers market days, and catering pickup days.
Ignoring Existing Batches
Most overproduction starts when the team preps from the target alone. The target is not the prep amount. Current quantity comes first.
Hiding the Use-First Work
First-Expired, First-Out only works when the team can see what to grab. Put the use-first note beside the prep action. If a batch sits in the back of the walk-in, the spreadsheet did not help.
Logging Waste Without Reviewing It
A bakery waste log is not a drawer for bad news. Review it weekly. If croissants, frosting, pastry cream, or fillings keep showing up, change the target, batch size, production schedule, or menu use.
Treating Food Safety as Spreadsheet Logic
A spreadsheet can calculate days left. It cannot decide whether a product is safe. Use the sheet to organize dates, labels, and review habits. Follow local food safety rules.
Food Safety Caveats
The FDA Food Code is a model code that local, state, tribal, and territorial jurisdictions can adopt or modify. Your local health department has the authority for your bakery.
Safe claims for a prep list:
- Ready-to-eat, Time/Temperature Control for Safety food held more than 24 hours needs date marking under FDA Food Code section 3-501.17.
- The FDA Food Code uses a maximum 7-day window at 41 F or below for covered ready-to-eat TCS foods, with day one counted as the day of preparation or opening.
- When covered foods are combined, the date marking must account for the oldest prepared or opened ingredient.
- Frozen food must remain frozen, and TCS food must be thawed under approved conditions.
- FoodKeeper can help with quality and storage guidance, but commercial kitchens still need to follow their regulatory authority.
Claims to avoid:
- Do not say all bakery items have the same shelf life.
- Do not restart the food safety clock just because an item was frozen.
- Do not use a spreadsheet formula as a food safety rule.
- Do not treat sell-by or best-by quality dates as the same thing as a regulatory discard date for covered TCS foods.
- Do not invent shelf-life times for pastry cream, egg wash, fillings, or cream-filled pastries unless your local rule or validated procedure supports them.
Use this disclaimer in your own bakery prep sheet:
This prep list is an operational planning tool. It is not a food safety plan and does not replace local, state, or federal food safety rules. Follow your local health department, your written procedures, and the FDA Food Code where applicable. When a date, formula, or label conflicts with your local rule, the local rule wins.Using FoodSaver Instead of a Spreadsheet
Spreadsheets work well until they become another job. During a busy morning bake, the team may skip updates, forget to mark a batch, or leave the buy-next note on paper. That is when a lightweight tool can help.
FoodSaver is built around the same small-list workflow: track key items, count current batches, see use-first priorities, calculate prep gaps, flag buy-next items, and log waste. It also supports voice logging for kitchen actions, so a team can record prep, use, or waste without opening a spreadsheet during service.
FoodSaver is still a workflow tool. It does not replace your local food safety rules, labels, cooling procedures, or inspector guidance.
| Task | Paper prep list | Spreadsheet | FoodSaver |
|---|---|---|---|
| Prep math | Manual calculation | Formula-based | Calculated from tracked items and batches |
| Use-first work | Handwritten notes | Date columns and filters | Daily use-first priorities |
| Buy-next items | Separate note | Low-stock formula | Low-stock and prep-gap list |
| Waste review | Often delayed | Weekly tally | Waste logs tied to key items |
| Best fit | Very small team | Team willing to maintain sheets | Team tired of spreadsheet upkeep |
If you are just getting organized, download the template above and run it for a week. If you already know the spreadsheet will become the bottleneck, check out FoodSaver pricing.
Frequently Asked Questions
What is a bakery prep list template?
A bakery prep list template is a daily production sheet. It shows what the team has on hand, what target quantity they need, what to prep, what to use first, and what to buy next.
How is a bakery prep sheet different from a cottage bakery inventory spreadsheet?
A prep sheet tells you what to do today. A cottage bakery inventory spreadsheet usually tracks broader stock, purchasing, vendors, cost, and raw ingredients. Many small bakeries need both, but the daily prep sheet should stay shorter.
What belongs on a bakery opening checklist instead?
Use a bakery opening checklist for sanitation, equipment, display case setup, oven checks, cash drawer tasks, and front-of-house setup. Use the production plan for batch decisions.
How do I set prep targets?
Start with expected sales, batch size, day of week, weather, events, and yesterday’s carryover. Then adjust weekly using waste notes and sellout notes. Do not let one unusual day rewrite the whole target.
Should I track flour and sugar on the daily sheet?
Usually no. Track shelf-stable bulk goods in a purchasing or weekly inventory routine. Put daily attention on the items that spoil, need labor, or create service problems when they run out.
Can I use this as a bakery waste log?
Use the waste note for quick shift context. Keep a separate waste log for quantity, reason, estimated cost, and manager follow-up.