Drinks and Wine Cellar Stock Control Template

Because drinks move differently from kitchen ingredients: open bottles, sales by the glass, staff drinks, breakages, comps, transfers between stores and quick restocks from the bar. Tracking them separately helps you spot losses, fine-tune orders and protect your margin on wine, soft drinks, coffee, beer and spirits.

It includes product, category, area, supplier, opening stock, deliveries, estimated sales, open bottles, breakages, comps, closing stock, minimum stock, suggested order, price per bottle, glasses per bottle and an indicative cost per glass or serve.

Yes. You can track wines by label, vintage, supplier, location, minimum stock and turnover. It also helps you separate bottles set aside for the wine list, pairings, events, tastings or staff use, which is especially useful in restaurants and hotels.

Yes. In a café it works for milk, coffee, water, soft drinks, juice, beer, takeaway cups and other bar consumables. The template is editable, so you can hide the wine or spirits columns and keep only the ones you use every day.

It lets you compare opening stock, purchases, expected usage and closing stock. If a drink goes down by more than sales explain, you can look at breakages, comps, service errors, staff drinks or recording problems before the gap repeats itself for weeks.