Food Stock-Take & Actual Food Cost Tracker

Excel (.xlsx) — also opens in Google Sheets & Numbers

Do a proper stock take and see your REAL food cost % — then compare it to your target and find the leak. Food used = opening + purchases − closing, worked out for you.

What's inside

• Actual vs theoretical food cost % in one view
• Shows the £ you're losing to waste, theft or portioning
• Quick weekly or monthly count
• Worked example built in — just type over it

What it does

A proper stock take, worked out for you: food used = opening stock + purchases − closing stock, turned into your REAL food cost percentage and compared against your target. The gap between actual and theoretical is where waste, portioning drift and theft hide — this sheet puts a £ figure on it.

It's built for a quick weekly or monthly count, with a worked example you type over.

Who it's for

Any kitchen that's ever been surprised by the month-end food cost. If your theoretical GP looks fine but the bank account disagrees, the stock take is where the answer lives.

Goes well with

Try the numbers first, free: the food cost & GP calculator and the recipe costing tool run in your browser.