Gaming Equipment Abnormal Colombia How to Set Up a Revenue Audit Process That Catches Problems Early
Colombian gaming operators typically reconcile revenue at the end of each month: total credits displayed on machines compared to total cash collected. This end-of-month reconciliation has one critical weakness: a problem that starts on day 3 is not detected until day 30. The operator has lost 27 days of revenue to a problem that could have been detected within 24 hours with a properly structured audit process.
This article describes how to set up a daily and weekly audit process that catches revenue problems early, specific to Colombian machine types and operating conditions. I designed this process based on the audit procedures used at the best-monitored Colombian venues I have worked with.
Why Monthly Reconciliation Is 27 Days Too Late
Consider a typical Colombian 15-machine venue losing 30,000-50,000 COP per day to unauthorized credits. Monthly loss: 900,000-1,500,000 COP. Detected at end of month, the operator has lost this amount before knowing a problem exists. If the problem is detected on day 3 through a daily audit process, the operator has lost only 90,000-150,000 COP and can investigate immediately. The difference between monthly and daily detection is a factor of 10 in saved revenue.
Daily Audit: The Revenue-to-Credit Ratio Check
The daily audit process takes 15 minutes and should be performed by the shift supervisor at the end of each day. Step 1 — collect per-machine revenue data: total credits registered per machine for the day (from the machine display or bus monitor data if monitors are installed), total cash collected per machine from the cash box, and the ratio of cash to credits (should be 0.95-1.05 if the machine is operating correctly). Machines with a ratio below 0.95 are registering credits that were not paid for — potential unauthorized credits. Machines with a ratio above 1.05 have cash that was not recorded as credits — potential undercount from sensor failure or configuration issues.
Step 2 — flag any machine with a daily ratio outside the 0.95-1.05 band. Investigate the same day, not next week. Step 3 — record the results in a daily audit log (spreadsheet or notebook, whichever the supervisor will actually maintain). The log should include the date, machine number, credits registered, cash collected, ratio, and any notes about anomalies.
The daily audit catches approximately 70% of Colombian machine revenue problems because most problems — unauthorized credits, sensor failures, configuration errors — produce immediate deviation in the credit-to-cash ratio. The remaining 30% are problems that do not affect the cash-to-credit ratio: payout manipulation (the machine pays more per credit without changing credit counting) and gradual component degradation (voltage drift causing 1-2% per month revenue decline — too slow for daily audit detection but detectable by weekly trend analysis).
Weekly Audit: Trend Analysis and Cross-Machine Comparison
The weekly audit catches the 30% of problems that the daily audit misses. The weekly process takes 30 minutes and should be performed by the venue manager (not the shift supervisor, to create a separation of duties that reduces the risk of internal collusion). Step 1 — review daily audit logs: check for patterns — a machine with 3 out of 7 days flagged or a machine with a ratio trend worsening over the week (0.94 dropping to 0.90 over 5 days).
Step 2 — cross-machine comparison: compare the weekly revenue-to-credit ratio across all machines of the same type. If fish table machine 1 has a weekly ratio of 0.98, fish table machine 2 has 1.01, and fish table machine 3 has 0.88 — machine 3 is the outlier. The cross-machine comparison identifies problems that are gradual enough that a single machine is within the daily band but far enough from peers that the cumulative weekly data reveals the anomaly.
Step 3 — payout deviation check: using bus monitor data if available, calculate the payout percentage for each machine for the week. A machine configured for 85% payout that shows 92% payout for the week warrants investigation even if the cash-to-credit ratio appears normal — the discrepancy suggests that credits are being paid out without being recorded correctly. This is the specific pattern of payout manipulation described in the Bogota 50-machine case study (article 284).
Step 4 — match the weekly data to the bus monitor alert log for the week (if bus monitors are installed). If the bus monitor shows unauthorized credit alerts on specific machines at specific times, and the weekly audit shows those same machines flagging for low daily credit-to-cash ratio on the same days, the data and the audit agree — the problem is confirmed from two independent sources.
Monthly Audit: Full Reconciliation and Exception Report
The monthly audit remains important for the overall revenue picture and for generating exception reports. But with daily and weekly audits operating, the monthly audit’s role shifts from primary detection to verification.
Monthly process: reconcile total monthly credits across all machines versus total monthly cash deposited. Calculate monthly revenue per machine and compare to the previous month and the same month previous year (to account for seasonal variation — Colombia’s seasonal tourism affects revenue in different months). Generate an exception report listing: any machine that flagged on the daily audit more than 20% of days (approximately 6 days in a 30-day month), any machine that the weekly audit identified as an outlier in the cross-machine comparison, any machine with monthly revenue more than 15% below the same month previous year, and any machine that received unauthorized credit alerts from bus monitoring (if installed).
The exception report is the monthly deliverable to the venue owner. It shows the owner not just “revenue was X this month” but “these 3 machines had problems, here is what we found, here is what we did.” This transforms the financial discussion from a revenue report to a problem-resolution update.
Colombian-Specific Audit Adjustments
The audit process includes Colombian-specific adjustments not needed in other countries. Colombian power quality adjustment: during rainy season, increase the daily cash-to-credit flag threshold from 0.95-1.05 to 0.93-1.07. Rainy season power fluctuations (as described in article 285) cause natural credit-counting variation that is not fraud. Using the tighter threshold during rainy season generates false flags that waste investigation time. Colombian holiday adjustment: flag the daily credit-to-cash ratio on major Colombian holidays and festival days as separately analyzed — the ratio may shift because holiday play patterns differ (more casual players unfamiliar with the machines mis-operating them in ways that affect credit counting).
Colombian venue-staff adjustment: Colombian shift supervisors are typically paid by salary, not by shift profit share — which is important for audit integrity. A supervisor paid by revenue share has incentive to hide revenue loss to protect their earnings. Verify that supervisors responsible for audit recording are salaried, not commission-based. If a supervisor is commission-based, add a second person (venue manager) to verify the daily audit numbers at least once per week — and make it known that this verification occurs to discourage manipulation.
Colombian cash management adjustment: daily audit should use the cash box count as the daily cash figure, reconciled against the bank deposit amount at each deposit. Cross-checking catches discrepancies indicating possible internal theft.
Frequently Asked Questions
Q: Does the daily audit require the supervisor to count cash from every machine every day?
A: Yes. Fifteen machines with 1-minute per machine cash box count = 15 minutes. The 15 minutes pays for itself the first time an unauthorized credit problem is detected on day 1 instead of day 30. The key is to make the process fast and routine — provide the supervisor with a standardized form or spreadsheet where they enter numbers without having to think about formatting.
Q: What if the supervisor falsifies the daily audit numbers to cover for their own involvement in a cheating ring?
A: This is the reason for the weekly manager review with cross-machine comparison. A supervisor can falsify individual daily numbers, but falsifying the pattern — the trend that emerges across 7 days of daily numbers, plus the comparison to bus monitor data from an independent system — is much harder. Bus monitor data is particularly powerful because the supervisor cannot modify it — the bus monitor records data automatically without human access to modify stored records. If bus monitor data shows unauthorized credits at specific times but the supervisor’s daily audit shows normal ratios on those same days, the contradiction immediately identifies the falsification.