Skip to content

Menu Costing Template: Food Cost and Profit by Item

A free menu costing template: each item's portion cost, price and food cost percentage, what it leaves, what it earns in a week, and the price at your target.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 19, 2026 · 5 min read

A menu costing template lines up every item you sell with three numbers: what one portion costs you, what you charge, and how many you sell in a week. From those it works out the food cost percentage (cost over price), the dollars each sale leaves, and the dollars each item leaves in a week. The percentage tells you which items are priced thin. The weekly dollars tell you which ones pay the rent. They're often not the same items, and you need both to decide anything. The template below does the arithmetic; six items from a made-up café are filled in.

The short version

  • Portion cost: everything on the plate or in the cup, packaging included.
  • Food cost % = portion cost ÷ menu price.
  • Left an item = price less cost. Left a week = that, times what you sell.
  • Don't judge an item by its percentage alone.
  • TaroStack keeps each portion cost current from your recipes and what you pay. More below.

An example: six best sellers

Menu item Portion cost Price Food cost Left an item Sold a week Left a week
Breakfast burrito $2.85 $9.50 30.0% $6.65 140 $931.00
Avocado toast $2.10 $8.00 26.3% $5.90 90 $531.00
Turkey club $4.40 $12.00 36.7% $7.60 110 $836.00
Soup, cup $1.15 $5.00 23.0% $3.85 75 $288.75
Cookie $0.62 $3.00 20.7% $2.38 160 $380.80
Cold brew, 16 oz $0.85 $4.50 18.9% $3.65 210 $766.50

What the table says

The turkey club has the worst percentage and the best dollars per sale. At 36.7% it's over the café's 30% target, and a rule-follower would cut it or shrink it. But each one leaves $7.60, more than anything else on the menu, and it's the second-biggest earner of the week at $836. The template's last column says the price that would hit 30% is $14.67. A move to $12.75 is more realistic, and brings it to 34.5%.

The cookie has a lovely percentage and earns the least per sale. 20.7%, $2.38 each. It's there to be added to an order, and it does that 160 times a week. Leave it alone.

Cold brew is the quiet winner. 18.9% and $766.50 a week, for a product made in one batch on Monday.

A "good" food cost percentage depends on what else the price has to cover; a counter-service café and a food truck aren't the same. The ranges are in what is a good food cost percentage.

Where portion costs come from

The template takes the portion cost as a number you type. It comes from costing each recipe: every ingredient's amount times what you pay, plus the wrap, the cup or the box. For the burrito:

Tortilla $0.28
Eggs, two $0.60
Sausage, 2 oz $0.74
Cheese, 1 oz $0.36
Potatoes, salsa $0.55
Foil and napkin $0.32
Portion cost $2.85

The method for a plate is in plate cost formula, and for a batch recipe like the soup in steps in recipe costing.

Get the template

Download the menu costing template. The menu sheet with every column worked out, a sheet for your target food cost, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.

Where this stops working

A menu costing is true on the day you do it. Eggs go up, the sausage supplier changes the case size, and the $2.85 is now $3.20 without anyone having typed it. Most kitchens cost the menu once a year, in January, and price on stale numbers for the other eleven months.

How TaroStack does it

TaroStack keeps the portion costs moving with your invoices.

Each menu item is a recipe. Tortilla, eggs, sausage, cheese, foil. Its cost is worked out from the stock you hold, at what you paid for it.

Receiving updates the cost. Record the delivery, or photograph the invoice, and every recipe that uses eggs shows the new cost that day.

Batch items are sub-recipes. Soup, salsa and cold brew are made in batches and used by the portion. The batch's real yield sets the portion's cost.

Price creep, by supplier. A report shows which suppliers' prices have risen and by how much, so the conversation happens before the margin's gone.

Margins by product. What each item left, on what it cost in the month it sold.

The job Template In TaroStack
Portion cost Typed, once a year From recipes and deliveries
Eggs went up Re-cost every egg item Updates across recipes
Soup by the cup Estimate the yield From the batch's real yield
Which supplier is creeping Dig through invoices A report

Recipes, batches and true cost are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.

Questions people also ask

How do you cost a menu?

Cost one portion of every item from its recipe, divide by the menu price for the food cost percentage, and multiply what each sale leaves by how many you sell.

What is the formula for menu price from food cost?

Portion cost divided by your target food cost percentage. A $4.40 portion at a 30% target is $14.67.

Should I remove items with a high food cost?

Not on the percentage alone. Look at the dollars each one leaves and how many you sell.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.