How to Import Bank Transactions into QuickBooks?

Written by scottravens

In case you are searching for the interaction steps to import Bank transactions into QuickBooks Desktop, you are at the helpful spot. Importing Bank transactions directly to QuickBooks Desktop will save you from a lot of manual undertakings and slip-ups affixed therewith. You can without a doubt import bank transactions into the QuickBooks work area from dominant. 


You can import bank transactions through the Bank feed feature in QuickBooks. You should go for importing transactions since it will permit you to deal with bank and Mastercard transactions capably and will permit you to focus on other business-related necessities. 


Setting up of Bank takes care of Account 


  • Step 1. Above all else, you need to tap on Banking and afterward go to Bank takes care of. 
  • Step 2. In this progression, you need to tap on ‘Set up Bank takes care of for a record and afterward, you ought to enter your bank’s name. 
  • Step 3. From that point forward, you need to go to the ‘Connection your Accounts’ screen and pick the bank account that you wish to add to QuickBooks. 
  • Step 4. In the last advance, you ought to adhere to the on-screen directions and it will prompt the finishing of the cycle. 


Import the Bank Transactions with the assistance of.QBO file 


  • Step 1. Most importantly, you need to sign in to your bank account and download the transactions as a . QBO file. 
  • Step 2. By and by you should go to the File menu in your QBDT. 
  • Step 3. In this progression, you should tap on Utilities > Import and subsequently click again on Web Connect Files. After this, click open the.QBO file that you saved previously. 
  • Step 4. Pick your Bank record and snap-on proceed. When you see the talk box that uncovers to you that data is successfully added as a bonus to QuickBooks, you should tap on OK. 
  • Step 5. After the fourth step, you can go to the Bank Feeds concentration to see the imported transactions 


Import Bank Transactions with Web Connect 


Yet Direct Connect is simpler to complete and utilize, a couple of customers would prefer not to interface their bank account with QuickBooks Desktop. In case you’re one of those customers, you can rely upon Web Connect and import bank transactions into QuickBooks Desktop. One benefit here is that you can download anyway numerous transactions as made open by your bank; however, there’s a limitation of one year when using Direct Connect. 



To import bank transactions into QuickBooks with Web Connect, follow the means gave underneath: 


  • Snap-on Banking and select Bank Feed. 
  • Snap-on Bank Feeds Center, then, at that point, Banking Center. 
  • Select your Bank and snap-on Download Transactions. 
  • In the new program window, enter your verification subtleties and download the Web Connect File. 


Assuming you need to download the Web Connect file remotely, then, at that point, follow the means gave underneath: 


  • Dispatch a Web Browser and visit your Bank’s website. 
  • Enter the Authentication Details. 
  • Download the transactions in.QBO (QuickBooks Web Connect) file design. 
  • Dispatch QuickBooks and snap-on Banking. 
  • Select Bank Feeds and taps on Import Web Connect Files. 
  • Select the QBO file downloaded from the Bank’s website and snap-on Open. 
  • Select one of: 
    • Utilize a current QuickBooks Account: to import transactions when the bank account is set up in QuickBooks. 
    • Make another QuickBooks account: import transactions when the bank account isn’t set up in QuickBooks. 
  • Snap-on Continue, then, at that point, Ok. 
  • Audit your transactions by visiting the Bank Feeds Center from the Banking menu. 


These are the least demanding strategies to import bank transactions in QuickBooks Desktop. As indicated by your inclination, you can choose either a direct connection or a web connection.

About the author


Leave a Comment