BdtdkFood Cost Calculator

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.

Preview of Printable Monthly Food Cost Sheet

Free printable · PDF

  • 1 page
  • US Letter, landscape — choose “Fit to page” for A4
  • PDF, 63 KB
Download free PDF

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.

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

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

7-day money-back guarantee. Full refund within 7 days of purchase, even after you download.

More free printables

Preview of Printable Ingredient Price ListPrintable Ingredient Price List2 pages · free PDFPreview of Printable Recipe Cost CardPrintable Recipe Cost CardTrack recipe ingredient costs by usable unit, amount used, and line cost on one letter-size recipe cost card.1 page · free PDFPreview of Printable Yield Test SheetPrintable 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