A prep sheet should answer one question fast: what needs to be made before service? When the sheet turns into a wall of numbers, cooks stop trusting it and managers start rebuilding it from memory.
A useful restaurant prep and par sheet is simple enough to update every shift and specific enough that two different people can reach the same answer.
Want a working version instead of building one from scratch? Download the Free Restaurant Prep & Par Sheet — an editable Excel template with automatic Prep Needed calculations, assignments, status tracking, due times, and notes.
Start with a real par
The par is the amount you want ready for the shift, not the maximum amount that fits in the cooler. Set it from recent usage, the day of the week, reservations, known events, and any sales pattern you can actually defend.
If the kitchen normally uses six hotel pans of an item on Friday, a Friday par of six or seven makes more sense than copying the Tuesday number. Pars should change when the business changes.
Count what is actually usable
On-hand quantity should mean product that is prepared, usable, correctly stored, and available to the station. A half-finished batch, product reserved for catering, or something that should be discarded can make a count look better than reality.
The basic calculation is straightforward: Prep Needed = Par − On Hand. If the result is below zero, prep needed is zero.
Give every prep item an owner
Adding an Assigned To column turns a list into a shift plan. It also makes handoffs cleaner because the next person can see whether an item was never started, is in progress, or is finished.
A simple status field such as Not Started, In Progress, Done, or 86'd usually gives more useful information than adding more complicated workflow.
Use the order people actually work
Group the sheet by station or by the route someone takes through storage. Grill, fry, sauté, cold line, bakery, bar, walk-in, and dry storage are easier to work from than an alphabetical master list.
The best spreadsheet is not the one with the most formulas. It is the one staff can scan quickly during a real shift.
Review misses instead of just increasing every par
If an item runs out, ask why. Was the par wrong, was the count wrong, was prep delayed, or was sales volume unusual? Increasing every par after one bad shift creates waste just as quickly as low pars create 86s.
Track patterns for a few weeks, then adjust the par intentionally.
A simple restaurant prep sheet structure
For most small operations, the useful columns are Item, Par, On Hand, Prep Needed, Assigned To, Status, Due By, and Notes. That is enough information to run prep without turning the sheet into another piece of software.
Start with the free Excel prep & par sheet. If you also want closing, waste, cleaning, and weekly-summary tools, upgrade to the Kitchen Ops Starter Pack. You can also browse all Kitchen Operations Templates.