A par sheet lists every item you stock with its par level: the amount you top the shelf back up to with each order. You count what is there, take it away from the par, and the difference is your order. Below is a free par sheet for a café, with 24 example items, the one formula that sets each par, and the one that turns a count into an order quantity. No signup.
Download the par sheet
Download the free café par sheet (CSV) →
It opens in Google Sheets, Excel or Numbers. The numbers in it are examples. Replace them with yours.
| Column | What goes in it |
|---|---|
| Category, Item, Order Unit | Your list, in the unit you order in: cases, bags, gallons |
| Supplier, Delivery Days | Who brings it and on which days |
| Weekly Usage | How much you go through in a normal week |
| Days of Cover | Days from placing an order until the delivery after that one arrives (see below) |
| Buffer % | Extra on top, for a busy day or a late truck |
| Par Level | Worked out from the three columns before it |
| On Hand | What you count |
| Order Qty | Par level minus on hand |
A CSV file cannot carry formulas, so add two once and copy them down:
- Par Level (I2):
=ROUNDUP(F2/7*G2*(1+H2/100),0) - Order Qty (K2):
=MAX(0,I2-J2)
How to set a par level
The formula is:
Par = weekly usage ÷ 7 × days of cover × (1 + buffer)
Weekly usage. Count on the same day two weeks running. Last count, plus what was delivered, minus this count, is what you used. One week is a rough number; three or four weeks is a number you can trust.
Days of cover. The par has to last from the moment you place an order until the delivery after that one arrives. That is the lead time (days from ordering to delivery) plus the order cycle (days between orders). Milk ordered the day before and delivered three times a week: 1 day of lead time plus a longest gap of 3 days is 4 days of cover. Cups ordered once a week that arrive the next day: 1 + 7 = 8.
Buffer. A share on top for the day you sell more than usual or the truck is late. Between 15% and 50% is a sensible range. Use the low end for things that spoil and come often, such as pastries and milk. Use the high end for things that keep and come once a week, such as cups, lids and syrups. Running out of lids stops every drink; an extra sleeve of lids costs you nothing but shelf space.
A worked example
Whole milk, ordered the day before and delivered Monday, Wednesday and Friday. You use 24 gallons a week.
24 ÷ 7 × 4 days × 1.25 = 17.1 → par of 18 gallons
When you place the next order you count 7 gallons. You order 18 − 7 = 11.
The free par level calculator does the same sum for any item from the same parts: lead time, order cycle and a buffer. The longer explanation is in what is a par level, and reorder points covers the other way to decide when to order.
Four mistakes that make a par sheet wrong
- Pars in the wrong unit. If oat milk arrives in cases of 12, the par is in cases. A par of "36" that one person reads as cartons and another as cases doubles or halves your order.
- One par for the whole year. Iced drinks in July use different milk and cups from hot drinks in January. Look at your pars when the menu or the weather changes.
- Counting after the delivery. Count before the truck arrives. That is the low point, and the low point is what the par protects.
- A par nobody can find. Print the sheet and tape it inside the walk-in, or keep it on the phone that does the count. A par in the owner's head leaves with the owner.
Where a par sheet stops
A sheet does the subtraction. It does not notice that your usage changed. You have to recount, redo the sums and retype the pars yourself, and most of us do that less often than we should.
That is the part QuickStok takes over. You count on a phone, and it works out weekly usage for each item from your counts and deliveries. Once it has a few count cycles of your own data, it suggests a par for each item from that usage and from how often the supplier delivers, and you tick the ones you accept. Until then you type your pars in by hand, the same numbers as on this sheet. It tells you when it does not have enough data yet.
It is free for one café, and it does not expire. No credit card.
If the sheet is working for you, keep using it. Pair it with the café count sheet template for the weekly count and the supplier order guide template for placing the orders.
Things you make in the café, such as cold brew and syrups, go on a prep list instead.
Frequently asked questions
What is a par sheet?
A par sheet lists every item you stock with its par level: the amount you top the shelf back up to with each order. You count what is there, take it away from the par, and the difference is your order.
How do I calculate a par level?
Par = weekly usage ÷ 7 × days of cover × (1 + buffer). Days of cover is the lead time plus the days between orders. For milk used at 24 gallons a week, ordered the day before and delivered three times a week, with a 25% buffer: 24 ÷ 7 × 4 × 1.25 = 17.1, so a par of 18 gallons.
Should par levels be in cases or single units?
In the unit you order in. If oat milk arrives in cases of 12, set the par in cases, so the order quantity needs no conversion.
How often should I update par levels?
Check them when the menu or the season changes, and whenever an item keeps running out or keeps piling up. Recount your weekly usage every few weeks so the pars follow what you really use.