Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
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:
If you need to sell the items, just set them up as inventory items.
Here's how:
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.
@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
Please Learn from this input. No, there is no Tracking this differently, when it is already inventory.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here