Quick answer: A workable coffee shop inventory system has five parts: a count sheet organized by shelf, a fixed count schedule (perishables several times a week, packaging weekly, everything monthly), par levels for every item, first-in-first-out rotation with date labels, and a monthly comparison of expected vs. actual usage (variance). Keep it simple enough that it actually happens every week.
Key takeaways
- Count the same way, same day, every week.
- Every item gets a par level; order up to it.
- FIFO + date labels prevent spoilage and health-code issues.
- Variance tells you where margin is leaking.
Why inventory matters more now
Margins are under pressure across the industry. World Coffee Portal points to unprecedented cost pressures on U.S. coffee shops. Inventory is where you control cash: too much ties up money and risks spoilage; too little causes stockouts and rush orders.
Step 1: Build a count sheet that matches your shelves
Organize your count sheet in the same order as your stockroom and bar, so counting is a walk, not a hunt.
| Location | Item | Unit | Par | On hand | Order |
|---|---|---|---|---|---|
| Stockroom shelf 1 | 12 oz hot cups | sleeve of 50 | |||
| Stockroom shelf 1 | 90 mm lids | sleeve of 50 | |||
| Walk-in / fridge | Whole milk | gallon | |||
| Bar rail | Vanilla syrup | bottle | |||
| Dry storage | Espresso beans | 5 lb bag |
Count in the unit you order in (cases, sleeves, gallons, bags) to avoid conversion errors.
Step 2: Set a schedule
| What | How often |
|---|---|
| Milk and dairy | 2–3 times a week |
| Coffee | Weekly |
| Cups, lids, sleeves, straws, food packaging | Weekly |
| Syrups, sauces, powders | Weekly |
| Cleaning supplies, merch | Monthly |
| Full count of everything | Monthly (for cost of goods) |
See our ordering calendar for a sample weekly rhythm.
Step 3: Set par levels
Par = average daily use × (days between deliveries + lead time) + safety stock
Start with estimates, then refine after a month of real data. Raise pars before busy seasons (holidays, summer iced demand) and lower them for slow ones. Our complete supplies guide walks through a worked example.
Step 4: Rotate and label
- First in, first out: new stock goes behind old stock.
- Date labels on opened milk, syrups, sauces and prepped food. Many health codes require ready-to-eat, temperature-controlled foods held more than 24 hours to be used within seven days, counting the day of opening as day one. Check your local code.
- Keep packaging sealed and off the floor.
Step 5: Track waste
Keep a simple waste log at the bar: date, item, amount, reason (spilled, expired, remake, quality). Review weekly. Patterns jump out quickly: a lot of milk at close, a syrup that keeps expiring, a cup size that gets damaged in storage.
Step 6: Calculate variance monthly
- Expected usage = units sold × recipe amount (from your POS and recipes)
- Actual usage = beginning inventory + purchases − ending inventory
- Variance = actual − expected
| Item | Expected | Actual | Variance | Likely cause |
|---|---|---|---|---|
| Whole milk | 260 gal | 290 gal | +30 gal | Over-steaming, waste at close |
| 16 oz cups | 3,100 | 3,400 | +300 | Double-cupping, damage, giveaways |
A small variance is normal. A large or growing one is margin walking out the door. Use our cost per drink guide to put a dollar value on it.
Tools that help
- Spreadsheets are enough for most single-location cafés.
- POS inventory features can deduct ingredients automatically as drinks sell.
- Inventory apps speed up counts with barcodes or mobile entry.
- Recurring deliveries remove steady items from the weekly scramble.
Keep it simple enough to stick
The best inventory system is the one your team actually follows every week. Start with milk, cups, lids and coffee, the items that move fastest, and add detail once the habit sticks.
Take packaging off the count sheet's worry list
Affogato Reserve delivers branded cups, lids, sleeves, napkins and pastry packaging on a recurring schedule, so your weekly count is about fine-tuning, not firefighting. See products.
Frequently asked questions
How often should a coffee shop count inventory?
Count fast-moving and perishable items like milk, cups and lids at least weekly, and milk more often. Do a full count of everything at least monthly so you can calculate cost of goods sold accurately.
What is a par level?
A par level is the amount of an item you want on hand after each delivery to cover usage until the next one. A simple formula is average daily use times the days until the next delivery plus lead time, plus a safety buffer.
What is inventory variance?
Variance is the difference between what you should have used, based on sales, and what you actually used, based on counts. High variance usually points to waste, over-portioning, theft or recording errors.
What's the easiest way to track coffee shop inventory?
Start with a simple spreadsheet organized in the same order as your shelves, count on the same day each week, and compare usage with POS sales. Many POS systems offer inventory features as you grow.
Sources
- South Carolina Department of Agriculture, “Date Marking for Retail Food Establishments.”
- World Coffee Portal, “Growth Slows in $58.5bn US Branded Coffee Shop Market Amid Unprecedented Cost Pressures (Project Café USA 2026).”
Sources checked October 2026. Statistics are reported as published by each source.