Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
AmandaEQ
Level 1

Adding Cost to Inventory Stock Status by Item

I cannot find a report that I can view all in one, the quantity on hand the cost of the item. I am able to view Sales Price, but I would like to know how much of an item I have and my cost for that item. The cost option is not available in the Customization of the report.

1 Comment 1
AlverMarkT
Moderator

Adding Cost to Inventory Stock Status by Item

It's great having you again here in the Community, @AmandaEQ.

 

Although we can't add a column to see the cost of each item in the Inventory Stock Status by Item, I can suggest an alternative report in QuickBooks Desktop (QBDT) to achieve the customizations you need.

You can consider running the Inventory Valuation Detail report to show the quantity on hand with the corresponding cost for each item and its sales price. I'll outline the steps below.

 

  1. Go to the Reports menu.
  2. Select Inventory from the drop-down menu, then choose Inventory Valuation Detail.
  3. Choose the reporting period. 
  4. Click on Customize Report.
  5. From the Display tab, put a checkmark for Sales Price.
  6. Select the Filters tab.
  7. If you need to choose specific inventory items, select the Item filter from the Current Filter Choices section.
    a. Select Multiple items... from the drop-down menu and put a checkmark for the inventory items you want displayed.
  8. Hit OK.

 

If you want to save the customizations of your reports in QBDT, let me add this article as a reference: Create, access, and modify memorized reports.

 

Let us know if you have further questions about customizing inventory reports in QBDT. We're committed to offering ongoing support. Take care. 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us