QBES Job WIP summary Report vs Cost to Complete Report

Thank you for the screenshot provided, Oliver1.

On your Cost to Complete report, your Expected Amount and Estimated Cost has a different amount. This could be the reason why it didn't show as what is on the Job Work In Progress report. Your Job Work In Progress report shows you the level of completion, as long as the job is done. It will also reflect as 100%.

Don't hesitate to hit the Reply button if you have further concerns. 

Hi Adrian,

Thank you for your quick response. The Cost to Complete report completion percentage is base on the % of completion input in contractor module (please see attached). Thus the percentage of completion in Job WIP report should be the same, why in this report it was tag as 100% complete but in the project still in 94%?

Hi Oliver1,

Thank you for the call out about the % to Complete column in the Jobs WIP report.

While we continue to enhance our program to make a report beneficial to our users, I'd like to suggest giving us a call. This way, we can create a case for you and forward it to our engineers.

1. Go to Help, QuickBooks Desktop Help, then Contact us.
2. Enter your question in the Tell us more about your question section.
3. Click Search.
4. Click Get Phone Number or Start a Message. Note: Our phone agents will be open from 4:00 am-7:00 pm PST Monday-Friday.

I'll be around if you have more questions.

We do not have desktop premier edition, not enterprise, but the Cost to Complete by Job report is available in this software.  However, the Cost to Complete report will not fill - it just comes up as zeroes for every job and the percentage complete won't update either.  But if you drill down in the total columns, the information is available.  Why is this?

Good Evening, @Agrifab. 

I hope your day is going well so far. Let's try a few basic troubleshooting steps to help fix the issue within your report. Just follow the steps below. 

Verify Data

1. Go to the File menu. 
2. Hover over Utilities. 
3. Select Verify Data. 

Rebuild Data

1. Go to the File menu. 
2. Hover over Utilities and then pick Rebuild Data. 
3. The rebuild will start after the backup is done. 
4. Press OK when you get the message, "Rebuild has completed." 

Using the Verify and Rebuild Data tool will help resolve the most common data issues know within your QuickBooks Desktop account. 

Touch base with me after trying these steps. Have a great day! 

Hi Candice - thanks for the reply.  I did the verify and rebuild this morning, but we're still having the same issues.  In the cost to complete report:  

It only shows a few old jobs from 2017 - none of the current jobs/estimates

The values for each item are zero, but the total at the bottom of the column are there

If you drill down in the total - all the information is in the detail - including the current jobs/estimates

I've double checked all the preferences to be sure that the system is set up for tracking, but nothing is making that report pull correctly.

Thanks for your help!

Karen

Hi @Agrifab.

I appreciate your time in doing the troubleshooting steps provided by my colleague. Since you're still snot able to see the values of each items, I suggest contacting QuickBooks Desktop Customer Care team. They have the tools to perform screen share and dig in to the possible cause of this issue.

Here's how to contact them:

1. In your QuickBooks Desktop company, go to the Help menu or simply press F1.
2. Click QuickBooks Desktop Help.
3. Follow the on-screen instructions.
4. You can choose how you wanted to be assisted, via Messaging, Callback or Get Phone Number.

If you want to contact us right away, the support hours for phone agents will be open Monday to Friday  from 4:00 A.M. to 7:00 P.M. PST.

I'll be around if you need anything else. Take care.

@Agrifab , I stumbled upon your post and I am having a similar problem (https://quickbooks.intuit.com/learn-support/en-us/reports-and-accounting/re-cost-to-complete-report-...)

So that you don't have to go through all of my updates, I'll summarize. I have found that sometime between late March and last week, something changed in my company file that causes this report to not work. The specific issue I've found is that any job that has an estimate which contains sub-items will no longer show up in the Cost to Complete report.

I was wondering if the old jobs from 2017 which show up in your report use top-level items only in the estimate, whereas all of your newer jobs include estimates with sub-items?

I was also wondering if this is a problem that started occurring for you in the same time frame as I had problems? That is, do you know that this was working at some point around March, but stopped working by the time you posted in late April?

@Agrifab wrote:

Hi Candice - thanks for the reply.  I did the verify and rebuild this morning, but we're still having the same issues.  In the cost to complete report:  

It only shows a few old jobs from 2017 - none of the current jobs/estimates

The values for each item are zero, but the total at the bottom of the column are there

If you drill down in the total - all the information is in the detail - including the current jobs/estimates

 

I've double checked all the preferences to be sure that the system is set up for tracking, but nothing is making that report pull correctly.

 

Thanks for your help!

Karen

 

---