Skip to main content
C
ChrisAC
January 23, 2021
Question

Manually importing downloaded qbo file from credit card in Quickbooks desktop 2019

  • January 23, 2021
  • 5 replies
  • 0 views

I have searched everywhere for an answer, tired everything in troubleshooting, but still not able to import a qbo file I download from my credit card company into QB desktop (windows) 2019.  I have an account on QB online and can import to that company file with a downloaded qbo file from the same bank, so I know it is not the file from the bank, it only does work in my windows desktop version of QB.  In QB desktop I have verified the credit card account is not active for auto download.  I start the import (file/utilities/import/web connect files...), then choose the qbo file saved on my desktop, but then I never get the window that asks for me to choose which account to import into as I have seen in every step-by-step example on the web.  It only tries to go online to connect and gives me the Error popup that reads "Quickbooks is unable to verify the financial institution information for this download. Click here to view common fixes for this issue."  I have gone through all the fixes as stated earlier.  How to I get it to stop trying to go online to download and ask which account to import into?  And again, NO, the little lightening bolt is not 

5 replies

R
Rea_M
January 24, 2021

Hello there, @ChrisAC.

 

Here are some of the possible reasons you're having trouble in manually importing a downloaded qbo file (Web Connect) in QuickBooks Desktop (QBDT):

  • The files from the bank are incomplete or in the wrong format
  • There are changes on your bank's end

 

Before we start fixing your Web Connect error, you'll first have to create a backup of your company file. Then, make sure you've kept your software updated so you always have the latest features and fixes.

 

You'll first have to download your Web Connect file directly from your bank, not from inside QuickBooks. This is to ensure you'll download the appropriate file. Her's how:

  1. Sign in to your bank's website
  2. Find and download the Web Connect file (.qbo file).
  3. Open QuickBooks and your company file. Then, start  importing your qbo file.

 

When you still encounter the error message, you can go back to the bank's website and review notifications. Follow the instructions to complete all the necessary updates. 

 

In case the error continues, I'd recommend performing the suggested fixes in this article starting Step 4: Fix Web Connect import errors. It also includes Advanced troubleshooting steps to further isolate the issue.

 

Additionally, I'd recommend reconciling your accounts every month. This is to effectively monitor your income, expenses, and the growth of your business. For the step-by-step guide, you can refer to this article: Reconcile an account in QuickBooks Desktop.

 

Let me know how it goes in the comments below. If you have other importing concerns or follow-up inquiries about managing transactions in QuickBooks, I'm just around to help. Take care always.

C
ChrisACAuthor
January 24, 2021

Thanks for responding.  Maybe I was not clear in my initial cry for help, so let me try again.  It is a Harley Davidson Visa, actually I have 3 of the same cards (different accounts of course, one for each company and one for personal).  The H-D Visa card is through US Bank and they used to offer the ability to download directly as my cards and accounts with other institutions.  This past year they stopped and now only offer downloading a qbo file to the desktop for importing into QB or QBO.  I have 2 companies, one I use QB desktop for and the other is on QBO so I can use the QB app for receipts and mileage integrated even though I do not care for QBO and the subscription stuff.

So in QBO I can import the downloaded file and it asks me what account to import into with no problems.  That tells me the downloaded file from the bank is fine and works.  However, when I follow all the steps in my desktop version it gives me the error I previously quoted and never gives me the window asking for which account to import into as I have seen in step-by-step tutorials.  

Your reply seems mechanical in that I have already stated that I have not only done "STEP 4", but have done all the "STEPS" including "Step 5: Create a test file".  I have even gone through the downloaded qbo file from H-D Visa and looked for issues in the contents of the file as I found some guidance online for that as well.

SO BOTTOM LINE:  How do I get my QB 2019 desktop for Windows to give me the window prompt to choose an account to import into?  I have attached a screen shot for what I found online as a visual example.

Fiat Lux - ASIA
Fiat Lux - ASIA
January 24, 2021

@ChrisAC 

Utilize the trial license of this converter app

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

 

C
ChrisACAuthor
January 24, 2021

Thank you for the recommendation.  Because the qbo file I download from the bank works in my QBO books file I don't think there is a problem with the downloaded file.  So using a converter to create a qbo file from statements will still put me in the same position when I try to import the qbo file in QB desktop.  The problem is QB desktop as far as I can tell.  I have jumped through ever other hoop ...

KlentB
KlentB
January 25, 2021

Hi there, ChrisAC.

 

I appreciate all the efforts that you've exhausted just to get this working.

 

At this point, I'd recommend contacting our technical supports. This way, we'll be able to look into your account in a secured environment, then investigate this issue. Here's how to connect with us:
 

  1. Open QuickBooks.
  2. Go to Help, then choose QuickBooks Desktop Help.
  3. Select Contact Us.
  4. Enter "Unable to see the window that asks which account to import the transactions into." in the description box.
  5. Click Let's talk, then choose a way to connect.

Our representatives are available from Monday to Friday at 6:00 AM to 6:00 PM Standard Pacific Time.

 

Additionally, here are some articles that you can read to be guided in reviewing your downloaded bank transaction in QuickBooks: Add and match Bank Feed transactions.

 

If there's anything else that I can help you with, please don't hesitate to insert a comment below. I've got you covered.

D
duhpensacola
March 31, 2021

I have a suggestion that might help if you did not get this resolved. One of my banks does not export their .qbo file with the right information in it for QB to read it properly. It is missing two lines of code that include the QB FID number so I have to add it manually to the .qbo before I import it.

 

IF this is the same problem you're having (it might be something else), first, find your bank's "FID" number in QB's FID directory. (Check this article for more info: https://quickbooks.intuit.com/learn-support/en-us/bank-feeds/update-the-financial-institutions-directory-in-quickbooks/00/186398). You can go here (https://ofx-prod-filist.intuit.com/qb3100/data/fidir.txt) and use ctrl-f to search for your bank name and see if you can track it down.

 

Then, open the .qbo file using Notepad (I right-click on the file name in File Explorer and choose "open with Notepad"). Find the line that starts with <DTACCTUP>. Immediately after that line, insert the following lines of code:

 

<FI>
<ORG>BANK NAME (as shown on the FID list that you searched)
<FID>XXXXX (the FID number for your bank from the FID list)
</FI>
<INTU.BID>XXXXX (the FID number again)

 

Then save the file. You should now be able to import it as you usually do and QB will recognize it as a valid file.

    C
    ChrisACAuthor
    March 4, 2022

    Thank you duhpensacola,

    I have spent a ridiculous amount of hours on the phone with US Bank and Intuit over the last months since my post with no resolve.  At one point I was interacting with an Intuit tech support person that came back with the response that US Bank needed to register the FID number since it does not exist in the QB FID directory.  I kept getting sent in circles with nothing being done.  I was hoping Intuit would have a backdoor phone number to call and ask them to register the FID and get this fixed.  Never happened.  I have laid this down, but coming across your response it has rekindled my interest.  Up till now I just stopped using the cards.

    I opened the download.qbo file from the H-D Visa website and opened it with an editor as you suggested and search for the <DTACCTUP> as you suggested.  It does not exist in the code?  Is there another tag possibly?

    Didn't see your response until now, thank you for doing so.  Maybe you should work for Intuit! ;@)

    D
    duhpensacola
    March 4, 2022

    Hi @ChrisAC ,

     

    Do you have anything in that file that resembles this code below? The red section is what I have to insert manually.

     

    <STATUS>
    <CODE>0
    <SEVERITY>INFO
    </STATUS>
    <DTSERVER>20210528165848.691[-4:EDT]
    <LANGUAGE>ENG
    <DTACCTUP>20210528165848.691[-4:EDT]
    <FI>
    <ORG>SYNOVUS CARD SERVICES
    <FID>12363
    </FI>
    <INTU.BID>12363
    </SONRS>
    </SIGNONMSGSRSV1>
    <CREDITCARDMSGSRSV1>
    <CCSTMTTRNRS>
    <TRNUID>0
    <STATUS>
    <CODE>0
    <SEVERITY>INFO
    </STATUS>

     

    Jennifer

    Controller at @duhpensacola 

    J
    JAK-TSD
    June 24, 2022

    I am having trouble importing .qbo files from a single credit card account (Elan Financial Services) into QB Desktop for Mac 2019 (and 2020) It wants to import the files into my Discover credit card account. Been struggling with this for over a year and support has not been able to help. I've done the following with no success (sent to me by QB Support)

     

    Disconnect Bank Feeds for an account in QuickBooks Desktop

    Resolving Potential Data Issues

     

    S
    ShiellaGraceA
    June 25, 2022

    Thanks for joining us, @JAK-TSD.

     

    I'll help get this straighten out for you. Since you're done with the troubleshooting steps, I recommend contacting our Customer Care Support. This way, they can create a ticket for you and assist you further. 

     

    Here's how you can reach out:

     

    1. Open QuickBooks.
    2. Go to Help, then choose QuickBooks Desktop Help.
    3. Select Contact Us. Then, enter a brief description of the issue. 
    4. Click Let's talk, then choose a way to connect.

    Our phone representatives are available from Monday to Friday at 6:00 AM to 6:00 PM Standard Pacific Time.

     

    Once done submitting a ticket, you'll received an update about the resolution when it's available. 

     

    In case you need help with other QuickBooks-related tasks, browse this link to go to the page. It has our general QuickBooks topics with articles: View all help for QuickBooks for Mac.

     

    Please know that you're always welcome to reply anytime if you need help with downloaded transactions or with QuickBooks. We're here for you. Take care and have a lovely weekend.

    C
    ChrisACAuthor
    June 25, 2022

    They never fixed my issue even with me giving them everything, so good luck with your issue.  I would suggest making sure your financial institution is listed, read above for the link.  If it is not no one I have talked to followed through with the bank to get it fixed (have the bank register the card) and have never heard anything from Intuit that it has been resolved.  Good luck ...

    Terms & ConditionsAccessibility statement