Configuring Taxes for Canadian Sites/Zones

[s_mack]

In a sale from 2-3 days ago, the total taxes are correctly calculated, but displayed funny:



Should be GST 1.29, PST 1.43.

No, this isn't correct.

On a sale of $25.85 you should be charging:

sub: $25.85
PST: $2.07
GST: $1.29
total: $29.21

[laurahowes]

Re: Configuring Taxes for Canadian Sites/Zones
OH!
And on another transaction, it lists a product as being only GST-taxable. I figured it was my error, but when I checked its settings, it's set to GST/PST/HST!

OK, scratch this one.
In my panic, I failed to notice that this customer was NOT in Ontario, and thus should have only been GST-taxable.

[laurahowes]

What is that last one for? You should have only 6

I have many PST-exempt items.

[laurahowes]

No, this isn't correct.

On a sale of $25.85 you should be charging:

sub: $25.85
PST: $2.07
GST: $1.29
total: $29.21

Sorry, I didn't give enough details.
In the subtotal of $25.85, $7.95 was PST-exempt (clothing).

So now the display makes more sense. GST on $7.95 is 40 cents. Wish there was a more elegant way to display it, though. If I'm confused, my customer might be too.

[s_mack]

Ok, then back to your first example where you said you had the problem... what in that, if any is tax exempt? Impossible to help without complete info :)

I'm presuming it is all tax exempt? That's why GST and GST+PST are the same. Still, it is obviously not calculating correctly:

[qoute]Sub-Total: $31.85
Store Pickup (Walk In): $0.00
5% GST # 86028 4694 RT0001: $3.58
8% PST in Ontario + 5% GST # 86028 4694 RT0001: $3.58
Total: $39.02 [/quote]

On $31.85, GST would be $1.59 not $3.58. So your GST is effectively calculating at aproximately 11% and I have no idea what you could have entered to achieve that! Your 8%+5% is also calculating at 11% for an total effective tax rate of around 22 and a half percent.

You clearly have some settings messed up. Is this a production site? If not, perhaps PM me your admin info (address + login + password) and I can take a look.

[laurahowes]

Ok, then back to your first example where you said you had the problem... what in that, if any is tax exempt? Impossible to help without complete info :)

The tax rates are displayed with the rest of the info. The first item is 5% (GST only), the other two are 13% (GST and PST).

In a simpler example, here is the sale of ONE PST-exempt item, shipped out of province (and therefore exempt anyway):

Sub-Total: $20.95
Canada Post (1 box(es) to be shipped) (Domestic Lettermail: estimated 3-5 business days): $3.75
5% GST # 86028 4694 RT0001: $1.05
5% GST on shipping: $1.05
Total: $26.80

It's calculating the GST on shipping based on the product price!

[s_mack]

I just set up a fake account and tested and it showed correctly for me.

Sub-Total: $23.95

Canada Post (1 box(es) to be shipped) (Expedited, 2009-07-17): $8.47

5% GST # 86028 4694 RT0001: $1.20

5% GST on shipping + 8% PST on shipping: $1.10

Total: $34.72

That's with a fake ON address. I also tried BC address and it worked fine too. Also tried store pickup and still did it correctly.

[laurahowes]

That is correct IF you only have PST-exempt items in your cart. What were they? If there are any PST-taxable items, they weren't charged tax.

[s_mack]

I tried a variety of products... I figured clothing was tax exempt (that's the above example). I also tried one with something (seat of some sort) that was charged PST as well (from ON address) and it again did it correctly. You've given me access to your admin and I tried finding the first problem transaction you posted above... I found one with the same subtotal but all the taxes and totals display correctly there so I can't figure out where you're seeing the bad calculations.

[laurahowes]

You've given me access to your admin and I tried finding the first problem transaction you posted above... I found one with the same subtotal but all the taxes and totals display correctly there so I can't figure out where you're seeing the bad calculations.

Yeah, I used the edit order function to quickly correct it since this buyer will be pickin gup her order soon.

Nothing like a million variables to make a problem impossible to ascertain!!