cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
janet-addedtouch
Level 2

is there a way to run your receivables aging report whereas it puts all current, then 60, then 90 days, etc. in columns rather than only by customer name?

see below Customer A 1-30 31-60 61-90 91-120 Mickey mouse $57.50 Mickey Mouse 125.00 "insert invoice numbers below customer names.

1 Comment 1
FateCandylaneT
QuickBooks Team

is there a way to run your receivables aging report whereas it puts all current, then 60, then 90 days, etc. in columns rather than only by customer name?

The Accounts Receivable Aging Summary report displays all aging dates in columns, Janet.  However, this reporting data doesn’t show invoice numbers below the customer names.

 

In the report, you can click on the individual amounts to drill down transactions associated to it. This gives you access to a detailed view, including the corresponding invoice numbers. To do this:

 

  1. In your QuickBooks Online account, navigate to Reports and enter the Accounts Receivable Aging Summary report.
  2. From the Classic view, make sure to enable the Report date option under the Aging method.
  3. Enter 30 days under the Days per aging period section and four (4) on the Number of periods. Then, Run report.
  4. Once done, click on the specific amount to view detailed information of the transactions.

 

 

Also, you can consider exporting this report to an Excel file to manually modify your reports and insert invoice numbers below your customer names.

 

Feel free to let me know for any additional queries.

Need to get in touch?

Contact us