Bank Reconciliation Report

The Bank Reconciliation report is accessed from the Bank Reconciliation Report tab on the Bank Account page. You can use this report to view bank statement lines and transaction line items that have not been reconciled, and bank account analysis. You can select the date range that you want to view unreconciled items for. The report also includes information on the opening and closing balances of your bank accounts and bank statement, the sum of movements for the account and statement, and the differences between these items.

The report displays the following sections:

  • Summary cards showing the opening balance, the total valuer of the unreconciled bank statement and transaction lines, and the difference between the unreconciled items.
  • Balance analysis showing opening and closing balances for your bank accounts and bank statements, the sum of movements for each and the difference, if any, between the account and the statement lines.
  • All unreconciled bank statement lines that do not have the status "In Progress" or "Reconciled".
  • All unreconciled transaction line items that do have the status "In Progress or "Complete".
Note:

If there is no data available, the summary cards and balance analysis display zero values.

For more information, see Bank Reconciliation Report Fields.

Tip:

This report has been optimized for generation after most of the lines on a bank statement have been reconciled. The unreconciled bank statement lines and unreconciled transaction lines section are limited to 200 lines each. The summary cards and balance analysis include any lines that cannot be displayed.

If you generate the report for a large date range or have a lot of unreconciled transaction line items, you can encounter the maximum query limit of 30,000 transaction lines.

If your report exceeds any of the line limits, you can either run bank reconciliation to reduce the number of unreconciled lines or re-generate the report using a smaller date range.

Generating the Report

To generate the bank reconciliation report:

  1. Navigate to the Bank Accounts tab.
  2. Click a bank account name to display the Bank Account Details page.
  3. Click the Bank Reconciliation Report tab
  4. Click Select Dates. A date selection window displays.
  5. Select the date range that you want to view bank reconciliation information for.
  6. Click Generate.

Refreshing the Report

Once you have generated the report, you can refresh the report if you make changes in bank reconciliation that affect the data displayed. To refresh the report, click Refresh button.

Exporting the Report

Once you have generated the bank reconciliation report, you can export it in CSV for further analysis, if required.

To export the report:

  1. Generate the bank reconciliation report.
  2. Click Export.
  3. [Optional] Enter a name for the report.
  4. Click Save.