Systems and methods for cash positioning and reporting

• US 9,208,522 B2
• Filed: 07/31/2008
• Issued: 12/08/2015
• 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., Santiago, Milton Jr.
• Primary Examiner(s): SHEIKH, ASFAND M
• Application Number:
  US12/183,844
• Publication Number:
  US 20090319429A1
• Time in Patent Office: 2,686 Days
• US Class Current: 1/1
• 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, wherein the instructions define a user interface layer, a business layer, and a data layer, the method comprising:

receiving, at the user interface layer, a user selection to update a multi-bank data store, wherein the user selection comprises a request for bank account information data from multiple banks that store bank account information in different proprietary formats;

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

in response to calling the controller module, utilizing a first thread that uses the controller module to call a web service module, wherein the first thread further uses the controller module to interact with the user interface layer, an interaction with the user interface layer associated with a rate of response;

in response to the call to the web service module, concurrently utilizing a second thread to interact with the data layer to retrieve the bank account information data, the second thread comprising an independent thread of execution, wherein utilizing the second thread to retrieve data enables the processor to maintain the rate of response for a concurrent interaction with the user interface layer utilizing the first thread; and

utilizing the first thread to use the controller module to populate, in conformance with a business rule residing in the business layer, a spreadsheet application at the user interface layer with retrieved bank account information from the multiple banks, the populating in conformance with a business rule comprising consolidating in the spreadsheet the bank account information from the multiple banks by mapping from the different proprietary formats to a display format for the spreadsheet, wherein the business layer insulates the user interface layer from the design of the data store at the data layer, the business layer insulated from (1) knowledge of the data retrieved from the data layer utilizing the second thread and (2) knowledge of the data presented at the user interface layer utilizing the first thread;

determining a cash position based on the populated spreadsheet;

in response to a user request, reconciling the cash position based on the populated spreadsheet with a cash position forecast determined on a prior date;

determining whether the spreadsheet includes an outstanding issue; and

in response to a determination that the spreadsheet includes an outstanding issue;

identifying an account associated with the outstanding issue;

mapping data associated with the outstanding issue to an ad hoc report, wherein the report presents a plurality of accounts associated with outstanding issue data; and

in response to user selection of an account presented in the ad hoc report, displaying the outstanding issue data associated with the selected account.

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. A system for cash reporting and cash positioning, the system comprising:

a computer memory storing;

a controller module that receives a selection to update a data store, wherein the selection comprises a request for bank account information data from multiple banks that store bank account information in different proprietary formats, the bank account information corresponding to cash amounts in different accounts in the multiple banks; and

a web service module comprising a user interface layer, a business layer and a data layer, the data layer interfacing with the data store, wherein;

the web service module is configured to receive a call from a first thread that utilizes the controller module, the first thread further utilizing the controller module to interact with the user interface layer, an interaction with the user interface layer associated with a rate of response, the call from the controller module being sent in response to the selection to update the data store;

in response to the call from the controller module, a second thread concurrently utilizes the web service module to retrieve the bank account information data, the second thread comprising an independent thread of execution, wherein utilizing the second thread to retrieve data enables a processor to maintain the rate of response for a concurrent interaction with the user interface layer utilizing the first thread; and

the first thread utilizes the controller module to populate a display at the user interface layer by enforcing a business rule upon the retrieved bank account information data from the multiple banks, the business rule residing in the business layer such that the cash amounts from the different bank accounts are consolidated for presentation by the user interface layer, wherein the business layer insulates the user interface layer from the design of the data store at the data layer, the business layer insulated from (1) knowledge of the data retrieved by the second thread and (2) knowledge of the data presented at the user interface layer by the first thread;

the web service module further configured to;

determine whether the consolidated cash amounts include an outstanding issue;

in response to a determination of an outstanding issue;

identify an account associated with the outstanding issue;

map data associated with the outstanding issue to an ad hoc report, wherein the report presents a plurality of accounts associated with outstanding issue data; and

in response to user selection of an account presented in the ad hoc report, display the outstanding issue data associated with the selected account.

7. The system of claim 6 wherein the user interface module populates a client-resident spreadsheet application with retrieved bank account information data.

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

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

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

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