Food inventory is everything edible you've paid for and not yet sold: what's in the walk-in, the freezer and dry storage, plus the packaging it goes out in. A food inventory template is a list with a row for each item, in the unit you count it in, with how much is on hand, what a unit cost, a level to reorder at, and where it's kept. Food adds one thing most inventories don't need: a use-by date for each delivery, because the chicken that arrived Monday and the chicken that arrived Thursday aren't the same stock. Count it on the same day every week or month and one formula turns the list into the number that matters, what the food you used actually cost. Below is a list for a made-up cafe kitchen, the count, the formula, and the file.
The short version
- One row an item, in one unit, kept the same every count.
- List the rows in the order you walk the storage: cooler, freezer, dry storage.
- Unit cost is what you paid, delivered.
- Write each delivery's use-by date. Use the oldest first.
- Food used = opening inventory + purchases − closing inventory.
- Divide food used by food sales for the food cost percentage.
- TaroStack keeps food by lot and date, counted on a phone. More below.
An example list
Counted on a Sunday night after closing.
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Chicken breast, boneless | lb | 42 | 30 | $3.85 | $161.70 | OK |
| Whole milk | gal | 9 | 12 | $4.10 | $36.90 | REORDER |
| Eggs, large | dozen | 22 | 15 | $2.90 | $63.80 | OK |
| Romaine lettuce | case | 3 | 4 | $28.00 | $84.00 | REORDER |
| Tomatoes | lb | 36 | 25 | $1.45 | $52.20 | OK |
| Bread flour | lb | 150 | 100 | $0.62 | $93.00 | OK |
Ten rows in all, $941.50 at cost, with two to reorder: milk and romaine. The walk-in cooler holds $398.60 of it, dry storage $425.90 and the freezer $117.00.
The unit is the one argument worth having once. Romaine arrives by the case and is used by the head. Pick one, write it in the column, and count in it every time. A count of "3" that was cases last month and heads this month is how a food cost jumps for no reason.
Unit cost is the last price you paid, with delivery in it. Update it when an invoice changes it. More on listing ingredients is in ingredient inventory template.
Dates
| Received | Item | Lot or code | Quantity | Use by | Note |
|---|---|---|---|---|---|
| Nov 16 | Chicken breast, boneless | Case code 6320 | 40 lb | Nov 23 | Use first |
| Nov 18 | Whole milk | Carton date | 12 gal | Nov 30 | |
| Nov 14 | Eggs, large | Pack date 318 | 30 dozen | Dec 12 | |
| Oct 28 | Bread flour | Lot 24F118 | 200 lb | Apr 28 |
The dates here are the ones on this kitchen's own deliveries. Write down what's printed on yours. New stock goes behind old stock on the shelf, so the oldest is what a cook's hand reaches first: see stock rotation methods. A list built around dates is in inventory list with expiration dates.
The count
Count with two people where you can: one counts, one writes. Walk the storage in the order of the sheet, and count everything, open containers included. An open 50 lb bag that's about half full is 25 lb.
The file's count sheet has a column for what the list said and a column for what you found. The difference, times unit cost, is what went missing or was never written down: waste, a portion that's grown, a delivery that came up short. Waste belongs on its own log as it happens: see waste log template.
Area by area: walk-in cooler inventory sheet, freezer inventory sheet, dry storage inventory template.
The food inventory formula
| This cafe, four weeks | |
|---|---|
| Opening inventory, from the last count | $880.00 |
| Purchases, from invoices | $3,260.00 |
| Closing inventory, from this count | $941.50 |
| Food used: opening + purchases − closing | $3,198.50 |
| Food sales | $10,150.00 |
| Food cost: food used ÷ food sales | 31.5% |
Purchases alone don't tell you what you used. This cafe bought $3,260.00 of food and used $3,198.50, because $61.50 more is on the shelves than four weeks ago. Without the two counts, a month where you stocked up looks like a month where costs ran away.
What the percentage should be depends on the menu. How to judge yours is in what is a good food cost percentage, and comparing it with what the recipes say it should be in food cost variance formula.
Get the template
Download the food inventory template. Four sheets: inventory with value and REORDER, deliveries with use-by dates and days left, a count sheet that works out each difference and what it's worth, and a read-me with the formula. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The sheet is right on Sunday night. By Tuesday three deliveries have come in and two cases of chicken have gone out as lunch, and it's a week old in two days. The use-by dates are on a second tab nobody opens during service. And the count takes two people two hours, so in a busy month it doesn't happen, and that's the month the food cost moved.
How TaroStack does it
TaroStack keeps the list current between counts.
Receiving adds stock as it arrives, with or without a purchase order, each delivery as a lot with its use-by date. Scanning a supplier's GS1-128 case label fills in the lot and the date.
Batches take out what recipes use, by lot, so prep comes off the shelf in the records too.
Oldest first. Stock goes out first-expired-first-out by default, with an alert before a date arrives.
Counting works on a phone with no signal, in the walk-in. A count shows what each difference is worth.
Every adjustment carries a reason, so waste is a number by cause.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| What's on hand today | As of the last count | Kept current by receiving and batches |
| What's about to expire | A second tab | An alert |
| What the count found | Typed in afterward | Counted on the phone, valued |
| What to order | Rows that look low | A reorder list in days of cover |
TaroStack doesn't run the till, and it isn't a temperature log. It connects to Square. Stock, lots, counts and reordering are on every plan, from $9.99 a month (50 items) or $39 a month (3,000 items). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
