Enter, or click to select, a bank abbreviation for the bank whose statement information you want to enter, view, or upload. The bank abbreviation description displays in the field to the right.

A bank's abbreviation is set up on the Manage Company Bank Accounts screens for either US or non-US banks.

This field displays the currency that you entered for this bank on the Manage Company Bank Accounts screen.

This field displays the bank account ID that was set up for this bank on the Manage Company Bank Accounts screen. Other than a US Bank Account ID, Costpoint will also search for one of the following fields that correspond to the selected bank abbreviation:

• Non-US Bank Account ID
• IBAN Code
• SWIFT Code

Costpoint searches for the said fields in the same order as they are listed above.

This field is populated automatically when you enter a bank abbreviation on this screen and you entered a default file location in the Alt File Location field on the Upload Bank Settings tab of the Manage Company Bank Accounts screen. You can modify the file location on this screen as needed.

If you did not enter a default file location on the Upload Bank Settings tab, enter the location of your upload file in this field.

This field is populated automatically when you enter a bank abbreviation on this screen and you entered a default file name on the Upload Bank Settings tab of the Manage Company Bank Accounts screen. You can modify the file name on this screen as needed.

If you did not enter a default file name on the Upload Bank Settings tab, enter the location of your upload file in this field.

Click this button to upload the bank statement from the location that you specified in the File Location and File Name fields. This imports the data from your bank statement file into Costpoint. If you did not complete the settings on the Upload Bank Settings tab of the Manage Company Bank Accounts screen correctly, you receive an error message when you attempt to upload the file.

In addition, you must enter the fiscal year, period, and subperiod for a bank statement. To set this default, open the Configure User Preferences screen, and then click the Change Default Period link.

If you select this check box and delete a bank statement, any matched rows for the bank statement detail are also deleted.

Select this check box if you want the program to continue processing if it encounters duplicate deposit information in a file.

Select this check box if you want the program to continue processing if the file contains deposit information that already exists in Costpoint.

Select this check box if you want the program to continue processing if it encounters duplicate miscellaneous deposit information in a file.

Select this check box if you want the program to continue processing if the file contains miscellaneous deposit information that already exists in Costpoint.

Select this check box if you want the program to continue processing if it encounters duplicate miscellaneous withdrawal information in a file.

Select this check box if you want the program to continue processing if the file contains miscellaneous withdrawal information that already exists in Costpoint.

Enter the fiscal year for this bank statement in this required field, or click to select the desired fiscal year.

If you are uploading your bank statement, set this default in the Change Default Period link on the Configure User Preferences screen.

Enter the accounting period for this bank statement in this required field, or click to select the desired accounting period.

If you are uploading your bank statement, set this default in the Change Default Period link on the Configure User Preferences screen.

Enter the accounting subperiod for this bank statement in this required field, or click to select the desired accounting subperiod. You normally enter the last subperiod for the month (except under unusual circumstances).

If you are uploading your bank statement, set this default in the Change Default Period link on the Configure User Preferences screen.

This non-editable field displays the subperiod ending date for the selected fiscal year, period, and subperiod combination. ( Subperiod ending dates are established in the Subperiods screen in Costpoint General Ledger.)

Enter the bank statement beginning date in this optional field.

Enter the bank statement beginning balance in this optional field. If you do not enter a beginning balance, a 0 populates this field.

If you uploaded your bank statement, this field displays the beginning balance from your file. If the amount is incorrect, you can delete the bank statement line, make the necessary corrections to your file, and then re-import your file.

Enter the bank statement ending date in this required field in the MM/ DD/YYYY format.

If you uploaded your bank statement, this field displays the bank statement ending date from your file. If the amount is incorrect, you can delete the bank statement line, make the necessary corrections to your file, and then re-import your file.

Enter the bank statement ending balance in this required field. Although this field is not required, if you are reconciling your bank statement manually, you must enter this data before running the bank reconciliation process (via the View Bank Reconciliation Summary screen and/or the Print Bank Reconciliation Summary Report).

Enter the beginning book balance in the bank account currency in this field. This column displays only if your company's bank account currency is not the same as your company's functional currency. Although this field is not required, you must enter this data before you run the bank reconciliation process (via the View Bank Reconciliation Summary screen and/or the Print Bank Reconciliation Summary Report). You must only enter this amount the first time you upload a bank statement. This field is then set by Costpoint for all subsequent bank statements that you upload.

This column displays Y (Yes) or N (No) to indicate the upload status of your company's bank statement.