FREE TEMPLATE
Food Cost Template: Free Weekly Food Cost % Tracker (Excel, CSV, Printable)
Free food cost template: a weekly food cost % tracker for Excel or Google Sheets with working formulas, plus CSV and a printable sheet. No signup.
Download Excel (.xlsx) Download CSV (Google Sheets) Printable version
Free. No signup, no email. The Excel file has working formulas and opens in Google Sheets, Numbers and LibreOffice.
How to use the weekly food cost % tracker template
- Take your opening inventory value at the start of the week and your closing count at the end.
- Enter purchases (all food invoices received that week) and food sales from your POS.
- The sheet works out food cost = opening + purchases - closing, then food cost % = food cost / food sales, and shows how far you are from your target.
- Keep one row per week to spot drift early; the total row gives your period food cost %.
Or calculate it right here
Same formula, live in your browser: Food Cost Percentage Calculator.
Formula
COGS = beginning inventory + purchases − ending inventory; food cost % = COGS ÷ food sales × 100.