Filters are a powerful tool that can help you manage your Household Index. By applying filters, you can quickly and easily sort through your data to find the information you need. In this article, we'll explain how to apply filters to your Household Index Layouts menu and provide some tips for using them effectively.

Please remember, the more information you enter on Essential and Details pages of financials the more useful your Household Index becomes!

Filters are a feature to allow you to sort through your Household Index based on specific criteria. They work by hiding data that doesn't meet the criteria you've set, making it easier to find the information you need. Filters can be applied and saved to your Household Index Layouts menu for reuse.

Use the filter menu to apply filters with multiple criteria to help you scan through your client list. You can optionally save the filters to your Household Layouts menu for future application.

Store your filters for later use! A useful tip is to display the columns you filtered by using the Columns selector. Feel free to add or remove columns as needed. Utilize the Save/Save As menu to name your household index filters and column combinations, allowing you to revisit your report periodically to refine your focus.

The following filters are provided by Household Index champions! They are only suggestions and may not be applicable to your situation. Remember, the more information you enter on a financial's essentials and details pages the more impactful the Household Index may become. Please enter your own values to fine tune your results to your client base.

A couple of fine-tuning tips

Filter: LTC/LTD = sort red light for disability or long-term care. Open each household and assess assets, savings, incomes versus risk of loss.

Opportunity: Put together a campaign based on shortfalls directed at those clients.

Learn more about Elite Tier features. Schedule a consultation 📅.

Filter: Net Worth > $1,000,000 AND LTC = 'Red'

Opportunity: These clients have assets to protect but lack long-term care planning — a major risk.

Filter: Primary Age >= 50 AND Ratio Retirement Position < 20

Opportunity: Approaching retirement age but under-allocated — signals an urgent planning need.

Filter: Income Earned Amount > 250000 AND LTD = 'Red'

Opportunity: High-income earners without LTD are financially exposed.

Filter: Dependent Count >= 1 AND Insurance Life Total Coverage Active = 0

Opportunity: Families at risk in the event of a death — life insurance is critical.

Filter: Wallet Share < 30 AND Managed Net Worth > 1000000

Opportunity: If you manage only a small portion of a large financial picture — opportunity to grow your relationship.

Filter: Liquid Assets Amount < (Expenses Amount * 3)

Opportunity: Households with less than 3 months of expenses in liquid assets may need an emergency fund or liquidity strategy.

Filter: Net Worth > 2000000 AND Legal Liability = 'Red'

Opportunity: High-net-worth clients with no legal protections in place — potential estate and asset protection planning.

Filter: Liabilities Amount > 200000 AND Ratio Debt > 40

Opportunity: Signals a debt-heavy household that may benefit from restructuring or payoff strategies.

Filter: Primary Age < 40 AND Insurance Life Total Coverage Active = 0 AND LTD = 'Red'

Opportunity: Educate and protect early-career clients at low insurance cost.

Recommendation reminder: neaten your report by setting Status = Client (or Prospect) and hide the Status and Linked columns, as well as any other unneeded columns.

Filter: Annual Income > $100,000 AND Assets < $30,000 AND Primary Age < 40

Opportunity: Make sure we're properly funding our retirement goals later in life (use a Retirement Target-Map to show the impact of contributing more to your retirement accounts or maximizing your Roth, etc.)

Target: Clients over 55 with low retirement assets relative to net worth and total assets.

Filters:

Why this matters: These clients may not realize they’re underprepared for retirement despite having significant assets.

Target: Wealthy clients not leveraging your services or retirement options.

Filters:

Why this matters: You could present tax-advantaged retirement strategies to increase AUM and value.

Target: Younger households with zero or minimal retirement savings.

Filters:

Why this matters: These clients have the means but haven’t prioritized retirement yet—you can catch them early.

Target: Clients with multiple asset types but no/low retirement focus.

Filters:

Why this matters: These clients may think they’re diversified, but they’re missing a key long-term component.

Target: Clients with solid earnings but insufficient retirement assets.

Filters:

Filters:

Rationale: These clients have assets worth protecting and are approaching retirement, but lack active life insurance.

Filters:

Rationale: Clients may soon lose life insurance coverage and have dependents relying on them, but no long-term replacement plan.

Filters:

Rationale: High-earning young clients with no life insurance may be underinsured and could lock in affordable premiums now.

Filters:

Rationale: Clients rely solely on term insurance and carry significant debt. They could benefit from permanent coverage for lifelong protection.

Filters:

Rationale: Wealthy households with multiple members and low insurance coverage may not be adequately protecting their legacy or family needs.

7/2025