System and method for account reconciliation

• US 7,698,216 B2
• Filed: 01/03/2007
• Issued: 04/13/2010
• Est. Priority Date: 08/25/2000
• Status: Expired due to Term

• Current Assignee: Liberty Peak Ventures, LLC (Dominion Harbor Enterprises, LLC)
• Original Assignee: American Express Travel Related Services Company, Inc. (American Express Company)
• Inventors: Provinse, Shirley J.
• Primary Examiner(s): Akintola, Olabode
• Application Number:
  US11/619,280
• Publication Number:
  US 20070130027A1
• Time in Patent Office: 1,196 Days
• Field of Search: 705/5, 705/33, 705 35- 40
• US Class Current: 705/39
• CPC Class Codes: G06Q 10/02 Reservations, e.g. for tickets, services or events
• CPC Class Codes: G06Q 20/02 involving a neutral party, e.g. certification authority, notary or trusted third party [TTP]
• CPC Class Codes: G06Q 20/023 the neutral party being a clearing house
• CPC Class Codes: G06Q 20/10 specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
• CPC Class Codes: G06Q 20/102 Bill distribution or payments
• CPC Class Codes: G06Q 30/04 Billing or invoicing
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes
• CPC Class Codes: G06Q 40/12 Accounting
• CPC Class Codes: G06Q 40/128 Check-book balancing, updating or printing arrangements

Abstract

An account reconciliation system having a particular usefulness in the reconciliation of centrally billed accounts and more specifically, in the reconciliation of centrally billed accounts in the travel industry is provided. The system and methods of the present invention expand on the traditional match/non-match techniques and provide complete transaction management for every item on a client'"'"'s account. In another sense, reconciliation is redefined to include each and every transaction on an account regardless of it'"'"'s reconciliation status, i.e., matched, unresolved, pending, etc. Consequently, the present invention reconciles the client'"'"'s account to the account balance.

Claims

1. A computer implemented account reconciliation method for reconciling a plurality of merchant transactions with a plurality of financial account transactions, comprising:

authorizing, by a processor, access to said plurality of merchant transactions stored in a merchant database, wherein each of said plurality of merchant transactions includes a first amount and first data, wherein said first data relates to non-monetary information; and

authorizing, by said processor, access to said plurality of financial account transactions stored in a financial database, wherein said plurality of financial account transactions includes a first charge and a second charge, wherein said second charge is associated with a change to one of said plurality of merchant transactions in said merchant database;

wherein said first charge is matched to said first amount of one of said plurality of merchant transactions in said merchant database, and said first charge is assigned to a department code by writing said department code to a field corresponding to said first charge in said financial database, wherein said department code is part of a plurality of department codes, wherein each of said department codes are associated with a type of merchant transaction, and wherein said second charge in said financial database is associated with said first data of said one of said plurality of merchant transactions in said merchant database, wherein said plurality of merchant transactions does not include said second charge, and wherein said second charge is assigned to said department code associated with said one of said plurality of merchant transactions.

2. The method of claim 1, wherein said plurality of merchant transactions and said plurality of financial account transactions are stored on a pending list.

3. The method of claim 1, further comprising receiving a computer-generated reconciliation report having:

a beginning balance comprising a dollar balance on a transaction account statement;

a pending payment comprising a combined dollar total of automatically approved and user-approved matches of said plurality of merchant transactions and said plurality of financial account transactions;

an ending balance comprising an aggregate of said beginning balance less said pending payment; and

an unresolved balance comprising a dollar total of unmatched merchant-related data and unmatched data.

4. The method of claim 3, wherein said ending balance equals said unresolved balance.

5. The method of claim 1, further comprising receiving a detailed description of said first charge and said second charge.

6. The method of claim 1, further comprising:

selecting a matching criteria from a detailed description of at least one of an unresolved one of said plurality of merchant transactions and an unresolved one of said plurality of financial account transactions;

activating a research tool to search for a match or near-match using said matching criteria;

selecting, on said display, a resolved match from a result of said research tool search.

7. The method of claim 1, wherein a resolved match is transferred to at least one of a pending payment list and a ready for approval list.

8. The method of claim 1,

wherein a resolved match is transferred to said ready for approval list;

and

wherein said resolved match is accepted and at least one of;

transferred to a pending payment list, denied, and transferred to an unresolved balance list.

9. The method of claim 1, wherein said plurality of merchant transactions and said plurality of financial account transactions are matched by searching for a common set of numbers within said plurality of merchant transactions and said plurality of financial account transactions.

10. The method of claim 1, wherein at least one of:

a match is identified by matching all of a plurality of matching criteria between said plurality of merchant transactions and said plurality of financial account transactions.

11. The method of claim 1, wherein at least one of:

a first criteria and a second criteria comprises basic matching criteria and client-specific matching criteria.

12. The method of claim 1, wherein a match is determined based on all of a set of first criteria and all of a set of second criteria during auto-reconciliation.

13. The method of claim 1, wherein said plurality of merchant transactions are related to at least one of:

an airline, lodging, and a rental car.

14. The method of claim 1, wherein said plurality of financial account transactions are related to at least one of:

a credit card, a charge card, a debit card and a pre-paid card.

15. The method of claim 1, further comprising compiling a list of at least two transactions that when summed equal zero.

16. The method of claim 1, further comprising incurring at least one of said first charge or said second charge.

17. A tangible computer-readable medium having stored thereon a plurality of instructions, when executed by a processor, perform a method of providing account reconciliation for an account comprising:

authorizing, by said processor, access to said plurality of merchant transactions stored in a merchant database, wherein each of said plurality of merchant transactions includes a first amount and first data, wherein said first data relates to non-monetary information; and

authorizing, by said processor, access to said plurality of financial account transactions stored in a financial database, wherein said plurality of financial account transactions includes a first charge and a second charge, wherein said second charge is associated with a change to one of said plurality of merchant transactions in said merchant database;

wherein said first charge is matched to said first amount of one of said plurality of merchant transactions in said merchant database, and said first charge is assigned to a department code by writing said department code to a field corresponding to said first charge in said financial database, wherein said department code is part of a plurality of department codes, wherein each of said department codes are associated with a type of merchant transaction, and wherein said second charge in said financial database is associated with said first data of said one of said plurality of merchant transactions in said merchant database, wherein said plurality of merchant transactions does not include said second charge, and wherein said second charge is assigned to said department code associated with said one of said plurality of merchant transactions.

18. A computerized system for reconciling a plurality of merchant transactions with a plurality of financial account transactions, said system comprising:

a network interface communicating with a memory;

said memory communicating with a processor; and

said processor, when executing a computer program, is configured to;

receive authorization to access said plurality of merchant transactions in a merchant database, wherein each of said plurality of merchant transactions includes a first amount and first data, wherein said first data relates to non-monetary information;

receive authorization to access said plurality of financial account transactions in a financial database, wherein said plurality of financial account transactions includes a first charge and a second charge, wherein said second charge is associated with a charge to one of said plurality of merchant transactions;

match said first charge to said first amount of one of said plurality of merchant transactions;

assign said first charge to a department code by writing said department code to a field corresponding to said first charge in said financial database, wherein said department code is part of a plurality of department codes, wherein each of said plurality of department codes are associated with a type of merchant transaction;

associate said second charge in said financial database with said first data of said one of said plurality of merchant transactions in said merchant database, wherein said plurality of merchant transactions in said merchant database does not include said second charge; and

,

assign said second charge in said financial database to said department code associated with said one of said plurality of merchant transactions in said merchant database.