Insights
Advisor best practices
From spreadsheet to portfolio intelligence: tools for DIY index investors

From spreadsheet to portfolio intelligence: tools for DIY index investors

How to obtain and maintain an alpha-enhanced passive portfolio

From spreadsheet to portfolio intelligence: tools for DIY index investors

Using a broad set of low-cost index funds has become the norm for many investors. These investors rebalance when things drift away from their targets, harvest tax losses, and let compound growth do the heavy lifting. Research backs it. But here's the thing people don't talk about: while the philosophy is easy, actually running it across multiple brokers, accounts, and goals can be a pain.

This guide is for you if you're juggling investments at Vanguard, Fidelity, Schwab, and maybe Robinhood. If you're tracking retirement, college savings, and a taxable brokerage all at once. If a spreadsheet used to work fine but is starting to feel like a second job (or a nagging job you ignore). And if you want to stay in control of your money while actually seeing your real allocation—not just one account at a time.

We'll walk through what a passive index investor actually needs, compare your options (broker tools, spreadsheets, robo-advisors, and portfolio intelligence apps), and help you figure out what actually fits your life. Along the way, we'll explain some concepts that get thrown around a lot but don't always land clearly.

Let's start with a real problem you're trying to solve.

The evolving world of multi-account portfolio management for DIY Investors

Here's an example of what may happen if you rely only on your broker's dashboard: you see investments in Vanguard and Fidelity, and you have a target-date fund from your old employer's 401(k). You’re aiming for a 80% stock, 20% bond portfolio across each of your portfolios. You figure you should keep the same target asset allocation across all accounts. The Vanguard app tells you you're 80% stocks and 20% bonds. The Fidelity app says 75% stocks, 25% bonds. So you're... confused. Which one is right? Are you really 78% stocks? What about that 401(k)? And if you're trying to do strategic asset allocation—the idea that your overall stock/bond mix is a main driver of your investment risk and return—you need to see all your money in one view.

The academic research on asset allocation is pretty clear: the mix of stocks and bonds you choose tends to matter more than which specific stocks or bonds you pick. Volatility across portfolios is driven primarily by allocation decisions, not security selection. So if you're splitting across three brokers without a way to monitor your accounts in one place, you could be flying blind on an important factor.1

That's the first reason folks move beyond broker dashboards.

The second reason is tax efficiency. If you have municipal bonds in a taxable account and high-dividend funds in a tax-advantaged account, you could be leaving money on the table. The right asset location strategy—putting tax-inefficient assets in tax-advantaged accounts—can improve your after-tax returns meaningfully over decades.2 But that optimization only makes sense if you can see all your holdings at once and think about them as one portfolio, not separate accounts across brokerages. Do you consolidate to one broker then? How do you move your employer’s account? You may not want to move everything to your employment brokerage - what if you change jobs? Isn’t your spouse’s 401k at a different broker?

The third reason is monitoring and rebalancing. Research shows that periodic rebalancing helps investors maintain their target risk profile, especially across volatile periods, and can modestly improve risk-adjusted returns in many cases by automatically "selling high" and "buying low".3 But again, if your portfolio is scattered, this can get messy fast.

Add goal-based tracking on top of it (retirement vs. college vs. a house down payment), and you're possibly looking at a spreadsheet nightmare and a lot of manual work. How do you make sure your spreadsheet is working right? Did you capture every nuance?

To help with this, you have four basic tools to choose from. Let's walk through each one.

1 Brinson, G. P., Hood, L. R., & Beebower, G. L. (1986). Determinants of portfolio performance. Financial Analysts Journal, 42(4), 39-44.

2 Sialm, C. (2009). Asset location for retirement savers. Journal of Finance, 65(3), 959-992.

3 Arnott, R. D., & Lovell, R. D. (1989). Rebalancing: Why, when, where, and how. Journal of Investing, 1(2), 35-40the averageand Every.

Option 1: Broker-Native Tools

Here's an example of what may happen if you rely only on your broker's dashboard: you see investments in Vanguard and Fidelity, and you have a target-date fund from your old employer's 401(k). You’re aiming for a 80% stock, 20% bond portfolio across each of your portfolios. You figure you should keep the same target asset allocation across all accounts. The Vanguard app tells you you're 80% stocks and 20% bonds. The Fidelity app says 75% stocks, 25% bonds. So you're... confused. Which one is right? Are you really 78% stocks? What about that 401(k)? And if you're trying to do strategic asset allocation—the idea that your overall stock/bond mix is a main driver of your investment risk and return—you need to see all your money in one view.

The academic research on asset allocation is pretty clear: the mix of stocks and bonds you choose tends to matter more than which specific stocks or bonds you pick. Volatility across portfolios is driven primarily by allocation decisions, not security selection. So if you're splitting across three brokers with no unified view, you could be flying blind on an important factor.

That's the first reason folks move beyond broker dashboards.

The second reason is tax efficiency. If you have municipal bonds in a taxable account and high-dividend funds in a tax-advantaged account, you could be leaving money on the table. The right asset location strategy—putting tax-inefficient assets in tax-advantaged accounts—can improve your after-tax returns meaningfully over decades. But that optimization only makes sense if you can see all your holdings at once and think about them as one portfolio, not separate accounts across brokerages. Do you consolidate to one broker then? How do you move your employer’s account? You may not want to move everything to your employment brokerage - what if you change jobs? Isn’t your spouse’s 401k at a different broker?

The third reason is monitoring and rebalancing. Research shows that periodic rebalancing helps investors maintain their target risk profile, especially across volatile periods, and can modestly improve risk-adjusted returns in many cases by automatically "selling high" and "buying low." But again, if your portfolio is scattered, this can get messy fast.

Add goal-based tracking on top of it (retirement vs. college vs. a house down payment), and you're possibly looking at a spreadsheet nightmare and a lot of manual work. How do you make sure your spreadsheet is working right? Did you capture every nuance?

To help with this, you have four basic tools to choose from. Let's walk through each one.

Single-Broker Views (Vanguard, Fidelity per-account, Schwab per-account, etc.)

Every major broker provides a dashboard to view your accounts. These are genuinely useful for what they do: clean views of positions, cost basis, realized gains, and simple allocation charts per institution. Your broker knows your exact positions, cost basis, realized gains, and unrealized gains. That's their core data, and they display it cleanly: a pie chart of your asset allocation per account, performance since purchase, and often some basic rebalancing alerts. If you're using Fidelity, for example, you can see a detailed breakdown of holdings and sort by sector or position size.

If you like nice visuals and want to track how a single account is performing, this is genuinely useful.

The catch is obvious: they only show your money at that broker. If you're juggling Vanguard, Fidelity, and Schwab, you need three logins to see the whole picture. These single-broker views only show you their own accounts. You can't view your Vanguard and Fidelity holdings on the same dashboard. That's a feature, actually—they want you to consolidate with them. But you may not want to. You might like Vanguard's fund lineup, Fidelity's trading experience, and Schwab's customer service. So you're stuck.

According to Morningstar Voice of the Investor (2024), the average American's assets are split across employer retirement (38%), bank accounts (23%), brokerage/investment (14%), Traditional IRA (10%), Roth IRA (7%), crypto (4%), and education savings (3%). The average investor has ~5 different types of accounts (employer, bank, brokerage, IRA variants, etc.), suggesting institutional fragmentation is normal. With the rise of FinTech tools and a more mobile workforce, Enrich predicts the number of accounts per person will grow, not consolidate. As a result, getting a consolidated view across brokerage firms is increasingly important to investors managing their own portfolios.

Even if you use (or consolidate to) just one broker, broker tools may not handle complex multi-asset portfolios well. If you own VTI, VXUS, and VTIAX, you have overlap. The broker could treat each as a separate line. If you're trying to figure out if your US/international allocation is 70/30 like you want, you have to do math. If you're trying to decompose a target-date fund or an ESG index fund into its component factors (size, value, geography), good luck.

And—most importantly—broker tools don't generally let you tie holdings to goals. You have an IRA, a 401 (k), a Roth IRA, and a taxable account, all aimed at your retirement. Your IRA is not the only goal aimed at "retirement." And if you have investments in your taxable account where you’re saving for a down payment, how can you split them off to be targeted towards that goal? Single broker-views don’t allow for this.

Broker-hosted aggregation tools (Fidelity full view, Schwab account aggregation, Vanguard outside investments)

Over the last few years, major brokers have added account aggregation features. The idea is smart: you can link your external accounts (at other brokers) from within the broker's platform, and see everything in one dashboard without moving money.

Fidelity Full View is the most mature. You log into Fidelity, set up Full View (powered by eMoney, a tool for financial planners, behind the scenes), and enter your login credentials for other institutions—Vanguard, Schwab, Robinhood, 11,000+ financial institutions. Each day, Full View scans those sites and pulls data into Fidelity. You get a consolidated view of all your holdings in one place, with automatic daily updates for linked accounts.

Schwab Account Aggregation works similarly: you link external accounts from within your Schwab dashboard, and they are then fed into your overall portfolio view.

Vanguard's "Outside Investments" feature lets you manually add external accounts (you type in ticker symbols and share counts) so they're included in Vanguard's portfolio analysis, though updates are manual, not automatic.​

Many other brokerages and robo-advisors have followed suit. This is a real step forward. You get a unified view. And it's free.

Where broker aggregators actually work well

If you're primarily with one broker (say, 80% of your money is at Fidelity) and you have a small account or two elsewhere, aggregators are a solid option. You check at that one broker, see everything, and you're done. The aggregation saves you from having to log in to three platforms.

Fidelity's aggregator also feeds into its portfolio analysis tool (called "Guided Portfolio Summary" or "GPS"), which can show you asset allocation across your connected accounts, not just Fidelity accounts. That's genuinely useful if you want to see whether you're actually at your target 70/30 stock/bond split across all brokers.

The limitations of aggregators

Here's what could break down:

  • Connection reliability and coverage gaps: Not all financial institutions allow account aggregation. Some link seamlessly; others require "web access" logins (less secure, because the aggregator logs in as you rather than using a special read-only API). Smaller institutions, credit unions, and newer platforms (such as Coinbase and Fundrise) often don't yet offer aggregation support. If you have accounts at less common brokers, the aggregator might not connect.
  • No unified asset allocation analysis across all accounts: Fidelity's Full View does a good job, but even there, you're limited. The aggregation pulls holdings, but if you're trying to see your true across-all-brokers allocation—mapping specific holdings to asset classes and goals—the analysis tools in a broker platform are broker-centric. They can show you asset allocation across your Fidelity + linked accounts, but only if those linked holdings are categorized correctly. If Fidelity doesn't recognize a security or fund from another broker, it might categorize it as "Unknown," and your allocation data becomes unreliable.
  • Limited customization: Broker tools are built for the median investor. You generally can't easily define custom asset classes, map holdings to specific goals, or create your own allocation rules. If you have a unique strategy or a mix of factor tilts, you're limited.
  • Manual updates for manual adds: You can also manually add accounts to these aggregators (just type in balances), but if you do, you have to update them manually when positions change. You can add holdings manually in Fidelity's Full View, but it's clunky, and new holdings must be entered one at a time.
  • Security and privacy trade-offs: Account aggregators store your usernames and passwords and log in to other institutions on your behalf. This is secure (they use encryption and trusted channels), but it's not zero-risk. You're trusting the broker (and the underlying aggregation service) to protect your credentials. It's one more place your login info lives. Also, some financial institutions disable two-factor authentication when an approved aggregator logs in (because they trust the aggregator), which can feel like a security step backward.​

Additionally, these tools are free and don’t drive revenue for brokers; they encourage greater engagement with brokers. Sometimes brokers use this information to inform their wealth management teams who to call to offer financial planning services.

When broker aggregators make sense

  • You have most of your money at one primary broker and one or two small accounts elsewhere.
  • You just want to see total balances, net worth, and a big-picture allocation view.
  • You trust the broker and are comfortable with their aggregation approach.
  • You don't have complex goals, custom asset classes, or tax-focused needs.

When they don't

  • You have accounts at multiple brokers you want to keep equal-weight (splitting between Vanguard and Fidelity, for example, for diversification).
  • You want precise asset allocation tracking with custom rules and goal-based mapping.
  • You have accounts at institutions that don't support aggregation.
  • You want tax-aware rebalancing suggestions and TLH identification built in.
  • You prefer not to share login credentials with additional services.

Broker aggregators are a nice middle ground between "single broker + spreadsheet" and "independent portfolio intelligence app." They give you visibility without moving money, and they're free. The problem is they might not be deep enough for investors who want to actually use that visibility to make smarter decisions about allocation, taxes, and rebalancing. They're more "reporting" than "intelligence.”

This is why many serious DIY investors use broker aggregators alongside a spreadsheet or independent app: the aggregator gives them a quick net-worth check, but for real portfolio analysis and decision-making, they go elsewhere.

Option 2: Spreadsheets and custom scripts

When you decide to manage your investments yourself, the immediate response for most is to build a spreadsheet. This is the DIY investor's best friend. A well-built spreadsheet or Google Sheet can do almost anything. You can define your own asset classes, map holdings exactly where you want them, build custom rebalancing logic, and see your real allocation across every account in one view.

The Bogleheads forum has entire threads dedicated to spreadsheet tricks (link). Rob Berger, a DIY investor influencer, provides a free spreadsheet (link). Folks build Google Sheets with integrations to their bank accounts or manually update them daily. Some go harder and write Python scripts to pull data from APIs. If you like tinkering and have time, this is freedom.

Spreadsheets are freeing because they don't judge. It does what you tell it. You're in complete control. You decide what "US equity" means. Maybe it's just VTI. Maybe it's VTI plus a small-cap value tilt. Maybe it's a specific weighting of individual stocks and funds. Your rules, your way.

However, getting spreadsheets to work can be a time sink and often times anxiety inducing. Every time you open a new account, buy a new holding, or move money, you have to update the sheet. Additionally, the market isn’t static. The median stock fund has an annual turnover of 65%, with the average investor experiencing 51% turnover across their stock fund holdings. Index funds operate at a fraction of that level.4 While index funds have remarkably low turnover, ranging from 4% to 19% depending on the fund type (e.g., small cap requires more frequent rebalancing), it is still another data point to track your exposure and fund overlaps (when two funds are invested in similar factors or dimensions, leading to unexpected concentration)5. If your automated import breaks—and it could—you're back to manual entry. Formulas from advanced rebalancing techniques break quietly. You might not notice for weeks that one cell isn't syncing, and suddenly your "true" allocation is wrong. If you're tracking multiple family members' portfolios or managing your parents' money alongside your own, the maintenance burden gets real. And you’re always left wondering, “Did I capture everything?”

If you're just starting out and want to learn by doing, or if you have a truly simple portfolio and you genuinely enjoy tinkering, spreadsheets are great. They're free, they're flexible, and they force you to understand your own holdings. However, as your life gets more complicated, so does the number of accounts and goals you take on, and as a result, your spreadsheet gets more complicated as well. If Excel formulas feel like home, this might be the path for you. If you have time for upkeep, this is solid.

If complexity is growing or you're tired of maintenance, that's a signal to look at the next option.

4 Reid, B., & Millar, K. (2004). Mutual Funds and Portfolio Turnover. Investment Company Institute Research Commentary.

5 Personal Fund. (2022). Mutual Fund and ETF Turnover Ratio Research.​

Option 3: Robo-Advisors

Robo-advisors have evolved a lot. Traditional robo-advisors like Betterment, Wealthfront, and Schwab Intelligent Portfolios handle the entire workflow: you tell them your risk tolerance, they build a diversified portfolio, automatically rebalance it, and monitor for tax-loss harvesting opportunities. You don't have to think about asset allocation or individual trades. Behavioral finance research is pretty clear that individual investors tend to trade too much and hurt their returns by reacting emotionally to market swings, so handing the wheel to a rules-based system can blunt some of that damage.6

You answer a questionnaire, the algorithm maps you to a portfolio (usually a mix of ETFs from a set of prebuilt model portfolios), and the system takes over ongoing rebalancing and basic tax-loss harvesting with wash-sale avoidance in taxable accounts. In exchange, you pay an advisory fee—typically around 0.25% to 0.50% per year on the assets you transfer into the robo-advisor.7 For many people, the trade is: pay a small percentage of assets and never touch the trading screen again.

For a pure index investor, that fee can be hard to justify over long horizons. Passive funds themselves require monitoring but not a ton of trading, and robo fees are not buying you time with a dedicated human planner; you’re paying for automation and guardrails around an already simple strategy. Additionally, the robo-advisor doesn’t manage multi-account portfolios - it can’t handle your 401k, or coordinate tax-optimizing asset location strategies across accounts. If you want a set-it-and-forget-it approach to each of your accounts, you will give up some control. If the robo builds you a portfolio with 11 holdings and you disagree with their international tilt or factor choices, you can’t easily swap pieces out without breaking their system. You’re accepting their definition of “diversified.”

As the category has grown, newer robo approaches have branched in a few directions. Some target higher-net-worth users with allocations into alternatives (private real estate, private credit, structured products), which can add complexity and risk that a passive index investor or one with already concentrated investments (RSUs, entrepreneurs, etc) may not want or need. Another branch focuses on “alpha-enhanced passive” using direct indexing: instead of ETFs, they hold many individual stocks that track an index, so they can harvest losses more granularly and let you personalize exposure (exclude certain sectors, manage single-stock risk, apply ESG screens). Another branch focuses on “alpha-enhanced passive” using direct indexing: instead of ETFs, they hold many individual stocks that track an index, so they can harvest losses more granularly and let you personalize exposure (exclude certain sectors, manage single-stock risk, apply ESG screens). Most recently, a set of AI-native platforms—like Autonomous and Origin’s AI advisor—are pushing toward full “financial brain” territory: you connect your accounts, and you can ask questions like “should I max my 401(k) or pay down my mortgage?” or “how does this job offer affect my taxes and retirement?” and get scenario analysis in real time.

That all sounds powerful, but there’s a real trust issue for many investors. Some don’t like having to move their money to the robo’s custodian and then let that platform execute trades automatically. If you already have a mix of IRAs and taxable accounts at multiple brokers, re-centralizing everything into one robo can feel like a massive lift. And how will you move your employer’s 401(k) to the roboadvisor? And as one Enrich client put it in a conversation: “I’m already hesitant about all these roboadvisors automatically moving money around and executing trades. I’ve seen how fickle all these fintech systems are, so I would rather there just be an advice layer on top of existing accounts.” That’s a very common sentiment among experienced DIY investors who are thinking of switching away from robo-advisors.

6 Odean, T. (1999). Do investors trade too much? American Economic Review, 89(5), 1279-1298.

7 Morningstar (2025). Are Robo-Advisors Still Worth It? Morningstar Personal Finance.

8 Testimonials are from an Enrich client who participated in a interview. No compensation was paid to this user for their testimony. The firm is not aware of any material conflicts of interest related to this statement, robo-advisors.

When robo-advisors make sense:

  • You don’t want to manage the day-to-day mechanics of investing. If the idea of picking funds, setting an allocation, and remembering to rebalance stresses you out, automation is a real benefit, even at 0.25%–0.50% per year.
  • Your accounts are relatively simple. One or two IRAs and a taxable account are easy to transfer onto a single platform and let the robo run.​
  • You’re at an earlier stage. For portfolios in the low five figures, the absolute dollar fee is modest, and the discipline benefit can outweigh the cost.
  • You’re okay with their level of personalization. You want a well-diversified, low-cost portfolio and don’t have strong opinions about exact tilts or custom rules.

When robo-advisors make less sense:

  • You already have a multi-broker setup. If you’ve got 401(k)s anchored at employers, IRAs at one firm, taxable at another, and maybe some legacy accounts, consolidating everything into one robo may not be worth the hassle or tax friction.
  • You’re seeking tax optimization through asset location, taking advantage of the tax protections of various accounts.
  • You care about maintaining full control over your accounts and trades. If the idea of an algorithm moving money around without you pressing the button makes you uneasy, you’re not going to sleep well, even if the math is sound.
  • You want deeper customization than a model portfolio. If you care about which specific funds implement your strategy, want to manage factor tilts or concentrated positions, or want goal-by-goal asset allocation, most traditional robo-advisors will feel constraining.
  • You’re fee-sensitive and already committed to a low-cost index approach. At larger asset levels (say $500k+), even a 0.25% fee is a non-trivial dollar amount every year, layered on top of fund expense ratios, for work that a good portfolio-intelligence tool plus your own discipline can often cover.

Option 4: Independent portfolio tools

Portfolios Intelligence Apps are designed to sit on top of your existing accounts, pulling in data from multiple brokers to give you one unified, analysis-first view. Unlike broker aggregators or robo-advisors, you don’t need to move your money around. You keep your accounts at Vanguard, Fidelity, Schwab, wherever. The app connects to those accounts, pulls in your holdings, and analyzes them.

Within this category, there are sub-slices:

  • Net worth and allocation tracker: primarily shows you your total net worth and a high-level allocation across accounts. These tools are useful for big-picture views, but their lack of granularity and understanding of your investment strategy can make it difficult to assess tax-optimization strategies or whether your portfolio is on track to achieve your financial goals. Sometimes, these are free and used to upsell you to paid financial advising services.
  • Retirement planning platforms: focus on modeling income, withdrawal strategies, and success probabilities. Great if retirement planning is the goal, less useful if you're focused on current portfolio management or other financial goals.
  • Portfolio intelligence tools: these tools go deep on holdings, decomposition, allocation accuracy, and the mechanics of getting to your target—rebalancing, tax-loss harvesting, asset location—while leaving trading decisions in your hands.

Each solves different problems. If you want to know "will I be OK in retirement?", use a retirement planning platform. If you want to understand your net worth across many public and private investments, use a net worth tracker. If you want to manage your portfolio across accounts with precision and stay in control, you're looking at a portfolio-intelligence app, like Enrich.

No matter which portfolio intelligence app (or if you decide to use them all), you get a unified view across all your brokers without moving a dollar. These apps are designed to help you generate insights in your portfolio that would be difficult to obtain with any of the other options. And you stay in control. You keep your accounts. You make the trades. The app is a decision-support tool, not a managed account.

Since these tools are aggregating data from multiple brokers, security and privacy matter. Check whether they're using established aggregators (Plaid is pretty standard), whether they're auditing their security (SOC 2 Type I is a good sign), and whether they're a registered investment advisor (meaning they're subject to fiduciary duty).

Also, don't let nice charts make you think the tool is doing more than it is. A good portfolio intelligence app gives you information and recommendations. It's not making trades. You are. That's the point.

A deeper look: what portfolio intelligence actually means

If you're considering the portfolio-intelligence route, it's worth understanding what "intelligence" actually covers. Here's what the good ones do:.

1. Unified holding view across brokers

You connect all your brokerage accounts in one app. The app pulls in your holdings, positions, and values daily (or as often as your broker provides data). Instead of logging into Vanguard, Fidelity, and Schwab separately, you see everything in one place. Sounds simple, but for those stuck in spreadsheets, it could be huge.

2. Goal-based portfolio mapping

Instead of "here's my Vanguard account" and "here's my Fidelity account," you build goals: retirement at 65, college in 10 years, down payment in 3 years. Then you assign portions of your holdings to each goal. There’s a growing body of research on goal-based investing—also known as goal-based wealth management or private ALM. Instead of treating the portfolio as one big pot, these frameworks explicitly tie asset allocation to specific goals (retirement income, college, home purchase) and define risk as the probability of undershooting those goals rather than just volatility. Studies show that tailoring strategies to goals and time horizons can reduce the risk of failing to meet those goals compared with one-size-fits-all allocations. This matters because different goals have different time horizons and risk tolerances. Your down-payment money should probably be safer (more bonds) than your retirement money 20 years out (more stocks). Once you map holdings to goals, the app can show you the actual allocation per goal, not per account, and alert you if a goal's allocation is drifting from your target. EDHEC-Risk reports that, in their retirement goal-based frameworks, using dedicated safety and growth portfolios with dynamic allocation can improve the probability of achieving investors’ aspirational income goals by up to around 50% versus simpler stock/bond mixes, in their modeled scenarios.9 Real-world results will depend on contributions, market returns, and specific plan design.”

3. Flexible asset allocation rules

Strategic asset allocation determines the vast majority of a portfolio's long-term returns and risk profile, as several studies have shown that this allocation drives ~90% of a portfolio's returns.10 Unlike tactical shifts aimed at exploiting short-lived opportunities, strategic allocation is about establishing the fundamental, durable foundation that will carry you toward your ultimate financial objectives. Some tools only offer pre-canned asset allocation buckets, making it hard to really see what you own and where funds overlap. Other tools let you tag tickers manually—“VTI is US equity, VXUS is international equity, BND is bonds”—but that assumes each holding belongs 100% in a single bucket, which isn’t how most real-world funds work. A smaller set of tools goes deeper, using metadata and the underlying holdings to break each fund into its true components, so something like VT is split between US and international in proportion to its current index weights as they change over time. This is especially useful for “blended” funds like target-date or balanced funds, where you want to see how much is actually in stocks, bonds, and international investments. Once you do this across all funds and all accounts, you can see your true mix of asset classes and avoid double-counting the same exposure across multiple overlapping funds.

4. Background monitoring

Depending on the type of portfolio intelligence tool, it needs to be monitoring your portfolio while you aren’t. Without it, you’re actively working to be a passive investor. Portfolio trackers should be notifying you of sudden changes in your portfolio and when to update offline, private investments. Retirement planning platforms should be monitoring whether you’re on track or off track. And Portfolio Intelligence tools should calculate your target allocation (e.g., 70% stocks, 30% bonds, with stocks split 65% US, 35% international). It tracks your actual allocation daily. When actual drifts from the target beyond a threshold you set, it alerts you.

5. Do the calculations for you

When you need to make decisions, these tools will perform the calculations for you. Whether that is computing your net worth, determining your required minimum distributions, or telling you the exact trades needed to perform a rebalance or tax loss harvest. This is the critical difference from a robo-advisor. You're not handing over discretion. You're getting a recommendation you can scrutinize.

6. Let's you make tweaks based on your circumstances

When you do rebalance, the portfolio intelligence tools can show you different ways to do it. Maybe it can rebalance mostly in tax-advantaged accounts to avoid triggering capital gains. Maybe it can rebalance by directing your contributions to the right accounts first, so you don't have to sell anything. Maybe it can first harvest losses from underwater positions. When it comes to utilizing retirement planning tools, you can create various what-if scenarios to see what might happen if you were to make changes to your retirement plan. While net worth trackers can model and let you tweak your investment strategy and portfolio to understand how your investment may grow, given certain scenarios. No need to build a complex financial model in Excel yourself.

9 Martellini, L., Milhau, V., & Tarelli, A. (2017). Applying Goal-Based Investing to the Retirement Issue. EDHEC-Risk Institute.

10 Brinson, G. P., Hood, L. R., & Beebower, G. L. (1986). "Determinants of portfolio performance." Financial Analysts Journal, 42(4), 39-44. Seminal study showing that asset allocation explains over 91% of return variation for balanced funds. Extended by Vanguard research confirming approximately 90% of long-term return variation attributable to strategic asset allocation.

How Enrich works (and where it fits)

Enrich is an independent portfolio intelligence app. If you're trying to figure out whether this type of tool makes sense for you, here's what it does:

Connection and visibility

You connect your brokerage accounts (Vanguard, Fidelity, Schwab, and 11,000+ other institutions) via secure data aggregation. The app pulls in your holdings, positions, and values daily without touching your accounts. You see your connected accounts in one place.

Goal-based portfolios

You create goals (retirement, college, home down payment, etc.). You assign portions of your holdings to each goal, even if those holdings are spread across accounts and institutions. The app then tracks your allocation per goal, not per account. This gives each of your investments a role in helping you achieve your goals. Together with other investments in the goal’s portfolio, it creates a strategy to help you achieve your goal. Research shows that Goal-based investing generates improvements in the probability of achieving investors’ important or aspirational goals that can reach 50% or more compared to traditional approaches.11

Flexible allocation rules

You can define asset allocation rules in two ways. Option one: assign specific holdings to rules manually; for example, create a rule called “US Equity” and assign both “VTI” and “AMZN” to it. Option two: use the investment's factor dimensions (geography, market cap, sector, issuer, etc.) to define rules and let the system automatically allocate funds. The latter method is effective if you have a lot of turnover in your portfolio, and helps you see where there might be equity exposure overlaps (e.g., in January 2026, SPY had an equity exposure of 34%). This dimension-based approach lets you decide what combination of factors you want to allocate your investment strategy to.

Portfolio Analytics

Based on the investments you assign to each goal, Enrich will compute the portfolio’s historical performance metrics, including risk, return, beta, Sharpe ratio, and alpha. Giving you concrete metrics to assess your portfolio against common benchmarks.12

Monitoring and alerts

The Enrich app tracks your actual allocation against your target and alerts you when drift exceeds thresholds you set. You can adjust sensitivity per goal (your retirement allocation might have a wider band than your short-term savings).

Tax-aware insights

The app identifies tax-loss harvesting opportunities, shows you which accounts are best for which assets, and helps you think through asset location decisions.

Trade instructions, not auto-trading

When you're ready to rebalance or harvest losses, the app generates exact trade instructions: sell this amount of this fund in this account, buy this amount of this fund in that account. You execute the trades at your broker. You're always in control. You’re in the driver’s seat when it comes to moving money around and executing trades.

Pricing

$50 per year, flat fee, regardless of assets under management. No percentage drag. This is very different from a robo-advisor or a traditional financial advisor, which typically charges as a percentage of the assets they are managing.13 And this AUM-based fee isn’t going away, asset-based client fees are the most popular fee structure for U.S. advisors… Asset-based fees represented 72.4% of advisor compensation in 2024, and Cerulli projects that 77.6% of the industry will be fee-based by 2026.14

Keep your money where it is

Enrich doesn't move your money, doesn't auto-trade, and doesn't require custody of your assets. You stay with your existing brokers. It doesn't do active stock-picking or try to beat the market. It's built for asset allocation, focused passive index investors who want precision and tax efficiency while staying in the driver's seat.

11 Martellini, L., Milhau, V., & Tarelli, A. (2017). Applying Goal-Based Investing to the Retirement Issue. EDHEC-Risk Institute.

12 Returns shown are historical and are presented on an annualized basis for the time period indicated.​ Risk is shown as portfolio standard deviation, a statistical measure of how much returns have varied over time.​ Benchmarks are unmanaged reference portfolios and are shown for illustrative comparison only; you cannot invest directly in an index.​ The chart does not represent personalized investment advice or a recommendation to buy or sell any security or strategy.​ Past performance is not a guarantee, or reliable indicator, of future results; future returns and risk may differ materially from those shown.

13 Morningstar (2025). Are Robo-Advisors Still Worth It? Morningstar Personal Finance.

14 Cerulli Associates. “More Than 72% of Financial Advisors Are Compensated by Fee-Based Models.” Cerulli press release, 17 March 2025.

When to move beyond a spreadsheet

If you're happy with your spreadsheet, there's no urgent reason to change. But here are signs it might be time:

Multiple brokers and manual sync

If you're tracking accounts at three or more institutions and spend time manually copying data or checking that everything is syncing, spreadsheet maintenance is eating your time, and you may be losing out on opportunistic rebalancing.15

Growing portfolio complexity

Portfolio complexity is growing in 3 dimensions: 1) As you begin to hold multiple accounts and multiple financial goals, coordinating portfolio and fund overlaps becomes harder to navigate. 2) If you've moved from three simple funds to holding multiple tilts, factor funds, or a mix of ETFs and mutual funds, decomposing all of that in a spreadsheet gets tedious. 3) If you hold a concentrated portfolio position - maybe you got in early on Tesla, Nvidia, or bitcoin; maybe you have a ton of RSUs at a big tech company; or maybe you are a business owner. Your asset mix has gotten complex. How do you handle the overlaps between your investments and your concentrated positions?

Tax considerations matter

If you're starting to think seriously about tax loss harvesting, the tax advantage of the tax benefits or your tax-advantaged accounts (tax-optimization through asset location), and which accounts to contribute to, a tool that automates these views may be more valuable than having to run through all the account coordination gymnastics yourself.

Multiple brokers and manual sync

If you're tracking accounts at three or more institutions and spend time manually copying data or checking that everything is syncing, spreadsheet maintenance is eating your time, and you may be losing out on opportunistic rebalancing.15

Tax considerations matter

If you're starting to think seriously about tax loss harvesting, the tax advantage of the tax benefits or your tax-advantaged accounts (tax-optimization through asset location), and which accounts to contribute to, a tool that automates these views may be more valuable than having to run through all the account coordination gymnastics yourself.

Multiple brokers and manual sync

If you're tracking accounts at three or more institutions and spend time manually copying data or checking that everything is syncing, spreadsheet maintenance is eating your time, and you may be losing out on opportunistic rebalancing.15

Anxiety about getting things right

If you’re an optimizer, you often are left thinking whether you got everything right. While you might have your Excel formulas nailed down, did you get all the nuances about financial planning, market updates, and the latest regulatory changes to 529s? If you feel this stress, your spreadsheet does too.

None of these are a "you must move" scenario. But they're all signs that a portfolio intelligence app might deliver real value.

15 Daryanani, G. (2008). “Opportunistic Rebalancing: A New Paradigm for Wealth Managers.” Journal of Financial Planning, January 2008. Financial Planning Association.

How to Transition Safely

If you're thinking about adding a portfolio intelligence app (or moving to one), here's how to do it without blowing up your system:

Document your current setup first

Write down your target allocation, how you've mapped holdings to goals, and any special rules (like "never sell this because of wash sales").

Build your goals and rules in the app

Recreate your asset allocation targets and goal mappings in the new system. Check that the app's allocation numbers now match your plan.

Set up read-only first

Most portfolio intelligence apps let you connect accounts and just look. Don't take trades yet. Spend a week comparing the app's view of your allocation to your spreadsheet or broker dashboards. Do the numbers match? If not, dig into why.

Small test trade

If everything checks out, make one small rebalancing trade based on the app's recommendation. Then verify that the app and your broker both show the same updated position.

Go live gradually

If you're comfortable, start using the app for actual rebalancing and TLH decisions. Keep your spreadsheet alongside it for a month or two as a sanity check.

The goal is to build confidence before you fully trust a new tool. Don't jump all-in on day one. To learn more about transitioning, read our comprehensive Migrating to Enrich Guide.

The Bottom Line

You've got four paths forward:

  • Broker tools are free, simple, and work if your life is simple. The name of the game is to consolidate your assets with a single broker or find a broker that can aggregate your accounts from other brokers.
  • Spreadsheets are flexible, empowering, and free—if you have time for them. They're still the backbone of many sophisticated DIY investors' workflows.
  • Robo-advisors solve the "I want this to be automatic" problem, but you may lose direct control of your portfolio.
  • Portfolio intelligence apps sit in the middle: they give you a unified view, decision support, and tax insights, without taking over or charging you a percentage of assets.

If you're a passive, low-cost index-fund-style investor with accounts at multiple brokers, growing complexity, or a real interest in tax efficiency, a portfolio intelligence approach is worth a look. You stay in control. You keep your accounts where you like them. You get better information. And you pay a small flat fee instead of a percentage that scales with your wealth.

If you want to see what that looks like for your own accounts, Enrich lets you connect your brokers and explore for free on iOS. You can build your goals, see your actual allocation across accounts, and explore rebalancing scenarios. No trades happen without your approval. No commitment. Just a clearer picture of your portfolio.

Start a free trial and see if portfolio intelligence fits how you want to invest.

Expected Return
Can you reach your goal?
What it measures:
Will this allocation generate enough returns to hit your target?
How to calculate it:
  • Take each asset class's long-term expected return
  • Multiply by your allocation weight
  • Sum them up
Asset Class
Allocation
Expected Return
Contribution
US Stocks (VTI)
40%
7%
2.8%
International (VXUS)
15%
6%
0.9%
Bonds (BND)
30%
3%
0.9%
Real Estate (VNQ)
10%
5%
0.5%
Cash
5%
5%
0.25%
Portfolio Expected Return
5.4%
What research says:
Vanguard's research on strategic asset allocation shows that your expected return is driven almost entirely by the asset mix you choose.3 Different allocations produce predictably different returns. A portfolio weighted 70% to stocks is expected to deliver higher returns (and higher risk) than one weighted 40% to stocks.
Is your number good?
  • Run your goal numbers: at 5.4% annual return, will you have enough to achieve your goal? Use a simple formula: multiply your current savings by (1.054)^(years until your goal). (Note that this doesn’t account for regular contributions)
  • If the answer is "yes," keep going. If "no," either increase your stock allocation or adjust your goal’s timeline or aspirations.
View example
Close
Volatility
Can you tolerate the ups and downs of this portfolio without reacting?
What it measures:
How much your portfolio will swing year-to-year—and whether you can stomach it without panic-selling.
How to calculate it:
  • This requires a bit of matrix math, but the formula is:
  • Portfolio Volatility = √(w₁²σ₁² + w₂²σ₂² + 2w₁w₂ρ₁₂σ₁σ₂ + ...)
However, this doesn’t account for correlations among investments.

A portfolio's risk comes down to three things: how volatile each investment type is on its own, what percentage of the portfolio each one makes up, and how much they tend to move up or down together (correlation).

You can do this in a spreadsheet with the help of an AI tool, or you can use our free portfolio analysis calculator
Asset Class
Allocation
Volatility
Weighted Vol
US Stocks
40%
15%
6.0%
International
15%
16%
2.4%
Bonds
30%
5%
1.5%
Real Estate
10%
18%
1.8%
Cash
5%
1%
0.05%
Simple Sum
11.75%
Diversification Discount (15%)
-1.75%
What research says:
The Capital Asset Pricing Model (CAPM), developed by Markowitz and Sharpe, shows that portfolio risk is not just the weighted average of component risks—it depends on correlation structure. This is why diversification works: low-correlation assets reduce portfolio volatility more than their individual volatility would suggest.
Is your number good?
  • Historical context: US stock market volatility averages 15–18%. Bond volatility averages 4–6%.
  • The key question: In a year when this portfolio drops 15%, can you hold steady or will you panic-sell?
    • If the answer is "I'd panic," your allocation is not good for you, no matter how good the expected return looks.
    • This is why many investment advisors have you complete a risk assessment to understand your risk tolerance
  • As a guideline
    • A 10% volatility portfolio is moderate to aggressive. You can expect occasional down years of −15% to −20%.
    • A 6–8% volatility portfolio is balanced. Down years might be −8% to −12%.
    • A 4–5% volatility portfolio is conservative. Down years might be −5% to −8%.
Disclaimer: These estimates are based on general market data. This is not a guarantee of the maximum loss that an individual investor might experience. Investment carries with it the risk of loss of principal.
View example
Close
Sharpe Ratio
Are You Being Compensated for Risk?
What it measures:
How much return you're getting per unit of risk you're taking.
How to calculate it:
Sharpe Ratio = (Expected Return − Risk-Free Rate) / Portfolio Volatility
Sharpe Ratio = (5.4% − 5%) / 10% = 0.04
4 Markowitz, H. M. (1952). "Portfolio selection." The Journal of Finance, 7(1), 77-91. Foundational work establishing mean-variance framework and showing that portfolio risk depends on both individual asset volatility AND correlation structure between assets.
What research says:
The Sharpe ratio, developed by William Sharpe, is the standard way to evaluate risk-adjusted performance5. A higher Sharpe ratio means you're getting more return for the risk you're taking. The risk-free rate is the return you expect from the safest investment, typically lending to a very stable government (a short-term US Treasury Bill), representing the minimum return expected when taking no risk at all.
Portfolio Type
Expected Sharpe
Notes
100% Stocks
0.35–0.45
High return, high risk
70/30 (Stocks/Bonds)
0.40–0.50
Typical balanced
60/40
0.40–0.50
Industry standard
50/50
0.35–0.45
More conservative
30/70
0.25–0.35
Conservative
100% Bonds
0.10–0.20
Low return, low risk
Is your number good?
  • A Sharpe ratio above 0.40 is solid—you're getting a reasonable return for the risk.
  • A Sharpe ratio below 0.30 might indicate you could improve your allocation.
  • If your Sharpe ratio is high but your volatility made you uncomfortable during the 2020 COVID crash, your allocation looks good on paper but not for you. Incorporating Treasury bills (T-bills) into your current investment mix without altering existing allocation percentages can be a strategic move. This approach maintains your portfolio's Sharpe ratio while simultaneously lowering your overall risk exposure.
View example
Maximum Drawdown
Can You Handle a Crash?
What it measures:
The worst decline your portfolio suffered in historical data. A realistic worst-case.
How to calculate it:
Look at historical data for your asset classes. Find the biggest peak-to-trough drop. Weight your components accordingly.
Sharpe Ratio = (5.4% − 5%) / 10% = 0.04
5 Sharpe, W. F. (1964). "Capital asset prices: A theory of market equilibrium under conditions of risk." The Journal of Finance, 19(3), 425-442. Introduces the Sharpe ratio as a standardized measure of risk-adjusted returns, now the industry standard for evaluating portfolio efficiency.
Asset Class
Allocation
Max Drawdown (2007–09)
Contribution
US Stocks
40%
-57%
-22.8%
International
15%
-60%
-9.0%
Bonds
30%
-5%
-1.5%
Real Estate
10%
-70%
-7.0%
Cash
5%
0%
0%
Portfolio Max Drawdown
-40.3%
What research says:
Historical analysis of portfolio drawdowns shows that most investors significantly underestimate what they can tolerate. Surveys consistently show people think they can handle 25–30% drawdowns, but panic-sell at 15–20%.
Is your number good?
  • If your max drawdown is −40% and you think "yeah, I can hold that," you're probably being realistic.
  • If your max drawdown is −15% and you're already nervous, that's actually healthy—your allocation matches your true risk tolerance.
  • The key: your actual tolerance should exceed your actual max drawdown, with buffer room.
View example

Join Android Waitlist

Sign up to be notified as soon as Enrich becomes available on Android. Don’t miss early access to smart rebalancing, portfolio insights, and personalized investment.

You're On the Waitlist

You’ll be notified as soon as Enrich is available on Android. Get ready to access smart rebalancing, portfolio insights, and personalized investment tools.
Oops! Something went wrong while submitting the form.

Invest with Confidence. Anywhere. Anytime.

Join 500+ investors already using Enrich Finance to optimize their rebalancing strategy.