cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to track Use Tax for inventory items that I use (not sell)?

I buy items with no sales tax because I have a resale certificate. I track inventory of all of my items. Some items I don't sell, I use it myself. I created a customer called "My business" so I can make invoices in order to decrease stock every time I use an item. But now, I have these invoices all open, because I did no pay myself for items I used and I wont pay. This may be easy for most people, but my head is not finding a way to do it. So, my problem is: I need to track what items I have used myself, decreasing stock, but not creating a bill to pay and still tracking use tax that I need to pay for that item. How can I do it?

Solved
Best answer 10-15-2018

Accepted Solutions
Highlighted
Established Community Backer ***

Use tax on items purchased tax free is based on average c...

Use tax on items purchased tax free is based on average cost of the item, and NOT retail sales prices - an invoice or sales receipt does not work for that reason.  And in QBO, since there is no by purchase reporting for inventory you have no way of knowing what cost will be used since QBO uses FIFO costing

@ rv

There are several work arounds for use tax floating around, this is my preference

When you take inventory, use inventory adjust, set the adjusting account to the business expense account or owner equity drawing if you are taking the item for personal use, and lower the qty.

Report on that adjusting account to get the total value of the items adjusted

Use enter bills, select the tax agency vendor, select a use tax paid expense account you set up in the chart of accounts first, enter the qty as your sales tax rate expressed as a decimal.  ie 8.25% tax rate enter .0825

and then enter the value you got from the use tax account report.

In the memo block enter something to remind you what it was for

when you use pay sales tax, insure you check both the normal sales tax payable line and the use tax line that will show up.

6 Comments
Established Community Backer ***

If I read it correctly you need to pay sales/use tax on i...

If I read it correctly you need to pay sales/use tax on items you consume but did not sell. Either an Invoice or Sales Receipt with "My Business" as a taxable customer is certainly one way of approaching it. But you do have to account for "paying" the company or "buying" the items from stock. If you are an LLC or a Sole Proprietor you can post the payment received from a member/owner equity account which reflects your cash contributions to the company. In effect you will be "paying" for the items you use. No way around it
Highlighted
Established Community Backer ***

Use tax on items purchased tax free is based on average c...

Use tax on items purchased tax free is based on average cost of the item, and NOT retail sales prices - an invoice or sales receipt does not work for that reason.  And in QBO, since there is no by purchase reporting for inventory you have no way of knowing what cost will be used since QBO uses FIFO costing

@ rv

There are several work arounds for use tax floating around, this is my preference

When you take inventory, use inventory adjust, set the adjusting account to the business expense account or owner equity drawing if you are taking the item for personal use, and lower the qty.

Report on that adjusting account to get the total value of the items adjusted

Use enter bills, select the tax agency vendor, select a use tax paid expense account you set up in the chart of accounts first, enter the qty as your sales tax rate expressed as a decimal.  ie 8.25% tax rate enter .0825

and then enter the value you got from the use tax account report.

In the memo block enter something to remind you what it was for

when you use pay sales tax, insure you check both the normal sales tax payable line and the use tax line that will show up.

Not applicable

Rustler, How do I set up a Use Tax Paid Expense Account?...

Rustler,
How do I set up a Use Tax Paid Expense Account?
Thank you for all your help
Established Community Backer ***

open the chart of accounts, click new, select expense and...

open the chart of accounts, click new, select expense and fill in the rest
Not applicable

When I first read your answer, I thought that it was a Su...

When I first read your answer, I thought that it was a Subaccount to Sales Tax.  I thought it would be on the sales tax liability report.  Now I think I understand that I have to run a report on the tax we owe and make an adjustment in the sales tax owed.  Right?
Established Community Backer ***

correct QB keeps sales tax payable and sales tax reportin...

correct
QB keeps sales tax payable and sales tax reporting very strictly controlled

Need to get in touch?

Contact us