cypherdenmark Posted October 26, 2002 Share Posted October 26, 2002 Hey everybody :D I have a problem calculating the TAX. Im located in Denmark where the tax is 25 %. My product is show with tax in the store, and when I add a new product, I put the price without tax and then selecting the Tax Class: Moms (moms <- The moms is 25 % (note the moms is the same as tax)) Here is the problem. 1 x Sony Wega 25% 100,00Kr ---------------------------------------- Sub-Total: 100,00Kr Shipping: 45,00Kr Discount: 10,00Kr (10% discount on the product(s)) Total: 135,00Kr Tax (25%): 20,00Kr Howcome is it calculating the tax with sub-total so Tax becomes = 20,00Kr (100*0,20=20kr) <- THIS IS WRONG Normally it should calculate the tax with total so Tax becomes = 27,00 kr(135*0,20=27) <- THIS IS RIGHT So it should look like this 1 x Sony Wega 25% 100,00Kr ---------------------------------------- Sub-Total: 100,00Kr Shipping: 45,00Kr Discount: 10,00Kr (10% discount on the product(s)) Total: 135,00Kr Tax (25%): 27,00Kr How can I make this possible ??? :P Link to comment Share on other sites More sharing options...
Ian Posted October 26, 2002 Share Posted October 26, 2002 This depends on your setup. First, as standard osc does not add tax to shipping. To change this go to your admin->modules->order_total->shipping and change that tax added to shiping. The discount module is harder. It depends which one you are using and whether it supports tax recalculation. Trust me, I'm an Accountant. Link to comment Share on other sites More sharing options...
cypherdenmark Posted October 26, 2002 Author Share Posted October 26, 2002 Hey Ian Super fast answer....Perfect.... :D The discout module is Customer Discount ORDER_TOTAL Class V1.0.I dont want to add tax to shipping. The only thing I want is to calculate how much tax is (the amout of total) The tax is 25 % Etc Total = 135 kr. Tax is(the amount of total) = 27,00 kr because 135*0,20 = 27,00 kr I dont know if this is possible. I have looked at the code but can not figure out how the calculating is working Hope you can understand my question ? Link to comment Share on other sites More sharing options...
Ian Posted October 26, 2002 Share Posted October 26, 2002 You say you don't want to add taxt to shipping, but the total 135.00 includes shipping. So working tax on this means you have to calculate tax on shipping. Trust me, I'm an Accountant. Link to comment Share on other sites More sharing options...
cypherdenmark Posted October 26, 2002 Author Share Posted October 26, 2002 Now it dont get it. The total 135 is OK. The calculating process is ok. But I just want to to inform the cutomer how much the tax is, you know the amout of total which will produce 27 kr. Normally we show the amout of tax which here is 27 kr of the total. So the 135 kr is included tax, and 108 kr is without tax (135-27) So the bill to the customer could look like this 1 x Sony Wega 25% 100,00Kr ---------------------------------------- Sub-Total: 100,00Kr Shipping: 45,00Kr Discount: 10,00Kr (10% discount on the product(s)) Total incl. tax: 135,00Kr The Tax is (25%): 27,00Kr I dont know if I make my self clear but its pretty dificult to explain, but thanx for your kindness. -> Ian :) Link to comment Share on other sites More sharing options...
Ian Posted October 26, 2002 Share Posted October 26, 2002 Lets go back to basics The product is 80 this gives tax of 20 and a total of 100 This is why tax shows as 20 in your original list. To this we add shipping of 45 no tax and deduct discout of 10 no tax gives total of 135. If you dont want to add tax to shipping/discount then tax is 20. To make tax =27 we must add tax to shipping and deduct tax with discount Trust me, I'm an Accountant. Link to comment Share on other sites More sharing options...
cypherdenmark Posted October 26, 2002 Author Share Posted October 26, 2002 Hihih thats pretty funny.. :D Normally here in denmark we do like this: basic knowledge: Sub Total = 100 kr incl tax Discount = 10 kr (10% discount) incl tax New Sub Total = 90 kr incl tax Shipping = 45 kr incl tax Total = 135 incl tax Tax is = 27 kr So the total amount is 135,00 kr incl Tax (25%) Link to comment Share on other sites More sharing options...
cypherdenmark Posted October 27, 2002 Author Share Posted October 27, 2002 Are there anyone who can help me on this question. The tax problem is the only thing im missing before I put the shop Online ??????? Link to comment Share on other sites More sharing options...
bjorn Posted November 25, 2002 Share Posted November 25, 2002 One solution might be to calculate the shipping with no tax, and add tax to shipping on checkout. This would make osc aware of the tax on shipping and add it to your tax total. -- Bjorn -- Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.