Spending Money in Foreign Currency and showing in Budget

Les Member Posts: 34
I am going to Canada for holidays and have a Pre-Paid Canadian Dollar Card. I have set it up in Reckon and transferred the funds without any problems. I have made a payment from the card and loaded that using the foreign amount with out any problems. The issue is when I view the list of expenses it lists it in AUD but at a incorrect amount. The payment was CAD7.00 and based on the conversion rate of approx 86.7 instead of the rate of 95.05. Is there anywhere that I need to set the rate, etc?


  • Les
    Les Member Posts: 34
    edited April 2020
    Diver Dan, I set up a CAD account. I have changed the exchange rate via Crtl+Q but as you point out it is at a set rate and I did not want to have to change every day. My thoughts are to use the rate that was used when I converted the currency until I use up all that amount. After that change the rate to the rate when I load more money and so on. I will probably only load 3 or 4 amounts so should be OK with that.
  • John G
    John G Reckon Staff Posts: 1,570 Reckon Staff
    edited March 2018
    Hello Les,

    The list of expenses on a foreign currency account will be listed in AUD equivalent using the exchange rate in the currency list on the day you create the report.  This rate will change wherever the currency list is updated either through running the One Step Update or you changing it manually.

    Remember, your "real" exchange rate is the rate at which your funds were converted from AUD to CAD.

    In the example below, the AUD value of my C$10,000 Travel Card is one value in my **** Savings account from which the funds came for the Travel Card (the actual exchange rate used for the conversion), and a different amount for the Opening Balance of the CAD Travel Card (listed at today's Exchange Rate 1.00809).


    Hope this explains the situation with reporting foreign currency values.