Lottery Accounting Report - Store Employee

Lottery Accounting Report - Store Employee

Lottery Accounting Report Overview 

In the FTx Cloud POS system, the Lottery Accounting Report is a financial summary that helps track and reconcile lottery ticket sales, pay-outs, inventory, and cash flow related to lottery transactions within the store. The "Lottery Accounting Report" gives visibility into lottery sales performance. 

This article includes information about: 
  1. How to generate the "Lottery Accounting Report" for the selected date range
  2. How to apply filter options to customize the report
  3. How to automate (schedule) or print a report
  4. How to mark the report as a favorite report 

1. Reaching the "Lottery Accounting Report"

  1. Step 1: Log into Control Center
  2. Step 2: Choose Location
  3. Step 3: Choose Reports
  4. Step 4: Choose Lottery Reports
  5. Step 5: Choose Lottery Accounting Report
Figure 1.1 below will help you better understand the navigation. 
                                                                                    Figure 1.1

2. Understanding the "Lottery Accounting Report" Layout

See Figure 2.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 2.1

3. Generating the "Lottery Accounting Report"

When you navigate to the "Lottery Accounting Report" page, you will see the current date selected by default. You can generate the report for the selected date range.

                                                                            Figure 3.1                                                                      
Report Information:

1. Lottery Department Info:

  1. Department Name: Lottery tickets are treated as regular store items and are assigned to a dedicated lottery department.
  2. Total: Displays the total retail value of all lottery tickets under this department.
  3. Quantity: Indicates the total number of lottery tickets available in the store.
  4. Cost: Shows the total purchase cost of the lottery tickets.
2. Pay Out Info:
  1. Receipt: Lists the receipt number associated with each lottery payout.
  2. Time Stamp: Records the date and time when the payout was made.
  3. Description: Provides a brief description of the payout transaction.
  4. Value: Displays the payout amount for the lottery transaction.
3. Online Lottery Info:
  1. Online Sales: Total amount and number of online lottery tickets sold. This gives you a clear picture of how much revenue was generated from online lottery sales.
  2. Online Cancels: Total value and count of canceled online lottery transactions. 
    Info
    The total value and count of transactions where online tickets were canceled (voided or refunded). Canceled sales reduce your net revenue, so tracking this helps you reconcile totals and catch anomalies.
  3. Online Cashes: The total amount paid out and the number of tickets cashed in by customers who won from online games. This represents money that leaves your till. It's essential for balancing your books and preventing fraud.
  4. Promo Credit: Value and count of promotional credits applied to online lottery purchases. These are not direct cash sales, so they don’t contribute to revenue but affect net accounting. Useful for marketing analysis, too.
  5. Balance: The net result after accounting for sales, cancellations, cash, and credit.
  6. Instant Validations: The count and value of physical instant-win (scratch-off) tickets validated through the POS system.
  7. Instant Activations: The total number and dollar value of new scratch-off (instant) ticket rolls activated for sale
  8. Net Sales/Credit: A final calculation showing your true net earnings after subtracting all non-revenue activities (like cancellations and credits) from gross sales.

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

4. Scheduling a Report

FTx Cloud POS supports report automation, allowing you to configure and schedule a report. The system will then send the scheduled report to the designated email addresses at the specified frequency (daily, weekly, bi-weekly, monthly, quarterly, etc.). 

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

5. 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. 

6. Manage Favorites 

FTx Cloud POS provides quick access to frequently viewed reports through the "Favorite Reports" feature. You can save a report as a favorite and manage all your favorites from any report screen using the "Manage Favorites" button. 

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

    • Related Articles

    • 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 ...

    • Lottery Safe Report - Store Employee

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

    • Lottery Safe Movement Report - Store Employee

      Lottery Safe Movement Report Overview The Lottery Safe Movement Report provides detailed tracking of all lottery-related movements involving the store safe. It captures key information such as the register number, Z report number, lottery game name, ...

    • Lottery Game Bin Assignment Report - Store Employee

      Lottery Game Bin Assignment Report Overview The "Lottery Game Bin Assignment Report" shows store employees exactly which lottery games are placed in which bins at their location. It lists each bin number along with the assigned game, making it easy ...

    • Lottery Reconciliation Summary Report - Store Employee

      Lottery Reconciliation Summary Report Overview The "Lottery Reconciliation Summary Report" provides a comprehensive overview of lottery activity across selected locations, based on the chosen filters and date range. It includes detailed information ...