cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. The QuickBooks Community will be unavailable for approximately 1 hour beginning at 10:00 PM PDT on Wednesday, August 14th for database maintenance. All community forums will be unavailable during maintenance but feel free to browse our Support articles for help in the interim.
dawnjohnson
Level 5

Why is the Estimate Summary on progress invoices in random order? Is there a way to fix this so it's in numerical order?

 
4 Comments 4
SheandL
QuickBooks Team

Why is the Estimate Summary on progress invoices in random order? Is there a way to fix this so it's in numerical order?

Hi there, dawn. Let me help you sort out your transactions alphabetically in your QuickBooksOnline (QBO) account.

 

If you're referring to the Estimate & Progress Invoicing Summary report, please know the ability to customize the details in numerical order is unavailable.

 

The report sorts transactions alphabetically by your customer or project's name and then groups them by transaction dates. Hence, the reason they're not sorted in numerical order.

 

To sort the data in this report numerically, you export it to Excel. After exporting, you'll be able to customize the report in Excel to suit your specific preferences.

 

To do so, here's how:

 

  1. Go to Reports.
  2. In the search field, input the Estimate & Progress Invoicing Summary Customer.
  3. At the top of the report, click the Export icon beside the print icon.
  4. Select Export to Excel from the dropdown.
  5. Save the file in a location that is easy to find, such as your Downloads folder or your desktop.

 

On the other hand, if referring to estimate and invoice summary orders in QBO, it's important to note that they're categorized based on when the invoice creation date. This means that the orders are listed from the oldest to the newest date.

 

Additionally, let me share this article with you for guidance in personalizing a report in modern view: Customize reports in QuickBooks Online.

 

Feel free to get back to this post as soon as possible if you have other questions regarding making this report in numerical order. I'll be sure to help you anytime.

dawnjohnson
Level 5

Why is the Estimate Summary on progress invoices in random order? Is there a way to fix this so it's in numerical order?

I'm sorry, I guess I was not clear on my question.  I'm not asking about a report generated by QBO but about the estimate summary that is optional to include on the bottom of invoices.  In the attachment, you can see that my customer has MANY invoices yet there is no rhyme or reason to the order (numerical would make sense because that would also be date order).  This is for a single project so it does not have to do with a customer or project.  Is there not a way to organize this?  It makes no sense. 

ChristineJoieR
QuickBooks Team

Why is the Estimate Summary on progress invoices in random order? Is there a way to fix this so it's in numerical order?

I know you require additional functionality preferences about progressive estimates and invoice orders in QuickBooks Online, Johnson. I'm here to provide more information about this feature.  

 

The Invoice Estimate Summary is organized based on the invoice date order. The sequence is arranged from the oldest to the newest invoice date.

 

We appreciate your patience and understanding as we strive to make QuickBooks Online as comprehensive and user-friendly as possible, and we would like to send our heartfelt gratitude for being with us and using QuickBooks Online.

 

Since there isn't a way to rearrange the summary based on invoice numbers, we can submit your suggestion to our product developer.

 

Please see the steps below:

 

  1. Go to the Gear icon.
  2. Under the Profile column, select Feedback.
  3. Share your suggestion, then click Next.

 

You'll want to track your suggestions through this website. You can also visit our blog to keep up with our recent events and developments.

 

Moreover, if you want to pull up your sales transactions, I'm adding this page to see the complete procedure on how to do it: Run reports in QuickBooks Online.

 

If you have other questions about managing sales transaction, add them below. Please don't hesitate to reach out if you have suggestions or concerns. Your satisfaction is our top priority.

dawnjohnson
Level 5

Why is the Estimate Summary on progress invoices in random order? Is there a way to fix this so it's in numerical order?

Sorry, the Estimate Summary is not in date order as you stated. It is random. Makes zero sense. I have provided feedback. 

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

Need to get in touch?

Contact us