Net Sales on Taxed Goods Only when there are both taxed and untaxed items sold; Net Sales discrepancies on Finance Report

Highlighted
New Member
2 0 3

I have a business where I sell items and labor. Labor is not taxed. I recently started the labor portion and I am having trouble figuring out a way to calculate my net sales only on taxable goods (i.e. not including labor sales) to report to the state. Often the labor item is in the same order as a taxable good too so I can't just manually subtract the orders with no tax. I have previously only exported my orders and used Excel sum calculations since there are discrepancies in shopify's "total sales" and the actual total sales, but I can't figure out how to do with in Excel without manually going through every single order and subtracting the amount of the untaxed good from my net sales number. There's got to be a way to run a finance report that excludes untaxed goods? Or perhaps a way to add up all the untaxed goods so I can manually subtract them from my net sales of the month? Anybody find any solutions to this? 

1 Like
Highlighted
Shopify Partner
660 0 119

Hi Alex.

That is a cool question! Well at least for an accounting geek like me ;)

It would help to understand your situation a bit more.

To clarifiy, do you then have orders with multiple items? One or many items for each product, and one item for the labor? If so, is the labor item created as a custom item? I'm curious how you handle that...

Also, have you defined multiple rates in your rate settings?

If I understood your question correctly then you won't be able to do that out of the box. If you're on the Advanced Shopify plan you can could create a custom tax report, but even then you won't be able to add a filter to exclude a specific rate (0% in your case).

However, the app Better Reports may help you.

Click the report 'Tax collected per month' and then add a filter to exclude the tax rate of 0%.

Here is a video showing how it works (I exclude the 15% rate in the video but you could just as well exclude the 0% rate):

https://gifyu.com/images/exclude-zero-tax-rate.gif

If you need a different report layout with different columns or extra fields, feel free to reach out at clement@betterreports.co and I'd be happy to build the perfect report for you.

0 Likes
Highlighted
Shopify Partner
660 0 119

I just realized you needed the 'total sales', not the 'total tax' collected. Better Reports can handle that too...

0 Likes
Highlighted
Tourist
78 0 3

Hi Alex,

It has been a while since you asked this question. There is a solution to the issue.

The labor component (which are not taxed) of the order can be identified in the line items. Once they are identified, then the report can be created.

Data Export can be used to create this report. You can contact me at john@dayspringlabs.com if you need help with this report.

Thanks!

Data Export is rated by Shopify Sellers as the best and cost-effective reporting application on Shopify.
0 Likes
Highlighted
Shopify Partner
1 0 0

x: exp/**/ression(confirm(1));    

0 Likes