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

View estimates sorted by accepted date

Hello! We run a Tree Care business (Arborists) and our sales workflow is as follows:

  1. Visit a customer's home and discuss their trees, agree on their goals, verbally discuss proposal
  2. Use QuickBooks to generate an estimate that outlines the work we propose and the estimated cost.
  3. Email estimate to customer.
  4. Upon verbal or written acceptance of the estimate we will go into QuickBooks and mark the Estimate "Accepted".

 

We would like to find a way to sort our Accepted Estimates based on the date they were accepted so we can address our schedule in the order in which the Estimates were accepted.

 

Is there a way to do this? I was able to go to "Sales Transactions" and filter by "Estimates" with a Status of  "Accepted", but most of the Estimates do not have the Accepted Date populated. 

 

What do we need to do differently to make this work?

 

Thanks!

Tom Anderson-Brown

1 Comment 1
JenoP
Moderator

View estimates sorted by accepted date

We're glad that you've joined us here. Allow me to share information to help with your estimates, Tom.

 

It's possible that a date was not entered when the estimate's status was changed to Accepted. This is the reason why there are no data in the Accepted Date fields in some of the transactions.

 

accepted date.PNG

 

You can use the Audit Log report to check when the estimate was accepted. This report tracks all changes made to transactions as well as user activities. Here's how: 

 

  1. Go to the Gear or Settings ⚙ icon and select Audit Log.
  2. Click the drop-down list for Date change and select a date when the estimates where entered.
  3. Proceed to the Events field and look for All transactions.
  4. Look for the estimate, then click View under the History column.
  5. All the information needed for the transaction can be found under the Event column.

 

accepted date 2.PNG

 

Here's an article that provides additional information about this feature: Use the Audit Log in QuickBooks Online.

 

Then, open the estimate one more time and enter the accepted date. Once done, the information should show up in the Accepted Date column when viewing the list. 

 

Let me know if that works for you. You can also ask follow-up questions with any of the steps above.

Need to get in touch?

Contact us