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.Use this screen to store statement and timing information for a bank account.
If you are not uploading a bank statement:
Each month when you receive a bank statement, you enter the fiscal year, period, subperiod, and bank statement ending date and ending balance on this screen. This information is used to create the Bank Reconciliation Inquiry and the Bank Reconciliation Summary Report.
If you are uploading a bank statement:
To upload your bank statement files from your bank to this screen, you must first complete the information on the Upload Bank Settings tab of the Manage Company Bank Accounts screen.
Every time you upload a bank statement using the Manage Bank Statement Information screen, you must set the FY/Pd/Subpd default settings for these columns by selecting Options ยป User Preferences from the menu, and then click the Change Default Period link on the User Preferences screen.
You must initiate this screen when you use bank reconciliations for the first time and for each subsequent bank reconciliation.
If you are uploading your bank statement from a file, you must use this screen to upload the statement.
Enter, or use 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 screen.
This field displays the bank account number that was set up for this bank on the Manage Company Bank Accounts screen.
This field displays the currency that you entered for this bank on the Manage Company Bank Accounts screen.
Complete these fields to upload a bank statement from your bank into Costpoint.
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.
This button is active only if you have uploaded a bank statement file. Use it to view the detail for the transactions that were imported. You can also obtain a printed report of the statement by selecting the Print Bank Statement Report.
Review the transactions that you uploaded before you reconcile your bank statement. This gives you the opportunity to make any of the necessary adjusting journal entries to balance your bank account to your general ledger.
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 
.
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.
Enter the beginning book balance in the bank account currency in this field.
This column displays Y (Yes) or N (No) to indicate the upload status of your company's bank statement.
|
Subtask |
Description |
|
Bank Statement Details |
Click this link to open the Bank Statement Details subtask to view more detailed information for a bank statement. |