Bank Reconciliation > Reconcile Bank Account > Reconciliation Reports > Bank Reconciliation Report

The Bank Reconciliation Report - Previous Statement function allows you to print or preview details about a previously completed and finalized bank reconciliation project for a certain bank account. The report shows the exact same information as what would have been shown when reconciliation for that statement period was performed before it was finalized. Included in the report are bank transactions that would have appeared at the time the bank reconciliation was performed. You must specify a bank account and an ending statement date in order to generate the report.

The Bank Reconciliation Report - Previous Statement includes the following set of reports:

oDeposits and Other Receipts Report

This report shows details of all previously reconciled deposit and other receipt transactions shown in the Bank Reconciliation Bank Summary Report. It shows details such as transaction type, transaction date, transaction number, reconciled date, description, reference, source module and reconciled amount. It also shows deposits and receipts that were still future-dated or in-transit at the time the bank reconciliation was completed and finalized. This report facilitates review on deposits, receipts and transfer transactions in your bank account.

oChecks and Other Disbursements Report

This report shows details of all previously reconciled checks and other disbursement transactions included in the Bank Reconciliation Bank Summary Report. It shows details such as transaction type, transaction date, transaction number, reconciled date, description, reference, source module, reconciled amount. It also shows checks and other disbursements that were still outstanding or future-dated at the time the bank reconciliation was completed and finalized. This report is useful for reviewing checks, other disbursements and transfer transactions in your bank account.

oBank Reconciliation Bank Summary Report

This report provides summary information on a bank account’s finalized reconciliation project that included the reconciled deposits and other receipts total amount, reconciled checks and other disbursements total amount, and outstanding checks and other disbursements. More importantly, this report shows the bank account’s calculated book balance and calculated bank balance as of the report's end statement date, calculated cash account balance in GL as of the report's end statement date, and any out-of-balance amounts. This report gives you a quick status view of the completed and finalized reconciled bank account for reviewing previous bank reconciliations or use as reference.

This report has the following uses:

•To help in verifying the accuracy of your bank account reconciliation.

•To serve as a reference in reviewing and monitoring reconciled bank transactions in prior bank statement periods.

To generate the Bank Reconciliation Report - Previous Statement, follow these steps:

1.Access the Bank Reconciliation Report - Previous Statement function from the Bank Reconciliation group under the Reports main menu in the Bank Reconciliation module.

2.Click the List box button next to the Configuration field; then, select the report configuration that you want to use.

3.Select the report sorting option by clicking on the List box button next to the Sort By field.

4.In the Layout field, click the List box button to select the report layout you want to use in generating the report.

5.In the Report Configuration area, define the desired report filters.

6.In the Ending Statement Date field, enter the date that matches the bank statement end date for the bank statement period you want to generate. Alternatively, you may click the Calendar button to display the system calendar where you can select the date.

7.Select any of the following options:

•Hide Bank Account #

•Encrypt Bank Account #

•Show Bank Account # (Note that the full, unencrypted bank account numbers will show only if the user generating the report has the necessary access right.)

8.Click the Preview or Print button to preview or print the report. Click the Configure tab to return to the report configuration page.

The Bank Reconciliation Report - Previous Statement function also provides you with flexibility to perform the following:

Bank Reconciliation Report - Previous Statement

Bank Reconciliation Report - Previous Statement

See Also