SYSTEMS AND METHODS FOR CASH POSITIONING AND REPORTING

• US 20090319429A1
• Filed: 07/31/2008
• Published: 12/24/2009
• Est. Priority Date: 06/23/2008
• Status: Active Grant

• Current Assignee: Bank of America Corp.
• Original Assignee: Bank of America Corp.
• Inventors: Scully, John E.
• Granted Patent: US 9,208,522 B2
• Time in Patent Office: Days
• US Class Current: 705/50
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03
• CPC Class Codes: G06Q 40/12 Accounting

Abstract

Systems and methods for cash positioning and cash reporting are preferably provided. A system for cash reporting and cash positioning according to the invention may include a controller module and a web service module. The controller module may be adapted to receive a selection to update a data store. The web service module may be adapted to receive a call from the controller module. The call from the controller module may be sent in response to the selection to update the data store. The web service module may be configured to retrieve bank account information data in response to the call from the controller module.

Claims

1. One or more computer-readable media storing computer-executable instructions which, when executed by a processor on a computer system, perform a method for retrieving data, said data to populate a spreadsheet, the method comprising:

receiving a user selection to update a data store;

in response to the selection to update the data store, calling a controller module;

in response to calling the controller module, using the controller module to call a web service module;

in response to the call to the web service module, retrieving bank account information data; and

populating a spreadsheet application with retrieved bank account information.

2. The method of claim 1 further comprising using the controller to pass bank account information (“

Bai2”

) data to a BaiParser.

3. The method of claim 2 further comprising using the BaiParser to translate Bai2 data into a human-readable format.

4. The method of claim 3 further comprising using the Controller to pass the Bai2 data to a StoreManager module.

5. The method of claim 4 further comprising using a StoreManager to save Bai2 data to a local file system.

6. One or more computer-readable media storing computer-executable instructions which, when executed by a processor on a computer system, perform a method for providing a cash positioning and reporting tool, the instructions comprising:

a first instruction that insulates a user interface software layer from a data storage layer, said data storage layer that stores bank account information;

a second instruction that manages persistent data and transactions;

a third instruction that maps persistent data objects to physical storage; and

a fourth instruction that stores the bank account information in a client computer.

7. The computer-readable media of claim 6, the instructions further comprising a fifth instruction that maintains data in an encrypted state in a client computer.

8. A method that may be implemented by a server on a client system, the method which utilizes a spreadsheet, the method comprising:

utilizing a main thread to communicate with a file system; and

utilizing a separate worker thread for downloading cash reporting and positioning data.

9. The method of claim 8 further comprising using a second separate worker thread for downloading application updates.

10. The method of claim 9 further comprising maintaining the client system in a responsive state during the downloading of the cash reporting and positioning data.

11. A system for cash reporting and cash positioning, the system comprising:

a controller module that receives a selection to update a data store; and

a web service module that receives a call from the controller module, the call from the controller module being sent in response to the selection to update the data store, the web service module that retrieves bank account information data in response to the call from the controller module.

12. The system of claim 11 further comprising a user interface module that populates a client-resident spreadsheet application with retrieved bank account information.

13. The system of claim 11 wherein the controller module is further configured to pass the bank account information data to a data parser.

14. The system of claim 13 wherein the data parser is configured to translate the bank account information data into a human-readable format.

15. The system of claim 14 wherein the controller module is further configured to pass the bank account information to a local database.

16. The system of claim 15 wherein the local database is configured to save the bank account information data to a local file system.