Generating Bank Reconciliation Report

This page allows you to generate the bank reconciliation report.

Select the “Bank Reconciliation Report” link under the “EDK – Reports Book Keeping” business component.

The “Bank Reconciliation Report” page appears.

Enter the following in the group box:

Bank Account No.	Use the drop-down list box to select the bank account number. The system lists all the “Active” bank account numbers as identified for the organization unit in the "Bank Cash Definition" business component.
As On Date	The date as of which the bank reconciliation report must be printed (Date Format). Mandatory. By default the system displays the last transaction date of the latest bank statement of the account number entered. Ensure that the date entered is earlier than or equal to the current date.

The system displays the following fields in the group box:

Name	The name of the bank.
Currency	The currency of the organization unit.

Enter the following in the “Print Criteria” group box:

Report Option

Use the drop-down list box to select the report option. The system lists the options as “Summary” and “Detailed”.

Select the “Detail” option to generate a detailed report.
Select the “Summary” option to generate a summarized report.

By default the system displays “Summary”.

View Option

Use the drop-down list box to specify the option based on which the bank reconciliation report must be printed. The system lists the options as “Unmatched Payments in Bank Book”, “Unmatched Payments in Bank Statement”, “Unmatched Receipts in Bank Statement”, “Unmatched Receipts in Bank Book” and “All”.

Unmatched Payments in Bank Book – Select this option to retrieve all the paid payment vouchers across all the finance books with payment date earlier than or same as the “As On Date” entered.
Unmatched Payments in Bank Statement - Select this option to retrieve bank statements with transaction type as “Payment”, “Check Payment”, “Interest Paid”, “Service Charges” and payment date earlier than or same as the “As On Date” entered.
Unmatched Receipts in Bank Statement – Select this option to retrieve bank statements with transaction type as “Receipt”, “Check receipt”, “Interest Received” and payment date earlier than or same as the “As On Date” entered.
Unmatched Receipts in Bank Book– Select this option to retrieve all the receipt vouchers across all the finance books with receipt date earlier than or same as the “As On Date” entered.

By default, the system leaves the field blank. Data entry in this field is mandatory if report option is set to “Detailed”. This field must be left blank if report option is set to “Summary”.

Note: The system considers only those payment vouchers which are in “Unreconciled” status or, are in “Reconciled” or “Confirmed” for reconciliation and the date for the contra document in the bank statement is greater than the “As On Date” entered.

Click the “Print Report” pushbutton, to print the bank reconciliation report.