SYSTEM AND METHOD FOR ELECTRONIC DATA RECONCILIATION AND CLEARING

摘要

Electronic source information is reconciled by normalizing at least some electronic source information, transport information and destination information by applying a plurality of rules to extract the information into at least one schema. At least some of the normalized information is identified to contain at least one discrepancy or missing data record, and reconciliation information is provided in a graphical user interface. Electronic information is received that reconciles the discrepancy or the missing record, and the reconciled and normalized electronic source, transport and destination information is processed to provide data analytics. A report is generated that represents the data analytics and that is output to at least one user. This can occur in one or more implementations of the present application.

主权项

1. A method for reconciling electronic source information associated with a source of a commodity, electronic transport information associated with transport of the commodity and electronic destination information associated with a destination of the transported commodity, the method comprising:
normalizing, by code executing in at least one processor, at least some of the electronic source information, the electronic transport information and the electronic destination information, wherein the step of normalizing includes applying a plurality of rules to extract the at least some of the electronic source information, the electronic transport information and the electronic destination information into at least one schema; processing, by code executing in the at least one processor, at least some of the normalized electronic source information, the normalized electronic transport information and/or the normalized electronic destination information to identify at least one discrepancy or missing record; providing, by code executing in the at least one processor, reconciliation information to identify the at least one discrepancy or missing record in a graphical user interface that provides an on-line collaboration environment for each of a plurality of users; receiving, from a computing device associated with at least one of the source, transport and destination, electronic information that is usable to reconcile the discrepancy or the missing record; reconciling, by code executing in the at least one processor and using the received electronic information, the at least one discrepancy or missing record; processing, by code executing in the at least one processor, the reconciled and normalized electronic source information, the electronic transport information and the electronic destination information to provide data analytics; generating, by code executing in the at least one processor, a report that represents the data analytics; and outputting, by code executing in the at least one processor, the report to at least one user.