• Was this page helpful?
Intuit Blog
|
Support
GoPayment
|
Payroll
|
QuickBooks Online
|
QuickBooks
|
Website Services
Intuit
Sign In
Register
Banking Creating & Customizing Forms Importing & Exporting Data Inventory Journal Entries & Accounting Tasks Multicurrency Vendors & Vendor Center Printing in Quickbooks QuickBooks Installation, Update, & Conversion
Customers & Customer Center Reports & Report Center QuickBooks UPS, FedEx Shipping Manager QuickBooks Online Services & Features QuickBooks File, Edit & View Menu Tasks QuickBooks Performance Issues & Program Errors QuickBooks Networking & User Setup
QuickBooks Attached Documents QuickBooks Connect QuickBooks Enterprise Solutions QuickBooks for Mac QuickBooks Online (US) QuickBooks Online Suggestions for Improvement QuickBooks Point of Sale QuickBooks Simple Start Edition QuickBooks Time and Billing Manager Cash Register Plus Customer Manager
Customer Manager & Client Manager Desktop Intuit Commissions Manager Intuit Data Protect Intuit Websites Review Websites and Get Feedback GoPayment Intuit Sync Manager New Intuit Business Tools & Resources Quickbase Quicken Turbotax
Better Because of You Considering Buying QuickBooks? Quickbooks Educational Resources QuickBooks Service/Support Policies & Procedures Classifieds
QuickBooks Payroll (Desktop) Intuit Online Payroll ViewMyPaycheck
Builders & Contractors Non-profit Real Estate Retailers Service Industries Other Industries
QuickBooks Canada QuickBooks UK Desktop QuickBooks UK Online QuickBooks Singapore Online QuickBooks en EspaƱol QuickBooks Australia
  • QuickBooks Tasks
  • Intuit Products
  • Intuit Resources
  • Intuit Payroll
  • Industries
  • International
Leaderboard
Hide Advanced Search
 
All of these words
Any of these words
This exact phrase
None of these words
In this forum
With posts written by
With posts from
to
mm/dd/yy
mm/dd/yy
Show Advanced Search
Home   Help with Intuit Products   Quickbooks Tasks   Vendors & Vendor Center  
hide
04/19/2013 at 09:23AM PDT
HTML Generator Sample Page

Need to verify a charge from Intuit? You can now retrieve the last 90 days of your Intuit order history from the QuickBooks Support Site

We are working on making some changes to the forums, in an effort to make valuable information more accessible. If you have 10-15 minutes, we would love to get your input through this survey. 

70
71
bO1aySbfyr36jyacfA8pyY
Subscribe RSS
   
christy4
christy4
Questions asked: 1
Questions answered: 0
Points earned: 0
christy4
christy4
Questions asked: 1
Questions answered: 0
Points earned: 0
New Member
01/18/10 9:33am PST
Viewed by asker 01/23/10 12:46pm PST

Sales tax on inventory

US QuickBooks Pro for Windows

I order inventory products and pay the sales tax up front, then I charge my customers tax at the time of sale. Right now QB creates a sales tax liability for those sales to my customers. When I receive the bill for the inventory, I have created an expense account called Sales Tax Paid . This creates 2 problems. 1. I have this large outstanding liability to be paid  and 2. The sales tax that was already paid should be included as part of the COGS so I can't just do a journal entry and move it to offset the balance due in liabities. Any ideas on how I can track this and keep my COGS accurate?

Submit a reply to this question
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
 Report Abuse
8 Replies
Rustler
Rustler
Questions asked: 136
Questions answered: 54727
Points earned: 137997
Allstar
Allstar
Advisory council of community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
Rustler
Rustler
Questions asked: 136
Questions answered: 54727
Points earned: 137997
Allstar
01/19/10 9:18am PST
Best Answer - Chosen by the Community

Sales tax on items for resale is part of the cost of the item, you have to roll it into the cost, not expense it. see if this entry helps any. (say sales tax when you see the word shipping)

http://my246shop.com/Rustler/t...

 

If I've helped, mark it solved.

My QB tips Blog >> http://onsale-apparel.com/Rust...

Targeted Tutorials - one problem - one solution>> http://community.intuit.com/po...
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
5
Reply to this Answer
 Report Abuse
 
 
 
christy4
christy4
Questions asked: 1
Questions answered: 0
Points earned: 0
christy4
christy4
Questions asked: 1
Questions answered: 0
Points earned: 0
New Member
01/22/10 9:29am PST

Per your suggestion, If I enter each item as I receive it and increase the cost per item to include the sales tax paid then that will keep my COGS accurate.

How do I "fix" the sales ticket?  I still want my cutomers invoice to show each item cost, a subtotal, a tax amount, and a total due. Right now , I enter the item number and qty. QB calculates the sales tax and I print the invoice. But this creates that outstanding sales tax liability account that I shouldn't have because the tax has already been prepaid when I purchased the items.

AND, how do I fix the current outstanding ST liability account to show 0?

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
Rustler
Rustler
Questions asked: 136
Questions answered: 54727
Points earned: 137997
Allstar
Allstar
Advisory council of community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
Rustler
Rustler
Questions asked: 136
Questions answered: 54727
Points earned: 137997
Allstar
01/23/10 4:59am PST

It doesn't work that way, at least in any state I have heard of.

Sales tax is function of retail sales, if you retail you collect sales tax, hold on to it, and pay it.

If you retail and you buy items for retail, in most states you have the option to buy tax free by filling in a form and handing it to your vendor.

Some states allow you to take a credit for sales tax paid on the items you retail, I have not worked with that and just thinking about how to track it in QB is a problem.

If I've helped, mark it solved.

My QB tips Blog >> http://onsale-apparel.com/Rust...

Targeted Tutorials - one problem - one solution>> http://community.intuit.com/po...
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
christy4
christy4
Questions asked: 1
Questions answered: 0
Points earned: 0
christy4
christy4
Questions asked: 1
Questions answered: 0
Points earned: 0
New Member
01/23/10 9:27am PST

I am working with a group in Independent Sales people.  They order products at wholesale cost and pay shipping, and sales tax (on the retail amount) up front. Then they sell to their customers and recover the sales tax. The company that sells them the products pays the state sales tax amounts. For income tax purposes, the sales tax collected by the IS person is included as part of their income and the sales tax that was prepaid on the products is part of COGS.

What if I make an inventory item called Sales Tax, enter every item as non taxable, and include a line item on each invoice for sales tax instead of letting QB figure the tax for me?  That seems really inconvenient but it's all I can think of.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
Rustler
Rustler
Questions asked: 136
Questions answered: 54727
Points earned: 137997
Allstar
Allstar
Advisory council of community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
Rustler
Rustler
Questions asked: 136
Questions answered: 54727
Points earned: 137997
Allstar
01/23/10 11:33am PST

Ok see this a different situation, this is like a mary kay kind of thing.

Do not set up sales tax at all, the company is taking care of that for you.  In QB sales tax always uses sales tax payable.  Create an Other charge item called sales tax, point it to an income account, use that item on the sales document.

Use the invoice designer to get rid of the stock sales tax block on the sales document.

All you do is sell the product and the total sales is income.

 

If I've helped, mark it solved.

My QB tips Blog >> http://onsale-apparel.com/Rust...

Targeted Tutorials - one problem - one solution>> http://community.intuit.com/po...
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
Gump47371
Gump47371
Questions asked: 0
Questions answered: 4
Points earned: 4
New Member
04/21/11 4:43pm PDT

 I know this is an old question, but am in this same situation, and would like to share how I have set mine up, and get opinions from some about it.

 

What I have done is set up an Other Asset account called Sales Tax Paid on Inventory. When I purchase inventory that has sales tax charged, I include the sales tax in this account. Then, when I owe Sales Tax for my Sales, I deduct what I have paid from what I owe.

 

Does anyone do this, and is this allowed? I am in Indiana.

 

Thank you

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
Rustler
Rustler
Questions asked: 136
Questions answered: 54727
Points earned: 137997
Allstar
Allstar
Advisory council of community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
Rustler
Rustler
Questions asked: 136
Questions answered: 54727
Points earned: 137997
Allstar
04/22/11 4:56am PDT

Some states allow that, you need to check with your state office.

When you pay sales tax in that situation are you using adjust sales tax and decreasing the amount due and using that account as the source - you should be.

Be sure you mark those receipts so you can find them in the event of a state sales tax audit, that kind of thing they look at.

Since the IRS says any cost including taxes is part of cost I have no clue what they will say about it, but if you are doing it all the time and the state allows it, I would guess it would pass.

If I've helped, mark it solved.

My QB tips Blog >> http://onsale-apparel.com/Rust...

Targeted Tutorials - one problem - one solution>> http://community.intuit.com/po...
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
Gump47371
Gump47371
Questions asked: 0
Questions answered: 4
Points earned: 4
New Member
04/22/11 5:25pm PDT
Latest post

First off, thanks for the reply. I have found a local Revenue office here and will be checking with them the first of next week.

 

 Let me give a little more insight into my situation, might help you understand. My business is a business in which we deliver items, mostly grocery,  to local residents. They order through a website, and it is on demand. Therefore, we usually don't receive bills, but purchase items from retail outlets and then markup the item. The reason I have neglected filing for tax exempt at these outlets is because at the local grocery stores here, you must fill out a form, give it to the cashier, and then they process the transaction tax exempt. Our niche is quick delivery, and I would like to avoid this if possible. Will have to see if the state of IN can understand our situation *crosses fingers*.

Since most items are purchased with a CC, I process the receipts through the checkbook in QB. Therefore, I record the item as costing us only the pretax price. I then switch to the Expenses tab, choose the Other Assets account of "Sales Tax Paid on Inventory", and record the Sales Tax on that tranaction there. It records it, but doesn't figure in as an expense.

 

Will keep you updated on what I find out. I don't know if the tax law allows this, but it benefits both. On their end, we only pay Sales Tax annually right now, and IN is getting their money much sooner than if we wait and pay it when it is due. On our end, it makes it much easier for our delivery drivers when purchasing items for resale. However, logic and government workers sometimes don't find each other very easily.

 

 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
   
Submit a reply to this question
 
Subscribe RSS
Tags for this topic
    Help other users find this post by tagging it
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
Peruzzi
2 mins ago
Peruzzi
replied to
How to credit a client's ac...
in: Customers & Customer Center
donnaept
29 mins ago
donnaept
posted
How can I remove Unrestrict...
in: Reports & Report Center
JJrenta
31 mins ago
JJrenta
posted
entering inventory
in: QuickBooks Online (US)
rklockner
41 mins ago
rklockner
posted
Am I able to get transactio...
in: Customer Manager
raywhite28
48 mins ago
raywhite28
replied to
How to credit a client's ac...
in: Customers & Customer Center
Community Home Help with Intuit Products Start & Grow Your Business Help for Accountants Small Business Blog Join us on Facebook Follow us on Twitter Watch us on YouTube Meet us on LinkedIn
About Intuit | Careers | Register Your QuickBooks | QuickBooks Affiliate Program | Privacy | Legal | Contact Us | Our Hosts
© 2013 Intuit, Inc. All rights reserved. Intuit and QuickBooks are registered trademarks of Intuit, Inc.
Terms and conditions, features, support, pricing and service options subject to change without notice.
TRUSTe - Privacy Standards and Principles
Intuit Websites - Create the perfect site
Intuit Small Business
QuickBooks Accounting Software
Small Business Grants
QuickBooks Online Accounting
Intuit Payroll Services
Intuit Credit Card Processing
Intuit Business Directory
Intuit GoPayment
Intuit Small Business Education
Intuit Small Business Blog
Love a Local Business