How to Track Revenue in a Billiard Hall — Reports, Reconciliation, and Real Numbers

Reporting & AnalyticsBy CuePoint Team··4 min read·
revenuereportsdaily closinganalyticsCSV export

Most billiard hall owners know their approximate revenue. They count the cash drawer at closing, check the register total, and have a general sense of whether it was a good night or a slow one. But approximate is not the same as accurate — and the gap between the two is where money disappears.

Why End-of-Day Cash Counts Are Unreliable

A cash count tells you how much money is in the drawer. It does not tell you how much money should be in the drawer. Without a system that records every transaction as it happens, you have no expected total to compare against.

Common reasons cash counts come up short:

  • A table was stopped but never checked out — the customer paid cash and it was pocketed or forgotten
  • Change was given incorrectly
  • A void or refund was processed but not recorded
  • Small purchases (a can of soda, a piece of chalk) were handled off-register
  • Time was rounded down at checkout, losing 10–15 minutes of revenue per session

None of these are necessarily theft. Most are process failures — things that happen because the system does not capture them, not because staff are dishonest.

Revenue Categories in a Billiard Hall

A billiard hall has at least three distinct revenue streams, and tracking them separately is essential:

Table time revenue: The core business. This should be tracked per table, per session, with the rate and duration recorded. Aggregate reports should show total table revenue by day, by table, and by time slot.

Product revenue: Food, drinks, cue rentals, chalk, and accessories. These should be tracked separately from table time so you can see what your snack bar actually earns versus what the tables earn.

Membership revenue: If you offer membership plans with monthly or annual fees, this is recurring revenue that should be tracked separately. It behaves differently from transactional revenue and affects how you forecast.

The Reconciliation Problem

Reconciliation is the process of comparing what the system says you earned with what is actually in the drawer. If your table revenue is tracked in a logbook, your product sales are on a POS, and your memberships are in a spreadsheet, reconciliation is a painful manual exercise that most halls skip entirely.

When all revenue flows through one system — table time, products, and memberships — reconciliation becomes a single comparison: system total vs. drawer count. The variance tells you exactly how much is unaccounted for, and the audit trail helps you find out why.

What a Good Daily Report Should Show

At the end of each day (or shift), you should be able to see:

  • Total revenue — broken down by table time, products, and other categories
  • Revenue by table — which tables earned the most and which sat idle
  • Table utilization — what percentage of available time each table was occupied
  • Average session duration — are customers staying longer or shorter than last week?
  • Voids and discounts — how much revenue was removed and by whom
  • Payment method breakdown — cash vs. card vs. e-wallet

If generating this report requires a spreadsheet and 30 minutes of data entry, it will not get done most nights. If it is available in one tap, it becomes part of the closing routine.

Exporting Data for Accounting

Your accountant or bookkeeper needs clean data. A stack of handwritten receipts or a photo of the logbook is not clean data. Export capabilities — CSV or similar — let you send structured transaction data to your accountant without retyping anything.

This also matters for tax compliance. In some jurisdictions, you need to produce transaction records on demand. A system that records every transaction with timestamps, amounts, payment methods, and staff names satisfies this requirement. A logbook does not.

See How CuePoint Handles This

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