Which file format to pick for import of split bookings

Derek Atkins warlord at MIT.EDU
Mon Sep 9 12:14:21 EDT 2013


Hi,

Guido Flohr <guido.flohr at imperia.bg> writes:

> Am Montag, den 09.09.2013, 10:53 +0300 schrieb Guido Flohr:
>> I will have a look at QIF and try to use it.
>
> Works without problems.
>
> I have one minor issue with it.  My transaction is balanced, debit and
> credit sum up to zero.  But still, gnucash wants to know the "Default
> QIF account name" from me which defaults to "gnucash".

You are forgetting the "implied split" in QIF.  QIF was designed to
import a specific account's transaction, so all the entries in a QIF
file apply to the "file qif account".  GnuCash assumes that the filename
is the name of this QIF account.  You named your file "gnucash.qif",
right?  So that means that all the transactions apply to the "gnucash"
qif account; you can then map that QIF account to any Asset/Liability
account in your books.

> The generated split transactions now all contain one empty booking for
> the account "gnucash".  I can easily fix that by deleting the account
> and all its bookings later.  But can I avoid that problem altogether?

Yes, use the "implied split" in your QIF.  E.g., if you have a qif file
named "checking.qif" and have a single transaction:

!Type:Bank
D08/09/2013
PKroger
T12.34
LExpenses:Groceries
^

You just need to map the "checking" qif account to Assets:Bank and this
create the single transaction.

For splits it works exactly the same way.

> Thanks,
> Guido

-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