Printable coffee shop inventory count sheet

How do you build a cafe inventory count sheet?

Two decisions make a count sheet fast or slow, and neither of them is a formula. The first is what goes on it: the objects a cafe actually stocks, not the produce and protein sections of a kitchen grid. The second is the order: you count in the order you walk the room, so you never cross back for something you already passed. Everything else on the sheet is six columns and a pen.

zone   = where in the room it lives, in walk order
item   = what your team calls it out loud
unit   = what one of it means when you count it
par    = the count that puts it on the order
Mon Wed Fri = one column per count, never overwritten
notes  = why a number looks wrong

items on the sheet = every row you kept, in the zones you left on

The seeded sheet, zone by zone, and the only sum on the page:

zone 1, the bar reach-in           5 items
zone 2, the bean shelf             3
zone 3, tea and matcha             3
zone 4, paper and plastics         6
zone 5, chemicals and supplies     5
zone 6, the pastry case            3

items on the sheet = 5 + 3 + 3 + 6 + 5 + 3 = 25 items across 6 zones

That sum is the only arithmetic on this page, and it is deliberate. A count sheet records what is on the shelf when you counted. It does not work out what left the shelf between counts, and any sheet that claims to is quietly making it up. Switch a zone off and the total moves. Nothing else here computes anything.

The order is physical, not alphabetical. Start at the bar reach-in, move to the bean and tea shelf, then paper storage, then the supplies under the sink, and finish at the pastry case. One loop, no zig-zag. Sort the same 25 rows alphabetically and you will walk the room five times, which is how a ten minute count becomes a half hour one.

Each item needs a unit so that 3 always means three of the same thing. A carton and a case are not the same 1, and a sheet where half the team counts one and half counts the other produces numbers nobody can act on.

The par column is what turns a count into a decision. When the count sits at or below par, the item goes on the order, and nobody has to judge whether 19 is a lot. If you have not set pars yet, leave the column blank and fill it in after two weeks of counts.

A worked example: 25 items, 6 zones, one loop

The sheet opens seeded with 25 items from a working cafe, in the order you would meet them walking the room. Zone 1 is the bar reach-in: whole milk by the gallon at a par of 6, half and half and heavy cream by the quart, oat and almond by the carton. Zone 2 is the bean shelf, three origins in five pound bags. Zone 3 is tea and matcha, a kilogram tin and two chai cartons.

Then the back half. Zone 4 is paper and plastics, six lines of cups, lids, straws, napkins and filters, which is the group most cafes under-count until the morning they are out of 16 ounce lids. Zone 5 is the supplies under the sink: cafiza, dish soap, sanitizer, gloves, trash bags. Zone 6 is the pastry case, counted last because it is received that morning.

Three count columns, not seven. Monday, Wednesday and Friday is enough to read a burn rate and stay ahead of every supplier cutoff. The Monday count catches the weekend damage, Wednesday tells you whether the start of week order was right while there is still time to fix it, and Friday sets up the weekend before the suppliers who skip Sunday go quiet.

Now make it yours. Rename anything that is not what you carry, delete the rows you do not stock, add your own, and switch off a zone your shop does not have. Then print it for the bar, or download the CSV and paste the same rows into a spreadsheet.

All 25 rows, the zones they sit in and the reasoning behind the walk order are written out in the cafe count sheet template.

Frequently asked questions about cafe count sheets

What should be on a coffee shop inventory count sheet?

The objects your shop actually stocks, grouped the way they are stored: dairy and alt-milks at the bar, beans and tea on the shelf, paper and plastics in storage, chemicals and supplies under the sink, and the pastry case on its own. About 60 lines for a specialty cafe. Each row needs a unit, so a 3 always means three of the same thing, a par so the count becomes a decision, and one column per count date. A downloaded kitchen template gets the objects wrong: it opens on produce and proteins and has no row for matcha, oat milk or chai concentrate.

How often should a cafe count inventory?

Three times a week, Monday, Wednesday and Friday, is enough for a cafe. Daily counting is labor you do not get back, and weekly is too slow to catch a burn rate before a cutoff. Monday catches the weekend damage, Wednesday tells you whether the start of week order was right while Thursday and Friday can still be fixed, and Friday sets up the weekend before the suppliers who do not run Sunday go quiet. Perishables that turn in a day, milk and pastries, get a quick morning eyeball on top of that. The full sweep stays at three.

Can I use this count sheet in Google Sheets?

Yes. Download the CSV and open it in Google Sheets and you get the same rows, in the same walk order, with the count cells empty and ready to fill. Once it is in a spreadsheet, four columns pay for themselves: used since last count, which is the previous count minus this one; per day, which is used divided by the days between counts; below par, which is this count minus par, where a negative means order today; and order quantity, which is the order-to level minus this count. Freeze the header row and the item column so a 60 row sheet is still readable on a phone, and give every count its own dated column rather than overwriting the last one.

Why does the pastry par say standing instead of a number?

Because a pastry par is not a shelf level, it is your standing order with the bakery. The croissants arrive in the morning and are meant to sell out by close, so there is no reorder point to count against. What the pastry rows record is how many came in against how many were supposed to, and the gap is a delivery discrepancy worth logging. Writing a number in that column would invent a par that does not exist, so the sheet writes the word standing instead.