Lottery Accounting Report

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 accurately recorded and reconciled.

This report is a vital tool for tracking and managing lottery-related finances, helping you maintain financial accuracy across departments. It also supports transparency and serves as an effective audit resource for reviewing and verifying all lottery transactions.

This article covers how to access, interpret, and utilize the "Lottery Accounting Report" for financial tracking, reconciliation, and audit preparedness.

1. Reaching the "Lottery Accounting Report"

To reach the "Lottery Accounting Report," follow the steps below: 
  1. Step 1: Log into Control Center
  2. Step 2: Choose Point of Sale
  3. Step 3: Choose Reports
  4. Step 4: Choose Lottery Reports
  5. Step 5: Choose Lottery Accounting Report

2. Understanding the "Lottery Accounting Report"

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

You will see the "Report Data is Empty" message initially. You need to select the date range to check the lottery accounting report in the report. See Figure 2.2.


                                                                                     Figure 2.2

3. Generating the "Lottery Accounting Report"

When you navigate to the "Lottery Accounting Report" page, you will see the options pre-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). Cancelled sales reduce your net revenue, so tracking this helps you reconcile totals and catch anomalies.
  3. Online Cashes: The total amount paid out and 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, cancels, cashes, and credits.
  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 roll activated for sale
  8. Net Sales/Credit: A final calculation showing your true net earnings after subtracting all non-revenue activities (like cancels and credits) from gross sales.

3.1 Store

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

                                                                                Figure 3.2

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

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

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

                                                                                        Figure 3.2.4

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