Novota blog

How to Run a Monthly Bar Stock Audit: A Step-by-Step Checklist

· 3 min read

Bar staff counting bottles on the back-bar shelves after closing, one with a clipboard

A bar stock audit answers one question: did the liquor that left the shelf leave through the till? Done monthly and the same way every time, it is the single best control a bar owner has. Done occasionally and differently each time, it mostly produces arguments.

This is a checklist you can follow. For the theory behind it, what variance is and where liquor goes, read our bar stock variance guide.

Before the count

  1. Fix the date and time. Same day of the month, after close. Tell the team in advance.
  2. Freeze the books. Every purchase for the period must be entered, and every bill for the period closed in the POS, before counting starts.
  3. Print or open the count sheet in shelf order: back bar, speed rail, store room, cold room. Counting in the order bottles stand is faster and nothing gets missed.
  4. Check the brand list. New brands added this month, bottle sizes, empty weights if you weigh.
  5. Pair the counters. One counts, one records. Rotate the pair every month.

The count

  1. Sealed bottles first. Count whole bottles, by brand and size, in every location.
  2. Open bottles in ml. Weigh them, or mark the level on the actual bottle shape. Avoid quarters and halves; see how to weigh open bottles.
  3. Do not move stock during the count. No transfers from store to bar until both are counted.
  4. Note breakages and empties found during the count, with a reason.
  5. Sign off the sheet, both counters, with the time.

After the count

  1. Work out the book stock for each brand: opening stock + purchases − sales, in ml.
  2. Compare with the physical count. The difference is the variance; a negative number is a shortage.
  3. Value it at cost and at selling price. The selling-price figure is what the shortage would have earned.
  4. Flag brands above your threshold, usually a few percent of what was sold. Set the threshold once and keep it.
  5. Recount flagged brands before you conclude anything. A miscount is the most common cause of a large variance.

The free bar variance calculator does steps 11 to 14 for you if you are working on paper.

Acting on the result

  1. Check the paperwork first. A missing purchase entry or a sale rung to the wrong brand looks exactly like theft.
  2. Look at patterns. Is the same brand short every month? Is the shortage concentrated on certain shifts?
  3. Change one thing. Measured pourers on the brand, a different bartender on that well, comps that need a manager's PIN.
  4. Write it down. The date, the brands, what you found, what you changed.
  5. Compare next month. A control only works if you check that it worked.

What good looks like

After three or four months of this, you should know your normal variance by brand, have a short list of brands that need watching, and see the overall shortage fall. The count itself should take under an hour for a typical bar.

Make the count faster

Novota BVR turns the count into a single pass: sealed bottles by tap, open bottles by Bluetooth scale, voice or a drag of the finger, and the variance report ready the moment the last bottle is counted. It is set up with your branches, stores and brand list before the first count.

Frequently asked questions

How often should a bar audit its stock?

A full count of every brand once a month, with a weekly count of the twenty or so fastest-moving brands, is a common rhythm. More frequent counts make a variance easier to trace to a shift.

When is the best time to count?

After close, before anything is served the next day, and at the same point every month. Counting mid-service mixes sold and unsold stock.

Who should do the count?

Two people: one counts, one records, and at least one of them should not be the person responsible for the bar day to day. Rotate the pair from month to month.

What should I do with a large variance?

Recount that brand first. If it holds, check purchases and sales entries for the period, then look at the shifts and staff involved. Write down what you found and what you changed.