Skip to main content
A
arkvalleyinfo
October 16, 2018
Solved

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

  • October 16, 2018
  • 2 replies
  • 0 views

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?

Best answer by Rustler

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.

2 replies

john-pero
john-pero
October 16, 2018
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
Rustler
RustlerAnswer
October 16, 2018

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.

    A
    arkvalleyinfoAuthor
    October 16, 2018
    Rustler,
    How do I set up a Use Tax Paid Expense Account?
    Thank you for all your help
      Terms & ConditionsAccessibility statement