Configuring Taxes for Canadian Sites/Zones

laurahowes:

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

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. :blush:

s_mack:

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

I have many PST-exempt items.

s_mack:

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.

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.

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!

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.

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.

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.

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!! :cry:

laurahowes:

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

You said it :)

I wish you the best of luck resolving your problem. Unfortunately I can't go any further (see PM I sent).

• Steven

sigh of relief
Nothing is wrong with my cart or my tax calculations. Whew.

Stepping away from my panicky sky-is-falling reaction, I took the time to compare the orders as they appear in my admin and the hard copy invoices I have here: the problem is with the Ty Package Tracker module not DISPLAYING the taxes correctly. Maybe it doesn't take into account complex taxing situations? I just installed this mod and it replaces the order screen with its own version. Just thought I'd post in case anyone else has a problem with it.

Steven, can't THANK YOU enough for taking the time to look into this for me. You helped me determine what WASN'T the problem and that was huge.

Off to uninstall and have a stiff drink... :P

You're very welcome. Good job on figuring it out!

So if I were setting up a store in BC, instead of Ontario....I would set up the PST zone for BC not ontario....correct?? or do i still need to charge pst to ontario?

You're correct. No PST for Ontario.

That is... until next year, when the HST in Ontario (and probably BC) comes into effect. Presuming its the same as for the Atlantic provinces that already have HST, you must charge and collect it.

Hello

hope you can figure out this

my taxes dont count

I have set everything as mentioned but i get 0 in taxes

also when I am not logged in I see products with prices including taxes (which is good)
but when I am logged in the prices are without taxes

your help is appreciated, I spent so many hours on this issue

Thank you

joudesign:

Hello

hope you can figure out this

my taxes dont count

I have set everything as mentioned but i get 0 in taxes

also when I am not logged in I see products with prices including taxes (which is good)
but when I am logged in the prices are without taxes

your help is appreciated, I spent so many hours on this issue

Thank you

How can we possibly help? you haven't posted any details whatsoever.

You obviously do not have everything setup as mentioned, or you've changed some default settings without understanding what they do, or you haven't selected the appropriate tax class in you products

it was a zones setting problm

thanks so much for your help and time

looking to hire an expert for assistance with tax/shipping configuration

running v1.3.8a/v1.3.8

despite attempts to follow the above instructions, still not getting taxes and shipping proper tallied/calculated (or even recognized) for out of province orders.

/greg

I have a problem with gst not being added to the order for any orders going out of province. All taxes work fine with orders in province.

All the settings are correct from what I can see.

Any ideas why it's screwed up?