Updating multiple Sales Tax tables in gnucash
J. Anthony Hertzler
anthony at integritybuildings.com
Fri Feb 17 12:53:16 EST 2012
I have a question regarding implementing tax tables for sales tax in
Gnucash. A year or so ago I asked this mailing list how to set up a tax
table so that the appropriate taxes on an invoice are automatically
added to the liability account of each state/city/county where they are
owed.
https://lists.gnucash.org/pipermail/gnucash-user/2009-December/032534.html
With some help I eventually found out how to make that happen,
https://lists.gnucash.org/pipermail/gnucash-user/2009-December/032590.html
but as my list of tax tables grows I'm finding that keeping it updated
is more complex than it seems like it ought to be. Here's what I mean:
We sell portable buildings over an area of fifteen or twenty counties.
Because we deliver them to the customer, the delivery destination is
considered to be the point of sale. This means we need a tax table for
every county that calculates county and state tax, and a tax table for
every town we deliver to that calculates the town, county, and state
tax. This might be a total of fifty or more separate tax tables.
Now the state sales tax changes by half a percent. To update my tax
tables I have to open the tax table editor just before the change kicks
in, and manually edit the state entry on each of those 50 tables
individually. This introduces lots of opportunity for error and mistaken
tax charges as a result.
Obviously this isn't likely to happen often on the state level, but it's
fairly common for one county or another to change the tax rate, again
requiring manual changing of each individual town in that county.
Am I overlooking a feature that would allow me to set these tables up in
a hierarchy such that I could change the state sales tax rate and have
that reflected in each tax table that included state sales tax? If so,
how is it done? If not, it seems like it should be considered to add as
an important feature for businesses that need to make sales in many
different sales tax jurisdictions.
-Anthony Hertzler
More information about the gnucash-user
mailing list