dealing with invoices and QIF imports

[Charles Day]

On Tue, May 27, 2008 at 5:16 PM, Leigh Morresi <dgtlmoon at gmail.com> wrote:

> Charles
>
> thanks for your reply
>
> On Tue, 2008-05-27 at 08:03 -0700, Charles Day wrote:
> > On Tue, May 27, 2008 at 2:08 AM, Leigh Morresi <dgtlmoon at gmail.com>
> > wrote:
> >         heya's
> >
> >
> >         Something i've never been able to clear-up for myself even tho
> >         i'm
> >         following the recipe from the documentation, can someone shed
> >         some
> >         light?
> >
> >
> >         Im creating an invoice, with the 'Income account' set to
> >         "Income:consulting" and "Post"'ing it to my Assets -> A/R
> >
> >
> >
> http://www.gnucash.org/docs/v2.0/C/gnucash-guide/bus-ar-invoices1.html
> >
> >
> >         And then once i receive payment i process the payment as per
> >
> >
> http://www.gnucash.org/docs/v2.0/C/gnucash-guide/bus-ar-payment1.html
> >
> >         So now now the payment is "Transfer account: Assets ->
> >         Checking" which
> >         is all cool.
> >
> >         now the part i dont understand
> >
> >         I'm doing a QIF import from my bank, I have a structure as
> >         thus;
> >
> >
> >         + Assets
> >          - Accounts Receivable
> >         + Expenses
> >          - Computer Repairs
> >         + Income
> >          - Consulting
> >         + MyBank
> >
> >         When I import a .QIF it asks me for an 'Account Name' so i
> >         enter
> >         'MyBank' - now i end up with a 'MyBank' entry in my account
> >         tree (whhich
> >         is fine i guess? or should this be elsewhere?)
> >
> > If the bank account already exists in GnuCash as Assets:Checking, then
> > that's what you should tell the QIF importer instead of making up a
> > new name (MyBank).
>
> My gnucash gives me a textfield to enter not a select list...
>

Simply type Assets:Checking into the text field, or whatever is the name of
your existing account.


> >
> >
> >         I tell it to put payments in the QIF import for monies for
> >         work i've
> >         invoced for into "Income:consulting"
> >
> >         Now when i view "Income:consulting" i see have duplicates of
> >         just about
> >         everything, the "Transfer" field says either "Assets->A/R" or
> >         "MyBank"
> >
> >         so it looks like my income:consulting is roughly twice that of
> >         what i
> >         should be at.
> >
> >         what am i doing wrong?? should i be deleting the items from my
> >         "Income:consulting" that have a transfer of "MyBank" ? (so
> >         that
> >         Income:consulting always shows my total income not includin
> >         the fact
> >         that those invoices might not have been paid - altho this
> >         difference
> >         *should* be sighted in accounts receivable?)
> >
> > What you are manually entering into GnuCash sounds reasonable to me.
> > Now if you set up the QIF import correctly, all the transfers from
> > Assets:A/R to Assets:Checking that have already been entered by hand
> > should get noticed during duplicate detection, allowing you to check
> > them off and avoid importing duplicates.  However, since you seem to
> > be saying that the imported transactions are transferring from
> > Income:Consulting rather than Assets:A/R, take a good look at the
> > account, category, and payee/memo mapping pages of the QIF importer.
> > Anywhere you see Income:Consulting, you should change it to
> > Assets:A/R.
>
> http://www.gnucash.org/docs/v2.0/C/gnucash-guide/bus-ar-invoices1.html
>
> So you mean on the invoice where it says (in this documentation under
> the Edit section) "Income:sales" it should be "Assets:A/R" ?
>

When enter your checking deposits by hand, you are transferring from
Assets:A/R to Assets:Checking, correct?  And I think you said that imported
checking deposits are instead transferring from Income:Consulting to
Assets:Checking (or would be, if you entered Assets:Checking instead of
MyBank). If those two things are true, then I'm suggesting that while in the
QIF importer, you change any existing mappings for "Income:Consulting" to
"Assets:A/R". Then the imported deposits should get detected as possible
duplicates of your existing, hand-entered deposits.

I didn't say anything about changing how you enter invoices. I really don't
know about the business part of GnuCash.

-Charles


> thanks
>
> leigh
>
> >
> > Cheers,
> > Charles
> >
> >
> >
> >         cheers
> >
> >         leigh
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >         _______________________________________________
> >         gnucash-user mailing list
> >         gnucash-user at gnucash.org
> >         https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >         -----
> >         Please remember to CC this list on all your replies.
> >         You can do this by using Reply-To-List or Reply-All.
> >
> --
> Leigh Morresi
> +61401883741
> dgtlmoon at gmail.com
> http://dgtlmoon.com
> skype: dgtlmoon
>
>