Showing results for 
Search instead for 
Did you mean: 
Level 2

Customer Name color on AR reports

When pulling up my accounts receivable aging report, I would like to be able to identify those customers who may be past due but have contacted me regarding payment in the future so I do not send them reminders.  Is there any way to possibly change the customers name color or make any changes that would set these customers apart from the others?   I manually send reminders out and do not use the automatic function as I know the payment patterns on many of the clients.  However with so many clients I sometimes forget when someone states that they will pay the invoice at such and such time.  Hope that makes sense to someone.  Thanks 

2 Comments 2
QuickBooks Team

Customer Name color on AR reports

Welcome to Community, @gwsw.


I have some information about adding color to the customer's name on the aging report. While this option isn't possible, you can export the report to Excel and then add the colors to your name from there. Let me walk you through how.


  1. Go to the Report menu at the top.
  2. Choose Customers & Receivables, then pick A/R Aging Summary.
  3. Select the Excel drop-down from the top., and then tap Create New Worksheet.
  4. Click Export.

After exporting, open the Excel file and then highlight the customer's name and add the colors from there.



Learn more about exporting reports at this link: Export reports as Excel workbooks in QuickBooks Desktop.


If you need help with other tasks in QBDT, you can browse for specific topics here and look for responses that fit your concern.


Keep me posted if you still have questions or concerns with your reports. I'm more than happy to answer them for you. Take care and have a great weekend ahead.

Level 2

Customer Name color on AR reports

Thank you for that tip.  I will try it but would be nice if there was a more permanent option that allowed me to do the same under the Customer Name Tab so it would show it that way in every report I made.  I do appreciate the answer and I will use it.  Happy holidays to you.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up