A prep list tells the opening shift what to make and how much: each prep item, how much you want ready, how much is left, and how many batches to make. It replaces "make some cold brew" with "make two batches". Below is a free prep list for a café, with 12 example items and two formulas. No signup.

Download the prep list

Download the free café prep list (CSV) →

It opens in Google Sheets, Excel or Numbers. The items and numbers in it are examples. Replace them with yours.

ColumnWhat goes in it
Prep Item, StationWhat gets made and where: bar or kitchen
Unit, Batch YieldThe unit you count it in, and how many of that unit one batch makes
Shelf Life (days)How long a batch keeps, from your own recipe and your local food safety rules
ParHow much you want ready at the start of the day
On HandWhat is left right now
To PrepPar minus on hand
BatchesTo Prep divided by batch yield, rounded up
Prepped By, Use ByWho made it, and the date it must be used by

A CSV file cannot carry formulas, so add two and copy them down:

  • To Prep (H2): =MAX(0,F2-G2)
  • Batches (I2): =ROUNDUP(H2/D2,0)

How to set it up

1. List what you make, not what you buy. Cold brew, syrups, chai, whipped cream, sandwich fillings, cut fruit. Things you buy ready to use belong on the par sheet, not here.

2. Write the batch yield. One batch of cold brew makes how many gallons? If nobody knows, measure it once. The Batches column is only as good as this number.

3. Fill in the shelf life yourself. The column is blank on purpose. How long a batch keeps depends on your recipe, your fridge and your local rules. Write it once, then use it to fill in Use By every time a batch is made.

4. Set a par for each item. Start with what you use on a busy day, plus a little. If you keep throwing an item away, lower the par. If you keep running out before close, raise it.

A worked example

Cold brew concentrate. One batch makes 2 gallons and the par is 4 gallons. At open there is 1 gallon left.

To prep: 4 − 1 = 3 gallons
Batches: 3 ÷ 2 = 1.5 → 2 batches

How to use it each day

  1. At close or at open, one person checks what is left and fills in On Hand.
  2. The sheet shows how many batches of each item to make.
  3. Whoever makes a batch writes their name and the Use By date, and labels the container with the same date.
  4. Anything past its date is thrown away and written on the waste log, so you can see which pars are too high.

Make the long items first. Cold brew that steeps overnight starts the day before; whipped cream takes two minutes.

Where a prep list stops

A paper prep list does not know what a batch costs, and it does not show the bar that the chai made on Monday is about to run out of time.

QuickStok keeps prep as batch recipes, each with a yield, a shelf life and a batch cost worked out from your latest receipt prices. Staff start a prep batch and see a countdown to its expiry. Opening and closing tasks are a checklist by station and weekday, ticked on the same link staff count on.

Two limits to know: it does not send an alert when a batch is about to expire, and making a batch does not lower the stock of its ingredients.

It is free for one café, and it does not expire. No credit card.

If paper on a clipboard works for your team, keep it. Pair it with the count sheet template for the weekly count.

Frequently asked questions

What is a prep list?

A prep list tells the shift what to make and how much: each prep item, how much should be ready, how much is left, and how many batches to make to get back to that level.

How do I work out how much to prep?

Take what is on hand away from the par, then divide by the batch yield and round up. With a par of 4 gallons of cold brew, 1 gallon left and a 2 gallon batch: 4 − 1 = 3, and 3 ÷ 2 rounds up to 2 batches.

What is the difference between a prep list and a par sheet?

A par sheet covers what you buy and decides what to order. A prep list covers what you make in the café and decides how many batches to make today.

How long does prepped food keep?

It depends on the recipe, how it is stored and your local food safety rules. The template leaves the shelf life column blank so you fill in your own figure for each item.