Restaurant Inventory Spreadsheet, Food Cost % Excel | Weekly Count Sheet, Par Levels, Recipe Costing, Waste Variance, Order List
Item highlights
If something goes wrong with an order, we've got your back for all eligible purchases. View program terms
Price:$10.49
You can only make an offer when buying a single item
Delivery
Instant download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Seller's description
Specifications
Filled example inside: 8 weeks of a made-up bistro with 43 items and 10 dishes – the Variance sheet finds 12.5 lb of ribeye ($236.25) that went missing between actual use, recipe use and logged waste.
For restaurant owners, kitchen managers, cafés and food trucks who count stock once a week.
What's inside:
• Example workbook (Excel), filled in: 8 weeks, 43 items, 10 dishes
• The same workbook, blank, with the same formulas
• Setup guide with a paper count sheet and a waste log (Word)
• Sheets: Dashboard, Items, Counts (one column per week for a year), Purchases, Menu + Recipes, Variance, Order List by supplier, printable Count Sheet in shelf order
Why it does more than a plain inventory list:
• Dashboard: food and beverage cost % for the week you pick, dollars over target, items below par, order total, 52-week chart
• Variance: actual usage vs recipe usage vs logged waste
• Purchases: a changed case cost is flagged ("Up 7.9%") and counted at what you paid
• Items: case cost ÷ units per case = cost per count unit (10 lb case at $189.00 = $18.90 per lb), par levels, orders in whole cases
• Menu + Recipes: plate cost, food cost % per dish and what to charge to hit your target
Food cost % = (opening inventory + purchases − closing inventory) ÷ food revenue.
Works in Excel 2016+, Google Sheets and LibreOffice; the guide is a Word .docx. No macros. US Letter, US dollars. Up to 200 items and 50 dishes.
How to use:
• Enter your items once with case cost, units per case and par level
• Count your shelves each week and log invoices and waste
• Read food cost %, missing stock and the order list on the Dashboard
Digital download – nothing is shipped.
Disclosure (Etsy policy): this item was designed by the seller with the help of AI tools.
-
Item typeDigital download
-
Digital file type(s)3 Files
If something goes wrong with an order, we've got your back on all eligible purchases. View program terms
Meet your seller
More from this shop
-
Digital download
Fahrtkostenabrechnung Vorlage 2026 Excel | German, Dienstreise mit Privat-PKW 0,30 EUR /km, Monat & Jahr (Digital Download)
$5.99
-
Digital download
Contabilidad Excel por partida doble PGC Pymes | Spanish, Libro diario, mayor (Digital Download)
$6.99
-
Digital download
Urlaubsplaner Excel 2027 für Teams | Feiertage aller 16 Bundesländer, Resturlaub, Engpass-Warnung, Urlaubsantrag Word, Beispiel 2026
$5.59
-
Digital download
Buchhaltung Kleinunternehmer Excel 2026 | Umsatzgrenze § 19 UStG mit Prognose 2027, EÜR ohne USt-Spalten, Rechnung (Digital Download)
$8.69
-
Digital download
Inventarliste Vorlage Excel Firma und Haushalt | Inventur mit Restbuchwert zum Stichtag, Hausrat mit Neuwert je Raum (Digital Download)
$9.99
-
Digital download
Protokoll Vorlage Word, Ergebnisprotokoll + Mitgliederversammlung Verein | Beispiel und leer, Aufgabenliste mit Ampel, Abstimmung
$4.49
-
Digital download
Food Cost Excel Template: Restaurant Recipe Calculator
Sale Price $11.21
Original Price $14.95
-
Digital download
Restaurant Recipe Cost Calculator Spreadsheet | Excel Food Cost & Menu Pricing Template
$12.59
-
Digital download
Recipe Cost Calculator for Restaurant & Food | Main and Sub Recipes Costing, Profit Margin | Easy Spreadsheet Template Excel Google Sheets
$14.99
-
Digital download
Recipe Cost Calculator: Restaurant Menu Pricing Tool (Excel Workbook)
$14.05
-
Digital download
Pro Recipe Cost Calculator | Food Business Cost Control Tool | Ingredient Management | Editable Excel Template (Instant Download)
$12.59
-
Digital download
Restaurant Accounting Template, Restaurant Profit and Loss, Food Cost Calculator, Menu Costing, Bookkeeping Spreadsheet, Google Sheets Excel
Sale Price $7.50
Original Price $15.00
-
Digital download
Recipe Cost Calculator Food Cost Spreadsheet Bakery Cafe Pricing Tool Profit Margin Tracker Google Sheets Template For Small Business
Sale Price $7.97
Original Price $15.95
-
Digital download
Restaurant Food Cost Calculator Spreadsheet, Recipe Cost Card, Menu Costing | Excel Google Sheets
$22.00
-
Digital download
Food Cost Calculator Excel Template | Recipe Costing & Menu Pricing Spreadsheet | Food Expense Tracker
Sale Price $14.35
Original Price $20.50
-
Digital download
Recipe Cost Profit Calculator, Baking Ingredient Spreadsheet Home Baker Cake Costing Template Bakery Food Costs Excel Baking Pricing Tool
Sale Price $7.97
Original Price $15.95
-
Digital download
Excel Template Restaurant Order Guide and Inventory Sheet
$12.50
-
Digital download
Recipe Cost & Menu Pricing Calculator: Food Business Profit Margins (Digital Download)
$7.00
Shoppers with similar taste loved these
-
Digital download
Small Business Bookkeeping Spreadsheet Profit Loss Order Inventory Customer Client Invoice Tracker Pricing Calculator Excel Google Sheets
Sale Price $17.64
Original Price $29.40
-
Digital download
Small Business Bundle Google Sheets Bookkeeping Spreadsheet Inventory Tracker Order Tracker Product Pricing Calculator Tax Bill Calendar
$17.13
-
Digital download
Small Business Bundle Inventory Tracker Excel Pricing Calculator for Handmade Business Bookkeeping Spreadsheet Client Invoice Google Sheets
Sale Price $14.99
Original Price $29.98
-
Digital download
Printable Small Business Daily Planner, Craft Show Templates Bundle, Business Forms, Labels, Price List, Scan to Pay, Business Binder A4 PDF
Sale Price $0.96
Original Price $3.84
-
Digital download
Small Business Bundle Project Cost Spreadsheet Project Management Excel Client Invoice Bookkeeping Template Google Sheets Budget Tracker
Sale Price $19.99
Original Price $39.98
-
Digital download
Small Business Bundle Bookkeeping Spreadsheet Client Tracker CRM Excel Template Google Sheets Budget Tracker Pricing Calculator Freelancer
Sale Price $4.19
Original Price $13.98
-
Digital download
Small Business Bundle Bookkeeping Inventory Tracker Order Tracker Product Handmade Pricing Calculator Smart Bill Calendar Google Sheet Excel
Sale Price $14.96
Original Price $29.92
-
Digital download
Small Business Bundle Bookkeeping Inventory Tracker Order Tracker Product Handmade Pricing Calculator Smart Bill Calendar Google Sheet Excel
Sale Price $14.96
Original Price $29.92
-
Digital download
Small Business Spreadsheet Service Business Bookkeeping Tracker for Google Sheets Excel Invoice Tracker Client Tracker Order & Task Tracker
Sale Price $13.46
Original Price $26.93
-
Digital download
All-in-One Product Business Template Google Sheets & Excel – Complete Inventory Sales Management System (Rainbow)
Sale Price $15.17
Original Price $30.34
-
Digital download
Inventory Tracker Spreadsheet Small Business Inventory Template Google Sheets Excel Inventory Management Inventory Log List Order Tracker
Sale Price $5.95
Original Price $8.50
-
Digital download
Small Business Bundle Bookkeeping Business Social Media Planner Content Calendar Journal Project Management Client Tracker Google Sheets
Sale Price $7.49
Original Price $29.95