IP Library Granted Patent US 9,460,472
Granted Patent B2
US 9,460,472 · App. 14/183,728 · Granted Oct 4, 2016

System and method for reconciling one or more financial transactions

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,460,472
App. No.
14/183,728
Granted
Oct 4, 2016
Kind
B2
Abstract

A system, method and computer program product for reconciling one or more financial transactions of one or more business units. The method includes capturing transaction data from the financial transactions using a first set of data logics. The capturing further includes extracting the transaction data from the financial transactions using import templates and transforming the extracted transaction data to a predefined format, using a first set of validations. The captured transaction data is then auto-matched with master data as reference, using one or more auto-match logics and a second set of validations. One or more reports are then generated on the auto-matched transaction data. The method further includes providing user privileges for controlling the capturing, the auto-matching, and the generation of the one or more reports according to a first predefined criterion.

Claims (36)

1. A method comprising:

creating, by a computer-based journal entry system, journal entries of transaction data based upon predefined journal entry criteria;

distinguishing, by the computer-based journal entry system, the transaction data as closed transaction data, in response to the predefined journal entry criteria being executed; and

archiving, by the computer-based journal entry system, the closed transaction data.

2. The method of claim 1 , further comprising executing, by the computer-based journal entry system, the predefined journal entry criteria.

3. The method of claim 1 , further comprising extracting, by the computer-based journal entry system and based upon data logic and validations, the transaction data from financial transactions, wherein the transaction data comprises a subset of the financial transactions.

4. The method of claim 1 , further comprising transforming, by the computer-based journal entry system, the transaction data to a predefined format.

5. The method of claim 1 , further comprising capturing, by the computer-based journal entry system, the transaction data in a reusable import template, wherein the reusable import template is created based up the transaction data.

6. The method of claim 1 , further comprising auto-matching, by the computer-based journal entry system, the transaction data to master data to within a specified tolerance limit.

7. The method of claim 1 , further comprising performing, by the computer-based journal entry system, research and clearance of the transaction data.

8. The method of claim 1 , further comprising auto-matching, by the computer-based journal entry system, the transaction data to master data to within a specified tolerance limit by using one or more auto-match logics, the one or more auto-match logics comprising permutations of one or more arithmetic algorithms, the auto-matching providing open transaction data and being performed using a second set of validations.

9. The method of claim 1 , further comprising:

generating, by the computer-based journal entry system, one or more reports on auto-matched transaction data; and

providing, by the computer-based journal entry system, user privileges according to a first predefined criterion, the user privileges for controlling capturing, the auto-matching, and generation of the one or more reports.

10. The method of claim 1 , further comprising:

scheduling, by the computer-based journal entry system, the data logic, the scheduling enabling automatic execution of the data logic according to a second predefined criterion.

11. The method of claim 1 , further comprising scheduling, by the computer-based journal entry system, at auto-match logics, the scheduling enabling automatic execution of at least one of the auto-match logics according to a third predefined criterion.

12. The method of claim 1 , further comprising performing, by the computer-based journal entry system, audit trails on at least one of captured transaction data, master data, auto-matched transaction data and reports.

13. The method of claim 1 , further comprising auto-matching, by the computer-based journal entry system, the transaction data to master data, wherein the auto-matching is a tolerance auto-matching, the tolerance auto-matching comprising a predefined tolerance limit.

14. The method of claim 1 , further comprising providing, by the computer-based journal entry system, views, the views for reviewing captured transaction data, uncaptured transaction data, auto-matched transaction data and reports.

15. The method of claim 1 , further comprising auto-matching, by the computer-based journal entry system, the transaction data to master data, wherein the auto-matching further comprises splitting captured transaction data, the splitting being performed using auto-match logics.

16. A system comprising:

a processor configured for executing journal entry criteria;

a tangible, non-transitory memory configured to communicate with the processor,

the tangible, non-transitory memory having instructions stored thereon that, in response to execution by the processor, cause the processor to perform operations comprising:

creating, journal entries of transaction data based upon predefined journal entry criteria;

generating and testing data logic based on a plurality of desired fields, wherein the data logic comprises at least one of: an algorithm and a computer code;

distinguishing, the transaction data as closed transaction data, in response to the predefined journal entry criteria being executed; and

archiving, the closed transaction data.

17. An article of manufacture including a non-transitory, computer readable storage medium having instructions stored thereon that, in response to execution by a computer-based journal entry system, cause the computer-based journal entry system to perform operations comprising:

creating, by the computer-based journal entry system, journal entries of transaction data based upon predefined journal entry criteria;

generating, by the computer-based journal entry system, a data logic based upon a plurality of desired fields;

testing, by the computer-based journal entry system, the data logic; and

scheduling, by the computer-based journal entry system, the data logic, the scheduling enabling automatic execution of the data logic according to a predefined criterion;

distinguishing, by the computer-based journal entry system, the transaction data as closed transaction data, in response to the predefined journal entry criteria being executed; and

archiving, by the computer-based journal entry system, the closed transaction data.

Assignments (3)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 16, 2018
From: III HOLDINGS 1, LLC
To: LIBERTY PEAK VENTURES, LLC
Reel/Frame 045611/0193 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jul 24, 2014
From: AMERICAN EXPRESS TRAVEL RELATED SERVICES COMPANY, INC.
To: III HOLDINGS 1, LLC
Reel/Frame 033388/0001 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Feb 19, 2014
From: LOBANA, PREETI; ARUN, RUCHIKA; KRISHNAN, KIZHAKKEMADAM R.; KADAM, UDAY RAO; VISHWANATHAN, RAJU; JOSEPH, SHINO; DAHIYA, ANURAG
To: AMERICAN EXPRESS TRAVEL RELATED SERVICES COMPANY, INC.
Reel/Frame 032242/0992 →