PRINT BANK STATEMENT REPORT

Use this screen to print the bank statement that you uploaded into Costpoint using the bank statement upload feature in the Maintain Bank Statement Info screen.

With this 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 uploading 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 in the Maintain Bank Statement Info screen.

In addition, you can use this report to obtain the information necessary for any adjusting entries to your General Ledger. You can use the Currency Balance and Adjustments screen to make necessary journal entries to your General Ledger.

You can print this statement as many times as necessary.

Note: If you reconcile your bank statements manually, you will be unable to print this report.

Select Bank Account

Bank Abbr

Enter, or use the drop-down list to select, a bank abbreviation.

Currency

This non-editable field displays the currency that is associated with the bank abbreviation you selected.

Select Date

Statement End Date

Enter, or use to select, the statement end date for which you need to print the bank statement report. The list of statement end dates that can be selected comes from the Maintain Bank Statement Info screen and is stored in the BANK_ACCT_END_BAL table.

Please note that this report will print information only for bank statements that are uploaded. If you select a Statement End Date where the File Upload is set to "N," the report printed will not have any entries.

Fiscal Year

The Fiscal Year automatically defaults in from the Statement End Date selected. This field is non-editable.

If you use to fill the Statement End Date field, you will see that each statement end date listed has a Bank Abbr, FY, Pd, Subpd, and a File Upload column. When you select a statement end date, the information from each of the other columns automatically defaults into its corresponding field.

Period

The Period automatically defaults in from the Statement End Date selected. This field is non-editable.

If you use to fill the Statement End Date field, you will see that each statement end date listed has a Bank Abbr, FY, Pd, Subpd, and a File Upload column. When you select a statement end date, the information from each of the other columns automatically defaults into its corresponding field.

Subperiod

The Subperiod automatically defaults in from the Statement End Date selected. This field is non-editable.

If you use to fill the Statement End Date field, you will see that each statement end date listed has a Bank Abbr, FY, Pd, Subpd, and a File Upload column. When you select a statement end date, the information from each of the other columns automatically defaults into its corresponding field.

Sort By Transaction

Date

Select this option to sort the report by transaction date. When this option is selected, the report prints the Transaction Date as its first column.

Note: If you sort your report by Transaction Date, the report will print a running total for each line. This feature is not available when you sort by Transaction Number.

Number

Select this option to sort the report by number. When this option is selected, Check Number is the first column of the report.