Importing QIF

Derek Atkins warlord at MIT.EDU
Mon Aug 17 10:42:32 EDT 2009


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


More information about the gnucash-user mailing list