PRINT BANK STATEMENT REPORT

Use the Bank Statement Report screen to print the bank statement that you uploaded into Costpoint using the bank statement upload feature on the Manage Bank Statement Information screen.

You can sort the statement by either the transaction date or by the transaction ID (the check number).

Print and review this report after you upload your bank statement and before reconciliation. Verify that all uploaded data is correct. If you find an error in the statement, you can delete the uploaded bank statement on the Enter/Manage Bank Statement Information screen.

In addition, you can use this report to obtain the information that is necessary for any adjusting entries to your General Ledger. You can use the Adjust Currency Balances screen to make necessary journal entries to your General Ledger.

You can print this statement as many times as necessary.

If you reconcile your bank statements manually, you cannot print this report.

Location

Identification

Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.

You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.

Parameter ID

Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made in the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display in the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Bank Abbrev

Option

This field displays One to indicate that you can enter only one bank abbreviation.

Start

Enter a bank abbreviation, or click to select a bank abbreviation from a list. The bank abbreviation description displays in the field to the right.

Currency

Option

This field displays One to indicate that only one currency displays in the Start field.

Start

This field displays the currency that is associated with the bank abbreviation that you entered. The currency abbreviation displays in the field to the right.

Statement End Date

Option

This field displays One to indicate that you can enter only one statement end date.

Start

Enter a statement end date for the report, or click to select a statement end date from a list. The list from which you can select statement end dates comes from the Enter/Manage Bank Statement Information screen.

This report prints information for only bank statements that are uploaded. If you select a Statement End Date where the File Upload is set to N in , the printed report has no entries.

Accounting Period

This row displays information based on what you enter in the Statement End Date field. When you click to enter a statement end date in the Statement End Date field, the fiscal year, period, and subperiod for that statement end date that displays in the list displays in the corresponding fields in the Accounting Period row.

Option

This field displays One to indicate that one accounting period displays in the fields in this row.

Fiscal Year

This displays the fiscal year for the statement end date that you entered on this screen.

Period

This field displays the period for the statement ending date that you entered on this screen.

Subperiod

This field displays the subperiod for the statement ending date that you entered on this screen.

Sort By

1st Sort

From the drop-down list, select an option to determine how to sort the report.

The options are:

If you sort your report by Date, the report prints a running total for each line. This feature is not available when you sort by Number.