[moneydance] FX Rates

[Steve Nunez]

Thanks. I'll try to export and viewing the data, and see if that helps.

Actually, I was only able to do the import by following the directions for
Quicken and recreating the accounts with the same names within MoneyDance.

The problem is that all of those transfers between accounts have incorrect
values. What I did was manually go and correct them, account by account.

However, what I found was that after I correct the last account, the value
in the other account had been changed as well! I was going 'round & 'round
in circles.

I think this is because of the exchange rate -- it appears that if it's a
currency change as well (when transferring between accounts), then it
automatically takes today's rates and applies it to the amounts -- forcing
them to 'balance'. 

If this theory is correct, then I'll never be able to balance the books
short of computing the rate manually and entering this before each change.

Does this make sense? Any suggestion?

    - Steve

On 20/7/06 7:45 AM, "Sean Reilly" <sreilly at seanreilly.com> wrote:

> 
> 
> On Jul 15, 2006, at 11:52 PM, Steve Nunez wrote:
>> Does anyone know how to turn off automatic exchange rate conversions?
>> 
>> I'm trying to import several years worth of Quicken data, and all
>> of the
>> transfers between account of different currencies have incorrect
>> amounts.
>> 
>> When I go and correct the value in one account, it updates the
>> amount in the
>> other one! Normally, this might be a good thing, but it means that
>> I can't
>> get the books to match initially, since the exchange rates have
>> changed
>> quite a bit over the last 5 years.
> 
> Hi Steve,
> 
> I just responded to your question on the other thread, but wanted to
> add a bit here.  It sounds like your accounts have both been assigned
> to the same currency in Moneydance.  If your data has been imported
> correctly with the exception of international transfers the best
> option might be to simply change the currency that is assigned to
> each account to the correct currency.  Since this is not possible to
> do via the GUI (too dangerous) you will have to do the following:
> 
> 1) Export your data to a Moneydance/XML file.  Select the File-
>> Export menu, then choose the XML format.
> 2) Open the exported file in a text editor.  In that file:
>    a) Find the <CURRENCY> section that contains the currency you want
> to assign to an account
>    b) Note the value of the <CURRID> tag in that section
>    c) Find the <ACCOUNT> section that contains the account to change
>    d) Replace the value in the first (and probably only) <CURRID> tag
> within that section to the value obtained from step B
> 3) Save the XML file, then select the File->Open menu in Moneydance
> to open the edited XML file
> 
> Repeat steps A through D for each currency that needs adjustment.
> Note that this will not work if any accounts are changed to a
> currency that uses a different number of decimal places.
> 
> QIF is nice, but a bit too simple in cases like this.
> 
> Thanks,
> Sean
> _______________________________________________
> moneydance-info mailing list
> moneydance-info at moneydance.com
> http://moneydance.com/mailman/listinfo/moneydance-info