I was wondering if anyone would be able to give me some insight into how you are currently recording your TAX/VAT.
For example - if we have 200 orders in a day that total £10,000 that are a mix of adults and kids clothing, we cannot enter into our accounts software £10,000 sales - Sales: £8333.33 / VAT: £1666.67. The reason we cannot do this, is that some of the items sold were kids clothing. meaning many of these items don't have VAT on them. The actual figures may be closer to Sales: £9000 / VAT: £1000
How are you guys finding out / reporting on the above situation accurately? Especially when it comes to having multiple sales channels such as a merchant/credit card payment processor and paypal.
I know there is a Report -> Sales -> TAX report, however this just tells us how much VAT we have charegd in a single day/time period - it doesn't split between sales channels, or take other factors into account.
Any help would be greatly appreciated - even if it requires an outside addon.
Well here is an extension for this purpose, It allows you sort orders based on VAT, You can list and total the order with and without VAT, You can also export these filtered list in a CSV file for reporting.