Written by: JJ Tan, Founder, Jelly

Key Takeaways

  • A simple food cost Excel template needs three tabs (Ingredient Master, Recipe Sheet, Summary) and five core formulas to calculate cost per unit, line item cost, total recipe cost, cost per serving and recommended menu price.
  • UK operators must handle 20% VAT correctly by stripping it from the menu price before calculating GP%. Most free templates skip this and overstate margins by around 5.5 percentage points.
  • The worked pub main example shows how to apply yield percentages, batch costing and target GP% to reach a VAT-inclusive menu price while keeping gross profit accurate.
  • Spreadsheets become a bottleneck once suppliers reprice weekly, multiple sites are involved or manual data entry exceeds 10–20 hours per week. At that point, automation is required.
  • Jelly automates invoice capture, flags supplier price changes in real time and keeps dish-level GP live through POS integrations at a flat £129/month per location.

See Jelly In Action For Your Kitchen

How The Simple Food Cost Excel Template Works

The workbook is a single file with exactly three tabs, and data flows one way through them. Prices enter once in the Ingredient Master, feed the Recipe Sheet and roll up into the Summary. The same layout works in Google Sheets with identical formulas.

Tab 1 — Ingredient Master. Use one row per ingredient. Add columns for supplier name, pack size, pack price (ex-VAT), unit of measure and a calculated cost-per-unit column. Every recipe tab draws its prices from here, so a single price update flows through automatically.

Tab 2 — Recipe Sheet. Use one sheet per dish, or one sheet with a dropdown to select the dish. Add columns for ingredient name (linked to the Ingredient Master), quantity used, yield or wastage percentage and the resulting line item cost. A yield column is essential. Omitting it understates true food cost by 10–20% on most proteins and produce.

Tab 3 — Summary And Pricing. Pull the total recipe cost from Tab 2, divide by portions to give cost per serving, accept a VAT-exclusive selling price and return GP%. This is where you set your target margin and read the recommended menu price.

Use £ and metric units throughout. Enter all purchase prices excluding VAT if you are VAT-registered, because input VAT is reclaimable and does not form part of your cost. For a deeper walkthrough of building the file from scratch, see How To Create A Food Cost Spreadsheet For UK Kitchens.

Core Formulas For Your Food Cost Excel Template

Five formulas do all the work:

  1. Cost per Unit = pack price ÷ pack quantity
  2. Line Item Cost = quantity used × cost per unit
  3. Total Recipe Cost = sum of all line item costs
  4. Cost per Serving = total recipe cost ÷ number of portions
  5. Recommended Menu Price = cost per serving ÷ (1 − target GP%), then multiply by 1.2 to add VAT

Each formula maps to one column or cell in the workbook. Cost per Unit lives in the Ingredient Master and every recipe row references it. Line Item Cost is calculated on the Recipe Sheet for each ingredient row. Total Recipe Cost sums those rows. Cost per Serving divides the total by the batch yield.

Recommended Menu Price works backwards from your target GP to give a VAT-inclusive price to put on the menu. Round it to a sensible price point, then recheck the GP.

The only formula that requires care is Recommended Menu Price. Dividing cost per serving by (1 − target GP%) gives the ex-VAT net price. Multiplying by 1.2 adds standard-rate VAT. If the item is zero-rated cold takeaway, skip the ×1.2 step. The full Recipe Costing Excel Tutorial shows each formula entered cell by cell.

Handling VAT In A UK Food Cost Template

VAT must sit outside your margin calculation for the numbers to mean anything. HMRC’s Tax Confident guidance for hospitality confirms that the standard 20% VAT rate applies to all food and drink consumed on the premises and to hot takeaway food. VAT collected from customers is passed to HMRC and is not part of your margin, so GP must be measured on the ex-VAT selling price.

The arithmetic in the template:

  • Selling price ex-VAT = menu price ÷ 1.2
  • GP% = (selling price ex-VAT − cost per serving) ÷ selling price ex-VAT

Measuring GP against the VAT-inclusive menu price overstates it by around 5.5 percentage points. That gap matters when you are trying to hit a target margin.

Many free downloads are US-centric, with dollars, lbs and no VAT. They do not suit a country where the same sandwich can carry two different VAT treatments depending on whether it is eaten in or taken away cold. On a £6.50 chicken ciabatta, the difference between a cold takeaway sale (zero-rated, 75.2% GP) and the same sandwich eaten in (standard-rated, 70.3% GP) is five margin points worth £1.08 per sale.

For delivery menus, treat the platform commission as an additional cost line before calculating GP, because it reduces the net revenue you actually receive. HMRC Revenue and Customs Brief 5 (2026) also demonstrates that VAT rates can change for narrowly defined categories, so keep the VAT rate in an editable cell rather than hard-coding 20%.

With VAT logic in place, you can see the full costing process on a single dish.

Worked UK Example: Costing A Braised Lamb Pub Main

The dish is a braised lamb shoulder with roasted root vegetables and mash, serving one portion from a batch of four.

Ingredient Master entries (all prices ex-VAT):

  • Lamb shoulder: £18.00 for a 2kg pack → £9.00/kg
  • Carrots: £1.20 for a 1kg bag → £1.20/kg
  • Parsnips: priced per kilo from your supplier’s current invoice
  • Potatoes: £2.35 for a 2.5kg bag → £0.94/kg
  • Butter: £3.60 for a 500g block → £7.20/kg
  • Lamb stock (house-made sub-recipe): costed from the bones and vegetables used, entered as a per-portion sub-recipe

Recipe Sheet quantities per batch of four portions, with 80% yield applied to the lamb:

  • Lamb shoulder 1,000g used → 800g usable → effective cost: 1,000g × £9.00/kg = £9.00
  • Carrots 400g → £0.48
  • Parsnips 300g → costed at your current per-kilo price
  • Potatoes 800g → £0.75
  • Butter 120g → £0.86
  • Lamb stock 500ml → costed from the sub-recipe

Total Recipe Cost equals the sum of all line item costs. For this lamb batch, assume the total comes to £X across four portions. Cost per Serving then equals £X ÷ 4, which gives £Y per portion.

Target GP is 68%. Recommended net price equals cost per serving ÷ (1 − 0.68). Menu price with VAT equals that net price × 1.2, rounded to a sensible price point. Recheck by taking the ex-VAT selling price as menu price ÷ 1.2, then calculate GP%.

GP% = (£9.17 − £2.94) ÷ £9.17 = 67.9%. The £9.17 is the £11.00 menu price net of 20% VAT. These figures are illustrative. For context, the UKHospitality × Christie & Co Benchmarking Report 2022 found survey-wide food GP of 67%.

Step-By-Step: Building Your Food Cost Spreadsheet In Excel

The build sequence takes under ten minutes:

  1. Create three tabs: Ingredient Master, Recipe Sheet, Summary.
  2. In Ingredient Master, add columns for Supplier, Ingredient, Pack Size, Pack Price (ex-VAT), Unit and Cost per Unit (= Pack Price ÷ Pack Size).
  3. In Recipe Sheet, add columns for Ingredient (linked to Ingredient Master), Quantity Used, Yield %, and Line Item Cost (= Quantity Used × Cost per Unit ÷ Yield %).
  4. In Summary, pull Total Recipe Cost (= SUM of Line Item Costs), enter Portions, calculate Cost per Serving, enter your VAT rate (default 0.2) and target GP%, and display Recommended Menu Price.
  5. Enter five or six ingredients, build one recipe, set your target GP% and read the output.

For a step-by-step cell-level tutorial, see Recipe Costing Excel Tutorial: Build a Working Spreadsheet. The same three tabs and five formulas work unchanged in Google Sheets. For a broader set of template options, see Free Restaurant Costing Template for Excel (UK Guide).

Talk To Us About Automating Your Food Costing

When A Food Cost Spreadsheet Stops Being Enough

A spreadsheet works well for a single site with a short, stable menu and one person maintaining costs. Its advantages are zero cost, immediate start-up, total format flexibility and offline access. Excel works fine until the conditions that make it work stop applying.

The signs that the spreadsheet has become the bottleneck:

At that point, Jelly is the best food cost management solution for UK operators. Jelly starts where the spreadsheet breaks down. It automates invoice capture via photo or email, so every line item, including quantity, SKU and price, lands in the system without manual entry. That constant flow of invoice data powers the Price Alert feature, which flags every supplier price increase or decrease the moment a new invoice arrives and gives chefs concrete evidence to negotiate credits or switch suppliers.

Because ingredient costs update with every invoice, dish-level GP stays live and a red percentage appears when a dish drops below target margin. Jelly integrates in real time with Square, Lightspeed, EPOS Now and Toast, delivering item-level sales mix and GP without any manual export. Xero integration handles payables. The flat rate is £129/month per location with no per-user charge.

Jelly users cut food costs by 3% on average in the first three months, and their gross margins increase on average by 2 percentage points in the same period. Costing a menu item drops from around 28 minutes in a spreadsheet to around 3 minutes in Jelly. One operator improved gross profit from 65% to 72% within 12 weeks on approximately £500,000 in revenue. Amber restaurant in East London saves £3,000–£4,000 per month through credits, better buying and tighter menu controls.

For operators who prefer to stay in spreadsheets, Unilever Food Solutions’ free food cost calculator is a downloadable Excel template that requires manual entry of ingredient, utility and delivery costs; like other standalone spreadsheet-based costing tools, it does not automatically update when supplier prices change and cannot manage recipes across multiple sites. For a direct comparison of Excel’s structural limitations, see Is Excel Effective For Restaurant Food Cost Tracking?

See How Jelly Keeps Your GP Live

Frequently Asked Questions

Is There A Free PDF Version Of The Simple Food Cost Excel Template?

A PDF can only serve as a printed reference. It cannot run formulas, update prices or calculate GP. The workbook described in this guide is built for Excel or Google Sheets so the five formulas stay live. Print a completed sheet for kitchen reference if needed, but keep the working file in spreadsheet format.

Can I Use It In Google Sheets?

Yes. The three-tab structure and all five formulas, Cost per Unit, Line Item Cost, Total Recipe Cost, Cost per Serving and Recommended Menu Price, work in Google Sheets without modification. Google Sheets also allows multiple users to view the file simultaneously, though concurrent editing by more than one person still risks formula corruption if cells are not protected.

How Often Should I Update It?

Update the Ingredient Master every time a supplier invoice shows a price change. Run a full price audit at minimum once a month, and date-stamp each update so you can see at a glance how current the data is. Stale prices are the most common source of inaccurate food cost data and often create false confidence instead of useful insight.

Does It Handle VAT?

Yes. As covered above, strip the 20% standard rate from the menu price before calculating GP, and keep the rate in an editable cell so a change does not break the workbook.

Conclusion

A simple food cost Excel template with three tabs, five formulas and correct VAT handling gives a strong starting point for a single-site UK operator getting control of dish costs. Build it using the structure above, or follow the Recipe Costing Excel Tutorial for a cell-by-cell walkthrough.

When supplier complexity, price volatility or multi-site growth make the spreadsheet unmanageable, Jelly becomes the best food cost management solution for UK restaurants, pubs and hotels. It automates invoice capture, surfaces price alerts and keeps dish-level GP live at a flat £129/month per location. If you recognise the graduation signs, the next step is a conversation.

Chat With Jelly About Your Food Costs