Coffee Shop Inventory Management: How to Track Stock

Coffee shop inventory management is the process of tracking the ingredients, packaging, retail products, and operating supplies a café needs to serve customers without running out or over-ordering.

The difficult part is that a coffee shop does not manage one kind of stock. Beans, milk, syrups, pastries, cups, retail coffee, and cleaning supplies all move at different speeds and need different counting and replenishment rules.

This guide gives you a practical step-by-step system you can use whether you run one café or multiple locations.

Last reviewed: August 10, 2026.

Quick answer: how to manage coffee shop inventory

1. Decide exactly what you need to track.
2. Standardize SKUs, units of measure, suppliers, and storage locations.
3. Take a reliable opening count.
4. Set a daily, weekly, and monthly counting routine.
5. Track ingredient usage, waste, deliveries, and transfers.
6. Set reorder points using usage, supplier lead time, and safety stock.
7. Reconcile purchase orders when deliveries arrive.
8. Review variances and adjust purchasing as demand changes.

If you use inventory software, connect it to your POS where supported so sales, recipes, and stock movements do not have to be re-entered manually.

Step 1: decide what your coffee shop should track

Start by separating inventory into four groups. This makes it easier to choose the right counting frequency for each one.

Ingredients

Track coffee beans, milk, alternative milks, syrups, sauces, tea, chocolate, food ingredients, and other products consumed when drinks or food are made.

These are usually the most important items to keep accurate because they directly affect menu availability, purchasing, waste, and cost of goods sold.

Packaging and consumables

Cups, lids, sleeves, napkins, straws, bags, and takeout containers may not be ingredients, but running out of them can still stop service. They need their own stock levels and reorder rules.

Retail products

Bags of coffee, bottled drinks, merchandise, and packaged food can usually be tracked as individual sellable SKUs and tied directly to POS sales.

Operating supplies

Cleaning products, sanitizer, paper goods, and other back-of-house supplies do not need the same precision as milk or beans, but they should still be monitored if running out would affect operations.

Step 2: build a clean inventory catalog

Before setting alerts or automating anything, make sure every tracked item has a consistent definition. For each item, record:

• Product name
• SKU
• Unit of measure
• Supplier
• Purchase cost
• Storage location
• Supplier lead time
• Reorder point or target level

The most common mistake is inconsistent units. If oat milk is purchased by the case but counted by the carton, the system needs a clear conversion. The same applies to beans purchased by bag but consumed by weight.

For replenishment thresholds, see the reorder point guide and safety stock guide.

Step 3: take a reliable starting count

Your inventory system is only as useful as the quantity you start with. Before relying on reports or reorder alerts, perform a physical count of the stock currently in the café.

1. Choose a time when stock movement is low, usually before opening or after closing.
2. Count one storage area at a time.
3. Use the same unit of measure defined in your catalog.
4. Separate opened and unopened quantities when that matters operationally.
5. Record damaged, expired, or unusable inventory separately instead of counting it as available stock.
6. Resolve large discrepancies before treating the count as your baseline.

For a full process, use the physical inventory count guide.

Step 4: create a counting routine your team can actually follow

Count frequency should follow inventory risk. The goal is not to count everything every day; it is to count important items often enough to catch problems before they affect service or purchasing.

Daily or very frequent checks

• Fast-moving milk and alternative milks
• Coffee beans used heavily during service
• Fresh pastries and short-life food
• Anything close to stocking out

Weekly checks

• Syrups, sauces, and slower-moving ingredients
• Cups, lids, sleeves, and packaging
• Retail coffee and merchandise
• High-value or high-variance items

Monthly or lower-frequency checks

• Cleaning products
• Low-risk operating supplies
• Slow-moving back stock

Assign responsibility to specific roles or shifts. A repeatable routine is more valuable than a perfect count that only happens occasionally. For a lighter-weight approach, see cycle counting.

Step 5: connect sales to ingredient usage

A coffee shop sells menu items, but it buys ingredients. That distinction matters.

A latte may consume espresso beans, milk, syrup, a cup, and a lid. If your system only subtracts one “latte” when the sale happens, you still do not know how much milk or coffee you have left.

For recipe-based inventory, define the quantity of each ingredient used by each menu item and modifier. Then compare theoretical usage from sales with actual usage from physical counts.

If the two do not match, investigate portion differences, remakes, comps, unrecorded waste, recipe assumptions, or receiving errors instead of forcing the numbers to agree.

Square users can see a more specific setup in the Square inventory guide for coffee shops.

Step 6: record waste instead of hiding it

Expired milk, stale pastries, spills, remakes, samples, damaged products, and preparation waste should be recorded consistently.

Waste is useful operational data. Repeated waste can point to over-ordering, incorrect par levels, poor storage, inconsistent portions, or demand changes.

Review waste separately from unexplained variance. If you simply adjust inventory down without recording why, you lose the information needed to improve purchasing.

Step 7: set reorder points for the items that matter most

A common starting formula is:

Reorder Point = (Average Daily Usage × Lead Time) + Safety Stock

If a café uses 12 cartons of oat milk per day, replenishment takes two days, and the café keeps 10 cartons as a buffer, the reorder point is 34 cartons.

Do not use the same safety rule for every item. Perishable milk, dry beans, cups, and retail merchandise have different shelf-life, storage, supplier, and stockout tradeoffs.

Reorder thresholds should also change when demand changes because of seasonality, weather, promotions, tourism, events, or a growing customer base.

Step 8: make purchasing and receiving part of the inventory system

A useful purchase order should connect what you have, what you expect to use, what is already on order, and what the supplier can deliver.

When a delivery arrives:

1. Compare the delivery with the purchase order.
2. Confirm quantities actually received.
3. Record substitutions, missing items, and damaged goods.
4. Confirm the receiving location.
5. Only then update available inventory.

This prevents short shipments or substitutions from becoming invisible inventory errors. See how to create a purchase order and the broader inventory replenishment process.

Step 9: review variances instead of blindly correcting them

A POS can record sales correctly while your ingredient inventory is still wrong. Common causes include:

• Recipe quantities that do not match real portions
• Milk or syrup substitutions
• Unrecorded waste, samples, comps, or remakes
• Deliveries entered incorrectly
• Transfers between cafés
• Cases being confused with individual units
• Physical counting mistakes

When the system and shelf disagree, work backward from the last reliable count. Check receiving, waste, transfers, units of measure, and recipe assumptions before making a manual correction.

Step 10: manage each coffee shop location separately

If you operate multiple cafés, do not assume every location should carry the same quantity. Each shop can have different traffic patterns, menu mix, storage capacity, delivery schedules, and supplier constraints.

Use these rules:

• Track stock separately by location.
• Use location-specific reorder points.
• Record transfers at both the sending and receiving locations.
• Compare waste and stock variance by location.
• Check whether another café has excess stock before placing an emergency supplier order.

See multi-location inventory management and Stash for coffee shops.

How to calculate coffee shop COGS

A standard inventory-based COGS calculation is:

Beginning Inventory + Purchases − Ending Inventory = Cost of Goods Sold

For example, if beginning inventory is $2,000, purchases are $4,000, and ending inventory is $1,500, COGS for the period is $4,500.

The right COGS percentage depends on menu mix, pricing, portions, purchasing, and waste, so avoid treating one generic benchmark as a universal target.

What to look for in coffee shop inventory software

The best system is the one that matches how your café actually buys, receives, counts, sells, and replenishes stock.

• POS integration where supported
• Ingredient and recipe-level tracking
• Low-stock and critical-stock alerts
• Supplier and lead-time management
• Purchase orders and receiving
• Location-specific inventory and transfers
• Demand forecasting and reorder guidance
• Waste, variance, and inventory reporting
• A counting workflow staff can use consistently

A spreadsheet can work for a small café with a short product list. Dedicated software becomes more useful when frequent sales, recipe ingredients, several suppliers, purchasing, or multiple locations make manual updates hard to maintain.

Here is how Stash can help a coffee shop

If the process above sounds manageable but too manual, that is the point where Stash becomes useful.

Stash is built for coffee shops that need to connect what they sell with the ingredients and supplies they actually need to buy. Instead of maintaining separate spreadsheets for counts, suppliers, purchasing, and locations, Stash brings those workflows into one inventory system.

• Track ingredients and recipes: recipe-based sales can deduct the ingredients used, rather than only tracking the finished menu item.
• Connect Square sales: Stash connects with Square so sales and inventory data can sync without manual double-entry.
• See stock by location: each café can keep its own inventory quantities and thresholds while owners see the wider operation.
• Know what needs attention: low, critical, and out-of-stock alerts help teams focus on products at risk.
• Plan purchasing: supplier information, lead times, purchase orders, and receiving live in the same workflow as inventory.
• Use demand data: Stash uses sales history, consumption patterns, and seasonality to support forecasting and reorder decisions.

The goal is not to remove physical counts. It is to make the data between counts more useful, reduce manual updates, and give your team a clearer answer to three everyday questions: What do we have? What are we about to run out of? What should we order next?

See how Stash works for coffee shops or start a free trial.

Coffee shop inventory checklist

1. List every ingredient, supply, and retail SKU worth tracking.
2. Standardize units of measure.
3. Record suppliers, costs, and lead times.
4. Perform a reliable starting count.
5. Define recipe quantities for ingredient-based menu items.
6. Create daily and weekly count routines.
7. Record waste, comps, and discrepancies.
8. Set reorder points for high-impact items.
9. Reconcile deliveries against purchase orders.
10. Review variances before correcting stock.
11. Use location-specific thresholds for multiple cafés.
12. Review demand and reorder rules when sales patterns change.

Frequently asked questions

What inventory should a coffee shop count most often?

Prioritize fast-moving perishables, high-value ingredients, products with high variance, and anything that would significantly affect service if it ran out.

How often should a coffee shop do inventory?

There is no single schedule for every item. Fast-moving perishables may need daily checks, while packaging, retail products, and slower supplies can be counted weekly or less often depending on risk and supplier lead time.

How do coffee shops reduce inventory waste?

Record waste consistently, use older stock first where appropriate, adjust purchasing to current demand, review portion assumptions, and investigate recurring variance instead of simply writing stock off.

Should every café location use the same reorder points?

No. Reorder points should reflect demand, lead time, shelf life, storage, and stockout risk at each location.

Can Stash work with Square for a coffee shop?

Yes. Stash connects with Square and is designed to add inventory workflows such as ingredient tracking, stock alerts, purchasing, forecasting, and multi-location visibility around the POS sales data.

Related coffee shop inventory guides

• Square Inventory for Coffee Shops and Cafés
• Inventory Par Levels
• Inventory Forecasting Methods
• Franchise Inventory Management