Canadian GST PST

Brian Dolbec brian_dolbec at telus.net
Mon Nov 13 10:37:29 EST 2006


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>



More information about the gnucash-user mailing list