Job estimates vs Actual Details in quickbooks for mac

Hi there, joe204.

Welcome to the QuickBooks Community. Let me discuss how Job estimates vs Actual Details report work in QuickBooks Desktop for Mac. Then, to ensure you can view the accurate detail for the actual cost of the entry on the said report.

Job Estimates vs. Actuals Detail report presents detailed costs and revenues for the customer or job you have chosen. It compares estimated and actual costs and estimated to actual revenue for each job that you invoiced or any created sales entry.

Estimated Cost comes from the Cost side while the Estimated Revenue comes from the Sales side. Item is anything that your company buys, sells, or resells. Then, their details in QuickBooks depend on the information you've manually entered when you set up them in the program. 

On the other hand, when entering an item for specific transactions, the actual cost of the item does not show in the Act.Cost column on the report. This is because it appears on the Est. Cost and on the Total to ensure you're able to verify the exact purchased amount. Then, to ensure the price shown on that Act.Cost section, you'll have to make sure that you've properly linked the estimate to a bill or invoice.

Here's how:

1. Go to the Lists menu and select Customer:Jobs.
2. Select the job for which you wrote the estimate.
3. Select Estimate.
4. From the Create Estimates window, Select Create Invoice. This will open the invoice window.

Then, the invoice will have all the information from your original estimate. The prices on the invoice automatically incorporate any markups from the estimate.

You can open this article to view various information on how reports work and give you an overview of what's going on in your business: Create reports in QuickBooks Desktop for Mac.

Please don't hesitate to click the Reply button below if you have other concerns related to your sales transactions. I'm always here to help,  joe204. Have a great day!

No. i think you'r saying there is no solution.

every job i have has at least 20 line items in the estimate. within that estimate i have multiple bills against that line item. the whole purpose of having an estimate is to then see how you do against it. the totals are at the bottom and not on the line items so how would i know if i am over or under the line item other than looking at the totals. i use excell for that now i thought this would work easier but it does not. am i missing something?

Hello there, @joe204. I appreciate your input from every angle. 

I understand the importance of running the report needed to show the totals on the line items so you'd know if you're over or under the line item. However, at this time, it's not an option. I'd suggest submitting feedback to our product engineers. They may see this request and consider adding the Totals on every line item on the Job Estimates vs Actual details report. 

To send feedback, here's how:

1. Go to the Help menu at the top.
2. Select Send Feedback Online.
3. Click Product Suggestion.
4. Choose a feedback type and product area on the QuickBooks Feedback window. 
5. Enter your feedback, name, and email address (optional).
6. Once done, click on the Send Feedback button.

You can also visit this page or the What's New section on your QBDT to get updates on our latest news about product improvements. 

In addition, you may want to memorize reports in QuickBooks. It will help run the same settings of the customized report.

As always, feel free to check out our help articles in case you need tips and related links while working with QuickBooks in the future.

Let me know if you have other concerns while managing QuickBooks. I'll get back to you right away. Have a great day.

Does quickbooks online allow that?