Welcome back! Ask questions, get answers, and join our large community of tax professionals.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to create a custom client filter

Intuit Help
Intuit

How to create a custom client filter

This article will help you create custom filters to modify your Client list view in Lacerte. We provide standard filters to help you manage your Client list, but you can also create complex filters of your own using multiple criteria, also called Filter Groups.

You can create filters that meet several different criteria or combinations of criteria. For example, you can create a filter that displays all successfully e-filed clients with unemployment income whose total income is $150,000 or less.

To create a custom filter:

  1. Go to the Clients tab.
  2. Select the Filter menu at the top of your window.
    modify filters.png
  3. Click on Modify Filters.
    • If you already have at least one custom filter, your list will be displayed. Click the Add button to create a new filter.
  4. Enter a Name of new filter, then press OK.
  5. Click the Groups button.
    filter groups.png
  6. Type a Name for the group, then press OK.
  7. Click the Add button on the right, to add a Filter Condition.
    add filter condition.png
  8. Select the Category of field you want to filter based on. For example, choose Income if you intend to filter clients by their unemployment income.
    filter specification 1.png
  9. Select a Field from the drop-down menu.
  10. Select the Compare statement you wish to use.
  11. Enter or select the appropriate Value.
    • The Value area changes depending on the Field you select. You'll either need to type something into the field, or select from a list of options. For example, if you filter by Federal e-file Status, you'll select from a list of all possible statuses.
      filter specification 3.png
  12. Click OK.
  13. If you want to filter based on more than one field, repeat steps 7 through 12 for additional filter conditions.
  14. Select Match All or Match Any.
    match all or any.png
    • Match Any will display clients who match at least one filter condition.
    • Match All will only display clients who meet the conditions of every filter.
  15. Click OK to close the Filter Groups window.
  16. Click OK to save the filter and close the Custom Filter window.

The new filter will now appear under the Filter section on the left side of your Clients tab. Click on it to sort your clients and reflect the applied filters you just created.

 The custom filter you create will only be available in the module where you created it. If you want the custom filter to be present in another module, you must navigate to that module and recreate the custom filter.

Was this helpful?

You must sign in to vote, reply, or post
Labels (1)