Adding a bank account to QuickBooks Desktop requires you to set it up in the Chart of Accounts first, then configure the connection method based on whether your bank supports direct read or requires manual entry
QuickBooks Desktop does not automatically detect your bank accounts the way cloud-based accounting software does. You create the account record yourself, then decide how transactions will reach it: either through direct read (if your bank participates in the Web Connect or OFX standard), or by manually entering transactions and reconciling later. The setup takes about ten minutes, but the real work happens during reconciliation, when you match what QuickBooks shows against what your bank statement shows.
The process splits into two parts. First, you add the bank account as a balance sheet account in your Chart of Accounts. Second, you configure how QuickBooks will receive transaction data from your bank. Which method you use depends entirely on your bank's technical setup, not on QuickBooks itself.
Key Takeaways
- You must create the bank account in your Chart of Accounts before QuickBooks can receive any transactions from it.
- Most banks support Web Connect or OFX read, which lets QuickBooks pull transactions automatically; some banks require you to read a file and import it manually.
- A small number of banks do not support either method, which means you will enter transactions by hand and reconcile against your statement.
- Once the account is set up and connected, you reconcile monthly by matching downloaded transactions to your bank statement.
Creating the bank account in your Chart of Accounts
Open QuickBooks Desktop and go to Lists > Chart of Accounts. Click the Account button at the bottom left and select New. A window will open asking you to choose an account type.
Select Bank from the list. QuickBooks will then ask for the account name (use something clear like "Main Operating Account" or "Business Checking"), the account number (optional but useful for your records), and the opening balance. The opening balance should match your actual bank balance on the date you are setting this up. If you are adding an account that has been open for months, enter the balance as of today, not the original opening balance from when the account was created.
Click Save & Close. The account now exists in QuickBooks, but it has no connection to your actual bank yet. That happens in the next step.
Checking whether your bank supports direct read
Before you try to set up a connection, find out what your bank actually offers. Go to Edit > Preferences > Internet Connection (in QuickBooks Desktop 2020 and earlier, this is under Edit > Preferences > Web Connect). QuickBooks will show you a list of banks that support direct connection.
Search for your bank by name. If it appears in the list, your bank supports either Web Connect or OFX read, which means QuickBooks can pull transactions automatically. If your bank does not appear, contact your bank's business support line and ask whether they offer OFX or Web Connect downloads for accounting software. Some banks support it but are not listed in QuickBooks' directory, or they may have added support after your version was released.
If your bank does not support either method, you will need to read transactions manually from your bank's website and import them, or enter them by hand. This is slower but still workable for reconciliation purposes.
Setting up Web Connect or OFX read
If your bank supports direct read, go to Banking > Online Banking Center (or Banking > Set Up Account for Online Services in some versions). Select the bank account you just created from the list on the left.
Click Set Up Account. QuickBooks will ask you to log in with your online banking credentials. Use the same username and password you use to access your bank's website. QuickBooks will verify the connection and show you which accounts at that bank it can access.
Select the checking or savings account you want to link, then click Next. QuickBooks will match it to the account you created in your Chart of Accounts. If the match is correct, click Done. The connection is now active, and QuickBooks will begin downloading transactions the next time you open the Online Banking Center.
Importing transactions manually if direct read is not available
If your bank does not support direct connection, you can still get transactions into QuickBooks by downloading a file from your bank and importing it. Log into your bank's website and look for an option to read transactions in OFX, QFX, or CSV format. Most banks offer this under a section called "read Transactions" or "Export Statements".
read the file to your computer. In QuickBooks, go to Banking > Utilities > Import Transactions. Select the file you just downloaded and click Open. QuickBooks will read the file and show you a preview of the transactions it found. Review them for accuracy, then click Import. The transactions will appear in your bank account register, ready to reconcile.
This method requires you to repeat the read and import process each time you want to bring in new transactions, usually monthly. It takes longer than direct read, but it still saves you from typing each transaction by hand.
Reconciling your bank account after setup
Whether you use direct read or manual import, reconciliation is where you confirm that QuickBooks matches reality. Go to Banking > Reconcile and select the bank account you set up. QuickBooks will ask for the statement date and ending balance from your bank statement.
Enter those figures, then click Continue. QuickBooks will show you a list of all transactions it has for that account. Check off each transaction that appears on your bank statement. When you are done, the difference between your QuickBooks balance and your statement balance should be zero. If it is not, you have either missed a transaction, entered an amount incorrectly, or your bank charged a fee that is not yet in QuickBooks.
Once the balances match, click Reconcile Now. QuickBooks locks the reconciliation and marks all checked transactions as cleared. You can now run reports and know that your bank account balance is accurate.
Troubleshooting common connection problems
If QuickBooks cannot connect to your bank, the most common cause is an incorrect password or a security setting on your bank's side. Banks sometimes require you to enable third-party access or whitelist QuickBooks' IP address before it can log in. Call your bank's business support line and ask whether they have any setup steps for accounting software connections.
If the connection works but transactions are not downloading, check the Online Banking Center to see whether QuickBooks is actually retrieving data. Go to Banking > Online Banking Center and look at the status next to your account. If it says "Last Update: [date]", the connection is working. If it says "Not Connected" or shows an error, try disconnecting and reconnecting the account.
If you see duplicate transactions after importing or downloading, it usually means you imported the same file twice or QuickBooks downloaded transactions that you had already entered manually. Delete the duplicates before reconciling, or QuickBooks will show a balance mismatch.
Frequently Asked Questions
Can I add multiple bank accounts to QuickBooks Desktop?
Yes. Repeat the process for each account: create it in your Chart of Accounts, then set up the connection method. You can have as many bank accounts as you need, and you reconcile each one separately against its own statement.
What happens if I enter a transaction manually and then QuickBooks downloads the same transaction?
QuickBooks will show both, creating a duplicate. During reconciliation, you will see two identical transactions and need to delete one. To avoid this, wait for the read to arrive before entering transactions manually, or mark manually entered transactions so you can identify them easily.
Do I need to reconcile every month?
You should reconcile at least monthly, when your bank statement arrives. Reconciliation confirms that your QuickBooks balance matches your actual bank balance and catches errors early. If you wait several months, finding and fixing mistakes becomes much harder.
Can I change the bank account I linked after setup?
Yes. Go to Banking > Online Banking Center, select the account, and click Change Account. You can then select a different bank account to link. Your transaction history in QuickBooks stays the same; you are just changing which bank account it pulls from going forward.
What if my bank is not in QuickBooks' list of supported banks?
Contact your bank and ask whether they support OFX or Web Connect downloads. If they do, you can usually set up the connection manually by entering your bank's server address in QuickBooks' settings. Your bank's technical support team can provide this information. If they do not support either method, read and import transactions manually each month.