Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

Import the QuickBooks Online banking web connect file into QuickBooks for Mac

Detailed Instructions

To import transactions for the first time:

  1. Select the Banking menu and then select Financial Institutions.
  2. Select your financial institution from the list and click Log In. If you don't see your financial institution in the list, contact your financial institution and ask them to support QuickBooks for Mac. Your browser window opens and displays your financial institution's website.
  3. Log in to your financial institution's website.
  4. Select the QuickBooks Web Connect option to download your account statement. Your financial institution may call the option "Download account activity," "Download account history," or something similar.
    Follow the onscreen instructions to download the file, which will have a .qbo file extension. Contact your financial institution for more information.
  5. Select the File menu and then select Import> From Web Connect.
  6. Select the .qbo file you want to import, and then click Open.
  7. For each account shown in the Web Connect file, select the QuickBooks account you want to associate with it, and then click Continue.
    The account pop-up menu shows available QuickBooks banking accounts if the account you are importing transactions from is a checking, savings, or money market account, available QuickBooks credit card accounts if the account you are importing transactions from is a credit card account, or available QuickBooks Other Current Liability accounts if the account you are importing transactions from is a line of credit account.
    The account pop-up menu will not show a QuickBooks account that is already associated with a Web Connect file. If nothing appears in the account pop-up menu, create a bank, credit card, or Other Current Liability account first.
  8. When QuickBooks finishes importing transactions, click OK. QuickBooks displays the transactions in the Downloaded Transactions window.
  9. Click a transaction to open it in the register.
  10. Click Record from within the register view.
  11. (Optional) Click Align Windows to display the Downloaded Transactions window and its corresponding account register.
  12. Proceed to updating your register.

To import transactions after the first time:

  1. Select the Banking menu and then select Downloaded Transactions.
  2. Select an account from the pop-up menu.
  3. Click Download to log in to your financial institution's website and download a Web Connect file.
  4. Click Import File to import the Web Connect file into QuickBooks.

If you want to link a different QuickBooks account to imported transactions, you must disassociate the currently associated account first.

Note: You must accept or delete any transactions still displayed in the Downloaded Transactions window before disassociating an account.

To disassociate an account:

  1. Select the Lists menu and then select Chart of Accounts.
  2. Select the account you wish to unlink from imported online transactions, and then select Edit from the Action pop-up menu.
  3. Click Online Settings.
  4. Click the Download Transactions drop-down arrow.
  5. Select Not enabled, and then click Save.
  6. In the Edit Account window, click OK.

You can then associate a different QuickBooks account with the imported transactions; this is useful if your financial institution changes names or ownership.

Important: Do not try to import the bank transactions by double-clicking on .qbo file. Doing so may cause you to receive the message "Quickbooks cannot open files in the web connect file format."

 

If these steps do not resolve the issue, you can read discussions and post messages and questions relating to your issue on the Intuit QuickBooks Community site for free or you can contact a technical support agent for additional guidance. Fees may apply.

 

KB ID# HOW12320
11/26/2014 4:06:50 PM
PPRDQSSWS404 9102 Pro 2013 84d7ff