Loading Profile...
Best way to convert with pre-euro expenses accounts?
Hello all,
I had just finished importing all my Microsoft Money accounts (yeah!) and reconciling all of them (changed each multi-currency transaction to the correct rate, tedious), when I realised the expenses reported were completely wrong.
I realised that one of the reasons was that quite a few expense categories were in French Franc (FF) a currency unknown to MoneyDance and thus with a weird rate.
Now what I had done in Money at the Euro transition date was that I closed my FF bank account a re-opened a new account in Euro, transfered the money from one to the other and that was it.
Unfortunately with MoneyDance all the expenses categories that had relationship with my FF account are still in FF.
I tried the following:
for reach FF expense category
I created a new expense category in Euro
I selected all the transactions going to the FF expense category, and changed the category to the new Euro denominated one.
Alas, the amount were not changed to euro => 6.5 times the expenxses!
What do you avdise I do?
Will I have to resort to some xml editing?
after that I will still be left with the other issue of the HomePage graph not working properly with multiple currencies (but that will go in another question)
Still keeping double books in Money and MoneyDance for now...
Thanks,
Charles
I had just finished importing all my Microsoft Money accounts (yeah!) and reconciling all of them (changed each multi-currency transaction to the correct rate, tedious), when I realised the expenses reported were completely wrong.
I realised that one of the reasons was that quite a few expense categories were in French Franc (FF) a currency unknown to MoneyDance and thus with a weird rate.
Now what I had done in Money at the Euro transition date was that I closed my FF bank account a re-opened a new account in Euro, transfered the money from one to the other and that was it.
Unfortunately with MoneyDance all the expenses categories that had relationship with my FF account are still in FF.
I tried the following:
for reach FF expense category
I created a new expense category in Euro
I selected all the transactions going to the FF expense category, and changed the category to the new Euro denominated one.
Alas, the amount were not changed to euro => 6.5 times the expenxses!
What do you avdise I do?
Will I have to resort to some xml editing?
after that I will still be left with the other issue of the HomePage graph not working properly with multiple currencies (but that will go in another question)
Still keeping double books in Money and MoneyDance for now...
Thanks,
Charles
I’m frustrated
1
person has this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
Create a customer community for your own organization
Plans starting at $19/month
-
Inappropriate?I tried this, seems to work:
I created a temporary account in euro temp_euro
In my real euro_account with the bad transactions I batch moved all transactions towards a FrencFranc category to the temp_euro account.
I exported to QIF
I erased all transactions from temp_euro
in the QIF I edited:
I removed all non temp_euro transactions and accounts
I batch edited all transactions, replacing cat by new_cat_euro
In MoneyDance
I imported from another program in euro to temp_euro.
I checked all seemed OK (all the new categories are in euro)
I moved all transactions back to real_eur_account
Repeat if necessary
Proceed to renaming categories properly
I’m tired
