Why Spreadsheets Fall Short
Many café owners start with Excel or Google Sheets, and it works — up to a point. The problem is that ingredient prices change constantly, and manually updating a spreadsheet with current Coles and Woolworths prices is tedious enough that most people stop doing it. Within six months, your spreadsheet costs are out of date and your margins are quietly eroding.
What Good Recipe Costing Software Does
Purpose-built recipe costing tools connect to live supermarket pricing databases so your costs update automatically. They let you build recipes by searching for ingredients by name, specify quantities in grams, millilitres, or units, and instantly see the total ingredient cost and recommended sell price. The best tools also let you model 'what if' scenarios — what happens to your margin if avocado prices double?
The Importance of Using Australian Prices
Generic recipe costing tools often use US or UK ingredient databases, which are useless for Australian cafés. A 200g avocado that costs US$0.50 in California costs A$2.50–$4.00 in Australia depending on the season. You need a tool built specifically for the Australian market, using Coles and Woolworths pricing as the benchmark.
How Often Should You Re-Cost Your Menu?
At minimum, re-cost your entire menu twice a year — once before summer and once before winter. Additionally, re-cost any dish immediately when a key ingredient has a significant price change. If avocado prices spike 40% in July, your smashed avo needs to be re-priced or re-engineered immediately, not at your next scheduled review.
Start With Your Top 10 Dishes
If you're new to recipe costing, don't try to cost your entire menu at once. Start with your 10 best-selling dishes. These are where the most money is made or lost, and getting them right will have the biggest immediate impact on your profitability. Once you've built the habit, add the rest of your menu over the following weeks.
