Understanding Statement Updates

The loading of bank statement information is an integral part of the reconciliation, bank statement accounting, and cash position processes. The system processes previous-day statements that it uses for reconciliation and accounting, current-day statements for cash position worksheets, and account analysis statements for bank fee analysis. PeopleSoft enables you to enter bank statement information in one of three ways.

The first method to enter bank statement information is to import a bank statement. Using one of the many PeopleSoft-supported bank statement formats, the statement can be imported using:

  • The file system in conjunction with the files name and path to it.

  • A file transfer protocol (FTP) file server.

  • A hypertext transfer protocol (HTTP) using a uniform resource locator (URL).

The second method, used if you receive only hardcopy statements from a bank, requires you to manually enter the statement information online using the following entry pages:

  • Enter Bank Balances

  • Enter Bank Statements

  • Enter Internal Bank Balances

  • Same Day Bank Statement

The third method of entering bank statement data is to integrate with a bank or bank communications partner by using PeopleSoft Integration Broker. See the product documentation for PeopleTools: Integration Broker.

When you import bank statements, the data are transmitted to the PeopleSoft system, which automatically loads the data to the production tables.

To import data, you run the File Import Application Engine process (IMPORT_FILES) from the Import Bank Statements page; this automatically loads bank statements from a file. You specify information that the system needs to retrieve the files, such as file location, layout, and type, and run the process. The process obtains the file contents, converts the content to a PeopleSoft standard layout, and loads the data into staging tables. After the files are loaded into the staging tables, the Treasury Bank Statement Load Application Engine process (TR_BSP_LOAD) copies the information from the staging tables into the production tables. It also determines whether a statement is a duplicate statement. Information for duplicate statements appears on the PeopleTools Process Monitor Process List (PMN_PRCSLIST) and Message Log (PMN_BAT_MSGLOG) pages.

Note: The system considers previous day statements as duplicates if a statement already exists with the same bank ID, bank account, and as of date.