Patent ID: 11972410
Assignee: WALMART APOLLO, LLC
Field: IT methods for management (Electrical engineering)
Classification: CPC G | IPC G

Claim 11:
12. A method for reconciling lottery transactions comprising:
by a plurality of individual point-of-sale (POS) systems at a plurality of retail stores, receiving input of first lottery transaction data for lottery transactions occurring at the retail stores, the lottery transactions corresponding to lottery games being operated by a third party separate from the retail stores;
by a POS server communicatively coupled to the plurality of individual POS systems, receiving the first lottery transaction data of the individual POS systems;
by a retailer server receiving second lottery transaction data from a server of the third party, receiving the second lottery transaction data in a third party format and transforming the second lottery transaction data from the third party format to a standardized retailer format;
by a control circuit communicatively coupled to the POS server and to the retailer server:
extracting sales data from the first lottery transaction data, the extracted sales data comprising a sales amount for each lottery transaction occurring at the retail stores;
extracting sales data from the transformed second lottery transaction data, the extracted sales data comprising a sales amount for each lottery transaction of the transformed second lottery transaction data;
conducting one-to-one matching by comparing individual sales amounts of the first lottery transaction data inputted on the POS systems with individual sales amounts of the transformed second lottery transaction data;
determining whether a discrepancy exists between the first lottery transaction data and the transformed second lottery transaction data based on the one-to-one matching;
conducting one-to-many matching by iteratively aggregating different combinations of sales amounts of transformed second lottery transaction data and comparing individual sales amounts of first lottery transaction data inputted on the POS systems with the different combinations of aggregated sales amounts of transformed second lottery transaction data;
determining whether a discrepancy exists between the first lottery transaction data and the transformed second lottery transaction data based on the one-to-many matching; and
generating a report of any identified discrepancies.