System and method for electronic data reconciliation and clearing
First Claim
1. A method for reconciling and associating electronic transport information associated with transport of a commodity and electronic destination information associated with a destination of the transported commodity, and generating, as a function of the association, output information that is usable by an external system, the method comprising:
- normalizing, by at least one processor executing code, at least some of the electronic transport information and the electronic destination information, wherein each of the electronic transport information and the electronic destination information originates from a different respective computing device and is automatically imported by the at least one processor, further wherein the step of normalizing includes;
applying at least one rule to extract the at least some of the electronic transport information and the electronic destination information;
designating a respective document type for each of the electronic transport information and the electronic destination information, each document type associated with a respective corresponding document schema;
identifying at least the source of the electronic transport information to determine a first custom parser of a plurality of custom parsers for extracting the electronic transport information;
identifying at least the source of the electronic destination information to determine a second custom parser of a plurality of custom parsers for extracting the electronic destination information;
extracting, using the first custom parser, the electronic transport information and storing the extracted electronic transport information in a respective first document schema;
extracting, using the second custom parser, the electronic destination information and storing the extracted electronic destination information in a respective second document schema;
automatically executing, by the at least one processor, respective mapping rules contained in each of the respective first and second document schemas, wherein the mapping rules, when executed, enrich the electronic information in the respective first and second document schemas with additional information;
reconciling, by the at least one processor, the normalized and enriched electronic transport and destination information by;
comparing normalized and enriched information from any one document schema to normalized and enriched information from any other document schemas;
executing match rules to determine that at least some of the normalized and enriched information from the any one document schema is inside or outside of a pre-defined tolerance with respect to the normalized and enriched information in the any other document schemas; and
associating, by the at least one processor, at least some of the normalized and enriched information in one of the document schemas with the normalized and enriched information in at least one other of the document schemas;
generating, by the at least one processor, output information to be used by an external system, wherein the generated output information includes at least some reference data received from the external system, and at least some information from the one of the document schemas and/or the at least one other of the document schemas; and
transmitting, by the at least one processor, the generated output information to the external system.
1 Assignment
0 Petitions
Accused Products
Abstract
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.
-
Citations
20 Claims
-
1. A method for reconciling and associating electronic transport information associated with transport of a commodity and electronic destination information associated with a destination of the transported commodity, and generating, as a function of the association, output information that is usable by an external system, the method comprising:
normalizing, by at least one processor executing code, at least some of the electronic transport information and the electronic destination information, wherein each of the electronic transport information and the electronic destination information originates from a different respective computing device and is automatically imported by the at least one processor, further wherein the step of normalizing includes; applying at least one rule to extract the at least some of the electronic transport information and the electronic destination information; designating a respective document type for each of the electronic transport information and the electronic destination information, each document type associated with a respective corresponding document schema; identifying at least the source of the electronic transport information to determine a first custom parser of a plurality of custom parsers for extracting the electronic transport information; identifying at least the source of the electronic destination information to determine a second custom parser of a plurality of custom parsers for extracting the electronic destination information; extracting, using the first custom parser, the electronic transport information and storing the extracted electronic transport information in a respective first document schema; extracting, using the second custom parser, the electronic destination information and storing the extracted electronic destination information in a respective second document schema; automatically executing, by the at least one processor, respective mapping rules contained in each of the respective first and second document schemas, wherein the mapping rules, when executed, enrich the electronic information in the respective first and second document schemas with additional information; reconciling, by the at least one processor, the normalized and enriched electronic transport and destination information by; comparing normalized and enriched information from any one document schema to normalized and enriched information from any other document schemas; executing match rules to determine that at least some of the normalized and enriched information from the any one document schema is inside or outside of a pre-defined tolerance with respect to the normalized and enriched information in the any other document schemas; and associating, by the at least one processor, at least some of the normalized and enriched information in one of the document schemas with the normalized and enriched information in at least one other of the document schemas; generating, by the at least one processor, output information to be used by an external system, wherein the generated output information includes at least some reference data received from the external system, and at least some information from the one of the document schemas and/or the at least one other of the document schemas; and transmitting, by the at least one processor, the generated output information to the external system. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 19)
-
10. A system for reconciling and associating electronic transport information associated with transport of a commodity and electronic destination information associated with a destination of the transported commodity, and generating, as a function of the association, output information that is usable by an external system, the system comprising:
-
non-transitory processor readable media; at least one processor operatively coupled to the at least one processor readable media; the non-transitory processor readable media having instructions for causing the following steps to be performed by the at least one processor; normalizing, by at least one processor executing code in, at least some of the electronic transport information and the electronic destination information, wherein each of the electronic transport information and the electronic destination information originates from a respective computing device and is automatically imported by the at least one processor, further wherein the step of normalizing includes; applying at least one rule to extract the at least some of the electronic transport information and the electronic destination information; designating a respective document type for each of the electronic transport information and the electronic destination information, each document type associated with a respective corresponding document schema; identifying at least the source of the electronic transport information to determine a first custom parser of a plurality of custom parsers for extracting the electronic transport information; identifying at least the source of the electronic destination information to determine a second custom parser of a plurality of custom parsers for extracting the electronic destination information; extracting, using the first custom parser, the electronic transport information and storing the extracted electronic transport information in a respective first document schema; extracting, using the second custom parser, the electronic destination information and storing the extracted electronic destination information in a respective second document schema; automatically executing, by the at least one processor, respective mapping rules contained in each of the respective first and second document schemas, wherein the mapping rules, when executed, enrich the electronic information in the respective first and second document schemas with additional information; reconciling, by the at least one processor, the normalized and enriched electronic transport and destination information by; comparing normalized and enriched information from any one document schema to normalized and enriched information from any other document schemas; executing match rules to determine that at least some of the normalized and enriched information from the any one document schema is inside or outside of a pre-defined tolerance with respect to the normalized and enriched information in the any other document schemas; and associating, by the at least one processor, at least some of the normalized and enriched information in one of the document schemas with the normalized and enriched information in at least one other of the document schemas; generating, by the at least one processor, output information to be used by an external system, wherein the generated output information includes at least some reference data received from the external system, and at least some information from the one of the document schemas and/or the at least one other of the document schemas; and transmitting, by the at least one processor, the generated output information to the external system. - View Dependent Claims (11, 12, 13, 14, 15, 16, 17, 18, 20)
-
Specification