[GNC] SalesTax problem with GnuCash

Tue Sep 30 16:10:11 EDT 2025

Hi

 I have done the following and looks okey to me, please let me know if there is a difference.  I have assumes some accounts which may be different for you.

  1.
Created an "Input HST" account under Accounts Receivable.
  2.
Set up a tax table named "Input HST" with a 13% rate, and linked it to the above account.
  3.
Created a bill for $860, marked as taxable, and applied the "Input HST" tax table.
  4.
The postings and calculations are correct, with a tax amount of $109.20 as expected.
  5.
To view the details, run a transaction report for the "Input HST" account.

Have attached some screen shots for you.  In this example I have assumed you will have two accounts Input and Output HST, you may have a single account as well and the report will detail if it is a credit or debit.

Saludos Cordiales

Murugan

________________________________
From: Jeannine Ross <ross.jeannine at yahoo.ca>
Sent: Tuesday, September 30, 2025 13:15
To: Murugan Mariappan <m.muruganandam at hotmail.com>
Subject: Re: [GNC] SalesTax problem with GnuCash

Tax is additional to the $ 840.00

On Sep 30, 2025, at 11:35 AM, Murugan Mariappan <m.muruganandam at hotmail.com> wrote:

Just a clarification , the $840 amount is inclusive of taxes or taxes are additional?

Saludos Cordiales

Murugan

________________________________
From: Jeannine Ross <ross.jeannine at yahoo.ca<mailto:ross.jeannine at yahoo.ca>>
Sent: 30 September 2025 12:15
To: Murugan Mariappan <m.muruganandam at hotmail.com<mailto:m.muruganandam at hotmail.com>>
Subject: Re: [GNC] SalesTax problem with GnuCash

I should also mention that when I do a bill from a Vendor and use the HST collected instead of HST paid out the calculation is correct.
The only problem with that is that I don’t get a proper HST report for filing as the HST paid out shows as a negative from HST collected therefore not the report needed when filing HST totals collected and HST paid out
Hope this makes sense to you.
Thanks again
Sent from Jeannine’s iPhone

On Sep 30, 2025, at 11:05 AM, Jeannine Ross <ross.jeannine at yahoo.ca<mailto:ross.jeannine at yahoo.ca>> wrote:

Thanks for responding.  I downloaded GnuCash on a  Mac Book Pro laptop with  operating system Mac OS Sequoia Version 15.6.1.
The sales tax works on when I post a bill from a vendor, but it calculates the amount of sales tax wrong.  I have set the sales tax rate at 13% but it calculates the amount of tax at 26%.
For example:  the billing amount is
$ 840.00 X 13% =$109.20
But instead it come out at
$ 840.00 X 13%. =. 218.40

I tried the calculation; Tax rate 6.5% which is half of the 13% but it comes out wrong .
It calculates it at;
$840.00 X 6.5 % =$. 163,80 Tax
When it should be
$840.00 X 6.5%. = $ 54.60 Tax
This is why I think there is something wrong with the programing of the sales tax in the HST Paid out formula.
Thanks for your help
Jeannine

Sent from Jeannine’s iPhone

On Sep 29, 2025, at 3:01 PM, Murugan Mariappan <m.muruganandam at hotmail.com<mailto:m.muruganandam at hotmail.com>> wrote:

I tried in my environment and it is working fine for both bills and invoices. Can you provide more step by step details

Saludos Cordiales

Murugan

________________________________
From: gnucash-user <gnucash-user-bounces+m.muruganandam=hotmail.com at gnucash.org<mailto:gnucash-user-bounces+m.muruganandam=hotmail.com at gnucash.org>> on behalf of Jeannine Ross via gnucash-user <gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>>
Sent: 28 September 2025 13:53
To: gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org> <gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>>
Subject: Re: [GNC] SalesTax problem with GnuCash

>
>
>
>
> I hope you can help me.  This summer I Set up my small business accounting in GnuCash.  Everything is working well except for the Sales Tax calculations when I post a Bill from a Vendor.  I know that I configured the Sales Tax properly as it works fine when I do an Invoice.  What happen when I do a Vendor Bill, it calculates the tax double the amount.  The Sales Tax set up is 13% , on the Bill it comes as 26% sales tax.   I went back and tried to set it up as 1/2 the amount, 6.5%  and it calculates at again at a wrong total.
> Could it be programmed wrong?
>
> Thank for your help
> Jeannine Ross
> ross.jeannine at yahoo.ca<mailto:ross.jeannine at yahoo.ca>

_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>
To update your subscription preferences or to unsubscribe:
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.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot 2025-09-30 170407.png
Type: image/png
Size: 43568 bytes
Desc: Screenshot 2025-09-30 170407.png
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20250930/ca50c6ad/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot 2025-09-30 170608.png
Type: image/png
Size: 8925 bytes
Desc: Screenshot 2025-09-30 170608.png
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20250930/ca50c6ad/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot 2025-09-30 170550.png
Type: image/png
Size: 25424 bytes
Desc: Screenshot 2025-09-30 170550.png
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20250930/ca50c6ad/attachment-0007.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot 2025-09-30 170439.png
Type: image/png
Size: 31952 bytes
Desc: Screenshot 2025-09-30 170439.png
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20250930/ca50c6ad/attachment-0008.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot 2025-09-30 170415.png
Type: image/png
Size: 33959 bytes
Desc: Screenshot 2025-09-30 170415.png
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20250930/ca50c6ad/attachment-0009.png>