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