Printable Monthly Food Cost Sheet
This sheet is for restaurant owners, managers, caterers, and home food businesses that track actual food cost each month. It includes a one-page landscape table with columns for Month, Opening stock, Purchases, Closing stock, Food sales, Cost of food sold, and Food cost %. The sheet also shows the formula: Opening stock + purchases − closing stock = cost of food sold. Sample rows are laid out by month, such as Jan, Feb, and Mar.

Free printable · PDF
- 1 page
- US Letter, landscape — choose “Fit to page” for A4
- PDF, 63 KB
Free for personal, family and classroom use.
Need to edit it? The full pack has the editable Excel and Word files plus all 4 sheets — $7.00, one-time.
Your free PDF is downloading. Want all 4 sheets in one download, plus the editable Excel and Word files so you can change the text?
Instant download · 7-day refund · Secure checkout by Stripe
Fill in each month’s stock values, purchases, and food sales, then use the formula to calculate cost of food sold and food cost percentage. Keep the page with your monthly records so you can compare trends, spot rising food costs, and check that sales and inventory numbers match.
Good for
- Monthly restaurant food cost tracking
- Compare food cost percentage over time
- Record stock and purchases by month
Tip: Print in landscape on Letter paper and keep one copy for each month.
4 files · XLSX, PDF, DOCX
Get every sheet: Recipe Costing Workbook
This sheet plus 3 more in one download, with the editable Excel and Word files. Excel recipe costing workbook with ingredient price list, yield-adjusted recipe cards, menu pricing and food cost %, plus a monthly actual food cost calculator and yield test sheet.
$7.00 USD, one-time 4 files · about $1.75 each
- Instant download
- 7-day refund
- Secure checkout by Stripe
7-day money-back guarantee. Full refund within 7 days of purchase, even after you download.
More free printables
Printable Ingredient Price List2 pages · free PDF
Printable Recipe Cost CardTrack recipe ingredient costs by usable unit, amount used, and line cost on one letter-size recipe cost card.1 page · free PDF
Printable Yield Test SheetTrack yield test results with columns for date, ingredient, as purchased weight, usable weight, yield percent, and notes on one Letter page.1 page · free PDF