gnucash-user Digest, Vol 44, Issue 19
Brian Goodyear
brian at goodyearandfriends.com
Mon Nov 13 21:40:18 EST 2006
Hi. Well I didn't figure it out even when you first said it was possible but
hey, what can I say. I just finished trying out posting an invoice using
the tax table as you suggested and it odoes work as advertised. It doesn't
look "right" for here (Montreal) but it'll do for sure. On to the next
hurdle.
Thanks again.
On 11/13/06, Derek Atkins <warlord at mit.edu> wrote:
>
> (don't forget to CC the list on all replies...)
>
> Well, the Edit button edits the current Tax Table Entry. Each Tax Table
> must have at least one Entry.. The Table itself is just a container.
> So yeah, when you click "Edit" it does let you edit the account binding..
> but you're editing it for the selected Tax Table Entry. Then you can add
> or remove additional Tax Table Entries..
>
> It's failure intuitive, although I guess you didn't figure out why there
> were two "new" and "delete" buttons? *shrugs*
>
> -derek
>
> Quoting Brian Goodyear <brian at goodyearandfriends.com>:
>
> > HI. Thanks man. That may have been obvious to you but I thought that
> given
> > there was no edit button on the left hand side that the right hand side
> was
> > for changing the linked account. That's great. I'm going to try it out
> > now. Thanks.
> >
> > On 11/13/06, Derek Atkins <warlord at mit.edu> wrote:
> >>
> >> 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
> >>
> >>
> >
> >
> > --
> > brian at goodyearandfriends.com 977-4412
> >
>
>
>
> --
> 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
>
>
--
brian at goodyearandfriends.com 977-4412
More information about the gnucash-user
mailing list