[moneydance] FX Rates

[Sean Reilly]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2560 bytes
Desc: not available
Url : http://moneydance.com/pipermail/moneydance-info/attachments/20060719/d3ccbcb0/smime.bin