Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

Change the way tax is calculated

cypherdenmark

By cypherdenmark
in General Support

Recommended Posts

cypherdenmark

cypherdenmark

Posted
Posted

Is is possible to change the way tax is calulated. (The tax is 25 %)

 

An example is shown how it could look.

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

 

As you can see in the above example tax is calulated with the total amount. (135*0,20) which I need, because of the Danish Laws. We have to show how much the the tax was out of the Total amout. So insted of taking tax of sub-total, it should take it from Total.

 

How can I change this.....I really need an answer because im about to launch the shop. :!:

 

Thanx :D

mortenz

mortenz

Posted
Posted

I have the same problem (also from Denmark).

I have just started working on osC and haven't found a solution yet.

I'll post if I figure something out.

Jason

Jason

Posted
Posted

Do you mean that you need to show prices inc Tax in the shop and then show the value of the tax at checkout?

 

We have done this, but it has taken a lot of coding and changes... and quite a bit of time. We had to add functions to calculate tax 'backwards' and then we called them from checkout. The biggest pain is the VAT on shipping (charged as a service at 19.9% in France and applicable if the delivery country is in the EEC)

 

I asked around in these forums and the answers I got were that noone else wants this option...

cypherdenmark

cypherdenmark

Posted
  • Author
Posted

Yeah, I want to show the product inc Tax, and on check out I have to show (because of Dansih Laws) the value of Tax

(Total Amount * 0,20 - The Tax is 25 % in Denmark look at my first post message)

 

Thanx for help and interest for this message so far :wink:

Jason

Jason

Posted
Posted

Hi,

 

We are trying to finish up our shop. We use exactly this system, ie showing everything inc tax, then showing the client the tax details if it is applicable. However, one thing we do is that if the tax is NOT applicable, we do not reduce the price accordingly. What do you intend to do if people buy from outside the EC? Deduct the tax, or just leave the price and enjoy a bigger profit margin?

 

Jason

cypherdenmark

cypherdenmark

Posted
  • Author
Posted

No I do not leave it for bigger profit. (wish I could :P )

 

The shop is intended to use in Denmark, not outside Denmark. So thats why I will deduct the tax from the total amount.

Jason

Jason

Posted
Posted

OK.

 

We added a column in products for our VAT level called tax_our_company, then changed the admin products page to update THAT column instead of tax. That way the shop thinks that all items do not have VAT. When the client gets to the check out no VAT is added.

 

In order to backwards calculate the VAT, we added the functions in the general.php (functions directory) and then applied them in a new ot_tax_our_company module in includes/modules/order_total/...

 

There are a few more steps. If this makes any sense to you, then I'll explain the rest and you can move ahead on your own... If not, then I would be happy to do a contribution for this if other people want it too (any opinions????). I won't be able to do it right away, though. I have to get my new shop up and running and I have very little time.

 

Rest assured that it is possible. But complicated (and VERY boring)

 

Jason

cypherdenmark

cypherdenmark

Posted
  • Author
Posted

Hey jason, sorry to take your time. That is so cool that you can help :lol:

 

So alle the product in the shop are shown with tax and on checkout you call the function which calculate the tax backwards. Have I understand your answer correct ??

 

If it is so, thats what I need to finsih my shop as I have show in my first post message (look at the example) !!

 

As you were saying "if people want it too".... I dont know but here in denmark we have to do it in that way and maybe for other countires as well, so a contribution would be lovely, specially for me and ofcourse other danes :)

henri

henri

Posted
Posted

AS i recall this is possible with the normal shop. (a minor change to shipping as i recall).

And i don't know how discount affects it, but shouldn't.

 

from a german Shop (translated to english):

1 Product Tax 16% Summe 9.00EUR

Sub Total: 9.00EUR

Shipping: 10.00EUR

included Tax.: 2.62EUR

Total: 19.00EUR

 

Cu Henri

henri

henri

Posted
Posted

Thats the Problem,

I don't recall exactly.

 

I try to recall:

First some settings in the admin (Tax on Shipping)

Then Shipping is diplayed wrong on one or two pages (without tax so you have to adjust the display)

 

Little tricky, but if you want, i help you implementing it (and if other need it i write it down)

Cu Henri

[email protected]

cypherdenmark

cypherdenmark

Posted
  • Author
Posted

Yeah that would be perfect if you got the time.

If you got the time to write it down, will you post the code here or will you mail me :?:

 

Jubiii I'm looking forward to it because it is the last thing I'm missing before I launch the shop :lol:

 

Perfect Henri

cypherdenmark

cypherdenmark

Posted
  • Author
Posted

Hey Henri.....

 

The main problem might be the discount module which I have installed, everything seem right when i disable it. The module which I have installed is Customer Discount ORDER_TOTAL Class V1.0 by Aubrey Kilian , so it must be that module which infect the tax

mortenz

mortenz

Posted
Posted

cypherdenmark -> Actually, I asked the authorities in Denmark (Forbrugerstyrelsen), and you don't have to specify the Tax (moms). Just write: "Price includes 25% moms".

 

How about that for an easy solution!

henri

henri

Posted
Posted

@cypherdenmark

If i should help you with the other solution, just contact me per email...

oreind

oreind

Posted
Posted

I think I need this functin here in Iceland. I mean only to show at checkout the amount tax is (all products includes the tax):

 

1 Product, Total 9.00EUR

Sub Total: 9.00EUR

Shipping: 10.00EUR

included Tax.: 2.62EUR

Total: 19.00EUR

 

Do you have some info handy how this is possible?

 

Regards from Iceland.

Baldur

www.oreind.is/catalog

henri

henri

Posted
Posted

Ok, just did it on a clear cvs shop:

 

In this example I go for flat shipping cost 10 Euro including Tax 16%

 

Admin:

 

Configuration/ handdling fee set to zero (only done to make the example easier; If used price must be without tax!)

 

Modules/order_total:

Adjust shipping: Sort Order 2 Tax Class: what you need (here 16%)

Adjust Tax:Sort Order 3

Sort order only for displaying reason

 

Now the Shippingcosts in the Admin is without Tax

 

modules/shipping/Flat Rat

activate it and set it to 8.620689656 (10 /1.16)

 

checkout_confirmation now looks right :)

but in checkout payment shipping is displayed without tax :(

 

For this you have to adjust the shippingmodul

in our case:

catalog/includes/modules/shipping/flat.php

 

There is a function display()

here i find the line which displays the shipping cost:

' <td align="right" class="main">' . $currencies->format($shipping_flat_cost);

 

and i calculate the tax manually to it:

 

' <td align="right" class="main">' . $currencies->format($shipping_flat_cost*1.16);

 

Other modules should go the same.

How you adjust the text for tax ( i would write 'included tax', or so), i don't need to explain, i hope ;)

 

Cu Henri

Archived

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

Go to topic listing
×
×
  • Create New...