Reporting issue: Finances summary Net sales amount is not matching Net sales report

[ChrissySydney]

Hi all,

major issue with the Analytics -> Reports for POS: As always, we did 2 'Finances summary' reports for a POS location last Saturday and Sunday and printed them. The numbers looked fine. Today (Monday), when going back the 'Finance Summary ' report, the Net Sales numbers for both days have changed!

But the in the "Net Sales' report, they are still as on Saturday and Sunday. Means, for some reasons it seems in the Finance Summary report the Net Sales for both days is incorrect all of a sudden.

We have not seen this happening with Shopify POS 'Finance summary' reports in the last 3 years and we pull them every day. Can anybody explain this by chance? We need to get our accounting right and this is urgent. Thanks so much! Christine

[Lisa_Knight]

I've had the same thing happen this morning. A quick 20 minutes task has had me digging through reports and re-adding things for the last 3 hours. I use that report every business day to balance out our books. The sales tax isn't adding up either. It's like it is taking the amount that it's off, and adjusting the sales tax for that.

[ChrissySydney]

HI Lisa, how can we escalate this burning topic to Shopify support asap? 

Thank you, Christine

[Lawson_Thalmann]

I've been pulling out Shopify data and trying to recalculate sales for our accounting platform as well as reporting in Microsoft Power BI, but for the past few months have not been able to reconcile back to what Shopify reports as sales within its reports. 

I know that on June 22nd, they started tracking exchanges and order edits differently. They showed me where to get that info via API, but I still haven't been able to figure out how that affects the sales calculation within Shopify itself. It seems something weird must be happening with the dates where if an order is exchanged, it might affect the sales for that original day rather than the day the exchange occurs.... But, that's just a hunch at this point. We have several exchanges per day, so it's quite complicated to sort that out! 

I don't think anyone that works for Shopify understands accounting unfortunately... 

[ChrissySydney]

Hi, yes I agree, Shopify should notify us with any changes to reporting and analytics proactively and in all detail. The accounting depends on it as well as ultimately tax payments and inventory value. 

Let's see how we can escalate this. 

Now, back to my originial message: Shopify must have corrected the error in the meantime. A few days after the discrepancies, we looked at the reports for the same days again and viola, they matched and went back to what they were/ are meant to be. 

This is a relief, but the hours we spent to identify there's an issue, manually try to find out and confirm there must be a Shopify error etc. were unnecessary. 

So immediate and pro-active notification of in particular accounting / reporting related glitches are necessary. Dear Shopify team, please listen to this!

Thank you