The restaurant inventory spreadsheet is a work of fiction. It is updated by whoever is least busy, which in a kitchen is nobody. By the time the chef checks it, the tomatoes are gone and the spreadsheet says there are 8 kg.
A good inventory system is designed for the constraints of an actual kitchen: narrow time windows, changing staff, and an ingrained resistance to anything that feels like paperwork. Here is what actually works.
Why spreadsheets fail
- They require manual entry that nobody does consistently.
- They do not connect to sales — the sheet does not know that you sold 34 Butter Chickens yesterday and used 5 kg of chicken.
- They are updated in batches (weekly or monthly) instead of continuously.
- They live on one person's laptop, not accessible to the person doing the counting.
ABC classification
Not all inventory deserves equal attention. Classify every ingredient into A (high value, high velocity — chicken, paneer, fresh produce), B (medium — dry spices, dairy), C (low — cleaning supplies, foil, toothpicks). Count A items daily. Count B items weekly. Count C items monthly. That focus alone reduces the management overhead by 60%.
Daily count rhythm
The morning opening cook counts A-category items and enters the count on the Indostra inventory screen — or into a shared Google Sheet if you are not there yet. The count takes 8 minutes. It is the same 12 items every day. The ritual creates accuracy.
Inconsistent count times (sometimes before deliveries arrive, sometimes after) corrupt your data. Pick 8am, before the first delivery, and never deviate.
Vendor order sheet
Based on the daily count and tomorrow's forecast prep list, the system generates a vendor order sheet. For each A-item, it calculates: quantity on hand + quantity to arrive today − quantity needed for tomorrow = order quantity. Print or WhatsApp it to your vendor by 10am. Done.
Recipe-linked depletion
Every time an item is sold, the ingredients for that recipe are automatically deducted from inventory. Sell 10 Butter Chickens: deduct 1.5 kg chicken, 400g tomato puree, 200g cream. This theoretical depletion runs in parallel with physical counts. The variance between theory and actuals is your shrinkage — waste, theft, and measurement error combined.
Low-stock alerts
Set a reorder point for every A-item. When the stock level drops below it, Indostra sends an alert to the manager's phone. The manager confirms the order, which auto-populates the vendor order sheet. The chef never runs out of chicken mid-service again.
15 years in restaurant operations across 3 continents. Former GM of a 5-star hotel restaurant in Mumbai.