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.
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.
Printable Ingredient Price List
Printable Recipe Cost Card
Printable Yield Test Sheet