I figured it out, I had my configuration set to base tax on store location instead of shipping address.
Printable View
I figured it out, I had my configuration set to base tax on store location instead of shipping address.
[QUOTE=DrByte;198824]You might find this helpful ... it needs a bit of touching-up, but the basic core is there:
########################################
This tax calculation makes no sense.
When you add a product price (let's say $100), and select TAX CLASS: NONE, the gross price become $117..or whatever, and if select a tax class the gross becomes $133..or whatever... I see no logic...?????????????????????????????????????
Logically, the price for a product displayed (in a box) should be $100, and when a client add it to cart, register, and check out it should displayed $100 + taxes depending on where she/he lives + shipping charges, and then a sub-total.
Maybe I'm mistaken, but how to modify Shipping module in order t odsiplay all these broken down ?:unsure:
This is REALLY helpful for Canadian Vendors (It might have to be updated in 2010 when BC and Ontario start doing HST). I just had a meeting with the Ontario Ministry of Revenue, and found out I need to indicate the taxes, or specify it is included.
I have products where I need to include taxes in the price, based on competitive pricing. I have set up the taxes as procedure above to reflect taxes being collected, but would like to do ONE the following, making the net price the same, even if taxes are charged:
- make a zone based pricing policy, with discounts for taxed regions.
- offer discount coupons by zone to reflect the taxes added (easy but can it be automatic?)
- add instant rebate to certain items by zone.
Are any of these items possible?
Yes, all possible. I don't think any are easy in terms of doing it by manipulating settings. You would have to customize the code. Its not a bad idea for a contribution actually. For my store I have no competition practically but I still hardly sell ANY product in my own province. There's really no reason for that other than taxes. I myself, when shopping online, try to stay away from businesses in my own province because I don't want to pay the extra 7% for no reason. Which is why provincial/state taxes suck - but that's an entirely different discussion.
One problem you're going to run into is that your site doesn't know where a customer is from until they log in. So you'll basically have to advertise somewhere that you pay the taxes for local orders. Then you need to modify the code such that a discount is automatically applied for those in the tax zone. That should be easy enough. Don't do it as a coupon or another problem you're going to run into then is that customers with other coupons won't be able to use them because the "tax free" coupon was automatically applied (zen won't currently allow more than one coupon). Instead, I think you'd probably want to modify the "specials" code to allow a special to only apply for a given zone. Actually, that's not a bad idea for a core upgrade to the code.
Really though, I think you could just charge a zero tax rate and put a notice up that "taxes, where applicable, are included in the price shown." and ignore what OMoR told you. What are they going to do? Nothing. Just make sure you handle the actual accounting side correctly and submit the appropriate tax you "collected" and they'll be happy as clams. I've learned in business, and especially as it relates to government, to just keep it simple and don't ask them questions you don't want to know the answer to.
This thread is quite helpful, but I still need some help.
I'm in Alberta, I realize I charge HST only for those provinces that have HST. What about for the provinces that have PST, to hav have to set up tax zones for each province to apply GST and which provices are cumulative?
It seems as though whever there is an example, it's always in Ontario. Can someone tell me what to set up for Alberta.
thanks
Just follow the examples, substituting Alberta and its taxes wherever you see Ontario. Yes you charge HST for any province that collects it - currently only Atlantic provinces, but starting sometime next year it will be ON and (probably) BC. There is nothing cumulative. You don't worry about anyone's PST but your own, which in your case doesn't exist.
Wow can't believe nobody found this one out.
In the zones_to_geo_zones table in my zen cart there is two associations for
Ontario , hence you see GST + GST.
I got rid of the duplicate by running this sql query in phpmyadmin:
delete zones_to_geo_zones where association_id = 6;
Clinton Gomes, CEO
MBA, BSc Comp Sci.
www.clintsys.com
Were you able to resolve this tax miscalculation problem on the shipping charges?
Quote:
Originally Posted by MojoDaddy
With July 1st changes, is this part of tax class obsolete?
- Tax Class Title: GST/PST/HST Class /* HINT: Yes, this is the same one you just used
- Zone: Ontario PST Zone
- Tax Rate (%): 8.0000
- Description: 8.0% PST (Ontario)
- Priority: 1
I assume we should create two HST tax zones (BC @ 12%) and the other (ON, NS, NL, NB @13%) and same for 2 HST shipping zones, right??
Hello:
has anyone performed the necessary steps to adjust for ON and BC HST? and their varying rates (12% BC, and 13% ON)
I need to make the changes on live sites and cannot afford any errors. If someone has adjustment steps required, please please share.
If you're doing business with the maritime provinces, you can simply apply the HST you would have set up there to the new provinces that are using HST.
Ray
It should be fairly straight forward. I'm in BC so I'll use myself as an example.Quote:
Originally Posted by newagekat
First Step: Locations / Taxes --> Zone Definitions
Currently I have BC PST Zone [PST (only when shipping to BC)], Canada GST Zone [GST (except Eastern Canada: NS, NB, NL)], and Eastern Canada HST Zone [HST (only when shipping to NS, NB, NL)]
That will chaneg to BC HST Zone [HST (only when shipping to BC)], Canada GST Zone [GST (except BC, NS, NB, NL, ON)], and Eastern Canada HST Zone [HST (only when shipping to NS, NB, NL, ON)]
Second Step: Locations / Taxes --> Tax Rates
For each Tax Class (Shipping and Taxable Goods) there are the three zones (listed above) associated. Adjust the new BC zone frmo 7% to 12%.
The rest stays the same.
Am I missing anything?
- Steven
I do wonder though... should we be adjusting existing tax definitions? Or should we be adding new ones and stop using the old ones? The reason would be (I guess) for historical paper trail.
Hello:
For those of us still confused about assigning tax rates etc. here's a blow by blow on how to adjust your existing settings.
My clients are in BC so BC PST is used. Please adjust for your province.
Locations/Taxes --> Tax Rates
Delete
GST/HST/PST Class Zone: BC PST
GST on Shipping Zone: BC PST
Locations/Taxes --> Zones Definitions
choose Canada GST Zone, click details
Delete BC and ON
Click BACK to go up one level.
choose PST Zone, click details
delete BC
Click BACK to go up one level.
delete PST Zone
Choose HST Zone, click details
Click INSERT to create new sub-zone:
- Country: Canada; Zone: Ontario
Click BACK to go up one level.
Create the HST Zone for BC
- Zone Name: BC HST Zone
- HST (only when shipping to BC)
Now choose on the newly created "BC HST Zone", click details
Click INSERT to create a new sub-zones:
- Country: Canada; Zone: BC
Locations/Taxes --> Tax Rates
create TWO Tax Rates:
- Tax Class Title: GST/PST/HST Class
- Zone: BC HST Zone
- Tax Rate (%): 12.0000
- Description: 12.0% GST#99999 99999 RT0001
- Priority: 1
- Tax Class Title: GST Shipping Class
- Zone: BC HST Zone
- Tax Rate (%): 12.0000
- Description: 12.0% GST on shipping
- Priority: 1
I don't think that completed order are changed, so any paper trail should still exist. I hope I've covered everything. If I've missed anything, do let me know.
is this correct for Ontario starting July 1st??
3 Tax Zones:
Canada GST Zone GST (Except NB, NL, NS -- ON, BC
HST Zone - Eastern Canada & ON NB, NL, NS, ON - ONLY
HST Zone for BC BC - ONLY
2 tax classes
GST on shipping/handling
GST/HST/PST Class
6 Tax rates
GST/HST/PST Class Canada GST Zone 5.00% 5.0% GST#99999 99999 RT0001
GST/HST/PST Class HST Zone - Eastern Canada & ON 13.00% 13% HST#R99999 9999 RT0001
GST/HST/PST Class HST Zone for BC 12.00% 12% HST#R99999 9999 RT0001
GST on shipping/handling Canada GST Zone 5.00% 5.0% shipping GST/HST#99999 9999 RT0001
GST on shipping/handling HST Zone - Eastern Canada & ON 13.00% 13% shipping GST/HST#99999 9999 RT0001
GST on shipping/handling HST Zone for BC 12.00% 12% shipping GST/HST#99999 9999 RT0001
Tx
Veronika
Hi Veronika,
The only change I can see that you missed is Nova Scotia's HST rate changes to 15% on July 1, so I guess you would need another zone and another tax rate for each of your classes.
Colleen
Thanks, I did not know that one...Quote:
Originally Posted by MsHutch
Soooo, the above will become
3 Tax Zones:
Canada GST Zone GST (Except NB, NL, NS, ON, BC)
HST Zone - NB, NL, ON
HST Zone - BC
HST Zone - NS
2 Tax Classes
GST on shipping/handling
GST/HST/PST Class
*8* Tax rates
GST/HST/PST Class/Canada GST Zone/5.00%
GST/HST/PST Class/HST Zone - NB,NL, ON/13.00% GST/HST/PST Class/HST Zone - BC /12.00%
GST/HST/PST Class/HST Zone - NS /15%
GST on shipping/Canada GST Zone/5.00%
GST on shipping/HST Zone - NB,NL,ON/13.00%
GST on shipping/HST Zone - BC/12.00%
GST on shipping/HST Zone - NS / 15%
Is that right?
Oops, 4 Tax Zones that is.
Hope this setting is right...
Hi
This is old and doesn’t include changes to Ontario and BC. There is no more GST and PST for these provinces and they go to HST from July 1. Does any one know what need to be changed in this document to reflect changes to Ontario and BC?
To set up the new HST's is pretty simple. I'm breaking all my provinces down independently just so every time a province changes their tax rates it's easier to adjust. This is assuming that you followed the original excellent tutorial that Dr. Byte created and you have the two classes "GST/HST/PST class" and the "GST/HST/PST on shipping" class.
So I'll take Ontario as an example, and just do each province accordingly:
Under "Locations/Taxes" go into "Zone Definitions". Create a new Zone.
Titled: HST - ON Description: HST for Ontario
Once you've created that, it will have a red dot beside it. Click on "details" then "insert", and choose Canada then Ontario out of the list. Now your dot should be yellow.
Under "Locations/Taxes", go into Tax Rates. Click "insert new rate"
Choose PST/HST/GST class
Zone is the HST - ON
Tax Rate - 13%
Description - 13% HST
Priority: 1
Then click insert
Now you have to do the same thing, just choosing the class as "PST/HST/GST on shipping" class and make the description 13% HST on shipping
Now go back to your original "Zone Definitions" and remove ON from what ever definition you had it under previously. Do this by clicking on the definition, choosing "details" and deleting the province from the list. At his point your dot should now be green since it has all been set up. Run a test order and see how it goes.
Initial instructions updated for basic setup. Adapt to other provinces as necessary.
margecc's advice may be helpful as you customize according to your unique needs.
DrB... in your updated first post, why are there 7 and not 8 rates? Why would an Ontario merchant not charge HST on shipping to BC now that both provinces use the harmonized tax?
Could be something I missed ... but ... unless the Ontario merchant is registered to collect and remit the provincial portion of BC HST, it seems incorrect to be charging customers needlessly. (Yes, there is still a distinction between the provincial and federal portions of the tax ... ie: cases where products are exempt from the provincial portion but must still pay GST.)
I see your logic, but since neither of us are tax accountants, I suggest that a merchant consult a qualified professional before surmising what they think they should do.
Sure, but then why have we all been collecting HST from Atlantic provinces for all these years, right?
From what I've read from the BC side of things... there is no "exempt from the provincial portion". If GST was charged, then HST is charged. If GST wasn't charged, then it still isn't (and neither is HST). Of course, you're right that I'm not an accountant and someone should find out for sure. But it definitely seems logical to me that if we (regardless of province) were collecting HST from the Maritimes that it would be the same situation for ON/BC. Then again.. "logic" and "government" don't exactly go together.
- Steven
While not a difinitive source, check out http://sbinfocanada.about.com/ where it states:*edit*: that info is backed up by a passage found on TaxTips.ca as well.Quote:
If you are selling goods or services out of province, you charge the GST/HST rate based on where the goods are being shipped to. Therefore, if you ship to B.C., charge 12%, to Ontario, Nova Scotia, Newfoundland and Labrador, or New Brunswick, charge 13%, and if you sell to Alberta, Manitoba and Saskatchewan only charge 5% (the GST rate).
I'm pretty sure ON stores (well, any province actually) will be collecting full HST from BC clients and vice-versa.
Hello Everyone,
Nova Scotia HST change to 15% as of July 1.
Check here for more info: http://www.gov.ns.ca/finance/en/home...x/default.aspx
Thank you DrByte, s_mack and everyone for making our life much easier. :smile:
==============
GST
- Country: Canada; Zone: Alberta - 5%
- Country: Canada; Zone: Manitoba - 5%
- Country: Canada; Zone: Northwest Territories - 5%
- Country: Canada; Zone: Nunavut - 5%
- Country: Canada; Zone: Prince Edward Island - 5%
- Country: Canada; Zone: Quebec - 5%
- Country: Canada; Zone: Saskatchewan - 5%
- Country: Canada; Zone: Yukon Territory - 5%
==============
HST
- Country: Canada; Zone: British Columbia - 12%
- Country: Canada; Zone: Ontario - 13%
- Country: Canada; Zone: New Brunswick - 13%
- Country: Canada; Zone: Newfoundland - 13%
- Country: Canada; Zone: Nova Scotia - 15%
==============
Click on "BACK" to go up one level.
Now create the Ontario HST Zone:
Click Insert
- Zone Name: Ontario HST Zone
- Description: HST (only when shipping to Ontario)
Now click on the newly created "Ontario HST Zone" row to drill down one level to "Sub Zones"
Click INSERT to create new sub-zone:
- Country: Canada
- Zone: Ontario
==============
Click on "BACK" to go up one level.
Now create the BC HST Zone:
Click Insert
- Zone Name: BC HST Zone
- Description: HST (only when shipping to BC)
Now click on the newly created "BC HST Zone" row to drill down one level to "Sub Zones"
Click INSERT to create new sub-zone:
- Country: Canada
- Zone: British Columbia
==============
Click on "BACK" to go up one level.
Now create the NS HST Zone:
Click Insert
- Zone Name: NS HST Zone
- Description: HST (only when shipping to NS)
Now click on the newly created "NS HST Zone" row to drill down one level to "Sub Zones"
Click INSERT to create new sub-zone:
- Country: Canada
- Zone: Nova Scotia
==============
Click on "BACK" to go up one level.
Now create the Maritimes HST Tax Zone:
Click Insert
- Zone Name: Eastern Canada - HST Zone
- Description: NB, NL
Now click on the newly created "Eastern Canada - HST Zone" row to drill down one level to "Sub Zones"
Click INSERT to create new sub-zone:
- Country: Canada; Zone: New Brunswick
- Country: Canada; Zone: Newfoundland
==============
- Tax Class Title: GST/PST/HST Class /* HINT: Yes, this is the same one you just used
- Zone: Ontario HST Zone
- Tax Rate (%): 13.0000
- Description: 13.0% HST (Ontario)
- Priority: 1
/*HINT: Insert your Tax Number (RST) as part of DESCRIPTION and it will show up on invoice !!!
- Tax Class Title: GST/PST/HST Class /* HINT: Yes, this is the same one you just used
- Zone: BC HST Zone
- Tax Rate (%): 12.0000
- Description: 12.0% HST (BC)
- Priority: 1
/*HINT: Insert your Tax Number (RST) as part of DESCRIPTION and it will show up on invoice !!!
- Tax Class Title: GST/PST/HST Class /* HINT: Yes, this is the same one you just used
- Zone: NS HST Zone
- Tax Rate (%): 15.0000
- Description: 15% HST (NS)
- Priority: 1
/*HINT: Insert your Tax Number (RST) as part of DESCRIPTION and it will show up on invoice !!!
- Tax Class Title: GST/PST/HST Class /* HINT: Yes, this is the same one you just used
- Zone: Eastern Canada - HST Zone
- Tax Rate (%): 13.0000
- Description: 15% HST#R99999 9999 RT0001
- Priority: 1
/*HINT: Insert your Tax Number (RST) as part of DESCRIPTION and it will show up on invoice !!!
==============
That takes care of taxes on products. And now, the Shipping taxes:
- Tax Class Title: GST Shipping Class
- Zone: Canada GST Zone
- Tax Rate (%): 5.0000
- Description: 5.0% GST on shipping
- Priority: 1
- Tax Class Title: GST Shipping Class
- Zone: Ontario HST Zone
- Tax Rate (%): 13.0000
- Description: 13% shipping HST#99999 9999 RT0001
- Priority: 1
- Tax Class Title: GST Shipping Class
- Zone: BC HST Zone
- Tax Rate (%): 12.0000
- Description: 12% shipping HST#99999 9999 RT0001
- Priority: 1
- Tax Class Title: GST Shipping Class
- Zone: NS HST Zone
- Tax Rate (%): 15.0000
- Description: 15% shipping HST#99999 9999 RT0001
- Priority: 1
- Tax Class Title: GST Shipping Class
- Zone: Eastern Canada - HST Zone
- Tax Rate (%): 13.0000
- Description: 13% shipping HST#99999 9999 RT0001
- Priority: 1
- Tax Class Title: GST/PST/HST Class
- Zone: Canada GST Zone
- Tax Rate (%): 5.0000
- Description: 5.0% GST#99999 99999 RT0001
- Priority: 1
/*HINT: Insert your Tax Number (RST) as part of DESCRIPTION and it will show up on invoice !!!
So its just NS that was raised to 15%?? Yeesh, why do they make this so confusing, and WHY don't they send this info out to GST registrants??? I heard NOTHING of an HST change for NS until I read it here>
Hell s_mack,
That's what I got so far.Quote:
So its just NS that was raised to 15%??
Changes for July 1, 2010:
Ontario 5% GST to 13% HST
British Columbia: 5% GST to 12% HST
Nova Scotia: 13% HST to 15% HST
Quote:
Harmonized Sales Tax & Rebates
The Harmonized Sales Tax (HST) is administered by the federal government and applies to all goods and services with some exceptions. It combines the federal Goods and Services Tax (GST) of 5 per cent and Nova Scotia’s value-added tax. As of July 1, 2010 the provincial value-added tax will increase from 8 per cent to 10 percent.
The HST relies on the same tax base, legislation, input tax credits and tax returns as the federal GST.
The HST is a value-added tax levied on the additional value of goods or services at a point of production or exchange. Although businesses pay the HST on their inputs, they are generally eligible to recoup this tax expenditure through input tax credits.
The HST differs from retail sales taxes in other provinces (PEI, MB, SK, QC) in that it applies to both goods and services and it provides input tax credits to businesses to offset the taxes paid in input.
Additional information on the administration of HST.
Additional information on HST Rebates.
A new Comprehensive Integrated Tax Coordination Agreement (CITCA) between the Government of Canada and the Government of Nova Scotia was signed on April 3, 2010.
Federal regulations under the Excise Tax Act (Canada) to effect the change in the provincial portion of the HST have been passed and were published in the Canada Gazette Part II on May 12, 2010.
What's new from Budget 2010
* The HST will increase to 15 percent as of July 1, 2010. Click here to read the Transitional Rules (as of April 15, 2010) for the rate change.
* HST rebates at the point of sale will be introduced on children’s clothing, children’s footwear, feminine hygiene products and diapers effective July, 1 2010.
* Administration of the Nova Scotia First Time Homebuyers HST Rebate is transferring from the Canada Revenue Agency to Service Nova Scotia and Municipal Relations.
Yep, you're right. Confirmed with my accountant WHO ALSO DIDN'T KNOW until today (a day AFTER the change) about NS!!
I'd heard that all the Maritime provinces were being increased to 15%. Interesting that it's maybe only NS.
Isn't it nuts that we reasonably intelligent business owners somehow didn't know this? If it were just me, I'd figure I somehow had my head in the sand and missed something in the mail... but as it is I have to say I really think our government(s) dropped the ball here. I read an article this morning that said an estimated HALF of Canadian businesses are not yet properly setup for the BC HST. Ridiculous.
LOL ... true enough.
Then again, I'd advocate that if they dropped the sales tax to 0% and put the money back in the hands of the people then the people could afford to pay for the things they need instead of forcing the government to provide them to people who don't even need them. Too much time and money are wasted in administrating taxes than actually gaining benefit from collecting them. What a waste.
As you say, ridiculous.
agreed 100%. I bet we could reduce our taxes by half and get double the services if we could make things perfectly efficient. I would run for PM. If I take my wife's last name I'd be Steven Harper... close enough to sneak some votes? (or close enough to catch a bullet?)
Er, um, lest this thread go off into a political tangent, I'm going to refrain from opening my mouth. :blush:
Just started new biz with Zencart.....
I cannot thank you (Dr.Byte and others) enough for this post! Saved me an entire day of work, and mental chaos!
I'm going back through the 25 pages of posts here.... in case anyone has it handy... how/where do I ad the SQL statement that was suggested by Dr. Byte on the initial post?
Is it necessary? (Has anyone not placed it?)
Thanks in advance,
K
That SQL statement would only be useful if you've added a whole lot of products and didn't set the correct tax-class on them when you created them.
First post here on the forums. I don't want to offend, and maybe I'm clueless but...
The tutorial at the start of this thread is wrong. It's clearly written but the tax rates are wrong for Eastern Canada. NS is 15%, ON, NL and NB are 13%, and BC is 12%. There is more steps and entries required.
The tutorial needs updating or I suggest taking it down altogether. Sorry to speak frankly about this, but think how many people who are newbies and are charging incorrectly. It put their reputation on the line also. Yes, they can find out for themselves, but I say the onus in on this tutorial on this zen cart forum.
In closing, this makes me skeptical of following the guides and info that I find here sadly. I do question my choice of using zen cart because the support for Canadian ecommerce is very poor.
I sound ungrateful, but I'm not. I'm just pointing out the obvious which is surprising why I can't find any mention of the tutorial being wrong. Additionally, the main zen cart guide is even more outdated than this one. Get it right or take it down.
It states at the beginning of the first post "You might find this helpful ... it needs a bit of touching-up, but the basic core is there", so I do not find it to be wrong, but merely a guide as to how to set up the taxes.
As well, the only thing "wrong" about it that I can see is that it doesn't correctly deal with NS. Provincial taxes can change at any time, and the "correct" way of doing it is covered later in the thread anyway. So really "ecom newbie"... "take it down altogether"? Seriously? This tutorial is invaluable to all Canadian Zenners and it holds your hand 99.9% of the way. Hoping for that extra 0.1% is fine... demanding it is not.
Hello, just noticed you have the tax rate at 13% and description at 15% ... i'm guessing it should say 13% on both ... just wanted to point out in case people are copying and pasting as i was :) ... and moved forward without double checking and it shows this on their invoice ...Quote:
Originally Posted by Royal
Yes! It should be 13%.Quote:
Originally Posted by djbelize
- Tax Class Title: GST/PST/HST Class /* HINT: Yes, this is the same one you just used
- Zone: Eastern Canada - HST Zone
- Tax Rate (%): 13.0000
- Description: 13% HST#R99999 9999 RT0001
- Priority: 1
/*HINT: Insert your Tax Number (RST) as part of DESCRIPTION and it will show up on invoice !!!
Hi:
There seems to be a lot of confusion around the original tax setup info on this post. For those of you who can't seem to get your head around it, here's a modified version as of July 1/2010.
NOTE: each province handles shipping taxes differently. Please check with he appropriate government agency in your province,
Thank you Dr Byte and Peter Mosier for their work on this topic.
===================
Step-by-Step SETUP:
===================
STEP (1): Set the location for your store:
Configuration --> My Store
- Country: Canada
- Zone: BC (This is my province)
STEP (2): Create the "Tax Zones". The are geographical regions where a particular set of tax laws applies
Locations/Taxes --> Zones Definitions
* Since HST has been adopted or modified as of July 1, 2010, the following zones will be required:
Canada GST Zone (Except NB, NL, NS, ON, BC)
HST Zone - NB, NL, ON
HST Zone - BC
HST Zone - NS
Create the Zone for all of Canada
- Zone Name: Canada GST Zone
- Description: GST (Except NB, NL, NS, ON, BC)
Now click on the newly created "Canada GST Zone" row to drill down one level to "Sub Zones"
Click INSERT to create 8 new sub-zones, one at a time:
- Country: Canada; Zone: Alberta
- Country: Canada; Zone: Manitoba
- Country: Canada; Zone: Northwest Territories
- Country: Canada; Zone: Nunavut
- Country: Canada; Zone: Prince Edward Island
- Country: Canada; Zone: Quebec
- Country: Canada; Zone: Saskatchewan
- Country: Canada; Zone: Yukon Territory
Click on "BACK" to go up one level.
Now create the HST Zone - NB, NL, ON:
Click Insert
- Zone Name: HST Zone - NB, NL, ON
- Description: NB, NL, ON
Now click on the newly created "HST Zone" row to drill down one level to "Sub Zones"
Click INSERT to create 3 new sub-zone:
- Country: Canada; Zone: New Brunswick
- Country: Canada; Zone: Newfoundland
- Country: Canada; Zone: Ontario
Click on "BACK" to go up one level.
Now create the HST Tax Zones for NS:
Click Insert
- Zone Name: HST Zone - NS
- Description: HST for NS
Now click on the newly created "HST Zone" row to drill down one level to "Sub Zones"
Click INSERT to create new sub-zone:
- Country: Canada; Zone: Nova Scotia
Click on "BACK" to go up one level.
Now create the HST Tax Zones for BC:
Click Insert
- Zone Name: HST Zone - BC
- Description: HST for BC
Now click on the newly created "HST Zone" row to drill down one level to "Sub Zones"
Click INSERT to create new sub-zone:
- Country: Canada; Zone: British Columbia
Do NOT create a separate Tax ZONE for Shipping. You will simply use the "Canada" tax zone for the GST Shipping tax CLASS (below).
*** Important: this means that SHIPPING GST will only be charged to destinations within Canada,
*** but NOT charged on exports.
*** According to Canada Customs & Revenue Agency (1-800-959-5525), you do *NOT* charge GST
*** on the shipping fee for EXPORTS.
STEP (3): Create the "Tax Classes"
Note: You can only assign ONE Tax CLASS to a product.
But since we want shipping GST to show up separately, we will make a seperate Tax CLASS just for it.
Locations/Taxes --> Tax Classes
create TWO (2) tax classes:
- Tax Class Title: GST/HST/PST Class
- Description: All taxable goods
- Tax Class Title: GST on Shipping
- Description: GST on shipping within Canada
STEP (4): TAX RATES
Here is where it all comes together: Tax Rates.
Tax RATES associate Tax ZONES & Tax CLASSES to determine the correct Tax Rate.
HINT: The "DESCRIPTION" is what shows up on the invoice, so use it judiciously!!!!!!!!!!!!!
Locations/Taxes --> Tax Rates
create SIX (6) Tax Rates:
- Tax Class Title: GST/PST/HST Class
- Zone: Canada GST Zone
- Tax Rate (%): 5.0000
- Description: 5.0% GST
- Priority: 1
/*HINT: Insert your GST# as part of DESCRIPTION and it will show up on invoice !!!
/*HINT: Leave PRIORITY at "1" for a non-cumulative tax (i.e. Ontario)
- Tax Class Title: GST/PST/HST Class /* HINT: Yes, this is the same one you just used
- Zone: HST Zone - NB,NL,ON
- Tax Rate (%): 13.0000
- Description: 13.0% HST (NB,NL,ON)
- Priority: 1
/*HINT: Leave PRIORITY at "1" for a non-cumulative tax (i.e. Ontario)
but change to "2" for cumulative tax (i.e. You are a Quebec store)
- Tax Class Title: GST/PST/HST Class /* HINT: Yes, this is the same one you just used
- Zone: HST Zone - NS
- Tax Rate (%): 15.0000
- Description: 15%
- Priority: 1
- Tax Class Title: GST/PST/HST Class
- Zone: HST Zone - BC
- Tax Rate (%): 12.0000
- Description: 12% HST#R99999 9999 RT0001
- Priority: 1
That takes care of taxes on products. And now, the Shipping taxes:
- Tax Class Title: GST Shipping Class
- Zone: Canada GST Zone
- Tax Rate (%): 5.0000
- Description: 5.0% GST on shipping
- Priority: 1
- Tax Class Title: GST Shipping Class
- Zone: HST Zone - NB,NL,ON
- Tax Rate (%): 13.0000
- Description: 13.0% HST (shipping)
- Priority: 1
- Tax Class Title: GST Shipping Class
- Zone: HST Zone - NS
- Tax Rate (%): 15.0000
- Description: 15% HST shipping
- Priority: 1
- Tax Class Title: GST Shipping Class
- Zone: HST Zone - BC
- Tax Rate (%): 12.0000
- Description: 12% HST shipping #99999 9999 RT0001
- Priority: 1
STEP (5): Specify the appropriate Tax Class for SHIPPING MODULES
MODULES --> SHIPPING
Edit whichever shipping module(s) you are using.
Tax Class: GST Shipping Class
/* SEE PREVIOUS HINT
STEP (6): Specify the appropriate Tax for PRODUCTS
This may take some time....
CATALOG --> Categories/Products
Drill down to each product. Click EDIT
TAX CLASS: "GST/PST/HST CLASS"
==============
I hope I did not forget anything.
Hello, i'm hoping someone could help me choose the appropriate shipping method module ... i'm residing in windsor ontario and am just looking to ship within Ontario probably toronto the furthest as of now ... to start off as most of my business is locally and as i expand i'd like to offer further shipping. Any help or direction would be great ! :)Quote:
STEP (5): Specify the appropriate Tax Class for SHIPPING MODULES
MODULES --> SHIPPING
Edit whichever shipping module(s) you are using.
Tax Class: GST Shipping Class
/* SEE PREVIOUS HINT
Hi all!
Great tutorial!
Unfortunately, even after going through it over and over again, I still seem to be doing something wrong.
i have set up the BC HST zone (12%), and the BC Shipping HST zone (12%), but when I go to check-out, I am charged 24% on the TOTAL (product + shipping charges), instead of 12% on each...
what have I done wrong?
Any advice appreciated :-)
UPDATE: I solved my problem. My best-guess is that, when you have a tax zone defined that doesn't associate with any specific geographical zone, that tax is added as well by default. I made a few changes, so I am not sure, but I think that was what was wrong (I had a zone that was geographically undefined)
Quote:
Originally Posted by sculpt
Correct: A zone that's not assigned any geographical limitations is thus universal, and therefore applied to everyone.
newagekat, thanks for that updated set of instructions. It worked a treat. Well done. :)
Vito
I followed the instructions from newagekat (instructions as of July 1 2010) then did a dump of the affected dbase records. If you import what follows into your database, this should take care of steps 1-4 inclusive assuming you've done no other tax configuration yet.
NOTE: this also assumes the dbase prefix is "zen_" which is easy enough to change with a search and replace in the code below
NOTE: I haven't tested this on a new install yet so hopefully I haven't missed any relevant dbase tables.
Code:--
-- Dumping data for table `zen_geo_zones`
--
LOCK TABLES `zen_geo_zones` WRITE;
INSERT INTO `zen_geo_zones` VALUES (2,'Canada GST Zone','GST (Except NB, NL, NS, ON, BC)',NULL,'2010-11-12 11:07:32'),(3,'Canada HST Zone - NB, NL, ON','HST (NB, NL, ON)',NULL,'2010-11-12 11:12:12'),(4,'Canada HST Zone - NS','HST (NS)',NULL,'2010-11-12 11:13:48'),(5,'Canada HST Zone - BC','HST (BC)',NULL,'2010-11-12 11:15:19');
UNLOCK TABLES;
--
-- Dumping data for table `zen_tax_class`
--
LOCK TABLES `zen_tax_class` WRITE;
INSERT INTO `zen_tax_class` VALUES (2,'GST/HST/PST Class','All taxable goods',NULL,'2010-11-12 11:16:43'),(3,'GST/HST Shipping Class','GST/HST on shipping within Canada','2011-07-22 12:00:03','2010-11-12 11:17:33');
UNLOCK TABLES;
--
-- Dumping data for table `zen_tax_rates`
--
LOCK TABLES `zen_tax_rates` WRITE;
INSERT INTO `zen_tax_rates` VALUES (2,2,2,1,'5.0000','5% GST',NULL,'2010-11-12 11:21:21'),(3,3,2,1,'13.0000','13% HST (NB,NL,ON)','2010-11-12 11:22:47','2010-11-12 11:22:33'),(4,4,2,1,'15.0000','15% HST (NS)',NULL,'2010-11-12 11:23:31'),(5,5,2,1,'12.0000','12% HST (BC)',NULL,'2010-11-12 11:24:13'),(6,2,3,1,'5.0000','5% GST Shipping','2011-07-22 11:46:06','2011-07-22 11:38:17'),(7,3,3,1,'13.0000','13% HST (NB, NL, ON) Shipping','2011-07-22 11:46:31','2011-07-22 11:39:28'),(8,4,3,1,'15.0000','15% HST (NS) Shipping','2011-07-22 11:46:42','2011-07-22 11:40:21'),(9,5,3,1,'12.0000','12% HST (BC) Shipping','2011-07-22 11:46:54','2011-07-22 11:41:47');
UNLOCK TABLES;
--
-- Dumping data for table `zen_zones_to_geo_zones`
--
LOCK TABLES `zen_zones_to_geo_zones` WRITE;
INSERT INTO `zen_zones_to_geo_zones` VALUES (2,38,66,2,NULL,'2010-11-12 11:08:05'),(3,38,68,2,NULL,'2010-11-12 11:08:22'),(4,38,72,2,NULL,'2010-11-12 11:08:42'),(5,38,73,2,NULL,'2010-11-12 11:08:56'),(6,38,76,2,NULL,'2010-11-12 11:09:09'),(7,38,77,2,NULL,'2010-11-12 11:09:54'),(8,38,78,2,NULL,'2010-11-12 11:10:07'),(9,38,70,3,NULL,'2010-11-12 11:12:45'),(10,38,69,3,NULL,'2010-11-12 11:12:55'),(11,38,74,3,NULL,'2010-11-12 11:13:05'),(12,38,71,4,NULL,'2010-11-12 11:14:50'),(13,38,67,5,NULL,'2010-11-12 11:15:36');
UNLOCK TABLES;
You're Welcome, Vito. It was my very first tutorial to ZC so it pleases me to no end that it was clear and concise. Of course, if they decide to remove the HST, we'll have to revisit this tutorial.Quote:
Originally Posted by vito
I'm trying to build some Karma points, so if you found the post handy, add some positive energy.
Happy Zenning, everyone.
I hope this is in the right area, I apologize if it is not. A general question for us Canadians...
in a situation where your province has an HST in place, and you've configured the taxes accordingly, how do you deal with customers that you have that were previously PST exempt? Do they now get a partial exmption on the provincial portion of the HST? How do you set this up so those customers don't get charged the provincial portion of the HST (only the GST)?:blink:
it doesn't work like that... you charge them the HST just like you would have charged them GST before. To be clear... say it was BC. You previously charged them 5% GST but did not charge them the 7% PST. Now you DO charge them the full 12%HST because the WHOLE thing is a federal tax.
What a lot of retailers are doing is charging the full amount and leaving the client to file for a refund of the PST portion. You can assist them by providing a link to the form and the gov't page thAt relates to it. Have a look at http://cra.gc.caQuote:
Originally Posted by highlander
I don't think that's the correct way to look at it either. For (most) all intents and purposes, there is no "BC portion". Of course there could be some exceptions in some particular industries/products, but for the most part - if you're selling "stuff" like 99% of the stores out there, then there IS NO PST and no "provincial part" of the tax. The only tax is the HST. You collect the full HST from everyone.
Who would be "exempt" anyway? Are you selling to a business that previously did not pay PST? They do now pay the full HST and they get the full HST back on their return (this is actually the whole point of switching to HST). Are they of native status? Well, i don't think that applies since they have to show you their status card and I don't know how they can do that over the net... but in any case, they're exempt fully and not just from a portion. Is it children's clothing in BC or something similar to that? OK in that case I don't know. I don't know how that would work online since in retail you have to sign something. In that case, I imagine newagekat is correct and you leave it to the customer to make a claim if they have such a claim.
More details on what or you are assuming would be "exempt" would allow for more research and a better answer.
- Steven
If you haven't selected one yet, I'd recommend CANADA POST.
Quote:
Originally Posted by djbelize
My bad...I meant to say GST ( but the native issue still applies now that I think about it when using online credit card processing and/or a virtual terminal). Mistakes happen when you're red-eyed and tired. :sleep1:
For instance, when selling to DND. They are GST exempt. In the past, they would tell me their exemption number and I would not have to charge the GST.
Small business with razor-thin mark-ups. Every little bit helps.
Quote:
Originally Posted by s_mack
I am gone through the postings on page 25 & 26 and I have set up my taxes in Zen Cart using the Aug 10th, 2010 posting by 'newagekat' (thanks for the updated info!). This is in preparation for registering with the federal government.
Now, I admit I really don't have a good grasp of what I have just done - and because of that I am not sure the steps I need to take to accomplish the following...
For now, I don't want to charge any taxes on the products (selling Canada-wide) but I do want to collect shipping taxes since I have to pay HST on postage here in Ontario. Would it be possible for someone to explain how I can accomplish this?
TIA
a.h.
You're going to get yourself into trouble if you start playing the "collect on some but not on others" games. If you're collecting tax then collect tax. If you're not, then don't. I can't see any way at all that you can collect just on shipping and not on your products.
IF you are operating as a business, then you collect tax for your goods and shipping and you pay tax on your inputs and shipping. How it washes out at tax time depends on if you spent more or sold more.
IF you are NOT operating as a business of any consequence (and that's OK - I think there's a $30,000 threshold where you don't have to register/collect) then you do NOT have to collect NOR remit taxes, but you still pay on everything. That's your choice as a very small business.
But its all or nothing and you can't pick and choose. If you are choosing to absorb the taxes then you must absorb all the taxes, including on your shipping costs and you can NOT collect taxes to recover that unless you register with the gov't for a tax ID. Once registered, you MUST charge and collect taxes on all applicable goods and services (your stuff plus shipping) and you MUST remit that at the end of the year/quarter/etc.
Thanks for replying, s_mack.
I have just moved from BC and when I ran my internet business there I only collected the PST from my BC customers - I did not register for the GST because I was under the threshold. I had the cart set up to collect PST from my BC addresses only. The cart has always used the Canada Post shipping module. However, I am not even sure tax was collected on the postage unless it was included in the quote from CP.
Now that I have moved to Ontario I am debating whether to wind the biz down or register and then have to collect all the taxes. In the meantime, I have removed the tax class from the products but I am being dinged the HST at the post office which is why I was wondering if it is possible to set the cart to collect the HST on shipping. It just seems lately the shipping price coming back from CP has been underestimating the actual cost and it looks like it is short on the taxes. I was only hoping to set the cart so that it was reflecting the actual cost of shipping. I suppose I could increase the "handling" costs within my biz CP profile to cover this shortfall - which might be the way to go.
Thanks for you help.
a.h.
Changing the "handling" fee inside my Canada Post client profile has helped to cover the shortfall. Of course, the fact that my profile still had my BC postal code as my "warehouse" location didn't help matters much. Okay, the minor shipping cost problem has been solved. Moving on.
a.h.
Yes, adjusting the price is the appropriate way to go. Collecting a tax on any part of your sale without having registered would be a big mistake.
Hi Dr Byte,
I just searcherd and found this thread, I wanted to say thank you for this step by step tutorial before I start off with my modifications to continue the oppression to all the poor Canadians.
But I guess its better to collect the taxes from the buyers instead of the government charging me if they ever audit me hehe
You always come through!! Thanks again :hug:
If a Status Indian presents an ID, you must rebate the provincial portion of the HST.Quote:
Originally Posted by s_mack
Over the Internet, I'm assuming they would have to pay the full amount and apply for a rebate directly to the government.
This info is regarding Ontario, but I know there is a countrywide exemption for Status Indians: http://news.ontario.ca/rev/en/2010/0...s-indians.html
Has anyone had to setup their cart post-HST with point-of-sale rebate items? http://www.rev.gov.on.ca/en/taxtips/hst/pdf/09.pdf
I've tried it but my cart is charging 0% on those items. :(
Thanks for you time on this - much appreciated!
Dr. Byte, An informative post !
I don't see anything in here about taxes for the 13.5% tax in Quebec, 10% in Sask or 12% Manitoba. Am I missing something?
Those provinces still charge both GST and PST. I believe you are responsible only for collecting the GST portion, unless your store is located in one of them. Hope that helps.
Colleen
Dr. Byte...something peculiar...
I've configured the taxes as per the instructions and consulted the "modified instructions" in this thread...and it seems to be working well...however I just had a sale to Alberta (I'm in Ontario) and it charged 0 tax!? I'm confused as to what went wrong. Help?:frusty:
small correction...my bad....on the invoice under the tax column it says none! for all items,
however I noticed that lower down on the invoice it does say GST for products and for shipping and the amount is correct. What have I done wrong. This appears on al invoices by the way regardless of province.:wacko:
Quote:
Originally Posted by highlander
Dohhh...I guess i posted this in the wrong thread. Sorry everyone.
Hi there,
I'm in Ontario and trying to set up an additional Tax Class for Children's Clothing which applies GST only (PST exempt item - a Point-of Sale Rebate) for GST zone and HST zone.
If I create a Tax Class called "GST only Class" (with Description: GST only items) for example, then do I need to create a new Zone covering all Canadian Provinces since I need to create a Tax Rate indicating 5% for all provinces as Zone? How is everybody setting this type of products?
Also, if I am in Ontario, do I need to set HST zone just for Ontario separate from HST Zone -NB, NL (or it is OK to combine those three as one HST Zone)? I see both way in this thread and just want to know which way is better for people in Ontario.
Any help will be appreciated. Thanks :smile:
Hi there,
I solved the above problem next day and everything is working great. :D
Now, I am not sure this is right place but it is Canada Tax setting/zone question so please help. I would really appreciate if someone could help me to keep all the Canadian Tax settings intact while restrict countries to only Canada. My store is almost complete and soon it will be a "LIVE" store. My Canadian Tax setting is done and working great but now I need to figure out how to restrict countries to only Canada so I can ship to Canadian customers only. When I searched, I figured there are 2 ways to do it and first option is to create a "new zone" called "Canada"
Details: Create a new zone "Canada" and insert the new Zone Definitions with sub-zones (10 provinces and 3 territories) under it, enter the new zone to your shipping module (in Shipping Zone). When I tried this, extra "GST" appears (for Example, for ontario customers, tax will appear as GST, HST for item and HST for shipping) because the Tax setting is now messed up...
(Second option - using phpAdmin and delete countries - is not my choice because I read Dr. Byte's advise - not to delete countries - in several threads and besides, if I run into problem after deleting them, I will be completely lost... sorry for mumbling about the off topic)
Anyhow, it will be great if anybody could let me know if there is anyway to "shift" or adjust tax setting so I can create new zone for "Canada only shipping" and still I can set the Canadian Tax setting right (or point me to right direction, thread).
Thank you in advance :D
Taxes will only be applied to Canadian destinations, so you don't have to do anything.
Why would you not want international customers?:dontgetit
Well, I have registered my trademark in Canada but not internationally for one reason and I want to focus on Canadian customers at first. :smile:
My understanding is that Canadian Tax setting works because the zones for GST, HST are created and each one is drill down to sub zones with each regions. I've done so and working perfect now. My dilemma is that If I want limit the country to only Canada by creating new "Zone" (let's say, "Canada only shipping") and create sub-zones (all prov.and terrt.), then that original structure is well, broken...
I looked at other threads and searched but I think I will end up deleting all other country through phpMyAdmin...
Thank you so much for this tutorial, you have kept me from tearing out all my hair. I do have one question though regarding shipping taxes. Is there a reason why under tax rates there are 4 product tax rates but only 3 shipping tax rates? Should there be a "GST Shipping Class" for the BC HST Zone as well? Or is there something I'm missing? I hope this makes sense.
Thanks in advance
Eric
Correction to post #250
The shipping taxes were missing. Here's the corrected versionQuote:
I followed the instructions from newagekat (instructions as of July 1 2010) then did a dump of the affected dbase records. If you import what follows into your database, this should take care of steps 1-4 inclusive assuming you've done no other tax configuration yet.
NOTE: this also assumes the dbase prefix is "zen_" which is easy enough to change with a search and replace in the code below
Code:--
-- Dumping data for table `zen_geo_zones`
--
LOCK TABLES `zen_geo_zones` WRITE;
INSERT INTO `zen_geo_zones` VALUES (2,'Canada GST Zone','GST (Except NB, NL, NS, ON, BC)',NULL,'2010-11-12 11:07:32'),(3,'Canada HST Zone - NB, NL, ON','HST (NB, NL, ON)',NULL,'2010-11-12 11:12:12'),(4,'Canada HST Zone - NS','HST (NS)',NULL,'2010-11-12 11:13:48'),(5,'Canada HST Zone - BC','HST (BC)',NULL,'2010-11-12 11:15:19');
UNLOCK TABLES;
--
-- Dumping data for table `zen_tax_class`
--
LOCK TABLES `zen_tax_class` WRITE;
INSERT INTO `zen_tax_class` VALUES (2,'GST/HST/PST Class','All taxable goods',NULL,'2010-11-12 11:16:43'),(3,'GST/HST Shipping Class','GST/HST on shipping within Canada','2011-07-22 12:00:03','2010-11-12 11:17:33');
UNLOCK TABLES;
--
-- Dumping data for table `zen_tax_rates`
--
LOCK TABLES `zen_tax_rates` WRITE;
INSERT INTO `zen_tax_rates` VALUES (2,2,2,1,'5.0000','5% GST',NULL,'2010-11-12 11:21:21'),(3,3,2,1,'13.0000','13% HST (NB,NL,ON)','2010-11-12 11:22:47','2010-11-12 11:22:33'),(4,4,2,1,'15.0000','15% HST (NS)',NULL,'2010-11-12 11:23:31'),(5,5,2,1,'12.0000','12% HST (BC)',NULL,'2010-11-12 11:24:13'),(6,2,3,1,'5.0000','5% GST Shipping','2011-07-22 11:46:06','2011-07-22 11:38:17'),(7,3,3,1,'13.0000','13% HST (NB, NL, ON) Shipping','2011-07-22 11:46:31','2011-07-22 11:39:28'),(8,4,3,1,'15.0000','15% HST (NS) Shipping','2011-07-22 11:46:42','2011-07-22 11:40:21'),(9,5,3,1,'12.0000','12% HST (BC) Shipping','2011-07-22 11:46:54','2011-07-22 11:41:47');
UNLOCK TABLES;
--
-- Dumping data for table `zen_zones_to_geo_zones`
--
LOCK TABLES `zen_zones_to_geo_zones` WRITE;
INSERT INTO `zen_zones_to_geo_zones` VALUES (2,38,66,2,NULL,'2010-11-12 11:08:05'),(3,38,68,2,NULL,'2010-11-12 11:08:22'),(4,38,72,2,NULL,'2010-11-12 11:08:42'),(5,38,73,2,NULL,'2010-11-12 11:08:56'),(6,38,76,2,NULL,'2010-11-12 11:09:09'),(7,38,77,2,NULL,'2010-11-12 11:09:54'),(8,38,78,2,NULL,'2010-11-12 11:10:07'),(9,38,70,3,NULL,'2010-11-12 11:12:45'),(10,38,69,3,NULL,'2010-11-12 11:12:55'),(11,38,74,3,NULL,'2010-11-12 11:13:05'),(12,38,71,4,NULL,'2010-11-12 11:14:50'),(13,38,67,5,NULL,'2010-11-12 11:15:36');
UNLOCK TABLES;
Hello Everyone, I am new to zen card it's been 3 weeks now since i try to find some help on setting up the tax on my store i am in Quebec i follow the guide from this link https://www.zen-cart.com/tutorials/index.php?article=75 but i am unable to set up the TVQ well i don't know how if anyone with a knowledge of a Quebec store be so kind and help me out please
PS. i did search all the threads but just can't find any info on this TVQ for Quebec.
I finally understand how to set up the Canadian Tax on a Quebec store. after i was done i slap myself :bangin: 'cause it was very easy :clap:Quote:
Originally Posted by HF509
Thank you Zen Cart for this tutorial https://www.zen-cart.com/tutorials/index.php?article=75
Hello...can anyone tell me why i am seeing all of my tax zones listed upon checkout please? This is that i see :
NS TAX 15% + Sales Tax + AB TAX 5% + BC TAX 12% + MB TAX 5% + NB TAX 13% + NL TAX 13% + NT TAX 5% + NU TAX 5% + ON TAX 13% + PE TAX 5% + SK TAX 5% + QE TAX 5% + YT TAX 5%:
Any help would be greatly apprecated!
Follow the instructions posted at the beginning and throughout this thread. You clearly did not.
Hello, everybody,
Can you advice how to set Taxes part in Administrator back-end for a business that is not required to collect taxes (below threshold $30,000), not for goods, not for shipping?
Appreciate your help.
Helen
Why are you setting up taxes if you are not registered or required to collect ?
:) To be sure that customers will be not charged with taxes...Quote:
Originally Posted by newagekat
And seriously, if I understand your answer right, if I leave Tax part in Administrator back-end alone, without any messing with defaults, then taxes will not be charged, not for goods, not for shipping too?
Sorry for making myself unclear.
Helen
If you don't set up taxes then your customers won't get charged. Be sure to set the sample taxes to 0. These are the samples that come with zc
Thank you, this is what I was looking for.
Appreciate your help.
Helen.
Hi
After a lot of searching etc, I have a zencart store in Quebec working correctly with all tax setups etc - I have attached all the settings/instructions that work on my site - which may be of help to you. :smile Attachment 10658
No files to upload, zip safe to open - just a read me text file & image.
NB: This is for version 1.5 - if you are using version 1.3.9h (then don't apply the FIXES to those 2 files)
I follow your setup tax for canada. But I try order get this as follow:Quote:
Originally Posted by DrByte
sub-tatal $12.99
$7.89Canada Post (Regular, 2012-07-25):
$2.18HST#804693150 RT0001 + 5.0% GST#804692150 RT0001 + 8.0% PST (Ontario):
$0.00HST#804693150 RT0001:
$0.005.0% GST#804692150 RT0001:
$0.008.0% PST (Ontario):
$0.005.0% GST on shipping:
$0.008.0% PST (shipping):
$23.06Total:
the tax not come out I don't know why?
I am in Quebec and having trouble getting both the QST and GST to calculte, as provincial tax laws require.
The problem seems to be related to having 2 tax calculations. If I delete one of the taxes, so that, say, there is only the 5% GST, it calculates and displays correctly. But I need 2 tax calculations.
So I add a second rate for Zone = Quebec, same Tax Class, and with the different Tax Rate. Now when I go to Checkout for a shipment to Quebec, the two tax lines are shown, but no calculation - the tax amounts are both $0.00. For the life of me I can't figure out how to make the taxes calculate when there are 2 of them.
I know the individual taxes are correct, since when I delete one Tax Rate, the remaining one calculates correctly. Show Split Tax Lines is set to True, so they are displaying correctly. Just not calculating when there are 2 Tax Rates.
What am I missing here?
Just to add a detail, using compounding Tax Rates is not necessary. The tax rules are 5% GST applied to the SubTotal, then 9.5% QST applied to the SubTotal+GST. However, the latter is the same as 9.975% QST applied to the SubTotal, with the SubTotal, 5% GST and 9.975% QST then arithmetically added to arrive at the total. So it can be either 9.5% QST compounded on 5% GST or 9.975% QST arithmetically added to 5% GST.
I'm going to add that this may be a possible bug in version 1.5, as it was working correctly in 1.3.9.
I've found the same issues with my current testing.
Ray
In an earlier thread in this post I uploaded a zip file with all the settings that I used to configure the taxes for Canadian Store in Quebec - mine works as this was on version 1.5. If you read my notes (text file) - there were 2 fixes that I had to apply for version 1.5Quote:
Originally Posted by RayDube
FIXES
4A - Compound tax was not working correctly so I applied the following changes to includes/classes/order.php
REMEMBER TO ALWAYS MAKE A BACKUP OF YOUR FILES BEFORE APPLYING ANY CHANGES!
- open includes/classes/order.php and uncomment the if statement on line 523:
Before = if ($taxDescription == $products_tax_description)...
After = //if ($taxDescription == $products_tax_description)...
- and replace:
Code:
$taxAdd = zen_calculate_tax($this->products[$index]['final_price'], $this->products[$index]['tax']) * $this->products[$index]['qty']
+ zen_round(zen_calculate_tax($this->products[$index]['onetime_charges'], $this->products[$index]['tax']), $decimals);
with this taken from v1.39:
Code:
$taxAdd = zen_calculate_tax($this->products[$index]['final_price']*$this->products[$index]['qty'], $taxRate)
+ zen_calculate_tax($this->products[$index]['onetime_charges'], $taxRate);
FIXES
5A - Split Tax Shipping and descriptions were not working properly for Compound tax so I applied the following changes to includes/module/order_total/ot_shipping.php
REMEMBER TO ALWAYS MAKE A BACKUP OF YOUR FILES BEFORE APPLYING ANY CHANGES!
- open include/module/order_total/ot_shipping.php and uncomment the following code on line 21:
Before = unset($_SESSION['shipping_tax_description']);
After = //unset($_SESSION['shipping_tax_description']);
- on about LINE 54 look for if ($shipping_tax_basis == 'Billing') {.....
ADD THE FOLLOWING JUST ABOVE THIS - at about line 50
//Begin SplitTaxLines modification
//--------------------------------
if (SHOW_SPLIT_TAX_CHECKOUT == 'false')
{
- on about LINE 78 look for if (DISPLAY_PRICE_WITH_TAX == 'true') $order->info['shipping_cost'] += zen_calculate_tax($order->info['shipping_cost'], $shipping_tax);
ADD THE FOLLOWING JUST BELOW THIS - at about line 79
} else {
//split the taxes
if ($shipping_tax_basis == 'Billing') {
$shipping_tax = zen_get_multiple_tax_rates($GLOBALS[$module]->tax_class, $order->billing['country']['id'], $order->billing['zone_id']);
$shipping_tax_description = zen_get_multiple_tax_rates($GLOBALS[$module]->tax_class, $order->billing['country']['id'], $order->billing['zone_id']);
} elseif ($shipping_tax_basis == 'Shipping') {
$shipping_tax = zen_get_multiple_tax_rates($GLOBALS[$module]->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']);
$shipping_tax_description = zen_get_multiple_tax_rates($GLOBALS[$module]->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']);
} else {
if (STORE_ZONE == $order->billing['zone_id']) {
$shipping_tax = zen_get_multiple_tax_rates($GLOBALS[$module]->tax_class, $order->billing['country']['id'], $order->billing['zone_id']);
$shipping_tax_description = zen_get_multiple_tax_rates($GLOBALS[$module]->tax_class, $order->billing['country']['id'], $order->billing['zone_id']);
} elseif (STORE_ZONE == $order->delivery['zone_id']) {
$shipping_tax = zen_get_multiple_tax_rates($GLOBALS[$module]->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']);
$shipping_tax_description = zen_get_multiple_tax_rates($GLOBALS[$module]->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']);
} else {
$shipping_tax = 0;
}
}
//accumulate taxes from array
foreach ($shipping_tax as $tax_entry_index=>$tax_entry_value)
{
$this_shipping_tax_amount = zen_calculate_tax($order->info['shipping_cost'], $tax_entry_value);
$aggregate_shipping_tax_amount += $this_shipping_tax_amount;
$aggregate_shipping_tax_description += " + " . $shipping_tax_description[$tax_entry_index];
$order->info['tax_groups'][$tax_entry_index] += zen_calculate_tax($order->info['shipping_cost'], $tax_entry_value);
$order->info['total'] += zen_calculate_tax($order->info['shipping_cost'], $tax_entry_value);
if (DISPLAY_PRICE_WITH_TAX == 'true') $order->info['shipping_cost'] += zen_calculate_tax($order->info['shipping_cost'], $tax_entry_value);
}
$order->info['shipping_tax'] += $aggregate_shipping_tax_amount;
$order->info['tax'] += $aggregate_shipping_tax_amount;
//preserve aggregate tax descriptions and amounts for session variables
$_SESSION['shipping_tax_description'] = $aggregate_shipping_tax_description;
$_SESSION['shipping_tax_amount'] = $aggregate_shipping_tax_amount;
}
I used these settings and they work:Quote:
Originally Posted by uniline1
I did not include Quebec in the Canada GST Zone - as the store is based in Quebec
Tax Rates
Priority Tax Class Zone Tax Rate Description:
1 GST/HST/PST Canada GST Zone 5.00% 5% GST
1 GST/HST/PST HST Zone - NB, NL, ON 13.00% 13% HST
1 GST/HST/PST HST Zone - NS 15.00% 15% HST
1 GST/HST/PST HST Zone - BC 12.00% 12% HST
2 GST/HST/PST PST Zone - QC 9.50% PST (NB Priority 2 = compounded)
1 GST/HST/PST PST Zone - QC 5.00% GST
1 GST on Shipping HST Zone - BC 12.00% 12% HST
2 GST on Shipping PST Zone - QC 9.50% PST (NB Priority 2 = compounded)
1 GST on Shipping HST Zone - NS 15.00% 15% HST
1 GST on Shipping HST Zone - NB,NL, ON 13.00% 13% HST
1 GST on Shipping PST Zone - QC 5.00% GST
1 GST on Shipping Canada GST Zone 5.00% 5% GST
Screenshot attached of what mine comes out like - version 1.5 Attachment 10907
I did look over your solution but I didn't think it should be necessary to make significant changes to the code when all that is necessary is to get two taxes calculating. That's surely meant to be a basic functionality that shouldn't need more than the right settings.
I applied those code changes for v1.5 if you are using v1.3 then you don't need to.Quote:
Originally Posted by uniline1
Try using this module for Canadian taxes - just recently updated and works.
If you can't see the link go to: Plugins and then search for Canadian Taxes and it will come up.
This is the proper way to setup Canadian Taxes. V.1.0
Please choose the province in which you do business and run ONLY that SQL file. They have been separated and altered to be accurate as of July 1st 2012.
Either open and run in your Zen Cart Administration "Install SQL Patch" utility located under 'tools' or run in phpmyadmin.
PLEASE NOTE:
BACKUP YOUR DATABASE FIRST!
These SQL files will remove all existing taxes and zone definitions. It is assumed that you are downloading this module because your store taxes and zone definitions do not work anyway. It is purposely done this way to clean up the incorrect settings that would remain otherwise.
If you require additional zone definitions for shipping, you will need to add them in again after running this SQL file.
There is a chance that you may have set your products to a tax that may have had a different ID associated with it. In this case we have provided the below SQL statement to globally change all of your products to use the taxes that you are going to install.
So to be clear run this statement after you run your Tax setup SQL.
UPDATE##products##SET##products_tax_class_id=1;
Qdixon - Quentin Dixon
GeekHost.ca
Two notes Catherine.
First, in Quebec, you are still required to pay GST, so yes, Quebec does need to be included in the GST Zone.
Second, your code modificaitons states:
Quote:
- open includes/classes/order.php and uncomment the if statement on line 523:
Before = if ($taxDescription == $products_tax_description)...
After = //if ($taxDescription == $products_tax_description)...
However, the "After" note shows the line commented out, rather than "uncomment" as you instructed.
Third, I agree with uniline, this is a feature that is not working correctly in the latest version of the script, so should be considered a bug.
Ray
You are 100% correct - I will correct that wording - should say COMMENT OUT, not UN COMMENT.Quote:
Originally Posted by RayDube
***Please note that the fixes should say COMMENT OUT - not UNCOMMENT.Quote:
Originally Posted by gandalfsmith
Hello Catherine,
Perhaps the text attachment was a little more detailed, but the notes you've copied here cause me some concern.
First you say to comment out the if statement with regards to the tax description (After = //if ($taxDescription == $products_tax_description)...) But then ask us to edit the contents of that if statement (which we just commented out)
I haven't reviewed any further, thought maybe I was missing something.
Of course, I'd like to know where the formula for the tax calculation is, to see if there is a difference in that function between 1.3.9 and 1.5 to see if there the reason for the changes between the two versions, as I'm starting to think that there is where the change should be made.
Ray