Item Profitabiity Report

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!

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

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.

Dear @KlentB 

Thank you for your recommendations. There was nothing wrong with the Company file.

I did find out the reason for this one item not tracking the Actual Cost.

If there is not a Customer:Job included in the bill from a vendor - the Actual Cost is not update in the Item Profitability report.

Thanks for you assistance.

Mark

PS Hope this helps someone else...