Hi Knittingman81,
This is a huge issue that I am seeing for Shopify stores on the Basic plan. I similarly have to report the net sales for several jurisdictions in New York and I can’t believe that the Sales Tax report provided by Shopify doesn’t have net sales included. I spent HOURS in Excel combining information from the Sales Tax report and the Total Sales report to come up with the numbers needed. Several of my friends who run ecommerce stores on Shopify who are using the Basic plan are having this same issue. so I hope the Shopify team updates that report soon! Sorry I don’t have a better answer, but wanted to let you know that you’re not alone!