Back
Categories
Back

Categories

      View All

      How do I set up Bank Reconciliation?

      Bank Reconciliation requires a Bank Connection so that you can match transactions from your bank statement to your activity inside FreshBooks. First, you’ll set up a Bank Connection, then you’ll set an Opening Balance. Once completed, you can start reconciling transactions.

       

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

       

       

      Set Up Bank Connection

      Set up a bank account to start importing transactions from with a Bank Connection:

      1. Click on the Accounting section
      2. Click on the Connect My Bank inside the Bank Reconciliation widget
      3. Then set up the Bank Connection with the steps outlined here
      4. Once connected, or if you’ve already connected any bank accounts previously, they’ll appear here, and you’ll see a Set your opening balance link.


      Notes:

      • Investments, Line of Credit and Loan bank accounts will not be displayed in Bank Reconciliation
      • Only connect your business bank account and not your personal bank accounts
      • You can only reconcile in a single currency

       

      Set an Opening Balance

      Once you have a bank account (or several) connected, you’re ready to set the opening balance which will determine the amount you’ll start reconciling with moving forward. Your invited Accountant can also help you with this set up:

      1. Click on the Accounting section
      2. You’ll now see your bank account(s) listed in the Bank Reconciliation widget, click on the Set your opening balance linkSet opening balance link inside Bank Rec widget.
      3. In the field provided, enter a date to start reconciling from (we recommend the first day of a recent bank statement or the start of a period on your credit card statement)
      4. Click Continue
      5. Enter your Opening Balance from the day you chose to start reconciling in the field
        1. If you’re setting up a credit card account, this is your Previous Statement Balance (if you’ve paid off your credit card balance, this would be $0)
      6. Choose the Currency of your bank account you’re reconciling
      7. Then click Continue again
      8. You’re now ready to start reconciling this account. Click Get Started to begin.

      Once you've entered an Opening Balance, the account will be automatically created in your Chart of Accounts. Bank Accounts will be added under Cash, the Parent Account, and Credit Card Accounts will be added under Credit Cards, the Parent Account.

       

      At the top right of your Bank Reconciliation, you'll see two balances which represent different amounts:

      • Bank Account Balance - This includes your Opening Balance entered for this account, and all imported transactions in real-time (as of the most recent sync)
      • FreshBooks Balance - This is your Opening Balance entered for this account, +/- the transactions you have matched in Bank Rec, as well as any Journal Entries that have been posted to this account.
      Once you have transactions to reconcile, see How do I reconcile my transactions in Bank Reconciliation for next steps.

       

      FAQs

      I put in the wrong opening balance, how do I fix this?

      You can reset your opening balance with these steps: 

      1. Click on the Accounting section
      2. Then click on the x left to match link for the account you want to fix the opening balance for
      3. Next, click on the More Actions button
      4. Select Reset Your Opening Balance
      5. Choose a new Reconciliation Start Date
      6. Then enter in the new Account Balance as of Start Date
      7. Click on Continue
      8. Confirm the details and click Reset to finish
      9. You can now match up transactions with the new opening balance.

      What happens if I reset my Opening Balance?

      If the Opening Balance that you set in your bank account is incorrect, you can reset it to the new correct amount. If only the balance is changed, previously matched transactions will remain. If the date is changed, transactions will be unmatched to ensure they are not double counted. Your FreshBooks Balance will now update to reflect the new Opening Balance.


      How do I close my books? How do I do my month end closing?

      We’re currently still working on this, but in the meantime, you can use the below steps:

      1. Ensure all your transactions have been matched in Bank Reconciliation up to end of month period
      2. Run your Reports and export in the format of your preference
      3. Keep these Reports somewhere safe
      4. Repeat steps 1-3 at the end of each month.

      Use the saved reports to compare as you re-run the reports every month. If the balances are off, you have recorded transactions in an incorrect period.


      How do I disconnect my bank account to stop importing transactions? 

      Look for your supported country here and follow the steps outlined in your Bank Connection partner's article. 


      How do I clear a disconnected bank account?

      Note that clearing a disconnected bank account will:

      • Unmatch all previously matched transactions in Bank Rec for this account - this affects Petty Cash and either the Bank Account (Cash) or Credit Card Account on the Chart of Accounts (CoA), Petty Cash will list all unmatched transactions instead
      • Erase the Opening Balance - the amounts will be removed next to Opening Balance Adjustments and the Cash or Credit Card Account in the CoA
      • Expenses previously imported by the disconnected account will still remain inside FreshBooks
      • The Bank Account or Credit Card Account on the CoA remains with a $0 balance instead


      Steps to Clear Disconnected Account:

      1. Click on the Accounting section
      2. In the Bank Reconciliation widget, if you have your disconnected accounts hidden, click on the filter next to Bank Reconciliation
      3. Then check off the checkbox next to Show disconnected accounts
        Checkbox to show disconnected accounts in bank rec widget.
      4. Click on the x left to match link next to the disconnected account
      5. Then in the top right, click on the More Actions button
      6. Select Clear Disconnected Account
        Clear disconnected account option in dropdown.
      7. Click Continue and then click Clear Account to finish. This disconnected bank account should now display a Set your opening balance link instead of x left to match.

      Support Categories