Sales Tax Revenue

Any non-Tax accounting topics go here.
#1
juro  
Posts:
918
Joined:
18-Oct-2015 9:11am
Location:
USA
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:
 

#2
Frankly  
Moderator
Posts:
2454
Joined:
21-Apr-2014 9:08am
Location:
California
Sales tax collected is not revenue.
 

#3
juro  
Posts:
918
Joined:
18-Oct-2015 9:11am
Location:
USA
okay, I will swallow my pride, and ask my co-worker.
 

#4
makbo  
Posts:
6840
Joined:
23-Apr-2014 3:44pm
Location:
In The Counting House
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.
 

#5
Posts:
2887
Joined:
21-May-2018 7:50am
Location:
Northern MI and Coastal SC
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.
 

#6
Posts:
3694
Joined:
21-Apr-2014 11:24am
Location:
North Carolina
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.
 

#7
juro  
Posts:
918
Joined:
18-Oct-2015 9:11am
Location:
USA
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
 

#8
Posts:
2887
Joined:
21-May-2018 7:50am
Location:
Northern MI and Coastal SC
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.
 

#9
juro  
Posts:
918
Joined:
18-Oct-2015 9:11am
Location:
USA
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.
 

#10
Posts:
2091
Joined:
21-Apr-2014 12:31pm
Location:
HAWAII
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.
 


Return to General Accounting



Who is online

Users browsing this forum: No registered users and 5 guests