Recipe Costing Sheet spreadsheet for Excel and Google Sheets
Recipe Costing Sheet – dashboard
Recipe Costing Sheet – recipe card
Recipe Costing Sheet – dishes
Recipe Costing Sheet – allergens
Recipe Costing Sheet – ingredients
Recipe Costing Sheet – whats included

Recipe Costing Sheet — Menu GP & Allergen Matrix Spreadsheet for Restaurants & Cafés

£29.99

Build your hospitality bundle

Tick the sheets you want. The discount is worked out here and added in your basket automatically.

Any 3 – 15% offAny 5 – 25% off10 or more – 40% off
  • £29.99
  • £29.99
  • £29.99
  • £29.99
  • £24.99
  • £24.99
  • £24.99
  • £19.99
  • £19.99
  • £19.99
  • £19.99

Know exactly what every dish costs to make and how much you keep. Type in your ingredients with their pack sizes and prices, then add each dish line by line. Works in Excel & Google Sheets. No macros, no subscription. Instant download: blank sheet, filled-in DEMO and a full PDF guide.

Digital download, available immediately. By buying, including with Google Pay or Amazon Pay, you agree to immediate access and that your 14-day right to cancel ends once your download is available. See our Terms and Refund Policy.

Category:
RestaurantsPubsCafésBarsHotelsTea roomsGastropubsBistrosTakeawaysFood trucks
Instant downloadLink straight after checkout and by email
Excel or Google SheetsMac, PC, Chromebook. No macros
Start Here guide built inPlain-English steps for every tab
Secure checkoutCard, Apple Pay and Google Pay

Sound familiar?

Busy every service. Nobody has time to cost the menu.

  • Menu prices set on a hunch
  • Supplier prices creep up and the GP quietly drops
  • Allergen info in three different notebooks
  • No idea which dish actually makes the money

That’s not a you problem. It’s a missing-system problem.

Why chefs love it

Cost an ingredient once. Every dish updates.

  • Cost per portion and GP % for every dish
  • Target GP check on every line
  • Printable recipe cards for the kitchen
  • 14-allergen matrix built from your recipes
  • Spoons, cups and pinches converted for you
  • VAT handled whether your prices include it or not

Where the money goes

A £14 dish. What does it really make?

Example figures for illustration: a main at £14 including VAT.

£11.67Price after 20% VAT
£3.85Ingredient cost
67%Gross profit
£1,560

A year from one dish that’s 50p too cheap, selling 60 a week

vs
£29.99

The sheet, once, to keep

Fix one underpriced dish and it pays for itself many times over. Buy now, instant download

How it fits together

Type ingredient prices once. The rest updates itself.

  1. IngredientsPack size and price
  2. Recipe linesAmounts for each dish
  3. DishesCost per portion and GP %
  4. Recipe cardPrint one for any dish
  5. AllergensMatrix built for you
Recipe costing dashboard with average GP %

The dashboard

Know your GP before service.

Average gross profit, your target, and your best and weakest dishes.

Dishes200Costed automatically
Ingredients500Prices and allergens
Allergens14Plus 5 of your own
Monthly fees£0One payment, yours to keep

What’s inside

9 tabs, one file. Click through them.

Dashboard

Dishes on the menu, average GP %, your target, and the best and weakest dishes.

Printable recipe card with cost and allergens

Recipe card

A costing card for any dish.

  • Cost per portion and profit
  • GP % against your target
  • What the dish contains
Allergen matrix built from recipes

Allergens

All 14 allergens, filled in for you.

  • Tick allergens once per ingredient
  • Every dish against every allergen
  • Up to 5 extra items, e.g. garlic

Before and after

From guessing to knowing.

Without it

  • Prices set on a hunch
  • GP worked out on a calculator
  • Allergens kept from memory
  • Price rises spotted too late

With the sheet

  • Cost per portion for every dish
  • GP % checked against your target
  • An allergen matrix built for you
  • Change a price once and every dish updates

What you get

Everything in one download.

The recipe costing workbookReady for your menu
A filled-in DEMO copySee it working before you add your own
Full PDF user guideSet-up, every tab and the rules explained
Colour themesPick one to match your venue
Works everywhereExcel or Google Sheets, Mac or PC
Help if you’re stuckMessage me any time and I’ll help you set up

Up and running before service

Four steps.

  1. Buy and downloadThe link arrives straight away
  2. Open itIn Excel, or upload it to Google Sheets
  3. Check the DEMO and guideThen fill in your blank copy
  4. Start using itEverything else works itself out

Made for

  • Independent restaurants, pubs, cafés and hotels in the UK
  • Owners, managers and head chefs who do the admin themselves
  • Anyone who’d rather not pay monthly for software

Not for

  • Nutrition or calorie labelling
  • Running a till or EPOS
  • Large chains with their own systems

A record-keeping spreadsheet, not legal, tax or accounting advice. You are responsible for the allergen information you give customers; always check supplier labels.

Before you buy

Questions

Does it work out GP with or without VAT?

Both are covered. In Settings, tell it whether your menu prices include VAT and set the VAT rate (20% by default). GP and food cost % are worked out on the price after VAT is taken off.

Does it include the 14 allergens?

Yes. The Ingredients tab has a column for each of the 14 allergens, plus up to 5 extra items of your own. Tick them once per ingredient and the Allergen Matrix and Recipe Cards fill in from your recipes. Always check supplier labels; you are responsible for the allergen information you give customers.

What happens when a supplier puts prices up?

Change the pack price once on the Ingredients tab and every dish that uses it is recosted straight away.

Do I need Microsoft Excel?

No. It works in Microsoft Excel, or free in Google Sheets.

Is it a subscription?

No. It is a one-off payment and the file is yours to keep. There are no monthly fees.

I'm not good with spreadsheets. Is this for me?

Yes. You type into the yellow boxes and everything else works itself out. There are no formulas to write, and the How to use tab walks you through it.

Can I see it before I buy?

Yes. Look through the screenshots above. Your download includes a filled-in DEMO copy and a full PDF guide as well as the blank spreadsheet, so you can see exactly how it works before adding your own.

Does it work on a Mac, iPad or phone?

Yes on a Mac: use Excel for Mac, or open it free in Google Sheets in your web browser. On an iPad or phone you can open it in the free Excel or Google Sheets app, but a computer is easier for setting it up.

Can I get a refund?

Because it is an instant digital download, I can’t offer a refund once the file has been downloaded. If the file is faulty and I can’t fix it, you were charged twice, or you received the wrong product, I will put it right or refund you. See the Refund Policy. This doesn’t affect your statutory rights.

How do I get my file?

It is an instant digital download. You will get a download link straight after checkout, and by email.

What if I get stuck?

Message me any time and I will help you get set up.

Ready when you are

Price every dish with confidence.

£29.99 once. Download it tonight and cost your menu tomorrow.

Buy now, instant download

More spreadsheets for restaurants, pubs & cafés →

Full product details, tabs list and notes

Description

Sound familiar?

  • You set menu prices by gut feel and hope the GP works out.
  • Supplier prices go up and you only notice when the margins have already gone.
  • Allergen information is scattered across notebooks, labels and memory.

What the Recipe Costing Sheet does

Type in your ingredients with their pack sizes and prices, then add each dish line by line. It works out the cost per portion, profit per portion and gross profit % (ex-VAT) for every dish, compares each one with your target GP, prints a recipe card for any dish and builds a 14-allergen matrix from the allergens you tick against each ingredient.

What’s inside

  • How to use – step-by-step instructions and what the colours mean
  • Settings – your business name, lists for the drop-downs and a colour theme picker
  • Dashboard – dishes on the menu, average GP %, your target, and the best and weakest dishes
  • Ingredients – pack size, pack price and cost per g, ml or each, with the 14 allergens plus up to 5 of your own (e.g. garlic, onion, chilli)
  • Measures – teaspoons, tablespoons, cups and pinches converted for you
  • Dishes – up to 200 dishes with portions, menu price, cost per portion, profit and food cost %
  • Recipe Lines – pick a dish, then add each ingredient on its own row
  • Recipe Card – a printable costing card for any dish, showing what it contains
  • Allergen Matrix – every dish against every allergen, filled in automatically

Format

  • Your blank spreadsheet (.xlsx, UK edition), ready for your business
  • A filled-in DEMO copy, so you can see every tab working before you start
  • A full PDF user guide: set-up, every tab explained, a daily routine, the rules that apply and answers to common questions
  • Works in Microsoft Excel (Windows and Mac) and Google Sheets
  • No macros, nothing to install, no subscription
  • Yellow boxes are for you to fill in; pale green boxes work themselves out

How it works

  1. Buy and download the file straight away.
  2. Open it in Excel, or upload it to Google Sheets.
  3. Open the DEMO and the PDF guide to see how it works, then fill in Settings on your blank copy and start typing your own.

Please note

This is a digital product — nothing will be posted. It is a record-keeping template, not legal, tax or food safety advice. For use in your own business only — please don’t resell or share the file.

Questions before you buy? Message me any time — happy to help!

Recipe Costing Sheet FAQ

Does it work out GP with or without VAT?

Both are covered. In Settings, tell it whether your menu prices include VAT and set the VAT rate (20% by default). GP and food cost % are worked out on the price after VAT is taken off.

Does it include the 14 allergens?

Yes. The Ingredients tab has a column for each of the 14 allergens, plus up to 5 extra items of your own. Tick them once per ingredient and the Allergen Matrix and Recipe Cards fill in from your recipes. Always check supplier labels; you are responsible for the allergen information you give customers.

What happens when a supplier puts prices up?

Change the pack price once on the Ingredients tab and every dish that uses it is recosted straight away.

Do I need Microsoft Excel?

No. It works in Microsoft Excel, or free in Google Sheets.

Is it a subscription?

No. It is a one-off payment and the file is yours to keep. There are no monthly fees.

I'm not good with spreadsheets. Is this for me?

Yes. You type into the yellow boxes and everything else works itself out. There are no formulas to write, and the How to use tab walks you through it.

Can I see it before I buy?

Yes. Look through the screenshots above. Your download includes a filled-in DEMO copy and a full PDF guide as well as the blank spreadsheet, so you can see exactly how it works before adding your own.

Does it work on a Mac, iPad or phone?

Yes on a Mac: use Excel for Mac, or open it free in Google Sheets in your web browser. On an iPad or phone you can open it in the free Excel or Google Sheets app, but a computer is easier for setting it up.

Can I get a refund?

Because it is an instant digital download, I can’t offer a refund once the file has been downloaded. If the file is faulty and I can’t fix it, you were charged twice, or you received the wrong product, I will put it right or refund you. See the Refund Policy. This doesn’t affect your statutory rights.

How do I get my file?

It is an instant digital download. You will get a download link straight after checkout, and by email.

What if I get stuck?

Message me any time and I will help you get set up.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Related products