Sales report 2.0

[OldNGrey]

@OldNGrey, is this an issue when the prices "include tax" like they do in AU? I ask because for US-based pricing where the tax isn't included, I'm not seeing an issue when the shipping is taxed.

Sorry for the delay in responding I posted a detailed explanation yesterday but it obviously disappeared into the ether.

Yes, the issue is when tax is included in the postage. In Australia all local postage includes tax, all postage for overseas is tax free. All product prices listed include tax, and this remains for an Australian delivery address. the tax is removed for overseas delivery addresses.

I can see the variation by selecting the "Total Validation" option and this is good enough for reconciling other reports.

For me this is now a very low priority for possible future consideration as I now fully understand what is occurring.

The first image is the sales report:


The second image is the order details amounts:


The third image is the "orders_total" table contents: