Skip to main content
March 28, 2024
Question

Adding Cost to Inventory Stock Status by Item

  • March 28, 2024
  • 1 reply
  • 0 views

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 reply

AlverMarkT
March 28, 2024

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.