Bank Reconciliation Report Tab

Use this tab to print a bank reconciliation report, which includes details that result from a bank reconciliation.

Two types of bank reconciliation reports are available: Summary and Detail.

The summary report is a single page report. The header lists the bank, general ledger account and reconciliation date. The body includes two columns. The general ledger column includes total for the ending general ledger account balance, interest earned, service charges, and general ledger adjustments, which nets to the adjusted general ledger balance. The bank column includes total for the ending bank balance, deposits in transit, outstanding checks, and bank adjustments, which nets to the adjusted bank balance.
The detail report consists of the summary report plus detailed sub-reports. The sub-reports include lists of the following items: unreconciled checks, unreconciled deposits, unreconciled bank adjustments, unreconciled GL book adjustments, outstanding checks, and outstanding deposits.

In addition, you can select the option Include Reconciled to include reconciled transactions in the results.

Note

The report includes only bank accounts to which you have access.

From the eFinancials menu, select Reports—GL Reports—Bank Reconciliation.
From the Bank Account drop-down list, select an account for the report.
From the Bank Recon Dates the drop-down list, select a date for the report.
To print a summary report, select the Summary radio button. Or, to print a detailed report, select the Detail radio button.
To include reconciled checks and deposits on the report along with outstanding checks and deposits, select the Include Reconciled check box.
Select one of the following report printing options:

PDF Format: Print the report in PDF format for use in a PDF viewer, such as Acrobat.
Create Spreadsheet: Prints the report in an Excel spreadsheet.

Click Print. If you selected Create Spreadsheet, you are prompted to open or save the report Excel file. Otherwise, the report opens in PDF format.