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

The Bank Reconciliation Report - Current function allows you to print or preview details about a current reconciliation project processed for a bank account. The report only includes transactions not yet part of a finalized bank reconciliation. You must specify a bank account and a report date in order to generate the report.

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

oDeposits and Other Receipts Report

This report shows details of all the deposits and other receipts transactions included in the Bank Reconciliation Bank Summary Report. It shows the transaction date, transaction number, description, reference, source module and amount. It also shows whether the transaction has been tagged as reconciled or in-transit during the current reconciliation project. It also shows deposits and receipts that are future-dated. 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 checks and other disbursement transactions included in the Bank Reconciliation Bank Summary Report. It shows the transaction date, transaction number, description, reference, source module, amount, as well as whether the transaction has been tagged as reconciled during the current reconciliation and its reconcile date. It also shows checks and other disbursements that are future-dated. 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 current reconciliation project that includes the reconciled deposits and other receipts total amount, reconciled checks and other disbursements total amount, deposits and other receipts in-transit, and outstanding checks and other disbursements. It also shows the reconciled but future-dated checks/other disbursements, and future-dated deposits/other receipts. More importantly, this report shows the bank account’s calculated book balance, calculated bank balance, calculated cash account balance, and any out-of-balance amounts. This report gives you a quick status view of the currently reconciled bank account to help you better manage your cash disbursements or issuance of checks, among other bank transactions.

If reconciliation of bank accounts is not performed regularly, cash balances recorded in AccountMate are not updated for reporting purposes. Misappropriation of cash accounts is possible due to the absence of independent audit of the bank account transactions and may result in poor management of the cash accounts.

This report has the following uses:

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

•To serve as a reference in monitoring bank transactions clearing that were stated as outstanding in prior bank statement periods.

To generate the Bank Reconciliation Report, follow these steps:

1.Access the Bank Reconciliation Report - Current 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 Report Date field, enter a date that will serve as a cut-off date (e.g. ending statement date) for the report. Alternatively, you may click the Calendar button to display the system calendar where you can select the date.

7.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 - Current function also provides you with flexibility to perform the following:

Bank Reconciliation Report - Current

Bank Reconciliation Report - Current

See Also