Systems and methods for reconciliation of various lottery transactions
Described are systems, methods, and computer readable medium for a lottery reconciliation system. Exemplary embodiments provide systems, methods, and computer readable medium for reconciling online lottery game transactions. Exemplary embodiments also provide systems, methods, and computer readable medium for reconciling instant lottery game transactions. Exemplary embodiments also provide systems, methods, and computer readable medium for reconciling lottery game transaction at an interactive vending machine.
1. A system comprising:
an application server;
a reconciliation server in communication with the application server; and
a point-of-sale (POS) server in communication with the reconciliation server, the application server, reconciliation server and POS server controlled by an entity affiliated with a plurality of POS systems;
wherein the application server includes a-data transformation instructions that when executed cause the application server to:
receive lottery transaction data from a third-party server on a daily basis, the lottery transaction data received as a text file and including data on individual lottery transactions,
process and convert the lottery transaction data to table data, and
transmit the table data to the reconciliation server;
wherein the point-of-sale (POS) server includes extraction instructions that when executed cause the POS server to:
extract lottery sales data from the plurality of POS systems located at a plurality of locations,
store the extracted lottery sales data from the plurality of locations in a database controlled by the entity, and
transmit the extracted lottery sales data to the reconciliation server; and
wherein the reconciliation server is remotely located from the plurality of POS systems and includes reconciliation instructions that when executed cause the reconciliation server to:
automatically perform a daily reconciliation of the table data and the lottery sales data,
determine, based on the daily reconciliation, whether discrepancies exist between the table data and the sales data, and
generate a record of any determined discrepancies.
2. The system of claim 1 , wherein the lottery transaction data relates to individual purchased online lottery tickets.
3. The system of claim 1 , wherein the lottery transaction data relates to individual redeemed online lottery tickets.
4. The system of claim 1 , further comprising a POS device configured to:
generate the lottery sales data when a user scans an online lottery ticket at the POS device.
5. The system of claim 1 , wherein the application server, the POS server, and the reconciliation server are in communication with an internal corporate network.
6. The system of claim 5 , wherein the third-party server is not connected to the internal corporate network and transmits the lottery transaction data to the application server across a firewall associated with the internal corporate network.
7. A method comprising:
receiving lottery transaction data from a third-party server at an application server on a daily basis, the lottery transaction data received as a text file and including data on individual lottery transactions;
processing and converting the lottery transaction data to table data at the application server;
transmitting the table data to a reconciliation server, the application server and reconciliation server controlled by an entity affiliated with a plurality of POS systems;
extracting lottery sales data from the plurality of POS systems located at a plurality of locations;
storing the extracted lottery sales data from the plurality of POS systems at the plurality of locations in a database controlled by the entity;
transmitting the extracted lottery sales data to the reconciliation server;
automatically perform a daily reconciliation of the table data and the lottery sales data at the reconciliation server;
determining, based on the daily reconciliation, whether discrepancies exist between the table data and the sales data; and
generating a record of any determined discrepancies.
8. The method of claim 7 , wherein the lottery transaction data relates to individual purchased online lottery tickets.
9. The method of claim 7 , wherein the lottery transaction data relates to individual redeemed online lottery tickets.