How to Do Bank Reconciliation in the FreshBooks Plus Plan: A Canadian Small-Business Guide

Disclaimer: This article is general information only. It is not tax, legal, or accounting advice. Requirements change and depend on your province or territory and your business structure. Confirm current requirements with the Canada Revenue Agency (CRA), Revenu Québec where relevant, or a qualified Canadian professional.

Why Bank Reconciliation Matters for Canadian Small Businesses

Bank reconciliation compares your accounting records with your bank or credit card statements to confirm that they agree. For a Canadian business, it is one of the simplest ways to catch errors before they reach a GST/HST return, a payroll remittance, or an income tax filing.

The CRA expects your books to support the figures you report. Reconciled records make that support easier to produce. FreshBooks can streamline the work through bank connections and a guided reconciliation tool, though you should confirm that your plan includes the features you need (see below).

This guide covers the concept, the FreshBooks setup and workflow, simple accuracy metrics, and the CRA and provincial points to check.

Understanding Bank Reconciliation

What Is Bank Reconciliation?

You compare each transaction in your accounting software with your statement for the same period. Your ending balance in the books, adjusted for timing differences such as outstanding cheques or deposits in transit, should equal the statement’s ending balance.

The CRA does not require a specific reconciliation method. However, the Income Tax Act and Excise Tax Act require you to keep adequate records, and reconciliation is a practical way to show that yours are complete and accurate.

Key Benefits

• Fewer discrepancies: You catch duplicates, missed deposits, bank errors, and unauthorized charges early.
• Better cash flow management: You see your real cash position, not just what you have invoiced.
• More reliable financial statements: Your accountant works from verified numbers, which can reduce year-end clean-up costs.
• Stronger tax reporting: Expenses, sales, and GST/HST amounts are less likely to be missed or double-counted.

Setting Up FreshBooks for Reconciliation

Confirm Your Plan and Features

FreshBooks changes its plan names, pricing, and feature availability from time to time. Before you start, check the FreshBooks pricing page or your account settings to confirm that the Plus plan includes bank reconciliation and bank connections as you expect. Menu labels in this article may also differ slightly from what you see.

Link Your Bank Accounts

1. Log in to FreshBooks and open the banking or bank connections area (usually under the expenses or accounting menus).
2. Search for your Canadian financial institution and sign in through the secure connection.
3. Select the business chequing, savings, and credit card accounts to import.
4. Choose the date from which transactions should import.

Not every Canadian institution supports automatic feeds equally well. If yours does not, you can usually upload statement files instead. Check the file formats FreshBooks currently accepts.

Assumption: Use dedicated business accounts. Mixing personal and business spending makes reconciliation harder and creates tax issues. If you operate as a corporation, personal expenses paid from the corporate account may need to be treated as shareholder loans or taxable shareholder benefits, so ask your accountant how to handle them.

Customize Account Settings

• Currency and fiscal year-end: Set Canadian dollars as your default currency. Make sure your fiscal period matches your actual year-end. Sole proprietors generally use a December 31 year-end for income tax purposes, while corporations choose their own.
• Sales tax settings: Enter your GST/HST registration details and, if applicable, your PST or QST information. Confirm that tax names and rates match current CRA, provincial, or Revenu Québec guidance.
• Bank feeds: Turn them on so new transactions arrive automatically. Review them before relying on them. A feed supplements your records but does not replace your review.
• Opening balance: Make sure each account’s starting balance agrees to a statement. Many persistent reconciliation differences begin here.

Step-by-Step Reconciliation in FreshBooks

Access the Reconciliation Tool

In the Plus plan, look for the bank reconciliation option in the accounting section of the main menu. Select the account, then enter the statement’s ending date and ending balance. The tool typically shows the statement balance, the cleared balance in FreshBooks, and any remaining difference. Your goal is a difference of $0.00.

Review Transactions

1. Download your statement from online banking as a PDF, or a CSV if you want to compare line by line.
2. Match transactions in FreshBooks to the statement lines by date, amount, and payee.
3. Check categories and tax: Confirm each expense category and the GST/HST, PST, or QST recorded. Bank fees and interest are generally not subject to GST/HST on their own, but treatment varies, so verify unusual items.
4. Investigate differences such as amounts that do not match, items missing from either side, or timing differences at month-end.

Finalize Reconciliation

• Mark matched transactions as reconciled and finish once the difference is zero.
• Save or export the reconciliation report and statement as support, and store them with your other records.
• Record who completed the reconciliation and when, especially if several people work in the books.

Troubleshoot Common Issues

• Unmatched transactions: Check for different dates, split payments, or payments grouped into one deposit (for example, payment processor payouts that net out fees).
• Duplicates: These often occur when a transaction was both imported and entered manually. Delete or merge the extra entry.
• Missing transactions: Add them manually or re-import the statement period. Look for cash withdrawals, pre-authorized debits, and e-transfers.
• Persistent difference: Compare the opening balance and check for changed or deleted transactions in a previously reconciled period.

Practical Metrics for Reconciliation

These are internal management measures, not CRA metrics. Use them to track the qu

Disclaimer: The content on this website is AI-generated for informational and educational purposes only. It does not constitute certified financial, tax, or legal advice. Because accounting standards and local tax codes vary frequently, readers should consult a qualified accountant or certified professional before making any financial decisions based on this material.