Free Restaurant Inventory Template
A count sheet and an order sheet that actually match how a kitchen works: items grouped by storage location, par levels, unit costs, and a total inventory value that calculates itself. No signup, no email — just the file.
Works in Excel, Numbers, and Google Sheets (File → Import).
What’s in the template
Walk the shelves, fill one column
Items grouped by storage location — Walk-in, Freezer, Dry Storage, Bar — with unit, par level, on hand, and unit cost columns. Total value per item and the grand inventory value calculate themselves.
Know what to order
Item, supplier, par level, on hand. The order quantity formula does the math: par minus on hand, never below zero. Sort by supplier and you have an order list.
Instructions included
A one-page walkthrough: how to run a count, how to set pars, and the habits that keep the numbers honest week to week.
Fifteen example rows show you the pattern — swap in your own products and you’re counting tonight. Pricing a dish instead? Try the free food cost calculator.
When the spreadsheet starts to hurt
This template will run a small kitchen fine. But a spreadsheet has a ceiling, and most kitchens hit it the same three ways.
Only one person can count at a time
A spreadsheet is single-player. In Rinvy your whole team counts at once on their phones — one person in the freezer, another in dry storage — and the count merges live.
Typing in every product by hand
Building the item list is the worst part. Photograph one supplier invoice and Rinvy’s AI reads the line items and builds your catalog for you.
Costs go stale the day prices move
The unit cost column is only right until your next delivery. Rinvy updates costs from your actual receipts and flags price jumps, so inventory value stays real.
Free plan, no card required. Your first count takes about the same time as the spreadsheet — and every count after that gets faster.
Common questions
- Is this inventory template really free?
- Yes. No signup, no email, no trial timer. Click the button and the file is yours. It is the same template whether you ever create a Rinvy account or not.
- Does it work with Google Sheets?
- Yes. In Google Sheets, go to File → Import, upload the Excel file, and everything comes across — formulas included. The CSV imports the same way if you only want the count sheet.
- What is the difference between the Excel and CSV versions?
- The Excel file has all three sheets: the count sheet, the order sheet, and instructions, with the total-value and order-quantity formulas built in. The CSV is the count sheet only — plain columns, no formulas — for anyone who wants to start from raw data.
- How do I use the par levels in the template?
- A par level is the amount you want on the shelf after a delivery. Set one per item, then the order sheet compares par to what you counted: order quantity is par minus on hand, never below zero. Review pars every few months — they drift as your menu and volume change.
- What does the spreadsheet not do?
- It cannot count with you. One person types while everyone waits, prices go stale the day a supplier changes them, and last month’s counts live in last month’s file. That is the work Rinvy automates — the template is the manual version of the same system.