[GNC] Determining HST Amounts from bank postings
Michael or Penny Novack
stepbystepfarm at comcast.net
Tue Aug 26 09:36:49 EDT 2025
> ------------------------------------------
>
> My further thoughts on how to resolve this issue:
>
> The incorporation of sales-tax-table into the splitting of Expenses is
> accomplished by adding the Action of "Split Transaction By Sales Tax"
> to the list of "Actions" available for the transactions on Expense
> accounts.
> "Split Transaction By Sales Tax" splits a transaction into item-value
> and sales-tax.
>
> For example in Ontario the HST sales tax is 13%. The value of sales
> tax is 13/113 times transaction-value; the item-value is 100/113 times
> transaction value.
As I see it, the problem with any automated "sales tax" at the general
ledger level, is that IN GENERAL a very complex matter. We usually see
these suggestions from people in jurisdictions where very simple (sales
tax a uniform rate applied to everything sold). To them simple, just a
rate table for every jurisdiction.
However some of us are in jurisdictions where this is not the case,
where whether sales tax applies to the item sold depends on what the
item is (category of item), possibly for some categories if the item
above a certain price, and possibly different rates for different
categories, etc. It might even depend on "seller's category of
business!* We see this as a VERY complex problem, not really something
to be done in the general ledger of the buyer..
That's what a POS (point of sales) application does. It is "told" the
jurisdiction and so looks up the rules for that jurisdiction. As each
item is rung up, decides if taxable, at what rate, and computes the tax.
It might also have a switch for "buyer exempt". The transaction out
(sales receipt) shows the cost of the items and the tax. << a POS system
usually does pother things, sending transactions to ITS General Ledger
and to ITS "Inventory system". Either way, the POS system is doing the
tax calculations for both General Ledger systems.
Michael D Novack
* For example, here in Massachusetts, if I walk into a store and buy a
pair of gloves, it will matter "what kind of store" and "how expensive
the pair of gloves". If bought in a clothing store, will usually be
considered in the category "clothing", not taxable if less than $175 (if
over, the portion of the price over $175 is taxable). But if bought in a
hardware store, classified as "protective gear" and is taxable. BUT --
the clothing store could be selling gloves taxed as protective gear
(specialized gloves) and the hardware store might be selling "clothing".
The issue here is that it is GENERAL PURPOSE clothing that is exempt and
the sort of store moves the dividing line. Sneakers bought in the
clothing store "general wear clothing" but bought in a "sporting goods"
shop "athletic gear".
More information about the gnucash-user
mailing list