cancel
Showing results for 
Search instead for 
Did you mean: 
gusi
Level 2

How do I get an Estimate report showing the individual line items of each estimate?

"I can use Sales By Customer Detail" and then select "non posting" in the filters. This will show all delayed charges and estimates. But I am not able to filter out only Estimates and only those that are accepted.
16 Comments 16
vpcontroller
Level 11

How do I get an Estimate report showing the individual line items of each estimate?

@gusi

 

I'm impressed you're even able to get the Estimate item detail data from this sales report. You can also filter the same report by Estimate, but you get blank data, only non-posting works. I also looked at it, seems like it's not customizable further than that.

 

What they really need is, "Estimates by Customer Detail" report instead of just currently available Estimates by Customer report.

dcroteau
Level 1

How do I get an Estimate report showing the individual line items of each estimate?

Hi -  I need this detailed estimate report too!  Where is the filter for "Non-posting" ? 

JonpriL
Moderator

How do I get an Estimate report showing the individual line items of each estimate?

Hello there, @dcroteau!

 

Let's go to your Sales by Customer Detail report and filter it to show your non-posting transactions.

 

Here's how:

  1. Pull up your Sales by Customer Detail report.
  2. Select Customize.
  3. Click the Filter option.
  4. Check the Transaction Type tick box.
  5. Under the drop-down menu, select Non-posting.
  6. Click Run Report.

I've attached a screenshot below to show you where the filter is.

 

 

Also, have a quick read on this article to maximize your expertise about customizing your reports: How to Customize Reports?

 

Feel free to leave a comment below if you have any other questions. Have a wonderful day!

gusi
Level 2

How do I get an Estimate report showing the individual line items of each estimate?

I have been trying and hoping for an answer for months. I also posted this other related question here https://quickbooks.intuit.com/community/Account-management/The-quot-Sales-by-Product-Service-Detail-...

 

Both sales by customer or sales by product detail reports only work if you select non-posting. They show nothing when selecting estimates. The problem with non-posting is that it shows both estimates and cash.

 

Even better, give me "Estimates & Progress Invoicing Summary by Customer Report" but detail instead of summary. I need to see each line item in the estimate, not just the total.

ShiellaGraceA
QuickBooks Team

How do I get an Estimate report showing the individual line items of each estimate?

Hi gusi,

 

The report to see each line item in the estimate is unavailable. You'll have to open the estimate manually in the Estimates & Progress Invoicing Summary by Customer report.

 

To let our engineers know how the "Estimates & Progress Invoicing Detail" report would help your business. You can send a product request directly to them by going to Gear, and then Feedback.

 

We're always here if you have further questions about QuickBooks. 

How Is This My Life Now
Level 2

How do I get an Estimate report showing the individual line items of each estimate?

Hi SheillaGraceA,

 

Given the vast amount of forum requests I see for this type of report both on the official QuickBooks chat forum as well as multiple 3rd party chat forums, I have to assume that QuickBooks is resistant to deliver on this report for some reason.

 

Is it that it is available in another more expensive version of QB and this is an attempt to get people to upgrade?  The lack of this particular report seems so obvious in its absence that it must have been done with discussion and purpose, I'm just curious as to know what that purpose is/was?

 

Any thoughts?

daxd
Level 4

How do I get an Estimate report showing the individual line items of each estimate?

We have been begging for this from the Intuit developers for *years* - we can't even find a 3rd party developer to help.

We need a way to run a report showing ALL item#s/item descriptions pulled from Estimates. Sorted by Item (not by customer).

Just as you go to "item list", right click and go to Quick Report: Item# but for estimates (or if from estimates could be included)

They won't add a way to do it :(
If they would just add a checkbox to this report to include from Estimates as well it would be perfect :(


We neeeed to know what items we need to order to cover estimate jobs and there is nooooooooo report to show this. We have to manually open each and every estimate and manually write down what we need. Drives us crazy. I don't understand why we can't create a custom report for this?
Can ANYONE help with a custom report for this?

daxd
Level 4

How do I get an Estimate report showing the individual line items of each estimate?

Sadly we have been letting the Engineers know we *need* reporting help for Estimates for 15 years. They haven't responded :(

CanadianHD
Level 2

How do I get an Estimate report showing the individual line items of each estimate?

This is how I did it.

Run Estimates by Job

Capture.PNG

 

 

I prefer the right hand column to be "Amount" as it excludes tax

In the Filters for Account I selected "All ordinary income accounts"

In the Filters for Estimate Active I selected "Yes"

Then when I run the report if there are 3 lines of details in the estimate, I get three lines of information for the same estimate

 

cherylwupsllc
Level 2

How do I get an Estimate report showing the individual line items of each estimate?

Hi, go to Report Center, choose Sales, scroll down until you find Estimates By Item For Sales Team and select this report by double clicking.

 

Click on Customize Report, choose Filters (2nd tab), type Name in the Search Filters box, All names will now be displayed under Name.

 

Click on Display (1st tab) and chose the date range that suits you.

 

Click OK (blue tab at the bottom)

 

You will have an estimate report that displays the individual line items of each estimate.

 

Good luck!

 

Cheryl

Nate5
Level 3

How do I get an Estimate report showing the individual line items of each estimate?

I don't know how you figured this out, but THANK YOU!

Knaght
Level 2

How do I get an Estimate report showing the individual line items of each estimate?

I don't know how you figured this out, but THANK YOU!

CYCBusiness1526
Level 3

How do I get an Estimate report showing the individual line items of each estimate?

I do not see an Estimates by Item for Sales Team in my Standard Reports. Any other suggestions?

jenop2
QuickBooks Team

How do I get an Estimate report showing the individual line items of each estimate?

Hi there, CYCBusiness1526.

 

The Estimates by Item for Sales Team report is only available in the QuickBooks Desktop version. This is the reason why you're unable to see it in your QBO account. 

 

As a work around, you can use the Sales by Customer Detail report. Then, customize it to only show non-posting transactions. Here's how:

 

  1. Go to the Reports menu and type in Sales by Customer Detail in the Search bar.
  2. Click Customize in the upper-right hand corner and scroll-down to the Filter tab.
  3. Check the box for Transaction Type and select Non-Posting
  4. Select Run report.

 

 

 

 

 

Allow me to share these articles for additional information and guidance when running reports in QBO:

 

 

Feel free to reply to me and ask follow-up questions if you still need more guidance with this. I'll jump right back and offer my help again. 

CYCBusiness1526
Level 3

How do I get an Estimate report showing the individual line items of each estimate?

Thanks, but that doesn't show what I need! I need to be able to see only Estimates and not all the other non-posting items, and only for active estimates.  Plus the report you suggested does not show the actual remainder to be invoiced for each item. Basically useless for our project managers!

MirriamM
Moderator

How do I get an Estimate report showing the individual line items of each estimate?

Hi there, @CYCBusiness1526.

 

I know the importance of having the report you need. However, at this moment, the option to pull up data to show only active estimates and its remains to be invoiced for each item isn't available in QuickBooks Online (QBO). In the meantime, you can run the Sales by Customer Detail to show all your estimates and its Product/Service items. Then, export it to Excel so you can add other information that you'd want from there.

 

I can see how the feature you're looking for would benefit and empower your business. In the meantime, I recommend sending this request straight to our product engineers through feedback. 

 

To send feedback, follow the below steps:

 

  1. Go to the Gear icon at the top.
  2. Select Feedback.
  3. Enter your comments or product suggestions. 
  4. Then select Next to submit feedback.

To learn about running and personalizing reports in QBO, visit these articles:

 

In addition, if you want to save your latest customization settings on your report, you can memorize your reports.

 

To be updated with the recent and upcoming changes for QuickBooks products, visit this site: What's New.

            

I'd be glad to help you out again if you need further assistance running the report you need. Just leave a reply below, and I'll get back to you as soon as I can. Have a good day.

Need to get in touch?

Contact us