Adding QFX files w Multi Currency Quicken

Badger51

I am attempting to combine my USD accounts with my CAD accounts in Quicken. I've successfully added some CAD accounts to my existing Quicken setup.

When my CAD accounts were added, they only added today's transactions. I would like to go back to 1/1/2023 for continuity. I downloaded transactions in qfx format.

However, when I attempt to import the file into my CAD chequing account, it gives an error "Downloaded data oes not match the currency of your Quicken account".

Any ideas?

Chris_QPW

Are you using Quicken windows Canadian?

The Canadian version allows for importing from different currencies but the US version does not

Badger51

I am using the US version....noticed your remarks about the US version after I posted my question.

I see there is an option to import the MS Money file...is there a similar US only restriction?

Badger51

Never mind, you have to have MS Money installed to import a file in MS money format.

Not that it makes any sense !

Chris_QPW

The way the MS Money converter works is by calling MS Money through an API to send it the data. Sort of like programs can call Excel/Outlook to do things.

Badger51

My subscription expires in June, I will convert to the Canadian version and hope it addresses my needs.

Chris_QPW

When I read this again, I wasn't sure if you were able to do the MS Money conversion or not.

If you were attempting to do that and couldn't here is some information on that.

https://www.quicken.com/support/how-do-i-importconvert-my-microsoft-money-work-quicken-windows

You will need the Sunset version of MS Money installed. You can find that here:

https://tinyurl.com/mrya8xus

Badger51

I wasn't able to do the MS Money conversion since I don't have a current MS Money app installed...But I will take advantage of your offer and install MS Money and give it a whirl.

Badger51

Worked like a charm, thanks for your assistance.

Would you recommend switching to a Canadian Quicken product, or staying with the US version now that I can download past history.

Chris_QPW

Depending on how you use Quicken there are definite advantages/disadvantages between using the US or the Canadian version. The Canadian version has better multiple currency support, but unlike Quicken Mac, Quicken Windows US pretty much only supports US financial institutions, and the the Canadian version only supports Canadian financial institutions. What’s more a lot of the online features are US only, like the Lifetime Planner, Direct Connect (very few Canadian financial institutions even support Express Web Connect), Zillow, Credit Score, …

Also there are some quirks on the Canadian version like you can’t change the Home currency like you can on the US version (If you switch make sure you set this to what you want in your data file before switching.

I think the main driver would be where you have the most financial institutions if you have them in both countries.

Badger51

Hmm..Most of my income originates in the US. Some of it gets deposited automatically in Canadian Banks, others I have to transfer up.

Perhaps, since I assume that once a CAD account is created in the US quicken version I can continue to download updated transactions, the better choice would be to remain with the US Q version.

Chris_QPW

Quicken Windows US will not import any data with a non-USD currency. Those transactions will have to be entered manually. The way it sits right now there isn't any good answer for you. If you go with the US version, the CAD accounts are manual entry only. If you go with the Canadian version, then it won't know about the US financial institutions, and they will be manual entry only.

The in between possibility is importing using the QIF format because it knows nothing about currency and as such there are just numbers in the QIF file, and it is the account that determines the currency. But QIF files have some really big restrictions in Quicken Windows Subscription. Here is more information on that:

https://www.quicknperlwiz.com/importprocessing.html

It is one reason why people might choose to use my program (ImportQIF) to help with all the problems, but note it can't help with the fact that Quicken Windows Subscription will not match existing transactions during a QIF import. ImportQIF is free.

Badger51

I appreciate all the information you have provided. If I can ask one more question, are you familiar with MoneyDance? I'm experimenting with a trial version. It appears to download, either manually, or automatically with a +membership, from both US and Canadian banks.

Interface is a bit less polished, but I can get used to that !!

Chris_QPW

No, I haven't used it, but given the current state of Quicken Windows that might be your best bet. Note that Quicken Mac actually can download from both US and Canadian, so the limitation is purely in the Quicken Windows code.