Kitchen FiguresTry it

For restaurants, cafés and takeaways

Recipe Costing Calculator

An editable spreadsheet that calculates food cost and gross profit for your dishes and batches. Spend less time on calculations and price your dishes with confidence. Your recipes appear automatically in one menu overview.

See how it works

$19 USD · One-time payment · XLSX download

Actual Cheeseburger example in the editable workbook, showing ingredient quantities and separate dine-in and takeaway costs and gross profit.Dine-in detail: USD 1.12 food cost per portion and USD 2.33 gross profit.
Actual workbook · Cheeseburger example
Buy now · $19

What you receive

Your own workbook.
Your whole menu.

An editable XLSX file that’s easy to follow, with clear input areas and worked examples. Add your dishes with the calculations already in place.

50
portion recipe spaces
25
prepared batch spaces
100
purchased ingredient spaces
50
packaging item spaces
  • 20 food lines and 5 packaging lines per recipe
  • Menu overview with separate service results
  • 14 currency displays, plus metric and US units
  • Editable examples and instructions in the file

Recipe Costing Calculator

Editable XLSX workbook

$19USD

One-time payment. No subscription.

Buy now · $19

Stripe checkout. Download after payment.

Applicable tax is calculated at checkout.

Requires desktop spreadsheet software supporting XLSX formulas and dropdowns. Google Sheets and mobile apps have not been verified.

Licensed for one business, including its staff and branches. You may edit, extend and back up your copy.

Single portions

Cost any dish
on your menu.

A burger. A roast chicken dinner. A bowl of pasta. Add the ingredients used in one portion and see what that dish costs to make.

Burgers · Roast dinners · Pasta
Breakfasts · Desserts

Enter purchase prices once and reuse them across your recipes. When a supplier price changes, update it in the ingredient list and the linked recipe costs recalculate automatically.

Actual ingredient list with purchase quantities, units and prices.
Shared ingredient prices · Actual workbook
Try the burger recipe
Actual cheeseburger ingredient lines: 75 g minced beef costs USD 0.63, plus a bun, cheese and ketchup.
Cheeseburger ingredients · Actual workbook
Actual dine-in result: USD 1.12 food cost per portion and USD 2.33 gross profit.
The included example: $1.12 food cost per portion.

Live recipe costing

Try a complete
burger recipe.

Change the quantities or prices in this cheeseburger example. The full food cost, takeaway cost and gross profit update as you type.

Cheeseburger

One burger · Editable worked example

Change an ingredient price or quantity, then adjust the selling prices and packaging below.

Minced beef
Line cost$0.63
Burger bun
Line cost$0.30
American cheese
Line cost$0.15
Ketchup
Line cost$0.044

Illustrative figures. Purchase prices are shown per kg, bun or slice. An empty takeaway price uses the dine-in price.

Food cost per burger

$1.12
Food cost % · dine-in
32.6%
Dine-in gross profit
$2.33
Takeaway packaging
$0.12
Food + packaging
$1.24
Takeaway gross profit
$2.21

Gross profit is before labour, overheads and delivery fees.

Buy now · $19
Included House burger sauce example, with total batch cost USD 3.07 and displayed unit cost USD 0.0034 per gram.
House burger sauce · 900 g finished batch

One included example. Use the same approach for the batches you prepare.

Prepared batches

Soups, stews
and sauces.

Cost the whole batch using its finished quantity, then include the amount you serve in each dish.

Soups · Stews · Curries
Sauces · Dressings

See the batch total and its cost per base unit. That prepared batch can then be selected as an ingredient in your portion recipes.

See what’s included

Dine-in & takeaway

Include your
takeaway packaging.

Keep packaging separate from food, with its own price list and quantities for each takeaway portion.

Compare dine-in and takeaway gross profit, then set prices that account for the food and packaging used in each order.

Buy now · $19
Actual packaging section. One example burger box has USD 0.12 item cost and line cost.
One example burger box per portion · $0.12

A few useful details

Before you buy.

Software, your download and business use.

Buy now · $19
What do I receive?

One editable XLSX workbook with ingredient and packaging price lists, 50 portion recipe spaces, 25 prepared batch spaces and a menu overview. Worked examples and instructions are included in the same file, ready to edit.

What software do I need?

Use a computer with desktop spreadsheet software that supports XLSX formulas and dropdowns. Google Sheets and mobile spreadsheet apps have not been verified. This is a downloadable spreadsheet, with no software subscription.

What does gross profit include?

Recipe gross profit is the selling price minus food cost, with packaging also deducted for takeaway. It is before labour, rent, other overheads and delivery fees. Enter selling prices excluding tax you collect.

Can I use my currency and measurement units?

Yes. Choose from 14 currency display options and metric or US measurements, including grams, kilograms, ounces and pounds. Currency selection changes the display. It does not convert exchange rates.

How do I get my download?

After Stripe confirms payment, the download opens on this site in the browser you used for checkout. You can download again in that same browser for seven days. Save the workbook and a backup on your computer; your saved copy remains yours to use under the licence.

Can my team use and edit it?

Yes. The purchase is licensed for internal use by one business, including its staff and branches. You may edit, extend and back up the workbook. The template may not be resold, published or distributed outside your business.