Happy Business Starts Here

Cash Collected from Tax vs Operations


Cash Collected from Tax vs Operations

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.