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

July 19, 2011

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.

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.

{ 117 comments… read them below or add one }

doug November 8, 2011 at 8:59 pm

WOW. Thank you sooo much. I can’t believe how easy this was. It worked too! No stupid converters.

Zack November 15, 2011 at 6:24 pm

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

C133 November 15, 2011 at 7:29 pm

You could try <FID>, but typically one only needs to edit <INTU.BID>.

Zack November 15, 2011 at 7:41 pm

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.”

C133 November 16, 2011 at 1:24 am

Have you tried re-downloading the data and trying again from a clean slate?

Paul January 30, 2012 at 1:18 pm

Thank you so much!! Works Brilliantly!!!!!!

frustratedBOFAcustomer February 2, 2012 at 2:50 am

thank you so much! the best trick to get my BOFA acct to upload into QB for Mac. you made life so much easier!

C133 February 2, 2012 at 12:23 pm

You’re very welcome, glad it helped you out!

Sue February 3, 2012 at 12:53 am

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

C133 February 3, 2012 at 1:11 am

You’re welcome. Glad it worked out well for you!

EasyMoney February 10, 2012 at 10:26 pm

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.

C133 February 11, 2012 at 1:00 am

We tested it in QB Pro 2008 and 2011. You need to download as a .qfx file and then you should see the tag.

Voa February 21, 2012 at 3:55 pm

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?

C133 February 21, 2012 at 5:30 pm

Hi Voa, this tutorial is for .qfx files, not .ofx or .qif files. Try Googling a solution specific to those file types. Good luck!

Rona Badger April 14, 2012 at 4:50 pm

I think I love you! No, I actually know I love you! THIS WORKS FOR ME!!!!!!!!!! Woo Hoo!!

Pivot Man May 24, 2012 at 3:56 am

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

JTittler May 30, 2012 at 11:26 am

This worked quite well. Thank you for sharing!

Jules June 1, 2012 at 4:42 pm

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!

Kim June 3, 2012 at 2:13 pm

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!!!

Kim June 3, 2012 at 2:33 pm

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

C133 June 4, 2012 at 1:16 am

You’re welcome. Glad you figured it out.

hiker108 June 5, 2012 at 9:06 pm

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

C133 June 7, 2012 at 4:21 pm

Try just changing INTU.BID and leaving FID as is.

eclecticd June 27, 2012 at 6:08 pm

OMG it worked! freaked me out a bit to see a C***E logo rather than the card I was importing…you saved me a bunch!

rp June 28, 2012 at 6:57 pm

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.

Bob June 28, 2012 at 11:19 pm

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!

C133 June 28, 2012 at 11:23 pm

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.

LilOleMe July 18, 2012 at 5:56 pm

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!

Jefferson Kim July 24, 2012 at 12:00 pm

THANK YOU! It worked just as you stated! I just wanted to thank you.

richie r August 20, 2012 at 8:24 pm

wow, you are the man! I was about to spend $40~$60 for some software to do this. your way was much cheaper and FREE!

C133 August 22, 2012 at 12:31 pm

Glad you found this useful Richie, cheers!

John September 29, 2012 at 12:46 pm

Brilliant solution – works perfectly. Thanks a million!

John September 29, 2012 at 1:56 pm

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.

Success! October 1, 2012 at 1:43 am

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.

C133 October 1, 2012 at 4:34 pm

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.

Kathryn December 3, 2012 at 11:50 pm

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!

C133 December 3, 2012 at 11:55 pm

You’re welcome Kathryn, thanks for documenting the USBank code!

Glen December 6, 2012 at 12:29 am

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!

Matt December 17, 2012 at 10:04 pm

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?

C133 December 19, 2012 at 7:30 pm

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.

Unnamed QuickBooks user December 25, 2012 at 4:05 pm

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.

C133 December 25, 2012 at 5:42 pm

You’re welcome. And thank you very much for including the detailed and helpful tips! It is great to have them documented.

John A January 18, 2013 at 2:18 pm

thanks so much! quick and to the point–and it works!

Joe January 23, 2013 at 1:24 pm

Life Saver!!!!

Thinh January 29, 2013 at 7:46 pm

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!!

Claudia February 10, 2013 at 9:56 am

OMG THANK YOU!!!!!

Genna February 13, 2013 at 7:36 pm

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!

C133 February 20, 2013 at 1:12 am

Sorry, not sure about QB 2012 Premier. Make sure you’re entering the code correctly and if it still doesn’t work, please let us know if you figure out the issue.

Dean February 26, 2013 at 8:59 pm

After finding a whole lot of crazy complicated solutions, used your method and it worked perfectly 1st try on Quickbooks Pro 2011. Thank you.

Debi March 1, 2013 at 6:10 pm

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.

Rich March 3, 2013 at 12:00 am

AWESOME! Pulled from US Bank, all accounts and imported perfectly into QB2013 Pro. -As Chase Bank Accounts :)

Thank you!

Jenny March 4, 2013 at 4:23 pm

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?

C133 March 4, 2013 at 4:26 pm

Did you try waiting and retrying the connection in a few hours or so?

Jenny March 4, 2013 at 5:51 pm

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?

Jenny March 4, 2013 at 5:53 pm

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.

Seth March 13, 2013 at 9:59 pm

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.

LilMomma March 14, 2013 at 5:59 pm

This has brought tears of joy to my eyes thank you sooooo very much.

BT March 24, 2013 at 10:19 am

THANK YOU VERY MUCH!

Worked for me, too: QuickBook 2013 for Mac.

Feldenkrais Institute March 25, 2013 at 8:35 pm

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.

Chelsi April 4, 2013 at 9:05 am

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!

Chadman April 15, 2013 at 1:25 pm

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!

Andy Morris May 30, 2013 at 1:14 am

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.

Darci June 12, 2013 at 3:07 pm

Unbelievably simple and effective. If I could, I would send you a Krispy Kreme donut. Thank you very much!

C133 June 12, 2013 at 3:22 pm

Wish that was possible, they are so delicious! You’re welcome.

Don June 15, 2013 at 1:04 pm

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…

IVMT June 16, 2013 at 12:08 pm

WOW!! You are *brilliant*!! It worked for me, and you saved me SOOO much money!! I am forever grateful to you. And very easy to do.

THANK YOU VERY MUCH!!!

debra June 19, 2013 at 5:26 pm

1234 does not show up

C133 June 19, 2013 at 5:30 pm

You are using 1234 for the code? That may not work. Use the code from the post.

Jay June 24, 2013 at 9:54 am

Don.. I have the same issue. What gives ? Anyone have a new solution ?

C133 June 24, 2013 at 9:56 am

Jay, what version of QB are you using?

Jay June 24, 2013 at 12:06 pm

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..

C133 June 24, 2013 at 12:18 pm

Thanks for the info, Jay. Good to know about the workaround. If we’re able to locate any other solutions, we will update!

k muller June 24, 2013 at 5:38 pm

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!

C133 June 24, 2013 at 6:57 pm

Have you tried Jay’s fix (above)? Did you upgrade between the first time you used the code and the present?

don June 26, 2013 at 2:08 am

can anyone send me the two files mentioned above from an old install?
I can’t locate my install disk as ee are packing up to move…

Napleschick June 27, 2013 at 11:21 am

Worked perfectly for me today, thanks!!! No work around required. N-

C133 June 27, 2013 at 11:37 am

Thanks for the update Napleschick, what version of QB are you using?

Michael Peeler July 10, 2013 at 2:57 pm

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!

Michael Peeler July 10, 2013 at 3:04 pm

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!

Michael Peeler July 10, 2013 at 4:38 pm

:-( 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.

Amy S July 20, 2013 at 2:12 am

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.

Maria August 5, 2013 at 1:45 pm

Thank you soooooo much!!!

89052zoo August 9, 2013 at 5:40 pm

Windows QBE user: It worked! Thanks for the post.

Tom Leonard August 9, 2013 at 8:52 pm

Worked fine for me. QQB2013 / 2430. Thanks very much. I had been working with a 3rd party software solution, but it only supported one bank account. This is much better.

Sidney Beck September 20, 2013 at 8:29 pm

QB Pro 2013 and it doesn’t work for me. Suggestions?

Christina September 27, 2013 at 6:03 pm

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!

Jay October 19, 2013 at 8:21 pm

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.

C133 October 21, 2013 at 7:39 pm

Thanks for the additional info, Jay. Much appreciated!

C133 November 1, 2013 at 6:09 pm

We have tested this method and code 2430 is still working fine.

JimK November 24, 2013 at 5:08 pm

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.

C133 November 29, 2013 at 12:07 pm

You’re welcome, glad it saved you from having to do manual entries!

Bob January 1, 2014 at 9:49 pm

The 2430 hack has previously worked but not until I took Jay’s advice today did it return to working again. Thanks.

xunderworldx January 7, 2014 at 4:11 pm

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!!

C133 January 9, 2014 at 8:28 pm

Glad it helped you out and thanks for letting us know!

Gary January 17, 2014 at 2:30 am

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!

C133 January 18, 2014 at 1:38 pm

The INTU.BID value for your bank may have already been on the QB-approved list. Could you post your INTU.BID?

Lynn January 21, 2014 at 1:36 pm

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?

C133 January 21, 2014 at 1:39 pm

Double check that the file extension is .qbo and not .qbo.qfx or something of that sort.

Shaheen January 29, 2014 at 2:51 am

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).

C133 January 30, 2014 at 10:35 am

Cool tool Shaheen. Thanks for sharing it with us. Is all info secured during transfer and conversion?

Robert January 30, 2014 at 10:29 pm

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….

C133 January 30, 2014 at 11:36 pm

It would be great to have such a list.

Debra Beasley February 1, 2014 at 7:26 pm

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…

C133 February 1, 2014 at 8:41 pm

Debra, have you tried Jay’s solution (it’s in the above comments at June 24, 2013)?

Robert February 1, 2014 at 10:17 pm

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.

C133 February 1, 2014 at 10:51 pm

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.

Shelley February 1, 2014 at 11:47 pm

I did the same thing as Gary – just opened the QFX file with Notepad and then did a SAVE AS OBO. Imported into my Quickbooks and voila! Thank you Gary!

Kandy February 9, 2014 at 7:03 pm

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!

C133 February 12, 2014 at 10:46 am

Hi Karla, is it possible to delete the accounts you’ve created and start with new ones that you create during the import process? That may be the quickest workaround.

Shaheen February 15, 2014 at 4:03 am

@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.

C133 February 17, 2014 at 3:04 pm

@Shaheen

Cool. Thanks for the additional info. We’ll give it a test run soon!

Hawthill February 21, 2014 at 11:15 am

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!

C133 March 3, 2014 at 9:45 pm

Hawthill, have you tried the tool Shaheen posted above?

Shaheen March 8, 2014 at 1:37 am

I updated the site. Hopefully it works better for some of you out there in the internet tubes.

Candy March 17, 2014 at 5:40 pm

THIS. IS. AWESOME!!!! Thank you so much!!!

Rakesh April 24, 2014 at 11:08 am

Absolutely amazing. Thank you for making my life easier. You rock!

Matthew May 2, 2014 at 6:10 pm

Thank you so much! This worked like a charm. I converted 18 months of statements in less than 10 minutes!

Leave a Comment

Previous post:

Next post: