Keg and Cask Stock Rotation Sheet
Keep the oldest container next on and nothing sold past the brewery's date, with a week-end count of full stock, empties and returns that a stock take can use.
RB-10 1 page
Restaurants and bars · RB-28
Bar Stock Count Sheet
A free printable bar stocktake — opening and closing counts for spirits, wine, bottled beer and soft drinks, with deliveries and the variance between them.
Download Free · no sign-up
One page. Choose your paper size — both versions are laid out identically, so neither one gets shrunk to fit.
Print it and write on it
Fill it in type and save
The fillable versions have real form fields — open them in any PDF reader, type into them and save. Printing help.
What this sheet is for
Catch a shortfall at the count, where it is a number on a sheet, rather than weeks later when the margin has already gone.
Who it is for
Bar managers and anyone responsible for stock control behind a bar.
How to use it
- Count spirits to the nearest tenth of a bottle; count wine, beer and soft drinks by whole bottle or case.
- Record opening stock, add what was delivered since the last count, then count what is actually there.
- Write the variance plainly — a positive or negative number, not a guess at why.
- Have a second person check the count on anything with a large variance before raising it.
What is on the sheet
One page, top to bottom:
Printed under the title: A full count of everything behind the bar — spirits, wine, bottled beer and soft drinks — opening and closing stock against what was delivered, so a shortfall shows up at the count rather than at the end of the month.
Counted in bottles and part-bottles. Count spirits to the nearest tenth of a bottle, using your own optics or a stocktake measure; count wine, beer and soft drinks by whole bottle or case. How often you stocktake, and what you count as an acceptable variance, is your own house routine.
Write-on lines: Bar · Stocktake date · Counted by · Checked by
Stock count
Table, 13 rows: Category · Product · Opening stock · Delivered · Closing stock · Variance
Questions
How is this different from the keg and cask rotation sheet?
That sheet tracks when each keg or cask was opened, for rotation and freshness. This is a stock count across the whole bar — spirits, wine, bottled beer and soft drinks — for working out what was actually used against what was sold.
Does this sheet set an acceptable variance?
No. What counts as normal wastage versus a problem worth investigating is for your own house to decide, based on your own history — this sheet only gives you the number to judge it by.
Related sheets
Bar Float and Cash Up Sheet
Cash up a bar with several tills so that a short drawer is found on the night and has a till and a shift attached to it, instead of vanishing into one bag.
RB-01 1 page
Spirit and Optic Measure Check
Find the optic that is short-pouring and the rail that is over-pouring before the stocktake finds them for you.
RB-19 1 page
Wine List and Bin Number Record
Keep one master sheet behind the printed list, the cellar shelves and the till, so a bin number means the same wine in all three places.
RB-25 1 page
