Systems and methods for reconciling lottery transactions

A system for reconciling lottery transactions comprising:

• a plurality of individual point-of-sale (POS) systems at facilities, the POS systems for input of first lottery transaction data for lottery transactions occurring at lottery terminals at the facilities;
• a database communicatively coupled to the plurality of individual POS systems, the database configured to receive, via an internal network, the first lottery transaction data of the individual POS systems, the first lottery transaction data being separated out, by a filter service, from other data of the individual POS systems using a transaction or product identifier;
• a server at the internal network to receive second lottery transaction data from an external network, the external network having received the second lottery transaction data from the lottery terminals but not via the individual POS systems, the server to:
• receive the second lottery transaction data in a third party format from the external network;
• and
• transform, using a data ingestion service, the second lottery transaction data from the third party format to a timestamp indexed tabular format and store it in the database, the second lottery transaction data being transformed to a structured tabular data set to facilitate comparisons and matching;
• a control circuit communicatively coupled to the database, the control circuit to:
• extract first sales data from the first lottery transaction data, the extracted first sales data comprising a first set of sales amounts for the lottery transactions;
• extract second sales data from the transformed second lottery transaction data, the extracted second sales data comprising a second set of sales amounts for the lottery transactions;
• generate timestamp bounded first and second subsets of sales data to reduce matching comparisons, the first subset of sales data including a first subset of sales amounts and the second subset of sales data including a second subset of sales amounts;
• conduct one-to-many or many-to-one matching by iteratively aggregating different combinations of sales amounts of one of the first subset of sales amounts and the second subsets of sales amounts and comparing the different combinations to individual sales amounts of the other of the first subset of sales amounts and the second subset of sales amounts;
• and
• identify discrepancies between the first subset of sales amounts and the second subset of sales amounts remaining after conducting the one-to-many or many-to-one matching and generate an electronic variance report of the identified discrepancies.