dealing with invoices and QIF imports

Derek Atkins warlord at MIT.EDU
Wed May 28 11:42:38 EDT 2008


Quoting Charles Day <cedayiv at gmail.com>:

>> > as per the advice of someone from this list to type in the A/R account
>>
>
> Not sure where you got that idea... I don't think it was from me. What I
> said was that, first, on the "Set the default QIF account name" page you
> type in Assets:Checking rather than MyBank. Second, on the mapping pages,
> substitute Assets:A/R wherever you see Income:Consulting (this part is all
> point/click). If you are finding this all a bit confusing, you might try
> turning on the QIF importer's documentation pages. From the main GnuCash
> window, click Edit->Preferences. In the Online Banking section, check "Show
> documentation".

Yes, and it's this SECOND part that's the problem.  You're telling
the QIF Importer that you have an Income Account called "Assets:A/R".
The importer dutifully does what you told it, making sure there's an
Income Account Assets:A/R, but because there's an incompatible-type
account of that name already it creates a new account tree.  Voila,
you now have Assets2:A/R2 of type Income.

> -Charles
>
>
>> Yeah, that was bad advice.  The problem here is that A/R is
>> an Asset account, but as far as the QIF is concerned it's
>> Income.You should make a new account, Income:QIF-Consulting,
>> and use that for the QIF importer.
>>
>> Then, after you import the QIF you can manually verify that all
>> those transactions match your business transactions... And remove
>> the duplicates from I:Q-C.
>>
>> Unfortunately QIF just doesn't play well with Business.
>>
>> -derek

-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