Maintenance Mode

The Ecommerce University Forums are under maintenance, and has been placed into read-only mode. Thank you for your understanding.

d
Topic
Luke Meadows Member
Posts:
5
June 21, 2017

VAT for refunds to be reported on date refund takes place and NOT at date of original order

Hello,

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.

Please help.

Thanks,

Luke

i
Replies
Posts:
627
June 22, 2017

Are you sure? I just did a test to verify this, and I could see that the tax was correctly adjusted on the refund date, not the original order date.

What report are you looking at?

Luke Meadows Member
Posts:
5
June 22, 2017

Hi Clement, thanks for getting in touch.

100% sure.

Numbers are changing all over the place.
For some months, depending on when I pull a report, the numbers are out by a significant amount. Really, the numbers shouldn't ever change.

At start of March I pull a product revenue report for Feb and I get one set of numbers. I pull the same report later in March and get a whole different set of numbers. I come back now and do the same and again, the numbers have changed.

Taxes report.
Product revenue report.
etc.
They're all changing. 

BUT - oddly, I've just done a test on a single order and the VAT reporting behaved correctly - i.e. VAT was altered on the day the refund was created, not when the original order took place. Which is great, as that's how it should work, but now I'm even more confused as to why revenue and tax figures are changing for some time periods I'm looking at.

I wonder if it's an issue with how Shopify and Stripe speak to oneanother?

Any ideas how to bypass Shopify reporting and create robust reports for VAT, shipping revenue / tax, product revenue / tax etc.

Shopify are just saying that 'they're a tech company, not a financial reporting company', so I'm at a loss. I really don't want to re-platform, but if we can't report in a way that's 100% robust, then I will need to (and so, I imagine, will everyone else).

Hhhhmmm...

Posts:
627
June 22, 2017

I don't why this is happening to you.

The only thing I can think of is that you are using an app that creates back-dated refunds or orders, which would be pretty weird too.

Regarding other reporting solutions, feel free to give a try to our app Better Reports.

It is one of the most powerful reporting app for Shopify and can report on pretty much any thing you can think of, including tax, shipping cost, revenue, and much more.

Feel free to reach out to me directly at clement@betterreports.co if you need any help to set up custom reports.

Luke Meadows Member
Posts:
5
June 22, 2017

Hi Clement,

Very strange, eh and hugely frustrating.

Not using any apps at all.

Are you able to pull data directly from orders - at the individual order level - in order to create reports?

i.e. rather than reworking the reports that Shopify provides as standard?

Do you think you can help us fix Shopify's reporting?

We need to bypass the reporting that they're giving us. Need to provide our own reports, using the rawest form of the order data.

L

Posts:
627
June 22, 2017

Yes we basically build our own reports from scratch.

Whether or not we will be able to fix your issue will depend if the raw data itself is wrong or if it's a bug in the way Shopify builds their report.

At this point, I'm not too sure based on what we know but if we can isolate an order which exhibits the faulty behaviour then we should be able to get to the bottom of it.

By the way, we have a 14-day free trial.

Posts:
78
October 26, 2017

Hi Luke,

Not sure why the VAT refund is not reported on the date of the refund.

But there is a field called "Tax Refund Amount" which will list the date of refund and not the date of the sale. We can create this tax refund report using this field along with other fields you need.

I'm from Data Export, which is a reporting application for any type of reports. Reports can be summarized and automated to be delivered to Excel or Google Sheets.

Let me know if you have any questions.

Thanks!

 

Data Export is rated by Shopify Sellers as the best and cost-effective reporting application on Shopify.