Method and apparatus for automatically applying/linking transactions in a financial management system

• US 7,552,089 B2
• Filed: 03/23/2005
• Issued: 06/23/2009
• Est. Priority Date: 03/23/2005
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Bruer, Annette M., Pfingsten, William F., Nelson, Kimberly A.
• Primary Examiner(s): CAMPEN, KELLY SCAGGS
• Application Number:
  US11/087,459
• Publication Number:
  US 20060218083A1
• Time in Patent Office: 1,553 Days
• Field of Search: 705/39, 705/22, 705/23, 705/29, 705/34, 705/35, 705/41, 705/40, 705/30, 235/379, 235/375, 707/100
• US Class Current: 705/39
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 20/10 specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems

Abstract

A computer-implemented financial management system that includes a standardized apply system that, in general, allows a user to relatively easily apply any transaction/document to any other transaction/document. The apply system includes a uniform apply interface that is configured to receive at least two generic transactions. The uniform apply interface applies at least a portion of one of the at least two generic transactions to at least a portion of another one of the at least two generic transactions to produce at least one apply record. The at least one apply record is stored in a database.

Claims

1. A financial system comprising:

a uniform apply interface configured to receive a generic transaction, and to automatically apply, independently of any account that may be associated with the generic transaction, by linking the generic transaction to at least one of a plurality of other transactions in the financial system to produce at least one apply record; and

a database configured to store the at least one apply record,

wherein the generic transaction has a standardized structure that is not tied to a data schema or structure of any particular account module,

wherein, after receiving the generic transaction and prior to carrying out the automatic apply, the uniform apply interface is configured to determine, based on at least one apply rule, which of the plurality of other transactions in the financial system is suitable for automatically applying to the generic transaction.

2. The system of claim 1 wherein the financial system further comprises a first user interface through which a user can select the generic transaction.

3. The system of claim 2 wherein the first user interface is further configured to allow a user to select the at least one apply rule, from a plurality of apply rules, for use in determining which of the plurality of other transactions in the financial system is suitable for automatically applying to the generic transaction.

4. The system of claim 3 wherein the financial system further comprises a second user interface for defining apply rules.

5. The system of claim 3 wherein at least some of the plurality of apply rules are predefined in the financial system.

6. The system of claim 3 wherein at least some of the plurality of apply rules are defined to allow for multiple levels of transaction matching criteria to be utilized in determining which of the plurality of other transactions, in the financial system, is suitable for automatically applying to the generic transaction.

7. The system of claim 3 wherein the plurality of apply rules comprise at least one write-off rule, which defines a tolerance level within which imperfectly matched transactions are written-off in the financial system.

8. The system of claim 3 wherein the plurality of apply rules comprise at least one national-account rule that defines transaction-matching criteria in terms of parent-child relationships between constituents in the financial system.

9. The system of claim 3 wherein the plurality of apply rules comprise at least one balance splitting rule, which defines how a balance of the generic transaction is distributed amongst multiple other transactions.

10. A computer-implemented method of linking transactions in a financial system, comprising:

receiving, in an apply interface, a generic transaction, the generic transaction having a standardized structure that is not tied to a data schema or structure of any particular account module;

automatically linking, independently of any account that may be associated with the generic transaction, the generic transaction, within the apply interface, to at least one of a plurality of other transactions in the financial system; and

storing the linked generic transaction and the at least one of the plurality of the other transactions.

11. The method of claim 10 wherein automatically linking the generic transaction to at least one of a plurality of other transactions comprises creating and storing at least one apply record that reflects consolidated outstanding balances of the linked transactions.

12. The method of claim 10 and further comprising determining, based on at least one apply rule, which of the plurality of other transactions in the financial system is suitable for automatically linking to the generic transaction.

13. The method of claim 10 and further comprising selecting the generic transaction using a first user interface.

14. The method of claim 13 and further comprising utilizing the first user interface to select the at least one apply rule, from a plurality of apply rules, for use in determining which of the plurality of other transactions in the financial system is suitable for automatically linking to the generic transaction.

15. The method of claim 14 and further comprising utilizing a second user interface for defining apply rules.

16. The method of claim 14 wherein at least some of the plurality of apply rules are predefined in the financial system.

17. The method of claim 14 wherein at least some of the plurality of apply rules are defined to allow for multiple levels of transaction matching criteria to be utilized in determining which of the plurality of other transactions, in the financial system, is suitable for automatically applying to the generic transaction.

18. The method of claim 14 wherein the plurality of apply rules comprise at least one write-off rule, which defines a tolerance level within which imperfectly matched transactions are written-off in the financial system.

19. The method of claim 14 wherein the plurality of apply rules comprise at least one national-account rule that defines transaction-matching criteria in terms of parent-child relationships between constituents in the financial system.