Billiard Hall Weekly Reconciliation: Table Time, Cash, and Inventory Done Right

Reporting & AnalyticsBy CuePoint Team··6 min read·
reconciliationcash managementinventorytable timeweekly reportingbilliard hall operations
CuePoint billiard hall article cover image for Billiard Hall Weekly Reconciliation: Table Time, Cash, and Inventory Done Right
Photo by Daniil Velychko on Unsplash (https://unsplash.com/@nemo_fisher?utm_source=cuepoint&utm_medium=referral)

Most billiard hall operators run a shift close every night — cash counted, drawer balanced, done. But if you're only reconciling at the shift level, you're missing a layer of accountability that only shows up over time. A week's worth of small discrepancies in table time, cash, and inventory can quietly compound into a significant problem before you ever notice. A proper billiard hall weekly reconciliation of table time, cash, and inventory is the habit that separates operators who catch problems early from those who discover them at month-end — or not at all.

Why Shift Closes Aren't Enough

A shift close answers one question: did tonight's cash match tonight's sales? That's necessary, but it's narrow. It doesn't tell you whether your table time revenue is trending down week-over-week, whether a particular product is disappearing faster than it's being rung up, or whether one cashier's shifts consistently show small variances that no single night makes obvious.

Weekly reconciliation is about pattern recognition. You're not auditing one shift — you're comparing seven days of data against each other and against your expectations. That context is what turns raw numbers into actionable information.

Step 1: Pull and Review Table Time Revenue by Day

Start with your table time data. Export the week's sessions and look at daily totals, not just the weekly sum. You want to identify which days performed above or below their typical range, and whether any sessions look anomalous — unusually short or long durations, missing charges, or sessions that were paused for extended periods without a clear reason.

Pay specific attention to rate integrity. If you run happy hour pricing on certain days and times, verify that promotional rates were only applied during the correct windows and not bled into regular-rate hours. A misconfigured happy hour schedule can silently reduce revenue across every qualifying session for an entire week before anyone notices.

Also look at table utilization patterns. If Table 4 consistently shows lower revenue than comparable tables, it might be a slow corner — or it might be that staff are letting friends play without starting a session. Weekly comparison makes that pattern visible in a way that a single shift report never would.

Step 2: Reconcile Cash Across All Shifts for the Week

Pull every shift's variance report for the week and look at them together. A ₱20 short one night might be a counting error. A ₱20 short on Tuesday, Thursday, and Saturday of the same week is something else entirely.

Group variances by cashier, not just by date. If your system maintains a staff-level audit trail, you can attribute each shift's close to the person who ran it. This isn't about accusation — it's about knowing where to focus your coaching or your controls. Consistent small overages can be just as revealing as shortages; they often indicate that change is being rounded in the hall's favor without proper documentation.

Check that every payment method recorded during the week reconciles to what was actually received. If your operation accepts GCash, Maya, or card payments alongside cash, make sure the non-cash totals from your records match your bank or e-wallet statements for the week. Recording payment method labels accurately at the point of sale is the only way this reconciliation is possible later. A solid cash drawer and day-close process makes this weekly review much faster.

Billiard Hall Weekly Reconciliation: Inventory Is the Third Leg

Table time and cash get most of the attention, but inventory reconciliation is where a lot of billiard hall losses quietly live. Food, beverages, cue chalk, and accessories all move in ways that are easy to overlook on a per-shift basis.

At the end of each week, do a physical count of high-value or high-velocity items and compare it against two numbers: your opening stock for the week, minus units sold according to your sales records. The difference — items neither counted nor sold — is your shrinkage figure. Some variance is normal (breakage, spillage, staff meals that were legitimately comped). Consistent variance on the same SKU week after week is a signal worth investigating.

If you're using automatic stock deduction at the point of sale, your system should be able to tell you the expected on-hand quantity without manual calculation. Your physical count then just needs to confirm or challenge that number. When they don't match, you're looking at either a recording gap (items given without being rung up) or a physical loss. Either way, you've caught it in week one rather than month three. You can read more about setting this up in our guide to pool hall inventory management.

How to Structure Your Weekly Review Meeting

Weekly reconciliation doesn't have to be a long process, but it does need to be a consistent one. Block 30–45 minutes at the same time each week — Monday morning before opening works well for most operators, since it covers the prior week without letting data go stale.

Keep the review focused on three outputs:

  • Variance summary: Table time revenue vs. prior week and vs. same week last month. Cash variance total and by-cashier breakdown. Inventory shrinkage by category.
  • Anomalies flagged: Any sessions, shifts, or SKUs that fell outside normal ranges, with a brief note on likely cause.
  • Actions assigned: If something needs follow-up — a conversation with a staff member, a rate configuration check, a reorder — it gets assigned to someone with a deadline before the next weekly review.

If you have a manager running this process, make sure they have access to the right reports without needing to ask you for credentials every time. Scoped staff permissions mean your manager can pull the data they need independently, which makes the process sustainable rather than owner-dependent. Your billiard hall revenue reports should be the starting point for every weekly review.

Building the Weekly Habit Before Problems Force It

Most operators who implement a weekly reconciliation routine do so because something went wrong — a cash shortage that went undetected too long, a product that vanished from shelves without explanation, a table that was being run off the books. The value of doing it proactively is that you establish a baseline before problems start, which makes anomalies much easier to spot.

In CuePoint, the combination of per-shift variance reports, session-level table time data, and automatic inventory deduction gives you the raw material for this weekly review in one place. The reports can be filtered by date range and exported to CSV if you want to run further analysis in a spreadsheet. The discipline of actually running the review weekly is still on you — but the data doesn't have to be the bottleneck.

Start simple: this week, pull your last seven days of cash variances and line them up by cashier. That one view alone will often tell you something you didn't know.

Ready to streamline your billiard hall operations?

CuePoint helps you manage tables, track revenue, and grow your business — all from one dashboard.

Try CuePoint Free