Canadian GST PST

Derek Atkins warlord at MIT.EDU
Mon Nov 13 19:47:59 EST 2006


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


More information about the gnucash-user mailing list