Skip to main content
A
arielson
January 30, 2020
Solved

How can you import a csv file with transactions (such as bank transactions) on quickbooks accountant desktop 2017? It is different than the online version which dont have

  • January 30, 2020
  • 5 replies
  • 0 views
Original commenter did not share additional details
Best answer by MirriamM

Thank you for posting in the Community, @arielson.

 

The supported file when importing bank transactions in QuickBooks Desktop is (.qbo) file. 

 

To download web connect files, here's what you'll need to do:

 

  1. Go to the File menu at the top. 
  2. Choose Utilities, then Import.
  3. Select Web Connect Files. 
  4. Locate the QBO file you saved, then Open.
  5. When prompted to Select Bank Account, choose Use an existing QuickBooks account if the account you are importing the transactions into is already set up in QuickBooks or Create a new QuickBooks account if the account you are importing the transactions into is not yet in QuickBooks.
  6. Hit Continue and OK. 

Once done, go to the Bank Feeds Center to review your transactions. For additional information on this process, I recommend the following article: Import web connect (.qbo) files.

 

Just in case, I'll add these articles for future reference:

If you need anything else, leave a comment below. I'm here for you. Have a great day!

5 replies

M
MirriamMAnswer
January 30, 2020

Thank you for posting in the Community, @arielson.

 

The supported file when importing bank transactions in QuickBooks Desktop is (.qbo) file. 

 

To download web connect files, here's what you'll need to do:

 

  1. Go to the File menu at the top. 
  2. Choose Utilities, then Import.
  3. Select Web Connect Files. 
  4. Locate the QBO file you saved, then Open.
  5. When prompted to Select Bank Account, choose Use an existing QuickBooks account if the account you are importing the transactions into is already set up in QuickBooks or Create a new QuickBooks account if the account you are importing the transactions into is not yet in QuickBooks.
  6. Hit Continue and OK. 

Once done, go to the Bank Feeds Center to review your transactions. For additional information on this process, I recommend the following article: Import web connect (.qbo) files.

 

Just in case, I'll add these articles for future reference:

If you need anything else, leave a comment below. I'm here for you. Have a great day!

A
arielsonAuthor
January 30, 2020

Thanks!

Fiat Lux - ASIA
Fiat Lux - ASIA
January 30, 2020

Utilize this converter app

https://www.moneythumb.com/?ref=110

 

U
Unicomp
March 9, 2020

There is a converter I just found from Propersoft.com...CSVtoQBO.  I just purchased the one converter, but there are others.

 

I have nothing to gain from this but it saved me a ton of time.  The serve and followup has been great but it was truly seamless and I did not need any help.

 

This converts a csv bank transaction list to a QBO file to import though Web connect.

J
JPC Ventures
October 22, 2020

Am I missing something here? It says solved, but I don't think so.

 

Looking to download a CSV file (not a web connect file) into brand new copy of QuickBooks Pro 2020.  Credit Card Company does not offer a QBO download, does not offer Web Connect, is not a banking institution in the feed list.   Only option is CSV. 

 

The instructions listed here do not address CSV import for banking.  The only option listed here is to go out and purchase another software to make the software my customer just purchased work properly.

 

Tori B
Tori B
October 22, 2020

Hey there, @JPC Ventures.

 

Thanks for following the thread. I'm happy to elaborate on how to import using a CSV file. 

 

Since you're trying to import a CSV file from your bank, a good thing to note is QuickBooks can't import transactions. If you take a look at our guide from the tool kit mentioned by my colleague above, it states:

 

  • Import from Excel and CSV can only import lists. Transactions cannot be imported using this method. Importing from Excel and CSV uses field mapping between QuickBooks and the import file to identify what data goes where in a QuickBooks list record. In QuickBooks, this import function is accessed by clicking File > Utilities > Import Excel Files. Do not confuse importing from Excel and CSV with IIF import. Although IIF import files are often created using a spreadsheet program like Excel, IIF files use a completely different format.

With that being said, the only option you would have to import the transactions in QuickBooks would be to use a third party or manually enter them. 

 

I understand how importing the CSV file in QuickBooks would be beneficial for you and your business. I have personally submitted a feedback request to our product development team, so this can be considered in a future update. Please know you can follow our latest happenings and updates using our Blog Site. 

 

Let me know if you have additional questions or concerns. I'll be here every step of the way. Feel free to reach out to the Community at any time. Take care and enjoy the rest of your day. You certainly deserve it! 

    J
    JPC Ventures
    October 24, 2020

    Understood.  I agree with what others have said here.  A plug in is available for QBO, SO...it should be easy to make it available for desktop.  I hope they add it.

     

    Thank You.

    U
    Unicomp
    June 6, 2023
    This post has been deleted.

    I still use propersoft, inexpensive, good support, and it works great.

    https://www.propersoft.net/

    Merrill Lynch does not do QuickBooks file, so this easily transfers CSV.

    I do not know if it works with outdated QuickBooks, but it may be worth a try.

    Good luck all:)

     

     

    Terms & ConditionsAccessibility statement