What a Recipe Costing Template Actually Covers
A recipe costing template is a structured document — usually a spreadsheet — that lists every ingredient in a dish, the quantity used per portion, the unit cost of that ingredient, and the resulting cost per plate. It also captures your menu price so you can calculate the food cost percentage for that item.
The core formula is straightforward:
> Food Cost % = (Total Ingredient Cost ÷ Menu Price) × 100
Most full-service restaurants target a food cost percentage between 28–35%, depending on concept and segment.
The Exact Fields to Include
A reliable recipe costing template should capture:
- Ingredient name — e.g., 8 oz salmon fillet
- Unit of measure — oz, lb, cup, each
- Quantity per portion — exactly what goes into one plate
- Price per unit — pulled from your most recent invoice
- Extended cost — quantity × price per unit
- Total recipe cost — sum of all extended costs
- Menu selling price
- Food cost % — calculated automatically
- Target food cost % — your internal benchmark
- Variance — how far off you are from target
Why It Matters to Your Margins
A single mispriced dish — say, a salmon entrée costing $14 sold at $36 — hits a 38.9% food cost, nearly four points above a 35% target. Across 80 covers a night, that silent margin leak adds up fast. Spreadsheet templates help, but they go stale the moment your salmon supplier raises prices.
How Hubstaurant Replaces the Spreadsheet
Hubstaurant reads your vendor invoices automatically and tracks price per ingredient in real time. When your broadliner changes the cost of an item, your recipe costs update without any manual re-entry. Food-cost analytics then surface which menu items are drifting above their target percentage — so you can reprice, respec, or renegotiate before the damage compounds.
Spreadsheet templates like a well-built Google Sheet are genuinely useful starting points, and many operators swear by them early on. The limitation is that they require disciplined manual updates every time invoice prices change — which rarely happens consistently in a busy kitchen. Hubstaurant closes that gap by connecting purchase data directly to recipe costs, giving you a live view rather than a monthly snapshot.
Start Tracking Recipe Costs Automatically
If you're still updating ingredient prices by hand, you're one supplier price hike away from a margin problem you won't see until month-end. Start a free trial of Hubstaurant and let your invoice data do the work.