dealing with invoices and QIF imports
Charles Day
cedayiv at gmail.com
Tue May 27 20:51:08 EDT 2008
On Tue, May 27, 2008 at 5:46 PM, Leigh Morresi <dgtlmoon at gmail.com> wrote:
>
> Cool, i'll give it a go shortly
>
> sounds like a bit of an oversight in the UI if it it asking for you to
> *type* in an "Account name:" instead of selectin it from a list, surely?
>
Yeah, it's pretty lame. The QIF importer won't win any beauty contests.
-Charles
>
> theres nothing else in gnucash that acts this way... it seems to be all
> select lists, and users dont know to use the "parent{colon}child"
> syntax?
>
> leigh
>
>
>
> On Tue, 2008-05-27 at 17:36 -0700, Charles Day wrote:
> > 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
> >
> >
> >
> --
> Leigh Morresi
> +61401883741
> dgtlmoon at gmail.com
> http://dgtlmoon.com
> skype: dgtlmoon
>
>
More information about the gnucash-user
mailing list