Update Bank Statement Info - BKUPBA

Use the Bank Reconciliation (BK) Update Bank Statement Info (BKUPBA) page to view bank statements and make minor adjustments.

The upper portion of the page displays general information that is loaded to the database from a bank file or keyed in manually.  Various fields referencing the act of reconciling refers to the process of matching within BK Bank Reconciliation (BKUPRC) page.

Bank ID: An internal code for the bank account providing the statement details. The drop-down arrow is only active when in Search/Find mode or manually adding a new statement.  The options available in the drop-down menu will be the valid statements loaded to BKUPBA previously.

The bank identification codes will be the same as those presented within the BK Update Check/Deposit Info (BKUPCD) page. The goal is to match each BKUPCD record with a detail record of a corresponding bank statement. For instance, a check paid via Bank ID "AP" will be reconciled against a bank statement for Bank ID "AP". The detail record will be managed within BKUPCD while the bank statement will be managed within BKUPBA.

Statement End Date: The statement date per BKUTLB, or the end date given by user during manual data entry. Best practice is to use the bank's statement date that typically indicates the cut-off date for the transaction data.

Statement End Amount: Enter a value manually. Consider using a bank statement's ending balance. (Optional)

Recon Status: The status of the bank statement, as a whole, indicating where it is in the reconciliation process. Valid options are A (Approved), N (None), or P (Pending).

Recon Date: The date the bank statement was reconciled and marked as Approved.

Source File Name: The name of the system file that was loaded into the BK database via BK Load Bank Reconciliation File (BKUTLB) utility. The file is not accessible yet will assist in validating and blocking the entry of duplicate bank records directly into BKUPBA page.

Source File Date: The date the file was loaded to BusinessPlus.

Recon User: ID of the user who reconciled and ultimately approved the bank statement.

Creating User: ID of the user who loaded the bank file to BusinessPlus.

Finance Record

Recon Document Type, Recon Document Number, Recon Date, Recon Status, and Match Status fields will remain empty until items are reconciled. When using the BKUTLB utility to load a bank file to BKUPBA, the statement is converted and interfaced with BusinessPlus using a series of NU Common Codes with a Code Category/Value of BKRC/xxYYYY where xx is a specific bank. Many of the fields within this section validate to one of these BKRC common codes.

Document Type: Indicates the category of document the bank is referencing. Valid types are ADJ (Adjustment), CHK (Check), DEP (Deposit), EFT (Electronic Funds Transfer), FEE, and INT (Interest). (Options validate to BKRC/xx[Type] code where Type is ADJ, CHK, and so on.)

Document Number: The reference number provided by the bank for the document. (Validates to BKRC/xxCKNUM.)

Entry Date: The date the document cleared the bank. This date will load with the bank statement via BKUTLB. This date will also populate BKUPCD's Cancel Date field after record is reconciled and approved. (Validates to BKRC/xxCKDATE.)

Amount: The value of the item clearing the bank. The amount will load with the bank statement via BKUTLB. (Validates to BKRC/xxCKAMT.)

Override Amount: If the amount provided by the bank is not correct, enter the amount used to reconcile the document. An Override Amount is typically added by a user in BKUPRC during reconciliation after research to affirm the correct value. When there is a legitimate error, the system will bring in the override amount typed into BKUPRC and insert into BKUPBA.

Source File Record Number: Indicates the sequence in which each item on the bank statement appeared in the bank file. The system will automatically update this field with content from the BKUTLB upload process.

Record Information

Recon Document Type: Identifies the document type used to reconcile the active bank record. The system will automatically update this field. This field will remain empty until an item has been reconciled. The system will automatically update this field.

Recon Document Number: The reference number from BKUPCD that identifies which specific document matched the active bank record. The system will automatically update this field. This field will remain empty until an item has been reconciled.

Recon Date: The date the document was reconciled. The system will automatically update this field.

Recon Status: The reconciliation status. The code displayed represents where the record is in the reconciliation process. Valid options are A (Approved), N (None), or P (Pending).

Match Status: The field describes how a record was reconciled. The Match Status will be N until the statement is open and either saved or approved within BKUPRC.