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)
        2. Or jump down to the Finding Your Reconciliation Start Date and Opening Balance section if you need detailed steps
      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.

       

      Find Your Reconciliation Start Date & Opening Balance

      While you're setting up Bank Reconciliation, if you're having trouble finding your Reconciliation and Start Date, use the bleow steps depending on whether you're looking at a Bank Account or Credit Card statement. Note that you can edit your Opening Balance again anytime: 
       

      The Reconciliation Start Date can be entered only as far back as the date of the first imported bank transaction. Bank Connections can pull up to a maximum of 90 days of activity (check for more details with your Bank Connection partner here).

       

      For Bank Accounts

      Most bank account statements include a running Balance or Amount column that shows the total of the Bank Account after a particular transaction. Use this Balance/Amount column to find your Reconciliation Start Date and Opening Balance for Bank Rec with these steps:

      1. View or download the Bank Account Statement for the period that you want to reconcile in
      2. Using the statement, determine whether you want to start reconciling from the first day on your statement or in the middle of your statement period:

        1. For the first day of your statement: 
          1. On the statement, look for the Opening Balance or Balance Forward line at the top of your list of transactions
            A sample bank account statement with the Balance Forward line selected.
          2. Put the Date of your Opening Balance/Balance Forward line into FreshBooks’ Bank Rec as your Reconciliation Start Date
            A sample bank account statement with July 1, 2020 selected next to the Balance Forward line.
          3. Then put the Balance or Amount of your Opening Balance/Balance Forward into FreshBooks’ Bank Rec as your Opening Balance
            A sample bank account statement with the amount next to Balance Forward selected.
        2. For a date in the middle of your statement:
          1. On the statement, find a Date next to any transaction you want to start reconciling from and put this into FreshBooks’ Bank Rec as your Reconciliation Start Date
            A sample bank account statement with July 4, 2020 selected in a list of transactions.
          2. Then on the statement, look for the Balance or Amount one day before the Date you chose (e.g., if you chose July 4, look for the Balance next to July 3 instead (or the next row above it if the next available transaction is older than July 3)
            A sample bank account statement with the amount selected from a transaction dated July 3, 2020 before.
          3. Enter this Balance or Amount from the day before into FreshBooks’ Bank Rec as your Opening Balance. This ensures that only transactions from your Reconciliation Start Date are imported in for you to reconcile, which is why they should not be included in the Opening Balance amount.

      Note: If the Balance is a positive number (e.g., xx.xx), or it is a negative number (e.g., -xx.xx or (xx.xx)), it should be entered the same way in your Opening Balance (meaning the Opening Balance should be positive for positive Balances and the Opening Balance should be negative for negative Balances).

      The Opening Balance you’ve entered will create a Journal Entry that affects the Bank Account (Cash) and Opening Balance Adjustments (Equity) Account. See Chart of Accounts for more details.

      For Credit Card Accounts

      Most credit card statements include an Amount column that shows after a particular transaction. Use this Balance/Amount column to find your Reconciliation Start Date and Opening Balance for Bank Rec with these steps:

      1. View or download the Credit Card Statement for the period that you want to reconcile in
      2. Using the statement, determine whether you want to start reconciling from the first day on your statement or in the middle of your statement period (starting from the first day of your statement is highly recommended):

        1. For the first day of your statement: 
          1. On the statement, find the Period Covered by Statement, Statement Period, or Opening Date
            A sample credit card account statement with statement period indicated.
          2. Put the opening Date into FreshBooks Bank Rec as your Reconciliation Start Date (e.g., if the Statement Period is July 1 to July 31, put in July 1)
            A sample credit card account statement with the date in a statement period indicated.
          3. Then put the Previous Balance into FreshBooks’ Bank Rec as your Opening Balance. This ensures that only transactions are imported into Bank Rec from the date you specified moving forward
            A sample credit card account statement with the amount next to previous balance selected.
        2. For a date in the middle of your statement (please follow the steps below carefully): 
          1. Choose any date within the statement period and put this into FreshBooks’ Bank Rec as your Reconciliation Start Date (e.g., July 28)
          2. On the statement, find the Previous Balance and use this as your starting amount to calculate from (e.g., 1234.56)
            A sample credit card account statement the amount next to previous balance selected.
          3. Next, add up any purchases, interest charges and fees that were posted before your Reconciliation Start Date to the Previous Balance amount
            A sample credit card account statement with purchase, interest charge and fee transactions selected.
          4. Then subtract any payments and credits that were posted before your Reconciliation Start Date to Previous Balance amount
            A sample credit card account statement with payment and credit transactions selected.
          5. Double-check your calculated amount, and ensure you have not added or subtracted amounts that are posted on the Reconciliation Start Date as they will be included afterwards when you start your Bank Rec
          6. Put the new amount you’ve calculated into FreshBooks’ Bank Rec as your Opening Balance. If it’s an outstanding amount, enter this as a positive number, or if it’s an overpaid amount, enter this as a negative number.

      The Opening Balance you’ve entered will create a Journal Entry that affects the Credit Card (Liability) and Opening Balance Adjustments (Equity) Account. See Chart of Accounts for more details.

       

      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