Understanding How to Parse Bank Statement Addenda

Bank statements often do not carry enough information in a structured format to reconcile the bank statement lines. The addenda field on a bank statement contains important customer data that could help in reconciliation. However, the addenda information varies from bank to bank and depends on the customer to bank relationship.

The Data Export and Import Utility provides a mechanism to break down the unstructured addenda information into its component parts and store it in a structured format. The bank reconciliation rules can be configured to use the parsed addenda information to more effectively reconcile bank statement lines.

Addenda parsing is based on People Tools Document Technology and the Data Export and Import Utility (DEIU) tool, which allows users to configure transformation through an online mapping component. Users should be familiar with PeopleSoft documents, as well as Data Export Import Utility map definitions and document relationships before parsing bank statement addenda using DEIU.

The next diagram illustrates the process used to parse previous day bank statement addenda using the Data Export Import Utility. The tool transforms the statement addenda on BANK_STMT_TBL to BANK_ADDEND_TBL for unreconciled bank statement lines. Users should copy the BANK_RECON_PD_MAP map definition, which is provided as a sample, and define appropriate transformations.

This diagram illustrates the process used to parse previous day bank statement addenda using the Data Export Import Utility.

For more information about the Data Export Import Utility, see PeopleSoft Application Fundamentals, Understanding the Data Export Import Utility.