Automatic generation of bank deposits

• US 7,114,649 B2
• Filed: 02/22/2005
• Issued: 10/03/2006
• Est. Priority Date: 02/22/2005
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: McIntyre, Scott, Egeberg, Nancy, Moberg, Michael, Nelson, Kimberly
• Primary Examiner(s): Fureman, Jared J.
• Assistant Examiner(s): Labaze, Edwyn
• Application Number:
  US11/063,053
• Publication Number:
  US 20060186192A1
• Time in Patent Office: 588 Days
• Field of Search: 235/375, 235/379, 235380-382, 235/487, 705 39- 44, 705/28, 705/30
• US Class Current: 235/379
• 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/405 Establishing or using transaction specific rules
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes
• CPC Class Codes: G06Q 40/12 Accounting

Abstract

An accounting system has a data file and a bank deposit generator. The data file contains a plurality of financial transactions. Each financial transaction includes associated information. The bank deposit generator is adapted to identify one or more cash-in transactions of the plurality of transactions according to selectable criteria and to associate the one or more cash-in transactions to a bank deposit transaction based on a correlation between the associated information and the selectable criteria.

Claims

1. An enterprise accounting system comprising:

a connection connectable to at least one bank to permit the enterprise accounting system to access deposit data at the at least one bank;

a data file containing a plurality of financial transactions for access by an enterprise accounting system user, each financial transaction having associated information, and a first one of the financial transactions being associated with multiple tallied receipts; and

a bank deposit generator adapted to identify one or more cash-in transactions of the plurality of financial transactions according to selectable criteria, and a first one of the cash-in transactions including the multiple tallied receipts and to associate the first one of the cash-in transactions to a bank deposit transaction that includes the first one of the financial transactions based on a correlation between the associated information and the selectable criteria.

2. The enterprise accounting system of claim 1 further comprising:

a user interface coupled to the bank deposit generator and adapted for user interaction with the selectable criteria.

3. The enterprise accounting system of claim 1 wherein the bank deposit generator is adapted to modify the associated first one of the cash-in transactions to include a deposit identifier that identifies the bank deposit transaction.

4. The enterprise accounting system of claim 1 wherein the selectable criteria comprises a bank account, a currency, and a payment method.

5. The enterprise accounting system of claim 1 wherein the selectable criteria comprises a bank account, a currency and a receipt status.

6. The enterprise accounting system of claim 1 further comprising:

a sort feature adapted sort the one or more cash-in transactions according to the selectable criteria.

7. A method for generating a bank deposit in an enterprise accounting system, the method comprising:

accessing deposit data from at least one bank through a connection in the enterprise accounting system that is connectable to the at least one bank;

identifying cash-in transactions within a financial transactions data file for access by an enterprise accounting system user, the identifying being based on one or more selectable criteria, the cash-in transactions including a first cash-in transaction that includes multiple tallied receipts;

associating the identified cash-in transactions to a deposit record that includes a first deposit record that includes the multiple tallied receipts; and

updating the first cash-in transaction within the data file with a deposit identifier associated with the deposit record of the first deposit.

8. The method of claim 7 wherein before the step of identifying, the method further comprising:

selecting at least one of the one or more selectable criteria for searching the financial transactions data file for unassociated cash-in transactions.

9. The method of claim 7 wherein the financial transactions data file comprises monetary transactions and associated information.

10. The method of claim 7 further comprising:

generating a deposit report comprising one or more deposit records.

11. The method of claim 7 wherein the selectable criteria comprises a bank account and a currency.

12. The method of claim 7 wherein the step of associating comprises:

generating a new deposit record for the identified cash-in transactions; and

associating the identified cash-in transactions to the new deposit record.

13. An enterprise accounting system comprising:

a connection in the enterprise accounting system that is connectable to at least one bank to access deposit data in the at least one bank;

a data file of cash-in transactions and associated information for access by an enterprise accounting system user, the cash-in transactions including a first cash-in transaction that includes multiple tallied receipts; and

a bank deposit generator adapted to assign cash-in transactions to a bank deposit that includes the multiple tallied receipts based on a correlation between the associated information and selectable criteria.

14. The enterprise accounting system of claim 13 and further comprising:

a user interface adapted for user interaction with the selectable criteria.

15. The enterprise accounting system of claim 14 wherein the user interface allows selection of any combination of the selectable criteria.

16. The enterprise accounting system of claim 13 wherein the bank deposit generator is adapted to insert a deposit identifier associated with the bank deposit into each assigned cash-in transaction within the data file.

17. The enterprise accounting system of claim 13 wherein the bank deposit is stored as a bank deposit record, the enterprise accounting system further comprising:

a bank manager feature coupled to the bank deposit generator and adapted to provide user access to the stored bank deposit record.

18. The enterprise accounting system of claim 13 further comprising:

a user data file for storing usernames and associated passwords and access permissions.

19. The enterprise accounting system of claim 18 further comprising:

an accounting engine adapted to control access to the data file based on the user data file.

20. The enterprise accounting system of claim 13 wherein each cash-in transaction can be associated to only one deposit record.