How to Clean Up a Messy Portfolio: A 7-Step Audit You Can Finish in an Afternoon

Almost nobody designs a bad portfolio. They accumulate one — a fund here, a hot stock there, an old account at a bank they no longer use. Here's how to fix it without creating a tax bill you didn't need.

Nobody sits down and designs a portfolio with four overlapping S&P 500 funds, a meme stock from 2021, an old employer plan at a bank they left, and $6,000 sitting in cash earning nothing.

Portfolios do not get designed. They accumulate. A fund here because someone recommended it. A stock there because it was in the news. An account that never got moved. Five years later you own eighteen things and could not explain the logic behind any of them.

Here is a seven-step process to fix it. Most people can finish it in an afternoon.

Step 1: Get everything on one page

You cannot audit what you cannot see.

Open every account — brokerage, workplace plan, robo-advisor, that old bank RRSP — and build a single list with four columns:

Account | Holding | Current value | % of total

Do it in a spreadsheet or on paper. Include cash balances; they count.

This step alone resolves a surprising amount. People routinely discover they own considerably more of something than they thought, or that a "small" speculative position has quietly become 15% of the portfolio.

Step 2: Find the overlap

This is the most common problem and the least visible.

For each fund, look at the index it tracks and its top ten holdings. If two funds share most of their largest positions, you own one exposure twice.

Common overlaps:

• VOO and VTI — roughly 85% the same. VTI adds mid and small caps, which are a small weight.
• VOO/VTI and QQQ — QQQ is Nasdaq-100, dominated by the same mega-cap technology names already at the top of any total market fund.
• A total-market fund and a sector technology fund — you are overweighting a sector you already own heavily.
• An all-in-one asset allocation fund plus individual ETFs — the all-in-one fund is already a complete portfolio; adding to it undoes its allocation.

Three tickers is not three exposures. Owning VOO, VTI and QQQ together means your portfolio is roughly a leveraged bet on US mega-cap technology, described to yourself as diversification.

Step 3: Ask one question about every holding

For each position: "If I had cash today, would I buy this at this price?"

If the answer is no, the only reasons to keep it are tax cost or transaction friction — not the fact that you already own it.

This is where sunk cost shows up. "I'm down 40%, I'll sell when it gets back to even" is not a strategy. The market does not know your purchase price. A holding you would not buy today is a holding you are choosing to buy again, every day, by not selling.

Be honest about the ones you cannot justify. Most cleaned-up portfolios have two or three positions in this category, and they are usually the ones bought in the most excited market conditions.

Step 4: Do the registered accounts first — they are free

This is the sequencing insight that makes the whole exercise cheaper.

Inside a TFSA, RRSP, IRA or 401(k), selling has no tax consequence. None. You can sell every position, buy exactly what you want, and there is no tax bill and nothing to report.

So clean these accounts first, and completely. There is no reason to hold a fund you do not want inside a registered account — the only cost is the bid-ask spread.

Then use your registered accounts to do the heavy lifting of getting your overall allocation right, which reduces how much you need to change in the taxable account.

Step 5: Be surgical in taxable accounts

Here selling has a cost, so the rules change.

In Canada: 50% of a realised capital gain is included in taxable income at your marginal rate. On a $10,000 gain at a 40% marginal rate, roughly $2,000 in tax.

In the US: long-term gains (held over a year) are taxed at preferential rates; short-term gains at ordinary income rates.

A practical approach:

Sell losers first. A realised capital loss offsets realised gains. If you have positions you want to exit at a loss, that loss reduces the tax on positions you exit at a gain — cleanup can be close to tax-neutral if you pair them.

Watch the 30-day rule. Canada's superficial loss rule and the US wash sale rule both deny a capital loss if you buy a substantially identical security within 30 days before or after the sale. This catches people who sell VOO to harvest a loss and immediately buy it back. Buying a different fund tracking a different index is generally acceptable; buying the same thing is not. Note that in Canada the rule extends to purchases by your spouse or a corporation you control.

Leave large embedded gains alone if the holding is reasonable. A total-market ETF with a large unrealised gain does not need to be sold to buy a marginally cheaper one. Paying tax today to save 0.02% a year is a bad trade.

Stop the bleeding at the source. If a taxable account is receiving new contributions, redirect new money to what you actually want. Fixing the flow is free; fixing the stock costs tax.

Step 6: Consolidate accounts

Three accounts at three institutions is how allocations drift out of alignment without anyone noticing. It also multiplies statements, tax slips and logins.

Transfers move holdings in kind — the actual securities move, nothing is sold, no tax is triggered — and the receiving broker usually reimburses the transfer-out fee.

One critical warning for registered accounts: always use a direct institution-to-institution transfer. Never withdraw and re-deposit. A TFSA withdrawal does not restore contribution room until January 1 of the following year, and re-depositing in the same year creates an overcontribution penalised at 1% per month.

Step 7: Deal with the cash

Uninvested cash is the most commonly ignored line in a portfolio audit.

Two questions:

Is it there on purpose? An emergency fund or money for a known near-term expense belongs in cash. Money that is there because you never got around to investing it does not.

What is it earning? This is the part that surprises people. Some brokers sweep uninvested cash to money market funds yielding roughly 4%+. Others default to bank sweeps paying well under 1%. On $20,000, that gap is several hundred dollars a year for doing nothing differently.

Check your broker's default sweep rate. If it is low, most brokers let you buy a money market fund manually in about a minute.

What "clean" actually looks like

You are not aiming for zero holdings. You are aiming for a portfolio you can explain.

A finished cleanup usually looks like:

• One to four funds covering your intended asset allocation
• A written target allocation — "70% equities, 30% bonds," and within equities, a rough domestic/international split
• All accounts visible in one place, with the total allocation known
• Cash that is there on purpose, earning a competitive rate
• Any speculative positions deliberately sized, ideally in a taxable account where losses are deductible

Then set a calendar reminder for six or twelve months to rebalance back to target. Rebalancing is what stops the drift from starting again — a 60/40 portfolio can become 75/25 after a strong equity run, which means you are carrying meaningfully more risk than you chose.

The mistake to avoid

Do not clean up during a market panic.

The urge to "simplify" tends to spike exactly when markets are falling, and what feels like organisation is often selling. If you are doing this in the middle of a drawdown, write the plan down first, wait a week, and then execute it. A portfolio audit is a structural exercise. It should look the same whether the market went up or down that morning.

Frequently asked questions