Hi there, @SaraG2.

I want to ensure you get the help you need.

To start with, I'd like to verify how you set up the item, like what category type (Service, Inventory, and others) did you use. Also, can you provide more details about the expense accounts under items that you've created with the estimate? Any information is appreciated.

We're looking forward to hearing from you.

Hi Miriam, 

Certainly! To begin, I categorized the item as a service. The expense accounts associated with the items created in the estimate are costs associated with providing the service or completing the construction project. Costs associated with the items in the estimate should be posted to WIP when paid. The only income account should be the home sale.

I followed this Construction Job Costing Video to do the setup, but I am missing something.  

Thanks for getting back here in the thread, @SaraG2.

Before anything else, know that I appreciate you for providing more details about your concern. Upon carefully scanning your screenshot, it looks like this has something to do with your QuickBooks Desktop (QBDT) company. With that said, I'd recommend performing the Verify and Rebuild option inside the company file to determine the root cause of the issue and proceed to fix it.  I'll be happy to walk you through the process to get you going:

1. Access your QuickBooks Desktop company.
2. Go to Window then select Close All.
3. Go to File, then select Utilities.
4. Select Verify Data. If you see:

• QuickBooks detected no problems with your data—your data is clean, and you don’t need to do anything else.
• 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.

You can check this article for more details about the process: Verify and Rebuild Data in QuickBooks Desktop.

Moreover, I've got this handy article to help you modify your business reports inside QBDT: Customize reports in QuickBooks Desktop.

@SaraG2, please don't hesitate to let me know how it goes. It's my pleasure to provide further assistance if you need me. Stay safe, and have a great weekend!

I was able to repair the company file, but this did not fix the problem.

Thanks for the update, @SaraG2. Allow me to chime in and share some insights about the Job Estimate vs. the Actual report in QuickBooks Desktop.

The estimate is a non-posting transaction that has no impact on your financial records. The transactions are only added to the report when the bill or invoice has been paid. 

Since the service item is added as an estimate it will be considered as estimated revenue. The EST revenue will not show zero even if you're not tracking any income account because it's working as designed in QuickBooks Desktop.

If you want to zero out the EST revenue, we can export the report to an Excel file and manually edit the amount. I'll guide you on how:

1. Go to Reports, then Jobs, Time & Mileage.
2. Select Jobs Estimate vs. Actuals Details. Then, choose a Customer: Job from the drop-down.
3. Click the Excel drop-down from the top menu, then Create New Worksheet.
4. Hit Export.
   
   

Once done, edit the amounts to zero. You can learn about exporting reports at this link: Export reports as Excel workbooks in QuickBooks Desktop.

I’ve attached a reference in case you want to keep the same report settings for future use: Create, access, and modify memorized reports. It helps you access the information quickly to save time.

Just click the Reply button below if you need further assistance in running your other reports. I'd be pleased to help you. Have a great rest of the day.

How can I add a percent column to show the earned revenue as a % as well as a dollar amount?

Hello - I'm running QB Enterprise Professional 23.0.  I'm wanting to have the earned revenue diff show as $ and %.  How can I add the % column to this report?

Thanks for joining this conversation, Smiller1165.

Currently, the Jobs Estimate vs. Actuals Details report provides two main columns: Estimated Revenue and Actual Revenue.

The report only includes columns that display the difference between these values, both in terms of $ amount and as a percentage by going to the Customize button> tick the % Difference box and $ Difference box.

If you're looking for column specific for earned revenue, you can export the report to Excel and then manually insert an extra column to incorporate the earned revenue. Then, I suggest sending feedback to our product engineers. You can input a few details that make them aware of the other features you're looking on the report. Here's how:
 

1. Go to the Help menu in your company file.
2. Select Send Feedback Online and choose Product Suggestion.
3. Click the Type of Feedback drop-down arrow and select Product Suggestion.
4. Choose Reports in the Product Area.
5. You can then add brief information in the box.
6. Enter your name and e-mail address.
7. Then, click the Send Feedback button.

If you have suggestions or other feedback to share, feel free to post them. We'll take them as an opportunity to improve QuickBooks. Keep safe.

The reason I'm asking this question is because even when I tried to add the % in customize report, it will not add it.  You state that both $ and % show, they do not.