What is included
- Daily sales and expense records connect with a monthly P&L, budgets and unpaid-bill reporting.
- Ingredient and recipe records feed plate costing and menu-price comparisons.
- Foreign-currency bills use configured monthly exchange rates so reports remain in the base currency.
- Includes Google Sheets and Excel; live exchange-rate update buttons are Sheets-only, while Excel rates are entered manually.
Based on the Etsy listing reviewed October 28, 2026. Check the current listing for any later changes.
What to prepare
For the workflow this product is designed around, gather:
- Income and expense records for a defined period
- Recipe quantities and ingredient cost information
- The categories and menu items used in your records
A practical way to use your records
Keep period bookkeeping and individual recipe estimates clearly labeled so their totals answer the intended question. Review the source records behind profit and loss and update menu-cost inputs when prices change. Compare the preview with the scope of restaurant work you need to maintain.
A worked example
Fictional example: a restaurant compares period-level bookkeeping with the estimated food cost of one menu item.
- Period sales record
- $8,000 for the defined week
- Period food-cost record
- $2,400 for that same week
- Separate recipe estimate
- $3 ingredient cost for one defined portion
- Keep the reporting-period figures and the individual recipe estimate clearly labeled as different measurements.
- Review source records and dates before using the period ratio to investigate a change in the business.
Result: The stated period food-cost ratio is 30%: $2,400 ÷ $8,000. The $3 recipe estimate is a separate per-portion figure; neither value alone explains net profit or proves why actual period costs changed.
Fictional figures explain the workflow; they do not represent customer results or guarantee particular template fields. See the included features above and the current Etsy listing.
A closer look at Restaurant Accounting and Food Cost Spreadsheet for Google Sheets & Excel
Additional previews from this product's Etsy listing. Open any image for a larger view.
Questions about this product
Are food costs and menu costing included with accounting?
Yes. The product includes profit and loss, food-cost calculations and menu costing.
Is this the seven-template restaurant bundle?
No. This is a separate restaurant accounting listing. Check the bundle's current Etsy contents if you need several individual restaurant tools.
Which spreadsheet formats are listed?
This product is described for Google Sheets and Excel. Confirm the included files, software requirements and delivery instructions on its current Etsy listing.
