Tax calculation problem - help please!

[RodG]

"Why - when there is no shipping fee the GST gets calculated on ONLY the item and not the surcharge."

Completely stumped!

And I'm somewhat perplexed. I made an observation that I thought you had missed, namely that it could perhaps be related to the shipping cost. If you had already determined this in your initial posts then why didn't you mention it? You probably would have gotten more responses if you had. It would have shown/demonstrated that you'd performed the diagnostics and narrowed it down to the shipping as being the dominant cause. Your initial posts came across as "here are the figures can someone work out what is wrong fo me because I don't have a clue" .... Well, apparently you *did* have a clue (shipping cost) but you kept it to yourself. I now wonder what other clues you are keeping to yourself?

Cheers
Rod

[satphone]

What happens if you change the sort order of the order totals so that the surcharge is processed before the shipping?

Hi the sort order is processed before the shipping, guess I'll try after the shipping and see what happens.

You're concerns about me "holding back information" are not warranted. If I'm asking for help I'm trying to deliver the best information I can - why would I not?!!! It's only whilst staring at this thread for days that it became clear to me this seems to be a key factor. Secondly I did "almost" deliver the shipping issue concisely, "The only difference I can see is that it's a) a different product b) there is shipping involved."

Let me correct that;

"The only difference I can see is that with any product there is free shipping involved."

[satphone]

Update - changing the sort order made no difference. Still - with free freight - GST is not calculated and added on the surcharge.

[RodG]

Update - changing the sort order made no difference. Still - with free freight - GST is not calculated and added on the surcharge.

Humour me. Please provide the figures that you are currently seeing for the test/example in message#3 with free shipping.

Thx
Rod

[satphone]

Humour me. Please provide the figures that you are currently seeing for the test/example in message#3 with free shipping.

Thx
Rod

OK - as posted in number 3, it's only happening where shipping is free. ie. The GST gets calculated on only the item price and not the item price + surcharge.

Sub-Total: $80.00
Credit Card / PayPal Fee: $1.09
Free Shipping: $0.00
GST 10%: $7.27 (This is the correct GST for $80, not the total of $80 + $1.09 surcharge, it should be $7.37)

This is consistent across all products and categories.

Total: $81.09

Got me stumped as to how the shipping cost can change the way GST is calculated!

[RodG]

OK - as posted in number 3, it's only happening where shipping is free. ie. The GST gets calculated on only the item price and not the item price + surcharge.

Sub-Total: $80.00
Credit Card / PayPal Fee: $1.09
Free Shipping: $0.00
GST 10%: $7.27 (This is the correct GST for $80, not the total of $80 + $1.09 surcharge, it should be $7.37)

This is consistent across all products and categories.

Total: $81.09

Got me stumped as to how the shipping cost can change the way GST is calculated!

Please continue to humour me here... now change the sort order back to how it originally was (or if you already did that please switch them around again) and then show me the results again.

Thx
Rod

(trust me, I do have good reason for asking this, which I will explain after next set of results).

[satphone]

Please continue to humour me here... now change the sort order back to how it originally was (or if you already did that please switch them around again) and then show me the results again.

Thx
Rod

(trust me, I do have good reason for asking this, which I will explain after next set of results).

OK sort order:

Subtotal 100
Shipping 200
CC Fee 250
Tax 300
Total 999

produces exactly the same results as :

Subtotal 100
CC Fee 200
Shipping 250
Tax 300
Total 999

[RodG]

OK sort order:

Subtotal 100
Shipping 200
CC Fee 250
Tax 300
Total 999

produces exactly the same results as :

Subtotal 100
CC Fee 200
Shipping 250
Tax 300
Total 999

<gggrrrrrr>. I asked you to *show* the results, just as you did in msg#3 and msg#15. Try again.

[satphone]

<gggrrrrrr>. I asked you to *show* the results, just as you did in msg#3 and msg#15. Try again.

Rod - I realise you are trying to help. But it is the SAME.

Sub-Total: $80.00
Credit Card / PayPal Fee: $1.09
Free Shipping: $0.00
GST 10%: $7.27 (This is the correct GST for $80, not the total of $80 + $1.09 surcharge, it should be $7.37)

In both sort order case - actual values - the same.

[RodG]

Rod - I realise you are trying to help. But it is the SAME.

Sub-Total: $80.00
Credit Card / PayPal Fee: $1.09
Free Shipping: $0.00
GST 10%: $7.27 (This is the correct GST for $80, not the total of $80 + $1.09 surcharge, it should be $7.37)

In both sort order case - actual values - the same.

It isn't the actual values that I was interested in.

You probably don't even realise this, but *all* of the examples that you've shown have the "wrong" sort order when referenced against the sort order that you wrote that you had/needed.

To put it together without numbers let's take it like this:

Product = Product Price inc GST
Shipping - Shipping Price inc GST
Surcharge = Surcharge Price inc GST
GST = 10%
GST Calculated = GST charge shown on Invoice / checkout

Your examples are *ALL* showing a sort order of
Subtotal 100
CC Fee 200
Shipping 250
Tax 300
Total 999

What you are wanting is.
Subtotal 100
Shipping 200
CC Fee 250
Tax 300
Total 999

You have successfully demonstrated that your defined sort order isn't being acted upon (or more accurately, you have failed to demonstrate that it *is* being acted upon).

I would suggest that you resolve/investigate this before delving further.

Cheers
Rod