Patent ID: 7895094

Claim:
A method, comprising: transmitting, by a computer based system for managing financial data, a standardized template for capturing remote financial data and a customization tool to a plurality of remote terminals, wherein the standardized template is operable on a plurality of operating systems; creating, by the computer based system, a customized template at the remote terminal, wherein the standardized template is customized with the customization tool to create a customized template, and wherein at least one of the standardized template and the customized template is associated with a financial data system at each of the remote terminals; transmitting, by the computer based system, a request for financial data to the plurality of remote terminals, wherein each of the remote terminals extracts data from the financial data system to at least one the standardized template and the customized template, in response to the request for financial data, and wherein data from each of the remote terminals is extracted to at least one of the standardized template and the customized template at each of the remote terminals; converting, by the computer based system, the remote financial data from a second format to a first format via the standardized template at a first remote terminal, wherein the first remote terminal stores remote financial data in the second format which is receivable by the standardized template; converting, by the computer based system, the remote financial data from a third format to a first format via the customized template at a second remote terminal, wherein the second remote terminal stores remote financial data in the third format which is receivable by the customized template; receiving, by the computer based system, the remote financial data from the plurality of remote terminals via the standardized template and the customized template, wherein the remote financial data is received in the first format; matching, by the computer based system, the remote financial data from the standardized template and the customized template to master financial data based on a set of predetermined rules, wherein the master financial data is stored in a first format; identifying, by the computer based system, an un-reconciled amount based on the matching; analyzing, by the computer based system, the un-reconciled amount; determining, by the computer based system, a classification of the un-reconciled amount; transmitting, by the computer based system, a notification in response to the classification of the un-reconciled amount; processing, by the computer based system, the un-reconciled amount based on the classification; and updating, by the computer based system, the master financial data based on the remote financial data.