Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
SaraG2
May 18, 2023
Question

job estimates vs actuals report,

  • May 18, 2023
  • 9 replies
  • 67 views

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 replies

MirriamMQuickBooks Team
QuickBooks Team
May 18, 2023

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.

SaraG2Author
May 19, 2023

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.  

 

 

 

Kurt_MQuickBooks Team
QuickBooks Team
May 19, 2023

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!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement