dealing with invoices and QIF imports
Leigh Morresi
dgtlmoon at gmail.com
Tue May 27 20:46:02 EDT 2008
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?
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