How to Audit Your Billiard Hall's Daily Revenue: Matching Table Time, POS Sales, and Cash Drawer Totals

You close the night with ₱8,400 in the drawer, but your session logs add up to ₱7,900 and product sales show ₱600 more. Which number is right — and where did the gap come from? A reliable billiard hall daily revenue audit that matches table time, POS sales, and cash drawer totals isn't just an accounting exercise. It's the fastest way to catch errors, deter theft, and understand whether your operation is actually performing the way you think it is.

Why the Three Numbers Never Match on Their Own

Most billiard halls collect revenue from two distinct sources: table time charges and over-the-counter sales like drinks, snacks, and accessories. These two streams often flow through different tracking methods — a whiteboard for tables, a separate counter for products — and get combined loosely at shift end. That loose combination is where variances hide.

Common sources of legitimate discrepancy include rounding differences (charging the nearest 30-minute block versus exact seconds), open tabs that weren't closed before reconciliation, and split payments where a customer paid part cash and part digital wallet. Before you conclude something is wrong, you need to understand what your system is actually measuring at each step.

The goal of a daily audit isn't to reach a perfect zero variance every time — it's to reach a explainable variance. Any gap you can account for is a gap you can manage.

Step 1 — Reconcile Table Time Charges First

Table time is your primary revenue source, so start there. Pull your session log for the day and total all completed sessions. Check specifically for:

• Sessions that were paused but not resumed — a player who stepped out for 20 minutes and the clock was never restarted means lost revenue, not a variance.
• Sessions closed at a rate that doesn't match the time of day — a happy hour rate applied to a 9 PM session suggests the rate wasn't switched back correctly.
• Short sessions billed below your minimum charge — if you have a 30-minute minimum and a table ran for 12 minutes, the charge should still reflect the minimum.
• Sessions transferred between tables — confirm the elapsed time carried over correctly and the total charge reflects the full duration, not just the second table.

Once you have a clean table time total, that number becomes your first anchor point for the audit. Accurate pool table time tracking is the foundation everything else reconciles against.

Step 2 — Add Product Sales and Verify Against Inventory Movement

Your POS sales total for the day should include every item rung through — drinks, food, cue rentals, chalk, whatever you sell. The figure to use here is total POS revenue, not just the product portion, since a well-integrated system combines table time and products into a single transaction at checkout.

Cross-check product sales against your inventory movement for the day. If your system shows 24 bottled waters sold but your physical stock only dropped by 19, you have either a ring-up error, a giveaway that wasn't recorded, or a shrinkage problem. This isn't always a cash issue — sometimes a staff member discounted an item without recording it, or a product was consumed during setup and never logged.

A basic inventory tracking system that automatically deducts stock on each sale makes this cross-check fast. Without it, you're doing a manual count every night, which most operators skip — and that's exactly when small discrepancies compound into large ones over weeks.

Step 3 — The Cash Drawer Reconciliation That Actually Catches Problems

This is the step most billiard hall owners do informally: count the cash, subtract the opening float, and see if it matches expected sales. But a proper billiard hall daily revenue audit of the cash drawer goes further than a single count.

Structure your end-of-day cash reconciliation this way:

1. Start with your expected cash — opening float plus all cash payments received during the shift.
2. Subtract any cash payouts — change given, petty cash used for supplies, any mid-shift drawer pulls.
3. Count the physical drawer — by denomination, not as a single pile.
4. Calculate the variance — difference between expected and actual.
5. Separate non-cash payments — GCash, Maya, card totals should be logged separately and matched against your digital wallet settlement statements, not lumped into the cash count.

A variance under ₱50 on a busy night is normal rounding and change-making error. A consistent short variance of ₱200–300 across multiple shifts, always on the same cashier's days, is a pattern worth investigating. That's why shift-level breakdowns matter more than a single daily total.

Step 4 — Matching All Three Totals and Documenting the Result

Once you have your three figures — table time charges, POS product sales, and cash drawer net — bring them together into a single daily summary:

Total Expected Revenue = Table Time Charges + Product Sales
Total Collected = Cash (net of float) + Digital Wallet Payments
Variance = Total Expected − Total Collected

Document this every day, even when the variance is zero. The historical record is what lets you identify whether a problem is a one-off anomaly or a recurring pattern tied to a specific day, shift, or staff member. Keep at least 30 days of daily summaries accessible — weekly or monthly review is where the real operational insight comes from.

If you're using a platform like CuePoint, the cash drawer and day-close reconciliation tools generate a variance report automatically at shift end, so your three-way match is already structured for you. What you still need to supply is the discipline to review it consistently, not just on days when something feels off.

Building the Habit: Who Does the Audit and When

A daily revenue audit only works if it happens every day, at the same point in your closing procedure, and is reviewed by someone with authority to act on what they find. Assign it clearly — either the closing manager or the owner — and make it a non-negotiable part of shift close, not an optional add-on when time permits.

For multi-staff operations, consider separating the person who handles the cash from the person who does the count. This isn't about distrust — it's a basic internal control that protects your staff as much as it protects your business. A cashier who never counts their own drawer can't be accused of manipulating the reconciliation.

Review your billiard hall revenue reports weekly to look across daily audits for trends. A single bad day is noise. Five consecutive Saturdays with an above-average variance in the same payment type is a signal.

A Practical Starting Point

If you're not currently doing a structured daily audit, start simple: a single spreadsheet with five columns — date, table time total, product sales total, cash net, variance — filled in every closing shift for 30 days. That baseline alone will surface patterns you didn't know existed and give you the data to make meaningful operational changes. From there, you can move to a system that automates the tracking and leaves you with just the review and the decisions.