Multiple Sales Taxes Canada

[featherlane]

I have been trying to get the following for checkout - example:

 

merchandise Total: 1000.00

Shipping + 10.00

Fed tax (GST) 5% + 50.50

Prov tax (QC) 7.5% + 78.75 (that is: based on the SUM of above - compounded)

 

All federal and provincial Taxes are zone based (country & Province) and dependent on the the 'ship-to' address.

GST, HST, and any provincial tax rate could be used.

This is the model required for Canada, any province,

 

Does anyone have this implemented?

 

I have tried to fix this in order.php but can't trace the parent module which assembles the print line of the invoice, nor do I fully understand the scope of the "isset" switch. (bloody php newbie...) :rolleyes:

 

Would appreciate a helping hand or a pointer to existing code which does this.

[Guest]

I just started to tackle the same problem.

I will let you know how I made out.

The tax solutions worked that was provided.

Now it's putting things on separate lines.\

[ken0306]

I have been trying to get the following for checkout - example:

 

merchandise Total: 1000.00

Shipping + 10.00

Fed tax (GST) 5% + 50.50

Prov tax (QC) 7.5% + 78.75 (that is: based on the SUM of above - compounded)

 

All federal and provincial Taxes are zone based (country & Province) and dependent on the the 'ship-to' address.

GST, HST, and any provincial tax rate could be used.

This is the model required for Canada, any province,

 

Does anyone have this implemented?

 

I have tried to fix this in order.php but can't trace the parent module which assembles the print line of the invoice, nor do I fully understand the scope of the "isset" switch. (bloody php newbie...) :rolleyes:

 

Would appreciate a helping hand or a pointer to existing code which does this.

 

There will be 3 step to setup your tax in Locations / Taxes page

Step A setup your Tax Zones

 

1. create your PST Zone

only insert the province your store local in.

2. create your GST Zone

all provinces need have to in there.

 

Step B setup your Tax Classes

 

Step C Setup your Tax Rates

1. GST/PST Class PST Province Zone = 7.5%

2. GST/PST Class GST Canada Zone = 5%

 

This setup will works.

 

When customer who is live in the province order goods from your site, the tax will be 5% + 7.5%

When order coming from out of the province, the tax will be 5%

when order coming from state, which is not in neither zone, the tax will be 0%.

you can trying to see my current project on the tax setup. the url is www.tjskids.net.

ken

[rickdeis]

There will be 3 step to setup your tax in Locations / Taxes page

Step A setup your Tax Zones

 

1. create your PST Zone

only insert the province your store local in.

2. create your GST Zone

all provinces need have to in there.

 

Step B setup your Tax Classes

 

Step C Setup your Tax Rates

1. GST/PST Class PST Province Zone = 7.5%

2. GST/PST Class GST Canada Zone = 5%

 

This setup will works.

 

When customer who is live in the province order goods from your site, the tax will be 5% + 7.5%

When order coming from out of the province, the tax will be 5%

when order coming from state, which is not in neither zone, the tax will be 0%.

you can trying to see my current project on the tax setup. the url is www.tjskids.net.

ken

Hi Ken

 

1./ Couldn't get on your site. It requires a logon/pswd?

 

2./ Which is the module to load that will handle the tax ?

 

3./ Is HST handled as a function of pst + gst?

 

Rick

[Guest]

Rick,

 

Have you tried this ?

 

 

http://addons.oscommerce.com/info/5871

 

 

 

 

Chris

[rickdeis]

There will be 3 step to setup your tax in Locations / Taxes page

Step A setup your Tax Zones

 

1. create your PST Zone

only insert the province your store local in.

2. create your GST Zone

all provinces need have to in there.

 

Step B setup your Tax Classes

 

Step C Setup your Tax Rates

1. GST/PST Class PST Province Zone = 7.5%

2. GST/PST Class GST Canada Zone = 5%

 

This setup will works.

 

When customer who is live in the province order goods from your site, the tax will be 5% + 7.5%

When order coming from out of the province, the tax will be 5%

when order coming from state, which is not in neither zone, the tax will be 0%.

you can trying to see my current project on the tax setup. the url is www.tjskids.net.

ken

Hi All

Just installed OSC 2.3.1 plus the Canada Post shipping and Canada tax modules and am trying to work things out. I am in BC and have to charge taxes. A few strange things are happening which I will list later on but first here are my settings:

Tax Zones

 

Tax Zones

British Columbia HST

Country-------- Zone

Canada ---------- British Columbia

 

Tax Zones

Canada GST

Country-------- Zone

Canada ---------- All Zones

 

Tax Classes

 

Tax Classes

Non Taxable Goods

Taxable Goods

 

Tax Rates

Priority ---- Tax Class---- Zone---- Tax Rate

2 --------- Taxable Goods ---- British Columbia HST---- 7.00%

2 --------- Taxable Goods ---- British Columbia HST ---- 5.00%

2 --------- Taxable Goods ---- Canada GST ------------- 5.00%

 

 

All my products are given a Taxable Goods except "gift certificates" which are Non Taxable Goods.

So all looks OK to me.

 

I've set up 3 test purchases to test purchases from BC, other Canadian Provinces and the USA.

 

Here's what happens: (dashes put in by me for readability)

 

Test case 1 is a BC purchaser.(checkout_confirmation.php page)

It shows 17% instead of 12% below the Tax heading.

Products (Edit)------------ Tax --- Total

1 x Unreal Tournament 17.00% --- $22.32

The GST & HST portion of taxes are charged at the proper rate (5% and 7%) on both the product and shipping in the final totals

Sub-Total:------------------$22.32

Flat Rate (Best Way):--------$5.00

HST portion class tax rate:--$1.91

GST class tax rate BC:-------$1.37

Total:-----------------------$30.60

 

 

Test case 2 is a Alberta purchaser.(checkout_confirmation.php page)

It doesn't list the Tax and Total headings nor does it list the 5% tax that should have been charged.

Products (Edit)

1 x Unreal Tournament---------------------------------$22.32

 

This results in no tax at all whereas it should be charged the GST 5% tax

Sub-Total:------------------------------------------------------------------------------$22.32

Canada Post (1 box(es) to be shipped) (Expedited, 2011-02-22): $8.65

-----------------------------------------------------------------------------Total:--------$30.97

 

Test case 3 is a USA purchaser.(checkout_confirmation.php page) Basically it prints the same as test case 2 which is all right as no tax is to be charged.

 

Can anyone tell me what I have done wrong or what I have to do to correct it?

I don't really know php but i can alter the code as well as the next person.

 

 

Regards

 

Rick

[Mrmike]

Rick, did you ever figure out the 17% in BC problem? Im having the same issue.. in my admin Ive set BC at 12% but it calculates it at 17% on checkout

[Mrmike]

Although if I input BC at 7% I see it calculates properly, automatically adding the 5% GST portion of BC's HST.. seems overly confusing

 

im guessing the Module is calculating the Federal tax automatically and we have to add in in provincial for the HST provinces and leave it blank for the GST provinces.

Edited March 14, 2012 by Mrmike

[Mrmike]

But not for Ontario, leading me to belive tha the module is still calculating BC as a GSt/ PST province,,, which it isnt anymore, until March 2013 haha