System and method for electronic data reconciliation and clearing

• US 10,182,083 B2
• Filed: 02/27/2015
• Issued: 01/15/2019
• Est. Priority Date: 02/27/2014
• Status: Active Grant

• Current Assignee: Commodities Square LLC
• Original Assignee: Commodities Square LLC
• Inventors: Cannon, Tim, Lefebvre, Marc, Drillock, Greg
• Primary Examiner(s): Featherstone, Mark D
• Assistant Examiner(s): Doraiswamy, Ranjit P
• Application Number:
  US14/634,327
• Publication Number:
  US 20150242456A1
• Time in Patent Office: 1,418 Days
• Field of Search: None
• CPC Class Codes: G06Q 10/101 Collaborative creation, e.g. joint development of products or services
• CPC Class Codes: H04L 65/403 Arrangements for multi-party communication, e.g. for conferences data switching systems for conference H04L12/18; arrangements for connecting several subscribers to a common circuit, i.e. affording conference facilities H04M3/56; television conferencing systems H04N7/15

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.

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.

2. The method of claim 1, wherein the at least some of the electronic transport information and the electronic destination information is received in a plurality of respective data formats.

3. The method of claim 1, further comprising transmitting, by the at least one processor, at least some of the normalized electronic transport information and electronic destination information to at least one external system.

4. The method of claim 3, wherein the external system includes at least one of a trade capture system, accounting system, inventory system, dispatching system, regulatory system executing on at least one computing device.

5. The method of claim 1, further comprising:

determining, by the at least one processor, an absolute differential of one transport and/or one destination;

comparing, by the at least one processor, the absolute differential of the one transport and/or one destination to a percentage value representing a plurality of sources, a plurality of transports and/or a plurality of destinations.

6. The method of claim 5, wherein the steps of determining and comparing occur as a function of a plurality of received, normalized and reconciled records.

7. The method of claim 6, wherein a report is generated that includes at least a graph representing one or more of the absolute differential and the comparison.

8. The method of claim 1, wherein the reconciliation can be formatted as a prompt for further processing.

9. The method of claim 1, wherein the mapping rules, when executed, augment and/or transform any of the electronic transport information and the electronic destination information.

19. The method of claim 1, wherein none of the reference data is included in, the electronic transport information or the electronic destination information.

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.

11. The system of claim 10, wherein the at least some of the electronic transport information and the electronic destination information is received in a plurality of respective data formats.

12. The system of claim 10, wherein the non-transitory processor readable media further have instructions for causing the following steps to be performed by the at least one processor:

transmitting, at least some of the normalized electronic transport information and electronic destination information to at least one external system.

13. The system, of claim 12, wherein the external system includes at least one of a trade capture system, accounting system, inventory system, dispatching system, regulatory system executing on at least one computing device.

14. The system of claim 10, wherein the non-transitory processor readable media further have instructions for causing the following steps to be performed by the at least one processor:

determining an absolute differential of one transport and/or one destination;

comparing the absolute differential of the one transport and/or one destination to a percentage value representing a plurality of sources, a plurality of transports and/or a plurality of destinations.

15. The system of claim 14, wherein the steps of determining and comparing occur as a function of a plurality of received, normalized and reconciled records.

16. The system of claim 15, wherein a report is generated that includes at least a graph representing at least one of the absolute differential and the comparison.

17. The system of claim 10, wherein the reconciliation can be formatted as a prompt for further processing.

18. The system of claim 10, wherein the mapping rules, when executed, further cause the following steps to be performed by the at least one processor:

adding, augmenting and/or transforming any of the electronic transport information and the electronic destination information.

20. The system of claim 10, wherein none of the reference data is included in, the electronic transport information or the electronic destination information.