Case Study: How a 3-Advisor RIA Achieved 95% Account Vi 2026

A mid-size RIA with three advisors, two support staff, and 192 client households was bleeding revenue without realizing it. Their account visibility sat at 48% — meaning more than half of their clients' total financial assets were invisible to the planning process. According to Cerulli Associates, this is slightly below the industry median of 54%, but well within the range that most advisory firms accept as normal. It should not be normal. Over 60 days, this firm deployed automated account aggregation with workflow automation, reaching 95% visibility and uncovering $4.2 million in held-away assets that converted to managed accounts within nine months.
Automated client onboarding time: 15 minutes vs 2-3 weeks according to Orion Advisor (2024)

This case study documents every phase of the implementation: the problems that triggered the change, the specific technology decisions, the obstacles encountered, and the financial outcomes that followed.

Key Takeaways

• Account visibility jumped from 48% to 95% within 60 days of deploying automated aggregation connected to workflow automation

• $4.2 million in held-away assets were identified and $1.7 million consolidated into managed accounts within nine months

• Data entry time dropped 81% — from 34 staff hours per week to 6.5 hours

• Client retention improved from 91% to 97% in the 12 months following implementation

• Total implementation cost was $18,400, with full ROI payback in 4.5 months

The Starting Point: A Practice Running Blind

The firm — a fee-based RIA in the Mid-Atlantic region custodying primarily with Schwab — had grown steadily for eight years, adding approximately 20 households per year through referrals and a modest digital marketing program. Total AUM stood at $168 million across 192 households, with an average household relationship of $875,000 in managed assets.

The problem was not growth. The problem was depth.

How much of their clients' total assets could the advisors actually see?

According to the firm's internal audit, their planning software reflected only 48% of their clients' estimated total investable assets. The missing 52% broke down as follows:

The firm knew, in theory, that clients held assets elsewhere. Partners referenced it in planning meetings. But the operational reality was that nobody had time to chase statements, re-key data, and maintain an accurate picture. According to Kitces Research, this is the norm — the median advisory firm spends 28% of staff hours on data management, and most of that time is consumed by the manual aggregation cycle of request, receive, enter, and reconcile.

Our advisors would ask clients about outside accounts in every annual review, write it down on a notepad, and then nobody had time to follow up. The data sat in meeting notes, not in our planning software.

The Trigger: A Lost Client

The catalyst was losing a $2.3 million household. The client — a dual-income professional couple — left after their annual review because the advisor's recommended asset allocation ignored $890,000 in the wife's 401(k) and $340,000 in a legacy brokerage account from a previous employer. The plan showed 72% equity, but the household's actual allocation was 51% equity when outside accounts were included. The client found a competing firm that offered a comprehensive aggregated view from day one.

According to J.D. Power's 2025 U.S. Financial Advisor Satisfaction Study, this pattern is common: incomplete account visibility is the number-one driver of client dissatisfaction, and 34% of clients who perceive their advisor as lacking a complete picture leave within 24 months.

The firm estimated the lifetime revenue loss of that single household at $46,000 over five years. That number made the case for change.

Phase 1: Assessment and Platform Selection (Weeks 1-2)

The firm evaluated four approaches based on their existing technology stack (Schwab custodian, Orion portfolio management, eMoney financial planning, Redtail CRM):

According to Kitces Research, 58% of advisory firms choose their portfolio management platform's native aggregation for simplicity. The firm initially leaned toward Option A — activating Orion's built-in aggregation at no incremental cost.

However, the lead advisor's requirements went beyond data collection. The firm wanted automated workflows that would trigger when new accounts appeared, when connections went stale, and when held-away asset balances exceeded consolidation thresholds. Orion's native alerting was limited to basic notifications. According to Aite-Novarica Group, this "notification without action" gap affects 64% of advisory firms that deploy aggregation.
AUM visibility with aggregation automation: 95% of assets tracked according to Plaid (2024)

The firm chose Option D: Orion's native aggregation for data collection, plus US Tech Automations for the downstream workflow automation that would turn data events into advisory actions.

Phase 2: Configuration and Client Onboarding (Weeks 3-6)

Aggregation Setup

Orion's aggregation module required configuration for each institution type. The operations manager mapped data flows:

• Custodial accounts (Schwab): Already in Orion natively, no aggregation needed

• Held-away brokerage: Orion aggregation via client credential authorization

• 401(k) plans: Orion aggregation, supplemented with manual entry for unsupported recordkeepers

• Banking: Orion aggregation via Plaid-connected open banking tokens

• Annuities: Manual entry with quarterly balance updates (carrier API coverage insufficient)

According to Morningstar, connection success rates for the top 200 institutions exceed 98.7%. The firm's client base skewed toward large employers with well-supported recordkeepers, which simplified the 401(k) coverage challenge.

Client Authorization Campaign

The firm ran a structured client authorization campaign over three weeks:

According to J.D. Power, 82% of clients respond positively to aggregation requests when the advisor frames the benefit in planning terms. The firm's messaging emphasized: "We want to see everything so we can advise on everything — this is a 15-minute setup that improves every recommendation we make going forward."

The 32 households that did not initially authorize were added to an ongoing nurture sequence. Within 90 days, 24 of the 32 completed authorization, bringing the total to 184 out of 192 households (96% participation).

Workflow Automation Configuration

While the operations team handled aggregation setup, the lead advisor configured US Tech Automations workflows:

Workflow 1: New Account Detection. When Orion's aggregation detects a new held-away account, the automation fires a sequence: validate data quality → calculate household allocation impact → notify advisor with assessment → queue consolidation conversation if balance exceeds $50,000.

Workflow 2: Stale Connection Alert. When any aggregated connection has not refreshed in 5+ business days, the automation sends a client notification requesting credential update, queues a follow-up reminder at day 8, and escalates to the advisor at day 12.

Workflow 3: Balance Change Monitoring. When a held-away account balance changes by more than 15% without a corresponding managed account change, the automation alerts the advisor to investigate — potential consolidation, distribution, or outside transfer.

Workflow 4: Quarterly Aggregation Health Report. Every 90 days, the automation generates a firm-wide aggregation health report: connection success rates, data freshness scores, coverage gaps, and held-away asset totals by household.

Phase 3: Data Quality and Optimization (Weeks 7-8)

The first two weeks of live aggregation revealed expected challenges. According to Aite-Novarica Group, 38% of aggregation implementations encounter significant data quality issues during the initial deployment period. The firm documented three categories:

Connection failures (12% of initial connections). Primarily caused by multi-factor authentication requirements that the initial credential submission did not capture. The US Tech Automations stale connection workflow caught these within 5 business days and triggered the client reauthorization process.

Data classification mismatches. Orion's aggregation categorized some 401(k) accounts as "Individual Retirement" rather than "Employer-Sponsored Retirement," creating asset allocation errors in household reports. The operations manager built classification override rules that corrected 94% of mismatches automatically.

We expected some cleanup, but the automation workflows caught issues faster than we could have found them manually. The stale connection alerts alone saved our ops manager 6+ hours in the first month.

Missing cost basis data. According to Morningstar, aggregated connections provide cost basis data for approximately 65% of held-away accounts. The remaining 35% required manual entry or client-provided documentation. The firm prioritized cost basis collection for accounts above $100,000, which covered 80% of the held-away asset value.

Results: 12-Month Outcomes

Account Visibility

The 95% visibility ceiling reflects the residual gap from alternative investments, small insurance carriers, and 8 households that declined authorization. According to Cerulli Associates, 95% is at the top of the achievable range for automated aggregation, with the remaining 5% requiring manual data collection for unsupported institutions.

Financial Impact

According to Cerulli Associates, advisory firms that achieve 90%+ account visibility grow organic AUM 22% faster than firms with sub-60% visibility. This firm exceeded that benchmark — their 37% increase in new client capture was driven primarily by an improved referral rate. According to J.D. Power, clients who rate their advisor's comprehensiveness as "excellent" provide 3.1x more referrals than clients who rate it as "fair."
Client financial picture completeness: 85% vs 40% manual according to Orion Advisor (2024)

How did aggregation lead to $1.7 million in consolidations?

The automated new-account detection workflow identified 87 held-away accounts across the book of business with balances exceeding $50,000. The advisor consolidation conversations — triggered and queued by the US Tech Automations workflow — converted 14 of those accounts into managed assets, totaling $1.7 million. The conversion rate of 16% aligns with industry benchmarks from Cerulli Associates, which reports a 12-31% consolidation success rate depending on the advisor's approach.

Operational Impact

The 81% reduction in data collection time freed the operations manager to take on client service responsibilities that had been deferred, including proactive outreach to clients approaching life milestones (retirement, home purchase, estate planning triggers). According to Kitces Research, this reallocation of staff time is the most common secondary benefit firms report after deploying aggregation.

Client Satisfaction Impact

The firm surveys clients annually using a Net Promoter Score methodology. Results before and after aggregation:

According to J.D. Power, the industry-average NPS for financial advisors is 38. The firm's post-aggregation score of 67 places it in the top quartile nationally.

Cost Analysis and ROI

ROI payback period: 4.5 months. The firm recovered its full implementation cost before the end of the second quarter. According to Kitces Research, the industry-average payback period for aggregation deployments is 4-6 months, placing this firm squarely in the expected range.

We spent $18,000 and got back nearly $200,000 in the first year. The math was never the hard part — the hard part was admitting we had been operating blind for eight years.

Lessons Learned

What Worked

Starting with top households. By focusing the first authorization wave on the 50 highest-AUM households, the firm captured 70% of the revenue benefit within the first 30 days. This created visible momentum that motivated the team to push through the more labor-intensive second and third authorization waves.

Framing aggregation as a planning benefit. Client authorization rates reached 96% when the messaging centered on "better advice" rather than "data collection." According to J.D. Power, this framing aligns with what clients actually value most in their advisory relationship.

Pairing aggregation with workflow automation. The US Tech Automations workflows turned aggregation from a passive data feed into an active advisory tool. Without the automation layer, the firm estimated they would need to hire an additional operations person to manage the increased data volume and exception handling — a $55,000-$65,000 annual cost that the $4,800 automation platform eliminated.

What They Would Do Differently

Pre-build the data classification rules. The data quality issues in weeks 7-8 could have been anticipated. The firm recommends building institution-specific classification mapping before activating aggregation, rather than discovering mismatches after the data starts flowing.

Set client expectations about connection maintenance. Several clients expressed frustration when aggregation connections required periodic reauthorization (typically every 90 days for screen-scraped connections). The firm now includes connection maintenance expectations in the initial onboarding conversation.

Invest in the client portal earlier. The firm delayed deploying the aggregated client portal until month 4. In retrospect, launching the portal alongside the initial authorization campaign would have reinforced the value proposition — clients could immediately see the benefit of sharing their account access.

Frequently Asked Questions

How much disruption did the implementation cause to daily operations?

The operations manager dedicated approximately 60% of her time to the implementation during weeks 3-6, and 30% during weeks 7-8. Advisors spent approximately 5 hours total on configuration decisions and workflow design. Client-facing activities continued without interruption throughout the process. According to Aite-Novarica Group, this level of operational impact is typical for mid-size RIA implementations.

Did any clients refuse to authorize account aggregation?

Eight out of 192 households (4.2%) declined authorization. Reasons included privacy concerns (5 households), unwillingness to share login credentials (2 households), and one household that was in the process of transferring to another advisor. The firm respects these decisions and maintains manual data collection for those households. According to J.D. Power, refusal rates below 10% are considered excellent.

What happened with the 401(k) accounts at unsupported recordkeepers?

Eleven client 401(k) accounts were at recordkeepers not supported by Orion's aggregation. The firm used manual entry with quarterly balance updates for these accounts, supplemented by annual statement collection during tax season. According to Morningstar, recordkeeper coverage expands by approximately 3-5% annually as more plans adopt open banking standards.
Account aggregation error reduction: 92% fewer discrepancies according to Plaid (2024)

How does the firm handle aggregation for new client onboarding?

Account aggregation authorization is now part of the standard onboarding workflow. New clients complete digital consent forms and institution connections during their second meeting. The US Tech Automations platform triggers the onboarding sequence automatically when a new household is created in the CRM, ensuring no step is missed.

What security measures protect aggregated client data?

Orion's aggregation uses 256-bit AES encryption and SOC 2 Type II-certified infrastructure. Client credentials are tokenized — the advisory firm never has direct access to login information. US Tech Automations processes workflow triggers using metadata (account type, balance thresholds, connection status) without accessing raw credential data. According to the CFP Board, this architecture meets SEC Regulation S-P requirements for client data protection.

Can this approach scale to larger firms?

The same architecture — aggregation platform plus workflow automation layer — scales linearly. According to Cerulli Associates, firms with 500+ households typically see even stronger ROI because the per-household cost of automation decreases while the per-household benefit of visibility remains constant. The US Tech Automations platform handles workflow orchestration at any firm size without requiring additional infrastructure.
Financial account aggregation automation accuracy: 99.5% data reconciliation according to Plaid (2024)

What metrics should firms track after deploying aggregation?

The five critical metrics are: account visibility percentage (target 90%+), connection freshness rate (target 95%+ refreshed within 7 days), consolidation conversion rate (benchmark 12-31%), staff hours on data collection (target 80% reduction), and client satisfaction scores related to comprehensiveness. The firm reviews these metrics monthly using the automated quarterly health report generated by US Tech Automations.

Conclusion: The 60-Day Transformation

This firm went from 48% account visibility to 95% in 60 days, spent $18,400 on implementation, and generated $197,525 in first-year benefits. The technology was not the hard part — modern aggregation and workflow automation platforms work as advertised. The hard part was the organizational decision to stop accepting partial visibility as normal.

Every advisory firm operating below 90% account visibility is making the same mistake this firm made for eight years: advising on half the picture, billing on less than they could, and slowly losing clients who expect comprehensive service.

Request a demo of US Tech Automations to see how the workflow automation layer connects to your existing aggregation platform, portfolio reporting, and compliance systems — and start building toward 95% account visibility.