| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | MONTH / YEAR | TAX TEMPLATE | ||||||||||||||||||||||||
2 | LICENSE # | |||||||||||||||||||||||||
3 | CASINO NAME | |||||||||||||||||||||||||
4 | PREPARED BY | |||||||||||||||||||||||||
5 | DATE COMPLETED | |||||||||||||||||||||||||
6 | REVIEWED BY (2nd Level Review) | |||||||||||||||||||||||||
7 | DATE REVIEWED | |||||||||||||||||||||||||
8 | ||||||||||||||||||||||||||
9 | ||||||||||||||||||||||||||
10 | RECONCILIATION OF SLOT MACHINE STATISTICAL REPORTS | |||||||||||||||||||||||||
11 | ||||||||||||||||||||||||||
12 | STEP 1: THE FOLLOWING WORKSHEET WILL ASSIST IN TYING OUT ALL STATISTICAL REPORTS. ENTER THE REQUESTED INFORMATION IN THE YELLOW BOXES. VARIANCES AND ERRORS WILL APPEAR IN RED. CORRECT ANY ERRORS. REMAINING VARIANCES MUST BE EXPLAINED. THE DATA WILL AUTOMATICALLY FLOW TO THE CALCULATION CHART. | |||||||||||||||||||||||||
13 | ||||||||||||||||||||||||||
14 | Drop | |||||||||||||||||||||||||
15 | Denomination | Weighted Avg. # of Units | Coin-In | Drop (Bill & Coin) | Ticket & Slot Coupon Drop | Electronic-In | Slot Tournament AGP | |||||||||||||||||||
16 | MSRS | Theoretical Hold | MSRS | Drop Comparison | Theoretical Hold | General Ledger | MSRS | Ticket-In Comparison + Purchase Tickets | Theoretical Hold | General Ledger | Electronic-In Comparison | General Ledger | Slot Tournament Summary | General Ledger | ||||||||||||
17 | 1 Cent | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
18 | 5 Cent | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
19 | 10 Cent | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
20 | 25 Cent | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
21 | 50 Cent | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
22 | 1 Dollar | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
23 | 2 Dollar | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
24 | 5 Dollar | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
25 | 10 Dollar | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
26 | 25/50 Dollar | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
27 | 100 Dollar | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
28 | Greater Than $100 | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
29 | Multi-Denom | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
30 | TOTAL | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
31 | Investigate and correct all errors noted above and explain any remaining variances in the appropriate section. | |||||||||||||||||||||||||
32 | ||||||||||||||||||||||||||
33 | Payouts | |||||||||||||||||||||||||
34 | Denomination | Payouts (JP, CC & Prog.) | Tickets Redeemed | Fills | Electronic-Out | Jackpot Adjustments* | Hopper Adj** | |||||||||||||||||||
35 | MSRS | Jackpot Comparison | Theoretical Hold | General Ledger | MSRS | General Ledger | MSRS | Theoretical Hold | General Ledger | Electronic-Out Comparison | General Ledger | Overpaid/ Unclaimed Jackpots | Paid Unclaimed Jackpots | Jackpot Adjustments Total | MSRS | |||||||||||
36 | 1 Cent | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
37 | 5 Cent | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
38 | 10 Cent | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
39 | 25 Cent | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
40 | 50 Cent | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
41 | 1 Dollar | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
42 | 2 Dollar | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
43 | 5 Dollar | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
44 | 10 Dollar | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
45 | 25/50 Dollar | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
46 | 100 Dollar | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
47 | Greater Than $100 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
48 | Multi-Denom | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
49 | TOTAL | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
50 | Investigate and correct all errors noted above and explain any remaining variances in the appropriate section. | * Jackpot Adjustments will only be completed if overpaid and/or unclaimed jackpots are included in drop period statistical reports. | ||||||||||||||||||||||||
51 | ** If the hopper amount was MORE than the initial fill, enter the adjustment as a POSITIVE number. If the hopper amount was LESS than the initial fill, enter the adjustment as a NEGATIVE number. | |||||||||||||||||||||||||
52 | ||||||||||||||||||||||||||
53 | Statewide | Tickets Issued | AGP | Prior Period Adj | Electronic Promotional Credits: Slots, Tables & Casino Games | |||||||||||||||||||||
54 | Denomination | Statewide Contributions | Statewide Secondaries | Theoretical Hold | Ticket-Out Comparison | Tickets Issued section is for reconciliation purposes only, will not be used on Tax Return. | AGP | PPA*** | ||||||||||||||||||
55 | Vendor Report | Paid by Casino | ||||||||||||||||||||||||
56 | 1 Cent | 0.00 | 0.00 | 0.00 | 0.00 | Slot EPC | 0.00 | |||||||||||||||||||
57 | 5 Cent | 0.00 | 0.00 | 0.00 | 0.00 | Prior Period Adj | 0.00 | |||||||||||||||||||
58 | 10 Cent | 0.00 | 0.00 | 0.00 | 0.00 | Total Slots EPC | 0.00 | |||||||||||||||||||
59 | 25 Cent | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||||||||||
60 | 50 Cent | 0.00 | 0.00 | 0.00 | 0.00 | Table EPC | 0.00 | |||||||||||||||||||
61 | 1 Dollar | 0.00 | 0.00 | 0.00 | 0.00 | Prior Period Adj | 0.00 | |||||||||||||||||||
62 | 2 Dollar | 0.00 | 0.00 | 0.00 | 0.00 | Total Table EPC | 0.00 | |||||||||||||||||||
63 | 5 Dollar | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||||||||||
64 | 10 Dollar | 0.00 | 0.00 | 0.00 | 0.00 | Casino Games EPC | 0.00 | |||||||||||||||||||
65 | 25/50 Dollar | 0.00 | 0.00 | 0.00 | 0.00 | Prior Period Adj | 0.00 | |||||||||||||||||||
66 | 100 Dollar | 0.00 | 0.00 | 0.00 | 0.00 | Total Casino Games EPC | 0.00 | |||||||||||||||||||
67 | Greater Than $100 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||||||||||
68 | Multi-Denom | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | Total EPC | 0.00 | |||||||||||||||||
69 | TOTAL | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||||||||
70 | Investigate and correct all errors noted above and explain any remaining variances in the appropriate section. | The Adjusted Gross Proceeds (AGP) may be different on the MSRS, Theoretical Hold Report and the Tax Return. The different amounts may be a result of unredeemed tickets (liability), hopper adjustments, and statewide contributions. | *** If an entry is made in this column, provide an explanation below. Be sure to contact the Division's Chief Auditor to obtain the amount of PPA Interest to be entered on the Tax Return (enter zero if reducing AGP). | |||||||||||||||||||||||
71 | ||||||||||||||||||||||||||
72 | RECONCILIATION OF TABLE GAMES STATISTICAL REPORTS | |||||||||||||||||||||||||
73 | ||||||||||||||||||||||||||
74 | STEP 2: COMPLETE THE FOLLOWING WORKSHEET FOR TABLES GAMES. ENTER THE REQUESTED INFORMATION IN THE YELLOW BOXES. VARIANCES AND ERRORS WILL APPEAR IN RED. CORRECT ANY ERRORS. REMAINING VARIANCES MUST BE EXPLAINED. THE DATA WILL AUTOMATICALLY FLOW TO THE CALCULATION CHART. | |||||||||||||||||||||||||
75 | ||||||||||||||||||||||||||
76 | Game Type | Weighted Avg. # of Tables | Drop | Handpays | Payouts (Total Fill/Credit Adj = Openers + Fills - Closers - Credits) | AGP | PPA*** | |||||||||||||||||||
77 | Master Games Summary Report | Tournament AGP | Total Drop | General Ledger | Handpaid Jackpots | General Ledger | Openers | Fills | Closers | Credits | Total Fill/Credit Adj. | General Ledger | ||||||||||||||
78 | Blackjack | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
79 | Player Banked Poker | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||
80 | House Banked Poker | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
81 | Craps | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
82 | Roulette | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
83 | Baccarat | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
84 | Pai Gow | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
85 | Big 6 Wheel | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
86 | Casino War | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
87 | Other | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
88 | TOTAL | - | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
89 | Investigate and correct all errors noted above and explain any remaining variances in the appropriate section. | *** If an entry is made in this column, provide an explanation below. Be sure to contact the Division's Chief Auditor to obtain the amount of PPA Interest to be entered on the Tax Return (enter zero if reducing AGP). | ||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | RECONCILIATION OF CASINO GAMES STATISTICAL REPORTS | |||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||
93 | STEP 3: COMPLETE THE FOLLOWING WORKSHEET FOR CASINO GAMES. ENTER THE REQUESTED INFORMATION IN THE YELLOW BOXES. VARIANCES AND ERRORS WILL APPEAR IN RED. CORRECT ANY ERRORS. REMAINING VARIANCES MUST BE EXPLAINED. THE DATA WILL AUTOMATICALLY FLOW TO THE CALCULATION CHART. | |||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | Game Type | Game Offered? (YES|NO) | Write | Drop | Payouts (Total Fill/Credit Adj = Openers + Fills - Closers - Credits) | AGP | PPA*** | ||||||||||||||||||||
96 | Master Games Summary Report | General Ledger | Openers | Fills | Closers | Credits | Total Fill/Credit Adj | General Ledger | ||||||||||||||||||
97 | Keno | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||||
98 | Other | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||||
99 | TOTAL | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||||
100 | Investigate and correct all errors noted above and explain any remaining variances in the appropriate section. | *** If an entry is made in this column, provide an explanation below. Be sure to contact the Division's Chief Auditor to obtain the amount of PPA Interest to be entered on the Tax Return (enter zero if reducing AGP). | ||||||||||||||||||||||||