cancel
Showing results for 
Search instead for 
Did you mean: 
ljones3803
Level 1

How do I hide inactive customers in Balance Detail Report?

I have been frustrated by this for some time now and I have seen no good options to remove inactive customers from the report. Even ones with NO ACTIVITY show on the report.  Using the multiple names option means you have to adjust it every month a customer moves out. So what I came up with is creating a customer type "active" and then filter by customer type "active" and only they show up. When I make one inactive I just add the task of deleting the type. Still not the best but better than the other options.  If you already have something in customer type you can still use it by deleting the field when you make it inactive and filter multiple types by all of the types you are using. 

IanDahmes
Level 1

How do I hide inactive customers in Balance Detail Report?

This comment was really helpful for me to narrow down this report to all active customers. Instead of filtering for all names, select the filter for all customers/jobs (this is what I needed to see), or filter for all vendors, etc. and then the options for all, active, or inactive become available to select. 

TekNecks
Level 1

How do I hide inactive customers in Balance Detail Report?

I was able to fix this issue. 

 

Need to Customize the report

Set Filter Tab to Name, then change All Names to All customers/jobs

This will enable the greyed out options, so you can select Active

 

These settings give me a Customer Balance Detail with only Active Customers/Jobs.

 

Make sure you also Memorize the report as it will revert to the default settings when closed.  I just created a Memorized Report group for my company and saved it there.

 

Inactive.JPG

TekNecks
Level 1

How do I hide inactive customers in Balance Detail Report?

This is easily fixed by customizing the default report with the following settings.  Changing the Name filter from All names to All customers/jobs is the key to unlocking the Active/Inactive radio buttons

 

Inactive.JPG

DBSLP
Level 1

How do I hide inactive customers in Balance Detail Report?

I'm new to QBO and this whole topic is ridiculous, since the desktop version of Quickbooks automatically hid inactive customers from view in all kinds of lists and reports.  I now have hundreds of customers that I have to scroll, scroll, scroll through to view things like previous invoices, payment dates, etc.  I have been nothing but frustrated with the online version of this software.  It's been two months and I still run into glitchy things that worked seamlessly in the desktop version.

I wish I hadn't been talked into the online version by the salesperson when it came time to renew!  And I guess they are phasing out the desktop software entirely next year?  Horrible!

 

I'm here in the Community because the other help functions and support have been terrible.  Not just inconvenient or time consuming (although that too) but I can't seem to get answers to simple questions like the one here! How the heck do you hide inactive customers across different lists??  I still don't know!

Giovann_G
Moderator

How do I hide inactive customers in Balance Detail Report?

Hello, DBSLP.

 

This isn't the experience we want you to have. I can share additional information about hiding inactive customers in QuickBooks Online.

 

Hiding inactive customers across all lists isn't possible. There are specific report that displays them if they have transactions on the date range selected.

 

As a workaround, you can customize your report to specify which customer you want to show. I'll show you how.

 

  1. Go to the Reports menu.
  2. Search the report you want to run.
  3. Click the Customize button.
  4. Enter the correct reporting period.
  5. Select Filter.
  6. Hit the dropdown under Customer area, then checkmark select all checkbox.Capture.PNG
  7. Once done, choose Run report.

 

Check out this article for more insights: Customize reports in QuickBooks Online.

 

In addition, you can also export your report to Excel and from there you can remove inactive customers.

 

Please don't hesitate to add any details if you need further assistance managing your customer lists or reports. We're always here to help.

JayMeister
Level 1

How do I hide inactive customers in Balance Detail Report?

After reading all of your responses, and with your help, trying several things...

 

I FOUND THE SOLUTION!

 

In the Customer Balance Detail Report, chose Customize.

 

Then filter by Name.

 

It defaults to "All Names", but use the drop down to select "All Customers/Jobs".

 

Then the sub-options for "All/Active/Inactive" start working, and you can select Active.

 

 

 

Archie_B
QuickBooks Team

How do I hide inactive customers in Balance Detail Report?

Hello there, JayMeister.

 

It's great to know you're able to find an effective solution, and I appreciate you sharing it in this thread.

 

You're always welcome to return to the Community if you require assistance with QuickBooks. We will make every effort to provide you with relevant information and the best assistance possible. Take care and have a great day.

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

Need to get in touch?

Contact us