Lottery Reconciliation Summary Report
Lottery Reconciliation Summary Report
The Lottery Reconciliation Summary Report lists lottery reconciliation details, listing the games with their
starting/ending numbers and any variances for locations based on the filter and
date range.
1. Reaching the Lottery Reconciliation Summary Report
To reach the Lottery Reconciliation Summary Report, follow the below steps:
Step 1: Log into Control Center
Step 2: Choose Point of Sale
Step 3: Choose Reports
Step 4: Choose Lottery Report
Step 5: Choose Lottery Reconciliation Summary
See Figure A. You will see many types of lottery reports that will be useful to your retail business. By clicking the drop-down selection, you will see the different types of lottery reports.
Figure A
You will see the "Report Data is Empty" message initially. You need to select the date range to check the Lottery Reconciliation Summary Report in the report. See Figure B.
Figure B
2. Generating the Lottery Reconciliation Summary Report
When you navigate to the Lottery Reconciliation Summary Report page, you will see the options pre-selected by default. You can generate the report for the selected date range.
Figure C
Fields:
- Game #: This column will display the game number that is associated with the lottery ticket configured in the lottery game module. See Figure D.
- Game Name: Here, the name of the game is mentioned in this column defined in the lottery game module. See Figure D.
Figure D
- Expected Start: This column displays the expected start number of the lottery ticket post-sales. Suppose the store you are in handles lottery tickets in ascending order, and the end # is 5, then the expected start would be 5.
- Diff: This column displays the difference (if any) between the end # and expected start.
- Start: The start value of the ticket would depend on whether your store handles the tickets in ascending or descending order. If the order is ascending, the start # would be 1, and if the order is descending, then the start # would be 100 (last to first, depending upon the total number of tickets in the bin).
- End: The end value of the ticket would depend on whether your store handles the tickets in ascending or descending order. If the order is ascending, the end # would be 100 (the last number of tickets depending upon the total number of tickets in the bin), and if the order is descending, then the end # would be 1.
- QOH: This column will display the number of tickets left at the store for the adjacent game # and game name.
- Total: This column displays the total number of tickets sold.
- Price: The selling price of one ticket is mentioned in this column.
- Total $: This column will display the total dollars as the number of tickets sold X price of one ticket. Here, the price of 1 ticket is $15.60, and if the total number of tickets is 2, then the Total $ value is $31.20.
- Reg Sales: This column displays the number of tickets sold that the system is keeping track of. For example, if the store is handling lottery tickets in ascending order and the value in end # is 6, then the register sales value would be 5 since that many tickets are sold.
- Reg Total: This column will display the Reg sales X price of one ticket. Here, if the price of 1 ticket is $3.00 and the Reg Sales value is 373, the Register Total value will be $1,119, As seen for Game # 12 in Figure C above.
- Variance: This column displays the variance between the end # and reg sales. If there is any discrepancy in the values, it is displayed here.
- Variance Total: The total price of the variance is mentioned under the variance total corner.
3. Date Range & Presets
You can filter your sales data in the report by selecting the date range as well as specific times.
By clicking the edit box, you will be taken to a tiny calendar where you can select a specific date range. You can also manually enter the date in mm/dd/yyyy format.
Figure E
1. Start Date: This field lets you choose the start date for the date range.
Figure F
2. End Date: This field lets you choose the end date for the date range.
Figure G
3. Presets: The Presets label is provided to select the specific duration/interval to generate the report with that.
Figure H
4. Store
To display the "Lottery Reconciliation Summary Report" for a specific location, select the store location from the associated "Store" field.
Figure I
5. Group By
This filter displays the report by grouping it by Register Z number.
Figure J
5.1. None: This option is selected by default and doesn't affect the general details of the report.
5.2. Reg Z: If this option is selected, the report will be displayed grouped by Register Z.
Figure K
Related Articles
Lottery Starting Change Report
Lottery Starting Change Report The "Lottery Starting Change Report" lists details when a lottery starting ticket is changed manually by an employee during a lottery reconciliation (not letting it start with the previous reconciliation’s ending ...Shift Reconciliation Variance Report
Shift Reconciliation Variance Report The Shift Reconciliation Variance Report will display the list of products showing variance after the completion of a shift reconciliation. The system will display the products with variance, which took place only ...Lottery Reconciliation Settings
Lottery Reconciliation Settings These setting options are account-level settings that will help you configure settings related to lottery reconciliation, options for employees, and how the system should function overall. Reaching "Lottery ...Lottery Safe Movement Report
Lottery Safe Movement Report Overview The Lottery Safe Movement Report is designed to monitor lottery-safe activities and display information such as Register #, Z #, Lottery Game Names, Product UPC, Safe Values Before and After, the Employee Names ...Lottery Accounting Report
Lottery Accounting Report Overview Lottery Accounting Report lists lottery pay-out totals based on the department assigned, listing totals and receipts with dollar amounts to match. 1. Reaching the Lottery Accounting Report To reach the Lottery ...