tag:infinitekind.tenderapp.com,2009-01-14:/discussions/general-questions/115081-foreign-currenciesInfinite Kind: Discussion 2022-02-14T02:30:20Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/494175312021-10-03T23:12:23Z2021-10-03T23:12:24ZForeign Currencies<div><p>I have multiple accounts in my Moneydance file and one of them is in Mexican Pesos. The others are in pounds sterling. On the summary page it adds the Mexican Peso balance to the Pounds Sterling balance which gives a meaningless total. I want to be able to enter transactions in Mexican Pesos and for Moneydance to calculate the running balance in Pounds Sterling using the current exchange rate. Is this possible to be and if so could somebody please help me?</p></div>jeremy.stoyletag:infinitekind.tenderapp.com,2009-01-14:Comment/494175312021-10-03T23:32:49Z2021-10-03T23:32:49ZForeign Currencies<div><p>Hello,</p>
<p>When you write that "it adds the Mexican Peso balance to the Pounds Sterling balance which gives a meaningless total," do you mean it is just adding up the numbers themselves, and not giving you a total based on the current conversion rate? It sort of sounds like the program is treating those currencies as if they have a 1:1 conversion ratio? If so, I wonder if you have the Quotes and Exchange Rates extension installed and running? You can add this in Extensions -> Manage Extensions from the menu bar.</p>
<p>If that's not what you mean, could you try explaining what you are seeing in more detail, or perhaps attach a screenshot? If you're not sure how to take a screenshot, please see <a href="http://www.take-a-screenshot.org/">http://www.take-a-screenshot.org/</a></p>
<p>Ethan<br>
Infinite Kind Support</p></div>Ethantag:infinitekind.tenderapp.com,2009-01-14:Comment/494175312021-10-04T07:29:53Z2021-10-04T07:29:53ZForeign Currencies<div><p>I am not support staff, just a user.<br>
Hi Jeremy</p>
<p>The attached PDF is my understanding how Moneydance handle foreign currency transactions.</p>
<p>Hope it helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/494175312021-10-12T20:01:07Z2021-10-12T20:01:07ZForeign Currencies<div><p>The system NEEDS to work like this.</p>
<p>I enter the amount in the foreign currency (yellow), I select if it's going EUR to USD or whatever (green), and have it calculate the base currency and adjust the ledger by THIS amount (red).</p>
<p>IF the MoneyDance requires us to have the base currency in the (yellow) payment/deposit area, then MoneyDance MUST let us choose which direction the conversion it in the (green area), and let us put the foreign currency in the (red) area and it calculate the value of the (yellow) area for us. Making us start a transaction, then switch to the category ledger, and input everything, is not acceptable behavior.</p>
<p>I spent WAY too long figuring out that work around, when other financial software does it the way I described. Unfortunately that other software runs on the virus called Windows and I don't want that virus on my system.</p></div>eric.v.mazzonetag:infinitekind.tenderapp.com,2009-01-14:Comment/494175312021-11-15T02:24:28Z2021-11-15T02:24:28ZForeign Currencies<div><p>Hello Eric,</p>
<p>Many thanks for your reply and apologies for my late response.</p>
<p>Your explanation makes sense and when I try it, it works!</p>
<p>Now I have problem that the net worth graph of the account I have in a foreign currency has some massive spikes in it which I can’t seem to get rid of no matter what I do. I have just posted a question / report about it on infinitekind.tenderapp.com <a href="http://infinitekind.tenderapp.com/">http://infinitekind.tenderapp.com/</a>.</p>
<p>Best regards,</p>
<p>Jeremy</p></div>jeremy.stoyle