Canteen stock in a snooker club: how to count it and match it to sales
How to track canteen stock in a snooker club: a simple count-and-match routine, where cold drinks and snacks go missing, and how stock follows sales.
Updated · 6 min read
To match canteen stock to sales, count each item at the start and end of a period, and add what you bought in between. Opening stock plus purchases minus the closing count is what should have been sold. Compare that number with what was recorded as sold. The difference is the gap you need to explain.
Why do stock and sales drift apart?
Cold drinks, tea and chips are small sales, made fast, often while the counter is busy. Each one is easy to forget. Stock also moves without a sale: a drink for a friend, a bottle that breaks, a packet that expires. Over a few weeks these small things add up, and the shelf no longer agrees with the book.
The gap is not always a sign of dishonesty. Often it is simply missing records. The count-and-match routine helps you find which kind of gap you have.
How do I count stock and match it to sales?
- Pick a period. A week works for most items. Fast items like cold drinks can be counted more often.
- Count the opening stock for each item on the first day, before any sale.
- Record every purchase during the period: the item and the quantity that came in.
- Count the closing stock at the end, the same way, with two people if possible.
- Work out what should have been sold: opening stock + purchases − closing count.
- Compare it with the recorded sales for the same item and period. Write down the difference.
A worked example
| Opening stock counted on Monday | 48 bottles |
|---|---|
| Purchases during the week | + 24 bottles |
| Closing count at the end of the week | − 30 bottles |
| Should have been sold | 42 bottles |
The sales record shows 36 bottles sold. The gap is 6 bottles (42 − 36). At a selling price of Rs 100 each, that is Rs 600 of stock, at selling price, that is not in the sales record. Asking around, the club finds:
- 2 bottles given free to a friend of the owner
- 1 bottle broken while unpacking
- 3 bottles sold at the counter but not entered
2 + 1 + 3 = 6, so the gap is fully explained. In real life it may not be, and a small unexplained gap is normal to start with. What matters is that you look, every period, and that the gap gets smaller.
Where does the missing stock usually go?
- Items given free. To a friend, a regular, or a player who lost a close frame. If you allow it, have it written down.
- Items sold but not recorded. The busiest times are when entries get skipped.
- Cash taken for tea but not entered. Money went in the drawer, or in a pocket, with no sale behind it. Then the cash and the stock are both wrong.
- Damaged or expired stock. Broken bottles and old packets are a real loss. Write them down as a stock adjustment, not as a mystery.
- No purchase record. If you bring in 24 bottles and nobody writes it, the count will look as though 24 bottles appeared from nowhere.
These gaps are part of the wider problem of small leaks. See how to stop money leaks in a snooker club.
Should I sell on the table bill or as a quick sale?
Use both, for different situations. If players at a table order tea or a drink while they play, put it on that table's bill, so they pay once at the end. If someone walks up to the counter for a cold drink and leaves, make it a quick sale and take the money at once. Each item should go in one place only. An item on a table bill that is also written as a quick sale is counted twice.
Whichever way you choose, decide how table bills are priced and charged first. See per-frame or per-minute billing.
How do I keep prices consistent?
- Keep one price for each item, and change it for everyone on the same day.
- Put the price list where staff and players can see it.
- If you give a special price, write it down with the reason. An unexplained lower price looks exactly like a mistake.
- Update the price in your records when you change it on the board, so sales and stock use the same number.
How Snook Manager handles it
Each canteen product has a selling price, and stock tracking can be switched on or off per product. With tracking on, the stock goes down automatically with each sale. Stock purchases and adjustments can be recorded, and a stock purchase can also be entered as an expense under the category "stock purchase". Items can be sold on a table's bill or as a quick sale at the counter, and quick sales work offline. Every entry records who made it and when. Snook Manager does not send low-stock alerts, manage suppliers or show profit per item, so the weekly count stays your routine. See the canteen feature and the daily report, expenses and salaries.
Read next
- How to choose snooker club software: 10 questions to askA checklist of 10 questions to ask before you buy snooker club software: billing rules, udhaar, offline use, staff roles, shift close, exports and price.
- What is snooker club management software, and what should it do?Snooker club management software explained: what it does for tables, billing, canteen, udhaar and staff, who needs it, and what to check before you choose.
- A discount policy for a snooker club that does not leakHow to give discounts in a snooker club without losing money: who may give them, a limit, a written reason, and a weekly read of the list.