cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Intuit
17 helpful votes

Download Bank Feed transactions in QuickBooks Desktop

 

This article is part of a series that covers Bank Feeds in QuickBooks for Windows.

After you set up your accounts for Bank Feeds, you can start downloading transactions from your banks.

Step 1: Before you start

If you haven't already, follow the steps to back up your QuickBooks company file.

Here are a few things to keep in mind:

  • You can't download transactions into the same QuickBooks Desktop company file more than once. However, your bank may be able to reopen the transactions on their side so QuickBooks can download them again. Reach out to your bank to get help with this.
  • You can only import Web Connect files into QuickBooks Desktop. These files have a .qbo extension at the end of the file name.
  • You can't import QFX or QIF Quicken files into QuickBooks Desktop. There are a few third-party applications that can handle QIF available on the Intuit Marketplace.

Step 2: Download transactions

Download using Direct Connect

The first time you connect, QuickBooks automatically downloads the maximum number of transactions available from your bank. This is as much as QuickBooks can download. Depending on the bank, this gives you up to a year of historical transactions.

Note: You can't download prior bank statements with Direct Connect.

  1. Go to the Banking menu.
  2. Hover over Bank Feeds and select Banking Center.
  3. From the Bank Accounts list, choose the account you want to connect. (Optional) In the Send items to your bank section, you can edit or delete items by clicking the drop-down.
  4. When you're ready to get your transactions, select Download Transactions.Note: If you already downloaded the transactions but haven't reviewed them yet, select Transaction List. Here's how to review them.
  5. Select Synchronize. If you only want to download transactions for a specific account, select Sync this account. Or if you want to download transactions for all your accounts at the same bank, select Sync all for this Bank.
  6. In the Access to window, enter your PIN or password to connect to your bank.
  7. Select OK.

After you download the transactions, you need to match or add any new ones.

Note: You can delete any remaining (previously matched/added) transactions by deleting the statement. To avoid duplicate entries, once you’ve deleted downloaded transactions, you can't download them again.

 

Download using Web Connect

Some banks let you set a date range for downloads. If your bank doesn't have this option, you automatically get the maximum number of transactions available the first time you download. This may be 30, 60, 90 days, or more depending on the bank.

There are two ways to import transactions via Web Connect:

If you're using QuickBooks Desktop

  1. Go to the Banking menu.
  2. Hover over Bank Feeds and select Banking Center.
  3. Find your bank and select Download Transactions. This opens a browser window to your bank's website.
  4. Sign in to your bank's website to download the Web Connect file.

If you're outside of QuickBooks Desktop

  1. Open a web browser and go to your bank’s website.
  2. Sign in to your bank account using your normal process.
  3. Download your transactions as a QuickBooks Web Connect (.qbo) file.
    Note: Every bank has a different method for downloading QuickBooks Web Connect files. If you're not sure how to do it, visit your bank's website and look for their steps. If you can't find any, reach out to your bank for help.
  4. Once you have the Web Connect file, follow the steps to import it into QuickBooks Desktop.

Was this helpful?

You must sign in to vote, reply, or post

Need to get in touch?

Contact us