[Kmymoney] Importing multi currency data from Quicken 2008

[Cristian Oneț]

2014-09-21 2:39 GMT+03:00 Cristian Oneț <onet.cristian at gmail.com>:
> 2014-09-21 2:30 GMT+03:00  <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?
>
> Yes, I'll keep this thread updated as soon as something is done about 2).

I opened this bug [1], from now on please follow it for updates about any fix.

Regards,
Cristian

[1] https://bugs.kde.org/show_bug.cgi?id=339262

>
> Regards,
> Cristian
>
>> 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
>>>
>>
>> _______________________________________________
>> KMyMoney mailing list
>> KMyMoney at kde.org
>> https://mail.kde.org/mailman/listinfo/kmymoney