How to Track Inventory for a Coffee Shop

Coffee shop inventory is uniquely difficult. You're dealing with perishable goods that expire in days, high-velocity items that need restocking constantly, dozens of ingredients that combine into hundreds of menu items, and — if you're growing — the challenge of keeping all of this consistent across multiple locations.

Most café owners start with a spreadsheet or a whiteboard. That works until it doesn't. This guide covers how to set up an inventory tracking system for your coffee shop that actually keeps up with your operations — from deciding what to track to choosing the right tools to building habits your team will follow.

What to Track

Coffee shops have four categories of inventory, each with different tracking needs:

1. Core Ingredients

These are the items that go into your drinks and food: coffee beans, milk (whole, oat, almond, soy), syrups, chocolate, tea, sugar, cream, butter, flour, eggs, and any fresh produce for food items.

Core ingredients are your highest-priority tracking items because they have the most direct impact on your cost of goods sold (COGS) and your ability to serve customers. Running out of oat milk means telling customers you can't make their regular order. That's a lost sale and potentially a lost customer.

How to track: Count these frequently — daily for the fastest-moving items (milk, beans), every delivery for perishables. Track by unit (gallons, bags, bottles) and tie consumption to sales so you can calculate how much of each ingredient you're using per drink or food item.

2. Consumable Supplies

Cups (hot and cold, multiple sizes), lids, sleeves, straws, napkins, bags, stirrers, to-go containers. These don't expire, but running out disrupts service just as badly as running out of milk.

How to track: Weekly counts are usually sufficient. Set generous reorder points because these items are cheap to overstock but expensive (in lost revenue and customer frustration) to run out of.

3. Retail Products

Bags of whole bean coffee, merchandise (mugs, tumblers), packaged snacks, bottled drinks. If you sell retail items through your POS, these should be tracked per-unit just like any retail store.

How to track: Your POS system should deduct these automatically with every sale. Physical counts weekly or biweekly to catch any discrepancies from theft, damage, or unrecorded samples/giveaways.

4. Operational Supplies

Cleaning products, sanitizer, dish soap, paper towels, register tape. Not glamorous, but running out of sanitizer can shut you down during a health inspection.

How to track: Monthly counts and a simple reorder checklist. These don't need the same precision as ingredients, but they do need to be ordered before you run out.

Setting Up Your Tracking System

Step 1: Build Your Product Catalog

List every item you need to track. For each item, record:

• Product name (be specific — "oat milk" isn't enough if you stock two brands)
• Unit of measurement (gallons, cases of 12, 5 lb bags)
• Supplier
• Cost per unit
• Storage location (fridge, dry storage, retail shelf)
• Reorder point (when to order more — see our reorder point guide)

This catalog is the foundation of your entire inventory system. Every count, every order, and every report builds on it. Take the time to set it up correctly once, and everything else becomes easier.

Step 2: Connect Your POS

If you sell through a POS system like Square, SumUp, or Lightspeed, your inventory system should connect to it. Every latte sold should automatically deduct from your coffee bean, milk, and cup inventory. Every bag of retail beans sold should deduct one unit from your retail stock.

Without this connection, you're manually updating inventory after every shift — and realistically, that won't happen consistently. POS integration is the single biggest accuracy improvement for coffee shop inventory. Stash integrates directly with Square and other major POS systems for real-time sync.

Step 3: Set Alert Thresholds

For every tracked item, set three alert levels:

• Low stock: Time to plan a reorder. For milk, this might be 2 days' supply. For coffee beans, 3-4 days.
• Critical stock: Order immediately or risk running out. Usually 1 day's supply for fast movers.
• Out of stock: You've already run out. Document it and order emergency supply.

These thresholds should account for supplier lead times. If your bean supplier takes 3 days to deliver, your "low stock" alert needs to fire with at least 3 days of supply remaining. Stash's AI demand forecasting calculates these automatically based on your actual sales patterns.

Step 4: Establish a Counting Routine

The best inventory system in the world is useless if no one counts what's actually on the shelves. Build counting into your daily and weekly operations:

Daily (during opening or closing):

• Count milk — all types, all sizes. This is your most perishable, fastest-moving category.
• Count pastries and baked goods. Note anything that needs to be pulled due to age.
• Check coffee bean supply. You need to know if you'll make it through tomorrow's morning rush.

Weekly:

• Full count of all syrups, sauces, and drink ingredients.
• Count consumable supplies — cups, lids, sleeves, napkins.
• Count retail products — bags of beans, merchandise, bottled drinks.
• Reconcile counts against your system and investigate any significant variances.

Monthly:

• Full count of operational supplies.
• Review supplier pricing — has anything changed without notice?
• Review waste and shrinkage data to identify patterns.

Assign specific counts to specific people. "Everyone is responsible" means no one is responsible. Your opening barista counts milk and beans. Your closing manager counts supplies. Your owner or manager does the weekly full reconciliation.

Managing Perishables

Perishable inventory is the defining challenge of coffee shop operations. Milk, cream, pastries, food ingredients — these have shelf lives measured in days, not weeks.

FIFO: First In, First Out

Always use the oldest stock first. When new milk arrives, put it behind the existing milk in the fridge. When new pastries come in, put them behind today's batch. This sounds obvious, but during a rush, it's easy for staff to grab whatever is closest — which is usually the newest delivery.

Label everything with the date received. Make it a non-negotiable rule: if it doesn't have a date on it, date it before it goes into storage.

Track Waste

Every item thrown away should be recorded. Expired milk, unsold pastries at end of day, dropped drinks, spoiled produce. This data tells you:

• Whether you're over-ordering perishable items (consistently throwing away the same product = ordering too much)
• Whether your FIFO process is working (items expiring means older stock isn't being used first)
• Your actual waste cost — which is invisible without tracking it

Most coffee shops waste 4-10% of their purchased ingredients. Even reducing that by a few percentage points has a direct impact on your bottom line.

Adjust Orders Seasonally

Your iced latte ingredients need to scale up in summer and down in winter. Your pumpkin spice supply has a narrow window. Your pastry orders should reflect whether it's a busy tourist season or a slow winter week.

If you're tracking sales through your POS, your inventory system can show you these patterns. Stash uses AI demand forecasting that factors in seasonality, day-of-week patterns, and trends so your purchase orders reflect what's actually going to sell — not what sold last week.

Managing Inventory Across Multiple Coffee Shop Locations

If you operate more than one café, inventory tracking gets significantly more complex. Each location has different demand patterns, different staff, and potentially different suppliers.

The key principles for multi-location coffee shop inventory:

• Each location needs its own inventory dashboard. Stock at Location A is independent from Location B. A combined view that doesn't separate by store is useless for operational decisions.
• Transfers between locations should be tracked. When your downtown shop runs low on oat milk and borrows from the suburban location, both inventories need to be updated. Informal transfers are the #1 cause of inventory discrepancies in multi-location cafés.
• Reorder points should be location-specific. Your flagship store that does 300 drinks per day needs very different thresholds than a smaller location doing 80.
• Reporting should allow comparison between locations. Which store has the lowest waste? Which has the highest COGS? Where is shrinkage happening? You can't answer these questions without per-location data.

Stash is built for multi-location coffee shops. Each location has its own dashboard, alerts, and inventory data, with a unified view for owners who need to see the big picture across all stores.

Calculating Your Cost of Goods Sold (COGS)

COGS tells you how much you're spending on ingredients relative to your sales. For coffee shops, a healthy COGS is typically 25-35% of revenue. If you're above 35%, you're either over-ordering, wasting too much, experiencing theft, or your pricing is too low.

The formula: Beginning Inventory + Purchases - Ending Inventory = COGS

If you start the month with $2,000 in inventory, purchase $4,000 more during the month, and end with $1,500 in inventory, your COGS is $4,500.

If you brought in $15,000 in revenue that month, your COGS percentage is 30% — within the healthy range.

Track this monthly at minimum. If COGS starts creeping up, investigate: are suppliers charging more? Is waste increasing? Are portion sizes inconsistent? Is someone giving away product or taking inventory home?

An inventory management system connected to your POS makes COGS calculation automatic. Stash tracks real-time stock value, margins, and product performance so you always know your numbers without pulling reports and doing manual math.

Choosing the Right Tools

Your inventory tracking approach should match your scale:

Stage	Best Tool	When to Move Up
Brand new, pre-revenue	Spreadsheet + manual counts	When you open for business and start selling through a POS
One location, steady sales	POS built-in inventory (Square free plan) + weekly counts	When you're losing sales to stockouts, wasting inventory, or want forecasting
Growing, considering a second location	Stash Core — POS-connected with AI forecasting, $79/month	When you open location #2
Multi-location coffee shop	Stash Pro or Scale — multi-location dashboards, transfers, team permissions	—

The important thing isn't which tool you start with — it's that you start tracking consistently. A spreadsheet updated religiously beats expensive software that nobody uses.

Getting Started

If you're currently winging it on inventory, here's a practical starting point:

1. List your top 20 highest-cost and highest-velocity ingredients. These are the items that matter most for COGS and customer experience.
2. Count them today. Write down how much of each you have right now.
3. Count them again in one week. Compare the difference to your sales data. This gives you your first consumption baseline.
4. Set reorder points for those 20 items based on how fast they're moving and how long your suppliers take to deliver.
5. Expand from there. Once the top 20 are dialed in, add the next 20 items and keep building until your full inventory is tracked.

Or, skip the gradual rollout: start a 14-day free trial of Stash, connect your Square POS, import your products, and have your entire coffee shop inventory system running in 15 minutes. AI demand forecasting kicks in immediately, and your stock levels update with every sale.