cancel
Showing results for 
Search instead for 
Did you mean: 
captesq
Level 1

Error in Cost of Goods Profit and Loss Report

I have inventory in Quickbooks that sells at a fixed cost. We don't do assemblies. My issue is that the Profit and Loss line for Finished Goods Shipped (COG) when run in detail shows some items at 0.00 and others for over $200.00. The first should have a dollar value of about $4.22 while the second should be $8.10. I've checked the calculated average on the Inventory Valuation reports and the Cost under the Item List; both are correct. So my ultimate question is where does the P&L pull that number from, and second, why would the number change?

Any help is most appreciated. Thanks

 

3 Comments 3
JasroV
QuickBooks Team

Error in Cost of Goods Profit and Loss Report

Thanks for sharing the details with us, @captesq.

 

I can share with you some insights on how we can isolate this issue. Let’s start by updating your QuickBooks Desktop (QBDT) software to the latest release. This way, we can ensure your software is up to date with the latest features and security. 

 

Outdated software causes unusual behavior that affects the performance of your software. To update it, you can follow these easy steps:

 

  1. Go to the Help menu.
  2. Select Update QuickBooks Desktop.
  3. Go to the Update Now tab
  4. Select Get Updates to start the download.
  5. When the download finishes, restart QuickBooks.
  6. Accept the option to install the new release when prompted.

 

You can also see this link for more details about the process: Update QuickBooks Desktop to the latest release.

 

Additionally, you’ll want to ensure the date range of the report is correct. This way, we can guarantee the data shown in the report is accurate and precise. There’s a possibility that the information shown in your Profit and Loss reports is inaccurate due to an incorrect report date.

 

Furthermore, I'm adding this article that you can read and utilize in case you need to learn how to generate a report to show the data that matters to you: Customize reports in QuickBooks Desktop.

 

In case you need further assistance managing your reports in QBDT, tag me in your reply and I’ll sprint back into action. It’s always my pleasure to help and keep in working order. Have a good one and keep safe.

captesq
Level 1

Error in Cost of Goods Profit and Loss Report

@JasroV  Thanks, however, I did all of the above and nothing seems to have changed. It did do a minor upgrade but the error is still there. I closed and re-opened the company file after the update.

 

 

Rubielyn_J
QuickBooks Team

Error in Cost of Goods Profit and Loss Report

I appreciate you doing the troubleshooting steps to fix the issue, @captesq.

 

Let me provide few ways on how to get rid of the error. You can start to repair your company file using the Rebuild Data tool. 

 

Here's how:

 

  1. Go to the File menu.
  2. Select Utilities and then choose Rebuild Data.
  3. On the QuickBooks Information window, click OK. Follow the onscreen steps to save a backup.
  4. Let the tool repair your file.
  5. When the tool finishes, choose OK.
  6. Go to the File menu again, then choose Utilities and click Verify Data.
  7. Let the tool check your file for data issues.

 

If QuickBooks doesn't find any problems, select OK. Otherwise, select Rebuild Now if QuickBooks finds an issue with your company file.

 

However, if the issue persists, let's repair your data using the QuickBooks File Doctor to fix your company file.

 

For more details, feel free to browse this article: Fix data damage on your QuickBooks Desktop company file.

 

 Meanwhile, let me add these resources to help you manage reports in QuickBooks Desktop: 

 

Please continue to reach out to me if you have any other QuickBooks-related concerns. I'm always here to help you out. Have a wonderful Tuesday.

Need to get in touch?

Contact us