cancel
Showing results for 
Search instead for 
Did you mean: 
tellarini-andrea
Level 1

Can the AR Aging report be set up to display in Customer order?

 
1 Comment 1
MaryLandT
Moderator

Can the AR Aging report be set up to display in Customer order?

You'll be happy to know that you can set up the AR Aging report to display in customer order, tellarini-andrea.

 

Simply run the A/R Aging Summary to get the data you need. By default, it displays customers in ascending order. Let me show you how:

 

  1. Select Reports from the left menu.
  2. In the Who owes you section, open the Accounts receivable aging summary.
  3. Customize the report as needed.
  4. Select Run report.
    ARagingreport.PNG

If you sort this report, it only applies to the amount under the Total column, not the customer name. See the attached screenshot below for your visual guide.
ARagingreport1.PNG

 

To get the information you need, I recommend exporting the report to Excel. Then, manually change the customer order from there.

 

I've also added this link Run an accounts receivable aging report for additional information about the statement.

 

Feel free to comment below if there's anything else you need to do about the AR Aging report. I'm always here to help you in any way that I can with QuickBooks.

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

Need to get in touch?

Contact us