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.

Use this formula for the prep column:

Target Quantity - Current Quantity = Quantity to Prep

In 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

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:

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

Use-First List

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

Buy-Next List

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.

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.

Sources

• FDA Food Code 2022
• FDA Food Code 2022 full PDF
• FoodSafety.gov FoodKeeper App
• EPA Wasted Food Scale
• ReFED Restaurant Food Waste Action Guide
• ReFED Solutions for Food Waste