Bank Reconciliation Report

The Bank Reconciliation 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 Bank Reconciliation Report is generated based on a user specified range of Bank Accounts and for a user specified range of Accounting Months. The report information is presented per Bank Account, and is grouped into three sections: Outstanding Cheques, Deposits, and Reversed Cheques. In the User Parameters section of the screen, the user is given the option to include these three sections in the report. If the user selects "N" (i.e. No) for a section, the information will not be included in the report.

Print Outstanding Cheques - If the user selects "Y" (Yes) to this option, all Outstanding Cheques for the selected range of Accounting Months, and a total for these Cheques will be displayed.
Print Deposits - If the user selects "Y" (Yes) to this option, all Bank Deposits for the selected range of Accounting Months, and a total for these Deposits will be displayed.
Print Reversed Cheques - If the user selects "Y" (Yes) to this option, all Reversed Cheques for the selected range of Accounting Months, and a total for these Cheques will be displayed.

For each of the three sections, the following information will be displayed: Cheque/Deposit Date, Cheque Number, Transaction Reference ID, Payee/Description, Journal Type, Journal Number, and the Cheque/Deposit Amount. For Reversed Cheques, the Month/Year of reversal is also displayed.

The report output can be generated into an Excel spreadsheet file, or in the same manner as most other reports (i.e. format selected in the System Parameters section). When generating an Excel file, the user must specify the full path and file name (i.e. c:\My Documents\Bank Reconciliation.xls). Keep in mind that this report can be generated in the manner selected in the System Parameters section AND generated to an Excel file at the same time; there is no need to run the report twice if the user wishes to have Excel output in addition to output in another format.

User Parameters

User Parameters

Print Outstanding Cheques
To include in the report all Outstanding Cheques for the selected Accounts and within the selected Accounting Period, the user must select "Y" (i.e. Yes) from the list provided. To not include Outstanding Cheques in the report information, the user must select "N" (i.e. No) from the list provided. The user also has the option to manually enter either "Y" or "N". This field defaults to the "Y" option.

Print Reversed Cheques
To include in the report all Reversed Cheques for the selected Accounts and within the selected Accounting Period, the user must select "Y" (i.e. Yes) from the list provided. To not include Reversed Cheques in the report information, the user must select "N" (i.e. No) from the list provided. The user also has the option to manually enter either "Y" or "N". This field defaults to the "Y" option.

Print Deposits
To include in the report all Deposits for the selected Accounts and within the selected Accounting Period, the user must select "Y" (i.e. Yes) from the list provided. To not include Deposits in the report information, the user must select "N" (i.e. No) from the list provided. The user also has the option to manually enter either "Y" or "N". This field defaults to the "Y" option.

Start Bank, End Bank
The user must specify the range of Bank Accounts for which the report will be generated. The Bank Accounts can either be selected from the list provided or the unique identifiers can be manually entered. These fields default to the first and last Bank Accounts in the list.

Accounting Month
The user must specify the Accounting Month for which the report will be generated. The Accounting Month can either be selected from the list provided or manually entered. This field defaults to the current Accounting Month.

Accounting Year
The user must manually enter the Accounting Year for which the report will be generated. This field defaults to the current Accounting Year.

Create Excel Output
To send the report contents to an Excel spreadsheet file, the user must select the "Y" (i.e. Yes) option form the drop down list provided. This field defaults to the "N" (i.e. No) option. Keep in mind that this report can be generated in the manner selected in the System Parameters section AND generated to an Excel file at the same time; there is no need to run the report twice if the user wishes to have Excel output as well as output in another format.

Excel Destination
If the user has selected to send the report contents to an Excel spreadsheet file, they must then specify the exact path and name for that file (i.e. c:\My Documents\Bank Reconciliation.xls).