Bar prep list template
Plan syrups, juices, cocktail batches and garnishes before service. Enter what you need and what's already on hand, then calculate how much to make, how many batches to prepare and when each item should be used by.
A weekend prep list
Syrups and pre-batched cocktails keep for several days, so make them on Friday for Friday and Saturday. Fresh juice and cut garnish do not keep, so Friday's list has only what Friday needs. Saturday's juice and garnish go on Saturday's list.
Scroll sideways for every column.
| Item | Unit | Par | On hand | Yield per batch | Batches | Make after |
|---|---|---|---|---|---|---|
| Lime juice (Friday only) | ml | 2,700 | 0 | 600 | 5 | |
| Simple syrup 1:1 | ml | 6,000 | 1,000 | 1,600 | 4 | |
| Falernum | ml | 800 | 0 | 1,000 | 1 | Simple syrup |
| Orange peels (Friday only) | each | 120 | 0 | 8 | 15 | |
| Mint sprigs (Friday only) | each | 40 | 0 | 20 | 2 |
A Friday prep list. For garnish, one batch is one orange (8 peels) or one bunch of mint (20 sprigs). Garnish goes on the same list, with the unit "each". So Friday needs 15 oranges and 2 bunches of mint.
The Excel file has an empty prep list for 40 items, set to print sideways on one page width, plus a filled sample list and a read-me with the formulas. The shaded columns work out what to make, how many batches, how much that makes and the use-by date. They stay blank until a row has what they need. Staff write what they really made under Actual made and any shortage, swap or delay under Notes, and the Status column flags items that are expired or overdue. The CSV file has the sample rows with the same columns and formulas, for any spreadsheet app.
What goes on a prep list
Each item gets one row: a syrup, a juice, a pre-batched cocktail or a garnish. A batch is one round of making that item, always to the same recipe. On hand is what is in the fridge now and still in date.
| Column | Example: simple syrup | What it holds |
|---|---|---|
| Item | Simple syrup 1:1 | The item, with its ratio |
| Unit | ml | ml, "each" for garnish, or g |
| Par | 6,000 | What the nights ahead will pour |
| On hand | 1,000 | What is in the fridge now |
| To make | 5,000 | What you still need to make |
| Batch recipe | 1 kg cane sugar, 1 kg water | The weights and volumes for one batch |
| Yield per batch | 1,600 | What one batch makes |
| Batches | 4 | How many batches to make |
| Will make | 6,400 | What all the batches make together |
| Keeps | 7 | Days it keeps, counting the day it is made as day 1 |
| Made on, Use by | Friday, Thursday | The day it is made, and the last day to use it |
| Make after | (empty) | An item that has to be made first |
| Who, Done | (empty) | A name, and a box to tick on the printed sheet |
| Actual made | What the team really made | |
| Status | Expired or Overdue, worked out for you | |
| Notes | Shortages, swaps or delays |
How to use the prep list
Make too little of an item and it runs out in the middle of service. Make too much and the syrup or juice goes down the sink when it expires. When everything is on one sheet, whoever picks it up makes the right amount without asking anyone.
To make, batches and use by
To make = MAX(0, par − on hand)
Batches = to make ÷ yield per batch, rounded up to a whole batch
Use by = made on + keeps − 1
For the simple syrup, 6,000 ml minus 1,000 ml on hand is 5,000 ml to make. One batch makes 1,600 ml, and 5,000 ÷ 1,600 = 3.125, so you make 4 batches. Four batches make 6,400 ml. The syrup keeps 7 days. Made on Friday, with Friday as day 1, it must be used by Thursday.
Round up to a whole batch so you make enough to cover the remaining par. Three batches make only 4,800 ml, which is 200 ml short of the 5,000 ml you need. If you have more on hand than par, make nothing. If the recipe scales well, you can also make a smaller batch to the exact amount, at the same ratios.
One batch of lime juice is 20 limes, pressed. At 30 ml of juice a lime, that is 600 ml. Friday needs 2,700 ml, and 2,700 ÷ 600 = 4.5, so you press 5 batches: 100 limes and 3,000 ml of juice. The exact need is 2,700 ÷ 30 = 90 limes. The extra 300 ml is the cost of making whole batches.
Do not press a whole case, the box the limes come in. One case gives about 6,000 ml of juice, more than twice what Friday needs. Pressed juice cannot wait for Saturday, so the rest of a full case would go down the drain at close.
Make after: when one item goes into another
Falernum is made with simple syrup. One batch takes 400 ml rum, 600 ml simple syrup and the zest of 6 limes, and makes 1,000 ml.
So the simple syrup par already includes the falernum's 600 ml. The drinks made with simple syrup on Friday and Saturday need 5,400 ml: 180 drinks at 1 oz (30 ml) each. Add 600 ml for the falernum and the par is 6,000 ml.
This is why the falernum row says "Simple syrup" under Make after: make the syrup first and let it cool. To scale any other spec to one batch, use the batch cocktail calculator.
Setting par for each service
On a prep list, par is what the nights ahead will pour: the drinks you expect times the amount of the item in each drink. The syrup par above, 180 drinks × 1 oz (30 ml), works this way.
With a forecast, take the drinks per night from the forecast. Then split them across the menu by how each drink sold on the same day of the week over the last four weeks.
Without a forecast, use your POS item report. For each drink, take the average count on that same day over the last four weeks. Then add drinks for bookings and events.
Never make more of an item than you will pour before it expires. Syrup not poured within its 7 days goes down the sink on day 8. Juice goes at close. Take each item's keeps figure from the shelf-life chart. Use the shorter of your house rule and any legal limit.
- Sarah Dawn MarsWrote this · Head of customer success and community
Sarah co-founded and ran Teresa Cocktail Bar, a Tales of the Cocktail nominee. She was also the first customer success hire at Loaded and now builds Overproof.
Prep list questions
What is the difference between a prep list and a par sheet?
A par sheet sets how much of each bottle the bar keeps, and it drives your orders to suppliers. A prep list does the same for house-made items, and it drives what the team makes before service.
Does the prep par include the bottles on the rail?
No. The prep par is how much the team makes: what the nights will pour. The rail par is where some of that stands: how many bottles of each pre-batched item are on the rail at opening, refilled from the walk-in fridge.
Which spreadsheet app do I need?
Any. The CSV file opens in any spreadsheet app, with the same formulas. The empty 40-row list, the print setup and the read-me are only in the Excel file.

Let the forecast write the prep list
Early access is free for your whole team, with no card. Founding bars keep 30% off list for 12 months on annual billing. Plans from $149 per bar a month, billed annually.
