Restaurant Inventory & Food Cost Tracker

KNOW YOUR REAL FOOD COST. EVERY WEEK.

WHY THIS ONE

• Your real food cost, not a guess: start inventory + purchases - end inventory, divided by sales, every week. Food and beverage separately, against your own targets.
• Everything in one file: items, vendors, weekly counts, deliveries, sales, waste, par levels and a printable order guide. No add-ons to buy.
• Built for real use: gray cells are the only place you type, and formulas are protected so nothing breaks.
• Buy once: no subscription, no app, no monthly fee.

For restaurants, diners, food trucks, cafes, bars and caterers who want to know where the money goes between deliveries.

WHAT IT DOES

• Items: category (protein, produce, dairy, beer, wine, liquor, paper...), storage area, vendor, count unit and cost. Type a par level, or how much you use per week and the par figures itself from your vendor's delivery schedule plus a safety buffer.
• Counts: one column per count date (up to 53). On hand, TO ORDER and order $ fill in from your last count.
• Purchases: every delivery by vendor and invoice. Log by item or by category for a mixed invoice. PRICE UP flags when an item costs more than you have on file.
• Sales and Waste: weekly (or daily) food and beverage sales from your POS; waste with reasons and cost.
• Weekly Food Cost: food cost $ and %, beverage cost $ and %, supplies and waste for every period, rated ON TARGET, A LITTLE HIGH or HIGH. CHECK COUNTS flags a period that doesn't add up.
• Order Guide: pick a vendor and print exactly what to order to get back to par, with an estimated total.
• Overview dashboard: food cost %, inventory on hand, what to order now, and cost of goods by week.
• A Start Here tab with step-by-step instructions.

WHAT THIS IS NOT (no surprises)

• Not a POS: you type your sales totals from your POS report.
• Not a recipe or plate costing tool (that's our Menu Costing calculator).
• Counts are valued at the cost you have on file for each item: update costs when prices change.

Works In: Google Sheets (free Google account) on a computer or phone, AND Microsoft Excel: a tested Excel version (.xlsx) is included for Excel 365, Excel 2021 or newer, and free Excel for the web.

What You Get: a PDF with a link to make your own copy in your Google Drive, plus a download link for the Excel version. Digital product.

Great for: Restaurant Inventory, Food Cost Tracker, Inventory Sheet, Par Level, Order Guide, Food Truck, Bar Inventory, Restaurant Owner, Kitchen Manager, Cafe Business, Food Cost Percent, Small Business, Google Sheets