On a Magento CE 220.127.116.11 website I'm having an issue where the Grand Total does not include tax, even though the Subtotal does. What this means is that my Subtotal figure is higher than the Grand Total, which is clearly wrong.
I've tried changing every setting in the Admin panel to do with tax and cannot get this to work.
These are some example figures on the shopping cart which also carry through to the checkout:
Subtotal (Excl. Tax) £909.50 Subtotal (Incl. Tax) £1,091.40 Tax £181.90 Grand Total £909.50
This is wrong - the Grand Total shold be £1091.40 because that should be the subtotal (£909.50) plus any tax (£181.90)
My configuration and settings are like this:
- Product price is 909.50
- Product has a tax class of VAT. The tax rules mean 20% tax is applied, which we can see is happening in "Subtotal (Incl. Tax)".
- Catalog prices: Excluding tax (this is to specify that the Admin has entered 909.50 as an Ex. Tax price, which is correct).
- Tax calculation based on: Shipping address. A UK shipping address has been used in this example so this is correct to apply 20% tax.
- Display Subtotal: Including and Excluding tax. This is correct because the cart and checkout do display both ("Excl. tax" and "Incl. tax")
If I set "Include Tax in Grand Total" to "No" it gives the total above (909.50) which is wrong. However... if I set this to "Yes" it makes the problem even worse - it makes even less sense by outputting this:
Subtotal (Excl. Tax) £909.50 Subtotal (Incl. Tax) £1,091.40 Grand Total Excl. Tax £727.60 (!!!) Tax £181.90 Grand Total £909.50
Templates have not been modified. Core code has not been modified. Caching is disabled.
Does anyone have any ideas? We are all scratching our heads over this one!