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

Accounting & Taxes

Topic summary

Issue: Finance Summary report in Shopify POS showed changed Net Sales for two specific days after initially matching printed reports; the separate Net Sales report still reflected the original figures. One user also saw sales tax values shift in tandem with the discrepancy.

Recent developments:

  • Multiple users confirm mismatches and difficulty reconciling daily accounting.
  • A user notes Shopify changed how exchanges and order edits are tracked on June 22, with related data accessible via API, and suspects exchanges may retroactively alter sales for the original sale date.
  • After a few days, the Finance Summary figures reverted to match prior values, suggesting Shopify corrected something, though no official explanation was provided.

Actions/requests:

  • Users seek escalation to Shopify support and call for proactive communication on reporting/analytics changes or glitches.

Status:

  • Partially resolved (numbers now match), but root cause and impact of exchanges/order edits on sales calculations remain unclear.

Key terms:

  • POS: Point of Sale system.
  • Net Sales: Sales after returns/discounts, typically excluding taxes.
  • API: Interface for programmatic data access.
  • Exchanges: Replacement transactions that may adjust original order values.
Summarized with AI on February 8. AI used: gpt-5.
1

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

1 Like
2

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.

1 Like
3

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

Thank you, Christine

1 Like
4

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…

1 Like
5

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