Report this item to Etsy

Restaurant Inventory Spreadsheet, Food Cost % Excel | Weekly Count Sheet, Par Levels, Recipe Costing, Waste Variance, Order List

Item highlights

  • Digital download
  • Digital file type(s): 3 Files
View more
Etsy's Purchase Protection

If something goes wrong with an order, we've got your back for all eligible purchases. View program terms

Price:$10.49

Loading

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 type
    Digital download
  • Digital file type(s)
    3 Files
Shop with confidence
Etsy Purchase Protection

If something goes wrong with an order, we've got your back on all eligible purchases. View program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 28, 2026