Skip to content

Food Inventory Template: List, Count and Food Cost

A food inventory template for a kitchen or food business: the list by storage area, use-by dates, the count, and the formula that turns it into food cost.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 6 min read

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.

Questions people also ask

What is food inventory?

Everything edible a business has bought and not yet sold or used, usually with the packaging it's sold in. It's counted at cost, on a regular day, by storage area.

What is the formula for food inventory?

Food used = opening inventory + purchases − closing inventory. In the example, $880.00 + $3,260.00 − $941.50 = $3,198.50. Divided by food sales of $10,150.00, that's a food cost of 31.5%.

How often should you count food inventory?

On the same day each week or month, after closing. The count is the closing figure for one period and the opening figure for the next, so skipped counts leave you with no food cost for that period.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.