cancel
Showing results for 
Search instead for 
Did you mean: 
BPC
Level 1

Inventory item delema

I have a cabinet shop and I would like to keep track of the hardware that I use. Is there a way to do that without having to sell each item at a specific cost. If I could somehow enter a quanity of each hardware item  then it could keep track of how many items I use on a given job and how many I have on hand. The job report could show how much the hardware cost per job but I don't want to have to put each hardware item on the invoice with a cost as if I am selling the items individually.

3 Comments 3
SophiaAnnL
Moderator

Inventory item delema

There are two ways to track these inventory items, BPC.

 

If you don't want to sell the hardware at a specific cost, you can create an asset account and track the transactions there.

 

Here's how:

  1. Click Lists at the top, and then select Chart of Accounts.
  2. Click the Account button in the lower left-hand corner.
  3. Select New.
  4. Choose the account type and proceed with setting up the asset account.
  5. Click Save & Close.

If you need to sell the items, just set them up as inventory items.

 

Here's how:

  1. Click Lists at the top, and then select Item List.
  2. Click the Item button in the lower left-hand corner.
  3. Select New.
  4. Complete the inventory item setup.
  5. Click OK when finished.

I'd also suggest consulting an accountant for best advice on how to record this inventory in your books.

 

I'm always here if you need anything else. Thanks for dropping by.

Rustler
Level 15

Inventory item delema


@BPC wrote:

I have a cabinet shop and I would like to keep track of the hardware that I use. Is there a way to do that without having to sell each item at a specific cost. If I could somehow enter a quanity of each hardware item  then it could keep track of how many items I use on a given job and how many I have on hand. The job report could show how much the hardware cost per job but I don't want to have to put each hardware item on the invoice with a cost as if I am selling the items individually.


Inventory is something you stock to sell or to use in a service you provide, so your hardware (hinges, drawer pulls etc) should be inventory items if you stock them\

 

cost is what you pay for the item, sales price is what you are concerned about I think, items can be put on an invoice or sales receipt at a zero dollar sales price and the  item cost will still post to COGS.

 

You can also just use inventory adjust, set the adjusting account to COGS, and lower the qty, select the customer/job on the adjustment screen.

 

Items could be listed in a bundle item, set to not print all items and included on the invoice or sales receipt too

qbteachmt
Level 15

Inventory item delema

@SophiaAnnL

 

Please Learn from this input. No, there is no Tracking this differently, when it is already inventory.

 

@BPC

 

For this: "The job report could show how much the hardware cost per job but I don't want to have to put each hardware item on the invoice with a cost as if I am selling the items individually."

 

All you need to do is Buy them as inventory, and that puts them on hand with cost. Then, you Relieve them from inventory by either selling them or Adjusting Inventory. On the Adjustment Screen, you see the field to Job Track that you pulled from stock on hand. This shows in Job Reporting, but now you have to Customize the report to see if it is filtered on "Accounts = ordinary income/expense." Or, it might be filtered on All Sales Items. The problem with that Account Filter is that it isn't including COGS adjustments. It works fine, but you need on customize the reports to meet your own operations.

 

Please see my attachment. The hardware was Used, not Sold, for that job.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us