Systems and methods for reconciliation of various lottery transactions

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.