Bank Account Reconciliation Report

The Bank Account Reconciliation Report is reached by selecting Reports > Banking > Bank Account Reconciliation Report.

It reports on completed reconciliations only, and voided items are not included.

The report can be run to show the effects of temporary GL journal entries by setting the Include Unposted Transactions parameter to Yes.

It can be created as an Excel file with up to 4 worksheets or a PDF file.

The worksheets contain the following information:

• Bank Reconciliation: Last reconciliation & statement dates, beginning & ending balances, transaction date, source document, item number, description, and deposit or withdrawal amount.

• Outstanding: Last reconciliation & statement dates, beginning balance, transaction date, source document, item number, description, and deposit or withdrawal amount for items outstanding after reconciliation

• Actual GL Detail: Transaction date, source, number, & comment, account code, and debit or credit amount

• GL Reconciliation: Beginning balance, deposits/debits, and withdrawals/credits for the following equation: Bank reconciliation + Outstanding = Expected GL - Actual GL = Difference

Report filters & parameters are:

• Accounting cycle

• Bank

• Bank account

• Statement date

• Include unposted transactions — yes or no

Sample Bank Reconciliation

Sample Outstanding

Sample Actual GL Detail

Sample GL Reconciliation

Return to Banking Reports Overview