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

when I run job estimates vs actual detail report the est cost number do not match estimate numbers for job

 
7 Comments 7
SarahannC
Moderator

when I run job estimates vs actual detail report the est cost number do not match estimate numbers for job

Hello there, PJL0999.

 

The amount recorded from the estimate will be the same amount showing in the Est. Cost number in the Job Estimates vs Actual Detail report. One thing we can do is to double-check the transaction. Here's how:

 

  1. Open the Job Estimates vs Actual Detail report.
  2. In the Est. Cost column, double click the amount.
  3. Then, open the transaction by clicking it twice.
  4. Review the amount and correct it if necessary.
  5. Click Save and Close.

 

All transactions coming from the estimate will match unless there is a transaction that does not come from the estimate. For more details about managing report in QuickBooks Desktop, check these articles:

 

 

Let me know if you have other questions. Take care always.

PJL0999
Level 1

when I run job estimates vs actual detail report the est cost number do not match estimate numbers for job

see attached for problem

Pabz_L
QuickBooks Team

when I run job estimates vs actual detail report the est cost number do not match estimate numbers for job

Hello there, @PJL0999.

 

 Job Estimates vs. Actuals Detail offers detailed costs and revenues for the customer or job you have selected. It compares estimated and actual costs and estimated to actual revenue for each job that you invoiced. I suggest checking each amount under Est.Cost column to review the details why it shows a different amount.

 

You can also check the date range, it should be matched on the period here the estimates have been entered.

 

You can use this article on how to customize reports: Customize reports in QuickBooks Desktop.

 

I want to make sure that this issue will get resolved. Please leave a comment below if you need further assistance. I am always here to help.

Lolly3
Level 1

when I run job estimates vs actual detail report the est cost number do not match estimate numbers for job

I too am having job est vs actual detail problems.  I want my expenses to fall in the correct estimated item line. So in enter bills, I changed the bill from expense to item.  now that vendor invoice amount doesn't show as an expense on job Profit Loss report. please help.

Ryan_M
Moderator

when I run job estimates vs actual detail report the est cost number do not match estimate numbers for job

Hi @Lolly3,

 

You can go through a few things I'll share below to get this bill to appear on the Profit and Loss by Job report in QuickBooks Desktop (QBDT).

 

First, open the bill in question. Go to the Items tab, and ensure the correct job is assigned under the Customer:Job column.

 

You can also check if the correct date range is set on the Profit and Loss by Job report.

 

If both of these are without issues, proceed with the Verify and Rebuild Data tools. Refer to this article for the steps: Verify and Rebuild Data in QuickBooks Desktop

 

In case you encounter any other issues which appear to be a cause of company file integrity, refer to this article: Fix data damage on your QuickBooks Desktop company file.

 

Keep in mind that you're always welcome to post here in the Community if you have any other concerns with your reports in QBDT. I'll be around to help you out. 

becky60
Level 1

when I run job estimates vs actual detail report the est cost number do not match estimate numbers for job

I need to know what column on the job estimates vs detail report what column do i look i for where i made money on the project?

 

 

MarkAngeloG
QuickBooks Team

when I run job estimates vs actual detail report the est cost number do not match estimate numbers for job

Hi there, Becky.

 

I'm here to help you identify the column that shows where you made money on a project in the Job Estimates vs. Actual Detail report in QuickBooks Desktop.

 

When you run the Job Estimates vs. Actual Detail report, the Act. Revenue column will show how much money you made on a project.

 

For a more tailored view, you can consider customizing the report to better fit your analysis needs.

 

If you have any more questions or need further assistance, don't hesitate to reply. Our goal is to ensure you have the data and tools needed to make informed decisions for your business's financial health.

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

Need to get in touch?

Contact us