Lottery Reconciliation Summary Report

Lottery Reconciliation Summary Report

Lottery Reconciliation Summary Report Overview

The "Lottery Reconciliation Summary Report" article provides a comprehensive overview of lottery activity across selected locations, based on the chosen filters and date range. It includes detailed information such as game names, starting and ending ticket numbers, and any variances identified during reconciliation.

This report plays a critical role in maintaining accurate financial records. By capturing data on ticket sales, inventory movement, and discrepancies, it supports the creation of precise financial reports. These insights are essential for evaluating the financial performance of lottery sales, identifying profit and loss trends, and ensuring that all lottery revenue is properly tracked and accounted for.

1. Reaching the "Lottery Reconciliation Summary Report"

To reach the "Lottery Reconciliation Summary Report," follow the below steps:
  1. Step 1: Log into Control Center
  2. Step 2: Choose Point of Sale
  3. Step 3: Choose Reports
  4. Step 4: Choose Lottery Report
  5. Step 5: Choose Lottery Reconciliation Summary Report
Notes
You can also access the Lottery Reports by navigating to Point-of-Sale> Lottery > Lottery Reports from the main menu.

See Figure 1.1. 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 1.1

2. Understanding the "Location Reconciliation Summary Report" Layout

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 2.1


                                                                               Figure 2.1

3. 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 3.1

Fields:
  1. Game #: This column will display the game number that is associated with the lottery ticket configured in the lottery game module. See Figure 3.2.
  2. Game Name: Here, the name of the game is mentioned in this column defined in the lottery game module. See Figure 3.2.

                                                                          Figure 3.2
  1. 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 6.
  2. Diff: This column displays the difference (if any) between the end # and expected start.
  3. 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).
  4. 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.
  5. QOH: This column will display the number of tickets left at the store for the particular game # and game name.
  6. Total: This column displays the total number of tickets sold.
  7. Price: The selling price of one ticket is mentioned in this column.
  8. Total $: This column displays the total amount in dollars, calculated by multiplying the number of tickets sold by the price of a single ticket. It reflects the overall sales value for the respective lottery game.
  9. Reg Sales: This column displays the number of lottery tickets sold, as recorded by the system. It reflects the quantity based on the ticket sequence and sales activity tracked through the register.
  10. Reg Total: This column displays the product of the regular sales quantity and the price of a single ticket. It represents the total sales value recorded at the register for that specific lottery game.
  11. Variance: This column displays the variance between the end # and reg sales. If there is any discrepancy in the values, it is displayed here. 
  12. Variance Total: The total price of the variance is mentioned under the variance total corner.

4. 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 4.1
  1. Start Date: This field lets you choose the start date for the date range.

                                                                            Figure 4.2
  1. End Date: This field lets you choose the end date for the date range.

                                                                      Figure 4.3
  1. Presets: The Presets label is provided to select the specific duration/interval to generate the report with that.

                                                                                    Figure 4.4

5. Store

To display the "Lottery Reconciliation Summary Report" for a specific location, select the store location from the associated "Store" field. 

                                                                                            Figure 5.1                                                                                

6. Group By

This filter displays the report by grouping it by Register Z number.

                                                                                        Figure 6.1
  1. None: This option is selected by default and doesn't affect the general details of the report.
  2. Reg Z: If this option is selected, the report will be displayed grouped by Register Z.

                                                                             Figure 6.2

7. Scheduling a Report

FTx Cloud POS supports report automation. You can configure a report and schedule it. The system will send the scheduled report to the indicated email addresses at the defined frequencies (daily, weekly, biweekly, monthly, quarterly, etc.). 

Please refer to Scheduling a Report to learn how to schedule a report.

8. Printing/Exporting a Report 

You can print or export any report according to your requirements. When you use the Print function, the system creates and opens the report's PDF file in a new tab. You can download the soft copy or print the paper copy according to your requirements. 

Please refer to Printing a Report to learn how to print or export a report. 

9. Manage Favorites 

FTx Cloud POS allows quick access to the reports you need to view frequently through Favorite Reports. You can save a report as a favorite and manage all your favorite reports from any of the report screens using the "Manage Favorites" button. 

Please refer to Managing the Favorite Reports to learn how to manage or export a report. 

    • Related Articles

    • Lottery Safe Report

      Lottery Safe Report Overview The Lottery Safe Report provides a detailed summary of the lottery safe inventory across all stores. It captures key information related to the current books and tickets assigned to each store's lottery safe. This report ...

    • Shift Reconciliation

      Shift Reconciliation Point of Sale -> Reconciliation -> "Shift Reconciliation" About Reconciliation Under FTx POS "Reconciliation" is the process of closing out a shift and recording the physical number (amount) of tenders on hand against the tender ...

    • Shift Reconciliation Variance Report

      Shift Reconciliation Variance Report The "Shift Reconciliation Variance Report" will display the list of products showing a variance after the completion of a shift reconciliation. The system will display the products with a variance that took place ...

    • Lottery Accounting Report

      Lottery Accounting Report Overview The "Lottery Accounting Report" provides a detailed breakdown of lottery payout totals categorized by department. It displays both total amounts and corresponding receipts in dollars, ensuring every transaction is ...

    • Shift Reconciliation

      Shift Reconciliation Overview Reconciliation is the process of closing out a shift and recording the physical tender amounts on hand against the tender amounts recorded by the system. This allows for tracking of any discrepancies between system ...