cancel
Showing results for 
Search instead for 
Did you mean: 
ValkyrieAnne
Level 3

Transaction report sorted by invoice number

I need a custom report that shows all my invoices sorted by invoice number.  I started with the Transaction List by Date report and filtered it to show only invoices. I can't figure out how to get the report to sort by invoice number. Any ideas?

 

 

Solved
Best answer October 08, 2018

Best Answers
VivienJ
QuickBooks Team

Transaction report sorted by invoice number

Welcome to the QuickBooks Community, ValkyrieAnne.


I can help get the report you can use to view the customers’ invoices based on the details needed.


You can use the Invoice List report to show your invoices, ordered by date with their assigned numbers in ascending sequence. However, there isn't yet an option to sort out any sales report by invoice number, only by invoice dates.


To run the report:

  1. Go to Reports in the left navigation panel.
  2. Scroll down to the Who owes you section, and pick Invoice List.
  3. In the Report Period, enter specific dates.
  4. Click Run Report (see screenshot 1).

By default, the invoices numbers are arranged from the first one you’ve created down to the most recent.


As an alternative, you’ll be able to filter the All Sales section by invoices and enter the date range of the transactions you need. Then, sort them in ascending or descending order.


Here’s how you can view it:

  1. Go to Sales in the left navigation panel, then All Sales.
  2. Click the Filter drop-down, and choose Invoices in the Type field.
  3. Pick the Status you need (Open, Overdue, Paid, or All Statuses).
  4. Select Custom in the Date drop-down, then enter the date range you need in the From and To fields.
  5. Click Apply (see screenshot 2).
  6. Once you’re back in the All Sales section, click the No. column header to sort the invoices in ascending or descending order.
  7. Choose the Print icon or Export button to get a copy of the data (see screenshot 3).

Let our product engineers know how the ability to sort out reports by transaction numbers can help get a better view of your data. We appreciate suggestions and we’ll be delighted to consider them for future inclusion.


To send them, please go to this link: http://feedback.qbo.intuit.com/forums/168199-quickbooks-online-feature-requests.


Feel free to get back to me if you have other concerns in QuickBooks. I’m here anytime.

 

image.pngimage.pngimage.png

 

View solution in original post

3 Comments 3
VivienJ
QuickBooks Team

Transaction report sorted by invoice number

Welcome to the QuickBooks Community, ValkyrieAnne.


I can help get the report you can use to view the customers’ invoices based on the details needed.


You can use the Invoice List report to show your invoices, ordered by date with their assigned numbers in ascending sequence. However, there isn't yet an option to sort out any sales report by invoice number, only by invoice dates.


To run the report:

  1. Go to Reports in the left navigation panel.
  2. Scroll down to the Who owes you section, and pick Invoice List.
  3. In the Report Period, enter specific dates.
  4. Click Run Report (see screenshot 1).

By default, the invoices numbers are arranged from the first one you’ve created down to the most recent.


As an alternative, you’ll be able to filter the All Sales section by invoices and enter the date range of the transactions you need. Then, sort them in ascending or descending order.


Here’s how you can view it:

  1. Go to Sales in the left navigation panel, then All Sales.
  2. Click the Filter drop-down, and choose Invoices in the Type field.
  3. Pick the Status you need (Open, Overdue, Paid, or All Statuses).
  4. Select Custom in the Date drop-down, then enter the date range you need in the From and To fields.
  5. Click Apply (see screenshot 2).
  6. Once you’re back in the All Sales section, click the No. column header to sort the invoices in ascending or descending order.
  7. Choose the Print icon or Export button to get a copy of the data (see screenshot 3).

Let our product engineers know how the ability to sort out reports by transaction numbers can help get a better view of your data. We appreciate suggestions and we’ll be delighted to consider them for future inclusion.


To send them, please go to this link: http://feedback.qbo.intuit.com/forums/168199-quickbooks-online-feature-requests.


Feel free to get back to me if you have other concerns in QuickBooks. I’m here anytime.

 

image.pngimage.pngimage.png

 

ValkyrieAnne
Level 3

Transaction report sorted by invoice number

Thank you!!

SeastheDay
Level 1

Transaction report sorted by invoice number

Is there anyway to sort invoices by numerical order when you are in the customer payment window?  My customers pay in order of invoice # but when I go to receive payment my invoices are sorted by date not numerical order.  This presents a problem when I have 20 plus invoices with the same date.  Can this be changed?

Need to get in touch?

Contact us