Get 50% OFF QuickBooks for 3 months*

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.
wwdiamondc
New Member

How can I display customers by their last name? Currently, in reports and Customers, all of the displays are by the first name.

My customers are created and connected to HouseCall Pro and are entered by first name and last name.

2 Comments 2
GlinetteC
Moderator

How can I display customers by their last name? Currently, in reports and Customers, all of the displays are by the first name.

When pulling up reports in QuickBooks Online (QBO), the system defaults to showing the first name, wwdiamondc.

 

In this case, QBO currently doesn’t have a built-in option to separate first and last names directly within reports. As a workaround, you can export the report to Excel, which will enable you to customize it further and extract the last names as needed.

 

Here’s how:

 

  1. Open the report.
  2. Look for the Export icon (a small sheet with an arrow)
  3. Select Export to Excel.
    Screenshot 2025-10-25 043712.png

 

Feel free to leave any additional questions in the comments, and we’ll be happy to help.

GlinetteC
Moderator

How can I display customers by their last name? Currently, in reports and Customers, all of the displays are by the first name.

Hi there, wwdiamondc.
 
Just checking in to see if the solution we shared worked for you.
 
Happy to help if you need any more assistance.
 
 
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us