The two ways to link your bank account in QuickBooks Desktop

QuickBooks Desktop connects to your bank through either direct connection (also called Web Connect) or by manual CSV import. Direct connection is faster and pulls transactions automatically, but it requires your bank to support the connection method QuickBooks uses. If your bank does not support direct connection, you can download your transactions as a CSV file and import them manually.

The direct connection method works through a secure link that does not store your login credentials in QuickBooks. Instead, QuickBooks opens your bank's website in a separate window, you log in there, and you authorize the connection once. After that, QuickBooks can download your transactions without needing your password again.

Manual import takes longer but works with any bank. You download a file from your bank's website and tell QuickBooks to read it. This method requires you to repeat the download and import each time, but it gives you full control over which transactions you bring in.

Key Takeaways

  • Direct connection works only if your bank appears in QuickBooks' supported list, which you can check before you start the setup process.
  • Web Connect is the most common direct method and opens your bank's login page in a separate window so QuickBooks never sees your password.
  • Manual CSV import works with any bank but requires you to download and import transactions yourself each time.
  • Once connected, QuickBooks downloads transactions into a holding area called the Bank Feed, where you review and match them to your records before they post to your account.
  • You can set up multiple bank accounts in the same QuickBooks file, and each one can use a different connection method.

Setting up direct connection through Web Connect

Start by opening QuickBooks Desktop and going to the Banking menu. Select "Set Up Bank Feed for an Existing Account" if you already created the bank account in QuickBooks, or "Add Bank Account" if you need to create it first. QuickBooks will ask you to enter your bank's name.

Type your bank name into the search box. QuickBooks will show you a list of banks it can connect to directly. If your bank appears, click on it. If it does not appear, stop here and use the manual import method instead. If your bank does appear, QuickBooks will open a new window and take you to your bank's login page.

Log in to your bank account using your normal username and password. You are logging into your bank's website directly, not into QuickBooks. After you log in, your bank will show you a screen asking you to authorize QuickBooks to access your account. Read what permissions QuickBooks is asking for — typically read-only access to download transactions — and click to approve.

Once you approve, your bank sends a code back to QuickBooks. The connection is now set up. QuickBooks will ask you which account to connect (if you have multiple accounts at that bank) and whether you want to download transactions going back 30, 60, or 90 days. Choose how far back you want to go, then click Finish. QuickBooks will download your first batch of transactions into your Bank Feed.

Importing transactions manually with CSV files

Log into your bank's website using your normal login. Look for a section called "Download Transactions," "Export," or "Account Statements." The exact name varies by bank. You are looking for an option to download your account activity as a file, not to view it on screen.

Select the account you want to download from and the date range. Most banks let you choose between CSV, OFX, and QFX formats. Choose CSV if it is available — it is the most reliable format for manual import. Download the file to your computer and remember where you saved it.

Open QuickBooks Desktop and go to Banking > Utilities > Import Transactions from File. QuickBooks will open a file browser. Navigate to the CSV file you just downloaded and click Open. QuickBooks will read the file and show you a preview of the transactions it found.

Review the preview to make sure QuickBooks recognized your transactions correctly. If the dates, amounts, and descriptions look right, click Import. QuickBooks will add these transactions to your Bank Feed. If something looks wrong — for example, if all amounts are showing as negative when they should be positive — click Cancel and check your bank's export settings before trying again.

Understanding the Bank Feed and matching transactions

After QuickBooks downloads or imports transactions, they land in your Bank Feed, which is a holding area separate from your actual account register. You can see the Bank Feed by going to Banking > Bank Feeds > Bank Feed Center. Each connected account has its own section in the Bank Feed.

Transactions in the Bank Feed show three possible statuses: unmatched, matched, or added. An unmatched transaction is one QuickBooks downloaded from your bank but has not yet connected to anything in your records. A matched transaction is one QuickBooks found a corresponding check or deposit for in your account register. An added transaction is one you created manually in QuickBooks and that now appears on your bank statement.

To match a transaction, click on it in the Bank Feed. QuickBooks will show you a list of transactions in your account register that might match — usually sorted by date and amount. Click on the one that matches, and QuickBooks will link them together. Once matched, the transaction moves out of the unmatched list.

If QuickBooks suggests a match but you are not sure, hover over the suggested transaction to see more details. If you do not see a match in the list, the transaction may be something you have not recorded yet — for example, a bank fee or a deposit that has not been entered. You can create a new transaction right from the Bank Feed by clicking "Add Transaction."

Troubleshooting connection problems

If your bank does not appear in QuickBooks' list when you search for it, your bank does not currently support direct connection. This is common with smaller regional banks and credit unions. Switch to manual CSV import instead. Go to your bank's website, download your transactions as a CSV file, and import them using the method described above.

If you set up direct connection but QuickBooks stops downloading transactions, the connection may have expired. Go to Banking > Bank Feeds > Bank Feed Center, find the account, and look for a message saying the connection needs to be refreshed. Click the refresh button or the message itself, and QuickBooks will open your bank's login page again. Log in and re-authorize the connection.

If you see an error message when you try to import a CSV file, the file format may not match what QuickBooks expects. Download the file again from your bank, but this time look for an option to export as OFX or QFX format instead of CSV. These formats are more structured and less likely to cause import errors. If your bank does not offer OFX or QFX, contact your bank's support line and ask what format they recommend for QuickBooks Desktop.

If transactions are downloading but the amounts or dates look wrong, check your bank's export settings. Some banks let you choose whether to include pending transactions, fees, or interest separately. Make sure you are exporting the right account and the right date range. If the problem persists, take a screenshot of what you see in QuickBooks and what you see on your bank statement, then contact QuickBooks support with both images.

Managing multiple bank accounts

You can connect as many bank accounts as you need in a single QuickBooks Desktop file. Each account can use a different connection method — for example, your main checking account might use direct connection while your savings account uses manual CSV import.

To add another account, go to Banking > Set Up Bank Feed for an Existing Account. If the account does not yet exist in QuickBooks, create it first by going to Lists > Chart of Accounts, clicking the Account button at the bottom, and selecting New. Make it a Bank account type, give it the name of your actual bank account, and click OK. Then return to Banking > Set Up Bank Feed for an Existing Account and search for your bank.

Once you have multiple accounts connected, the Bank Feed Center shows all of them in one place. You can filter by account to see only the transactions from the one you want to work on. This makes it easier to match transactions across multiple accounts without getting confused.

Frequently Asked Questions

Does QuickBooks store my bank password?

No. When you set up direct connection through Web Connect, QuickBooks opens your bank's website in a separate window and you log in directly to your bank. QuickBooks never sees or stores your password. After you authorize the connection once, QuickBooks uses a secure token to download transactions without needing your password again.

How often does QuickBooks download new transactions?

QuickBooks Desktop does not download automatically on a schedule. You must manually download transactions by opening the Bank Feed Center and clicking the Download button for each account. This is different from QuickBooks Online, which downloads automatically throughout the day. Set a reminder to download at least once a week so your records stay current.

What if my bank is not on the QuickBooks list?

Use manual CSV import instead. Log into your bank's website, find the Download or Export option, select CSV format, and download your transactions. Then go to Banking > Utilities > Import Transactions from File in QuickBooks and select the CSV file you downloaded. You will need to repeat this process each time you want to bring in new transactions.

Can I undo a matched transaction?

Yes. Open the Bank Feed Center, find the matched transaction, and click on it. A button labeled "Unmatch" will appear. Click it to separate the bank transaction from the QuickBooks transaction. The bank transaction will return to unmatched status and you can match it to a different transaction if needed.

What should I do if a transaction appears twice in QuickBooks?

This usually happens when you manually entered a transaction and then the bank also downloaded it. Go to the Bank Feed Center, find the downloaded version, and click on it. QuickBooks should suggest the manually entered transaction as a match. Click on the suggested match to link them together. The duplicate will disappear from your register.