Inventory

Restaurant Bar Stock Take: Count Faster and Trust the Variance

How often should you stock take a bar?

Count a bar by storage area, on a phone, and more often than once a week. That turns the bar stock take into something your team can act on the same session, not days later. The Spread, Supy's own data, found records are about 3x more accurate for bars counting more than weekly, 76.2% against 24.5%. This article shows how often to count, how to count by storage area, part bottles and kegs, and reading variance across a group.

Weekly is the floor for a busy bar, not the target. The Spread found the least frequent counters match the shelf on only 24.5% of count days, against 76.2% for those counting more than weekly. Match the cadence to how fast the stock moves and how much it is worth:

  • Full count, weekly. Every line in every storage area, on the same day each week, so one week compares against the last.
  • Spot count, two or three times a week. Your premium spirits, wine by the glass and draught kegs, counted between full counts so a problem shows up in days, not weeks.
  • A fresh count after any big service. A festival weekend or a function empties the fast movers, so count them before you reorder against a shelf you think is full.
The Spread staircase chart: records are 76.2% accurate on count day for bars counting more than weekly, against 24.5% for the least frequent counters

Count by storage area, not one long list

Split the count by where the stock sits, not by one flat list of every product. A bar holds the same gin in the back bar, the cellar and the cool room. One flat list makes a counter walk the venue three times and still miss a case.

Counting by area lets each person take one area while the system sums each item across all of them. Supy builds the count around the bar's own layout:

  • A reusable template in shelf order. Each outlet gets its own template, so a counter works left to right along the shelf instead of hunting for the next line on a sheet.
  • Named sub-sections counted in parallel. Each area (back bar, cellar, cool room) is counted at once, and every sub-section locks when its counter finishes. Supy merges them into one count with each counter's name and an audit log.
  • Counting on a phone, even offline. Supy's stock counting runs on a phone or tablet and keeps working in a cellar with weak signal, so a dropped connection does not lose the numbers already tapped in.

Teams that count this way report cutting their count time by more than 50%, because three people working three areas in parallel beat one person walking the whole venue.

The template needs upkeep as the range grows. A fine-dining group that adds new wine lines every month has to add them to the template too, or the next count skips them. For structuring a bar's stock from the ground up, see bar inventory management.

Before and after: back bar, cellar and cool room counted separately merge into one bar stock count

How to count part bottles, kegs and mis-rung drinks

Three bar items break a count that works fine for a dry store, and each has a reliable way to count it. Count them the same way every week, so you can compare this week's variance against last week's.

ItemHow to count itWhat skews the variance
Part bottle of spiritCount to the nearest tenth by eye or weigh it, and record it the same way every weekGuessing differently each week makes a line look like theft
Draught kegCount full kegs as units and gauge the tapped keg by weight or flow meterA half-logged tapped keg hides real pour cost
Post-mix and bag-in-boxCount sealed boxes and estimate the open one by weightOpen boxes left off the count overstate usage
Mis-rung drinkRead variance against till sales and flag the lines that do not reconcileA drink rung as the wrong flavour moves the loss onto another line

The mis-rung drink is the one people miss. When a double gin is rung as a single, the till records the sale against the wrong line, so one line shows a loss and another a matching gain. Reading variance against till sales finds the pair, and a word with the team fixes the buttons before the next service.

Why bar variance shows up too late

Variance you see after the count closes is a report, not a tool. A counter keys the sheet into a spreadsheet that evening, and the manager opens it the next day. By then the stock has moved, and nobody remembers which shift poured heavy.

Supy shows variance per area the moment each sub-section merges, against what the system expected from your deliveries and till sales. A manager watching the back bar close sees the vodka running short before the cellar is even counted. They drill into the line and act while the shift is still on.

Timeline showing bar variance gets harder to act on, from acting at count close to writing it off the next day

Comparing bars across a group

One bar's variance means little until you put it next to the others. A group that runs the same template everywhere can line its bars up side by side. The clean counts and the drifting ones show at a glance, so the area manager visits the bar that needs it.

Supy's Stock Counts list shows the counts for every branch and location, filterable by branch and location. On count day, head office sees which bars have reported and which have not.

Supy Stock Counts list showing which bars across a group have submitted their count and which are still in draft

A stock count stays a draft until someone submits it, and submitting it adjusts inventory quantity and value and produces the variance report. Because every bar counts off the same template in shelf order, the variance compares like for like across the group. For the controls that keep those counts honest across sites, see stock count controls for multi-site groups.

Count weekly at a minimum, and spot count your highest-value lines two or three times a week. Act on any area where the variance is over your threshold the moment the count merges. Do that while the shift is still on, not at month end.

Book a Demo with Supy - bar stock take

Ready to optimize your restaurant operations?

Blog

Our operational insights

Restaurant inventory management - complete guide for multi-location operators
Inventory

Restaurant Inventory Management: The Complete Guide for Multi-Unit Operators

Food cost

Zero Waste Restaurant: Start With the Food You Already Throw Away

Inventory

Restaurant Prep List Template: Prep for Tomorrow's Covers, Not Habit

Your questions 
answered

Everything you need to know about Supy — from setup to integrations, pricing, and daily use. If it’s not covered here, just ask.

How often should you do a bar stock take?
+

Count a busy bar weekly at a minimum, and spot count your highest-value lines two or three times a week. Weekly gives you a clean comparison against last week, while spot counts on premium spirits, wine by the glass and draught kegs catch a problem in days rather than at month end. Supy's own data, The Spread, found records are about 3x more accurate for businesses counting more than weekly, so the frequency is what makes the variance worth acting on. Counting less than monthly leaves the number too stale to tell you much.

How do you count part bottles of spirits?
+

Count a part bottle to the nearest tenth by eye, or weigh it for a tighter figure, and record it the same way every week. The method matters less than the consistency, because if one week you guess high and the next you guess low, the line looks like theft when nothing was lost. Weighing is worth it for your most expensive spirits, where a tenth of a bottle is real money. For everything else, a careful eye estimate against a marked bottle is enough, as long as the whole team reads the level the same way.

What is the best way to count a bar with several storage areas?
+

Count each storage area separately and let the system add an item up across all of them. A bar keeps the same gin in the back bar, the cellar and the cool room, so one flat list makes a counter cross the venue three times and still miss a case. Supy builds a count template per outlet in shelf order and splits it into named sub-sections that several people count at once. Each sub-section locks when its counter finishes, and the counts merge into one with each counter's name against it, so you read the full figure without adding anything up by hand.

How do you work out bar variance?
+

Work out variance by comparing what you counted against what the system expected, which is opening stock plus deliveries minus what the till sold. A gap means stock left without a matching sale: over-pouring, breakage, waste or a drink rung to the wrong line. Read the variance per item rather than as one venue total, because a single figure hides which line is the problem. Supy shows the variance per storage area the moment each sub-section merges, against your deliveries and till sales, so you can drill into the line that moved and act on it the same session.

Why does bar stock variance show up too late to act on?
+

Variance shows up too late when the count is keyed into a spreadsheet after service and read the next day, by which point the stock has moved and nobody recalls which shift poured heavy. A number that is accurate but a day old cannot tell you who to ask or what to change. The fix is to see the variance the moment the count closes, while the people who worked the shift are still on. Supy merges each area's count and shows its variance straight away, against the real till sales, so the problem is current enough to act on.

Can you do a bar stock take on your phone?
+

Yes, you can run a full bar stock count from a phone or tablet. Supy's stock counting works on a mobile device and keeps counting even in a cellar with weak signal, so a dropped connection does not lose the numbers your team has already tapped in. Counting on a phone means a counter reads the shelf and records the figure in one motion, instead of writing on paper and keying it in later, the step where a counter makes most mistakes. It also lets several people count different areas at the same time and merge the results automatically.

How do you compare stock takes across several bars in a group?
+

Compare bars by running the same count template across every venue, so each one counts the same lines in the same order. Supy's Stock Counts list shows the counts for every branch and location in one view, filterable by branch, so head office sees on count day which bars have reported and which have not. Because every bar counts off the same template, the variance compares like for like, and an area manager can go straight to the venue with the worst variance rather than reading a different spreadsheet from each site. A count stays a draft until someone submits it, which is how you tell a finished count from one still in progress.

Ready to transform your operations?

Join 3500+ restaurant operators cutting costs, streamlining operations and making smarter decisions with Supy.