Contents of the Manage Bank Statement Information Screen

Use the fields and options to configure the Manage Bank Statement Information screen.

Bank Statement Info

Field	Description
Bank Abbr	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.
Currency	This field displays the currency that you entered for this bank on the Manage Company Bank Accounts screen.
Account	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.

Upload Bank Statement

Complete these fields to upload a bank statement from your bank into Costpoint. Before you can upload bank statements for the first time, you must complete the information on the Upload Bank Settings tab of the Manage Company Bank Accounts screen. Make sure that the file that you will upload has a maximum record length of 250 characters.

Field	Description
File Location	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.
File Name	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.
Upload	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.
Clear matchings for a deleted statement	If you select this check box and delete a bank statement, any matched rows for the bank statement detail are also deleted.
Skip duplicate deposit validation	Select this check box if you want the program to continue processing if it encounters duplicate deposit information in a file.
Skip existing deposit validation	Select this check box if you want the program to continue processing if the file contains deposit information that already exists in Costpoint.
Skip duplicate miscellaneous deposit validation	Select this check box if you want the program to continue processing if it encounters duplicate miscellaneous deposit information in a file.
Skip existing miscellaneous deposit validation	Select this check box if you want the program to continue processing if the file contains miscellaneous deposit information that already exists in Costpoint.
Skip duplicate miscellaneous withdrawal validation	Select this check box if you want the program to continue processing if it encounters duplicate miscellaneous withdrawal information in a file.
Skip existing miscellaneous withdrawal validation	Select this check box if you want the program to continue processing if the file contains miscellaneous withdrawal information that already exists in Costpoint.

Table Window

Enter the data applicable for the monthly bank statement received from a bank in this table window. To enter data for a new row, click .

Field	Description
Fiscal Year	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.
Period	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.
Subperiod	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.
Subperiod End Date	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.)
Bank Statement Beginning Date	Enter the bank statement beginning date in this optional field.
Bank Statement Beginning Balance	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.
Bank Statement Ending Date	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.
Bank Statement Ending Balance	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).
Beg Book Balance Bank Crncy	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.
Upload	This column displays Y (Yes) or N (No) to indicate the upload status of your company's bank statement.

Subtask

Subtask	Description
Bank Statement Details	Click this link to open the Bank Statement Details subtask to view more detailed information for a bank statement.