Importing QIF

Derek Atkins warlord at MIT.EDU
Tue Aug 18 11:01:35 EDT 2009


Hi,

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

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

This is an income/expense transaction to the Category
Aufwendungen:Christian:Kleidung.  So this looks correct.

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

THIS, however, is also an income/expense transaction to the Category
Aktiva:Christian:Barvermögen:Bargeld, which is not what you want.  This
transaction should use the QIF Account format if you want to say that
it's a transfer to an Asset/Liability:

L[Aktiva: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?

Yes, fix your QIF.  :)

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


More information about the gnucash-user mailing list