Skip to main content
A
arkvalleyinfo
December 11, 2018
Question

How to import bank transactions using excel.

  • December 11, 2018
  • 12 replies
  • 0 views
I am trying to import bank transactions from a bank that does not support Web Connect.

- My bank only allows downloads for Excel, Comma Separated Values, Micrsoft Money, and Quicken. My quickbooks only allows import for IIF File, Quicken, and Web Connect, none of which I have.

I don't not have Quicken or IIF. I only have Excel and Numbers(almost identical program).

Is there any way to download or convert the Excel file so I can import in quickbooks.

I have been at this for MONTHS!! HELP!!!!!!!!!!!

Many thanks,
Shelby

    12 replies

    A
    arkvalleyinfoAuthor
    December 11, 2018
    Hi Shelby,
    Did you ever get this problem solved?  I am having the same issue.  The account I need to import has over a thousand transactions.  Any insight would be greatly appreciated.

    Thanks!
    Heather
      A
      arkvalleyinfoAuthor
      December 11, 2018
      Generally one does not import excel files into quickbooks.

      the reason being an excel file needs to be converted into a file Quickbooks
      and read..   And in my opinion is not worth the effort, to set up the file the way
      QB can import the file.   Of course this applies to accountant, someone who is
      IT trained,  i am sure it fairly simple.

      Therefore if the volume of transactions is large.   You may need help from an IT person to show you how to import an excel file.
      A
      arkvalleyinfoAuthor
      December 11, 2018
      Ok, thanks!

      My file is not very large. I don't understand why I am having this issue. I have downloaded IIF trial and that thing is a joke. I only need to import this list of transactions once, so I do not want to spend $100 on a program. Where are all my hackers at? Haha

      I have tried to save the file in every way possible. I get the error message below when trying to import:

      "QuickBooks was not able to complete your request.
      Please contact your financial institution.
      (OL-222)"
      J
      justin6
      December 11, 2018
      You're with US Bank, huh?  I hate them.  

      There is a way to import large amount of data, once you get used to it, its quick too.

      http://support.quickbooks.intuit.com/support/pages/inproducthelp/core/qb2k12/contentpackage/thirdparty/excel/data_in_use_templates.html?family=pro

        S
        shortib
        January 10, 2019

        Yes. Client has US bank and I need to get 1099s out, so I don't have time to hand enter a years worth of data.

         

        ANy bright ideas?

         

        The link you posted doesn't load.

        Kristine Mae
        Kristine Mae
        January 10, 2019

        Hello, Shortib.

         

        In QuickBooks, you can only use the Excel/CSV file when you import lists. 

         

        With regard to your concern, if your financial institution supports WebConnect (.QBO) file, then you can import it to QuickBooks.

         

        Here's how:

        1. Click the File menu, then go to Utilities.
        2. Click Import, then choose Web Connect Files.
        3. Choose the QBO file, then click Open.
        4. When prompted to choose bank account, choose Use an existing QuickBooks account if the account is already set up or Create a new QuickBooks account if it's not yet added.
        5. Click Continue.
        6. When you see a window telling you that the data has been successfully read, click OK.

        Go to the Bank Feeds Center to check the imported transactions. 

         

        Feel free to get back to us if you need more help. 

          AlcaeusF
          AlcaeusF
          January 25, 2019

          Hello there, kane_2.

           

          I appreciate you for reaching out to the Community. I'm here to provide additional clarification with using QuickBooks Desktop.

           

          The import and export process for QuickBooks Desktop for Windows and Mac is different. For users using the Windows version, they can only import list in the CSV format.

           

          For additional insights, I'm adding this article: Import/export CSV files.

           

          If you're now having issues with the import function in the Mac version, I recommend you give us a call. One of our Phone Support Specialists will need to check your program settings and set up to ensure it'll work at its best.

           

          You can reach them through these steps:

           

          1. Go to: https://help.quickbooks.intuit.com/en_US/contact#
          2. Select QuickBooks Mac Desktop.
          3. Select a topic.
          4. Scroll down and click Get Phone Number.

          Please be sure to let me know if there's anything else I can do to help you succeed.
           

          A
          Artslover
          May 6, 2022

          You attached an article how to import/export csv file but that article only lets you download an exe file which is a Windows file, but you replied to person who was using a Mac. Please update the article.

          M
          mox
          May 7, 2019

          I'm going to give this a try. I'll let you know

          https://quickbooks.intuit.com/community/Banking-and-bank-feeds/How-to-import-bank-transactions-using-Excel-CSV-files/m-p/185578

           

          A
          Anton Bondar
          May 7, 2019

          Hello boltonalloys ! Business Importer Desktop app is made to import Excel and CSV files into QuickBooks  Desktop. It has 14-days free trial, hope it will help you save your time! 

          BigRedConsulting
          BigRedConsulting
          December 24, 2019

          RE: Is there any way to download or convert the Excel file so I can import in quickbooks. I have been at this for MONTHS!! HELP!!!!!!!!!!!

           

          Yes, there are a couple of ways you can do this by converting the Excel or CSV file (opened in Excel) to another file format.

           

          To convert it to an .OFX/.QBO file for import using bank feeds, use our BRC Excel to OFX/QFX/QBO Converter 

           

          To convert it to an IIF file to import directly into your bank (or credit card) registers, use our BRC IIF Transaction Creator 

          N
          neilw60
          July 30, 2020

          I use a third party program to convert the file ...

          Very easy ... using a program to convert the Quicken file to a QBO file (type of OFX cleaner).

          I am not sure if I am allowed to disclose the name of the program ... 

          I believe it is worth the extra cost.

          Thanks ... 

          A
          AccountingAtEvergreen
          July 20, 2022

          I don't know why this works BUT...for Quicken .qfx files, simply download the .qfx file...open with Notepad...scroll down to where you see  "<INTU.BID>4411" (the number 4411 may be different depending on the bank), change the 4 digit number to 3000. Now save the document and change the extension to .qbo and voila! It uploads as a QBO file! 

          A
          AccountingAtEvergreen
          July 20, 2022

          I don't know why this works BUT...for Quicken .qfx files, simply download the .qfx file...open with Notepad...scroll down to where you see  "<INTU.BID>4411" (the number 4411 may be different depending on the bank), change the 4 digit number to 3000. Now save the document and change the extension to .qbo and voila! It uploads as a QBO file! 

          N
          numbers123
          October 3, 2022

          This discussion is talking about QUICKBOOKS DESKTOP not Quicken

           

          After all these months no answer on this except to buy a 3rd party converter.  It would be good to have some guidance from intuit. 

          Show more replies
          Terms & ConditionsAccessibility statement