Free Trial: TheSiteFactory.com

Sales Tax Revenue

Any non-Tax accounting topics go here.
#1
juro  
Posts:
227
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:
1762
Joined:
21-Apr-2014 9:08am
Location:
California
Sales tax collected is not revenue.
 

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

#4
makbo  
Posts:
5978
Joined:
23-Apr-2014 3:44pm
Location:
District 13
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:
475
Joined:
21-May-2018 7:50am
Location:
Hilton Head Island, 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:
1246
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:
227
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:
475
Joined:
21-May-2018 7:50am
Location:
Hilton Head Island, 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:
227
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.
 


Return to General Accounting



Who is online

Users browsing this forum: No registered users and 1 guest

cron