DATA RECONCILIATION

• US 20170039553A1
• Filed: 10/26/2015
• Published: 02/09/2017
• Est. Priority Date: 08/04/2015
• Status: Active Grant

• Current Assignee: Accenture Global Services Limited (Accenture PLC)
• Original Assignee: Accenture Global Services Limited (Accenture PLC)
• Inventors: Thangaraj, Naveen Kumar, Fernandes, Sebastian, Podder, Sanjay, Ghatage, Prakash
• Granted Patent: US 10,332,109 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06Q 20/3563 Software being resident on card
• CPC Class Codes: G06Q 20/389 Keeping log of transactions for guaranteeing non-repudiation of a transaction

Abstract

Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for reconciliation data. The methods include actions of determining to perform a reconciliation task between transactions of a primary type and transactions of a secondary type, determining a reconciliation profile associated with the reconciliation task, obtaining reconciliation rules associated with the reconciliation profile from a reconciliation rule database, obtaining primary records of the primary type and secondary records of the secondary type based on the reconciliation profile, identifying matching transactions in the primary records and the secondary records and identifying unmatched transactions in the primary records and secondary records based on the reconciliation rules, providing an indication of the matched transactions and the unmatched transactions, receiving input specifying a match between an unmatched primary record transaction and an unmatched secondary record transaction, and identifying the unmatched primary record transaction and the unmatched secondary record transaction as matching.

Claims

1. A computer implemented method, comprising:

determining, by a reconciliation system, to perform a reconciliation task between transactions of a primary type and transactions of a secondary type;

in response to determining to perform a reconciliation task between transactions of a primary type and transactions of a secondary type, determining a reconciliation profile associated with the reconciliation task;

obtaining reconciliation rules associated with the reconciliation profile from a reconciliation rule database, where the reconciliation rule database stores multiple sets of reconciliation rules associated with different reconciliation profiles;

obtaining primary records of the primary type and secondary records of the secondary type based on the reconciliation profile associated with the reconciliation task;

identifying, by the reconciliation system, matching transactions in the primary records and the secondary records based on the reconciliation rules associated with the reconciliation profile;

identifying, by the reconciliation system, unmatched transactions in the primary records and secondary records based on the reconciliation rules associated with the reconciliation profile;

providing an indication of the matched transactions and the unmatched transactions;

receiving input specifying a match between an unmatched primary record transaction and an unmatched secondary record transaction;

in response to the input, identifying the unmatched primary record transaction and the unmatched secondary record transaction as matching; and

providing a report based on the matching transactions and the unmatched transactions.

2. The method of claim 1, wherein determining, by a reconciliation system, to perform a reconciliation task between transactions of a primary type and transactions of a secondary type comprises:

determining that timing criteria specified by a reconciliation task has been satisfied; and

in response to determining that the timing criteria specified by the reconciliation task has been satisfied, determining to perform the reconciliation task.

3. The method of claim 1, wherein obtaining reconciliation rules associated with the reconciliation profile from a reconciliation rule database comprises:

determining reconciliation rules specified by the reconciliation profile; and

obtaining the reconciliation rules specified by the reconciliation profile from the reconciliation rule database.

4. The method of claim 1, wherein identifying, by the reconciliation system, matching transactions in the primary records and the secondary records based on the reconciliation rules comprises:

determining that matching criteria specified by a particular reconciliation rule is satisfied by a particular transaction of the primary record and a particular transaction of the secondary record.

5. The method of claim 4, wherein determining that matching criteria specified by a particular reconciliation rule is satisfied by a particular transaction of the primary record and a particular transaction of the secondary record comprises:

determining that a date, amount, and description of the particular transaction of the primary record are the same as a date, amount, and description of the particular transaction of the secondary record.

6. The method of claim 1, wherein identifying, by the reconciliation system, matching transactions in the primary records and the secondary records based on the reconciliation rules comprises:

determining that matching criteria specified by a particular reconciliation rule is satisfied by a particular transaction of the primary record and multiple transactions of the secondary record.

7. The method of claim 1, wherein identifying, by the reconciliation system, matching transactions in the primary records and the secondary records based on the reconciliation rules comprises:

determining that matching criteria specified by a particular reconciliation rule is satisfied by multiple transactions of the primary record and a particular transaction of the secondary record.

8. The method of claim 1, wherein identifying, by the reconciliation system, unmatched transactions in the primary records and secondary records based on the reconciliation rules comprises:

determining that no matching criteria of any reconciliation rule is satisfied by a particular transaction of the primary record and any unmatched transaction of the secondary record.

9. The method of claim 1, wherein providing an indication of the matched transactions and the unmatched transactions comprises:

providing a graphical user interface indicating the transactions of the primary records and whether each transaction of the primary records is matched.

10. The method of claim 1, wherein providing an indication of the matched transactions and the unmatched transactions comprises:

providing a recommendation of a potential match between the unmatched primary record transaction and the unmatched secondary record transaction.

11. The method of claim 1, wherein receiving input specifying a match between an unmatched primary record transaction and an unmatched secondary record transaction comprises:

receiving from a preparer device, an indication of user input selecting that the unmatched primary record transaction be matched with the unmatched secondary record transaction.

12. The method of claim 1, wherein receiving from a preparer device, an indication of user input selecting that the unmatched primary record transaction be matched with the unmatched secondary record transaction comprises:

receiving an indication of an acceptance of a recommendation of a potential match between the unmatched primary record transaction and the unmatched secondary record transaction.

13. The method of claim 1, identifying the unmatched primary record transaction and the unmatched secondary record transaction as matching comprises:

determining that a variance between the unmatched primary record transaction and the unmatched secondary record transaction satisfy a tolerance.

14. The method of claim 1, comprising:

receiving a selection of the unmatched primary record transaction; and

in response to receiving the selection of the unmatched primary record transaction, providing for display a variance of the unmatched secondary record transaction.

15. The method of claim 1, wherein obtaining primary records of the primary type and secondary records of the secondary type based on the reconciliation profile associated with the reconciliation task comprises:

obtaining an image based file from an enterprise resource planning system of a client through an interface using access information specified by the reconciliation profile;

obtaining text from the image based file based on optical character recognition; and

generating the primary records of the primary type of secondary records of the secondary type based on the obtained text.

16. The method of claim 1, comprising:

receiving a request to modify one or more reconciliation rules associated with the reconciliation profile; and

modifying the one or more reconciliation rules associated with the reconciliation profile.

17. The method of claim 1, comprising:

receiving a request to modify associations of the reconciliation profile with one or more reconciliation rules; and

modifying the associations of the reconciliation profile with the one or more reconciliation rules.

18. A system comprising:

an administration engine configured to;

determine, by a reconciliation system, to perform a reconciliation task between transactions of a primary type and transactions of a secondary type;

in response to determining to perform a reconciliation task between transactions of a primary type and transactions of a secondary type, determine a reconciliation profile associated with the reconciliation task; and

obtain reconciliation rules associated with the reconciliation profile from a reconciliation rule database, where the reconciliation rule database stores multiple sets of reconciliation rules associated with different reconciliation profiles;

a matching engine configured to;

obtain primary records of the primary type and secondary records of the secondary type based on the reconciliation profile associated with the reconciliation task;

identify matching transactions in the primary records and the secondary records based on the reconciliation rules associated with the reconciliation profile; and

identify unmatched transactions in the primary records and secondary records based on the reconciliation rules associated with the reconciliation profile;

a preparer engine configured to;

provide an indication of the matched transactions and the unmatched transactions;

receive input specifying a match between an unmatched primary record transaction and an unmatched secondary record transaction; and

in response to the input, identify the unmatched primary record transaction and the unmatched secondary record transaction as matching; and

a reporting module configured to;

provide a report based on the matching transactions and the unmatched transactions.

19. The system of claim 18, wherein obtain reconciliation rules associated with the reconciliation profile from a reconciliation rule database comprises:

determine reconciliation rules specified by the reconciliation profile; and

obtain the reconciliation rules specified by the reconciliation profile from the reconciliation rule database.

20. A non-transitory computer-readable medium storing software comprising instructions executable by one or more computers which, upon such execution, cause the one or more computers to perform operations comprising:

determining, by a reconciliation system, to perform a reconciliation task between transactions of a primary type and transactions of a secondary type;

in response to determining to perform a reconciliation task between transactions of a primary type and transactions of a secondary type, determining a reconciliation profile associated with the reconciliation task;

obtaining reconciliation rules associated with the reconciliation profile from a reconciliation rule database, where the reconciliation rule database stores multiple sets of reconciliation rules associated with different reconciliation profiles;

obtaining primary records of the primary type and secondary records of the secondary type based on the reconciliation profile associated with the reconciliation task;

identifying, by the reconciliation system, matching transactions in the primary records and the secondary records based on the reconciliation rules associated with the reconciliation profile;

identifying, by the reconciliation system, unmatched transactions in the primary records and secondary records based on the reconciliation rules associated with the reconciliation profile;

providing an indication of the matched transactions and the unmatched transactions;

receiving input specifying a match between an unmatched primary record transaction and an unmatched secondary record transaction;

in response to the input, identifying the unmatched primary record transaction and the unmatched secondary record transaction as matching; and

providing a report based on the matching transactions and the unmatched transactions.