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

Collections Report and Open Invoices Report

Is it possible to filter either the collections report, the open invoices report or any of the accounts receivable aging reports by customer? I have tried several things but am not having any luck.

 

I have a co-worker that would like to monitor her own specific customers open invoices not all the customers in the entire company.

 

Thank you!

1 Comment 1
ShiellaGraceA
QuickBooks Team

Collections Report and Open Invoices Report

Thanks for reaching out to us here today, @Txroofer.

 

I have some information about filtering the report by customer. Since these reports will show the customer's name by default, you can export the report into Excel and filter the customer name from there. Let me walk you through how.

 

  1. Go to Reports, then select Customers & Receivables.
  2. Choose either Open Invoices, A/R Aging Summary, or Collections Report.
  3. In the report, click the Excel drop-down. Then, tick Create New Worksheet.
  4. Click Export.

An Excel spreadsheet will open you can highlight the customer's name column and Filter. For more information about exporting, check out this guide: Export reports as Excel workbooks in QuickBooks Desktop.

 

Also, if you're using the sales by rep or the Rep field on your invoices, you can just filter your report by rep to view the customer under a specific sales representative. Please refer to this article for details: Customize reports in QuickBooks Desktop.

 

Feel free to visit our page in case you need help with other QBDT tasks. Just browse for specific topics and look for responses that fit your concern.

 

Keep me posted if you still have questions or concerns with reports. I'll be happy to answer them for you. Take care and have a good one.

Need to get in touch?

Contact us