Restaurant Inventory & Supplier Tracker - Kitchen Stock, Food Cost & Wastage (Excel & Google Sheets)

Run your kitchen stock without guesswork. Track what comes in, what the kitchen uses, what gets wasted, and what you still owe each supplier, all in one simple spreadsheet.

What's inside:

- Dashboard: stock value, supplier dues, purchases this month, food used, wastage cost, wastage % and items to reorder, plus a month-by-month chart

- Items list: unit, category, opening stock, cost and reorder level for up to 300 ingredients and supplies

- Purchases log: pick supplier and item from dropdowns; unit and total fill in automatically

- Usage & Waste log: record food used and wasted (spoiled, expired, dropped) with the cost calculated at average cost

- Stock Status: live balance, average cost and stock value for every item; low items turn red

- Payments and Supplier Ledger: total purchased, paid and still due for each supplier

- Start Here guide and example data

Works in Microsoft Excel and Google Sheets. Formulas are protected so nothing breaks by mistake; you only fill the yellow cells. No macros.

Who it's for: restaurants, cafes, cloud kitchens, caterers, bakeries and food trucks.

Licence: for use by one business. Please don't share or resell the file.

Questions? Message me through this shop and I'll help.