Any luck in finding a way to isolate WA state gross sales easily?
I did find a way to do it quickly but something has changed, I think
Here’s what I had to do this time;
-
Export total sales for the quarter to your spreadsheet program
-
Sort for the “Billing Province” column (Shopify is Canadian)
-
Isolate the WA state sales
-
Do a sum for the gross sales.
-
You can do a sum for the taxes collected too, if needed.
You can find your overall gross sales in the Finance section - do a custom date range to get your quarterly numbers.
Having to pay for an app to do something that we have to do by law is ridiculous. Anything that is mandatory by law should be built in to all levels of Shopify automatically.