[Kmymoney] Importing multi currency data from Quicken 2008

[Cristian Oneț]

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

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