Bank Reconciliation Report

Use this report to assist with the bank reconciliation process. The detailed version of this report lists all transactions by type for a specific bank, and presents a reconciliation summary so that the bank balance can be compared with the balance of the general ledger account of the bank.

You can reconcile the report as at a statement date (which may be mid-month), or to the period end.

Header Details

• Custom heading
• Report process date & time
• Page number
• Period end date
• Bank account code, number, and description
• Statement number for reconciliation
• Overdraft limit
• Bank account currency

Report Body

The body of the report outputs this detail:

• Statement Closing Balance

In Bank not in GL

• Plus Unmatched Payments
• Less Unmatched Receipts
• Less Unpresented Cheque Refunds (applicable only if the AR Refunds sub-module is in use)

+ Receipts in GL not in Bank

• Bank deposits
• Receipts
• Transfers in

- Refunds in GL not in Bank (applicable only if the AR Refunds sub-module is in use)

• Unpresented cheques (including. held cheques, which is flagged on the report with an asterisk if printed in detail)
• Direct credits (including detail if the Include Direct Credit detail parameter is selected)
• Credit cards

- Payments in GL not in Bank

• Unpresented cheques (including held cheques, which is flagged on the report with an asterisk if printed in detail)
• Direct credits (including detail if the Include Direct Credit detail parameter is selected)
• Transfers out

+/- GL Journals

• Closing Bank Balance
• Variance

For each of the transaction type groups, this line detail displays if the Summary option is not selected in the report parameters:

• Transaction date
• Transaction reference
• Transaction description/narration
• Transaction value

A sub-total of transactions is printed for each transaction type group.

If the report is printed in detail (for example, the Summary parameter is not selected), a reconciliation summary prints at the base of the report using the format outlined above.

Note: You can include reconciled items in the report by specifying a Reconciled from Statement in the report parameters.

Bank Account Code

Enter the code of the bank account to reconcile.

Statement Number

Enter the number of bank statement to include in the report.

To Period End

Select this option to reconcile the account to the end of the current period.

Reconciled From Statement

Enter the number of the bank statement from which to perform the reconciliation.

Summary Only

Select this option only include a summary of all transactions in the report.

Include Direct Credit detail

Select this option to include all transactions by their type, from the bank specified in the Bank Code field in the report.

• Bank Statement Entry
• AR Refunds
• Generic Reporting Options