Restaurant Inventory Template

Count ingredients and supplies against par, flag use-by dates, and log kitchen waste so you can see what it is costing you.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Inventory

Tables

Ingredients, Waste log

Fields

23

Views

grid, calendar, dashboard, form

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Ingredients

15 fields · 7 sample rows

  • Count sheet (Grid)
  • Order sheet (Grid)
  • Use-by calendar (Calendar)
  • Kitchen (Dashboard)
ItemTextCategorySingle selectStorageSingle selectUnitSingle selectOn handNumberParNumberStock statusFormulaOrder qtyFormulaUnit costCurrencyStock valueFormulaSupplierTextUse byDateUse-by alertFormulaWaste entriesLink to another tableWaste costRollup
Chicken thigh, bonelessMeat & seafoodWalk-in coolerkg6.012.0Reorder6₹320₹1,920Licious B2B21 Nov 2026Use first17 Nov 2026₹384
Basa filletMeat & seafoodFreezerkg8.06.0In stock0₹380₹3,040Coastal Catch19 Dec 202616 Nov 2026₹228
OnionsProduceDry storekg25.020.0In stock0₹35₹875APMC vendor – Ravi3 Dec 202614 Nov 2026₹70
Fresh creamDairyWalk-in coolerL2.05.0Reorder3₹220₹440Amul distributor18 Nov 2026Discard18 Nov 2026₹330
Basmati riceDry goodsDry storekg40.030.0In stock0₹110₹4,400Metro Cash & Carry₹0
Garam masalaSpicesLinekg0.51.0Reorder0.5₹900₹450MDH wholesale₹0
Takeaway containers 500 mlPackagingDry storecase0.03.0Out of stock3₹1,600₹0PackRight₹0
Field details
Item · Text
Category · Single select
Produce, Meat & seafood, Dairy, Dry goods, Spices, Beverages, Packaging, Cleaning
Storage · Single select
Walk-in cooler, Freezer, Dry store, Line
Unit · Single select
kg, L, dozen, case, pack, piece
On hand · Number
Par · Number
Stock status · Formula
IF({On hand} <= 0, 'Out of stock', IF({On hand} <= {Par}, 'Reorder', 'In stock'))
Order qty · Formula
MAX(0, {Par} - {On hand})
Unit cost · Currency
INR
Stock value · Formula
{On hand} * {Unit cost}
Supplier · Text
Use by · Date
Use-by alert · Formula
IF({Use by}, IF(IS_BEFORE({Use by}, TODAY()), 'Discard', IF(DATETIME_DIFF({Use by}, TODAY(), 'days') <= 2, 'Use first', '')), '')
Waste entries · Link to another table
Links to Waste log
Waste cost · Rollup
sum of Cost via Waste entries

Waste log

8 fields · 4 sample rows

  • Waste log (Grid)
  • Log waste (Form)
  • Waste insights (Dashboard)
DateDateItemLink to another tableQuantityNumberReasonSingle selectUnit costLookupCostFormulaLogged byTextNotesLong text
18 Nov 2026Fresh cream1.5Expired₹220₹330Chef Joseph
17 Nov 2026Chicken thigh, boneless1.2Over-prepped₹320₹384Sous chef AnitaLunch prep for cancelled group booking
16 Nov 2026Basa fillet0.6Dropped / burnt₹380₹228Line cook Ramesh
14 Nov 2026Onions2.0Spoiled₹35₹70Chef Joseph
Field details
Date · Date
Item · Link to another table
Links to Ingredients
Quantity · Number
Reason · Single select
Expired, Spoiled, Over-prepped, Dropped / burnt, Returned by guest
Unit cost · Lookup
Unit cost via Item
Cost · Formula
ROUND({Quantity} * SUM({Unit cost}), 0)
Logged by · Text
Notes · Long text

Form view “Log kitchen waste” asks for: Date, Item, Quantity, Reason, Logged by, Notes.

Restaurant Inventory Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates