Taxes not calculated properly

[osuwariboy]

Hi, I live in Quebec, Canada and I'm having trouble with making Zencart calculate the taxes on my products. I have read a few articles explaining how to set things up, but none it seems address this matter. Here is the problem.

In Quebec, there are two taxes on products. The first is the federal one (that is called TPS) and the second is the provincial one (that is called TVQ). The way they are calculated is as follow (let us assume an amount of 5$ for this example).

First, the federal tax applies which is currently at a rate of 6%. So:

6% X 5$ = 0.30$

Next is the provincial tax. HOWEVER, it DOES NOT apply to the original amount, instead, it applies to the original amount PLUS the TPS that has just been calculated. Now the provincial tax rate at the moment is 7.5%, so:

7.5% X (5$+ 0.30$) = 0.40$

The grand total should then be:

5$ + 0.30$ + 0.40$ = 5,70$

Now when I try to set taxes up with zenith cart, all I manage to get for this same amount is 5,68$. This is because the provincial tax was applied to the ORIGINAL amount of 5$ instead of the increased amount of 5,30$.

This difference might look insignificant because my test product is cheap... but when you increase the prices, the difference automatically increases too (for 10$ the difference is already 0.05$). I tried to change the tax priorities, increasing and decreasing them, putting TPS at 1 and TVQ at 2 and vice versa, but the amount does not change regardless of the values I set for this field.

Is there anything I'm doing wrong, because quite frankly, I'm at my wits' end here. Thanks in advance.

Tobbi Filteau

[utopiko]

I have the same questions.. anyone has an idea about how to put those two taxes on the same products with the right formula?

Also, i want to put my tax numbers visible to the client....

thanks

[osuwariboy]

Hi,

Concerning your tax number, I'm not too sure, but setting the tax priorities correctly WILL work. It's just that there's a bug in the price field of the product form that calculates the price always with the wrong formula. However if you try to make a purchase of the product, the formula will be applied correctly... took me about a week before realizing that.

Then, concerning your tax number, I believe somewhere on the forum I might have actually seen someone post something of the sort, but it's been a year since I last checked it. Anyway, I hope I was helpful.

Osuwariboy

[DrByte]

The display issue you mention about the tax calc while editing product prices was fixed in v1.3.8.

[utopiko]

Ah, good for the tax formula, i didn't set the priority correctly.

Now i want to be able to see the two tax(and their number) separated from the total like

SubTotal = 10$
GST 5% = 0,5$
QST 7,5% = 0,79$
Total = 11,29$

?

[utopiko]

Forget it.
It doesn't show in your shopping cart, but it show later on the Order Review.


One thing done !