Home Quicken for Windows All Things Canadian (Windows)

Quicken Canada R4.4 / Home Trust Visa Card Transaction Download Update

Tour GuideTour Guide Member ✭✭
edited December 2018 in All Things Canadian (Windows)
Be advised that when a payment  is initiated through quicken you will experience a foreign currency transfer window, this is due to the USA company (EZCARD) that handles Home Trust Visa. The coding for this issue is in their transaction downloads and will not be changed. The quick fix is to accept the currency exchange at 1.0. Home Trust visa works great in the USA and has no transaction fee's.  

Comments

  • Arctic Hare (H&B 2019 Canadian)Arctic Hare (H&B 2019 Canadian) SuperUser ✭✭✭
    edited December 2018
    @Tour Guide:

    What do you mean when you say "when a payment  is initiated through quicken"?

    The only time that one would see a foreign currency exchange rate dialogue box is when transferring between accounts with different F/X settings... and, then, you wouldn't expect to use an F/X rate of 1.0... unless the two currencies were pegged to one another at unity... and I assume you are dealing in USD and CAD, which are clearly not pegged at unity.

    Unless/until you can further substantiate your position, I think it is based on a misunderstanding. It sounds like you have your currency setting set incorrectly in Quicken.

    You can have CAD and USD denominated credit cards in Q and the only time one would/should see the F/X rate is when transferring between a CAD and USD denominated account or vice versa.

    I have a number of CAD and a number of USD accounts. I download transactions for both. The only time I see the F/X conversion dialogue is when I should see it... when transferring between accounts... and then the F/X rate isn't 1.0.
  • Tour GuideTour Guide Member ✭✭
    edited April 2018
    Hello Arctic Hare,  you helped me solve this issue as to the coding, this issue is when I'm using quicken to make a payment from my visa account to chequing, the foreign currency window pops up and shows the exchange rate to make the payment to my chequing from my visa. the only currency I use is in CDN in my accounts.  The download from "EZCARD"  which is a USA company is in fact <cur def usa> that changes it to cdn in the download to my quicken that receives it, even if the transaction was made in canada when I download the transaction it still utilizes the <cur def usa> and then to cdn,  so when I go to pay my visa account through my chequing account the foreign transfer window shows. I can't think of any thing else that would cause this. I received and email from another quicken customer experiencing the same issue. I have talked to Home Trust IT department and they informed me that  EZCARD company coding is the issue and that will not change as of now, as stated in the past, Account Details currency selection is ghosted in USA currency and cannot be switched to CDN this is due to downloads from EZCARD .  This is the best explaination I can offer.
  • Arctic Hare (H&B 2019 Canadian)Arctic Hare (H&B 2019 Canadian) SuperUser ✭✭✭
    edited December 2018
    The correct explanation is that Home Trust has the currency definition set incorrectly in their OFX server configuration. If I were you, and they refused to fix such a blatant problem I would switch financial institutions. There are plenty of gret credit card options that work properly. The issue has absolutely nothing to do with whether the FI is owned by a foreign national.
  • Tour GuideTour Guide Member ✭✭
    edited December 2018
    Appreciate your solution and I will contact Home Trust and advise them with regards to their QFX server config.
  • Arctic Hare (H&B 2019 Canadian)Arctic Hare (H&B 2019 Canadian) SuperUser ✭✭✭
    edited May 28

    Appreciate your solution and I will contact Home Trust and advise them with regards to their QFX server config.

    @Tour Guide: I might be able to get this issue routed to Quicken's Online Banking team, who can work with Home Trust to get it resolved. Before I attempt that, could you please confirm:
    1. You can see the USD currency definition in the QFX file.
    2. You are using on of these credit cards: http://www.hometrust.ca/visacards.aspx
    3. Your credit card transactions are denominated in CAD, e.g. on your paper or electronic statement;
    4. If you right click on the the name of your credit card in Quicken and the Edit Details, you see the USD currency set in the currency box (and it is greyed out).
    5. When you look at the list of Quicken accounts on the left side of your Quicken program, there is a "USD" indicated after the credit card account.
    6. Also, please indicate exactly what is listed in the "Financial" box of the General tab of the Edit Account Details dialogue
  • Tour GuideTour Guide Member ✭✭
    edited December 2018
    Thanks Arctic Hare for the help, I answered in sequence as follows:

    1. Here is the actual coding from Ezcard QFX transaction

    image

    2. I am using the Home Trust Preferred Visa card as per your link

    3.  There is no designation on the charges or statement to refer to USD, it is all CDN as per this statement 

    image

    4. Account Details :

    image

    5. There is no USD indicated in any of the Quicken Account List on left side after credit card account.

    6.  Refer to #4.

    This is everything I have with regards to this account. I'll try Home Trust again but they explained that it is a Ezcard transaction issue from the USA. I called Ezcard and they told me it's a Quicken problem and the circle is complete. Thanks for your guidance in this issue.
  • Arctic Hare (H&B 2019 Canadian)Arctic Hare (H&B 2019 Canadian) SuperUser ✭✭✭
    edited May 28

    Thanks Arctic Hare for the help, I answered in sequence as follows:

    1. Here is the actual coding from Ezcard QFX transaction

    image

    2. I am using the Home Trust Preferred Visa card as per your link

    3.  There is no designation on the charges or statement to refer to USD, it is all CDN as per this statement 

    image

    4. Account Details :

    image

    5. There is no USD indicated in any of the Quicken Account List on left side after credit card account.

    6.  Refer to #4.

    This is everything I have with regards to this account. I'll try Home Trust again but they explained that it is a Ezcard transaction issue from the USA. I called Ezcard and they told me it's a Quicken problem and the circle is complete. Thanks for your guidance in this issue.

    @Tour Guide: Thanks for all the additional information you provided. Everything was as expected (indicative of a problem with Home Trust), except for your answer to Question #5. Because the currency is set to USD, you would normally see a US in front of the account balances like shown below. Notice how the USD accounts have a US$ and the CAD account have only $.
     
  • Tour GuideTour Guide Member ✭✭
    edited December 2018
    I realize what your saying now about the accounts list, all my CDN accounts have a C$ in front of the amount in each account .. ie C$200.00. The USD ones only have a $ sign in front of the amount..ie. $200.00.. This seems to be opposite of what your saying???  I have Quicken Starter Edition Canada 2018, R4.4, Build 27.1.4.4    
  • Arctic Hare (H&B 2019 Canadian)Arctic Hare (H&B 2019 Canadian) SuperUser ✭✭✭
    edited May 28

    I realize what your saying now about the accounts list, all my CDN accounts have a C$ in front of the amount in each account .. ie C$200.00. The USD ones only have a $ sign in front of the amount..ie. $200.00.. This seems to be opposite of what your saying???  I have Quicken Starter Edition Canada 2018, R4.4, Build 27.1.4.4    

    OK. Evidently, Quicken implemented that feature differently in Starter editions than they did in Home & Business (which I run). Nonetheless, it is still differentiating between CAD and USD in some fashion. I've reached out to one of the Quicken moderators requesting that this issue be escalated to Quicken's online banking team. It is now with the Moderator, who might reach out to you at the email address you used to register with GetSatisfaction.

    Please post an update if you get this resolved with HomeTrust.
  • Tour GuideTour Guide Member ✭✭
    edited April 2018
    Will Do and Thanks for all the assistance. 
  • Quicken KathrynQuicken Kathryn Administrator admin
    edited May 28

    Will Do and Thanks for all the assistance. 

    Hi Tour Guide,
    Thanks for reporting this!  We're escalating this to our team for review--however, we do need some more information (log files) to complete the escalation.

    If you go to Help > Report a problem in your Quicken program, you can send your OFX and Connlogs through our reporting system; just uncheck the other file options, and add "Community Escalation" to the subject of your submission.  We can then send this info to our team.

    Please reply here if you have any trouble!

    Thanks,
    Quicken Kathryn
    Quicken Kathryn
    Community Administrator
  • Tour GuideTour Guide Member ✭✭
    edited April 2018
    Kathryn ... Thank you for your response and assistance, quick question.. when I look at the OFX file in the "Help" it shows all my accounts, or do you just need the ofx file of Home Trust Visa that is the problem account?
  • Quicken KathrynQuicken Kathryn Administrator admin
    edited May 28

    Kathryn ... Thank you for your response and assistance, quick question.. when I look at the OFX file in the "Help" it shows all my accounts, or do you just need the ofx file of Home Trust Visa that is the problem account?

    Hi Tour Guide,
    It's preferable to have the full OFX log, so we can get a full picture of what's happening--

    Thanks,
    Quicken Kathryn
    Quicken Kathryn
    Community Administrator
  • Tour GuideTour Guide Member ✭✭
    edited April 2018
    Ok Thanks Kathryn, Have just sent the data and also here is a screenshot of today's  account when I paid my CDN visa using my CDN Chequing account.  Cheers, Duane

    image
  • Quicken KathrynQuicken Kathryn Administrator admin
    edited May 28

    Ok Thanks Kathryn, Have just sent the data and also here is a screenshot of today's  account when I paid my CDN visa using my CDN Chequing account.  Cheers, Duane

    image

    Thanks, Tour Guide!  I'll complete the escalation and see what our online banking team says--

    Quicken Kathryn
    Quicken Kathryn
    Community Administrator
  • Tour GuideTour Guide Member ✭✭
    edited April 2018
    Appreciate our effort.
  • Unknown Member
    edited April 2018
    I managed to fix the problem in the following manner:
    1.  Ensure that the Quicken account is in Canadian dollars.  If it isn't, create a new account.
    2.  Download a qfx file and with a text editor change the "USD" designation to "CAD" located at <CURDEF>USD</CURDEF>
    3.  Open the modified qfx file with Quicken.  Quicken will allow you to link it to the account in step 1.
    4.  The USD designation in all subsequent qfx files from Home Trust will be ignored by Quicken and the file will correctly load into the account set up in step 2.
  • Tour GuideTour Guide Member ✭✭
    edited April 2018
    Thanks meame1, I completed the segment and it stays in CDN funds, I have to wait until I get a new transaction to download to confirm but it looks good. Appreciate you help.
  • Arctic Hare (H&B 2019 Canadian)Arctic Hare (H&B 2019 Canadian) SuperUser ✭✭✭
    edited December 2018
    @rneame1: Thanks for posting that info. I was well aware of the ability to edit the QFX and I was well aware that the QXF sets the currency on first download, but I wasn't certain whether the QFX could override a currency setting on subsequent downloads. I had never got around to testing that, partly because I use EWC instead of WC.

    I've run into a similar issue, which I have reported to Q as a bug. If you are setting up accounts for download using EWC in a new file and one of those accounts is CAD, but has no transactions in the history (e.g. last 90 days), it will default to USD. So, when setting up CAD accounts for EWC, it is critical that they are already locked to CAD (having even one transaction in the account locks the currency) OR you must ensure that the first EWC/OSU finds at least one transaction in the history or the CAD account will get set to USD.
  • Tour GuideTour Guide Member ✭✭
    edited December 2018
    Just downloaded a new transaction into the Home Trust Visa account and it reverted back to USD for the account. I then downloaded it again and changed the <curdef> to CDN and the account switched back to CDN. It appears that every QFX download has to be opened and the <curdef> changed from USD to CDN or it will revert back to the USD in the account details. This clearly show that the issue is from Home Trust QFX generated file, as far as I can tell.
  • Arctic Hare (H&B 2019 Canadian)Arctic Hare (H&B 2019 Canadian) SuperUser ✭✭✭
    edited May 28

    Just downloaded a new transaction into the Home Trust Visa account and it reverted back to USD for the account. I then downloaded it again and changed the <curdef> to CDN and the account switched back to CDN. It appears that every QFX download has to be opened and the <curdef> changed from USD to CDN or it will revert back to the USD in the account details. This clearly show that the issue is from Home Trust QFX generated file, as far as I can tell.

    @Tour Guide: that makes more sense to me and matches behaviour that I thought I had observed in the past. Until meame1 indicated otherwise, I had understood that the CURDEF in the QFX would always override the currency setting on the Quicken account even if the currency definition were greyed out. That is why I didn't suggest what meame1 one suggested as a solution. I would have suggested it if I thought it was a one time edit. I didn't suggest it because I thought you'd have to edit the CURDEF in every QFX you upload.

    BTW, the QFX format is a Quicken variant of an industry standard OFX file. One thing that is NOT in doubt or question here is that the problem is caused by Home Trust, which is providing QFX files that contain incorrect information.
  • Tour GuideTour Guide Member ✭✭
    edited April 2018
    Thanks Arctic Hare for your input, I have sent this information to Community Escalation team for their info and they may approach Home Trust for a fix. I have talked to Home Trust multiple times and their "IT" personnel are looking at it. Now that I know how to fix it it won't be a major problem just a quirk. Appreciate your guidance and excellent help in this matter.
  • Unknown Member
    edited May 28

    Just downloaded a new transaction into the Home Trust Visa account and it reverted back to USD for the account. I then downloaded it again and changed the <curdef> to CDN and the account switched back to CDN. It appears that every QFX download has to be opened and the <curdef> changed from USD to CDN or it will revert back to the USD in the account details. This clearly show that the issue is from Home Trust QFX generated file, as far as I can tell.

    Yeah.  Sorry about the previous misleading info.  So that I don't have to edit the QFX file every time, I downloaded a single record from Home Trust, edited it to show CAD and saved it onto a spot near my Quicken file.  I can "import" that file into Quicken anytime I need to change the Quicken parameter back to CAD.
This discussion has been closed.