Page 1 of 1

Sales Tax Revenue

PostPosted: 9-Jan-2019 11:00am
by juro
The Sales Tax return reports total revenue, and I am trying to adjust the sales account in Quickbooks, so that they agree.

There are several categories of revenue, one of which is Sales Tax, which is a liability that is paid in full each month.

Right now my sales account is off by the Sales Tax. My journal entry needs to credit both revenue & Sales Tax liability.

confused. :idea:

Re: Sales Tax Revenue

PostPosted: 9-Jan-2019 3:48pm
by Frankly
Sales tax collected is not revenue.

Re: Sales Tax Revenue

PostPosted: 9-Jan-2019 8:02pm
by juro
okay, I will swallow my pride, and ask my co-worker.

Re: Sales Tax Revenue

PostPosted: 10-Jan-2019 8:56am
by makbo
juro wrote:okay, I will swallow my pride, and ask my co-worker.

Are you using the sales tax tracking capability built in to Quickbooks, or trying to doing it all with journal entries? The former is recommended.

Re: Sales Tax Revenue

PostPosted: 10-Jan-2019 11:07am
by CornerstoneCPA
Is client including sales tax in their gross revenue figure? If so, why? It should be going straight to a liability account, completely bypassing revenue.

Use the sales tax tracking as makbo suggested, it really simplifies everything.

Otherwise, do an entry as follows to correct revenue:

DEBIT revenue
CREDIT sales tax liability

This will then reduce equity and get you to where you need to be, assuming sales tax liability and payments are correct.

Re: Sales Tax Revenue

PostPosted: 11-Jan-2019 11:24am
by SumwunLost
Are you sure Sales Tax and Sales should be the same? I have a job on my desk now where Sales Tax is reported on the accrual basis but Sales for income tax purposes are recorded on cash basis.

Re: Sales Tax Revenue

PostPosted: 13-Jan-2019 12:01am
by juro
CornerstoneCPA wrote:Is client including sales tax in their gross revenue figure? If so, why? It should be going straight to a liability account, completely bypassing revenue.

Use the sales tax tracking as makbo suggested, it really simplifies everything.

Otherwise, do an entry as follows to correct revenue:

DEBIT revenue
CREDIT sales tax liability

This will then reduce equity and get you to where you need to be, assuming sales tax liability and payments are correct.


here is what i mean.
https://i.imgur.com/hEE9uw1.jpg
https://i.imgur.com/HiTjQLZ.jpg

Re: Sales Tax Revenue

PostPosted: 14-Jan-2019 9:25am
by CornerstoneCPA
What other system are they using besides QBs? Certainly they have a POS or warehouse management system (but since it's pizza/deli, I assume it is a restaurant of sort, so POS). Sounds like a configuraiton error in the POS is causing sales tax to be reported as revenue instead of strictly a liability. If they ARE using an external system that exports to Quickbooks, then the prior suggestion of using the QB sales tax tracking will not work (at least, it did not when I last tried using it under this scenario).

Since there is an error in sales tax calculation (likely result of rounding on that volume of sales), what I said previously still applies and also corrects their financial statements. Disregard sales tax revenue except to eliminate it. For the discrepancy, plug to equity unless MI gives a discount for paying early, then I account for it as other income.

Re: Sales Tax Revenue

PostPosted: 14-Jan-2019 7:24pm
by juro
thanks. today i turned over the client books for review, with sales tax excluded from revenue.

man, i thought i was going crazy last week.

Re: Sales Tax Revenue

PostPosted: 2-Dec-2019 11:54am
by actionbsns
Unless you are in Hawaii. But then it's not really sales tax, it's general excise tax. In this state the GET is revenue on which taxpayers also pay GET and GET is an expense. The sales tax feature in QB doesn't work for us.