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

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
GinnyM
Level 1

P&L Report for an estimate in QB Desktop?

Is there a way to create a P&L Report for an estimate in QB Desktop?

2 Comments 2
MoiraskyeT
QuickBooks Team

P&L Report for an estimate in QB Desktop?

Hello, Ginny. The Profit and Loss (P&L) Report typically includes posting transactions that affect your Chart of Accounts, meaning it does not cover Estimates, which are considered non-posting transactions. However, we can adjust the filters on this report to include non-posting transactions, allowing you to see your potential revenue.

 

You can follow these steps:

 

  1. Go to the Reports menu. Then, select Company & Financial.
  2. Choose either Profit and Loss Standard or Profit and Loss Detail.
  3. Click on the Customize Report tab, and then Filters.
  4. In the search field, type in Posting, and select the Non-posting radio button.
  5. Back in the search field, type in Transaction type, and choose Estimate from the drop-down list.
  6. Hit OK.

 

Alternatively, check out other estimate reports like the Jobs Estimates vs Actuals Detail report to compare the estimated costs and revenues for specific jobs against the actual costs and revenues incurred. Refer to the  Run job costing reports to see how your business is doing on a job-by-job basis section of this article for more details: Track job costs in QuickBooks Desktop.

 

Additionally, you can access further resources related to managing your customer and vendor transactions by exploring these links:

 

 

If you encounter any questions while filtering the estimates, please leave a comment below. We're here to support you and make the process seamless. Take care!

BigRedConsulting
Community Champion

P&L Report for an estimate in QB Desktop?

@GinnyM 

 

Yes, there is - at least in some cases. Generally, there isn't a way to create a P&L for one transaction unless you can apply filters that will include only that transaction.

 

In the case of an Estimate, if you have only one Estimate for a customer on any given date, then you can do it:

 

- Start with a standard P&L.

- Change the date range to the date of the Estimate.

- Customize the report and under filters, change the Posting Status filter to Non-posting.

- If there are other types of non-posting transactions on the date (Purchase Orders come to mind) then add the transaction filter and select Estimates.

- If there is more than only Estimate on the date, add the Name filter and enter the customer's name

 

When you're done the report filters should look like this:

Capture.JPG

 

The resulting P&L might look like this based on one Estimate:

Capture1.JPG

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us