Configuring Taxes for Canadian Sites/Zones

Winks:

Hello Zenners,

It's me again. I'm in the process of configuring the GST etc using the very thorough tutorial but I'm a bit confused on the "Leave PRIORITY at "1" for a non-cumulative tax (i.e. Ontario)" issue. My business is based in Red Deer, Alberta. Do I use Priorty as '1' or not?

Any help would be appreciated!

My understanding is that Alberta has no provincial sales tax, so the priority setting shouldn't be an issue (ie: 0% of subtotal, or 0% of subtotal+GST will give the same number... $0.00)

The priority setting is used when you want, for example, Tax#1 to be calculated directly on the subtotal, and Tax#2 to be calculated on subtotal+Tax#1. Since this is not what you need, just leave priority at 1 and everything should work out well.

Hope this is helpful,
Alan

Ok Alan i'll leave it as Priority 1.

Thanks for getting back to me!

John

Ok I been reading through these posts and am confused about what taxes to apply to which provinces.

I should probably consult an accountant (which I probably will) but thought I would first get some info here.

The business is located in Ontario.

This is what I came up with, is this correct?

Canada GST Zone (except Eastern Canada: NS, NB, NL) 5%
Eastern Canada - HST Zone NS, NB, NL 13%
Ontario PST Zone ON 8%
?
Thanks

thats pretty much what I have and it works fine

Winks:

Products price (net) $1.5873
Products price (gross) $2.00

This forum's notification system has always frustrated me. I'm subscribed to this forum so I can help out, and I didn't get any notifications until sn_tobin's last email above. That's 6 posts since Apr 22 that I had no idea they were there.

Winks... I was trying to figure out what you meant by Gross and Net... now I see. Its in the product description page, right? That thing is so beyond useless I've forgotten its there... I don't know why, but it never seems to calculate right. Just worry about the Net section. For whatever reason, the Gross calculation it does, does not (necessarily) apply the tax settings correct, but the checkout process does. I just confirmed, I have the normal settings everyone else is using here, but a Net price of $100 shows a Gross price of $125 - a 25% tax, and there's no possible way to get that.

Actually, I just figured out what its doing.

For Ontario it would be 26%, which is what your example shows (which means you have your cart set up for Ontario!! You are in Alberta so you do NOT have an Alberta tax and you DO NOT charge and Ontario tax!! The exception is EVERYONE charges HST to Atlantic and GST to everyone)

What its doing is applying ALL the taxes. For ontario: 8% PST + 5% GST + 13% HST = 26%

I suppose its because on that page it has no idea what zone you're in so it applies all the taxes that are in the system.

Kinda dumb... but forgivable I suppose.

• Steven

... and was fixed in v1.3.8

Thanks Steven!

I'll have a look into your suggestions. I might also get a friend of mine to help me upload the new version of Zen Cart because Dr. Byte seemed to infer that might help too.

I'll let you know how I get on.

Again thank you very much for your support.

John

Yeah, I'm using 1.3.7 on the store that I checked on. How'd you fix it Dr. B? Does it now go by the store's location? Just curious.

John, you probably should upgrade to the latest version. I should too - just haven't had the time, especially with all the mods I have.

Best of luck!

• Steven

http://www.zen-cart.com/forum/showthread.php?p=523295
http://www.zen-cart.com/forum/showthread.php?t=65821

If I recall correctly it was fixed by updating one of the tax functions.
And, yes, the displayed tax calculations are still based on the store's location.

Hi there, i have followed this instructions but i'm still getting ZERO for sales tax
:-(

Follow them again I guess.

Be careful, go step by step. If you're confused on a step... ask. But just posting that its not working gives us ZERO info to go on.

• Steven

ok so i tested it with a different shipping address (Newfoundland) and the sales tax shows right!

But how comes it's showing ZERO for Alberta ???

Store Location : Alberta

Hi zenners,

I have a 1.3.8 cart in Quebec selling books and other items.
GST on all products in Canada
+PST (compounded) on all products except for books in Quebec

I followed the config tips of this thread and it helps a lot... thank's for that! I made some tests and actually almost everything seems working fine, except for this case, when "Config->My Store->Show Split Tax Lines" = TRUE:

With orders having books and other products mixed, for people buying from Quebec as well as the ones from the rest of Canada, I observed that the GST (5%) is displayed only for the book(s) and shipping, but not for other items. PST on other items seems well displayed (and calculated).

As example:

With "Config->My Store->Show Split Tax Lines" = TRUE
Sub-Total : $34.23 (book=12.16)+(other=22.06)
Shipping : $5.53 (configured to have both taxes)
TPS (5%) : $0.88 (5%x($5.53+$12.16)) Missing (5%x$22.06) :no:
TVQ (7.5%): $2.17 (7.5%x($22.06+$5.53+$0.88) OK
Total : $43.92 The (5%x$22.06) missing above is included

Note: A partial total of $3.05 of tax displayed here. Supposed to have $4.16 in total.

Then, with "Config->My Store->Show Split Tax Lines" = FALSE
Sub-Total : $34.23
Shipping :$5.53
TPS (5%) + TVQ (7.5%) : $3.55
TPS (5%) : $0.61
Total : $43.92

Note: Seems all taxes are displayed here!

Probably a bug in SplitTaxLines ?!

Thank's !
Franck :cool:

I'm guessing you're right, just based on the fact you get the correct calculation with that turned off. My first thought was you had the tax class wrong for "other" products, but then it would calculate wrong with the option as FALSE as well.

Me thinks yer on to someting.

• Steven

Franck69,
Is it possible that you have an older version of SplitTaxLines installed? There was a bug similar to this that was raised earlier in the year and has been successfully patched as far as I am aware.

I'd suggest reading the support thread for SplitTaxLines and continuing this discussion there.

just follow this link: SplitTaxLines support thread

Regards,
Alan

I compared all files and I have the latest version.

I am using the Canadian Tax set-up as indicated and it works perfect. However, now I have Dual Pricing/Wholesale and I included the PST exempt modification as indicated in
http://www.zen-cart.com/forum/showpost.php?p=245427&postcount=5
but my HST zone (for NS, NB, NF) is still charging full 13% for wholesale clients.
Where and what do I have to change so that wholesale people in HST Zone would not be charged the PST?

Tx

Why it is necessary to set up 6 tax rates (3 for product and 3 for shipping) if the rates are the same in both. Only the titles change... Can I not just use the Taxable Goods tax class for shipping (the rates are the same)??

Is this so the tax shows on a separate line and not together??

Are the extra 3 tax rates still necessary wen the SplitTaxLine Module is installed??

Sorry, for all the posts... I believe that I figured it out.

I did not enter in the 6 tax rates, only 3 for Canada and in my case one for US.

I am in Canada and wanted one flat shipping rate for Canada that would add the appropriate tax rates depending on where in Canada the product was shipping. Then, I wanted a different flat rate for US being tax exempt.

I have the SplitLineTax and ZonesFlatRate Modules installed. I have 4 zone definitions (US - exempt, Can GST, Can PST, Can HST) I have only 1 tax class (taxable goods). I have 4 tax rates (GST, PST, HST, Exempt).

When I select ship to Canada, it charges the Canada flat rate and the appropriate tax. When I select ship to US, it charges the US flat rate and does not charge tax.

:P