Restaurant Inventory Sheet: Free Template & How to Use It

Q: How often should a restaurant do inventory counts?

High-value items like proteins, seafood, and alcohol should be counted daily. Other items like dry goods, spices, and cleaning supplies can be counted weekly. Most successful restaurants do a full inventory count once a week, usually on the same day (e.g., every Monday morning before opening).

Q: What is the FIFO method in restaurant inventory?

FIFO stands for First In, First Out. It means you use older stock before newer stock. When new supplies arrive, place them behind existing stock so the oldest items get used first. This reduces spoilage and waste, especially for perishable items like vegetables, dairy, and meat.

Q: What is a par level in restaurant inventory?

A par level is the minimum quantity of each item you should always have on hand. It's calculated based on your average daily usage, delivery lead time, and a safety buffer. For example, if you use 10 kg of chicken per day and your supplier delivers every 3 days, your par level would be at least 30 kg plus a 20% buffer = 36 kg.

Q: How do I calculate food cost percentage from my inventory sheet?

Food Cost % = (Beginning Inventory + Purchases - Ending Inventory) / Food Sales × 100. For example: Beginning inventory ₹50,000 + Purchases ₹30,000 - Ending inventory ₹45,000 = ₹35,000 cost of goods sold. If food sales were ₹1,00,000, your food cost % is 35%. The industry benchmark is 28-35%.

Q: Should I use a spreadsheet or software for restaurant inventory?

Spreadsheets work well for small restaurants with under 50 menu items. But once you grow beyond that, or manage multiple locations, inventory software like DineOpen saves significant time — auto-deducting stock as items sell, sending low-stock alerts, and generating food cost reports automatically. Most restaurants see a 3-5% reduction in food waste after switching to software.

Restaurant inventory management with organized stock shelves

Indian restaurants lose an average of 4-10% of revenue to poor inventory management — that's ₹2-5 lakh per year for a mid-sized restaurant. A simple inventory sheet can cut that loss in half. This guide gives you a free template, step-by-step instructions, and tips to avoid the most common inventory mistakes.

Why Use an Inventory Sheet?

Whether you run a small dhaba or a multi-outlet chain, tracking inventory is the single most impactful thing you can do for profitability. Here's what a proper inventory sheet gives you:

Accuracy: Know exactly what's on hand — no guessing, no surprises when you run out mid-service.
Cost Control: Track usage patterns to reduce over-ordering and spoilage. Most restaurants cut food waste by 15-20% just by tracking.
Faster Counts: Standardized categories and organized layout speed up weekly counts from 2 hours to 30 minutes.
Reorder Confidence: Clear par levels mean zero stock-outs and zero emergency market runs at inflated prices.
Theft Detection: When actual stock doesn't match expected usage, you can identify pilferage quickly.
Menu Costing: Accurate inventory data feeds directly into food cost calculations, helping you price menu items correctly.

Free Inventory Sheet Template

Here are the 11 columns your inventory sheet needs. Copy this into Google Sheets or Excel and customize for your restaurant:

Item / SKU
Category (Protein / Dairy / Veg / Dry / Beverage)
Unit (kg / L / pack / piece)
Par Level (what you need on hand)
On Hand (current count)
To Order (Par - On Hand)
Unit Cost
Total Value (On Hand x Unit Cost)
Expiry / Batch
Supplier
Last Counted (date)

Count high-value items (proteins, seafood, alcohol) daily; everything else weekly. Use separate tabs for bar, kitchen, and bakery if needed.

Pro Tips for Your Spreadsheet

Color-code categories: Use green for vegetables, red for proteins, blue for beverages — faster visual scanning.
Add conditional formatting: Highlight cells in red when On Hand drops below Par Level.
Lock formulas: Protect the "To Order" and "Total Value" columns so staff can't accidentally break calculations.
Create a "Waste Log" tab: Track items thrown away with date, quantity, and reason (expired, damaged, overproduced).

How to Use (Step-by-Step)

Set Par Levels: Define minimum quantities for each item based on your average daily usage and delivery frequency. For example: if you use 5 kg onions/day and get deliveries every 3 days, set par at 15 kg + 20% buffer = 18 kg.
Count & Update: Enter the On Hand quantity. The sheet automatically calculates To Order (Par minus On Hand) and Total Value (On Hand times Unit Cost).
Reorder: Place purchase orders based on the To Order column. Always record the supplier name and batch number for traceability.
Review Weekly: Compare this week's counts to last week. Look for variances — if you used 20 kg chicken but only sold dishes that should need 15 kg, investigate the gap.
Adjust Par Levels Monthly: Seasonal changes, menu updates, and festival periods all affect demand. Review and adjust par levels at least once a month.

5 Common Inventory Mistakes (And How to Avoid Them)

Even with a good template, these mistakes can cost you lakhs per year:

1. Counting Only When You Remember

Inconsistent counting means you're always working with stale data. Fix: Set a fixed schedule — daily for high-value items, weekly for everything else. Assign specific staff members to specific sections.

2. Not Tracking Waste Separately

If spoiled items just "disappear" from inventory without being logged, you can't identify patterns. Fix: Add a waste log. Track what was wasted, how much, and why. Review it weekly to spot trends (e.g., "we always throw away paneer on Tuesdays").

3. Ignoring FIFO (First In, First Out)

New stock gets placed in front of old stock, and old stock spoils at the back. Fix: Always place new deliveries behind existing stock. Label everything with receipt dates. Train kitchen staff to pull from the front.

4. Setting Par Levels Once and Forgetting

Your par levels from Diwali season won't work in January. Fix: Review par levels monthly. Factor in seasonal demand, upcoming festivals, and menu changes.

5. One Person Doing Everything

If the same person orders, receives, and counts inventory, there's no accountability. Fix: Separate duties — one person places orders, another receives and checks deliveries, a third does physical counts.

Digital vs Paper Inventory: Which Is Right for You?

Feature	Paper / Spreadsheet	Inventory Software (DineOpen)
Cost	Free	From ₹999/month
Best For	Single outlet, <50 items	Any size, multi-location
Auto Stock Deduction	No — manual updates	Yes — deducts as items sell
Low Stock Alerts	No	Yes — instant notifications
Expiry Tracking	Manual — easy to miss	Automated batch/expiry alerts
Food Cost Reports	Manual calculation	Auto-generated daily
Multi-Location	Separate sheets per outlet	Centralized, real-time sync
Time to Count (weekly)	1-2 hours	15-20 minutes
Human Error Risk	High	Low

Bottom line: Start with the free spreadsheet template above. Once you have more than 50 items or open a second location, switch to software — the time savings alone pay for the subscription.

Do It Faster with DineOpen

Auto-Counts: Inventory updates as items sell — no manual math, no end-of-day discrepancies.
Smart Reorders: Low-stock alerts + one-click purchase orders sent directly to suppliers.
Expiry Tracking: Batch and expiry date alerts so nothing spoils unnoticed.
Recipe-Level Tracking: Define recipes with exact ingredients, and stock deducts per-recipe as orders come in.
Multi-Location: Centralized stock view for chains. Transfer stock between outlets with one click.
Analytics: Food cost %, variance reports, waste tracking, and supplier comparison — all in one dashboard.

Frequently Asked Questions

How often should a restaurant do inventory counts? ▼

High-value items like proteins, seafood, and alcohol should be counted daily. Other items like dry goods, spices, and cleaning supplies can be counted weekly. Most successful restaurants do a full inventory count once a week, usually on the same day (e.g., every Monday morning before opening). Consistency matters more than frequency — pick a schedule and stick to it.

What is the FIFO method in restaurant inventory? ▼

FIFO stands for First In, First Out. It means you use older stock before newer stock. When new supplies arrive, place them behind existing stock so the oldest items get used first. This reduces spoilage and waste, especially for perishable items like vegetables, dairy, and meat. Label all items with receipt dates to make FIFO easy for kitchen staff.

What is a par level in restaurant inventory? ▼

A par level is the minimum quantity of each item you should always have on hand. Calculate it as: (Average Daily Usage × Days Between Deliveries) + Safety Buffer (usually 20%). For example, if you use 10 kg of chicken per day and your supplier delivers every 3 days, your par level would be (10 × 3) + 20% = 36 kg.

How do I calculate food cost percentage from my inventory sheet? ▼

Food Cost % = (Beginning Inventory + Purchases - Ending Inventory) ÷ Food Sales × 100. For example: Beginning inventory ₹50,000 + Purchases ₹30,000 - Ending inventory ₹45,000 = ₹35,000 cost of goods sold. If food sales were ₹1,00,000, your food cost % is 35%. The industry benchmark for Indian restaurants is 28-35%. Use our free Food Cost Calculator for instant results.

Should I use a spreadsheet or software for restaurant inventory? ▼

Spreadsheets work well for small restaurants with under 50 menu items and a single location. But once you grow beyond that, or open a second outlet, inventory software saves significant time — auto-deducting stock as items sell, sending low-stock alerts, and generating food cost reports automatically. Most restaurants see a 3-5% reduction in food waste after switching to software. DineOpen offers inventory management starting at ₹999/month with a 14-day free trial.

Get the Free Template + Automate with DineOpen

Download the sheet to get started, then see how DineOpen removes manual counting, prevents waste, and keeps you always in stock.

Try DineOpen Free for 14 Days