Canadian Tax Display

[Guest]

My Canadian Tax Display v1.0 is available in the download's features.

I would like to improve it, then please test it.

The module works like this:

Subtotal : xxx

GST ( 7.0% ) : xxx * 7%

PST ( 7.5% ) : ( xxx + GST ) * 7.5%

Total : xxx + GST + PST

And like this:

If the store and the customer live in the same country AND in the same zone, the module display GST and PST.

If the store and the customer live in the same country but NOT in the same zone, the module display GST only.

If the store and the customer live in a different country the module display no tax.

But someone said me today that each zone in canada must be charged for his own provincial tax. If someone knows exactly how it works I could improve the module with that. !-P

I'm waiting for your comments.

 

Christophe Weber

[The Grinch]

What it comes down to is the other provinces have no way of tracking taxes for out of province businesses. And the Ministry of finance in your province doesn't care about the other provinces. Charge PST and GST for your home province, and only charge the other provinces GST. Just make sure you keep a good record of all out of province sales in case you get auditted.

 

I don't work for the government, so take my advise with a grain of salt. I could be totally wrong, but the above statements make sense. If you want to go by the honor system and pay taxes to each province, that's up to you.

[afterblue.com]

You don't charge provincial sales tax for sales outside of your province.

You also don't charge GST unless you registered for GST account.

 

Saying all that...

Where can I find this canadian tax module for osCommerce?

After seting up my tax zones, osCommerce calculates the taxes but doesn't add them to the Total.

h.e.l.p.

[Guest]

The Canadian Tax Display Module is available in the download section:

 

http://www.oscommerce.com/downloads.php/co...ions,767/type,3

 

I hope you'll enjoy it :D

[afterblue.com]

Hi Christophe,

 

Thanks for such a rapide response,

I am a bit puzzled about the way you calculate taxes

i.e. Ontario has 7% GST and 8%PST calculated on sale price

 

for example:

$100 purchase would have $7 of GST (7%) and $8 of PST (8%)

total of $15 of taxes.

 

Your script seems to calculate things differently unless there's something else I messed up during configuration

[Guest]

I dont think so ...here in Quebec the PST is 8% of the price including the GST so 8% of 107$

 

Regards

[gevans]

I guess the tax laws in Quebec are different as here in Ontario PST & GST on a $100 product would be $115 not $115.56 as your calculations would suggest.

 

I use the Canadian Separate Tax Hack for my store and have had no problems calculating the correct tax for in-province and out-of-province orders.

 

http://www.oscommerce.com/downloads.php/co...ions,662/type,3

[Guest]

Hello,

 

PLease just take some time to try the module before saying something :wink:

 

In the first version of the module afterblue was right, but in the last version YOU CAN CHOOSE IF YOU WANT CALCULATE THE TAXES LIKE IN QUEBEC OR LIKE IN ANOTHER PROVINCE :P

 

Then for Quebec it's pst=(sub+gst)*x%

and for the others pst=sub*x%

 

It's because tax laws are different in Quebec and other provinces in Canada like said gevans.

 

Regards.

[Noctule]

Here is a link to an amendment in BC might clear up this issue for one province.

 

http://www.rev.gov.bc.ca/ctb/publications/...lletins/074.pdf

[afterblue.com]

Christophe,

 

I was able to install your module and realised I missed a detail during my previous attempt. So my appologies :oops:

One more minor issue I face is that I can either:

 

1. setup tax rates for Ontario and Canada and have Tax rate column showing 15% (correct) but then under GST and PST (correct calculations) shows incorrect Tax and correct Total :P

2. or... I can delete tax rates and everything is peachy except Tax column would display 0% tax rate but everything correct at the bottom

 

If I haven't confused you enough, let me know... :lol:

We could start 'Canadian' thread on some BB because there's a number of issues specific to Canadian stores (like UPS shipping, anyone?)

 

Thanks all for your help!

[Guest]

I made this module to use it without tax for any canadian store ( GST and PST should be automatically displayed ). But you can add any other taxes if you live in florida for example. :shock:

Then use no tax with your items... The 0% only appears in the admin order module, customers may never see that ( I think so, I can't really try because I have no store online ) :roll:

 

And no problem with any replies, appologies or not :wink:

 

No I work on another problem: to display a custom text for customers with products... And that's */$&*&?#***##* :evil:

 

Regards to everybody :D

[gnailor]

Hi,

I installed your Tax display and on the confirmation page it displays all the taxes and the total. Unfortunately the total does not transfer through to my payment module. The payment module shows the total of the shipping costs and the product total only. So the taxes are not being added somehow to the 'total'. Have you come across this?

 

Thanks

Graeme Nailor

[email protected]

[Guest]

You're the second one to tell me about that...

Because I have no online store but only on my local computer, I can't try with all payement modules...

I will try to check how to do it working with...

[afterblue.com]

Chris, I have H-sphere based hosting with osCommerce and other goodies.

afterblue.com/internet/hostingplans.htm

I can work something out for you if you're interested :wink:

[/url]

[Guest]

A new version of this module is available and works well with PayPal... Then it would work fine with all payment modules...

 

I'll post it when contributions will be activated again for upload.

[archie2]

The way the taxes work here in Ontario is:

PST (8%) to Ontario Residences

 

GST (7%) to Quebec, Ontario, Manitoba, Sask, Alberta, BC, North Ter, Nunavit, and Yukon

 

HST (15%) to Eastern Provinces.

 

I believe the PST is handled differently in other provinces.

 

 

I still can't get the taxes to work right in the software

I have tried a couple of modules and I must be missing something.

 

Joe.

[Guest]

The way the taxes work here in Ontario is:

  PST (8%) to Ontario Residences

 

  GST (7%) to Quebec, Ontario, Manitoba, Sask, Alberta, BC, North Ter, Nunavit, and Yukon

 

  HST (15%) to Eastern Provinces.

 

I believe the PST is handled differently in other provinces.

 

 

I still can't get the taxes to work right in the software

I have tried a couple of modules and I must be missing something.

 

Joe.

 

The PST for the separate Provinces is:

 

PST

 

BC 7.5 SK 6 MN 7 ON 8 PEI 10

 

The problem I am running in to is that I have to charge the appropriate taxes for the appropriate provinces .. and hopefully have them separated for book keeping purposes. I can have them add up properly with out of the box installation of OSC .. but I can't get them to show on different lines.

[Guest]

You have 2 choices to use different PST for each provinces:

 

1/ With my module GST will be charged for everyone in Canada. Next edit PST with your local values in your province ( for example 7.5 for me in Qc ). That's the part of the module. For other provinces create taxes for each zone separatly like you did before without the canadian module. It will work fine, but the display will be

GST=xxx$

Taxe=xxx$ (Tax will be the local PST)

To change that just edit the langage file and replace 'Tax' with 'Provincial Tax' for example...

 

2/ The second way is to hack my module and add a zone test for each province... It's easy lines look like

 

if ($orderquery3['entry_zone_id'] == $orderquery4['configuration_value']) { /* customer and store in the same zone */

 

add some of them with the choosen zone to replace $orderquery4['configuration_value'])

 

But this second way is boring to do and I have no time yet to change it... Maybe later or when I'll win to super7 and have no more to work to win $$$ :D

[Guest]

You have 2 choices to use different PST for each provinces:

 

1/ With my module GST will be charged for everyone in Canada. Next edit PST with your local values in your province ( for example 7.5 for me in Qc ). That's the part of the module. For other provinces create taxes for each zone separatly like you did before without the canadian module. It will work fine, but the display will be  

GST=xxx$

Taxe=xxx$    (Tax will be the local PST)

To change that just edit the langage file and replace 'Tax' with 'Provincial Tax' for example...

 

2/ The second way is to hack my module and add a zone test for each province... It's easy lines look like

 

if ($orderquery3['entry_zone_id']  == $orderquery4['configuration_value']) { /* customer and store in the same zone */

 

add some of them with the choosen zone to replace $orderquery4['configuration_value'])

 

But this second way is boring to do and I have no time yet to change it... Maybe later or when I'll win to super7 and have no more to work to win $$$  :D

 

Thank you so much .. that is exactly what I needed. I will start workingn on the hack on a dump site as soon as I get this one operational.

 

My Next question is how do I exclude GST for the provinces that do not have it? There are some provinces that do not charge the GST, mainly east coast provinces, would need to exclude themas they have their own wonky tax system .. lol ..

[Guest]

You have 2 choices to use different PST for each provinces:

 

1/ With my module GST will be charged for everyone in Canada. Next edit PST with your local values in your province ( for example 7.5 for me in Qc ). That's the part of the module. For other provinces create taxes for each zone separatly like you did before without the canadian module. It will work fine, but the display will be  

GST=xxx$

Taxe=xxx$    (Tax will be the local PST)

To change that just edit the langage file and replace 'Tax' with 'Provincial Tax' for example...

 

2/ The second way is to hack my module and add a zone test for each province... It's easy lines look like

 

if ($orderquery3['entry_zone_id']  == $orderquery4['configuration_value']) { /* customer and store in the same zone */

 

add some of them with the choosen zone to replace $orderquery4['configuration_value'])

 

But this second way is boring to do and I have no time yet to change it... Maybe later or when I'll win to super7 and have no more to work to win $$$  :D

 

Ok I think I have everything working for the most part.. but I am having a problem with excluding the three provinces that do not use GST. Maybe I can email you or PM you the code that I have hacked .. or even place it here to see if anyone can see where my logic is going wrong. I have got the code working to that it will not display the GST for the NB, NS and Nfld but it is still charging it.

[Guest]

Blarhg!

 

I just downloaded osCommerce and got it working... except for Canadian taxes. I incorporated the above mentioned files, but no PST or GST shows up in the confirmation or is calculated. I did go to the modules and activated them as per the read me and added my GST number - and deactivated and reactived and reentered the GST number - but with no luck. Perhaps I just don't understand this tax zone stuff... is there one 'final' thing I have to do to get the taxes to appear on the confirmation form??

 

Jay

[mike2001]

I installed this contribution too, but the taxes don't show up ?!! :blink:

 

Is this contribution still working with MS2 ?

 

Any help would really apreciated , thanks