Skip to content
English - Australia
Contact Support
  • There are no suggestions because the search field is empty.

Investigating Gaming Variances - S7000

Please refer to our Knowledgebase article for instructions on how to enter data from S7000 correctly here: Gaming Daily Data Entry - S7000

Step 1: Run the NSW Pub Activity Report with the Correct Filters

Before investigating the variances in Cashup, ensure the NSW Pub Activity report is configured with the correct filters:

  1. Group By: Set to None
    This removes any grouping and ensures you are working with the overall data.

  2. Report Type: Select Summary
    This provides a high-level summary of key metrics, ideal for comparing against Cashup data.

  3. Include P2P: Set to True
    Make sure Player-to-Player (P2P) transactions are included to ensure all data points are captured accurately.

Step 2: Verify the Metered NET Profit calculation in Cashup

After running the report, check the Metered NET Profit value in the Cashup application. The value in Cashup should match the following:

  • Columns A-B-E, minus any value that appears in Linked Payouts (if applicable).
    In this example A-B-E ($11,209.01) - Linked Payouts ($5,208.60) 
    = $6,000.41 / Matches Metered NET calculation in Cashup

Step 3: Verify Actual Net Profit Value in Cashup

After running the report, check the Actual Net Profit value in the Cashup application. The value in Cashup should match the following:

  • Columns C-F-G+H, minus the reversed value of Unclaimed Movements.

  • If there is a Linked Payout value present, deduct this amount from the value that appears in Column C-F-G+H when crosschecking these figures.

    In this example C-F-G+H  ($11,209.15) - Unclaimed ($0.04) - Linked Payouts ($5,208.60)
    = $6,000.51 / Matches Actual Net calculation in Cashup


 

Troubleshooting Tips

If the above comparison calculations do not match the expected value, consider these potential causes:

  1. Ensure data has been entered as per:
    Gaming Daily Data Entry - S7000
    How to record CRT payouts & refills
    How to record CCU payouts & refills
    How to record AutoPay CCU payouts & refills

  2. Mismatch in Report Filters: Double-check that the filters for the NSW Pub Activity report (Group By, Report Type, Include P2P) are correctly set. Any incorrect filter settings can lead to discrepancies when validating the data via the above method.

  3. Time Period Mismatch: Ensure that the period in the NSW Pub Activity report matches the relevant timeframe in the Cashup application. Discrepancies in reporting periods can cause mismatched values.

  4. Unaccounted Linked Payouts: Ensure all Linked Payouts are properly accounted for in Cashup and your gaming systems and are included in your analysis.

  5. CCR Variance Discrepancies: If the Unclaimed Movements total does not match the CCR Variance on the NSW Cash Flow Analysis report, recheck the report for errors or missing data. 

  6. Ensure all EFT / Cheque Payouts have been entered into Cashup.

  7. Make sure there is no duplication of values entered into Cashup under the Payout fields.

    1. Example 1: If a CRT Short Pay occurs, the short pay amount should not be included in the CRT Payouts if it has already been entered as a manual CCU Cash Payout.
    2. Example 2: For an EFT payment, ensure that the EFT amount does not overlap with any Cash Payout totals, especially if the payment was split. Manual Cash Payout amounts should be entered separately in the CCU/AutoPay Cash Payout fields.