gnucash-user Digest, Vol 44, Issue 19

[Brian Goodyear]

On 11/13/06, gnucash-user-request at gnucash.org
Hi.  Well I guess if I can get it working as you suggested above I would
change the description to "workable" from "unworkable".

You seem to have found a way to enter 2 linked accounts on one tax table but
I can't see how to do that.  The window that comes up here to set up the
tables only allows one linked account unless( and this is quite likely) I'm
missing something!! Please let us know how that is done.

Increasing the second tax rate to accomodate the tax on tax seems like a
workable solution although I'm not sure how it would print out on the
invoice. Normally (for here) there is:

The item    1000.00
GST 6%        60.00
Subtotal     1060.00
PST 7.5%      79.50

TOTAL      1139.50

The problem with business use in this juristiction is that it is highly
regulated as to form especially regarding the taxes which they take very
seriously.  Anyway, I'm looking forward to your trick to put to linked
accounts in one table.   Love the program so far after entering 2 months of
transactions.  Thanks


From: Derek Atkins <warlord at MIT.EDU>
> Subject: Re: Canadian GST PST
> To: "Brian Goodyear" <brian at goodyearandfriends.com>
> Cc: gnucash-user at gnucash.org
> Message-ID: <sjm3b8metvk.fsf at cliodev.pgp.com>
> Content-Type: text/plain; charset=us-ascii
>
> I would disagree with your word choice of "unworkable".  Had you
> said "cumbersome" then I would agree.  The invoice system was
> written both for selling things AND selling services..  But it
> was meant for itemizing lists, not for just saying "you owe me $1000".
> It's certainly over-designed for the latter.
>
> As I said in my previous message, the tax thingie [sic] works just
> fine.  It's just left to YOU to set it up properly because there are
> just too many tax-locales to try to hard-code a list in the
> application.
>
> -derek
>
> "Brian Goodyear" <brian at goodyearandfriends.com> writes:
>
> > Hi.  Thanks again for your ideas.  I had a look at the thing again and
> find
> > the whole tax thingie unworkable especially for invoices. The invoices
> are
> > basically aimed at the selling of goods whereas we sell mainly services
> so
> > our invoice usually says "Services rendered $1000.00"
> >
> > I am just entering the invoices into the bank register directly like
> this:
> >
> > Paid Invoice
> > Note:Name of client
> > Debit (deposit) of total amount to Bank
> > Credit of amount before taxes to Income Account
> > Credit of 6% to Liabilities: GST collected
> > Credit of 7.5% to Liabilities: PST collected.
> >
> > The first time it's a little onerous but after that it's pretty easy,
> > certainly easier than entering all the Customer info and then wading
> through
> > the Invoice screen.
> >
> > Maybe at some point they will get the tax thingie worked out.
> > Thanks for your input, I appreciate it.
> >
> > On 11/13/06, Brian Dolbec <brian_dolbec at telus.net> wrote:
> >>
> >> On Mon, 2006-13-11 at 05:46 -0500, Brian Goodyear wrote:
> >> > Hi.  Thanks for responding.  I have set up 4 tax tables:
> >> >
> >> > 6% GST collected linked to LIABILITIES:gst collected
> >> > 6% GST paid linked to LIABILITIES;gst paid
> >> > 7.5% PST collected linked to LIABILITIES: pst collected
> >> > 7.5% PST paid llinked to LIABILITIES paid
> >> >
> >> > However here in Quebec the PST is added to the subtotal of the ITEM +
> >> > GST.
> >> > I could setup a table with the combined amount but it looks like it
> >> > can only be linked to one account so it would have to be manipulated
> >> > afterwards.
> >> >
> >> > The same goes for customers/suppliers.  They can only be linked to
> one
> >> > account.
> >> > Am I missing something?
> >> >
> >>
> >> I was just snooping around and apparently gnucash is lacking proper
> >> handling of multiple taxes.  I did figure out a workaround for
> >> invoicing, Bills entry is the same.
> >>
> >>
> >> In the invoice enter each item, selecting taxable/GST, after all items
> >> are entered, add another item labeled PST Taxable, quantity 1, amount =
> >> the subtotal you see at the bottom, select the PST tax table.  Then
> >> enter another item to reverse the subtotal amount, not taxable.  All
> >> totals will be correct, Taxes will display on the invoice correctly.
> >> Only the annoyance of having to enter it manually with a partial
> >> reversal entry.
> >>
> >>
> >> That way it will track taxes properly.
> >>
> >> You might want to submit a feature request to add multiple tax column
> >> options to the invoicing and bills editors, etc..
> >> >
> >> > On 11/12/06, Brian Dolbec <brian_dolbec at telus.net> wrote:
> >> >         On Sun, 2006-12-11 at 19:09 -0500, Brian Goodyear wrote:
> >> >         > Hmm. I can't sem to find any reference anywhere to how to
> >> >         set up the tax
> >> >         > tables to reflect the way the tax is computed here in most
> >> >         jurisdictions ie.
> >> >         > item cost + tax1= subtotal +tax2.  Is there something I'm
> >> >         missing or has
> >> >         > somepne figured a way around it?
> >> >         >
> >> >         > I know I can set up a tax table for each tax linked to the
> >> >         appropriate
> >> >         > liability account but is there a way to set it up so that
> >> >         the Default tax
> >> >         > table can be set from the properties dialog?  Otherwise
> it's
> >> >         a lot of work
> >> >         > to enter each invoice billed or paid.
> >> >         >
> >> >
> >> >         Look in the FAQ for setting up the GST & PST.  It works
> >> >         great.  And yes
> >> >         you can set up the default tax table to use.
> >> >
> >> >         File==>Properties   you can set the default customer and
> >> >         vendor tax
> >> >         tables.
> >> >
> >> >         Setting up the GST accounts, set up a master GST account with
> >> >         three sub
> >> >         accounts, GST paid, GST collected, GST payments.  The master
> >> >         account
> >> >         shows the running balance.
> >> >
> >> >         The invoicing also has a number of tax options you can set.
> >> >
> >> >         --
> >> >         Brian Dolbec <brian_dolbec at telus.net>
> >> >
> >> >
> >> >
> >> >
> >> > --
> >> > brian at goodyearandfriends.com
> >> --
> >> Brian Dolbec <brian_dolbec at telus.net>
> >>
> >>
> >
> >
> > --
> > brian at goodyearandfriends.com 977-4412
> > _______________________________________________
> > 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.
> >
> >
>
> --
>        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
>
>
> ------------------------------
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>
> End of gnucash-user Digest, Vol 44, Issue 19
> ********************************************
>



-- 
brian at goodyearandfriends.com 977-4412