[Kmymoney] Importing multi currency data from Quicken 2008

[Cristian Oneț]

2014-09-21 10:25 GMT+03:00 Cristian Oneț <onet.cristian at gmail.com>:
> 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.

The issue is closed, if you can build from sources you can test it,
otherwise wait for a new release. Just make sure you have proper
conversion rates setup in the file before importing the transactions.

Regards,
Cristian

>
> 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