What is the Bank Reconciliation Summary report?

The Bank Reconciliation Summary is a report that makes it easy to review how organized your accounts are and if there are any remaining transactions to be matched in your Bank Reconciliation. This report is also useful for reviewing all unmatched transactions across all bank accounts, as well as any expenses and payments logged in your FreshBooks account that have yet to be matched. 

Accounting features like Bank Reconciliation and the Bank Reconciliation Summary report are available on trials as well as Plus, Premium and Select plans only. We also recommend inviting an accountant (if you haven’t already) to help you learn more about Bank Reconciliation.

 

You can run a Bank Reconciliation Summary by doing the following:

  1. Go to the Reports section
  2. Select Bank Reconciliation Summary under Accounting Reports.

 

To adjust your view of the Bank Reconciliation Summary report, click on Filters under Settings. From there, you can change:

Bank reconciliation summary report with filters available.

  • Reset all - Select this link to restore the filters back to the default settings
  • Date Range - Choose from Today, End of Last Month, or Custom to enter a specific date range (or if you’ve changed your fiscal year end date, choose from the extra options)
  • Bank Account - Choose which Bank Account you want to view transactions from

 

Overview

The report displays the below:

  • Unmatched FreshBooks Entries - These are displayed first and show all your Payments and Other Income and your Expenses that have yet to be matched to transactions in your Bank Account.
  • Unmatched Bank Transactions from (Bank Account) - These are entries from your connected Bank Account that have yet to be matched to entries from FreshBooks.

 

Additional options can also be accessed in the top right corner of the Bank Reconciliation Summary report:

  • More Actions
    • Export for Excel - Download the report as a CSV file
    • Print or Save PDF - Print the report or save the report as a PDF using the print dialog
  • Send To… - Send the report to any specific email addresses