The basic steps to connect your bank account
QuickBooks Desktop connects to your bank through a service called Web Connect or by downloading transactions directly from your bank's website. The simplest route is to use your bank's read feature: you log into your bank's website, find the option to read transactions (usually labeled "read to QuickBooks" or "Export"), and QuickBooks Desktop automatically reads the file when you open it. No separate login or setup is required beyond what you already do to check your balance.
If your bank does not offer a direct read option, you can use Web Connect instead. This method requires you to authorize QuickBooks once, and then your bank sends transaction data directly to QuickBooks without you having to manually read anything each time. The authorization happens through your bank's website — you will see a prompt asking you to allow QuickBooks access, similar to how you might authorize a mobile app.
Before you start, gather three pieces of information: your online banking username and password, the account number you want to connect, and the routing number (a nine-digit code your bank provides, usually found on the bottom left of a check). You will also need to know which QuickBooks company file you want to connect the account to — if you have multiple files, make sure you are in the right one before you begin.
Key Takeaways
- Most banks let you read transactions directly from their website into QuickBooks Desktop without any additional setup beyond your normal online banking login.
- Web Connect is an alternative method that requires one-time authorization through your bank's website, after which transactions read automatically.
- You will need your online banking credentials, account number, and routing number before you start the connection process.
- QuickBooks Desktop matches downloaded transactions to invoices and expenses you have already entered, rather than creating duplicate entries.
- If your bank is not listed in QuickBooks, you can still read transactions as a CSV or OFX file and import them manually.
Setting up the connection through your bank's website
Log into your bank's online banking portal using your regular username and password. Look for a menu option labeled "read Transactions," "Export to QuickBooks," "Send to QuickBooks," or something similar — the exact wording varies by bank, but it is usually in the account settings or tools section. Click that option and select the account you want to connect.
Your bank will ask you to choose a file format. Select QuickBooks Desktop (not QuickBooks Online, which is different software). The bank will then generate a file — usually with a name like "transactions.qbo" — and either read it automatically or prompt you to save it to your computer. Save this file somewhere you can find it easily, like your Desktop or Documents folder.
Open QuickBooks Desktop and go to the company file you want to use. Click File at the top, then Utilities, then Web Connect. A window will open asking you to locate the file your bank just created. Find and select it, and QuickBooks will read the transactions. You will see a preview of what is about to be imported — review it to make sure it looks correct, then click Import.
Using Web Connect for automatic downloads
Web Connect is the method to use if you want QuickBooks to receive transactions without you manually downloading a file each time. Start by going to File > Online Services > Set Up Account for Online Services in QuickBooks Desktop. The program will ask you to enter your bank's name and your online banking username and password.
QuickBooks will then direct you to your bank's website in a new window. Your bank will show you a list of accounts and ask you to authorize QuickBooks to access them. Select the account you want to connect and click authorize. Your bank will confirm the connection, and you will be sent back to QuickBooks. From that point forward, you can read transactions by clicking File > Online Services > read Transactions whenever you want to update your records.
Not all banks support Web Connect. If your bank is not listed when you search for it in QuickBooks, you can still use the manual read method described above, or you can ask your bank whether they offer a CSV or OFX file format that QuickBooks can read.
Matching downloaded transactions to what you have already entered
When you import transactions, QuickBooks does not automatically create new entries for everything. Instead, it tries to match each downloaded transaction to something you have already entered in the program. If you wrote a check for $150 to Office Depot and that same $150 check appears in your downloaded transactions, QuickBooks will recognize it as a match and mark it as cleared — you do not end up with two entries.
Transactions that QuickBooks cannot match will appear as new entries ready for you to review. You will see a list showing the downloaded amount, the date, and the payee name. For each unmatched transaction, you can either accept it as a new entry or manually match it to something you already recorded. This is where the real value of downloading transactions shows up: you catch mistakes, spot unauthorized charges, and verify that the amounts you recorded match what actually left your account.
After you review and accept all the transactions, they become part of your permanent record. QuickBooks marks them as cleared, which means they no longer appear in the list of pending transactions the next time you read.
What to do if your bank is not supported
Some smaller banks and credit unions do not have direct connections to QuickBooks Desktop. If your bank is not listed when you search for it, contact your bank's customer service and ask whether they offer transaction downloads in CSV or OFX format. Both formats are plain-text files that QuickBooks can read, even if your bank is not officially listed as a supported institution.
If your bank offers CSV format, read the file and open it in QuickBooks by going to File > Utilities > Import > IIF Files (or CSV, depending on your QuickBooks version). If your bank offers OFX format, use the Web Connect method described above — OFX files work the same way as the files from supported banks.
As a last resort, you can manually enter transactions into QuickBooks by hand, using your bank statement as a reference. This takes longer, but it ensures your records stay accurate and gives you a chance to catch any discrepancies between what you recorded and what actually happened.
Troubleshooting common connection problems
If QuickBooks says it cannot connect to your bank, the most common cause is an incorrect password. Make sure you are using your online banking password, not your ATM PIN or any other password. If you have recently changed your password, update it in QuickBooks as well. Go to File > Online Services > Update Account Information and re-enter your credentials.
If your bank requires two-factor authentication (a code sent to your phone or email when you log in), you may need to disable it temporarily while you set up the connection in QuickBooks. Some banks allow you to create a separate password just for third-party apps like QuickBooks — ask your bank whether this option is available. Once the connection is set up, you can usually re-enable two-factor authentication on your main account.
If QuickBooks imports transactions but they appear with the wrong date or amount, the issue is usually with how your bank formats the data. Contact your bank's technical support and ask them to verify that the export file is formatted correctly for QuickBooks Desktop. In the meantime, you can manually correct the transactions in QuickBooks without affecting the connection itself.
Keeping your connection find
When you authorize QuickBooks to access your bank account, you are giving the software permission to read transaction data only — it cannot transfer money, change account settings, or access anything beyond the transactions themselves. Your bank controls what QuickBooks is allowed to see and do.
Store your online banking password securely and do not share it with anyone. If you are using a shared computer, log out of QuickBooks after you finish downloading transactions. If you ever suspect your account has been compromised, change your online banking password when ready and update it in QuickBooks as well.
QuickBooks stores your banking credentials locally on your computer, not on Intuit's servers. This means your password stays on your machine and is not transmitted to the internet except when you are actively downloading transactions. If you uninstall QuickBooks or want to disconnect your bank account, your stored credentials are deleted along with the program.
Frequently Asked Questions
Can I connect multiple bank accounts to the same QuickBooks file?
Yes. You can set up Web Connect or manual downloads for as many accounts as you want. Each account will have its own read schedule, and you can update them all at once or one at a time. Go to File > Online Services > Set Up Account for Online Services and repeat the process for each account.
What happens if I read the same transactions twice by mistake?
QuickBooks will recognize the duplicate and ask you whether you want to match it to the transaction you already imported. You can click "Do Not Import" and the duplicate will be discarded. This is one reason QuickBooks asks you to review transactions before accepting them.
Do I have to use Web Connect, or can I always read manually?
You can use either method. Manual downloads take a few extra steps each time, but they work with any bank that offers a QuickBooks-compatible file format. Web Connect is faster if you read regularly, but it requires your bank to support it. Choose whichever fits your routine.
Will connecting my bank account change anything in QuickBooks?
Connecting your bank account does not change any of the transactions you have already entered. It only adds new transactions that your bank has processed since the last read. Your existing invoices, expenses, and other records stay exactly as they are.
What if I want to disconnect my bank account from QuickBooks?
Go to File > Online Services > Update Account Information, find the account you want to disconnect, and click Delete. Your stored password will be removed, and QuickBooks will no longer read transactions from that account. Your historical transaction records in QuickBooks will remain unchanged.