Bank Reconciliation Report Fields

Here is a list of the fields that make up the bank reconciliation report. The bank reconciliation report is available on the Bank Reconciliation Report tab of the Bank Account page.

Summary Cards

The summary cards on the bank reconciliation report display the following information, in the bank account currency, for the selected date range.

Summary Card Descriptions
Card Description
Bank Statement Opening Balance Taken from the last bank statement line item balance before the selected start date of the report.
Opening Difference Displays the difference between the bank statement opening balance and the bank account opening balance.
Sum of Unreconciled Bank Statements Lines Displays the total value of bank statement lines that do not have the status "Reconciled".
Sum of Unreconciled Transaction Lines Displays the total value of transaction lines that do not have the status "Reconciled".
Remaining Difference Displays the difference between the unreconciled bank statement lines and the unreconciled transaction lines.

Balance Analysis

The balance analysis section contains the following columns and rows.

Balance Analysis Fields
Field Description
Bank Account Values This column displays the bank account values for the selected date range.
Bank Statement Lines This column displays the values of bank statement lines for the selected date range.
Difference For each row, the difference is the bank statement lines minus the bank account values.
Opening Balance

The opening balances are calculated as follows:

  • Bank Account Values. Taken from the opening balance in period 000 plus the cumulative values of all transaction lines for the bank account up to (but not including) the selected start date for the report.
  • Bank Statement Lines. Taken from the last bank statement line item balance before the selected start date of the report. If more than one value exists, the higher value used. If no bank statement line item balance value exists, the opening balance is zero.
Sum of Movements

The sum of movements are calculated as follows:

  • Bank Account Values. The sum of all the bank statement line values for the selected date range of the report.
  • Bank Statement Lines. The sum of all the transaction line bank account values for the selected date range.
Closing Balance

The closing balances are calculated as follows:

  • Bank Account Values. Taken from the opening balance in period 000 plus the cumulative values of all transaction lines for the bank account up to and including the selected end date for the report.
  • Bank Statement Lines. Taken from the bank statement line balance on the selected end date of the report. If more than one value exists the higher value is used. If no value exists the closing balance is zero.

Unreconciled Bank Statement Lines

The unreconciled bank statement lines section contains the following columns.

Unreconciled Bank Statement Line Fields
Column Description
Line ID Number of the bank statement line.
Amount Value of the payment or receipt.
Reference Reference taken from the bank statement line, such as a check number or payee name.
Description Description on the bank statement line.
Date The date on the bank statement line.

Unreconciled Transaction Lines

The unreconciled transaction lines section contains the following columns.

Unreconciled Transaction Line Fields
Column Description
Line ID Unique numeric identifier for this transaction line item.
Bank Account Amount Total value of the line, in the bank account currency.
Line Reference Reference taken from the originating document.
Line Description Description of the transaction line item.
Date The date the line item was created.

Buttons

Buttons and Actions on the Bank Reconciliation Report
Button Description
Export Allows you to export the bank reconciliation report in CSV format.
Refresh button Refresh. Allows you to refresh the information displayed in the report. Use this if, for example, if you have made changes in bank reconciliation that affect the report.
Search You can use the search field to search for bank statement lines. You can search by number, reference, or description.
Select Dates Displays the Select Dates window. You can use this window to select the dates that you want to view unreconciled lines for and generate the report.