dealing with invoices and QIF imports
Leigh Morresi
dgtlmoon at gmail.com
Tue May 27 20:54:16 EDT 2008
Cool
I wish developers would realise how important the UI is.
I've been - believe it or not - stuck on this same issue for maybe 2 or
3 years and have just been "plowing ahead" with my old ways and working
around having duplicates.
All because I should have been selecting an existing account name/branch
instead of typing in an arbitrary account name??
leigh
On Tue, 2008-05-27 at 17:51 -0700, Charles Day wrote:
> 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
>
>
>
--
Leigh Morresi
+61401883741
dgtlmoon at gmail.com
http://dgtlmoon.com
skype: dgtlmoon
More information about the gnucash-user
mailing list