This forum has been archived. All content is frozen. Please use KDE Discuss instead.

Importing accounts

Tags: import, multiple currencies import, multiple currencies import, multiple currencies
(comma "," separated)
something_new
Registered Member
Posts
52
Karma
0
OS

Importing accounts

Tue Dec 07, 2010 2:55 pm
Hi,

I'm a newcomer to KMyMoney and I'm trying to import an account from a OFX file. There is already one account with the same name but in Dollars (my base currency is Euros), but KMM insists in creating a new account in Euros - with the same name.
Once the import is done, it doesn't let me move the transactions to the Dollar accounts. Is there a way to go around this, or do I have to manually insert all the transactions in the non-Euro accounts?

Thank you,
Pedro
zebulon
Registered Member
Posts
417
Karma
2
OS

Re: Importing accounts

Wed Dec 08, 2010 2:04 am
Why do you want to enter transactions in Euro into a dollar account? Do you have an exchange rate that you want to apply to each transaction? An account can only have a single currency. Same for categories: they are linked to a unique currency.
something_new
Registered Member
Posts
52
Karma
0
OS

Re: Importing accounts

Sat Jan 22, 2011 4:06 pm
I'm trying to import a dollar account, but when I do it, KMyMoney creates an account in Euros because it's my base currency.
zebulon
Registered Member
Posts
417
Karma
2
OS

Re: Importing accounts  Topic is solved

Sat Jan 22, 2011 6:29 pm
An OFX file contains very detailed account information. Some of this data must be inconsistent with the definition of the existing account, and KMM thinks it is a new account as a result. Open the OFX file in an editor and check the BANKID, ACCTID, ACCTTYPE, CURDEF, etc. You should find some discrepancy with the existing account. You can then edit the existing account and fix the differences. At least, that's what I think is happening.
something_new
Registered Member
Posts
52
Karma
0
OS

Re: Importing accounts

Sun Jan 23, 2011 5:17 pm
Thanks Zebulon! Indeed after editing the OFX it started working!
Xionbox
Registered Member
Posts
5
Karma
0
OS

Re: Importing accounts

Fri Feb 18, 2011 11:57 pm
Hello,

I'm sorry to bump this topic up, but I'm having the same problem.

I'm moving from MoneyManagerEx to KMyMoney and to do so, I've exported my transactions in a QIF format (it was either that or CSV).

Hence I have no OFX file. How can I modify the account now that it has been imported?

Thanks in advance!
zebulon
Registered Member
Posts
417
Karma
2
OS

Re: Importing accounts

Sat Feb 19, 2011 12:52 am
Xionbox wrote:How can I modify the account now that it has been imported?
So you succeeded importing your QIF file, but the currency is wrong? I think you can try this: create a new account with the proper settings. Go to the first account, hit ctrl-A in the ledger to select all transactions, right-click and select "Move Transaction To". Move everything to the new account. Then, delete the old account and rename the new one to whatever the old one was called.
Xionbox
Registered Member
Posts
5
Karma
0
OS

Re: Importing accounts

Sat Feb 19, 2011 4:38 pm
Yes, I did manage to import the data from the QIF file and there currency is in deed wrong (because not stored in the QIF file).

Interesting idea that is to move the transactions between accounts. However, I couldn't move the transactions because there currencies of the accounts were different. In fact, it seems only possible to move a transaction to another account if both accounts are expressed in the same currency.

Maybe is it possible to manually edit the .KMY file in order to change the currency of the account?
zebulon
Registered Member
Posts
417
Karma
2
OS

Re: Importing accounts

Sat Feb 19, 2011 5:13 pm
I think I got it to work by changing the currency of the new account back and forth; after that I could move into it. Not sure though. Do you still have your QIF file? If so, just create a new account in USD, re-import, and clean up the old account.
Xionbox
Registered Member
Posts
5
Karma
0
OS

Re: Importing accounts

Sat Feb 19, 2011 6:08 pm
Thanks for your insight, it worked!

What I did is change my default currency to USD (instead of EUR) and import the QIF file, and the trick was done!

Thanks again.
zebulon
Registered Member
Posts
417
Karma
2
OS

Re: Importing accounts

Sat Feb 19, 2011 7:03 pm
Smart! And then you changed your base currency back to Euro afterwards?

You can edit the .kmy file (it is a simple gzipped html file), but I'd be very careful, because you may corrupt it.


Bookmarks



Who is online

Registered users: Bing [Bot], Google [Bot], Sogou [Bot]