Download Bank Transactions in QuickBooks Desktop for Mac

,

Download Bank Transactions in QuickBooks Desktop for Mac

Bank transactions can be very useful when reconciling accounts in QuickBooks. Once you’ve connected your bank account with QuickBooks, you can directly import transactions and other information directly from your bank account. In this article, you’ll learn to download bank transactions in QuickBooks Desktop for Mac.

When connecting your bank account with QuickBooks, you have two particular options:

  • Web Connect
  • Direct Connect

In this article, we’ll show you the ways to import transactions for both types of connections.

Download Bank Transactions Via Web Connect

This is the preferred method of connecting to your bank account with QuickBooks. Most banks support the WebConnect format and enable their users to download transactions easily.

To download bank transactions in QuickBooks Desktop for Mac when your bank account is connected via web connect, follow the steps provided below:

  1. Select Banking from the main menu.
  2. Click on Website. In a new window, the bank’s website will appear.
  3. Enter the authentication details and hit enter to log in.
  4. In the transactions window, enter the date range for which you want the transaction. Download the transactions in the .qbo file format. The steps to download this file will depend on the bank.
  5. Go back to QuickBooks, and click on Banking.
  6. Select Download Transactions.
  7. Click on Import File.
  8. Select the .QBO file you downloaded in Step 4.

If you encounter issues during the process, then you should follow the steps provided below:

  1. Click on Chart of Accounts in QuickBooks.
  2. Click on the bank account. This process will unlink the account from online transactions.
  3. From the Action window, click on Edit.
  4. Go to the Online Settings tab.
  5. Select Not enabled on the download transactions window. Click on Save.
  6. The Edit Account window will appear. Select Ok.
  7. Create a Duplicate with a different name for the selected account.
  8. Go back to the original account and rename it. Enter the name used for the duplicate account.
  9. Now try to import the web connect file.

Download Bank Transactions Using Direct Connect

Users who’ve connected their bank accounts via direct connect don’t need to manually download and import the transactions. Instead, the transactions are automatically available and can be downloaded directly from QuickBooks.

To download bank transactions in QuickBooks Desktop for mac when the bank account is connected via direct connect, follow the steps provided below:

  1. Select Banking from the main menu.
  2. Click on Download Transactions.
  3. Click on the QuickBooks Account dropdown menu.
  4. Select the bank account from which you want to download the transactions.
  5. Click on Download.

You’ve successfully downloaded the bank transactions into QuickBooks. These transactions can be used for ascertaining the accuracy of accounting data, entering transactions, and reconciling accounts.

If you encounter errors while downloading the errors directly into QuickBooks, then your bank’s website may be down or the bank account may not be properly linked with QB.

To know more, you can get in touch with our experts via Live Chat.

FAQs

Yes. Most banks provide transactions in Web Connect format, which can be imported into QuickBooks. Once you’ve downloaded the transactions from your bank account, you can go to QuickBooks > Banking > Download Transactions.
Neither is better than the other. It’s more about convenience. If you want to download your bank transactions directly into QuickBooks, then you should go with Direct Connect. However, if you plan to download the transactions and then import them into QuickBooks, then you should rely on Web Connect.

Post Written by

Daniel Tough is a Content expert @ Bigxperts.com with over 7 years of experience who writes blogs on Accounting & Accounting Softwares. He’s an organizer for SEO Meetup & SEO Conference. Daniel regularly writes informative articles on Accounting & Accounting Software integration with various third-party apps.

Leave a Comment

Disclaimer: We have experienced CPAs providing the quality solutions of QuickBooks for many years. Content available on our website is solely our property, and for any feedback contact our team via LIVE CHAT or Contact form. We are not associated with any other company like Intuit and work with our own T&C.

Enquire Here Chat Now