Printable View
For all Canadian stores....Effective January 1, 2008, the rate of the GST and the federal component of the HST will be reduced from 6% to 5%. The provincial component of the HST will remain at 8%. This means that the rate of HST will be reduced from 14% to 13%. Please note that the HST applies only to purchases made in or imported into New Brunswick, Nova Scotia, and Newfoundland and Labrador (the participating provinces) and the GST applies to supplies made in the rest of Canada.
I always found it interesting that the gov't presumes we all watch tv or that the news will trickle down to everyone eventually. Thanks for posting because some may not have known. But isn't it a bit odd that for something as important as that, that they don't individually notify GST registered businesses by mail? In a way, I'm glad they don't (waste of paper) but there's probably a lot of small businesses that don't catch the change right away and that could screw up accounting later. Then again, the entire tax system is developed to keep accountants employed :)
Cheers and happy newyear.
- Steven
For the first 2 weeks everything was working fine with the TOTAL including all taxes, but for some reason since last night, CANADIAN TAX calculations have come out wrong...
Tax Class: GST/PST/HST Class
Net Price is set at $139.00 <<< my product
Gross Price ends up at: $157.07 < Stores calculations incorrect
When i change the $157.07 which is incorrect, to 157.63 <CORREECT
the NET PRICE changes to : 139.4867 ????????????
It should be 139.00 + GST 5% 6.95 =145.95
plus PST 8% 11.676= 157.626 = FINAL PRICE $157.63
also my GST and PST taxes numbers which should show up on the invoice does not.. i get a pretty plain jane TOTAL. THATS IT...
:censored: lol
ALSO.. i have no idea how u edit this!
==============
The following SQL statement would be helpful:
--------
Code:
UPDATE products SET products_tax_class_id = 1 WHERE products_model NOT LIKE 'GIFT%';
(you'd need to confirm that the desired products_tax_class_id = 1, first )
================================================== ======
?????????????:wacko:
Umm... you're wrong, its right. $157.07 is absolutely correct. $139 * 1.13 = $157.07
Not sure how you're doing your math, but its wrong. Oh, Actually I see... you are taxing a tax. You do NOT add the PST to the Amount + GST. GST and PST are INDEPENDENTLY calculated on the item amount. The easiest way is to just add the percentages and multiply like I did above.
Anyway, trust me (and the rest of the Canadian accountants) that the shop's method of calculating is correct. It was 2 weeks ago, and it is now.
Cheers.
- Steven
%Quote:
Originally Posted by s_mack
Hi steven.. prefect timing... yes.. I have been told to calculate the taxes as so..
139.00 my product
+ 5% GST 6.95 = 145.95 + 8% 11.676 = 157.63
Been told to add on the 8% PST ontop of the 5% GST including the product total.
other wise 13% equals $157.07
Btw im in Quebec...
perhaps u might know also, why isnt my GST NUMBER or PST numbers i included showing up
currently i only get this...
Sub-Total: $139.00.
Tax: $6.95.
Total: $145.95.
=================================
I do not get the following *btw i do not have shipping set up, since i ship directly from overseas to my clients..
Sub-Total: $69.00
Per Item (Best Way): $10.00
8.0% PST (Ontario) + 7.0% GST # 86179 1655 RT0001: $10.35 <<<<<<<<
7.0% GST (shipping) + 8.0% PST (shipping): $ 1.50
Total: $90.85
You're awesome. This helps a lot.
I am having problems setting up the taxes I live in Saskatchewan and ship across Canada.
I sell two kind of products:
Books (exempt from PST in SK) that need GST in Canada
Books that need HST in Eastern Canada
Courses that need PST and GST in SK
Courses that need GST in Canada
Courses that need HST in Eastern Canada
I set everything up like the first post but unfortunately it doesn't allow me to PST exempt from SK. I know I'm missing a step but don't know what it is.
Any ideas?
:frusty:
Your situation is more complex, but still doable. You'll have to set up extra tax classes I think. When I have more time I'll think carefully about how you need to do it. Maybe DrByte can answer - he seems to be the expert on this :)
thanks! I'll wait for your reply.
I tried adding an extra TAX CLASS called "GST only" and then created a new tax rate for "GST only" and set the tax rate at 5% GST (for SK buying books and audios) but when I tested it I get GST and GST so I deleted it for now.
Currently I have the following set up:
ZONE DEFINITIONS
Canada GST Zone GST (except Eastern Canada: NS, NB, NL)
Eastern Canada - HST Zone NS, NB, NL
Saskatchewan PST Zone PST (only when shipped to Saskatchewan)
TAX CLASSES
GST on Shipping
GST/HST/PST Class
TAX RATES:
GST on Shipping Eastern Canada - HST Zone 13%
GST on Shipping Saskatchewan PST Zone 5%
GST on Shipping Canada GST Zone 5%
GST/HST/PST Class Eastern Canada - HST Zone 13%
GST/HST/PST Class Canada GST Zone 5%
GST/HST/PST Class Saskatchewan PST Zone 5%
Wondering if anyone can help me with the last thread...:frusty:
I really like your set up, but was wondering what do you set the priorities to for each tax rate??
priorities don't really apply in Canada because we don't tax taxes. So set them all to 1. Taxes are applied independently in this country. In some countries, you add one tax to the amount, and then another to that total amount (including the first tax).Quote:
Originally Posted by sn_tobin
I think you should have something like this:Quote:
Originally Posted by blf
ZONE DEFINITIONS
(yours are correct)
TAX CLASSES:
Shipping Tax
Taxable Goods
Books
TAX RATES:
Taxable Goods Canada GST Zone 5.00%
Taxable Goods BC PST Zone 7.00%
Taxable Goods Eastern Canada HST Zone 13.00%
Shipping Tax Canada GST Zone 5.00%
Shipping Tax BC PST Zone 7.00%
Shipping Tax Eastern Canada HST Zone 13.00%
Books Canada GST Zone 5.00%
Books BC PST Zone 0.00%
Books Eastern Canada HST Zone 13.00%
In other words, I think you need to add a "Books" class (and then define rates for it). Then, in your products setup pages make sure you choose the correct tax class! Books get the "Books" class and your courses get "taxable goods" class.
I think that's right... again, I wish Dr.B could confirm as he knows the system way better it seems.
- Steven
Hi,
The above tax calculation of GST and PST for Ontario is not done the right way. The GST is first added to the cost and then the PST is added to the cost +GST. In the calculation shown below:
Shipping to Ontario:
Sub-Total: $69.00
Per Item (Best Way): $10.00
8.0% PST (Ontario) + 5.0% GST #99999 9999 RT0001: $8.97
5.0% GST (shipping) + 8.0% PST (shipping): $ 1.30
Total: $89.27
the tax is taken as 5% of $69.00 = $3.45 + 5% of $69.00= $5.52 which is equal to $8.97 which is not the right tax calculation as done in Canada. It should be 5% of $69.00 =$72.45(69+3.45) + 8% of 72.45= $78.24(72.45+5.79)
Tax on shipping would be 10+5% + 8%=11.34
The total would be 78.24+11.34=89.58.
Indicana
You are 100% incorrect Indicana. Check with an accountant.
We do NOT tax taxes in (most of*) Canada! The 5% and 8% are calculated independently, not compounded as you have it. You have been (illegally) ripping off your customers if that's the way you've been doing it.
If you don't believe me, then check with an accountant or your local tax office. Or just check any receipt you've ever gotten from any company that's likely to do it correctly.
* There are a couple exceptions. Quebec goes back an forth on this over the decades... I'm not sure what they're at right now. Seems to me PEI compounds their sales tax. Ontario DOES NOT!
Here's a source: http://en.wikipedia.org/wiki/Sales_taxes_in_Canada
As you can see, only Quebec and PEI compound taxes. The rest are calculated independently.
Granted, that's wikipedia and not an official source. And I'm the first to acknowledge that wikipedia is a terrible source if you need to be SURE its right, but in this case I know it is :)
- Steven
Quote:
Originally Posted by s_mack
You are right. I just checked with Revenue Canada and they confirmed that you cannot collect tax on tax. Anyway as I am just starting my online sales I haven't ripped off any of my customers. Thanks anyways for the correction.
Hi Zenners,
I followed the Canadian Taxes tutorial to the letter but I've encounter problems I can't sort.
There seems to be a problem trying to get the prices to show correctly once I activate the GST/HSTPST tax class on a product. This is what I'm getting:
Products price (net) $1.5873
Products price (gross) $2.00
This isn't correct. I want the gross to be show as $2 with the GST included to this figure. But 1.5873 plus the GST doesn't make $2.00. Whats going on?
Cheers in advance!
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)Quote:
Originally Posted by Winks
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
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.Quote:
Originally Posted by Winks
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
:-(
http://www.zen-cart.com/forum/attach...0&d=1211677443
http://www.zen-cart.com/forum/attach...2&d=1211678582
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/showpo...27&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
uhh... yeah, but it does that if you set it up the recommended way too.
True. I just didn't think it was efficient to do the extra work of setting up the extra tax rates, zone definitions and tax class.
Well... since "efficient" came up... it would have been a lot more efficient use of time to just set it up that way rather than question it :) And while it is true I can't think of a good reason why it had to be that way, it is proven effective and non-detrimental. To each his own, but if I were setting up a store right now I think I'd go with the full tutorial recommendations.
Isn't that the point of this forum? To help others, as well as ourselves, to better understand and to constantly strive to improve methods and procedures for Zen Cart??
As Albert Einstein said "Any man who reads too much and uses his brain too little falls into lazy habits of thinking."
Over and out.
Yes yes of course :) I just found the "efficient" statement a bit ironic.
[QUOTE=DrByte;198824]You might find this helpful ... it needs a bit of touching-up, but the basic core is there:
########################################
(...)
- 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 PST Zone
- Tax Rate (%): 8.0000
- Description: 8.0% PST (shipping)
- Priority: 1
etc.
Except this doesn't work for Quebec. Quebec PST is 7.5% (not 8%) on top of GST.
The final rate is 12,875% (not 13%). Every time I tried, Zen Cart rounded that DOWN to 12% :oops: That is not acceptable, not any more than rounding it up to 13%.
Plus, it is quite a bugger not to be able to show both taxes separately on invoices. It raises tons of questions i can well do without.
Thanks
Marie-Andree
It doesn't round at all. Do an actual transaction and report the details (and use a relatively large subtotal amount).
I does so round. If I input the actual tax rate for PST on top of GST, that is 12,875%, zencart rounds it DOWN to 12%. If I input 12,88%, same difference. It's only if I iput 12,9% that it behaves ok and takes it.
The problem is, I don't want to have to reconfigure my accounting software just for the sake of zencart....
So if you have a $1000 item, you're saying it shows the tax as $120.00 instead of $128.75? (don't guess... try it). If so, you're doing something wrong with the setup I think.
Wait a minute... are you INPUTTING a rate of 12.875% (or 12.88 or 12.9)? That's not how you're supposed to do it if that's the case. You're supposed to put the two taxes in separately and let it do the calculation.
- Steven
Coming in late on this and I am somewhat new to Zen Cart but I noticed in the "My Store" menu, there is a field for "Tax Decimal Places". I have mine set to zero because, as I understand it, "Pad the tax value this amount of decimal places" would suggest rounding. Therefore, if I set it to 1, it would round up. Is this correct or have I been using Excel too long? :wacko:
If I am correct, this may be MarieAndree's problem. I will test it once I finish setting up my site.
Matthew
Hmmm.... that's a good question/point. I don't recall doing anything with that (or even seeing it) so I would suggest that you leave it at whatever the default is as it was probably implemented for a specific situation that likely doesn't apply to most people's situations. I'm not sure what the default is... but "2" would make the most sense to me.
You know, I think it is for currencies that use more than 2 decimal places. If it does have to do with rounding then I think you have it backwards... 0 or 1 would force it to round unnecessarily whereas 2 would be correct and more would be that much more accurate (but likely unnecessary).
- Steven
Again, I am more used to Excel's "ROUNDUP" and "ROUNDDOWN", whereby the number refers to the number of decimal places it rounds to. Therefore, if you were to put 3 in this field, I am wondering if that will solve the problem.
On the other hand, 5% and 7.5% equals 12.5%. If the tax is supposed to be 12.875%, that means that it is COMPOUNDED as Net Price x 1.05 (GST) and THEN the product of that is multiplied by 1.075 (PST). This suggests different prioritizations, no? In MarieAndree's example, she has both priorities set to 1. The Admin panel states, "Tax rates at the same priority are added, others are compounded." Therefore, she needs to have GST set to Priority 1 and PST to Priority 2, no?
Sorry if I am off base, but new to this and trying to learn as I fix my own site and hopefully help others in the process.
Matthew
You would only compound GST and PST if you are in Quebec/Maritimes ... but, wouldn't you just use HST instead then?Quote:
Originally Posted by matthewr
The rest of Canada NEVER compounds GST and PST.
And, the tax-padding value is used only for padding the displayed tax output to the specified number of spaces, by adding zeroes as needed to make up the number of decimal places entered. It has nothing to do with precision of calculations. It is for display only, after all calculations are done.
DrByte,
Thanks for the response and for confirming my suggestion. Quoting MarieAndree:
"Except this doesn't work for Quebec. Quebec PST is 7.5% (not 8%) on top of GST. The final rate is 12,875% (not 13%). Every time I tried, Zen Cart rounded that DOWN to 12% That is not acceptable, not any more than rounding it up to 13%."
So this was all about Quebec specifically. In Quebec, HST is not used. It is separate GST and PST items. Therefore, you could set up a separate Tax Zone for Quebec with a Tax Rate of 12.875% but this number comes from a compounded PST and GST so, since the program can handle compound taxes, why not?
Thanks for clarifying the tax padding thing. I guess it works differently than Excel. :cool:
Matthew
regarding GST
I just spoke with Revenue Canada agency concerning taxes and my specific question was what tax to charge Canadians if the shipment comes to Canada from abroad like USA.
Agent told me that I don't charge them Federal tax.
and when I asked what about provincial taxes she said I'd have to contact provincial tax dept. to find out..
so no GST for merchandise coming to Canada from US.
Yeah, no kidding. If you are an american (and that is the only way that statement made sense) then of course you do not charge a Canadian any tax at all.
Tax collection 101: You collect tax on BEHALF of the country and/or province that BOTH you and your customer reside in. So if you are in Canada you collect Canada (federal) tax from ALL Canadians. In addition, if you are in a certain province you collect that tax from all people living in that province. The exception (and it isn't really an exception technically) is that ALL Canadian businesses regardless of province must collect HST from the customers of provinces that it applies to.
But if you are NOT in Canada then you do not collect ANY tax from ANY Canadian EVER. That happens at the border when the goods come in and it is between the customer and their government.
- Steven
Unless you're meaning this: you are a Canadian and you are selling goods to Canadians, but you don't actually have those goods and instead they are being drop-shipped from America? If that's what you meant, then the agent you spoke with didn't understand. Because in that instance you DO collect taxes the same as if you shipped it from your location. It doesn't matter where the goods actually arrive from... it is where the customer bought it from (you) and where they live.
- Steven
Well yes I am canadian and I asked the question about taxes on merchandise originating from USA bought by canadians and shipped from USA to Canada.
I made it clear to her many times verifying answer from many angles. and also made it clear that I was talking about drop shipping.
she said that I should not charge federal tax on those goods.
Infact i dont reside in canada atm but in Germany.
Also regarding paying GST as a business I was told by the same rep. that I dont have to declare GST unless I make more then 30k annual sales.
im trying to setup taxes now and slowly getting lost..
my dropshipper will always send products from USA to USA and Canada.
I setup taxes according to the guide on first page.
As I understand Zencart will calculate taxes based on store location and delivery address. I guess I can enter dropshipper Zip code for shipping charge calculatings sake.(?)
when I add new product which Tax Class I shold select ?
GSt on shipping, GST/HST/PST or there's one default came with zencart Taxable Goods.
Also do I charge any taxes to americans?
Sorry if the question is ubernoobish.
Simple. If you are in Germany YOU DO NOT COLLECT ANY TAXES FROM CANADIANS!!! Or Americans. No tax at all, period.
And that $30K rule is as follows: You can CHOOSE not to collect or remit any GST if you ANTICIPATE your sales to be under $30,000 per year. If you DO collect ANY GST at any point in the past you MUST register, collect, and remit all appropriate taxes. If your sales end up being > the limit you have to REMIT taxes for ALL sales, even the ones you didn't collect on, which would SUCK. But if you know you are under then don't register, don't collect, and don't remit.
Again though... if you're in Germany you don't have any right or responsibility to collect taxes anyway so just leave it alone.
Also again, you/she are wrong. If you are in Canada and your drop shipper is in the US you DO collect taxes on the goods. It is a moot point because you're in Germany, but if the business is in Canada and the customer is in Canada than tax is collected REGARDLESS of where the goods come from physically. I know this for a fact and if you think she said otherwise then she didn't understand. But since you're not even in Canada, no wonder she was confused.
- Steven
I think its a bit complicated since my business is registered in Ontario and I have GST number and estore will be based on that.
in addition my receiving bank will be Scotiabank and Im assuming Revenue Canada will want GST to be paid and my personal physical location wont matter. also Ill be coming back to canada in a year or so.
of course it'd be easier for me not to meddle with taxes altogether and select "none" to tax rate brackets when adding a product, but I wanted to setup taxes correctly initially.
so Im not sure what to select when adding a product GSt on shipping, GST/HST/PST or there's one default came with zencart Taxable Goods.
Ok, sorry. You're right - if your business is registered in Ontario and you have a GST number then it doesn't matter where you personally are located. Since you already have a GST number you MUST collect and remit GST (where applicable) regardless of the $30,000 rule. Even if you make 10 bucks, you have to charge, collect, and remit the GST on it because you already registered. The $30k rule is only for those that haven't yet CHOSEN to register for GST. Now you're stuck with it.
Still, nothing changes. You have to treat all the goods you sell as though they came from Ontario regardless of where they physically came from. The POSSIBLE exception to that is this:
If your drop shipper is in another Canadian province, say BC for example, then you MAY have to also collect PST from BC residents. This is because you have to collect provincial taxes from customers of ANY AND ALL provinces you have a physical presence in. I'm not sure, but they may consider a drop shipper as being an extension of your business.
But, I am sure that if your drop shipper is outside of Canada you still have to charge GST (and PST in Ontario, HST in Atlantic) to your customers because they did business with YOU and not the foreign company. HOWEVER, what gets very complicated about this is unless your drop shipper does the paperwork right (and sometimes even if they do it right) your customers are going to get double-taxed because once it comes into the country, customs assumes no tax was paid on it. It gets hairy.
If it is really small time, I'd probably suggest NOT collecting the taxes for those items because the PROPER way to do it is so bloody complicated. Or don't drop ship from the US.
As for your question about setting up the shipping... it is explained at the top of this thread.
Best of luck friend.
- Steven
thanks for info.
I just finished talking to GST dept in revenue canada and was told that GST has to pay person receiving inported goods 5%.
and best way to avoiding a client for Double taxing (at your webstore and at the customs) would be to contact ups or fedex or whoever is delivering and identifying and registering yourself as an "importer".
then courier company will pay GST on your behalf and then I'd reimburse the costs to them.
Yes, exactly. Easier said than done :) But that is right. I would recommend FedEx over UPS (and certainly over DHL - easily the worst company on this planet) but they are more expensive. You'll find doing it this way a hassle unless you're doing pretty good volume - then it is worth it. But yes, that is the correct way to go about it.
- Steven
I decided not to charge GST (untill I start making more then 30k in sales) and canceling my GST number.
I setup taxes as in guide, now how do I remove GST charge? since clients will pay GST at the door to courier company.
It's always nice to re-vistit old threads with solutions, so here goes.....
If you want to display -
SubTotal $100.00
Shipping: $10.00
GST: $5.50
PST: $8.00
Total $123.50
You need to do the following.
1 - Setup all your taxes as discribed at teh top of this thread, BUT ensure that the Descriptions match for those you wish to group together. So if you have GST on Shipping, and GST, the DESCRIPTION field MUST be the same - so GST (5%)
2 - BACKUP includes/modules/order_totals/ot_tax.php
3 - REPLACE the function process() { and all code down to function check() { with the following code (Leave the function check() { line intact.)
That's it. It re-works all your taxes, so that rather than showing tax A + Tax B = $xxx.xx, it now shows Tax A = xx.xx and Tax B = xx.xx. No alterations have been made to how the tax is actually calculated, so this should work with any tax rates, and with any modules you have installed.Code:function process() {
global $order, $currencies;
reset($order->info['tax_groups']);
$tax_values = array();
while (list($key, $value) = each($order->info['tax_groups'])) {
if ($value > 0 or STORE_TAX_DISPLAY_STATUS == 1) {
if (strstr($key, ' + ')) {
$tax_rates = array();
$tax_descriptions = explode(' + ', $key);
foreach($tax_descriptions as $tax_description) {
$tax_rate = zen_get_tax_rate_from_desc($tax_description);
$tax_rates[$tax_description] = $tax_rate;
$total_tax_rate += $tax_rate;
}
foreach($tax_rates as $description => $rate) {
$tax_values[$description] += ($value / $total_tax_rate) * $rate;
}
} else {
$tax_values[$key] += $value;
}
}
}
foreach($tax_values as $description => $tax_value) {
$this->output[] = array('title' => $description . ':',
'text' => $currencies->format($tax_value, true, $order->info['currency'], $order->info['currency_value']),
'value' => $tax_value);
}
}
Absolute
Interesting... I replaced the original ot_tax.php with yours and noticed my SHIPPING GST and PST display 50% of their actual values. The grand total does display correct. I restored the backup of ot_tax.php and the shipping values appear fine.Quote:
Originally Posted by Absolute
With original ot_tax.php:
Sub-Total: $155.99
Shipping: $10.48
GST#99999 99999 RT0001 5.0% GST + 8.0% PST: $20.28
5.0% GST on Shipping + 8.0% PST on Shipping: $1.36
Total: $188.11
With modified ot_tax.php:
Sub-Total: $155.99
Shipping: $10.48
GST#99999 99999 RT0001 5.0% GST: $7.80
8.0% PST: $12.48
5.0% GST on Shipping: $0.26 (Should be $.52)
8.0% PST on Shipping: $0.42 (Should be $.84)
Total: $188.11 (Remains correct)
Any thoughts would be appreciated.
I looove this tax tutorial and have used it to set up the taxes for my two Leatherman Tools sites, but...
I'm creating a new site for my programming work, and that site need to be setup with the same taxes as the Leatherman sites...
Now I don't really want to go through the entire process of setting them all up by hand.
Is there a way to export/import the settings from my other sites?
Any help would be appreciated!
Ray
Honestly, in the time it takes to figure out and implement an export/import strategy you'd probably have it done manually twice over :)
I could very well be wrong. Someone can probably whip up an SQL query faster than I can type "SQL query"
The only way to do this using SQL is through phpMyAdmin, or similar interface. The Zen Cart SQL patch doesn't return recordsets, only sends the SQL to the server, so you can't use that for exports.
All you would need to do is to export all records from tax_class and tax_rates tables, and if you wanted them, the zones_to_geo_zones and geo_zones tables as well.
Export the data, change databases, and then import into the same tables on the new database.
JUST ENSURE YOU BACKUP FIRST
Absolute
I have a problem with my cart. When I purchase a product and go to the billing of my item, all the amounts show up correctly. However, the label for GST doesn't show up.
What could be wrong and what is the fix ?
I have found the problem and corrected it.
Would you mind sharing your solution so others may learn from your experience?Quote:
Originally Posted by kramerr
Quote:
Originally Posted by kramerr
They would have simply set a description on their tax rate so that there is something to be displayed.Quote:
Originally Posted by MojoDaddy
Oh shoot!
I just noticed that after working properly for some time, the Canadian taxes are no longer being calculated correctly!! I have installed a few new modules lately, but can't think what could be affecting the tax calculation? I've installed userCurrency (not sure yet if it is working), Ty Package Tracker and GoogleAnalytics. I've been messing around with tpl_header but only touched tpl_module_order_totals to implement the bug fix (division by zero).
Here is an example of an incorrect calculation:
Quote:
Products Model Tax Price (ex) Price (inc) Total (ex) Total (inc)
1 x Snap N' Grow Garment Extenders 3 Pack 5% $6.95 $6.95 $6.95 $6.95
1 x iPlay Flexi Specs Sunglasses - Infant size
- Colour: Lime 13% $10.95 $10.95 $10.95 $10.95
1 x Munchkin Baby Food Grinder / Hand Mill 13% $13.95 $13.95 $13.95 $13.95
Sub-Total: $31.85
Store Pickup (Walk In): $0.00
5% GST # 86028 4694 RT0001: $3.58
8% PST in Ontario + 5% GST # 86028 4694 RT0001: $3.58
Total: $39.02
OH!
And on another transaction, it lists a product as being only GST-taxable. I figured it was my error, but when I checked its settings, it's set to GST/PST/HST!
Its unlikely its a mod. userCurrency (my mod) doesn't touch tax calculations at all... simply determines which currency the user is using and stores that to DB. The others have nothing to do with taxes either.
Probably you have your taxes just set up wrong. It looks like you're charging GST twice and even then its not calculating at the correct rate. You'd have to post your tax setup for us to help.
In a sale from 2-3 days ago, the total taxes are correctly calculated, but displayed funny:
Should be GST 1.29, PST 1.43.Quote:
Sub-Total: $25.85
Store Pickup (Walk In): $0.00
8% PST in Ontario + 5% GST # 86028 4694 RT0001: $2.32
5% GST # 86028 4694 RT0001: $0.40
Total: $28.57
Here are my tax ratesQuote:
Tax Rates
Priority Tax Class Zone Tax Rate Action
1 GST/HST/PST Class Ontario PST Zone 8%
1 GST/HST/PST Class Canada GST Zone 5% Info
1 GST/HST/PST Class Eastern Canada - HST Zone 13% Info
1 GST on Shipping Canada GST Zone 5% Info
1 GST on Shipping Ontario PST Zone 8% Info
1 GST on Shipping Eastern Canada - HST Zone 13% Info
1 GST only Canada GST Zone 5% Info
What is that last one for? You should have only 6
No, this isn't correct.Quote:
Originally Posted by laurahowes
On a sale of $25.85 you should be charging:
sub: $25.85
PST: $2.07
GST: $1.29
total: $29.21
OK, scratch this one.Quote:
Re: Configuring Taxes for Canadian Sites/Zones
OH!
And on another transaction, it lists a product as being only GST-taxable. I figured it was my error, but when I checked its settings, it's set to GST/PST/HST!
In my panic, I failed to notice that this customer was NOT in Ontario, and thus should have only been GST-taxable. :blush:
I have many PST-exempt items.Quote:
Originally Posted by s_mack
Sorry, I didn't give enough details.Quote:
Originally Posted by s_mack
In the subtotal of $25.85, $7.95 was PST-exempt (clothing).
So now the display makes more sense. GST on $7.95 is 40 cents. Wish there was a more elegant way to display it, though. If I'm confused, my customer might be too.
Ok, then back to your first example where you said you had the problem... what in that, if any is tax exempt? Impossible to help without complete info :)
I'm presuming it is all tax exempt? That's why GST and GST+PST are the same. Still, it is obviously not calculating correctly:
[qoute]Sub-Total: $31.85
Store Pickup (Walk In): $0.00
5% GST # 86028 4694 RT0001: $3.58
8% PST in Ontario + 5% GST # 86028 4694 RT0001: $3.58
Total: $39.02 [/quote]
On $31.85, GST would be $1.59 not $3.58. So your GST is effectively calculating at aproximately 11% and I have no idea what you could have entered to achieve that! Your 8%+5% is also calculating at 11% for an total effective tax rate of around 22 and a half percent.
You clearly have some settings messed up. Is this a production site? If not, perhaps PM me your admin info (address + login + password) and I can take a look.
The tax rates are displayed with the rest of the info. The first item is 5% (GST only), the other two are 13% (GST and PST).Quote:
Ok, then back to your first example where you said you had the problem... what in that, if any is tax exempt? Impossible to help without complete info :)
In a simpler example, here is the sale of ONE PST-exempt item, shipped out of province (and therefore exempt anyway):
It's calculating the GST on shipping based on the product price!Quote:
Sub-Total: $20.95
Canada Post (1 box(es) to be shipped) (Domestic Lettermail: estimated 3-5 business days): $3.75
5% GST # 86028 4694 RT0001: $1.05
5% GST on shipping: $1.05
Total: $26.80
I just set up a fake account and tested and it showed correctly for me.
That's with a fake ON address. I also tried BC address and it worked fine too. Also tried store pickup and still did it correctly.Quote:
Sub-Total: $23.95
Canada Post (1 box(es) to be shipped) (Expedited, 2009-07-17): $8.47
5% GST # 86028 4694 RT0001: $1.20
5% GST on shipping + 8% PST on shipping: $1.10
Total: $34.72
That is correct IF you only have PST-exempt items in your cart. What were they? If there are any PST-taxable items, they weren't charged tax.
I tried a variety of products... I figured clothing was tax exempt (that's the above example). I also tried one with something (seat of some sort) that was charged PST as well (from ON address) and it again did it correctly. You've given me access to your admin and I tried finding the first problem transaction you posted above... I found one with the same subtotal but all the taxes and totals display correctly there so I can't figure out where you're seeing the bad calculations.
Yeah, I used the edit order function to quickly correct it since this buyer will be pickin gup her order soon.Quote:
You've given me access to your admin and I tried finding the first problem transaction you posted above... I found one with the same subtotal but all the taxes and totals display correctly there so I can't figure out where you're seeing the bad calculations.
Nothing like a million variables to make a problem impossible to ascertain!! :cry:
You said it :)Quote:
Originally Posted by laurahowes
I wish you the best of luck resolving your problem. Unfortunately I can't go any further (see PM I sent).
- Steven
*sigh of relief*
Nothing is wrong with my cart or my tax calculations. Whew.
Stepping away from my panicky sky-is-falling reaction, I took the time to compare the orders as they appear in my admin and the hard copy invoices I have here: the problem is with the Ty Package Tracker module not DISPLAYING the taxes correctly. Maybe it doesn't take into account complex taxing situations? I just installed this mod and it replaces the order screen with its own version. Just thought I'd post in case anyone else has a problem with it.
Steven, can't THANK YOU enough for taking the time to look into this for me. You helped me determine what WASN'T the problem and that was huge.
Off to uninstall and have a stiff drink... :P
You're very welcome. Good job on figuring it out!
So if I were setting up a store in BC, instead of Ontario....I would set up the PST zone for BC not ontario....correct?? or do i still need to charge pst to ontario?
You're correct. No PST for Ontario.
That is... until next year, when the HST in Ontario (and probably BC) comes into effect. Presuming its the same as for the Atlantic provinces that already have HST, you must charge and collect it.
Hello
hope you can figure out this
my taxes dont count
I have set everything as mentioned but i get 0 in taxes
also when I am not logged in I see products with prices including taxes (which is good)
but when I am logged in the prices are without taxes
your help is appreciated, I spent so many hours on this issue
Thank you
How can we possibly help? you haven't posted any details whatsoever.Quote:
Originally Posted by joudesign
You obviously do not have everything setup as mentioned, or you've changed some default settings without understanding what they do, or you haven't selected the appropriate tax class in you products
it was a zones setting problm
thanks so much for your help and time
looking to hire an expert for assistance with tax/shipping configuration
running v1.3.8a/v1.3.8
despite attempts to follow the above instructions, still not getting taxes and shipping proper tallied/calculated (or even recognized) for out of province orders.
/greg
I have a problem with gst not being added to the order for any orders going out of province. All taxes work fine with orders in province.
All the settings are correct from what I can see.
Any ideas why it's screwed up?