Inventory Spreadsheet Template: Columns and Formulas
By mise · Updated September 29, 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.
| Column | Formula / note |
|---|---|
| Item, category, unit | Text |
| Unit cost | Latest purchase price |
| Par | Target stock |
| Count | Entered at the count |
| Value | =Count × Cost |
| Order qty | =MAX(0, Par − Count) |
| Variance | =Count − Expected |
Try mise in your business
Scan the barcode or snap a photo: mise's AI finds the product and categorizes it. 7-day free trial, then US$33 a month (£26 in the UK).
Start free
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 with Barcode Scanner: Small Business
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.
How much does mise cost?
A 7-day free trial, then US$33 a month per location (£26 in the UK).