gnucash-user Digest, Vol 44, Issue 19
Derek Atkins
warlord at MIT.EDU
Mon Nov 13 20:41:36 EST 2006
On the Tax Table editor, on the right-hand side there is a "New" button
that lets you add a new Tax Table Entry to the current Tax Table.
I.e., the LHS shows the Tax Tables, the RHS shows the Tax Table Entries
for the currently-selected Tax Table.
-derek
Quoting Brian Goodyear <brian at goodyearandfriends.com>:
> 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
> _______________________________________________
> 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