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

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!

Carolyn September 24, 2014 at 5:09 pm

Wow!! You saved me hours!! Thank you!!

C133 September 24, 2014 at 5:11 pm

You’re welcome!

paul w October 1, 2014 at 4:43 pm

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?

C133 October 9, 2014 at 8:49 am

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!

Lina November 20, 2014 at 2:44 pm

How do you get the Financial Institution Code? I am wondering if I can this information for my bank.

Ben January 7, 2015 at 9:10 pm

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?

Sara February 12, 2015 at 4:53 pm

This trick no longer seems to be working. So sad. I think QB is pushing everyone to their online version.

NP February 17, 2015 at 2:10 am

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

Daniel March 11, 2015 at 12:45 pm

Excellent tip!

Mel March 13, 2015 at 12:54 pm

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?

Greg March 19, 2015 at 12:10 pm

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.

C133 March 19, 2015 at 12:14 pm

Mel, try using Notepad++. It’s a free download. Just do a Google search for it.

John March 30, 2015 at 7:36 pm

Is there anyway to import QBO files after quickbook 2015 expire in May 2015?

Traci Bunkers March 30, 2015 at 8:59 pm

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!

Traci Bunkers March 30, 2015 at 9:12 pm

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.

C133 March 31, 2015 at 12:09 am

Glad it worked for you Traci. Thanks for sharing the US Bank code!

Britt April 18, 2015 at 1:12 pm

Using QB Pro 2014 and it work great!!! Thank you for sharing you brain with us:)

I used code 2430… Chase Bank….

jk April 21, 2015 at 7:07 pm

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

jk April 21, 2015 at 7:17 pm

is there any way to redo the download through pro 2008? itried prior attempts and nothing

TrpltDad May 1, 2015 at 1:34 pm

btw, I was using Premier 2013

mr June 12, 2015 at 4:33 am

Thank you so much. This worked beautifully and saved hours and hours of time. What a blessing!

Sherrie July 9, 2015 at 2:29 pm

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?

Jess September 5, 2015 at 4:40 pm

THANK YOU!!!!!! It worked beautifully!

David September 13, 2015 at 3:32 pm

Similar troubles to a few but found a way to make it work. Using QB 2011 Pro and U.S. Bank information. Despite trying Jay’s fix, kept receiving the “Quickbooks is unable to verify Financial Institution information for this download. Please try again later”. Am sure QB is at the root of this problem.

My needs were immediate as taxes were due in 2 days. So tried the QB free trial of 2015 and attempted the import…and it worked. Used 02153 as the code for U.S. Bank. Enabled me to finish taxes far faster…Thanks Everyone!!! Next experiment is to now upload completed files and try QB Online or find a company that actually cares. Thanks Again!!!

Robert October 19, 2015 at 3:33 pm

I use QB for 3 different companies. This worked around worked great for 2 of the companies (which were set up as “retail”. When I try and use the work around for the 3rd (and most important company), which is set up as “professional services”, I do not see my bank account in the “Use and Existing Account” drop down box. Does anyone know why my bank account does not show up when it does for each of the other companies?

Hope December 10, 2015 at 12:31 am

I love you.
I have been manually entering thousands of transactions because my rural bank does not pay the fee. Then my computer had a meltdown, and my backup copy of QB was corrupted. I lost the entire year. So you have saved me from the mindless task of data entry FOR THE ENTIRE YEAR. Thanks!!!

M April 2, 2016 at 11:50 am

I’ve used this workaround before and was successful again today, using code 2430 with QB 2014.
OFX edits:
-Edited FID to code 2430, as before.
-This time I had to correct bank account # in the OFX file ()
QB did not want to download to the account I already had set up in the COA, so I let it create a new account and it worked.

This trick has been a lifesaver to me, Thanks! Hope my note is helpful and Good Luck to All!

Tom May 23, 2016 at 1:40 pm

I just updated QB to 2016, and having the same issues with QFX files. I did the change, using code for Chase Bank, and it seems to work. But, I have accounts with Rabobank, and would like to append these transactions to my Rabobank account in QB. When I am asked to import to an existing account, the drop down is blank. Thoughts?

C133 May 23, 2016 at 1:42 pm

Glad you’ve found it useful and thanks for sharing your tips!

Jason Luros June 20, 2016 at 5:16 pm

If you need help converting Citibank QFX downloads to QBO, I wrote up instructions here:

https://community.intuit.com/questions/1386709

Jeff Dooley June 29, 2016 at 12:11 pm

Using QB 2016 for Mac & dealing with the Costco switch from AMEX to Citibank. I’m having no luck at all, am hoping Costco has a nice “sit-down” chat with Citibank to ask why they want to ignore who knows how many people that use QB & are Costco members.

C133 July 26, 2016 at 8:53 am

Hi Jeff, see the post directly above yours for instructions to do exactly this.

SM August 1, 2016 at 3:27 pm

After Wasting many hours, this did the trick. Thanks a lot for your help. You saved me the upgrade for $200.

Paul August 12, 2016 at 12:40 pm

Thank you thank you thank you! Works like a charm and saved me a LOT of time.

lee August 25, 2016 at 2:13 pm

Not working for me. I have tried the qboconvert as well as changing the extension. I’ve tried 2430 and 2340 as well as my banks number. When I double click on qbo file, it opens the new tranxaction data window. Import new transactions is already selected and I click ok. That brings up the “Select Bank Account” window where I select “Use an existing QB account” and pick the appropriate account from the drop down list. Once I hit continue, the “Select bank account” window is immediately re-displayed and the only option is create a new account.

lee August 25, 2016 at 2:14 pm

BTW I am using QB Pro 2014

lee August 25, 2016 at 2:20 pm

I also took a look at the two files Jay mentioned back on June 24. My bank is still listed in those files.

Carrie August 28, 2016 at 2:23 pm

Uuummmm…..AMAZING!!! THANK YOU~~~!!!!

Stacy August 29, 2016 at 10:33 am

It worked, oh my god! Thank you. I am using QB Accountant 2015 and downloaded info from Bank of America. Very grateful!

Dianne Barney September 14, 2016 at 12:23 pm

Thank you so much!! It worked!

Alexander Mecca September 15, 2016 at 5:45 pm

This seems to have did the trick for one of my customers. Thanks

Bazza November 9, 2016 at 9:39 pm

This work around has been working for multiple years for me but my latest import created journal entries for each credit card charge – a debit and credit for each transaction. It did not create the usual credit card charges. Any idea why?

Ray November 13, 2016 at 7:00 pm

I have tried this fix multiple times with different codes and i keep getting “Quickbooks is unable to verify the financial institution information for this download”
I am downloading from Suntrust which allows download of .qbo files directly. I dont have to change the extension
I have QB 2006 and QB 2013 and no luck with either 🙁

Jeff December 30, 2016 at 5:33 pm

Lee, Im having the exact same issue. I have been using this trick for over a year with no problem. Now all of a sudden it asks me “select existing account” etc.
Have you found a fix yet?

Abe January 4, 2017 at 5:05 pm

The 2430 code had worked for years, even through mid November, and now is not working. I have also tried 02153. Thank you for the initial code! Any chance you have a new fix???

Hilary January 7, 2017 at 10:17 am

Never tried this in the past(2013) but was super hopeful it would work. Scrolled down to see the recent(2016) comments. =( No luck for me! Do you have a work around yet? I used 2430 and 02153.

Dan January 9, 2017 at 1:12 pm

I am still using QB2009 for fear of upgrade remorse.
None of the codes I found online seem to work any longer, so I did some research and found that these work for me: 00915, 10915. Good luck! I hope this helps!

C133 January 9, 2017 at 1:52 pm

Awesome, thanks for sharing this Dan! We’ve updated the post to reflect these codes.

Melissa January 20, 2017 at 11:13 pm

2430 worked for me on Quickbooks 2016

C133 January 21, 2017 at 11:19 am

Good to know, Melissa. Thanks for sharing this info!

Shelley February 16, 2017 at 10:41 am

I used Test Wrangler for Mac and used code 10915, and it worked!

Rafael February 28, 2017 at 5:46 pm

Wow! Im using IMac I don’t know of a text editor saving to .qbo extension. If there is one will you suggest it? Thanks!

C133 February 28, 2017 at 6:03 pm

Try Sublime Text, or some people have used Text Wrangler.

LKS April 13, 2017 at 2:19 pm

Worked in 2014, not in QB 2015.

Kim June 10, 2017 at 12:06 pm

You rock! Worked with 2430 / QB Pro 2015

Lisa June 30, 2017 at 11:27 am

What if the bank is Citizens? What is the code for that or where can I find it?

sy July 6, 2017 at 8:36 pm

No luck for me either. There may be a current year identifier in the 2017 bankfeed file or there may be a registry key that turns off the ability to upload the new bankfeed file after a certain date. Anyone have any ideas.

Don Nahhas August 11, 2017 at 12:44 pm

I have a US Bank Business account and was able to use 02153 yo import my info

Lisianthus August 30, 2017 at 12:43 pm

2430 worked for me with QB2010. I just saved it and then in the file manager, changed the file extension from .qfx to .qbo

Kathryn October 14, 2017 at 4:51 pm

Thanks Don Nahhas! It worked although it did make me create a new online account but since it seems to be merged with my US Bank register, all is OK. 😉

Kerry October 16, 2017 at 9:29 pm

Just did it with 2017 Accountant Desktop and code 2430. Awesome!!

Mathias December 27, 2017 at 6:17 am

Using Mac 2014 QB and it’s not working – USB bank changed both the numbers to:
02153

02153
And also tried the other – 5885
Nothing works .. can get to import panel and then hit import, select file named and can’t import.
Message – QuickBooks was not able to complete your request.

Brandy Bradford January 10, 2018 at 6:46 am

This continues to work for me every time downloading from US Bank & using code 2430, importing into QB 2015 Pro. THANK YOU so much for this workaround, it has been a lifesaver!

Vinay Patel January 10, 2018 at 6:24 pm

For QuickBooks 2016 it doesn’t work. Any help would appreciated!!
same message – QuickBooks was not able to complete your request.

Mrs Smith March 1, 2018 at 10:45 pm

2430 still works for me on QB Pro 2018. However I was having a problem and found a solution to turn off the Chart of Accounts and edit the account in question to turn off online services (Deactivate All Online Services) Then I was able to choose the account from a list of existing accounts when it would not come up as selectable when Online Services was Activated.

Lawrence March 21, 2018 at 7:33 pm

Thank you! Thank you! Now I can keep my personal accounts in QuickBooks.

Kimberly June 9, 2018 at 7:49 pm

I finally got it to work today with QB Pro 2018 desktop by using a code from this link: https://ofx-prod-filist.intuit.com/qb2800/data/fidir.txt, which is the entire current bank list for Quickbooks.

C133 June 10, 2018 at 2:12 am

Thanks Kimberly! We’ve updated the instructions in the post with a link to this list.

Mali September 28, 2018 at 1:00 am

Thank you for that update!! You da bomb!

Sarah November 14, 2018 at 9:50 pm

C133!! YOU ARE AMAZING! I am SO glad I kept searching and searching online for a solution! Of course, all the time I’ve spent searching, I could have easily entered all the transactions I was trying to import, but that’s beside the point! Your “work-around” worked for me with QB Pro 2019, thank you! My multiple calls to BOA and QB were NO HELP! You helped! Thank you very very much! Blessings!

Robert December 22, 2018 at 1:05 am

Can I now be considered a hacker:) Thank you VERY much for the information, it worked like a charm!

Bob Stanton February 4, 2019 at 4:59 pm

Navy Federal does not offer the QBO this fixes my issues and worked great. Now I can get the info like I do with importing other web connect files in my 2017 QB.
Thank you
BobS

Donna March 17, 2019 at 5:57 pm

Hot diggity! After hours of searching for a solution, this works! Opened file in Notepad, changed bank code to 2430 and saved file name with .qbo extension. So simple. Upload to QBs Desktop shows a different bank name but that’s OK because I was able to import 20 months of transactions. Thanks so much!

Paige Weber March 23, 2019 at 2:30 pm

This has worked like a charm for me downloading from Citibank using Mac QB 2015 and now Mac 2019. Credit card and checking info. Thank you so so much! A word of advice: when downloading account info, Citibank does offer a .QBO file type option in addition to a QFX, but I have had mixed luck using the .QBO file. One of my credit cards would not import unless I downloaded the QFX file and followed the steps above. But I know I have been able to import using QBO for certain accounts in the past. Something in the code, too deep for me to figure out. Anyway, shortcuts (downloading the QBO file) aren’t always time saving, that’s for sure!

Lars Dennert April 22, 2019 at 5:00 pm

This worked for me, once. Then when I tried to connect additional accounts, everything stopped working and I’m back to using a spreadsheet that converts CSV to IIF.

C133 May 23, 2019 at 7:02 pm

Did you try changing the INTU.BID tag for each extra account that you tried to connect?

Bob Tryber May 28, 2019 at 12:27 am

I checked my BMO bank account for QBO and QFX file and the INTU.BID for both is the same 17614, but the DTASOF number and DTSERVER number has a different last two digits at the end of the number shown. For QBO the two digits are 31 for both and for QFX the two digits are 09.

Joan July 24, 2019 at 10:20 pm

I’ve been using this hack for a year or so, and recently it seems the file format has changed and I can’t import anymore. Is anyone else having this problem? I checked the file for Wells Fargo (one account I have that does pay QB) and the file is different than the one I’m trying to change.

Henry Miller August 8, 2019 at 4:30 pm

I have used this method many times but this time no matter what number I use when quickbooks opens it wants me to chose my account but there is no account in the drop down list. Only “add new”. any Ideas?

C133 August 15, 2019 at 6:56 pm

It could be that some of the data in the QFX file has changed, so QB doesn’t recognize as the one that is associated with your current account and needs you to choose a new one. You can’t choose the existing one because it is already linked to an account. You could try unlinking it and then reattempt the file import.

drea September 11, 2019 at 8:30 pm

Just wanted to say thank you so much for posting this. Really helps with 5/3 since they took over MB.

C133 October 15, 2019 at 2:29 pm

You’re welcome! Glad it’s helpful.

Rion December 8, 2019 at 1:03 am

THANK YOU SO MUCH, AND FOR THAT LIST! I found Bank of America, threw the code in, saved is as a qbo, and it worked perfect!! You are a LIFE SAVER

Duane December 8, 2019 at 2:40 am

I have tried this method with several different banking numbers, but each time I try to input it into QB Pro 2019 it says it cannot read the file that my financial institution sent. Any Ideas?

C133 December 11, 2019 at 3:21 pm

Sounds like an issue with the file itself instead of the bank code. Check the formatting of the file closely to see if anything looks incorrect. Try downloading a different statement/file from your financial institution to see if that works.

Elena February 9, 2020 at 2:46 am

Amazing help, very much appreciated! So much time and effort saved. Thank you so much foe this solution

Uriah February 10, 2020 at 1:10 am

I have been using this trick for years but now in early Freb 2020 – I can’t get any code to work and keep getting the quickbooks is unable to verify the financial institution code. I’m using Enterprise 18. Any thoughts?

Becki Logsdon March 30, 2020 at 8:32 pm

I cannot begin to tell you how grateful I am to have found this! I’ve been fighting with .xls files for my clients with US Bank for years. Thank you so much!

mgcan May 24, 2020 at 8:31 pm

@Duane,
Check the length of ‘NAME’ tag. It can be maximum of 32 Char.
Check Example below:
https://pasteboard.co/J9U4fOR.png

Brian Rainey August 7, 2020 at 5:28 pm

Im having the same problem with trying to download us bank credit card transactions into QB desktop pro 2019. Called Us bank and they said they just dont sync up with QB desktop. I followed all these steps to a T. Changing code in notepad and saving as QBO etc etc. But when i try to import into QB it says “you are trying to upload a web connect file that qb does not support. Contact your financial institution.”
Anybody know the new 2020 version of a work around for this?

Douglas August 19, 2020 at 4:36 pm

Thanks for posting this. Works great!

I created an Automator workflow (mac) to auto-convert a QBX file to a Quickbooks supported QBO file via drag and drop. See screenshot below.

In Automator, create new ‘Application’ (File/New), and save it somewhere handy.
Then add the following workflow steps:
1. Duplicate Finder Item
2. Rename Finder Items
– Replace text
– Find: .qfx copy in full name, ignore case
– Replace: ‘.qbo’
3. Run shell script
– Shell: bin/bash
– Pass input: as arguments
– script:

#!/bin/bash # # Find / Replace 9899 (ETrade) with 3000 (Wells Fargo) # To use, change the numbers in line 2: # Set first number to your real bank (found in the downloaded QFX file). # Set second number to the QB supported bank (found in link list). # https://ofx-prod-filist.intuit.com/qb2800/data/fidir.txt # /usr/bin/perl -CSDA -pi <<'EOF' - "$@" s/9899/3000/og; EOF

4. Save. Then drag and drop your QBX file onto your saved automator app.

The app will duplicate the original in place, rename it, then search / replace the Bank ID.

C133 August 19, 2020 at 4:46 pm

Thanks for sharing this Douglas, looks helpful for streamlining the process.

Lando December 18, 2020 at 2:18 am

I have a credit card from USAA. Has anyone found a way of downloading from them b/c they allow export in csv or direct connect in qfx but not without direct connect. Thanks.

SudzDaddy January 27, 2021 at 8:38 am

Edit file as referenced above, use 2430 as code, then rename QB account. Good for DT2020.

Brian January 30, 2021 at 1:29 am

11162 worked for Bank of America

TY May 26, 2021 at 6:14 pm

Thank you, thank you, thank you!!!! I can confirm 11162 still works for Bank of America

C133 May 26, 2021 at 6:19 pm

You’re welcome, Ty. Thanks for confirming the code for BoA.

Mark June 27, 2021 at 3:25 pm

Brian Rainey

Just used it for the first time with 2020 version. Use code 11162 for Bank of America

Oren November 6, 2021 at 1:06 am

Also grateful for this workaround! Hitting same snag as another user whereby QB will accept the new file but won’t allow me to associate it with my pre-existing account, since I used to use a different method to import files. C133, you responded:
“It could be that some of the data in the QFX file has changed, so QB doesn’t recognize as the one that is associated with your current account and needs you to choose a new one. You can’t choose the existing one because it is already linked to an account. You could try unlinking it and then reattempt the file import.”

How do I “unlink” the account so that QB doesn’t think it’s associated with any previous imports?

Oren November 6, 2021 at 3:51 am

@C133 – you can disregard previous post/question. I was able to figure out how to match the BankID numbers to get QB to recognize the file and match it up! Thanks for this great resource.

C133 November 11, 2021 at 3:21 pm

@Oren, glad you were able to sort it out. To clarify about unlinking: if there is an issue associating accounts that have already been set up with online bank, disconnecting online banking often solves the problem. Exact steps to disconnect are listed at https://quickbooks.intuit.com/learn-support/en-us/chart-of-accounts/disconnect-or-delete-an-account-from-the-downloaded-transactions/00/185413.

piyush modi November 13, 2021 at 11:47 pm

You guys rock!!! I use QuickBooks 2020 and have a Bank of America credit card. First, I downloaded web connect for Quicken 2018 and above file. Second, opened the file using Notepad and replaced the code with 11162 (works for Bank of America). Third, save the file with QBO extension. Forth, double-click on the file and it opened with a QuickBooks file.

Thank you for the help

Paul December 9, 2021 at 6:14 am

Anyone know if the specific code needs to match the specific bank?
Also, does it matter if the account is a bank account or a credit card account?
My bank is US Bank if there is a specific code for that bank.

Paul December 9, 2021 at 6:53 am

Just FYI – I used the 2430 code only in the spot and it worked for my US Bank credit Card account! I just clicked on the altered qfx file saved as a .QBO with QB desktop Mac 2020 and it opened and tried to get me to log in to activate WebConnect, which I declined, but then it asked me to associate an account and I did that and voilà, it was all there!

Paul December 9, 2021 at 6:55 am

The spot in the above post got stripped out, perhaps because of the brackets? THe “spot” is INTU.BID

Sandy March 22, 2022 at 9:42 pm

It took me several tries because the number kept changing for some reason, but 2430 finally worked for Fifth Third Bank. I’m shocked and very grateful.

Hugh Heinsohn July 20, 2022 at 6:13 pm

This worked beautifully! We got an Alaska Airlines VISA issued by bank of America (BofA). BofA does not provide the option to download QBO files.

1. I downloaded the QFX file from BoF and opened it in Notepad++
2. Updated the code to 11162
3. Renamed the file to use a QBO extension.
4. Imported it into Quickbooks Desktop Pro Plus.

Penelope August 31, 2022 at 6:44 pm

Wow, Thank you Hugh! That worked

Cathy Osborn December 21, 2023 at 8:13 pm

Am trying to convert some QFX downloads from Key Bank to QBO for QB Desktop.
Any bank code for that?

EJ April 6, 2024 at 8:49 pm

Thanks so much Hugh!! I had the exact issue as you and you made my life so easy by including such details in your comment!! It worked for me for the BoA Alaska card!!!

Recent Posts

Newsletter

QuickBooks