cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
davidmatyas
Level 3

How can I remove inactive customers from AR report?

I set a lot of customers to inactive status. But when I run a open A/R report they still show up there. I dont see a filter option to filter them out. Any suggestions?

 

Thank you 

2 Comments 2
jamespaul
Moderator

How can I remove inactive customers from AR report?

Hello, David. 

 

I'll share some information about the inactive customers, and help you remove them from your report. 

 

It looks like those inactive customers still have an open invoice or balance. They will always show on any AR reports, and there's actually a way to filter them out. 

 

The filter option is located within the Customize Report button. I'll show you where to locate it: 

 

  1. On your AR report, click the Customize Report button.
  2. Go to the Filters tab.
  3. Under CURRENT FILTER CHOICES, highlight Name.
  4. From the drop-down menu, select Multiple names.
  5. Check the active customers you want to show on the report.
  6. Click OK.

 

filter1.PNGfilter2.PNGfilter3.PNG

 

If you need help on how reporting works in QuickBooks, feel free to check this article: Understand reports.

 

Looking for help in managing your customer payments from the Bank Feeds feature? This article can guide you through the process: Add and match Bank Feed transactions in QuickBooks Desktop.

 

I'm willing to help you out if you have any other concerns while managing your customers list. Also, if you have other questions about invoices or any other features, please add them to your reply. I've got you covered. 

BigRedConsulting
Community Champion

How can I remove inactive customers from AR report?

The report is filtered for open AR transactions. As soon as all AR transactions for a customer are paid, then the customer won't appear.

 

Making a customer inactive won't make them disappear from the report, which would then be inaccurate.

 

If the customer has a 0.00 balance but still appears, that likely means you have unapplied payments or credit memos.  If you edit these payments and apply them to open invoices, then the customer will not appear on the report.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us