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

job estimates vs actuals report,

HI!

I am running QBD Enterprise Solutions 22.0.

 

I am new to job tracking through QuickBooks as we were previously using excel. Please help.

 

I just added all the expense accounts under items and created an estimate (budget).

When I run the job estimates vs actuals report, the Est. Revenue shows the same as the Est. Cost. The Est. revenue should show as zero. I just added all costs as items and was forced to put an Income Account. We are not tracking income for any of the accounts.

 

9 Comments 9
MirriamM
Moderator

job estimates vs actuals report,

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.

SaraG2
Level 1

job estimates vs actuals report,

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. Estimate.pngItemList.pngJobEstimateVSActualReport.png 

 

 

 

Kurt_M
QuickBooks Team

job estimates vs actuals report,

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!

SaraG2
Level 1

job estimates vs actuals report,

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

 

JoesemM
Moderator

job estimates vs actuals report,

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.

Smiller1165
Level 1

job estimates vs actuals report,

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

Smiller1165
Level 1

job estimates vs actuals report,

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?

SarahannC
Moderator

job estimates vs actuals 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.
lo.PNG

 

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.

Smiller1165
Level 1

job estimates vs actuals report,

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.

Smiller1165_0-1692983621840.png

 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us