How to Connect QuickBooks Online Accounts to Financial Institutions - dummies

How to Connect QuickBooks Online Accounts to Financial Institutions

By Elaine Marmel

QuickBooks Online offers three ways to connect QBO Bank and Credit Card accounts to corresponding accounts at financial institutions:

  • Connect directly if your bank supports a direct connection.
  • Use QuickBooks web Connect.
  • Import transactions stored in an Excel file.

You have a fourth option: You don’t have to connect at all. The following info may help you decide which approach is right for you.

Connecting … or not connecting

In QBO, you might be able to directly connect QBO Bank and Credit Card accounts to their counterparts at financial institutions. The word “might” is used because not all financial institutions support directly connecting to QBO. If you bank at an institution that doesn’t support a direct connection, you can use the QuickBooks web Connect method to export transactions from the financial institution’s website into QBO.

It’s important to understand that you don’t have to connect. You can work along quite happily in QBO without ever connecting an account at a financial institution to one in QBO. You simply enter transactions that affect the appropriate account and, monthly, you reconcile the accounts.

So, why connect? Most people connect to accounts at financial institutions so that they can electronically verify (by matching) the transactions recorded in QBO with the ones recorded at the financial institution. Connecting is, therefore, primarily a matter of convenience.

Connecting Bank or Credit Card accounts

When you add a new Bank or Credit Card account, you can opt to connect it to a financial institution — or you can choose not to connect to a financial institution. The method you choose to add a new account depends on whether you want to connect it to a financial institution.

You typically use an Expense transaction to record credit card purchases and sales receipts to record refunds to a credit card.

Adding but not connecting

Follow these steps to set up a Credit Card account that you don’t intend to connect to a financial institution:

  1. Click the Gear button beside your company’s name and, from the left side of the menu that appears, choose Chart of Accounts.

    QBO displays the Chart of Accounts page.

  2. Click the New button on the Chart of Accounts page to open the Account dialog box.
  3. Open the Category Type list and choose Credit Card.
  4. If you’re using account numbers, supply a number for the new account.
  5. Optionally, you can enter your account’s balance as it appears on the last statement.

    If you enter a balance, QuickBooks updates both the account balance and the Opening Balance Equity account, and your accountant probably won’t be happy with you. You can choose not to enter a balance.

  6. Click Save and Close.

    QBO redisplays the Chart of Accounts page and your new account appears in the list.

The dialog box you use to create an account.

You’ll need to enter expense transactions that have occurred since you received the last statement for this credit card account.

Adding and directly connecting

If, on the other hand, you want to create an account that is connected to a financial institution, you can do so if your financial institution offers the option to connect directly to QBO accounts. Gather up the user ID and password you use to log in to the financial institution online and follow these steps:

  1. In the Navigation bar, choose Transactions →   Banking.

    QBO displays the Bank and Credit Cards page.

  2. In the upper right corner, click Add Account.

    QBO starts a wizard that helps you connect to a financial institution.

  3. On the first wizard page, you either provide your financial institution’s website address, or you click your financial institution’s name if it appears on the page.

    To expand the search for banks, click the Search Global Banks option at the right edge of the website address box.

    The screen that appears next depends on whether you typed a web address or clicked one of the popular banks onscreen.

  4. Supply your user ID and password and click the Log In button.

    Follow any additional onscreen prompts you see to finish setting up the account.