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.

Reply to message

View discussion in a popup

Replying to:
Catherine_B
QuickBooks Team

Reply to message

Hello there, Tom99. 

 

We can decrease the number of interval days and then export the A/R Aging Summary report to remove zero data. I'll show you how: 

  1. Go to Reports and choose Customers & Receivables A/R Aging Summary
  2. Click Customize report at the upper-right. 
  3. Decrease the number in the Days per aging period field. This is to drill-down most of the aging transactions. 
  4. Click OK to refresh. 
  5. Select Excel from the menu to export the report and manage it from there. 

On the other hand, we can also use the Customer Balance Detail report and add an Aging column. Here's how: 

  1. Still from Reports > Customer & Receivables > Customer Balance Detail.
  2. Click Customize Report and select the Filter tab.
  3. Locate and click Aging and select a condition.
  4. Click OK

You can also use these reference in customizing your customer and sales reports.

 

I'll be here if there's anything you need help with. Take care always and have a great day!

Need to get in touch?

Contact us