Total sales on Dashboard vs CSV output

MaxReve
Tourist
6 0 1

Hi All,

 

I am trying to do a reconciliation exercise between the stats on my Shopify dashboard and the output per the sales CSV export data. However in doing so, I keep getting differences.

I understand that total sales per the Shopify dashboard are: 

Net sales (gross sales minus discounts and returns) plus taxes and shipping. Includes orders from all sales channels

Please note taxes are not relevant for my business.

In the CSV export data, the column labelled Total is taken to be Gross sales, less discounts plus shipping. However the amount I am seeing in this column is larger than the sales on my Shopify dashboard, even when I factor in refunds/ partial refunds. Does anyone know why?

Thanks,

Max

0 Likes
CloudlabSam
Pathfinder
125 6 9

We have noticed the same thing with one of our clients. They never seem to add up exactly - close, but not exactly.

0 Likes
MaxReve
Tourist
6 0 1

What do you take as the source of truth? the .CSV output or Shopify Dashboard?

0 Likes
CloudlabSam
Pathfinder
125 6 9

The csv is correct. We checked it against other sources.

0 Likes
MaxReve
Tourist
6 0 1

Thanks a lot. Very helpful.