A coffee shop inventory sheet is a simple record for counting ingredients and supplies, comparing what is on hand with what you need, and noting what should be reordered. Use the blank template below as a printable starting point, then adjust its units and columns to match the way your café buys, stores, and uses stock.
What a coffee shop inventory sheet does
An inventory sheet turns a walk-through of your storage areas into a consistent record. Rather than relying on memory or waiting until a product runs out, staff can see what is available, how it is measured, and whether a purchase is due. A sheet can also help explain differences between expected and counted quantities, such as a delivery that arrived short or a product that spoiled.
It is useful to distinguish an inventory count from a sales report. A sales report records what was sold; an inventory count records the stock physically present at a particular time. Comparing the two can help a manager notice unusual usage, but the sheet alone cannot establish why a difference occurred. It is a practical operating document, not a substitute for accurate receiving records or a careful review of waste and recipes.
Small shops may use one sheet for a weekly count, while larger or busier operations may keep separate sheets for different storage areas or count high-use items more often. The best format is the one staff can complete consistently.
What to include on the sheet
Each line should describe one stock item in terms that make it easy to identify and count. “Milk” may be too vague if the shop carries several types or package sizes. Use a clear name such as “whole milk, 1-gallon jug,” and use the same wording each time. Avoid changing between package counts and individual units without recording the conversion.
Useful fields include:
- Count date and location: Record when the count took place and whether it covers the refrigerator, dry store, bar, or another area.
- Item and category: Name the product and group it, for example coffee, dairy, alternative milk, syrups, food, cups, or cleaning supplies.
- Unit: State whether the count is in bags, kilograms, bottles, cartons, sleeves, or another unit.
- Quantity on hand: Enter the amount physically counted, not an estimate based on what the sheet says should be there.
- Par level and quantity to order: Record the target stock level and the amount needed to reach it.
- Supplier, order date, and notes: These optional details help staff follow up on an order, record a delivery issue, or explain a count adjustment.
Not every café needs every field. If a sheet becomes so detailed that people skip it, remove fields that do not support a real task. Keep the item names and units stable, since consistency makes counts easier to compare over time.
Coffee Shop Inventory Sheet Template
Blank inventory sheet — Count date: ____________________ Location: ____________________ Counted by: ____________________
| Item | Category | Unit | Quantity on hand | Par level | Quantity to order | Supplier or order note | Count notes |
|---|---|---|---|---|---|---|---|
Sample — fictional details: On a sample count dated 12 May, “House espresso beans” might be listed under Coffee, measured in 1 kg bags, with 4 bags on hand, a par level of 8 bags, and 4 bags to order. These figures are illustrative only; a real shop should set its own levels based on its usage, delivery schedule, and storage capacity.
How to use the sheet during a count
A repeatable routine matters more than a complicated form. Decide who counts, which areas are included, and when the count happens. If more than one person works on it, assign clear sections so the same shelf is not counted twice or missed. Keep the sheet and a pen or device with the person doing the physical count.
- Prepare the item list. Use the current list and add a line for any new product. Remove discontinued products only after confirming they are no longer stocked.
- Count one area at a time. Move through the café in a consistent route, such as dry storage, cold storage, bar, and service supplies. This makes it easier to avoid overlooking items stored away from their usual place.
- Use the stated unit. Count whole packages when practical. If a partly used package must be measured, use a consistent method and record the unit or estimate clearly rather than treating it as a full package.
- Record exceptions. Note damaged packaging, items past their usable date, open packages, or stock held aside. Follow the shop’s normal handling process for items that should not be used.
- Work out the order quantity. Compare the counted amount with the target level and account for any orders already placed but not yet received.
- Review and follow up. Check surprising figures before submitting an order. When a delivery arrives, compare it with the order and update the record if the shop uses the sheet to track receiving.
For example, if a café has 3 sleeves of takeaway cups on hand and its chosen par is 7 sleeves, the basic gap is 4 sleeves. If 2 sleeves are already on an outstanding order, staff should consider that incoming quantity before placing another order. Recording the outstanding order somewhere visible prevents both an accidental shortage and a duplicate purchase.
Setting par levels and reorder quantities
A par level is a target amount of stock to have available for a product. It is not a universal number: it depends on how quickly the shop uses the item, how often it can be replenished, the supplier’s delivery schedule, and how much storage space is available. A high-use staple may need a larger buffer than a slow-moving seasonal syrup, while a perishable product generally calls for careful attention to expected use and delivery timing.
A straightforward starting point is to review usage across ordinary service periods and note how long replenishment takes. Set a provisional target that covers expected use until the next practical delivery, with an appropriate buffer for normal variation. Then compare the target with actual counts over several cycles and adjust it. Seasonal drinks, local events, weather, and changes in menu availability can all affect demand, so a par level should be reviewed rather than treated as permanent.
For a simple sheet, calculate the basic order gap as par level minus quantity on hand, with a minimum result of zero. Then account for confirmed incoming stock and any relevant ordering constraints. The sheet can include an “on order” column if this adjustment happens often. Keep the calculation method consistent and make clear whether quantities refer to individual units or full cases.
How often should a café count inventory?
There is no single schedule that suits every coffee shop. A useful approach is to count items at a frequency that reflects their importance and the effort required to count them. High-use or easily depleted items—such as espresso beans, milk, popular cups, and lids—may warrant more frequent checks than slow-moving paper goods or backup cleaning supplies. Perishable stock also needs attention as part of routine storage and rotation, not only during a full inventory count.
Many operators choose a regular full count, such as weekly, and add shorter checks for critical items between counts. The exact rhythm should fit the café’s trading pattern and ordering schedule. Counting just before an order is prepared can make the sheet immediately useful; counting at a consistent time also makes one period easier to compare with another. If deliveries regularly arrive on particular days, decide how to treat stock received around the count so quantities are not recorded twice or omitted.
Use the same method from one count to the next. A count taken while deliveries are being unpacked may not be comparable with one taken before opening. If timing has to vary, note it. Trends are more informative when the underlying process is reasonably consistent.
Common inventory problems and practical fixes
One frequent problem is inconsistent units. A person records coffee in bags, another enters kilograms, and a third counts open bags as full ones. Choose a standard unit for each line and explain how to handle partial packages. If cases contain multiple units, write down the case size or use a separate conversion note so the order quantity is understandable.
Another problem is counting the same stock in more than one location, or forgetting a secondary storage area. Group lines by location, label shelves, and count in a fixed route. Keep products with similar names distinct, especially different milk types, cup sizes, or bean blends. A tidy, clearly labeled storage area makes counting more reliable, but the sheet should still reflect where stock is actually kept.
Large differences between counts can come from a missed delivery, an unrecorded transfer, spoilage, spills, staff use, incorrect portioning, or a simple counting error. Avoid changing a figure just to make it match an expectation. Recount the item, check recent receiving notes, and record a short explanation if the cause is known. A recurring difference may justify reviewing the recipe, serving tools, storage practices, or staff instructions.
Finally, do not let a printed sheet become a forgotten archive. Give someone responsibility for filing completed counts and updating the active item list. If an item is repeatedly entered as zero or is no longer sold, confirm whether it should remain on the form.
Storage, rotation, and safe handling
An inventory sheet supports good stock control, but it does not replace the café’s food-safety procedures or product-label instructions. Record dates or batch details where the shop’s process requires them, keep products stored under the conditions specified for them, and separate items that should not be stored together. Staff should follow applicable local requirements and the business’s established procedures for receiving, storing, and discarding food.
For products with date labels, a first-in, first-out approach—using older suitable stock before newer stock—can help reduce forgotten items. This works best when deliveries are put away behind existing stock and storage areas are organized. It does not mean using an item that is no longer suitable; staff should follow the relevant label and handling rules. Include a notes field for damaged packages or stock set aside, so it is not mistakenly treated as available for service.
Paper sheet or digital inventory list?
A printed sheet is easy to carry through storage areas, does not depend on a device during the count, and can be useful for a small operation with a stable list. Its limitations are that totals must be calculated manually, handwriting may be unclear, and completed pages need to be filed. A basic digital table can calculate order gaps, retain prior counts, and make it easier to revise item names, but it still depends on accurate entries and a clear process.
Choose based on the people who will use the record, not on the number of features available. If staff count while moving around the shop, a paper copy may be simpler. If several people need to review the same figures or compare counts, a shared digital record may be more convenient. Either way, preserve a clear distinction between counted stock, stock already ordered, and stock that has actually arrived. A more elaborate system cannot fix unclear units or irregular counting.
Frequently Asked Questions
What should a coffee shop count in inventory?
Count the ingredients and supplies the shop needs to operate, including coffee, milk, syrups, food ingredients, cups, lids, napkins, and relevant cleaning supplies. Include items that are important to ordering or availability, and use separate lines for products that differ in type or package size.
How do I calculate how much to order?
Subtract the quantity on hand from the chosen par level to find the basic gap. Then consider confirmed incoming orders and any case-size or supplier requirements. The result is a planning quantity, so check it against expected demand and storage capacity before placing an order.
Should I count open bags and bottles?
Yes, if the remaining amount affects what the shop can use or needs to order. Decide how staff will estimate or measure partial packages, state the unit, and apply the same method at every count. Do not record a partly used package as full without noting the difference.
How often should I update a coffee shop inventory sheet?
Update it whenever a scheduled count takes place and revise the item list when products or package sizes change. Many cafés use a regular full count plus more frequent checks of fast-moving essentials, but the appropriate schedule depends on usage, delivery timing, and the shop’s workflow.
Can one inventory sheet cover food and non-food supplies?
It can, especially for a small café, if categories and units are clear. Separate sheets or pages may be easier when storage areas, counting schedules, or handling needs differ. The main goal is a complete, understandable record that staff can maintain consistently.