Cheque Listing by Bank Report

The Cheque Listing by Bank Report screen is divided into two sections; System Parameters and User Parameters. In the System Parameters section, the user must specify details for the format of the report; in the User Parameters section, the user must specify details pertaining to the content of the report. For general information on running reports and on defining System Parameters, please refer to the Running Reports help document.

Report Description

The Cheque Listing by Bank report is generated based on a user specified range of Bank Accounts, for a user specified range of dates. This report has three sort order options: by Date, Cheque Number, or Payee Name. the report information is grouped by Bank Account, and then within each grouping, will be sorted according to the selected sort order.

Each Bank Account section will be totaled per Cheque Status (i.e. Reconciled, Not Reconciled, Reversed). Report details include Cheque Date, Cheque Number, Transaction Reference ID, Payee, Cheque Status, and Cheque Amount.

The Cheque Listing by Bank report does include Requisitioned Cheques. Since this report is generated based on a date range, it is not a balancing report.

User Parameters

Start Bank, End Bank
From the list provided, the user must select the Bank Accounts that will define the range of accounts that are included in the report. The user also has the option to manually enter the Bank Account Number. Only information about Cheques that are associated with the Bank Accounts within this range will be included in the report. These fields default to the first and last Bank Accounts in the list.

Date X to X
The user must manually enter the range of dates for which the report will be generated. Only those Cheques that are dated within this date range will be included in the report. These fields default to the current system date.

Sort By
From the list provided, the user must select the sort order by which the report information will be presented. Valid options include Date (i.e. Cheque Date), Cheque Number, Payee Name, and Cheque Status (i.e. Reconciled, Not Reconciled, Reversed). This field defaults to the Date option.