to select the desired fiscal year.Use this screen to enter and store statement and timing information for a bank account.
If you are not uploading a bank statement:
Each month, when you receive the bank statement, you should enter the FY/Pd/Subpd data and the bank statement ending date and ending balance in this screen. The system will use this information to create the Bank Reconciliation Inquiry and the Bank Reconciliation Summary Report.
If you are uploading a bank statement:
You will need to set the FY/Pd/Subpd defaults for these columns by selecting Options from the menu, followed by Preferences, then Change Default Period. You will need to do this every time you upload a bank statement.
You must initiate this screen when using 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.
In this group box, you can enter or select the desired bank abbreviation for which bank statement information will be entered or uploaded. The description for the bank abbreviation that was set up in the Maintain Company Bank Accounts screen automatically displays.
Enter a valid bank abbreviation or select a bank abbreviation from the drop-down list in this required field. The bank abbreviation represents the bank account for which you want to edit or view statement and timing information. The description for the bank abbreviation that was set up in the Maintain Company Bank Accounts screen automatically displays.
This non-editable field displays the bank account number that was set up for this bank abbreviation in the Maintain Company Bank Accounts screen.
This non-editable field displays the currency that you entered for this bank abbreviation in the Maintain Company Bank Accounts screen.
This field is automatically populated when you select a Bank Abbr and if you entered a default in the Upload Bank Settings subtask in the Maintain Company Bank Accounts screen. If you did not enter a default value in the Upload Bank Settings subtask, you must enter the location of your upload file. This field is editable.
Click this button to activate the Select Input File dialog box. Use this dialog box to select your upload file.
Click this button to upload the bank statement from the location you specified in the File Location field. This will import the data from your bank statement file into Costpoint. If you did not set up the Upload Bank Settings subtask in the Maintain Company Bank Accounts screen correctly, you will be prompted with an error message when you attempt to upload the file.
In addition, you must define the desired FY/Pd/Subpd you would like defaulted for this bank statement. You can set this default by selecting Options from the main menu, followed by Preferences, and then Change Default Period.
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 reconciling your bank statement. This will give you the opportunity to make any of the necessary adjusting journal entries to balance your bank account to your G/L.
You should enter the data applicable for the monthly bank statement received from the bank in this table window. To enter data for a new row, use the New Line button on the toolbar.
Enter the fiscal year for this bank statement in this required field,
or use to select the desired fiscal year.
If you are uploading your bank statement, set this default by selecting Options from the main menu, followed by Preferences, and then Change Default Period.
Enter the accounting period for this bank statement in this required
field, or use to select the desired accounting period.
If you are uploading your bank statement, set this default by selecting Options from the main menu, followed by Preferences, and then Change Default Period.
Enter the accounting subperiod for this bank statement in this required
field, or use to select the desired accounting subperiod.
You will normally enter the last subperiod for the month (unless there
are unusual circumstances).
If you are uploading your bank statement, set this default by selecting Options from the main menu, followed by Preferences, and then Change Default Period.
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 editable column.
Enter the bank statement beginning balance in this editable, optional column. If you do not enter a beginning balance, a "0" will default in.
If you uploaded your bank statement, this column has the beginning balance from your file. If the amount you see 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 column has the bank statement ending date from your file. If the amount you see 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 optional field.
Enter the beginning book balance in the bank account currency in this editable column.
This non-editable column displays the upload status of your company's bank statement.