Importing QIF

[Öhreneder Christian]

My QIF looks like this:

!Type:Bank
D27.06.2009
U-34.50
T-34.50
MBezahlung Maestro                            MC/000001293|C&A 1140     1325  K1 27.06.UM 11.00
LAufwendungen:Christian:Kleidung
^
D27.06.2009
U-90.00
T-90.00
MAuszahlung Maestro                           MC/000001292|BANKOMAT 25991 KARTE1 27.06.UM 09.25
LAktiva:Christian:Barvermögen:Bargeld
^


Where the first is a transfer to an expense account and the second is a transfer to my wallet (asset account). I read the QIF spec and tried other ways of generating the QIF but none worked. The way it is written above seems to me the most straightforward ... except that it does not work.

Any suggestions?

Br
Christian


-----Original Message-----
From: Derek Atkins [mailto:warlord at MIT.EDU] 
Sent: Monday, August 17, 2009 4:43 PM
To: Öhreneder Christian
Cc: gnucash-user at gnucash.org
Subject: Re: Importing QIF

Hi,

Öhreneder Christian <Christian.Oehreneder at kapsch.net> writes:

> Hi,
>
> I want to import my bank account statement into GnuCash. I get them in
> csv format and convert them to QIF using calc2qif. In calc I have
> defined rules to assign categories (accounts) to the entry lines in my
> statement, e.g. all lines containing a policy number of an insurance
> are assigned to my respective GnuCash account. (I find that this
> reduces the manual work a lot.) This works well as long as the account
> is an expense type account. If I do the same with my transfers to my
> savings account GnuCash says there is a name conflict and creates a
> new account.
>
> Does anyone know how I can solve this?
> Any suggestions how to efficiently import account statements? How can I automatically assign target accounts to the entry lines in my bank account statement?

What does the QIF look like for the Asset transfers?  (vs. the QIF
for an Expense transaction)?  I suspect your QIF is malformed...

> Thanks for your help!
> Christian

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available