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.