Recipe Costing & Stock Control

Recipe & Stock Costing for Bars (Google Sheets)

Working out your actual drink costs and keeping stock control tight takes hours if you do it properly. Get it wrong and you're pricing menus off gut feel, which is how bars quietly bleed margin every week. Pay someone to build you a proper costing system and you're looking at real money and still waiting on them.

This is that system, done. Fifty US dollars, ready to use today.

What's inside:

• Full stock list with pricing, categories, and cost-per-unit, so every ingredient you buy has a real, current cost attached to it.
• Recipe editor that calculates cost per serve automatically, including batch recipes (think large-format cocktails, house syrups, prepped mixers), so you know exactly what a drink costs you before you put a price on the menu.
• Recipe overview page showing target COGS versus actual COGS at a glance, so you can see which drinks are making you money and which ones aren't.
• Stocktake function to count what's actually on your shelves and in your storeroom, so you know your stock on hand value any time you need it.
• Automations built in throughout, save a recipe, edit a past stocktake, or refresh your recipe costings at the push of a button. Basically a spreadsheet made smarter.

What it doesn't do: this isn't a sales or POS system. It doesn't take sales data or track variance between what you bought and what you sold. If you want that level of tracking you need dedicated inventory software, and you'll pay a monthly fee for it. This tool is for getting your costing and stock numbers right, properly and permanently, without a subscription.

Built and runs entirely in Google Sheets. It is not an Excel file and hasn't been built or tested for Excel.

Currently set up in DOLLAR, POUND, and EURO. If you need a different currency, message me directly and we'll see what's possible.