Sign in

Import Bank Transactions into QuickBooks Online

James Antonio
Import Bank Transactions into QuickBooks Online

QuickBooks is a perfect resolution for managing and dealing with all of an enterprise's accounting and bookkeeping wants. In this publication, we’re going to learn to import bank transactions into QuickBooks Online. Online Banking in QuickBooks online is an important and time-saving characteristic that not solely downloads financial institution transactions however it additionally categorizes them. To study is temporary then you have to consult with the given steps.

Steps for importing financial institution transactions into QuickBooks Online

You may simply import your financial institution transactions into QuickBooks online by referring to the given beneath steps one-by-one:

Finding Your Financial institution

  1. First, you have to select the transactions choice> then go to the left menu bar QuickBooks and faucet on the Banking choice.
  2. Now so as to add your checking account, faucet on the inexperienced join account button.
  3. After that, you have to search your financial institution by getting into the financial institution’s title or the Financial institution’s website URL.
  4. If in case you don’t discover your financial institution within the record, you have to import your financial institution transactions by utilizing a CSV file or with a QuickBooks online file.
  5. As soon as you choose your financial institution then navigate to your financial institution’s sign-in web page by urgent the inexperienced Proceed button.

Log In To The Financial institution Account

  1. When you sign up to your financial institution, then a pop-up “are wish to share your banking data with Intuit and supply an abstract of the knowledge to be shared” is displayed on the display.
  2. Click on agree for the affirmation and proceed. It should once more take you to QuickBooks.

Linking your Financial institution Accounts to a Chart of Accounts

  1. When you returned again to QuickBooks then a listing of accounts that have with the chosen financial institution will get displayed.
  2. Now you have to select all of the financial institution accounts that you simply wish to hyperlink to QuickBooks online.
  3. After that click on an account> now a drop-down menu will record all the chosen financial institution accounts in addition to your chart of accounts. Word: If in case your checking account just isn’t in the Chart of Accounts then you have to add by clicking on the Add new choice.
  4. Be sure that the account sort is Financial institution and Element sort is Checking.
  5. In the case in case you have a couple of checking accounts with an identical financial institution then you have to add the final 4 digits of the account quantity.
  6. As soon as getting into all of the needful knowledge, click on Save and shut choice.

Choice of the suitable Date Vary

When you efficiently assign your checking account to an account out of your Chart of Accounts. Now you have to resolve the transaction vary.

Reviewing Downloaded Financial institution Transactions within the Banking Heart

When you connect with your checking account then QuickBooks will take you to the Banking middle web page. Then you have to undergo the given steps.

  1. Evaluate transactions: Navigate to the orange quantity (which is positioned within the higher left nook of the Banking Heart). This quantity is principally the variety of transactions that have been imported out of your checking account and are able to overview.
  2. Reviewing Tab: To overview the imported checking account transactions, you have to faucet on the Evaluate lists choice.
  3. Including account: So as to add a brand new account, you have to click on the Add account choice (positioned within the higher right-hand nook of the display).

Steps for manually importing financial institution transactions into QuickBooks online with a CSV File

  • Initially, go to the “Banking middle”.
  • Then you have to choose the File add choice> click on on the file that you simply wish to add.
  • Now select your QuickBooks account> after that you have to arrange your QuickBooks account.
  • After that, you have to deal with the QuickBooks online Obtain Fields to Your Financial institution Account Fields
  • Then choose the “banking transactions” that you simply wish to import into QuickBooks Online.
  • Thereafter, you have to click on the verify choice to proceed with the import.
  • Now your transactions are downloaded> now you’ll be able to overview all of the Imported transactions


In this article, we’ve got discovered the best way to import transactions into QuickBooks. Nonetheless, if in case you face any challenges when importing your financial institution transactions into QuickBooks online go to Dancing Numbers. 

James Antonio
Zupyak is the world’s largest content marketing community, with over 400 000 members and 3 million articles. Explore and get your content discovered.
Read more