magento - multiple tax rates

Posted by Fiona on Stack Overflow See other posts from Stack Overflow or by Fiona
Published on 2009-09-16T10:47:49Z Indexed on 2010/04/22 15:03 UTC
Read the original article Hit count: 456

Filed under:

magento

|

tax

|

rates

I've built a magento site for a Canadian company where each state has a Retail sales tax and a federal tax rate and these rates differ! So, I set up the rates, and the Tax is being calculated correctly, ie the sum of the two tax rates is being calculated correctly. however on selecting the breakdown of tax mode in the admin panel, it would appear that there is something wrong with my setup.

Eg. Subtotal $129.99 GST/HST Quebec (5%) $ 16.25 Provincial Sales Tax Quebec (7.5%)
Tax $ 16.25 Grand Total $158.23

16.25 is 12% of $129.99 so the tax figure is correct. However it should be displaying as follows: Subtotal $129.99 GST/HST Quebec (5%) $ 6.50 Provincial Sales Tax Quebec (7.5%) $ 9.75 Tax $ 16.25 Grand Total $158.23

Anyone come across this before? Have any suggestions on how to fix it?

Many thanks, Fiona

© Stack Overflow or respective owner

Related posts about magento

Can't view order in magento

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I've been setting up a fresh magento 1.4.0.1 install, working great so far. I did some test orders just to see. Everything works fine, but when I click on "view order" under "my orders", I get a bunch of error messages: There has been an error processing your request Notice: iconv_substr() … >>> More
Magento Community - Hosting :: Need Advice which sharing hosting will run magento fast

as seen on Server Fault - Search for 'Server Fault'
Hi, Need Advice which sharing hosting will run Magento Community fast or some other not expensive solution. This website will not have a lot of users, I only need that it will run fast for 100-20 users in same time. The problem with magento is database design that make this system very slow ,… >>> More
Magento Community - Hosting :: Need Advice which sharing hosting will run magento fast

as seen on Server Fault - Search for 'Server Fault'
Hi, Need Advice which sharing hosting will run Magento Community fast or some other not expensive solution. This website will not have a lot of users, I only need that it will run fast for 100-20 users in same time. The problem with magento is database design that make this system very slow ,… >>> More
Magento Developers: Is Magento really -that- good?

as seen on Stack Overflow - Search for 'Stack Overflow'
We are looking at Magento as a possible commerce solution, but we are reading more bad than good on the free product. However Magento sells itself as the best thing ever, so I am confused on its actual value. Thought I'd ask the pros here. Can any seasoned developer here explain the difficulties… >>> More
Loading Magento child html outside of Magento

as seen on Stack Overflow - Search for 'Stack Overflow'
I am loading Magento blocks outside of Magento for certain parts of my site. I can do this successfully with something similar the following. require_once $docRoot.'/app/Mage.php'; umask(0); Mage::app('default'); ... $layout = Mage::getSingleton('core/layout'); $block = $layout->createBlock('Mage_Page_Block_Html_Header'); $block->setTemplate('page/html/header… >>> More

Related posts about tax

What’s Your Tax Strategy? Automate the Tax Transfer Pricing Process!

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Does your business operate in multiple countries? Well, whether you like it or not, many local and international tax authorities inspect your tax strategy. Legal, effective tax planning is perceived as a “moral” issue. CEOs are being asked to testify on their process of tax transfer pricing… >>> More
Best way to store sales tax information

as seen on Stack Overflow - Search for 'Stack Overflow'
When designing a stock management database system (sales / purchases) what would be the best way to store the various taxes and other such amounts? A few of the fields that could be saved are: Unit price excluding tax Unit price including tax Tax per item Total excluding tax (rounded to 2 decimals) Total… >>> More
magento - multiple tax rates

as seen on Stack Overflow - Search for 'Stack Overflow'
I've built a magento site for a Canadian company where each state has a Retail sales tax and a federal tax rate and these rates differ! So, I set up the rates, and the Tax is being calculated correctly, ie the sum of the two tax rates is being calculated correctly. however on selecting the breakdown… >>> More
MSCRM Tax default to Zero

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
I have been playing around with MSCRM4 lately. It has been interesting going. I had a problem getting the tax to reflect correctly, it was defaulting at zero. Eventually I found a solution after scouring the web for a while... see steps below… Add the following code… >>> More
Video on Hyperion Tax Provision

as seen on Oracle Blogs - Search for 'Oracle Blogs'
( in via Jan) EPM Information Development has asked us to remind you about the new video available for Hyperion Tax Provision. You can view it on the OracleEPMWebcasts YouTube channel here: http://bit.ly/1jxLlCy An information rich 4:40 minutes of your time. So please… >>> More