Excel (.xlsx) — also opens in Google Sheets & Numbers
Track your sales, food cost and gross profit week by week — and spot the slide before it hurts. Type sales and food cost; the percentages and profit fill in.
Type your weekly sales and food purchases; the tracker fills in food cost %, GP % and GP £ for every week, keeps running totals and an average, and shows the trend line of your margin — up to 26 weeks per sheet.
Margins rarely collapse in a week. They slide, quietly, and this sheet is how you see the slide while it's still cheap to fix.
Owner-operators who check the numbers weekly (or want to start). Pairs naturally with the stock-take tracker: one measures the week, the other explains it.
Try the numbers first, free: the food cost & GP calculator and the recipe costing tool run in your browser.