Core reconciliation system with cross-platform data aggregation and validation

A method for performing cross-system verification across disparate systems to identify and resolve discrepancies with a core reconciliation device, the method comprising:

• interfacing with one or more independent systems;
• generating an order of operations for a data scraping process based on the one or more independent systems, wherein the generated order of operations optimizes for at least one of a reduced number of logins or a reduced number of page loads;
• gathering a plurality of data points from one or more data stores associated with a plurality of the one or more independent systems based on the generated order of operations, wherein each of the plurality of data points includes a respective data value;
• parsing the plurality of data points from the one or more data stores to prepare the corresponding data values for processing one or more discrepancies that include inaccurate or out-of-sync data values between the plurality of one or more independent systems;
• validating that each data value from each data point from each data store of a plurality of the one or more data stores matches with other data values from the other data points from a plurality of the other data stores;
• determining whether there are one or more discrepancies within the plurality of data points;
• flagging each of the one or more discrepancies as a validation item for review;
• generating a plurality of exception items based on the flagged validation items for data reconciliation;
• inputting the plurality of generated exception items into a processor assignment queue, and queuing the plurality of generated exception items into one or more processor groups to be reviewed in the processor assignment queue;
• wherein each of the one or more processor groups is configured to be a computer external to the core reconciliation device;
• wherein each of the one or more plurality of generated exception items is configured for at least two of the following by a user of the one or more processor groups:
• being reviewed within the processor assignment queue, being resolved in the processor assignment queue, or being reassigned to another one or more processor groups;
• and
• wherein the core reconciliation device is configured to build a validation case query based on an update of the plurality of data points or validation of the plurality of data points, and schedule when the validation case query runs.

A core reconciliation system for performing cross-system verification across disparate systems to identify and resolve discrepancies, the system comprising:

• one or more core reconciliation devices communicatively coupled to one or more independent systems;
• one or more processors coupled to the one or more reconciliation devices;
• and
• a non-transitory computer-readable storage medium for storing instructions that, when executed by the one or more processors, cause the one or more processors to:
• interface with the one or more independent systems;
• generate an order of operations for a data scraping process based on the one or more independent systems, wherein the generated order of operations optimizes for at least one of a reduced number of logins or a reduced number of page loads;
• gather a plurality of data points from one or more data stores within a plurality of the one or more independent systems, wherein each of the plurality of data points includes a respective data value;
• parse the plurality of data points from the one or more data stores to prepare the corresponding data values for processing one or more discrepancies that include inaccurate or out-of-sync data between the plurality of one or more independent systems;
• validate that each data value from each data point from each data store of a plurality of the one or more data stores matches with other data values from the other data points from other data stores of a plurality of the other data stores;
• determine whether there are one or more discrepancies within the plurality of data points;
• flag each of the one or more discrepancies as a validation item for review;
• generate a plurality of exception items based on the flagged validation items for data reconciliation;
• input the plurality of generated exception items into a processor assignment queue, and queue the plurality of generated exception items into one or more processor groups to be reviewed in the processor assignment queue;
• wherein each of the one or more processor groups is configured to be a computer external to the core reconciliation system;
• wherein each of the one or more plurality of generated exception items is configured for at least two of the following by a user of the one or more processor groups:
• being reviewed within the processor assignment queue, being resolved in the processor assignment queue, or being reassigned to another one or more processor groups;
• and
• wherein the core reconciliation system is configured to build a validation case query based on an update of the plurality of data points or validation of the plurality of data points, and schedule when the validation case query runs.