Converting QFX files to QBO files for Import to QuickBooks via Web Connect

Annoyingly, QuickBooksQuickBooks doesn’t support the import of QFX files (the reason for this is that Intuit charges banks for the ability to export financial data in the .qbo web connect format supported by QB.   If your bank doesn’t pay this fee, you can’t download your financial data directly into QuickBooks).

Fortunately, you can use a quick little hack to sidestep this limitation:

1) Download your financial data as a QFX file.

2) Open the file in a text editor, like Notepad++, and locate the Intuit Bank ID label near the top of the code: <INTU.BID> with a number after it.

Sample QFX File:

<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<DTSERVER>20090618000000[-5:EST]
<LANGUAGE>ENG
<FI>
<ORG>ABC BANK
<FID>12345
</FI>
<INTU.BID>1234
</SONRS>

3) Change the number after <INTU.BID> to a banking institution that is supported by Intuit. 2430 seems to work well for this. Also, 02153 per Traci’s comment.

4)  Save the file as .qbo.

5)  Import the QBO file into QuickBooks Pro via Banking > Online Banking > Import Web Connect File or simply opening QuickBooks and double clicking on the .qbo file to import it.

6) You will be prompted to select an account into which to import the QBO file.

139 Responses to “Converting QFX files to QBO files for Import to QuickBooks via Web Connect”

  1. Does not work for me. Do any other values need to be changed other than the ONE number sequence following the BID> ? FID also lists the same reference above…

    Thanks

    Zack

  2. Tried that as well… still get same error :(

    ” An error occurred while processing your online banking data.

    Your data was not imported in to Quickbooks.

    Please try importing your data again. If this error persists, contact QuickBooks technical support.”

  3. Wow cool! I just tried it so thanks

    I use a converter that usually works really well but I have to be careful of using the right bank numbers etc and with 12 clients to do it can be cumbersome if I am trying to remember them all

    The only issue I had was the file wouldnt recognize the bank so as a fix to that issue I created a new bank account and did the transactions into that for the new month then renamed the bank account and merged it with the old one. Still really easy

    Thanks

  4. EasyMoney

    Won’t for for me, what versions of Quickbooks is this good for? I have QB for Manufacturing & Wholesale 2008. I understand what’s going on here, its an XML file and Intuit is making a killing charging for a service.

  5. I am trying to download transactions from my cc bank and the only options I am receiving is for either an OFX or QIF format. When I look in notepad at both of those files, I do not see INTI.BID>1234. It ends with Language>ENG and then goes into the SIGNonmsgsrsvi message again.
    I do not see FI; ORG>bank name; FID>12345; /FI>; INTU.BID>1234.
    Any ideas?

  6. Pivot Man

    Works like a Charm. I found out that my bank (Bank Of Hawaii) is not recognized by QuickBooks and therefore only generates a QFX. The trick is to use a number that is not used by any other financial institutions in your file! Check the QBO of your other institutions to make sure you use a unique number!
    I use QB 2012

  7. Jules

    AMAZING!!! I didn’t expect this to work, but it did. Next task…how to get old statements that I downloaded in Excel format into Quickbooks :( I have a tax audit and need to enter all this bank and credit card data going back to 2009!

  8. Hi there, thanks for this. I was able to do everything but “save as” .qbo I tried within Notepad to “save as” and also through right-clicking and choosing properties, but I could not change the file type from QFX to QBO nor from .TXT to QBO. I can change the “open with” to Quickbooks but it still doesn’t recognize the file because of the extension. How do I “save as” .qbo and from what place shall I try it (Notpad, Properties)?

    Thank you so much!!!

  9. Never mind! Stupid Windows had my “file extentions” hidden. I un-hid them and now it works like a charm!!! thank you sooooo much!!!!!

  10. hiker108

    I’m running Quickbooks Pro 2009. Quicken just stopped supporting online banking downloads. I did the following:

    1) Downloaded a QFX file from American Express
    2) Edited that file, changing the FID and INTU.BID to 2340
    3) Saved it and renamed it with file extension QBO
    4) In Quickbooks I did a Web Connect File Import

    Quickbook displayed the online banking comm window and then returned with the dreaded
    “Quickbooks is unable to verify the Financial Institution information for this download”

    Any ideas?

    Ed

  11. hiker108, i think were screwed i have same version, its in the software not the file. we won’t be able to use .qbo files at all. they turn it off so you have to pay for new version/upgrade. wish i could find a way around it, but u cant just download the qbo and import it communicates and sees u have 2009 or older and wont allow the import unless you buy another newer version. its spread sheet import or manual entry now or buy same software over and over every few years. I HATE INTUIT SCAMMERS, my accounting firm dumped them because of this kind of stuff i have to convert everything to spreadsheets.

  12. I 6have the exact same scenasrio as described by Ed in the June 5th post. I have tried going through this process several times and tried changing the INTU.BID value to 2340 (and also tried 2340). I 6continue to receive the following error msg:

    “Quickbooks is unable to verify the Financial Institution information for this download”

    Perhaps this is because QB2009 has now discontinued support for online banking?

    Or any other suggestions to try?

    Thanks….it would be great to get this to work!

  13. Hi Bob, see the comments by rp and hiker108 above. It does sound like it’s due to discontinued support. We’ve tested within the last week in QB 2011 and it worked fine.

  14. LilOleMe

    Worked for me using QB Pro 2012. First it did NOT work when I tried to start the process via double-click on the QBO. When I followed the menu commands Banking > Online Banking > Import Web Connect File, it gave me the option to choose an account for import, then imported the transactions seamlessly, to the specified file. Perfect! You just saved me a lot of time and money, which with my client load down to 2/3 what it was, every penny counts! PEACE!

  15. BTW, this issue is a perfect example of Intuit’s complete lack of customer focus. Most of us would gladly pay a few more dollars if all of our accounts sync’d without issues (if they were more like Apple, this kind of thing would ‘just work’). Instead they choose to charge banks an amount that many won’t pay given the low margins earned on checking accounts. The banks and intuit also don’t absorb the hassle when things don’t sync – we do!

    A classic lose-lose situation. The customer suffers needlessly and Intuit leaves money on the table since we’d gladly pay a bit more for this functionality but instead Intuit wants to scrape value from banks who really don’t care if we suffer inconvenience.

  16. Success!

    You rock! Success! But it would be helpful to know what the proper code for Bank of America is. Right now, I’ve used your trick with the digits 2430 as suggested. This (plus, changing the file-extension from QFX to QBO) does seem to make the file import-able into Quickbooks. But Quickbooks still doesn’t know which of my accounts to apply the transactions to, and it gets kind of wonky trying to put them into whichever account IS properly linked to “2430”.

    I’m stunned at how irresponsible Bank of America is about this. They’re going to have to admit sooner or later that they’re behind the curve. Reminds me of back-when in the early days of the internet, when banks wanted to charge you extra for on-line access, when in fact giving a customer some degree of access to his accounts on-line would SAVE the bank in terms of time and grief and teller salary. So, they tried to charge the customer a fee for the privilege of the customer having the right to do the bank’s work for the bank. Eventually so many banks just said, “Oh heck, man, we LIKE it when they take the data-munging AWAY from our under-educated counter staff” that the ones who were resisting had to follow the herd. Similarly, I think Bank of America will have to admit soon, that keeping QBO files inaccessible is just childish of them.

  17. Glad you found this helpful. It’s likely that BOA doesn’t want to pay the licensing fee to Intuit for this feature, which is certainly not very convenient for customers.

  18. Thank you so much! I had no problem with your solution. I had tried a converter program when it was free and had one example of the .qbo file. I was able to search for in that file and discovered that 5885 is the code for USBank.

    Thanks again!

  19. Worked like a charm! My bank website will download a .qbo file but apparently my bank ended their contract with Intuit so Quickbooks recently started giving the dreaded “Quickbooks is unable to verify your financial institution” error. So I just changed the INTU.BID to 2430 then Quickbooks asked me what account I wanted to import into, and it worked! I have QB 2010 Pro. Thanks!

  20. Tried this with BofA and no go I get ” “Quickbooks is unable to verify your financial institution” error.
    Im sure it is due to my version of quickbooks being 2009 Pro. Can anyone suggest any other way to get this fixed? besides buying a new version of quickbooks?

  21. Hi Matt, see comments by Bob and rp above. You may be out of luck due to the version. You could also try another code in the .qbo file. Some have reported success with 5885.

  22. Unnamed QuickBooks user

    Thanks much from a long time QB user and consultant, and programmer. I use both Quicken and QB and don’t believe customers should need to pay banks yet another fee to access Open data we already pay to access from the web log in, just to import it to a data file. My contribution:

    There are two video tutorials for using the QuickBooks Online Banking center: Help menu > Learning Center, click on Overview & Setup.

    For the bank account in QB, edit the account and fill in the account #. Then, the download will always match by account # for the data you got from the Web, and not be confused by the FID code you use. After all, the download is your actual data and conveys the account # internally. I can bring in one file that has all transactions for two accounts. I found this on one bank website’s “Reports” page. I created a filter for Prior Month and a filter for Current Month. They already have a link for Daily.

    On the first download with an account # in QB with the pop up that asks you to match the data in the download to one of your QB accounts: Once you do this, everything is unique and linked to the correct account, even if the FID is not unique. FID is just the financial institution. Many of us have more than one account at the same institution. Make sure to set up the account # for each account in the Edit screen, and you have made it possible for the program to separately import the data to each bank account in your QB data file. You won’t get that pop up again.

    Since the FID # you are using is not really generic but specific to a real institution, all you are impacting is the Online Banking Center, the far left dropdown, which simply is an organizating aspect for electronic communication to the institutions. Since you are getting this via a file, don’t worry about logos. Using one FID for all your web connect files means the online banking center can be used as one central point for all the downloaded data, even if you had to bring in mutliple web connect files for your various bank and credit card accounts. Even investment accounts can be managed with Web connect files. One FID means all accounts show in the Online Banking Center without havign to change the selection in the dropdown, top left.

    And do not finalize the “online services” tab you have enabled, when editing those bank or credit card accounts. If you aren’t using the real code, you aren’t accessing the real institution, so there will never be authentication. Leave the userID and password info blank or with all 0’s as it is populated by the program.

  23. Works perfectly. You are my hero!! Using QuickBooks Premier 2012 Contractor Edition. For those of you might be having a hard time, download the file but choose the “Open” option. 1st try, it didn’t work (I saved the file, then open it with notepad). Save and name the file “filename.qbo”. Good luck to you all!!

  24. Hi there,

    Do you know if this should work with QB 2012 Premier? I can’t get it to work! I’m getting the same error message as Ed, “does not recognize financial institution.” Do you know another number that may work instead of 2430?

    Thank you!

  25. Oh my GOSH! I downloaded a ‘free’ trial an importing program today and then found it cost a subscription fee of over 100 bucks a year! Oops – kept looking- Then I found this hack. Wowww I am impressed and sooo thankful! :>

    This really tics me off in other ways though . I have really really been struggling to reenter all the data twice and then match it to a statement, and what a load of **** intuit put me through.

  26. I am trying to import chase banking in to QB 2008. I followed the entire process and got an error saying “Quickbooks is unable to verify Financial Institution information for this download. Please try again later”.
    We had the bank setup on QB’s for upload but since it’s an older verion I keep getting an error saying
    “ROBLEMS

    your financial institution sent an error message. This can happen if your financial institution is having problems with its Internet banking system.
    Wait 15 minutes, and then try connecting again. If you still cannot connect, contact your financial institution to see if its Internet banking system is working properly.
    If you still have problems after talking to your financial institution, contact QuickBooks Technical Support. [OL-301] Attention QuickBooks 2008 users: Online Banking and other services in QuickBooks 2008 were discontinued on May 31, 2011. To maintain high-quality products, Intuit supports the current version of QuickBooks and the two previous versions. Upgrade to QuickBooks 2011 to continue using your Online Banking service. Call 1-866-676-9670 or visit QuickBook.com.

    when I try and login the normal way.

    Any thoughts?

  27. I haven’t. I am just at a business doing bookkeeping briefly. I will try again in a bit. That second error message that they gave about online banking and other services bieng discountinued after 5/31/2011. Is that the reason I should continue trying to upload the way you instructed above?

  28. I just tried again. It’s been just over an hour since my first attempt and I got the same message… ughhh… need to upload that last 24 months worth of transactions to save a lot of time.

  29. Perfect! Worked flawlessly with QB Pro 2013. I couldn’t believe that they wouldn’t give this simple compatibility, but thanks to you it doesn’t matter…THANK YOU!!

    btw if anyone cares that bank code gives you Chase Card Services.

  30. Feldenkrais Institute

    Oh my goodness! This worked. Flawlessly to quote others, using QB Pro 2011 for Mac. I am speechless. I cannot believe that the solution was THIS DAMN SIMPLE and in repeated calls to US Bank, their customer service made this compatibility issue sound like it involved programming that could only be done by an unborn mastermind. To quote Seth, I can’t believe the bank wouldn’t provide this utterly simple solution for us QB users. Thank you, thank you.

  31. Chelsi

    This worked for me! Thank you so much! I could just kiss you! I cannot believe that the solution was this simple. I talked to my bank’s customer service and did some research online and I was told to use the .iif files they provided as there was no other download option for QuickBooks with my credit card statements. I really hate having to deal with the quickbooks .iif files, they suck, especially when you compare them to the simplicity of the .qbo files. Now I can just download the .qfx files, switch them over to .qbo and save a bunch of time! (I used this with QuickBooks Pro 2011) Thanks again!

  32. Chadman

    I have been using this “hack” for more than 4 years now, and today it’s not working. Anybody else find it has stopped working? Perhaps QuickBooks has closed the loop-hole? Help!

  33. Andy Morris

    The messages warning the end of the earth in 1 day if I don’t upgrade have forced me to look into this. Now I am going to cancel the usbank 12 / month fee.

    O.k. question this seems to work but prompts me to set up a new account in qb pro 2010. I don’t want to set up a chase account and it can’t seem to find my existing usbank account to dump the data in. I saw one person mention that they create a new account and then merge them later. Seems like a paigne. Might it help if I change the name of my us bank account to chase just to placate quickbooks? Any ideas appreciated.

  34. seems like the 2430 code no longer works.
    I tried to import my new file and i get the error message
    “quickbooks was not able to complete your request
    Please contact your financial institution”
    Went back to a file that i know imported last month and I get the same error message…

  35. Quickbooks 2010.

    I have a fix.. not the best.. but a fix.
    issue stems from 2 files that are updated automatically.

    fidir.txt and FIBlueprint.xml

    Something has changed to kill the 2430 trick…

    My solution.

    Go to quickbooks app.
    Right click – show package contents > Contents > resources
    The files are in this directory..
    Trash the 2 files..
    Copy over the original ones from your install disk.. Mine were from 2009.
    Lock these two files

    Edit your .qfx and use 2430 as before
    Import as before..
    yea..

  36. k muller

    hello! i tried this trick a few weeks ago and it worked brilliantly, thank you! i was so behind that i decided to wait to import the rest and now it is not working. i am using qb 2012 and it is telling me there is nothing to import, though i know there is. any thoughts? many thanks in advance!

  37. Michael Peeler

    The QFX to QBO file conversion has been working flawlessly with US Bank for a couple years. Today it failed with the QuickBooks pop-up “Quickbooks was not able to complete your request. Please contact your financial institution.” (I tried that dead-end a couple years ago; that’s why I am following your lead.) Anyone else seen this yet? I’m on QuickBooks 2011 Version V12.0.15 R16 for the MAC. Download worked in early May and is now failing in early July. Assistance appreciated!

  38. Michael Peeler

    Sorry. Finished reading all the way to the end of the posts and see I’m not unique. Will go the Jay fix route and see if it works for 2011 MAC version. Would love to know how you traced that one, Jay! Thanks!

  39. Michael Peeler

    :-( Jay’s fix did not work for me. My install files are AUG 31, 2010. I am running files from MARCH 21, 2012. I looked at fidir.txt and FIBlueprint and there are no changes to the info for 2430. Nuts.

  40. Outstanding!! Thanks so much for this post. This solution worked perfect and just saved me from manually entering a year worth of company credit card charges.

  41. Christina

    I stumbled across this forum hoping to figure out my OFX/QBO issue.
    My OFX file shows this for the first few lines:
    OFXHEADER:100
    DATA:OFXSGML
    VERSION:102
    SECURITY:NONE
    ENCODING:USASCII
    CHARSET:1252
    COMPRESSION:NONE
    OLDFILEUID:NONE
    NEWFILEUID:NONE

    It isnt the same info shown in the example provided.
    Please help!
    Thank you!

  42. One addition to my solution above
    For QB2013 Mac users…

    When quickbooks opens, it updates FIBlueprint.xml and fidir.txt automatically.
    trash FlBLueprint.xml and fidir.txt files in the ~/user/library/application support/quickbooks/downloads

    I turn off my Wi-Fi before I import my .qbo for good measure.

  43. I’m going to cry… IT WORKS!!!
    For others, make sure you have Online Banking supported QuickBooks, which means until 05/2014, QuickBooks 2011 or newer.
    My problem was I had bank with QBO file that worked until 05/2013.
    But starting 06/2013, it stopped download into QB.
    Had had similar problem 2 yrs ago in 05/2011, when my QB 2009 was stop supported and it took a some research to figure about about the retired QB versions.
    Above method will save your Online Banking under Chase and it does not seem to effect your account # or routing #.
    It took me several month to get to this site and I was about to give up and manually input everything.
    You SAVED me man!!! I had more than 1000 entry I had to manually if you was not for you!!!
    Thank you!!! Thank you!! Thank you!!!
    I’ll be extra nice to people in your honor for next 2 days.

  44. xunderworldx

    This worked.. Switched banks and couldn’t believe i have to pay $10 a month just to download a statement… But with this now I don’t have to pay them that!!

  45. I just tried re-naming the file extension WITHOUT doing the INTU.BID number change, and it imported just fine. NO changes to the text in the file, merely renamed qfx to qbo and it worked. Don’t waste money on any converter!

  46. I’m using QB Premier2014 and have Suntrust as the bank. I’m made it down to where I import and getting error. Im saving as QBO file but when I look at the data file it still shows QFX. I went back and resaved to make sure I had done correctly, but file still says qfx data. What am I doing wrong?

  47. I took the information here (thank you for that!) and created a quick online tool that does the work for you automatically.

    Check it out, its free forever (I dont have a care in the world to make money from this): http://qboconverter.com

    It only does QFX conversion to QBO files, probably has bugs since I’m not professionally testing it, but for those that it works for, its free and safe (no information is transferred over the internet – it operates totally offline).

  48. Lynn, I have the same problem . I am thinking about dumping Suntrust for a better bank though…..
    Maybe someone on this thread has a LIST of banks participating (paying the license fee) with Intuit so we can change to one of those banks….

  49. Debra Beasley

    This hack has been working well for me until now…the format of the qfx file seems to have changed and it no longer works. Do you have a new fix??
    Appreciate all that you do for us…

  50. Still doesn’t work with QuickBooks Premiere 2014…so any suggestions???
    BUT I DISCOVERED
    if you have the Quicken Converter installed with your Intuit product, (or if you don’t you can download it from Intuit) you will find a CURRENT LIST OF BANKS in the following directory:
    C:\ProgramData\Intuit\QuickenConverter\Inet\Common\Localweb\Banklist\2014
    From there, you can COPY the file to your desktop, OPEN Excel, SELECT the text file then CONVERT it with tab delimiters. The list covers 14343 institutions to choose from.

  51. Robert, thanks for the tip on the current list of banks. That’s valuable info. Would you be able to post them or send us a .txt file to post?

    Sorry to hear you are having issues with QB 2014 Premier. Have you tried Jay’s solution (it’s in the above comments at June 24, 2013)?

    Shaheen also posted a cool tool, we haven’t checked it out, so use at your own risk, but it’s here: http://qboconverter.com.

  52. Hiya! When I try to import I get as far as the Account Association window, but when I click on Select an Account under the Store in the Quickbooks Account menu no accounts come up, just the “new” option. For some reason it’s not’s seeing the accounts I created for Banks at all. Any remedies Folks? At this point I’m thinking I may have to give up and just shell out the $75 for Quicken. Sigh. QB is the WORST!

  53. @C133

    Yea. Once you download the site, zero information is transferred online; all the work is done inside the browser. To verify, you could load the website, disconnect from the internet and it would work fine.

    For now, it only works with the Google Chrome browser tho.

  54. Kandy, I have a similar problem. This technique worked fine in October, November and December, but in January and February I get a dialog box asking for a new file or offering me only the option of one other account, and it isn’t the one I need. I downloaded an update to QB between the December and January events and my suspicion is that they blocked this trick from working. I may have to break down and just get a “business” credit card — that’s working fine on my other QB account. Too bad, this was a nice technique while it lasted. If anyone else has figured out how to overcome this, please let us all know!

  55. I completed the process, but was not prompted to select an account. QB 2014 recognized that the 2430 code is Chase. It automatically created a Chase account. How do I move the transactions to my bank account?

  56. In step 6, you should be prompted to select an account. We haven’t tried this technique on QB 2014, so the process may have changed. Take a look at your bank account settings and see if you can update there. Please let us know what you find!

  57. I get an error “QuickBooks is unable to verify the Financial Institution information for this download. Please try again later.”

    Is there a way around this issue?

  58. Can’t believe this worked! Was ready to fork over the $150 for new version when I learned my bank doesn’t support or something doesn’t support syncing when using yosemite… glad I didn’t using quickbooks 2013 for mac this worked great! Thanks!!

  59. Tried to open the QXF I created from Quicken 2015 in Notepad and just got gobbledygook. No discernible English words whatsoever. Am I doing something wrong, or did Intuit put in another hurdle?

  60. My problem was not with QFX files but the QBO file I download was generating the error that “Quickbooks is unable to verify your financial institution. Please try again later.” As if trying later would fix it. My bank was recently bought out by Talmer West Bank. A recent change to their computer system made the account data downloads no longer work with Quickbooks. After several days and several calls to my bank with no luck, I finally stumbled on this site. I used the suggested edit to the QBO file and now it successfully imports the data. The code 2430 is a Chase bank code so in my online banking I now show one of my credit cards under Chase and my business checking account. That does not seem to be a problem but I might try to find another unique code that works. Seems that the people at my bank should know what the correct id code is. Clearly the code that is in the download is not being recognized by Quickbooks even though Talmer West Bank is in the list of financial institutions.

  61. Based on Jay’s comment #71, I opened up the fidir.txt file and searched for U.S. Bank–copied the INTU.BID code and pasted it into that & the FID area of my qfx file, and it worked. 02153 is the number that worked for me. THANKS!

  62. Looks like I goofed leaving my comment. I’ll try again. From Jay’s comment, #71, I opened the fidir.txt file, found my bank’s code (US Bank), and pasted it in for both the INTU.BID & FID, and it worked. I used 02153.

  63. Is there a work around for QB Pro 2008? I tried the earlier comments and it did not work. My comp crashed recently and Ihad to re-install the disc. please advise

  64. Sherrie

    I can’t seem to get it to work, Don’t know if I’m just too computer ignorant to do it. Just to make sure, after I have changed the number, and go to save the document do you have to do anything other than change the letters after the . to qbo?

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>