Bug: mixing BRL with GBP in Summary total

Alan Silva's Avatar

Alan Silva

24 Oct, 2019 09:15 PM

I have a Brazilian account, all in Real currency (R$) (BRL). In Summary page when showing the total, it prints 4 million... pounds! I wish it was true, though I'm not even near to that in BRL.

Please see the pic attached.

  1. 1 Posted by derekkent23 on 25 Oct, 2019 06:56 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    What version and build of Moneydance are you running,e.g. 209.4(1892)?
    Is the exchange rate pounds/Real history correct under TOOLS - CURRENCIES - double click Brazilian Real?

    Hope this helps

  2. 2 Posted by Alan on 25 Oct, 2019 08:34 AM

    Alan's Avatar

    Thanks derekkent23,

    My version is 2019.3 (1880) and checking for updates it says it's the
    latest version.

    Brazilian history is indeed a mess. I deleted the history and now at least
    the values are correct, yet I see £ rather than R$.

    Best wishes,

    Alan

  3. 3 Posted by derekkent23 on 25 Oct, 2019 08:53 AM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi Alan

    When you have your base currency in say British Pounds and Accounts in a foreign currency in your case Brazilian Real then the account totals will be R$, but the sum of the totals in blue will be converted in to the base currency £ using the current exchange rate stored in TOOLS - CURRENCIES - double click Brazilian Real.

    It’s important to have a exchange rate history so that the exchange rate is correct and Moneydance has them available for reports, side bar and the summary page etc.
    Are you using the Quote and Exchange Rate updater extension to update exchange rates?

    Hope this helps.

  4. 4 Posted by Alan on 25 Oct, 2019 09:14 AM

    Alan's Avatar

    I got it "sorted out" by using BRL as base currency and ticking the option
    to update my currencies. However, for me it's still a bug because I think
    in GBP, not in BRL, regarding currency conversion.

    Thanks again!

    Alan

  5. 5 Posted by derekkent23 on 25 Oct, 2019 01:54 PM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi Alan

    Its my understanding the intension is if you have accounts in a foreign currency then these accounts are reported in that currency. However most total of account types on the summary page or in reports are converted to the base currency using the relevant exchange rate. Dated reports use the exchange rate for the report date, if it exists or if it doesn’t then the next earlier exchange rate, that why its good idea to update the exchange rate every day.

    Hope this helps.

  6. 6 Posted by Alan on 26 Oct, 2019 08:42 PM

    Alan's Avatar

    Thanks again Derek,

    In hindsight, I agree, it makes sense to have this option. But, I wish it
    to be a option.

    Best,

    Alan

  7. System closed this discussion on 25 Jan, 2020 08:50 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac