3.1 – Asset Allocation Spreadsheet: The Metrics and Categories Every Investor Should Track
- Compounding Investor
- Jul 13
- 15 min read
Updated: Jul 20
Most investors know what they own.
Far fewer understand why they own it.
Almost every serious investor tracks their portfolio in a spreadsheet.
They calculate portfolio value.
They monitor gains and losses.
They record individual holdings.
Many also calculate their asset allocation.
Their spreadsheet might tell them that 32% of their portfolio is invested in US equities, 18% in technology, 14% in cash and 8% in healthcare. But surprisingly few investors know whether those percentages are actually good.
More importantly, very few understand why those percentages have changed. Has there been allocation drift because markets moved?
Because they bought more technology stocks?
Because one investment has become too dominant?
Or because their investment decisions no longer reflect the strategy they originally set out to follow?
This is one of the biggest weaknesses in the way private investors monitor their portfolios.
They measure allocation. They do not measure the quality of the decisions creating that allocation.
That distinction matters.
Because successful investing is rarely about finding the perfect allocation.
It is about making consistently good allocation decisions over many years.
In this guide you’ll learn how to build an asset allocation spreadsheet that does far more than display percentages.
You’ll discover which allocation categories actually matter, the metrics Structured Compounders monitor, the common spreadsheet mistakes that quietly reduce decision quality and why understanding what I call the Allocation Decision Gap is one of the biggest steps towards building a repeatable long-term investment process.
Who This Guide Is For
This guide is for investors who:
• track their portfolio using Excel or Google Sheets
• already monitor asset allocation but want deeper insight
• invest across shares, ETFs, funds or multiple asset classes
• want to understand whether their portfolio still reflects their original strategy
• are concerned about concentration risk, allocation drift or overlapping investments
• want to make more consistent long-term allocation decisions rather than reacting to markets
Most importantly…
This guide is for investors who want their spreadsheet to become a decision-making tool rather than simply a record of where their money happens to be invested today.
What You'll Learn | |
The categories every allocation spreadsheet should include | Build a structure that reflects how professional investors review portfolio allocation. |
The metrics that matter most | Understand which measurements genuinely improve allocation decisions and which simply create noise. |
The Allocation Decision Gap | Learn why seeing your allocation is very different from understanding whether it reflects a disciplined investment process. |
The common spreadsheet mistakes investors make | Identify hidden weaknesses that can gradually increase portfolio risk without you noticing. |
How Structured Compounders review allocation | Discover how better investors combine allocation data with repeatable decision-making rather than constantly changing their portfolio. |
Contents
Why Most Asset Allocation Spreadsheets Fail
The Allocation Decision Gap
The Categories Every Investor Should Track
The Metrics Every Investor Should Track
How Good Allocation Decisions Compound
Common Spreadsheet Mistakes Investors Make
Why Allocation Tracking Reveals Your Investor Type
The Behaviour Gap
Real Investor Case Study (Seattle, USA)
What The Review Revealed
The Real Issue
What Changed
Basic Allocation Tracking vs Structured Allocation Tracking
Quick Allocation Audit
Who This Guide Is For
Who This Guide Is Not For
FAQ
Explore The Full Framework
Related Guides
Final Thought
Why Most Asset Allocation Spreadsheets Fail
Search online for an asset allocation spreadsheet and you’ll find hundreds of templates. Most include:
• Current holdings
• Asset class breakdowns
• Sector allocation
• Geographic exposure
Some even include colourful pie charts and automatic rebalancing calculations. On the surface, they appear comprehensive. But many still fail to answer one fundamental question:
Are your allocation decisions actually improving?
A spreadsheet can display perfectly accurate percentages while quietly encouraging poor investment behaviour.
Imagine two investors.
Both have portfolios that are 70% equities and 30% defensive assets.
Both appear perfectly diversified.
Both own global index funds.
Yet the quality of their allocation decisions could not be more different.
Investor A built that allocation deliberately.
They established target ranges.
They understood why each asset class existed.
They reviewed drift quarterly.
Every purchase supported a long-term investment plan.
Investor B arrived at exactly the same allocation almost by accident.
Recent market gains increased their US exposure.
Technology shares gradually became their largest sector.
Several ETFs began holding many of the same companies.
New purchases followed whatever had performed well over the previous twelve months.
Today their portfolios look remarkably similar. The process that created them is completely different. That difference rarely appears inside a traditional spreadsheet.
Most allocation spreadsheets record outcomes.
Very few evaluate the quality of the decisions creating those outcomes.
That is why Structured Compounders treat allocation tracking as more than a pie chart. They use it to understand how every investment decision is gradually reshaping their portfolio.
The Allocation Decision Gap
Most investors know what their portfolio looks like. Far fewer understand why it looks that way.
That distinction is the Allocation Decision Gap.
The graphic below illustrates the difference between simply observing your allocation percentages and understanding the decisions that created them.
Every investment decision changes your portfolio.
A new contribution, dividend reinvestment, strong market performance or an additional purchase gradually reshapes your allocations. Individually these changes appear insignificant. Collectively they can transform the portfolio over time.
Many investors eventually discover they hold more US equities than intended, greater concentration in a handful of companies or multiple funds with overlapping exposure.
Usually there wasn’t a single bad decision. The portfolio simply drifted.
Closing the Allocation Decision Gap changes the questions investors ask.
Instead of asking:
“What percentage do I hold?”
they begin asking:
“Why has that percentage changed?”
That shift transforms allocation tracking from a record of what has happened into a decision-making system that keeps the portfolio aligned with its intended strategy.
Before You Analyse Your Allocation, Understand the Investor Behind It
Most investors believe they understand their portfolio allocation. Few have ever assessed the quality of the decisions that created it.
The Free Investor Assessment goes beyond simple asset allocation to evaluate how you build, review and improve your long-term investment process.
It identifies:
Your Investor Progression Model classification
Hidden weaknesses in your portfolio allocation
Concentration, overlap and allocation drift you may not have recognised
Behavioural patterns affecting long-term decision making
Practical steps towards becoming a Structured Compounder
Only takes 2-minutes • manually reviewed • delivered within 24 hours
The Categories Every Investor Should Track
A good allocation spreadsheet is not built around investments. It is built around decisions. The categories you monitor determine the questions you are able to answer.
Most investors stop after recording asset classes.
That is only the beginning.
Structured Compounders review allocation across multiple dimensions because every category reveals a different source of portfolio risk.
The diagram below illustrates what a well-designed allocation spreadsheet should normally include.
Each category tells a different story.
Together they create something much more valuable than a list of percentages. They reveal how your investment decisions accumulate over time.
The Metrics Every Investor Should Track
Once the categories are established, the next question becomes:
Which metrics actually improve investment decisions?
Many spreadsheets calculate dozens of statistics. Most add little value.
Structured Compounders focus on a relatively small number of measurements that consistently improve decision quality.
These include:
Metric | Why It Matters |
Allocation % | Shows how capital is currently distributed. |
Creates an objective benchmark for future decisions. | |
Allocation Drift | Identifies where market movements have changed portfolio balance. |
Highlights growing concentration risk. | |
Measures dependency on relatively few investments. | |
Geographic Exposure | Prevents excessive home bias or unintended country concentration. |
Sector Exposure | Reveals hidden thematic risk. |
Identifies duplicate underlying holdings across multiple funds. | |
Cash Allocation | Measures flexibility for future opportunities. |
Allows comparison against an intended portfolio strategy. |
Notice that none of these metrics attempt to predict future returns. Their purpose is much simpler.
They improve future decisions.
Better measurement leads to better judgement.
Better judgement gradually produces better portfolios.
How Good Allocation Decisions Compound
Compounding is usually discussed in financial terms.
Returns compound.
Dividends compound.
Investment gains compound.
But decisions compound as well.
Every allocation decision influences the next one. A disciplined review today makes tomorrow’s investment slightly better. That better investment slightly improves next year’s allocation. Which improves the decisions made after that.
Over twenty years those improvements become significant.
The opposite is equally true. Small behavioural mistakes also compound.
Ignoring concentration once makes it easier to ignore it again. Buying another technology ETF feels harmless. Allowing one holding to reach 12% feels manageable.
Then 15%.
Then 18%.
No single decision appears dangerous. Collectively they reshape the portfolio.
Structured Compounders understand that exceptional portfolios are rarely created by exceptional predictions.
They are created by thousands of consistently good allocation decisions made over many years.
That is why they review the process. Not simply the outcome.
Common Spreadsheet Mistakes Investors Make
Many allocation spreadsheets appear sophisticated. Yet they quietly encourage poor investment decisions. Some of the most common mistakes include:
Mistake | Why It Matters |
Tracking percentages without targets | There is no objective basis for deciding whether allocation is appropriate. |
Ignoring allocation drift | Market movements gradually change portfolio concentration risk. |
Measuring funds but not underlying holdings | ETF overlap remains hidden. |
Focusing only on asset classes | Sector and geographical concentration develop unnoticed. |
Never reviewing allocation | Decisions become reactive rather than intentional. |
Measuring current allocation only | Investors cannot understand how decisions have changed the portfolio over time. |
Treating rebalancing as automatic | Every rebalance should reflect strategy, not arbitrary percentages. |
None of these problems are difficult to solve. The difficult part is recognising they exist.
Many investors continue improving spreadsheets that were never designed to improve investment decisions.
Why Allocation Tracking Reveals Your Investor Type
Many investors only discover allocation problems after years of investing, when they realise their portfolio has gradually drifted away from what they originally intended.
The Free Investor Assessment helps identify the hidden patterns that shape your allocation decisions, including:
Unintentional concentration in individual holdings
Asset allocation drift developing over time
Hidden overlap between ETFs and funds
Home bias and geographic concentration
Sector exposure that has quietly increased
Decisions driven by recent performance rather than a long-term strategy
A lack of clearly defined allocation targets
In just two minutes, you’ll discover where you currently sit on the Investor Progression Model and receive a personalised review highlighting practical opportunities to build a more structured portfolio.
Because the percentages in your spreadsheet only tell part of the story.
Understanding why your portfolio looks the way it does is what helps you become a better investor.
Start the Free Portfolio Assessment to see what your portfolio review could reveal.
Only takes 2-minutes • manually reviewed • delivered within 24 hours
One of the biggest differences between investor types is not what they own. It is how they think about allocation.
The way investors review their portfolio often reveals where they sit on the Investor Progression Model.
Investor Type | How They Track Portfolio Returns |
Notices allocation only after major market movements. | |
Owns a reasonable allocation but rarely understands how it developed. | |
Reviews allocation periodically and controls obvious concentration risks. | |
Uses allocation as part of a documented investment system that guides every future decision. |
Notice that progression is not about creating increasingly complicated spreadsheets. It is about asking better questions.
Reactive Investors ask: “What has gone up?”
Lucky Investors ask: “What percentage do I own?”
Conservative Compounders ask: “Should I rebalance?”
Structured Compounders ask: “Does every allocation decision move my portfolio closer to the investment system I am trying to build?”
That final question changes everything. Because successful portfolios are rarely built by one perfect decision.
They are built through hundreds of good decisions that reinforce one another over decades.
The Behaviour Gap
Many investors believe allocation problems arise because they lack information. Usually they have plenty of information.
They know which sectors have performed best.
They know which ETFs are popular.
They know the latest market news.
The problem is rarely knowledge. It is behaviour.
Markets reward recent winners. Human psychology encourages familiarity. Media attention naturally concentrates on whatever has performed best.
Together these influences create a powerful temptation to abandon disciplined allocation.
This is what creates the Behaviour Gap. The gap between:
Knowing what your long-term allocation should be
and
Making decisions that consistently support it.
The strongest investors reduce this gap by removing as much emotion from allocation decisions as possible.
They define target ranges.
They monitor objective metrics.
They review portfolios on a structured timetable.
They document significant investment decisions.
Most importantly, they allow their spreadsheet to challenge their behaviour rather than simply confirm it. Because an allocation spreadsheet should not merely tell you where your portfolio is today.
It should help ensure that every decision you make moves your portfolio towards where it ought to be.
Real Investor Case Study (Seattle, USA 🇺🇸): The Portfolio That Was More Concentrated Than The Spreadsheet Showed
A Seattle investor had spent almost twelve years building what appeared to be a broadly diversified portfolio. They worked in the technology sector.
Their investments were spread across:
• a 401(k)
• a taxable brokerage account
• a Roth IRA
• vested employer shares
• broad US index ETFs
• international equity funds
• a municipal bond fund
• cash reserves
The spreadsheet looked organised.
Every account had its own worksheet.
Every holding had a current value.
The overall portfolio exceeded $1.1 million.
At first glance, the allocation appeared sensible:
• 72% equities
• 18% bonds
• 10% cash
No single brokerage account looked dangerously concentrated. The taxable account contained a mixture of ETFs and individual shares.
The 401(k) held several diversified funds.
The Roth IRA contained long-term growth investments.
Employer shares were tracked separately.
That final detail created the problem.
The investor treated each account as a separate portfolio. They had never combined the underlying exposures across all accounts. As a result, the spreadsheet understated how dependent the household had become on one economic engine:
US technology.
The portfolio looked diversified by account. It was concentrated by exposure.
What The Review Revealed
The review did not begin with asset allocation. It began with employment.
The investor’s salary, annual bonus and unvested compensation were all connected to the technology sector.
Their portfolio was then analysed as one economic system rather than five separate accounts. That changed the picture immediately.
The employer shares represented just over 15% of the invested portfolio. That appeared manageable in isolation.
But the same company was also held indirectly through:
• an S&P 500 index fund
• a US growth ETF
• a technology-sector fund
• a large-cap retirement fund
The investor did not own the company once. They owned it through several different routes. The same pattern appeared across other major technology companies.
Microsoft.
Apple.
Nvidia.
Amazon.
Alphabet.
Each appeared inside multiple funds and accounts. Once all underlying holdings were consolidated, the review revealed:
• approximately 43% of the portfolio was exposed to technology
• more than half of the portfolio was concentrated in the ten largest underlying companies
• employer shares were only one part of the employer-related risk
• the household’s income and investment capital were both highly sensitive to the same sector
• international equities represented only 11% of the total portfolio
• most new contributions had been directed into funds that reinforced existing underlying exposures
The investor had not been careless. They had followed familiar advice.
Maximise the 401(k).
Hold broad index funds.
Retain some employer shares.
Use tax-efficient accounts.
Maintain cash and bonds.
Every decision appeared reasonable on its own. The problem only became visible when those decisions were viewed together.
What Would Your Portfolio Reveal?
The Seattle investor’s spreadsheet wasn’t wrong. It simply wasn’t measuring the exposures that mattered most. Many investors already track:
Portfolio value
Asset allocation
Individual holdings
Account balances
Monthly performance
Far fewer track:
Total exposure across every account
Sector concentration
Allocation drift
Employer dependency
The quality of each allocation decision
Your spreadsheet may already contain all the data you need. It may simply be measuring your investments instead of measuring your investment decisions.
The Free Investor Assessment helps identify hidden concentration, allocation drift and behavioural blind spots that many investors never realise they have.
Only takes 2-minutes • manually reviewed • delivered within 24 hours
The Real Issue
The real issue was not that the investor worked in technology.
It was not that they owned employer shares.
It was not that broad US index funds contained large technology companies.
The real issue was that the spreadsheet had no concept of household-wide exposure.
Each account was measured independently.
The 401(k) had its own allocation.
The Roth IRA had another.
The taxable account had another.
Employer shares sat in a separate section. No single worksheet looked alarming. But investment risk does not respect spreadsheet tabs. A fall in the technology sector would affect:
• the investor’s employer
• their annual compensation
• the value of employer shares
• the largest holdings inside several ETFs
• the growth allocation inside the retirement portfolio
The accounts were separate.
The risk was connected.
This created a more subtle version of the Allocation Decision Gap. The difference between:
knowing what sits inside each account
and
understanding what the entire financial system depends upon.
The investor had built an account structure. They had not yet built a portfolio structure. That distinction mattered far more than the number of funds they owned.
What Changed
The investor did not overhaul the portfolio. Instead, they changed how it was measured. The spreadsheet was rebuilt around the combined household portfolio rather than separate accounts.
It now tracked:
• total technology exposure across every account
• direct and indirect employer exposure
• overlapping holdings inside ETFs and retirement funds
• portfolio-wide allocation targets
• the effect of each new contribution on overall concentration
Future investments were then directed towards underrepresented areas rather than reinforcing existing exposure.
The portfolio changed gradually.
The decision process changed immediately.
Basic Allocation Tracking vs Structured Allocation Tracking
Basic Allocation Tracking | Structured Allocation Tracking |
Reviews each account separately | Reviews the total portfolio as one system |
Categorises funds by product name | Measures the underlying holdings and exposures |
Tracks direct employer shares | Measures total employer dependency |
Assumes broad funds create diversification | Tests whether funds duplicate existing exposure |
Sets targets within individual accounts | Sets targets across the complete portfolio |
Measures the number of holdings | Measures what the portfolio economically depends upon |
Uses new contributions without checking total exposure | Directs new capital towards identified allocation gaps |
Treats each investment decision independently | Measures how every decision affects the whole portfolio |
Records portfolio structure | Manages portfolio structure |
Quick Allocation Audit
Ask yourself:
✓ Do you review all accounts as one portfolio?
✓ Do you know your largest underlying holdings?
✓ Have you measured exposure to the sector in which you work?
✓ Do your ETFs duplicate companies you already own?
✓ Are allocation targets set across the whole portfolio?
✓ Do new contributions reduce concentration or increase it?
If several answers are No, your portfolio may be less diversified than your spreadsheet suggests.
Structured Compounders do not simply count accounts or holdings.
They measure what their financial future actually depends upon.
Who This Guide Is For
This guide is for investors who:
already track their portfolio in Excel or Google Sheets
want to improve their asset allocation decisions rather than simply record them
invest across shares, ETFs, funds or multiple accounts
are concerned about concentration, allocation drift or ETF overlap
want a more structured, repeatable investment process
Who This Guide Is NOT For
This guide is not for investors who:
buy and sell purely on short-term market movements
have no interest in tracking portfolio allocation
are looking for stock picks or market predictions
believe successful investing is simply about finding the next winning investment
Discover What Your Asset Allocation Isn’t Telling You
Most investors already track their portfolio allocation. They know:
Asset class percentages
Sector exposure
Geographic allocation
Individual holdings
Yet many still cannot answer some of the most important questions about their portfolio.
Is my allocation becoming more concentrated over time?
Have my investment decisions improved my portfolio or simply changed it?
Am I duplicating the same holdings across multiple funds?
Does my portfolio still reflect the strategy I originally intended?
Am I investing like a Structured Compounder?
Your spreadsheet may already contain all the numbers you need. But percentages alone do not create better investment decisions.
The Free Investor Assessment helps identify:
hidden concentration and allocation drift
ETF overlap and diversification blind spots
weaknesses in your portfolio review process
your Investor Progression Model classification
practical steps towards becoming a Structured Compounder
Because measuring your allocation is only the beginning.
Understanding what your allocation reveals about your investment decisions is what helps build a stronger portfolio.
Takes Less Than 2-Minutes
FAQ
How often should I review my asset allocation?
For most long-term investors, a quarterly review is sufficient. More frequent reviews often encourage unnecessary changes rather than better decisions.
Should I rebalance every time my allocation changes?
Not necessarily. Small changes are a natural consequence of market movements. Rebalancing should support your investment strategy, not react to every fluctuation.
Is an Excel spreadsheet enough for tracking allocation?
Yes—provided it measures the right categories and metrics. The quality of the information is far more important than the software itself.
Why isn’t asset allocation alone enough?
Allocation percentages show where your portfolio is today. They do not explain whether the decisions creating those percentages are strengthening or weakening your long-term strategy.
What is the Allocation Decision Gap?
It is the difference between knowing what your portfolio looks like and understanding whether it still reflects a disciplined investment process.
Explore The Full Framework
The Investor Progression Model White Paper |
This guide forms part of the Compounding Investor Progression Model—a framework designed to help investors move from reactive decision-making towards a repeatable, structured investment process. Inside the white paper you’ll discover: ✓ The four investor types ✓ Why most investors plateau ✓ The five dimensions of investor progression ✓ How Structured Compounders build repeatable systems ✓ The research behind the Investor Assessment |
⬇ READ THE WHITE PAPER ⬇ |
Related Articles
Continue Building Your Portfolio Tracking System
Build a complete Excel portfolio tracker from scratch and understand why effective portfolio tracking is the foundation of better long-term investment decisions.
Understand why measuring investment performance is about far more than checking whether your portfolio has increased in value. Learn how proper performance measurement supports better portfolio decisions.
10.0 – Portfolio Health Check: What Most Investors Miss
Use a structured portfolio review to identify hidden allocation drift, concentration risk, ETF overlap and weaknesses in your investment process before they affect long-term compounding.
Discover how your investment decisions shape your portfolio over time, and why reviewing behaviour can be just as valuable as reviewing returns or asset allocation.
Final Thought
Most investors believe an asset allocation spreadsheet exists to record percentages. Structured Compounders use it for something much more valuable.
They use it to improve decisions. Every investment you make changes the shape of your portfolio.
Some decisions strengthen diversification.
Others quietly increase concentration.
Most seem insignificant at the time.
Over years, they compound into a portfolio that either reflects a disciplined investment strategy—or one that has gradually drifted away from it.
The most successful investors don’t necessarily own better investments. They make better allocation decisions, more consistently, over longer periods of time.
Your spreadsheet should help you do exactly that.
Because successful investing isn’t just about knowing what you own.
It’s about understanding why you own it—and ensuring every new decision moves your portfolio in the right direction.
Comments