The fastest way to get your bank data into QuickBooks Online

QuickBooks Online pulls transactions directly from your bank through a secure connection—you don't download files and upload them manually. The process takes a few minutes to set up, and after that, new transactions appear in your account automatically, usually within one business day of posting at your bank.

The connection works through bank feeds, which is QuickBooks' term for the live link between your bank and your accounting software. Most U.S. banks and credit card companies support this. If your bank doesn't, or if you prefer to control the timing, you can also import transactions from a CSV or OFX file that you download from your bank's website.

Key Takeaways

  • Bank feeds connect your QuickBooks Online account directly to your bank, pulling transactions automatically without you uploading anything.
  • The setup takes about five minutes: you authorize QuickBooks to access your bank account, then match the connection to the correct account in QuickBooks.
  • Transactions usually appear in QuickBooks within one business day, but you still have to review and categorize them before they count as official entries.
  • If your bank doesn't support direct feeds, download a CSV or OFX file from your bank and import it manually through QuickBooks.
  • Duplicate transactions are common when you first connect; QuickBooks flags them, but you have to review and delete the duplicates yourself.

Setting up a direct bank connection in QuickBooks Online

Start in QuickBooks Online by clicking Accounting in the left menu, then Chart of Accounts. Find the bank account you want to connect, click the three dots next to it, and select Edit. Scroll down to the section labeled Bank Feeds and click Connect.

QuickBooks will ask you to search for your bank by name. Type your bank's name (for example, "Chase" or "Bank of America") and select it from the list. Click Connect Account, and your bank's login page will open in a new window. Sign in with your online banking username and password—QuickBooks does not store these credentials, and your bank confirms the connection directly.

After you log in, your bank will ask you to authorize QuickBooks to access your account. This is a one-time approval. Once you confirm, QuickBooks will show you a list of accounts at that bank. Select the account that matches the one you set up in QuickBooks, then click Connect. The connection is now active, and transactions will start flowing in.

How long it takes for transactions to appear

Transactions typically show up in QuickBooks within one business day of posting at your bank. Some banks are faster—transactions may appear the same day—but don't count on it. Weekends and bank holidays can add a day or two to the delay.

When transactions arrive, they land in a section called For Review in the Banking tab. They stay there until you categorize them and confirm them as official entries. Until you do, they don't affect your profit and loss statement or balance sheet. This review step is where you catch errors and make sure the transaction is coded to the right account.

Reviewing and categorizing imported transactions

Click Banking in the left menu, then select the account you connected. You'll see a list of transactions waiting for review. For each one, click on it to open the details.

QuickBooks will suggest a category based on the merchant name and your past transactions. If the suggestion is correct, click Add to accept it. If it's wrong, click the category dropdown and select the right one. For example, if a transaction from Staples was categorized as "Office Supplies" but you meant it as "Equipment," change it before you confirm.

Once you've categorized a transaction, click Add to move it into your official records. The transaction now appears on your balance sheet and in your reports. If you see a duplicate—which happens when you've already entered a transaction manually or when a pending transaction posts and appears again—click the three dots next to it and select Delete.

Importing transactions manually if your bank doesn't support feeds

If your bank doesn't appear in QuickBooks' list, or if you prefer to control when transactions are imported, download a file from your bank and import it manually. Log into your bank's website and look for an option called Download Transactions, Export, or Download History. Most banks let you choose a date range and a file format—select either CSV or OFX (both work with QuickBooks).

In QuickBooks Online, go to Banking and click the account you want to import into. Click Import Transactions (or a similar button depending on your version). Select the file you downloaded from your bank, then click Next. QuickBooks will show you a preview of the transactions and ask you to confirm the mapping—that is, which column in your file represents the date, which is the amount, and which is the description. Once you confirm, the transactions import and appear in the For Review section, just as they would with a direct feed.

Handling duplicates and reconciliation

When you first connect a bank account, QuickBooks may pull in transactions from the past 90 days. If you've already entered some of those transactions manually, you'll see duplicates. QuickBooks has a built-in duplicate detection tool that flags likely matches, but it's not perfect—you still have to review them.

Open a transaction in the For Review section. If you see a banner saying "This transaction may be a duplicate," click on it to see the match. If it's truly a duplicate, click Delete on one of them. If it's not a duplicate, dismiss the warning and categorize the transaction normally.

After you've reviewed and categorized all imported transactions, reconcile your account. Click Reconcile at the top of the Banking tab, select your bank account, and enter the ending balance from your bank statement. QuickBooks will match the transactions you've confirmed against the statement balance. If everything matches, you're done. If there's a difference, QuickBooks will show you which transactions don't match, and you can investigate.

Troubleshooting a connection that stops working

If transactions stop appearing, the most common cause is that your bank requires you to re-authorize the connection. Log into your bank's website and look for a section called Connected Apps, Third-Party Access, or Authorized Applications. If QuickBooks is listed there, check whether it says "Needs Attention" or "Action Required." If it does, click on it and re-authorize.

If re-authorizing doesn't work, or if you can't find the authorization section, disconnect the account in QuickBooks and reconnect it. Go to Chart of Accounts, find the account, click the three dots, select Edit, scroll to Bank Feeds, and click Disconnect. Then follow the setup steps again from the beginning.

If your bank's website has changed its login process—for example, if it now requires two-factor authentication—QuickBooks may not be able to log in automatically. Contact your bank's support line and ask whether they support QuickBooks Online. If they do, they can often reset the connection on their end. If they don't, you'll need to import transactions manually using CSV or OFX files.

Frequently Asked Questions

Can I connect multiple bank accounts at once?

Yes. Repeat the connection process for each account. You can connect accounts from the same bank or different banks. Each one will pull transactions into its own account in QuickBooks, and you'll review them separately in the Banking tab.

What if a transaction appears in QuickBooks but hasn't cleared my bank yet?

Bank feeds sometimes pull pending transactions before they officially post. When you reconcile, QuickBooks will match pending transactions against your bank statement. If the transaction hasn't posted yet, it won't appear on the statement, and reconciliation will show a difference. Wait for the transaction to post, then reconcile again.

Do I need to keep my QuickBooks Online subscription active for the bank connection to work?

Yes. The bank feed connection only works while your QuickBooks Online account is active and paid. If your subscription lapses, the connection stops, and transactions won't import. When you reactivate, you may need to reconnect the account.

Can I import credit card transactions the same way?

Yes. Most credit card companies support bank feeds in QuickBooks. Follow the same process: go to your credit card account in QuickBooks, click Connect under Bank Feeds, search for your card issuer, and authorize the connection. Transactions will import the same way as bank transactions.

What happens if I delete a transaction by mistake?

If you delete a transaction before it's been categorized and confirmed, it will re-import the next time the bank feed updates. If you've already confirmed it and then delete it, it's gone from QuickBooks, but your bank still has a record. You can re-enter it manually or wait to see if it re-imports on the next feed update (it usually won't).