Cash Collected from Tax vs Operations

[gregoryodonnell]

I'm trying to look at cash collected from actual operations/revenue items as opposed to total collections which includes tax collected.

Does anyone have a report they run or a roundabout to calculate this value?

I'm currently looking at invoices paid in the period and looking up what the tax amount was for that invoice. It mostly works, in a quick and dirty way.

We connect and sync all transactions into Netsuite so I also looked into changing the Account Receivable debit on the tax accounting codes to a separate AR account, but it does not appear we are able to change the "debit" account on tax codes. 

Any ideas/solutions would be greatly helpful. 

Thanks