TYPO3 Mailingliste: nicht fragen - lesen!

I'm having trouble with the tax calculations in the shop. I've set
plugin.tt_products.TAXpercentage = 6.00, however, take the following
example:

Product P1 costs 1.20, P2 is 1.60.

123*P1 + 456*P2 = 877.20
877.20*.06 = 52.632

The shop shows tax to be 54.21!

I'm not sure where the extra 1.578 went! This is mostly noticeable on a
large scale, but I did notice this:

If I only have 2 P2 (3.20), the calculated tax is 0.20 when it really
should be 0.192. It is rounded up instead of down. Is this the expected
behaviour? Is the tax calculation impacted by using different article
prices? My prices are entered without tax included, and I have no tax
on shipping or payment methods.

Any thoughts on this?

Thanks,
Ryan
_______________________________________________
TYPO3-project-tt-products mailing list
TYPO3-project-tt-products (AT) lists...netfielders.de
http://lists.netfielders.de/cgi-bin/...ct-tt-products

Hello Ryan,

> I'm having trouble with the tax calculations in the shop. I've set
> plugin.tt_products.TAXpercentage = 6.00, however, take the following
> example:
>
> Product P1 costs 1.20, P2 is 1.60.
>
> 123*P1 + 456*P2 = 877.20
> 877.20*.06 = 52.632
>
> The shop shows tax to be 54.21!
>
> I'm not sure where the extra 1.578 went!

Your calculation is wrong.
The tax must be calculated and rounded for one product and not on the
total end sum.

P1: 1.20 * 0.06 = 0.072 ~ 0.07
P2: 1.60 * 0.06 = 0.096 ~ 0.10

The tax calculation must not change if you order 1 product or 100.

123*P1 = 123 * 0.07 = 8.61
465*P2 = 465 * 0.10 = 45.60

total tax: 54.21

> If I only have 2 P2 (3.20), the calculated tax is 0.20 when it really
> should be 0.192. It is rounded up instead of down. Is this the expected
> behaviour?
P2: 1.60 * 0.06 = 0.096 ~ 0.10
This must be rounded up.

2 products have 0.20 tax. There must not be any tax reduction by
rounding if you order more than one product.

- Franz


_______________________________________________
TYPO3-project-tt-products mailing list
TYPO3-project-tt-products (AT) lists...netfielders.de
http://lists.netfielders.de/cgi-bin/...ct-tt-products

On Thu, 21 Dec 2006 05:20, Franz Holzinger wrote:
> Your calculation is wrong.
> The tax must be calculated and rounded for one product and not on the
> total end sum.

Why not? Shouldn't the tax be based on the total amount spent, not the
price per product? I don't know the legal rules involved. Is this
perhaps a difference between European and American calculations? I
think what you are saying makes sense if the tax is already included in
the quoted price, but not if you are quoting the actual price and adding
tax on additionally. Is that why? I really hate the American system,
but I do have to write for it. You know the Americans don't want the
"evil" government to steal even one cent and give it to those "lazy"
homeless people!

Thanks again,
Ryan
_______________________________________________
TYPO3-project-tt-products mailing list
TYPO3-project-tt-products (AT) lists...netfielders.de
http://lists.netfielders.de/cgi-bin/...ct-tt-products

Hello,

> On Thu, 21 Dec 2006 05:20, Franz Holzinger wrote:
>> Your calculation is wrong.
>> The tax must be calculated and rounded for one product and not on the
>> total end sum.
>
> Why not? Shouldn't the tax be based on the total amount spent, not the
> price per product? I don't know the legal rules involved. Is this
> perhaps a difference between European and American calculations? I
> think what you are saying makes sense if the tax is already included in
> the quoted price, but not if you are quoting the actual price and adding
> tax on additionally.

This has been changed now to your proposal.

Use TAXmode=1 for your calculation of all sums without taxes and without
any roundings. The tax will be added at the end sum. Then it will be
rounded for the output. This will be the default behaviour and you
should use this mode also for Germany. I have now uploaded a new
tt_products 2.5.1 which contains this. This is the last upload of 2.5.1.
The improved tt_products 2.5.2 will follow soon.

Use TAXmode=2 to do the former way. The tax will be added for each
product and rounded to 2 digits after the comma. Then the products
prices are calculated together.

- Franz

_______________________________________________
TYPO3-project-tt-products mailing list
TYPO3-project-tt-products (AT) lists...netfielders.de
http://lists.netfielders.de/cgi-bin/...ct-tt-products