dealing with invoices and QIF imports

Charles Day cedayiv at gmail.com
Wed May 28 11:19:50 EDT 2008


On Wed, May 28, 2008 at 7:59 AM, Derek Atkins <warlord at mit.edu> wrote:

> Leigh Morresi <dgtlmoon at gmail.com> writes:
>
> > hi all
> >
> > Ok i just tried to import my QIF by typing "Assets: Accounts Receivable"
> > into the "To Account:" field of the .QIF importer.
> >
> > To cut this short - im getting this new account show up after i import
> >
> > "* Assets 2    QIF Import: name conflict with another account
> >   * Accounts Receivable  $0.00
> > "
> >
> > 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".

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