Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Multiple Sales Taxes Canada


featherlane

Recommended Posts

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.

Link to comment
Share on other sites

  • 1 month later...

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.\

Link to comment
Share on other sites

  • 4 weeks later...
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

Link to comment
Share on other sites

  • 2 years later...

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 1 year later...

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 by Mrmike
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...