Work in Progress Report

Thanks for sharing your concern on the QuickBooks Community page and adding a screenshot, @Gambit.

Upon review, the calculation in the Excel report shows the correct calculation. A minor data issue in QuickBooks Desktop might cause the incorrect calculation.

To rectify the problem, we can run the Verify and Rebuild Data tools in QuickBooks. These tools can help us verify the issue and fix its possible cause.

To verify your company data, follow these steps:

1. Go to Window and select Close All.
2. Click the File menu, then select Utilities.
3. Click Verify Data. If you see:

• An error message—search for it on our QuickBooks Desktop support site for how to fix it.
• Your data has lost integrity—Data damage was found in the file. Rebuild your data to fix it.

Once done, proceed with the Rebuild your company file data section of this article to fix your data: Verify and Rebuild Data in QuickBooks Desktop.

Before performing the steps above, make sure you're using an updated version of QuickBooks Desktop. 

If the issue persists, run QuickBooks Tool Hub to fix common data problems in your company file. 

Moreover, I'll share this resource about customizing reports in QBDT: Customize reports in QuickBooks Desktop. This will help get the data you need the most for your business. 

If you have additional questions about the Work in Progress report or any QuickBooks-related concerns, just add them to the Reply section. I'll be here to help you out. Have a good one.

Verify and rebuild, no change. I went back the past 2 years and the WIP report calculates the same. I don't think this is a minor data issue. I think this is the way QB coded the report. Surely I'm not the only one who sees this as a mistake...

Hello there, Gambit. I understand that you're facing a challenge with an inaccurate value on your Work in Progress Report.

The calculations in your Excel report seem correct, but we need to investigate it further to find out where the differences in the Work in Progress reports are coming from. I recommend contacting our Customer Care team, who are experts in dealing with such situations. They can securely review your account and investigate the issue.

Here's how to reach them:

1. Open QuickBooks.
2. Go to Help, then select QuickBooks Desktop Help.
3. Select Contact Us.
4. Enter a brief description of your concerns.
5. Click Continue.
6.  Choose to chat with us or Have us call you.

To ensure we address your concern, our representatives are available from 6:00 AM to 6:00 PM on weekdays and 6:00 AM - 3:00 PM on Saturdays, PST. See our support hours and types for more information.

In addition, I would like to share a resource with you about customizing reports in QBDT. This will help you get the data you need most for your business: Customize reports in QuickBooks Desktop. 

Please don't hesitate to reach out to us if you have any questions about the Work in Progress report or any other QuickBooks-related concerns. I'm always here to help. Stay safe!