Home → Problems →

Bug: mixing BRL with GBP in Summary total

• Edit

Alan Silva

Oct 24, 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.

• Screenshot_2019-10-24_23.03.01.png 34.6 KB

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

   

   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

   • Edit

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

   

   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

   • Edit

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

   

   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.

   • Edit

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

   

   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

   • Edit

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

   

   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.

   • Edit

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

   

   Thanks again Derek,

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

   Best,

   Alan

   • Edit

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