Computer methods and computer systems for automatic data analysis, reconcilliation and repair

摘要

In some embodiments, the instant invention includes a computer-implemented method that includes: specifically programming at least one computer system to perform: automatically obtaining input financial data; automatically determining units of work that the input financial data can be organized into; automatically importing the input financial data into a database based on the units of work; automatically validating the imported input financial data, by: identifying deficient units of work based on predefined rules, where each deficient unit of work has a current data error; analyzing, based on research information, the current data error to determine a current corrective action to remedy the current data error; and verifying that the current corrective action does not result in: an additional deficient unit of work, an additional data error, and a change in at least one predefined data report; and automatically executing the current corrective action to remedy the current data error.

主权项

1. A computer-implemented method, comprising:
automatically obtaining, by at least one specifically programmed computer processor, via a computer network, input financial data from at least one electronic source, wherein the input financial data is related to a plurality of financial transactions regarding stocks, a plurality of stock-holding accounts, or both; automatically determining, by the at least one specifically programmed computer processor, a first unit of work to be utilized to electronically import the input financial data, wherein the first unit of work is a stock-based unit of work or an account-based unit of work; wherein the stock-based unit of work identifies that a first type of database objects to be utilized to hold the input financial data; wherein the account-based unit of work identifies that a second type of database objects to be utilized to hold the input financial data; wherein the first type of database objects are distinct from the second type of database objects; automatically importing, by the at least one specifically programmed computer processor, the input financial data into the first type of database objects or the second type of database objects based on the first unit of work to form imported input financial data; automatically subdividing, by the at least one specifically programmed computer processor, the imported input financial data into a plurality of second units of work based, at least in part, on:
i) when the first unit of work is the stock-based unit of work, a custodian, a stock identifier, and a mutual fund code identifier, orii) when the first unit of work is the account-based unit of work, the custodian and an account number;wherein each second unit of work comprises a plurality of database records having plurality of data fields; automatically validating, in real-time, by the at least one specifically programmed computer processor, the plurality of second units of work via at least one programmed validation engine object to form a plurality of validated second units of work;
wherein the at least one programmed validation engine object comprises a plurality of predefined rules, comprising:
i) at least one first predefined rule selected from stock position reconciliation validation rules,ii) at least one second predefined rule selected from custodian cash balance reconciliation validation rules,iii) at least one third predefined rule selected from data element validation rules,iv) at least one fourth predefined rule selected from stock identifying information validation type rules, andv) at least one fifth predefined rule selected from custodian posting consideration validation rules;wherein the automatically validating comprises:
analyzing each filed of each database record of each second unit of work;identifying a plurality of deficient second units of work, wherein a particular deficient second unit of work has at least one first current data error in at least one first data field, designated as at least one first deficient data field, in at least one first database record;analyzing, based at least in part on research information in at least one first research database, the at least one first current data error to determine a presence of at least one first current corrective action to remedy the at least one first current data error or an absence of the at least one first current corrective action, wherein the research information comprises historical information about at least one first previous data error and at least one first previous corrective action that remedied the at least one first previous data error;1) when the at least one first current corrective action is present:
verifying that the at least one first current corrective action does not result in one of: i) at least one additional deficient unit of work, ii) at least one additional data error, and iii) at least one change in at least one predefined data report; andautomatically executing, the at least one first current corrective action to remedy the at least one first current data error in the at least one deficient data field of the at least one first database record to form a particular validated second unit of work from the particular deficient second unit of work; and2) when the at least one first current corrective action is absent:
selectively withhold the at least one first deficient data field from the at least one first database record to form the particular validated second unit of work from the particular deficient second unit of work; and causing, by the at least one specifically programmed computer processor, via the computer network, to post the plurality of validated second units of work to at least one data storage object of the at least one electronic source.