VAT for refunds to be reported on date refund takes place and NOT at date of original order
I'm looking for someone who can create a tool for reporting VAT correctly. A software / app developer who specialises in Shopify financial reporting.
The standard tax report for Shopify reports incorrectly. Refunds are linked back to the original order and not treated as a separate transaction at the date when they were created.
To illustrate... A customer purchases a product in Feb. You refund them in April.
In all the available Shopify Tax reports, Shopify doesn't report that this refund took place in April. Shopify reports that it took place in Feb - the VAT and transaction details for Feb are updated and adjusted.
This is wrong.
If a refund is made, VAT and transactions need to be adjusted for the date the refund is made and NOT for the date of the original, corresponding order.
I'm assuming that lots of people have a fix for this - otherwise all Shopify users would be reporting VAT / taxes incorrectly.
But I'm struggling to find the right fix.
Can you help?
The data is in Shopify. Shopify records transaction dates - whether they're a refund or order - BUT the date of refunds is not given when pulling transaction or tax reports.