Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

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?
mnh4fcs
February 5, 2023
Question

Item Profitabiity Report

  • February 5, 2023
  • 4 replies
  • 23 views

Most of the items in the Item Profitability Report correctly report the Actual Cost and Actual Revenue.

The cases where it does not, from what I observe,  is when the item is billed from a vendor who is not the Preferred Vendor..

 

Is that a correct assessment of why certain costs are not showing up?

Any other suggestions on other reasons only some Actual Costs are always $0 even when there are bills from vendors for the item?

 

Thanks

Mark

 

4 replies

Nicole_N
Nicole_NQuickBooks Team
QuickBooks Team
February 6, 2023

Hi there, @mnh4fcs. Thanks for taking the time to explain that here. Allow me to get this sorted out so you can get the data you need.

 

As I try to run the Item Profitability report here in my end, it's giving me an amount in the Act. Cost column.

 

In your case, you might be experiencing data issues that caused certain amounts to not show up. I'll share some steps with you that can resolve common data issues in QuickBooks. 

 

Here's how:
 

  1. Go to the File menu, hover over Utilities, and then select Rebuild Data.
  2. Click OK and follow the onscreen steps to save a backup.
  3. Let the tool repair your file. It may take some time. QuickBooks may seem stuck, but as long as you can move your mouse, the tool is working.
  4. When the tool finishes, select OK.
  5. Go back to the File menu. hover over to Utilities, and then select Verify Data.
  6. Let the tool check your file for data issues.

 

If QuickBooks doesn't find any problems, select OK. You can keep using your company file. You don't have any data damage. If QuickBooks finds an issue with your company file, select Rebuild Now.

 

For more details, see this article: Fix data damage on your QuickBooks Desktop company file.

 

Aside from that, you can also use the QuickBooks File Doctor to fix your company file if you're getting the same result.

 

Moreover, ensure that you're using the correct item in the bill when the purchases were made. 

 

Once done, go back to the Item Profitability report and check if you can see an amount in the Act Cost column.

 

You may want to visit this article to learn how to personalize reports: Customize reports in QuickBooks Desktop.

 

If you have additional questions about the Item Profitability report, let me know in the comment below. I'd be happy to answer them for you. Stay safe!

mnh4fcsAuthor
February 7, 2023

Hi @Nicole_N 

 

Thanks for you quick reply. I ran through the suggested steps in your post. The condition is still the same.

For bills entered specifying an item - that does not have the preferred vendor, or is billed from a different vendor the Actual Cost is not updated in the Item Profitability Report..

 

I verified that the bills fort the vendors on the item in question - included the item on them.

For all the cases where the Actual Cost is correct - the bill was from the Preferred Vendor of the item.

 

Not solved yet!

 

Mark

 

 

Klent
Level 8
February 7, 2023

I appreciate the efforts you've exhausted in performing the steps above, mnh4fcs. Allow me to share another set of troubleshooting procedures that can rectify the underlying problem.

 

That behavior seems odd. The actual cost should show whether the item is billed from a regular or preferred vendor. Take a look at my screenshots below:

 

 

This report discrepancy is an indication of a potential data integrity issue. Since the issue still persists after verifying and rebuilding your data, we can install the QuickBooks Tool Hub. This program is a collection of tools that can help resolve major issues and errors that a user might face while working in QuickBooks Desktop. 

 

For the best experience, we recommend using this software on Windows 10, 64-bit. Here's how to install it:
 

  1. Close QBDT.
  2. Download the most recent version (1.6.0.3) of the QB Tool Hub.
  3. Open the file you downloaded (QuickBooksToolHub.exe).
  4. Follow the on-screen steps to install, then agree to the terms and conditions.
  5. When the installation finishes, double-click the icon on your Windows desktop.

 

Once done, it's time to run the Quick Fix my File utility:
 

  1. From the tool hub, select the Company File Issues tab.
  2. Select Quick Fix my File.
  3. Once the process is completed, click OK and then open QuickBooks again.

 

If the same thing happens after running the probability report, you'll have to utilize QuickBooks File Doctor:
 

  1. From the tool hub, go to the Company File Issues tab.
  2. Select Run QuickBooks File Doctor.
  3. Choose your company file from the drop-down menu.
  4. Select Check your file (middle option only), then click Continue.
  5. Enter your QuickBooks admin password, then hit Next.

 

Once the scan finishes, check your records again. Please know that your issue may have been resolved even if the scan says it was unsuccessful.

 

Finally, I recommend reading this article to help keep track of the services and products that you buy and sell: Customize items reports.

 

Keep me posted if you have any other concerns or further questions. I'll always have your back.

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