Not Taken Reports mixing Tax rules
It seems some reports are mixing Incl Tax and Excluding Tax amounts. This is ludicrous. As an example, The sales reports are showing an Incl tax value for the invoice amount, but COGS is Excl Tax. This is really confusing and pretty much against all known system standard workings. This needs to be fixed immediately or the reports are garbage.
1.COGS never contains tax amount that's why you can see it as exclusive of tax
2. Invoice total contains tax amount to be comparable with other invoice related reports. Invoice amount is rather Accounts Payable/Receivable amounts and always tax inclusive.
3. Sale amount is net of tax and gross profit is calculated as Sale amount minus COGS amount
Please be more specific and let us know the report you are confused about