Skip to main content
G
Gambit
March 14, 2024
Question

Work in Progress Report

  • March 14, 2024
  • 1 reply
  • 0 views

When exporting a Work in Progress report to Excel, I just learned the math used to calculate the TOTAL at the bottom of the "Earned Revenue" column changes. The same report, 2 different numbers. Why would QB's do that?

 

In the attached example, it's a $100K+ swing between QB's and Excel.

 

I believe the Excel calculation is the correct WIP adjustment, not the QB report.

 

Thoughts?

1 reply

R
ReymondO
March 14, 2024

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.

G
GambitAuthor
March 15, 2024

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...

R
RheaMaeH
March 15, 2024

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!

Terms & ConditionsAccessibility statement