Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Problem: calculating the TAX


cypherdenmark

Recommended Posts

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

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

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

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

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

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

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

  • 5 weeks later...

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...