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?