Start free

Inventory Spreadsheet Template: Columns and Formulas

By mise · Updated October 7, 2026

Quick answer: a good inventory spreadsheet has: item, category, unit, cost, par, on-hand count, value (=count×cost), reorder quantity (=MAX(0,par−count)) and variance. Keep one tab per count date.

A spreadsheet is the classic inventory tool. With the right columns it works; the limit is the time it takes to fill.

ColumnFormula / note
Item, category, unitText
Unit costLatest purchase price
ParTarget stock
CountEntered at the count
Value=Count × Cost
Order qty=MAX(0, Par − Count)
Variance=Count − Expected

Build it in 10 minutes

  1. Put the headers in row 1: A Item, B Category, C Unit, D Unit cost, E Par, F Count, G Value, H Order qty.
  2. List items in the order they sit on your shelves, grouped by location (walk-in, dry store, bar).
  3. In G2 type =F2*D2 (count × unit cost) and copy it down.
  4. In H2 type =MAX(0,E2-F2) (par minus count, never negative) and copy it down.
  5. Add a total at the bottom of column G, for example =SUM(G2:G200).
  6. Duplicate the tab for each count date, so you can compare counts.

Usage and variance between two tabs

ItemLast countReceivedThis countUsageSold (POS)Variance
Vodka 750 ml1224152119.5 (from pours)−1.5 bottles
Chicken breast (lb)4012035125118 (from recipes)−7 lb
Paper cups 12 oz (sleeve)20402832—n/a

Usage = last count + received − this count. When you can work out expected usage from sales (pours, recipes), the difference is your variance; see inventory variance.

Ready-made templates

When to move on from the spreadsheet: if a count takes more than an hour, several people need to count at once, or you keep typing the same product names, scanning saves the time; the result can still be exported to the same spreadsheet.

Common spreadsheet mistakes

Try mise in your business

Scan the barcode or snap a photo: mise's AI finds the product and categorizes it. Free trial.

Start free
Download on the App StoreGet it on Google Play
Keep reading Restaurant inventory sheet: free template and how to use it Inventory count app: count stock by scanning, not typing Par level: meaning, formula and calculator Free inventory app: what free gets you, and when to pay All guides

Frequently asked questions

Google Sheets or Excel?

Either works; Sheets is easier to share.

How do I count faster than a spreadsheet?

Scan with a phone: mise fills the item for you.

Can mise export to a spreadsheet?

Yes, to Excel and PDF.

What is the most important column?

Unit cost at the latest purchase price. Without it the count has no value, and food cost and variance cannot be calculated.

Should I lock formula cells?

Yes. Protecting the formula columns stops counters overwriting them, which is one of the most common spreadsheet errors.

How do I share an inventory spreadsheet with my team?

Google Sheets lets several people edit at once; protect the formula columns and give each counter their own area of the sheet to avoid typing over each other.

How many tabs should the spreadsheet have?

One master list plus one tab per count date works well; a summary tab can pull the totals from each count.

Can I try mise for free?

Yes. You get a free trial, with no card needed.