Skip to main content

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

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
G
GraceESMB
January 16, 2023
Question

Sorting items on invoices with QBO

  • January 16, 2023
  • 8 replies
  • 91 views

I recently changed from QB Desktop to QBO Plus because I also switched from PC to Mac. In both versions I am not able to sort by item when creating a customer invoice. Because we bill cost-plus we need to list all items separately and group/subtotal by item and date. With QB Desktop I used a 3rd party application to sort but they don't have a Mac version. Does anybody know if there are any 3rd party apps or any other way to sort on the invoice.  The only way I'm able to do it currently is by exporting the unbilled costs to Excel and creating an invoice there. This seems very short-sighted of QB to not have this function.  Thanks for any help you can provide.

8 replies

Nicole_N
Nicole_NQuickBooks Team
QuickBooks Team
January 16, 2023

Hi, @GraceESMB! Thanks for taking the time to write about your concern here.

 

The option to sort line items on an invoice is currently unavailable. However, you can manually select which item you'd like to appear first in the item drop-down list and so on. This will set your items in a particular order the way you want. 

 

Here's how:

  1. Go to the Sales menu, then select Invoices.
  2. Locate the entry and click the pencil icon to edit invoice.
  3. Change the items in a particular order from the item drop-down and click Save.
     

 

Once done, you may click on the Print or Preview button located at the bottom. This enables you to show the items in their respective orders. Refer to the screenshot below.

 

I also appreciate you sharing your ideas about adding this feature. We'd love to hear more of your insights, so I recommend sending feedback to our product developers. This way, they can further review which parts of the program need enhancements and consider adding them to future updates.

 

Here's how:
 

  1. Go to the Gear icon and click Feedback.
  2. Provide your feedback or product suggestions.
  3. Click Next to submit.

 

To get updates about the status of your feedback, you may visit the Customer Feedback page.

 

You may visit this article if you want to learn how to personalize your sales forms in QuickBooks Online: Customize invoices, estimates, and sales receipts. 

 

Please know that you can always get back to me if you have any other questions about managing invoices. I'm happy to help. Stay safe!

G
GraceESMBAuthor
January 16, 2023

Thanks for the detailed information. Unfortunately I don't seem to be following your instructions very well. If I click on the pull-down where you've indicated with the red square, and choose which item I'd like to appear first, it just changes the product/service & Description of THAT line item. It does not make the subsequent line items appear in an different order.  Am I misunderstanding your instructions?

 

 

N
nbee
July 9, 2024

When you're creating your invoice, add the items in the order you would like them to appear. When the billable charges pop up on the right to be added, scroll through and find the one you want to appear first, add that one, then find and add the next one and so on.


This solution does not work for me, either. Items appear in the order I choose so long as I'm in edit mode, but as soon as I send it, my customers receive everything in date order. Very frustrating.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement