Sales Report by State

wasunflwr
New Member
2 0 1

Hi, 

I'm on the basic plan and preparing for quarterly taxes. We are based in WA state but have had some sales in other states and trying to find the best way to find the total sales for each. Is there a way to do this, say just see total sales in WA, on this plan, or without paying for an app? I've seen some people mention needing a professional plan or using an app with a monthly fee. 

Thanks for your help!

Stephanie 

0 Likes
BobsMojo
Shopify Partner
439 44 89

Hi @wasunflwr 

The way we do this is to go to the orders screen, filter by the date range we need, then export the filtered orders to a CSV. We then use Excel to filter & sort the orders in the CSV file by state.

wasunflwr
New Member
2 0 1

Thank you MelsMojoBob, this worked and made it so easy to file!!

texas44
New Member
1 0 0

hmm this didn't work for me, it does not show a column with state information on the excel document

0 Likes
BobsMojo
Shopify Partner
439 44 89

@texas44 

In Excel, column 'AP' (Shipping Province).

0 Likes
BobsMojo
Shopify Partner
439 44 89

@bronddy 

On any plan. Just go to your orders screen and hit the export button. The CSV file will have the states listed in column 'AP'.

0 Likes
radiant-shenti
New Member
4 0 0

Worked great. Thank you!

 

0 Likes