Load Bank Reconciliation File - BKUTLB

The BKUTLB  process converts a bank's statement and places it into the BK Update Bank Statement Info (BKUPBA) page. This requires configuration of various bank-specific NU Common Codes with the Code Category of BKRC. The system will read the bank's file using a series of NU Common Codes that must be defined prior to running this process. These codes help interface data from its position within the bank file and fill into the expected fields of the BK Update Bank Statement Info page.

The client is responsible for configuring the bank file for proper loading via the BK Load Bank Reconciliation File utility. After familiarizing with the statement, modify the arrangement so that its contents are ready for the next step. Modification may involve removing extra lines or sentences that do not relate to bank data specifically. For instance, if the file has multiple header and/or trailer records, the client must delete all unessential content or blank spaces prior to the header record and/or blank records after the trailer. Remove duplicate columns or change the format of the columns to "text."

Importing the first bank statement may take effort. Once the setup is complete, take screen shots of the various common codes in grid mode, write notes, and save the information in a secure location for future reference.

The following document types are supported by this interface: Cancelled Checks, Deposits, Adjustments, Interest, Bank Fees, and EFT. Notice that Epayments are excluded as these are typically managed by the financial institution administering that process.

At minimum, define the following NU Common Codes: general information (BKRC/xxGEN), Document types (BKRC/xxCHK), check number (BKRC/xxCKNUM), check date (BKRC/xxCKDATE), and check amount (BKRC/xxCKAMT). 

Please enter the Bank ID to process: Enter check stock ID (CKID) that corresponds to the bank file. This CKID will be used to read any bank-specific common codes that have been defined. Note that this ID should correspond to the CKID/XX common code setup. 
Please enter the statement date: Enter the ending date of the bank statement. Typically set to default to the current date.
Bank File Name: Use the lookup controller to browse and select the remote file holding the statement data.
Trial Mode: "Yes" will not write transactions to the BK subsystem, but will generate a report of detail transactions and control counts. The report will describe the documents that would be added to the statement if Trial Mode were checked "NO." "No" will write transactions to the BK as well as generate the report and control counts.