Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
E
ECW2
July 20, 2021
Question

Report Showing Group Costs

  • July 20, 2021
  • 3 replies
  • 10 views

Hi there,

 

I would like to be able to pull a report that shows me the cost of each group we have created. The inventory items that are in the group all have a cost associated with them, so surely there is a way to see the total "cost" of each group in a report.

 

Can someone help? 

 

 

3 replies

C
ChristieAnn 11
Level 9
July 20, 2021

Hi there, ECW2.

 

Welcome to the QuickBooks Community. I'll ensure you're able to pull a report that shows the inventory items that are in the group and the cost associated with them.

 

I suggest running and customizing the Item Listing report. This way, you can filter the columns to show all the created group items and the cost associated with them. Please note that you'll have to manually click the group name to view all the items connected with it.

 

Here's how:

 

  1. Click the Reports menu at the top.
  2. Choose List and Item Listing.
  3. Click the Customize Report button.
  4. Select Item and Cost in the Columns bar.
  5. Go to the Filters tab.
  6. Choose Item in the Search Filters.
  7. From the Item drop-down arrow, select Multiple items.
  8. Choose all item groups that you've made.
  9. Hit OK. Then, OK.

 

For additional information on how you can customize the data by adding or deleting columns or removing information on the header/footer and even personalize the font and style of the report, you can click this article: Customize reports in QuickBooks Desktop.

 

As another option, you can run different reports that have a list of items. Then, export to Excel and customize them if you want to combine the data.

 

Please refer to this article to view steps on how to memorize reports in QuickBooks if you want the same settings of the customized report to be available for future use: Create, access and modify memorized reports.

 

Please let me know how it goes or if you have any other issues or concerns. I want to make sure everything is taken care of for you. Have a good one!

E
ECW2Author
July 21, 2021

Hi there! Thank you for the quick reply! I tried to run the report you mentioned above, but what I am running into is that the cost for every group is coming up to $0.00. Why would this be? I definitely have a cost entered into the inventory item. 

 

Please help!

C
Charies_M
Level 9
July 21, 2021

Hi there, ECW2.

 

I'm here to share some information on why you're seeing zero cost when running the Item Listing report in QuickBooks Desktop (QBDT).

 

If your Item Type is Inventory, it shows an amount under the Cost column. If it's Service type or Non-inventory, then it shows no Cost amount. I'll show you a sample screenshot below so you can notice the difference:

 

 

 

If it's an Inventory type and still not showing cost amount even if you have entered cost in the setup, then let's download the QuickBooks Tool Hub. This tool is designed to automatically diagnose and fix issues within the software. Below are the instructions on how to do it:

  1. Download the most recent version (1.4.0.0) of the QuickBooks Tool Hub. Save the file somewhere you can easily find it.
  2. Open the file you downloaded (QuickBooksToolHub.exe).
  3. Follow the on-screen steps to install and agree to the terms and conditions.
  4. When the install finishes, double-click the icon on your Windows desktop to open the tool hub.
  5. Once the  QuickBooks Tool Hub is open, select Program Problems.
  6. Select Quick Fix my Program.
  7. Start QuickBooks Desktop and open your data file.

To ensure the components are properly updated, please restart the computer after running the tool.

 

If this doesn't work, we can try using the Verify/Rebuild Data tool in QuickBooks Desktop. This tool is used to fix any possible data damage within your company file.

 

Let me show you the steps on how to perform this below:

 

  1. From the File menu.
  2. Click on Utilities.
  3. Select Verify Data/ Rebuild Data.
    QBDTverifyrebuild.PNG

Find out more about managing reports in QuickBooks Desktop through the following articles:

If you need other helpful articles in the future, you can always visit our site: Help articles for QuickBooks Desktop.

 

As always, feel free to add a comment below if you have any other questions while running reports. I'll be around to help. Have a lovely day ahead.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement