Hacking Quicken to import OFX transaction exports in foreign currencies

July 24th, 2010 · 57 Comments

So, earlier this year my wife and I relocated to the UK for a period of time due to work reasons. As part of the move, we’d opened up a checking account at HSBC but had been unable to import transactions into Quicken because the bank only allows downloads in QIF, OFX, and CSV formats rather than the “WebConnect” Quicken wants to import.

ASIDE: Intuit are out to screw you, the user of Quicken, by not using the open industry format OFX.

WebConnect is Intuit’s special format that requires Quicken to validate an embedded bank code value before it will let the import succeed. This code value is something that Intuit sells to each bank, at an apparently not cheap price, or else more bank’s would have it. Although, I suspect another very real cost is that of supporting this special, proprietary format – coding, testing, maintenance, etc.

However, we can hack around the proprietary nature of WebConnect as it turns out this format is really OFX with one special (badly formatted) tag added. And in fact, you can download an OFX file, edit it manually, then import it into Quicken. You can even do this for a UK bank export into a USA install of Quicken! Here are the steps I took to do just that:

  1. Visit the bank website and export your transactions in OFX format.
  2. Edit the file in a text editor. I used Notepad++ on a Win7 box.
  3. Search for the string “</SONRS>” in the file. This may be in the middle of a line or on its own line, depending on the bank export. Either way, it should have come immediately after a “</LANGUAGE>” string (or the previous line should end with that.)
  4. Before the “</SONRS>”, insert a new line or phrase that is “<INTU.BID>” followed by any valid bank code. You can find these on your machine in (for Quicken 2010 running on Windows XP) “C:\Documents and Settings\All Users\Application Data\Intuit\Quicken\Inet\Common\Localweb\Banklist\fidir.zip” which contains a file called fidir.txt. Open that and look for a bank code you’d like to use. If you have a different version of Windows or Quicken, the file location will need to be adjusted. Earlier versions of Quicken didn’t zip up the fidir.txt file so you may not have to unzip anything in that case.


    Note for those familiar with XML file formats: This is a purposely malformed XML tag with no closing!  Do not insert a  matching </INTU.BID> at the end!

    In my particular case, for using the HSBC US bank account code, my edited file looked like:

    . . . </LANGUAGE>
    . . .

    Don’t forget to save the edited file. But save it with the file extension “.qfx” instead of “.ofx”!

  5. There is one other catch, if you try importing this into a USD (US dollar) install of Quicken, you’ll get an error like:

    Downloaded data does not match the currency of your Quicken account

    This is because your exported data includes a tag indicating it is for a foreign currency, in my case for HSBC UK that would be GB Pounds (Sterling). This is specified just a few lines further down in the .qfx file with something like:


    Simply change that to the standard currency symbol for US Dollars, USD, and your file will import without error. Here’s an example of the line edited:


    Do not worry if the account you’re trying to import into in Quicken is setup for Pounds, Quicken’s check is only to match the default install currency, not the per account currency!

    NOTE: Quicken will NOT convert amounts from USD to GBP on import either!

  6. As a last step, import this into Quicken. Navigate the application menu: File–>File Import–>Web Connect File and in the resulting dialog select your edited .qfx file. Quicken will pop-up a dialog to ask you which account to match to, after which it will show a few more to indicate progress as the import is done.

    Finally, it may also ask you if you want to turn on “One Step Update” for this account. Do NOT do this as your account does not really come from the bank Quicken thinks it does, so it won’t be able to automatically download new transactions for you. You’ll need to download them manually each time.

Tags: Personal Finance

57 responses so far ↓

  1. 1 Nepa // 2010.07.27 at 10:07 am

    To convert CSV and QIF to regular OFX try iCreateOFX Basic from http://icreateofx.com/Convert-CSV-to-OFX

  2. 2 matsch // 2010.08.19 at 11:42 pm

    It worked just the way you described. I can’t believe how sick I am of Intuit, who would have thought I’d be thinking that MS Money was still available?

  3. 3 Robert // 2010.09.04 at 4:36 pm

    Thanks! I followed the instructions above and it worked great.

  4. 4 Chris // 2010.11.12 at 8:10 pm

    The instructions worked perfectly. Now has anyone done a script so that you can update your file automatically.

    If only Intuit would listen to their Customers.

  5. 5 QuicknPerlWiz // 2011.01.07 at 5:19 am

    I see someone else has figured out what I figured out too, but I thought I would point out something the comment about having a program to do this automatically. The QFX format is copyrighted by Intuit. So even though it is basically just OFX with a sprinkle of financial information thrown in, anyone that creates a program to create a QFX file and then goes out and makes it public, risks Intuit coming down on them.

  6. 6 QuicknPerlWiz // 2011.01.07 at 5:27 am

    P.S. The whole purpose making QFX over using OFX which Intuit, Microsoft and the banking industry created is so that Intuit could charge for the support it needed to provide the financial institutions and of course a money stream, after all Intuit is a business not a charity. People might hate the fact that Intuit created this cost that the financial institutions are now trying to pass on to customers and such, but the fact that Microsoft gave up on MS Money and OFX (which it couldn’t charge for) might be an indication of what was the better approach to running a business providing “personal finance” software.

    Now Intuit dropping out of the UK market altogether is a whole another subject, but I guess they dropped out for the same reason Microsoft dropped out, the cost was greater then the gain for some reason.

  7. 7 Jaco // 2011.01.12 at 1:45 pm

    Hail the writer of this tip! It is thanks to people like you that the world will become a better place to live in! Ok, and Wikipedia too but thats besides the point. Im just thankful Im not the only person living outside of the US, companies like Intuit would have succeeded in letting me feel left out in the dark.

  8. 8 dave // 2011.04.01 at 2:35 am

    I had been looking for such a solution for a long time I live in UK and have always used quicken from 1995, when they decided to pull out of UK I was well disapointed have had to use old versions until now I bought a USA copy of 2010 last year as the quicken web site intimated that it used ofx format which of course was a lie , they are anally retentive at quicken, with just a small software tweak it could work worldwide but no they want their pound of flesh from the banks for their stupid QFX file download, Thankyou so much I am now a very happy guy even though it has to be modded every time very quick and easy to do thanks once again

  9. 10 mak // 2011.07.06 at 6:03 pm

    I followed the steps but quicken say it cannot verify the financial institution and will try again later. error [OL-220-B]

  10. 11 dave // 2011.07.08 at 4:39 am

    hey mak there is something you haven’t done , it does work you need the currency to be USD not GBP

  11. 12 JAW // 2011.07.14 at 5:23 pm

    it seems that I am the only quicken2009 user in Poland, it is obvious that there is no bank linked to quicken in Poland, I used to convert ofx files into qfx manualy, i.e. by adding 3000, converting PLZ into USD, addind bank.id. 00000001. Unfortunately, this method has stoped working. Does anybody know why?

  12. 13 davmp // 2011.07.14 at 8:19 pm

    @JAW, have you tried a different bank id by any chance? Quicken probably has someway to stop a given bank id from working if that banks stops paying them the licensing fee for ‘qfx’ format.

  13. 14 dave // 2011.07.16 at 3:02 am

    I would refer you to sergiy’s input up the page it works a treat and for not a lot opf cash

  14. 15 JAW // 2011.07.16 at 3:52 pm

    dave, I tried sergiy’s trial version without positive results, I will come back to this problem later cause am leaving for holidays, thanks for your and davmp comments. JAW

  15. 16 JAW // 2011.07.27 at 4:02 pm

    guys, I tried to sort out my problem, however without any positive result, now I look for a helpful eye that could look at my example *.qfx file in order to check what is wrong with it despite of adding required elements. i am quicken2009 premiere user, thanks in advance. jaw

  16. 17 dave // 2011.07.30 at 12:38 am

    Hi JAW can you copy and paste the first part of the OFX download file then the error can possibly be spotted it really can only be the bank identifier or the currency setting , the other thing is are you saving the converted file as .QFX?

  17. 18 JAW // 2011.08.02 at 5:23 pm

    Hi Dave, see the latest qfx file requested part below, following my practice, I’ve inserted 3000 line, changed he currencyDEF from PLN into USD, changed bank ID into 00000001. I found such instruction on the net. Should you prefer communication in this respect by e-mail, let me know your e-mail address. I appreciate your help! BR JAW








  18. 19 JAW // 2011.08.02 at 5:30 pm

    upps, the file does not show up correctly, I changed symbol ”
    ?NAME>Zlecenia różne
    ?NAME>Smyk Poznan

  19. 20 JAW // 2011.08.02 at 5:36 pm

    dear readers sorry for the above mess, I replaced symbol ”

  20. 21 JAW // 2011.08.02 at 5:38 pm

    Dave, once again sorry for the above. I cannot display the content of qfx file correctly. May I send you this by e-mail directly. thanks. JAW

  21. 22 dave // 2011.08.02 at 5:58 pm

    Hi JAW The only thing I can see from your download file is it is missing a the other side of the USD, I would also try 01270 as the bank ID . I do know that one works

  22. 23 luca // 2011.12.22 at 1:27 pm

    Hello, i can´t convert this file to QFX









    Trade Date Activity



  23. 24 Frank // 2012.01.06 at 10:51 am

    Here is what my insert looks like “PNC01270″ but it still rejects it with ” Quicken is unable to verify the financial institution information for this download. Please try again later. Did I miss something?

  24. 25 MM // 2012.01.26 at 5:25 pm

    This is what I did to fix the “Quicken is unable to verify the financial institution information for this download. Please try again later.” —
    Change the value for to “000000000” (that’s 9 zeros) in the ofx file, to be saved as qfx ( is found about 10 lines down from where you inserted the bank code.) After making this change, the Quicken import web connect file process immediately opened a window allowing linkage to the correct existing account.

  25. 26 MM // 2012.01.26 at 5:30 pm

    Edit: Missing from my post above are the data field names because the “less than” and “greater than” symbols were stripped — insert the 9 zeros after BANKID which is about 10 lines down from INTU.BID.

  26. 27 FH // 2012.02.24 at 10:19 pm

    I followed the instructions and it worked great. Thank you for posting this.

  27. 28 Andy // 2012.05.06 at 1:53 pm

    Thank you sir!!!! My financial institution just revamped their website and stop offering the option to export as a QFX file (now it’s only csv and ofx).

    As I was researching how to convert from ofx to qfx, I came upon the ugly fact that Intuit was stickin’ it to financial institutions. I had know idea they had to pay Intuit a fee. Many thanks for providing these instructions!!!

  28. 29 JAW // 2012.05.09 at 1:58 pm

    I am here again. Since May, all the above tricks do not work. My Q Premier 2009, when downloading reports “Quicken is unable to verify the financial institution information for this download. Please try again later.” Do someone know what happened?

  29. 30 JAW // 2012.05.09 at 2:53 pm

    HAHAH, I’ve just found this Intuit’s notice. It is ubelivable arrogance. Does anyone know whether it is possible to omit this?


  30. 31 pdquicken // 2012.05.12 at 11:16 am

    I am having the same problem. I saw the notice, but thought it only referred to one step updates performed by quicken automatically. But it now does not allow importing these files when downloaded from each institution’s website. Basically, it makes the software useless and forces you to buy the newer version. This is terrible and I am wondering if I should move to another software, may be a freeware if something is available. Any suggestions?

  31. 32 michelle // 2012.10.11 at 7:54 am

    Hi there – I just moved to the UK and tried this solution to bring my UK bank data to Quicken 2012 R7 with no luck. I assume Intuit closed the loophole and this hack no longer works. Has anyone found an alternative solution? I would just like to have all my financial data in one place without having to type it in by hand. Any alternative software that is any good?

  32. 33 Dieter // 2012.10.23 at 2:18 pm

    Hi gentlemen, I read the above with lots of interests, but unfortunately can’t come to me desired result – importing the OFX file. Reason is that my German Quicken 2011 V. under Win7 SP1 64Bit does not allow me to import any other file than juqst and only a *.dat. And this regardless what category I try:
    adresses, bookings, courses, quicken adresses, QIF Import, DTA Import, StarMoney Import, T-Online Import are the only options suggested when selecting >File >Import/Export >Quicken Import
    Anybody has experienced this situation, please send an email to dhallen@euraf.com.
    Thanks in advance

  33. 34 chobo2 // 2012.12.02 at 12:53 am


    Does anyone know where this path is one windows 7?

    C:\Documents and Settings\All Users\Application Data\Intuit\Quicken\Inet\Common\Localweb\Banklist\fidir.zip

    also does it still exist in quicken 2013?

  34. 35 QuicknPerlWiz // 2012.12.02 at 4:25 am

    First let me start by saying I actually believe in Intuit’s right to get money from financial institutions and disconnected, importing and such. All produces have to be paid for by some means and different streams of money help do that. And I also believe because of the non-standardized state of the financial institutions it costs Intuit a great deal of money money to maintain downloading. Also I believe that Quicken is in fact not a good money maker for Intuit. Microsoft didn’t get out of this market because they were making tons of money.

    With that being said I can feel for the foreign users that have been left without a good program to use. In fact if Intuit ever stops making Quicken the same would be true for the US and Canadian (and maybe the Australian) markets.

    Here are some facts that may help you. Mind you I know about the US Quicken (and a bit about the Canadian, and Australian) versions, not about any other versions of Quicken out there, which for the record were not created by Intuit. Intuit just license the name and I believe the starting code, so for those version there is no telling what they will do.

    As pointed out there are only a few field different in the QFX format, and you can get other financial institution’s information from the fidir.txt file. It is tricky to get working, but it should still work as far as I know.
    But lets talk about another problem and that is currencies. The OFX standard puts the currency into the OFX file.
    Now what does that imply? If you are making a US version of Quicken, and you are only supporting US financial institution you are not going to go out of your way to make sure things like conversion of one currency to another during downloading works, or even if you can download from a foreign currency into an account using that currency.
    And they haven’t. So that is why you might have to deal with problems in the area.

    Now about the QIF format. You can still import into any account you like if you know how to bypass the GUI as shown in this thread: https://qlc.intuit.com/questions/153976-how-to-import-qif-files-into-non-cash-accounts-post-q2004

    Why bring this up? Well QIF is certainly a weaker and I might add unstandardized format, but it does have a few things going for it. One, is that its lack of knowing what the currency is means it just knows 23.03 the $ or whatever currency sign is determined by the account it is imported into. So unless you are expecting a currency conversion in the download it actually works without having to deal with that problem. And of course as it turns out some financial institutions will provide it when they won’t provide OFX. There is a problem that in QIF the date is not standardized and as such any program has to deal with that. And of course the US version is going to expect it in MM/DD/YYYY formation. Interesting enough I believe the Canadian and Australian versions expect it in that format too, but I might be wrong about that. Of course if they don’t then just not touching the date in a QIF file might work if both the financial institution and Quicken agree on it.

    Another thing to point out is about Quicken an foreign characters. Quicken US and I think Canada and Australia are not unicode compatible so they only know about ASCII characters. So that means English with a few extra symbols.

    That is something else that the OFX standard added, but doesn’t mean much if the core of Quicken doesn’t support it.

    Recently in the beta for Quicken 2013 it looked like Intuit was going to leave a bug in that meant that QIF imports wouldn’t work at all. Thankfully they fixed it for R2, but in the process I did look quite a bit into doing conversions into QFX and use it. I was doing that for two reasons. 1) I personally import using QIF from a financial institution that in fact doesn’t support any kind of downloading except CSV/web pages (Lending Club), so I wrote a program to get the data myself and create the right QIF file and import them. But even before that I wrote a program to help people with the manual edit above for making QIF files bypass the GUI restriction and to make it push the right buttons to do the import automatically. That program is called ImportQIF. Anyway when I tried switching to the QFX format I found it was actually much more of a pain to deal with then QIF. In QIF I can import categories and splits, which you can’t do in the OFX standard. And there were a lot of other “gotchas”, so I was very happy that Intuit fixed that bug.

    Now on the QFX/QIF restrictions. In the Canadian version the downloading is restricted to two years I believe AND it includes QIF imports. In the US version QFX imports are restricted to 3 years AND the QIF format is not restricted at all by time. I’m not sure of the policy in the Australian version.

    Any that is a dump of what I know. If you want to check out ImportQIF you can find it on my website.
    The free part will add the account name and type to a QIF file so that it can be imported. The automatic import into Quicken and other format conversions do cost a small amount after the 30 day free trial.

  35. 36 QuicknPerlWiz // 2012.12.02 at 4:28 am

    Hmm. I thought it would post my website since it asked for it, but I guess not.
    Here it is: http://www.quicknperlwiz.com/

  36. 37 Roysten // 2012.12.31 at 11:46 pm

    After reviewing the options available, I am going for the open source package GnuCash which is totally free and is able to support QIF/OFX format freely.

    I have just started to play with GnuCash and it seems that it is also able to support QFX format. So there is a possibility that one might be able to import OFX format and export QFX for use in Quicken if that is what you would like to stick to.

  37. 38 Mark Batten-Carew // 2013.03.13 at 7:39 pm

    Thank-you very much for this post – it gave me exactly the information I needed.

    My problem was very simple. I am a Canadian in Canada using the Canadian version of Quicken Cash Mananger 2011. My sole purpose is to download all my bank and credit card accounts, categorize all my transactions, then print out the result annually to get a single list of all my income and deductions for tax return purposes.

    This has worked fine for many years for all my Canadian bank accounts and credit cards in both CAD and USD, but last year I opened a USD bank account at a US Bank that knows how to download QFX files for Quicken and those files would not import into the Canadian version of Quicken. I presume they import fine into the US version of Quicken, but when I try to import them, the Canadian version of Quicken fails saying “Quicken is currently unable to verify the financial institution information for this download.”.

    In other words, the US bank is not on the list of banks the Canadian version is willing to accept. I called Quicken support and they said the Canadian version could not accept downloads from US banks and there was nothing that could be done about this.

    Following your instructions above, all I did was pick an arbitrary Canadian bank code, and used it to replace the existing bank code, which was on two lines, the FID line and the INTU.BID line, as shown below. (I picked the Canadian bank 00013)

    S1 IBS


    Then I just Imported this QFX file as usual into an existing USD bank account I had already set up in Quicken and it worked perfectly.

    So my process from now on is just download the QFX file, edit the two lines above, and import.

    Thank-you very much for solving this problem for me.
    Mark Batten-Carew

    PS. I gave so much detail so that any other Canadian who ran into the error message above would find this post and know what to do.

  38. 39 Matt Chambers // 2013.03.22 at 3:31 pm

    I generated my OFX from a CSV file via this free tool: http://csvconverter.gginternational.net

    Then I added the tag mentioned here. But then I got a OL-221-B error. I looked in the log file and saw that it complained about a missing LANGUAGE tag, so I made sure the tag was set to ENG and the import started working. Hope this helps someone!

  39. 40 SURAIN // 2013.06.02 at 10:53 am


  40. 41 Kevin Mc // 2013.11.23 at 7:19 pm

    Not working for me – in the US
    I downloaded the OFX file from my credit union and edited as follows and saved as .qfx
    There was no tag – so tried impoting into Quick 2010 with and without

    File => Import=>WebConnectFile
    Quicken immediately attempts to OneStepUpdate to update my bank information
    and then tells me it cannot verify the fincial institution
    and downloads are discontinued for my version.
    I disabled all accounts from OneStepUpdate and the same still happens

    Any ideas?
    I have no problem paying for software that works – but from what people are saying on 2013 and 2014
    who wants to pay for broken features


  41. 42 Kevin Mc // 2013.11.23 at 7:25 pm

    Should have read closely
    I enetered
    “left bracket”LANGUAGE”right bracket” ENG”left bracket” slash LANGUAGE”right bracket”
    “left bracket”INTU.BID”right bracket”1241
    “left bracket” Slash” SONRS”right bracket”

  42. 43 Arthur Ed // 2014.02.17 at 6:10 am

    Long time user of Quicken 2004 in UK and my new bank does not offer QIF downloads but does offer OFX. Used this hack to try import of QFX and worked a treat. Thank goodness for the good people who are willing to share these tips – many thanks.

  43. 44 Dale Jenkins // 2014.03.02 at 7:48 am

    Glad to have found this tip, it works flawlessly after I edit each. QFX download file for my Visa credit card accounts.

    I cannot understand why the folks at Quicken would want to ruin their brand and customer good will by crippling features preventing customers to continue to use their older software versions. It is a shame, some companies unwittingly ruin their brand and reputation by playing games and orphaning customers as a strategy to sell you more, newer versions of software – when the version you have will work just fine from now on. I can see their point to want to continue selling upgrades, but the games that have played with these data files import formats boggles the mind. They have gone to great lengths to cripple their software regarding data importing. Wake up Intuit! Thank you for this valuable tip!

  44. 45 Laurie // 2014.04.09 at 11:35 am

    Hello friends,

    The path for “C:\Documents and Settings\All Users\Application Data\Intuit\Quicken\Inet\Common\Localweb\Banklist\” in Windows 7 (with Quicken 2014) is “C:\ProgramData\Intuit\Quicken\Inet\Common\Localweb\Banklist”.


  45. 46 Patrick // 2014.04.30 at 1:52 pm

    I have attempted this hack a number of times in the past, since it seems to be one of the few that offers a real solution for people who have foreign banks that don’t use the Quicken .qfx format. Unfortunately, I have never been able to get it work. I tweaked different things as different users posted how they worked around it on their computers. Finally today, I decided to download a .qfx from another bank I use, and simply transplant my transaction list from the .ofx file my foreign bank produces to the working .qfx file. I left everything else the same. Wouldn’t you know, it worked like a charm! I got a prompt to link the transactions to an existing file, followed by the option to add in each transaction like I would on a regular update. While your particular workaround didn’t work for me, it definitely helped lead me to the step I took today. Thanks!

  46. 47 Doug // 2014.08.15 at 10:36 pm

    this worked perfectly for me! thank you very much!!

  47. 48 Rob // 2014.08.22 at 7:51 pm

    Hi All
    First, thanks for this site and its information which has proven invaluable.

    One thing I have discovered about trying to load transactions from ABNAMRO,
    though not unique to them (QV), is that, if the MEMO field in the .QFX file is too
    long, Quicken will choke. You will see an ol-220-a error message and,
    if you look at the connection log this message:
    Parse error. Current object: STMTTRN

    Solution simple: trim down the MEMO field.
    I have not had the time or energy to determine just what the maximum length allowed is.
    It may differ between Quicken 2014 and earlier versions.

  48. 49 Adrian // 2016.06.23 at 6:44 am

    This no longer works in Quicken 2016 R7. I have been using this method successfully for years (through Bank2QFX software) to convert the OFX files from Barclaycard in GBP into a QFX file which I import into my GBP credit card account in Quicken. However when trying to import the QFX file into Quicken 2016 R7, Quicken changes the bank currency to USD, which screws up my balances!

    At first when I saw the currency change in Quicken I didn’t know what was going on and thought Quicken had a bug. So I tried to change the currency back to GBP in Quicken- and as far as I can tell this is impossible, thanks Intuit! So I had to create a new GBP credit card account and copy all the transactions across from the old bad one to the new one, which was very time-consuming! And quite tricky to eliminate all the duplicates. Anyway I did this and backed up my QDF file. Then I carried on as normal and noticed that the import of my next QFX file changed the currency back to USD again. Luckily I had a backup now, however I now cannot use the hack nor the Bank2QFX software any longer.

    I’d like to hear if anyone has similar problems and/or a solution.

  49. 50 Thomas // 2016.09.24 at 3:40 pm

    @Adrian, I’m bumping into the same problem. I followed something like the process Dave originally provided to import an OFX file from the Royal Bank of Scotland, with transactions in GBP. It imported fine, but Quicken (2016 RPM R8) is actually changing the account currency! (And yes, I’m pretty sure that is not something a user can undo — we get to do it only when creating the account). Here’s what I did.

    1. I downloaded two accounts’ transactions into a single my-transactions.OFX file

    I then pulled the file into emacs and:
    2. Changed the currency (two entries) from GBP to USD
    3. Changed the INTU.BID from 005050 to 3000 (Wells Fargo)
    4. Renamed my-transactions.OFX to my-transactions.QFX

    In Quicken 2016 (RPM version) I then:
    5. Created two new bank accounts, both in GBP
    6. Ran File->”File Import”->”Web Connect File…” on my-transactions.QFX
    7. Each time (twice) the wizard asked my which account it should drop the transactions into, I pointed it at each of those two new GBP accounts

    Then, to my initial delight, I got a burst of incoming transactions being loaded into the two GBP accounts.
    Then, as I looked, the GBP pound signs changed to USD dollar signs! Quicken had actually converted the account currencies.

    I tried it several times, first deleting the earlier attempts, but it was always the same. (Except…except I could swear the first time I did it, the conversion may not have happened. But I now think I’m imagining things — must be the stress of dealing with such a cynical piece of manipulation on the part of Intuit with this QFX and INTU.BID nonsense).

    I haven’t given up, but I haven’t fixed it yet. This is by far the most annoying purposeful IT-ish thing I’ve come across in a long time. Makes me wonder if I shouldn’t just bite the bullet and move to John Wiegley’s Ledger.

  50. 51 chris // 2016.10.02 at 9:39 am

    Yes Thomas Quicken made a change that messed up the workaround. So far I see no solution…. anyone with any ideas???

    So far the only solution is to uninstall Quicken .. restore your quicken files to from a previous backup .. reinstall Quicken and never update to Quicken 2016 R7.

    If anyone has a solution let us know.


  51. 52 Pete // 2016.11.23 at 4:23 pm

    Workaround: change the conversion rate to 1: CTRL-Q, select US Dollar, Edit, $ per ‘your currency’ set to 1.

    It looks like Quicken stores the values in both registers separately. It doesn’t store a formula. So if you change the exchange rate later, then the values in the two registers stay unchanged.

  52. 53 chris // 2016.11.24 at 4:34 pm

    I have my base rate Cdn $ and have both US$ and Cdn $ accounts. So if I change US rate to 1 then all reports will look at everything as a CDN $. Am I correct.

  53. 54 Pete // 2016.12.29 at 12:19 pm

    Hi, Chris

    Yes, changing the exchange rates will screw up the reports. So… when importing, set the exchange rate to 1, when looking at the reports set the exchange rate to the current rate. I know, it’s a PITA, but it’s better than nothing.

  54. 55 Josia // 2017.01.02 at 2:05 pm

    Hi, I have the same problem – I also tried using Quicken 2017 (will ask for a refund). I’ve tried the support but they do not give support for non-US banks.
    One alternative (not ideal), is to create an Asset Account and import transactions using QIF format – but you will need the download using this format, or a tool to convert from Excel to QIF. This way the currency is preserved.
    You can change “Display Options” for the Asset account to one of the following options: Spending (Checking and Credit Cards), Savings, Investment, or Retirement. -This will group the accounts properly in Quicken.
    Again, this is not ideal.
    This workaround preserves the Foreign Currency for the new account (Asset type) and you can import QIF format file – for now – you never know when Quicken – (new company – NOT Intuit anymore), will eliminate this option.
    I found a new tool for free: https://www.personalcapital.com/financial-software – but I don’t know if I can track manual accounts / foreign currency

  55. 56 Josias // 2017.01.02 at 3:29 pm

    Perhaps a better explanation is found on this Quicken Community answer – The Asset / or Cash Account can be used just as temporary account to import the transactions. Then, you can copy and paste the transactions into your original Bank / Credit Card account as suggested in this article: https://getsatisfaction.com/quickencommunity/topics/foreign-checking-account-currency-corrupted-by-qfx-import-web-connect-file
    I bought many years ago tools from Big Red Consulting, so I am equipped with the tools I need:
    1- OFX / QFX reader for Excel (I used this to read my foreign bank OFX / QFX formats)
    2- Excel to QIF Converter – will use this one again (if your banking provides CSV or Excel you will be good with this tool – but is another charge)
    3- QIF to QFX Converter (I will not need this one anymore)

  56. 57 Bruce // 2017.02.13 at 11:55 am

    Bloody brilliant! worked a treat. Intuit SUCKS with their US centric narrow minded way.

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>

 Subscribe in a reader