[Kmymoney] Importing multi currency data from Quicken 2008

[krpasundarananda at gmail.com]

Hello again,

1): Importing the empty structure works fine. As long as the ledgers are
empty the currency can be changed to the correct one after importing
them in KMM.

Emptying the ledgers in Quicken was a lot of clicking ok as the deletion
of each reconciled transaction needs to be confirmed.
But now I have the empty structure saved so once 2 and as a result of
that 3 works I should be able to transfer all the accounts and only need
to go through to manually accept the automatically matched transfers.

Of course it would be simpler if KMM would ask about the currency of
each imported ledger and the exchange rate to use. But now we know that
there is an simple work around.

Would any update about this issue get to this mailing list?
I'd also be happy to do any testing you require and report back.

Sincerely,
Dada

On 09/19/2014 02:46 AM, Cristian Oneț wrote:
> Hi,
>
> I think that if 2) is not currently performed then that is a bug which
> should be easy to fix. If 2) is fixed 3) should work. I'm not sure how
> 1) could be implemented though. My best guess is that you would need a
> QIF file containing only your account structure. Import that account
> structure into a new empty file. Adjust the account currencies (I need
> to take a look how this can be done) then import the data (after 2) is
> fixed). I'll take a look at this issue.
>
> Regards,
> Cristian
>
> 2014-09-19 0:11 GMT+03:00 Krpasundarananda <krpasundarananda at gmail.com>:
>> Hello,
>>
>> I am still trying to transit to KMM.
>>
>> After giving up last year while still using Windows I thought I'll try again
>> now I am fully switched to Linux.
>>
>> Last time I did a full import of all the accounts at once created but this
>> created many issues, so this time I thought to start simple and import each
>> ledger from Quicken separately. (This is also what you adviced me to do last
>> time: Create the whole account structure in KMM before importing so
>> currencies will be correct for each ledger.)
>>
>> As a test I created two ledgers in KMM: 1) My Pesos and 2) My US. I set the
>> currency accordingly and used the conversion rate that I also used in
>> Quicken.
>>
>> Now when importing the My US ledger from the Quicken account (using qif
>> format) it automatically created all the relevant additional ledgers in KMM.
>> This is really good as KMM also automatically matches transactions when
>> importing other ledgers. The only problem is that all were created as US$
>> ledgers, unless I set them up in advance. Like when I tried last year the
>> currency information is greyed out and can't be changed after the ledger is
>> set up.
>>
>> Even tough I pre-created the My Pesos and the My US ledgers with proper
>> currency, the transactions between these ledgers were not converted, ie the
>> same amounts as in the My US ledger was also entered in the My Pesos ledger.
>> The only way I found to correct it is to manually update all the
>> transactions.
>>
>> (My actual account spans 12 years, has 70 ledgers in 10 different
>> currencies, that would be a lot of work to do manually)
>>
>> 1) Is there a way to have KMM ask what currency to use for each
>> automatically created ledger? Can this be added simply in case there is no
>> way right now? That would safe the effort of manually creating 70 ledgers.
>>
>> 2) Is there a way to have all the conversions done automatically when
>> importing ledgers? If KMM knows the currency of a ledger it should be able
>> to do that right? You could have the option to just use one rate for all
>> transactions or confirm amount/exchange rate for each transaction (In case
>> the exchange rates changes during the period that is imported)
>>
>> 3) Can KMM match the transactions once (in this case) both My Pesos and My
>> US ledgers are imported. It already does this perfectly fine when the
>> ledgers are in same currency. When KMM does these matches or allows you to
>> do it manually then the actual exchange rate for each transaction is clear
>> as it has both USD and MXN values. (for me a fixed value for each import
>> would be fine as for my purpose I don't need to adjust the rates unless they
>> are really changing a lot)
>>
>> I could imagine 3) would take some more time to implement but 1) and also 2)
>> seem simple.
>>
>> Sincerely,
>> Dada Krpasundarananda
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> However there are a few issues:
>>
>> 1) Transfers between accounts are added twice when the original accounts are
>> in different currencies. So if I have a My US account and a My Pesos account
>> and the original transfer is USD10 --> MXN130 it would add an entry for 10
>> and 130 in each account in KMM. Deleting the 130 entry from the My US
>> account and the 10 from the My Pesos account would correct it but take a
>> really long time as I have so many accounts and most in different
>> currencies.
>>
>> 2) All accounts are imported in the same base currency though the original
>> accounts are all in different currencies. How can I make sure the new
>> account is created in the correct currency, or change it after the account
>> is already created? The amounts are correct, just the currency is wrong. If
>> I try to edit the account afterwards the base currency drop down box is
>> greyed out. Is there a way to edit the kmy file to change the accounts to
>> their proper currencies?
>>
>> 3) It creates a separate account for each tag used in quicken. So what is
>> one account in Quicken, say "My US$" gets split in several accounts
>> according to the tags. My US/Balivisit, My US/triptoNY, etc etc
>>
>> Thanks so much
>>
>> _______________________________________________
>> KMyMoney mailing list
>> KMyMoney at kde.org
>> https://mail.kde.org/mailman/listinfo/kmymoney
>>
> _______________________________________________
> KMyMoney mailing list
> KMyMoney at kde.org
> https://mail.kde.org/mailman/listinfo/kmymoney
>