Mid-Year Portfolio Rebalancing Dashboard Excel: June 2026 Drift Heatmap and Trade List

Mid-year portfolio rebalancing dashboard excel - if you have ever opened your brokerage account in June, looked at how far the tech sleeve has run, and thought "I need to rebalance, but I do not have a clean way to see the trade list," this is the template for that. A simple spreadsheet shows current weights. A rebalancing dashboard shows current versus target, the drift between them, which positions are out of band, what each trade should be in dollars and shares, and how the picture changes if you widen or tighten your tolerance band. This guide ships a premium, dashboard-style Excel template that does all of that in one place, with KPI tiles, embedded charts, a drift heatmap, glide path comparison, sector exposure, and a tax-aware sleeve that helps you route trades through the lowest-tax account first.

The template is built to look like a professional-grade dashboard product, not a plain spreadsheet. Eleven sheets, branded cover page, frozen panes, conditional formatting, dropdown form controls, and live MarketXLS formulas wired through every metric. Download both the static sample (with formula references shown as cell comments) and the live MarketXLS formula version at the end of this post.

Mid-year rebalancing at a glance - the quick reference

Before going further, the single most useful table in the entire rebalancing toolkit, illustrating what a drift heatmap actually surfaces:

Three things jump out. First, communications services has run the most relative to target (META and GOOGL are both more than 2 percent over weight). Second, healthcare is almost perfectly aligned with target and needs no trade. Third, cash is materially below target, which the rebalance trade list automatically refills with sell proceeds. The dashboard surfaces all of this without you computing a single weight by hand.

What is portfolio rebalancing, and why a dashboard

Portfolio rebalancing is the act of buying and selling positions to return a portfolio to its target weights. You set a strategic allocation (a "policy") - say 8 percent each in AAPL, MSFT, and NVDA, 5 percent in GOOGL, 5 percent cash buffer, and so on - and rebalance to that policy on a schedule (quarterly, semi-annually, annually) or when positions drift past a tolerance band.

Three reasons every long-term investor cares about rebalancing:

1. It enforces a sell-high, buy-low discipline mechanically. Without rebalancing, winners run and losers shrink as a share of the portfolio. With rebalancing, you trim what has outrun target and add to what has lagged, regardless of how you feel about either side. The discipline is the value, not the prediction.
2. It controls risk drift. A portfolio that started at 60 percent equity and 40 percent bonds in January will not be 60/40 in June if equities have moved 8 percent and bonds have moved 1 percent. Without rebalancing, the portfolio quietly takes on more risk than the policy intends.
3. It surfaces concentration creep. A single winner that has compounded for two years can become 12 to 15 percent of a portfolio that was supposed to cap any one position at 8 percent. The dashboard makes that visible the moment you open it.

The catch is that rebalancing is hard to do well without a tool because it depends on three numbers at once (current weight, target weight, the drift between them) and on a fourth implicit number (your tolerance band) that decides whether to trade at all. A mid-year portfolio rebalancing dashboard fixes that. Plug your shares, cost basis, and target weights into the Holdings sheet; the rest of the workbook recomputes drift per holding, total absolute drift, the trade list in dollars and shares, sector exposure, glide path comparisons, and a tax-aware routing aid.

Why mid-year - the case for a June 2026 review

Rebalancing schedules vary. Some advisors run a calendar approach (end of every quarter), some run a tolerance approach (rebalance only when a position exceeds the drift band), and some run a hybrid. June has earned a place in the calendar version for four practical reasons:

• Halfway through the tax year. Capital gains realized in January through June can be paired with potential losses identified in July through December. Surfacing them now gives you time to plan, not react in the last week of the year.
• Earnings season is over and dividends are confirmed. Q1 earnings reports through May give you a fresh fundamentals read, and dividend declarations for Q2 are largely visible. Your risk and quality screen reflects current operating reality, not stale numbers.
• Russell reconstitution is two weeks away. The annual reconstitution in late June can move small-cap and mid-cap weights in passive funds. Rebalancing before reconstitution gives you a clean view of where you stand without index-flow noise.
• It is far enough from year-end to avoid window-dressing pressure. Trading in December often runs into bid-ask spread widening, tax-driven sell pressure, and thin liquidity. June trading is quieter and more orderly.

The mid-year review is not a market timing exercise. It is a discipline exercise. You are asking "did weights drift outside my comfort band?" not "should I sell because the market is high?" The dashboard answers the first question and stays silent on the second.

The mechanics - drift, tolerance, and trade triggers

Every rebalance computation reduces to four numbers per holding:

• Current weight = position market value / total portfolio value
• Target weight = policy weight you set in the Holdings sheet
• Drift = current weight - target weight
• Absolute drift = |drift|

The dashboard then applies your drift tolerance (a single global input, default 1.0 percent) to bucket each holding:

• Hold: absolute drift is less than or equal to the tolerance. No trade.
• Buy or Sell: absolute drift is between 1x and 2x the tolerance. A modest, deliberate trade.
• Add or Trim: absolute drift is more than 2x the tolerance. A material trade to bring weight back to target.

Trade size for each holding is straightforward: trade dollar = (target - current) * total portfolio value. A negative trade dollar means sell; a positive trade dollar means buy. Trade shares = trade dollar / current price, rounded to whole shares if your broker requires whole shares (or kept fractional if your broker supports fractional trading - both are dropdown options on the Holdings sheet).

The cash row is treated like a regular position with its own target weight. Sells fund cash; buys deplete cash. The dashboard reports the cash weight against target so you can see whether the rebalance restores your cash buffer or leaves it stretched.

What is inside the template

The premium template ships with eleven sheets, each color-coded with a tab color, with frozen panes and conditional formatting tuned for the role of the sheet:

1. Cover - branded title page with version, data-as-of date, MarketXLS branding, and a table of contents.
2. How To Use - step-by-step tutorial. Walks you from typing in your first ticker through reading the trade list.
3. Dashboard - the headline sheet. Six KPI tiles across the top (Portfolio Value, YTD Return, Total Abs Drift, Out of Band, Largest Drift, Cash Weight), two embedded bar charts (current vs target, absolute drift), and a 24-row holdings screener with a drift heatmap on the drift column, data bars on the absolute drift column, traffic-light icons for trade triggers, and color-coded action cells.
4. Holdings - your inputs live here. Yellow cells for shares, cost basis per share, target weight, drift tolerance, glide path mode, lot rounding, cash balance, cash target, and account type. Dropdown form controls keep entries valid.
5. Rebalance Trades - the auto-generated buy and sell list. Each row shows the trade dollar, the rounded share count at current price, the action label (Trim, Sell, Hold, Buy, Add), and a short routing note. Totals at the bottom: total buy dollars and total sell dollars.
6. Scenario Glide Paths - three rebalance bands compared side by side. Conservative (0.5 percent), Balanced (1.0 percent), Aggressive (2.5 percent). For each band: trades triggered, average trade size, cash used, and a one-paragraph fit guide.
7. Sector Exposure - aggregate current and target weight by GICS sector. Gap column flags sector overweights and underweights with conditional formatting. Two pie charts (current vs target) make the contrast obvious.
8. Risk and Quality - per-holding screen on beta, three-month volatility, P/E, ROE, dividend yield, market cap, and YTD return. Use it to break ties: when two positions are equally drifted, this sheet helps you decide which to trim first.
9. Tax-Aware Sleeve - per-position unrealized gain/loss view. Embedded gains greater than 50 percent are flagged for tax-advantaged accounts. Embedded losses are flagged as tax-loss harvest candidates.
10. Methodology - definitions, the trade trigger logic, glide path logic, data sources, and the explicit limits of the model.
11. Glossary and Disclaimer - plain-English definitions of every term used in the template, plus the educational notice.

That is a deliberately bigger sheet count than the base daily blog template because rebalancing has more moving parts than a single-purpose screener. Each sheet earns its place by surfacing one decision the dashboard would otherwise hide.

MarketXLS implementation

The template uses real, verified MarketXLS functions throughout. Every price, return, valuation ratio, and risk metric is a live formula in the template file. Below is a representative slice (verified against the MarketXLS function docs):

=QM_Last("AAPL")                       Pending last price (the position's mark-to-market input)
=StockReturnYTD("AAPL","Price")        Year to date total return
=ChangePercentYTD("AAPL")              Year to date percent change (price only)
=Beta("AAPL")                          Beta versus the market
=StockVolatilityThreeMonths("AAPL")    Three-month annualized volatility
=PERatio("AAPL")                       Trailing PE ratio
=ReturnOnEquity("AAPL")                Return on equity (TTM)
=DividendYield("AAPL")                 Trailing twelve-month dividend yield
=MarketCapitalization("AAPL")          Market capitalization
=Sector("AAPL")                        GICS sector classification
=Name("AAPL")                          Company name lookup from a ticker

The drift, trade dollar, action, and trade shares columns are pure Excel formulas that reference the live MarketXLS data above plus the inputs on the Holdings sheet. For example, on the Dashboard sheet for row 11 (the first holding), the formula chain looks like:

F11 = D11 * E11                                            Market value (shares * price)
G11 = F11 / 'Dashboard'!$G$4                               Current weight (market value / portfolio value)
H11 = Holdings!H10                                         Target weight (looked up from Holdings)
I11 = G11 - H11                                            Drift
J11 = ABS(I11)                                             Absolute drift
M11 = (H11 - G11) * 'Dashboard'!$G$4                       Trade dollar
L11 = nested IF on J11 vs Holdings!$C$5/100               Action (Trim, Sell, Hold, Buy, Add)

Change a target weight in the Holdings sheet and the whole workbook reprices: the Dashboard recomputes drift, the Rebalance Trades sheet regenerates the buy/sell list, the Scenario Glide Paths recount trades triggered at each band, and the Sector Exposure recalculates the gap. That is what live formulas buy you that a static spreadsheet cannot.

Reading the dashboard

The Dashboard sheet is built to be read in four passes:

Pass 1 - the KPI row (2 seconds). Look at the six tiles. Portfolio Value tells you the total. YTD Return tells you whether the year has been kind. Total Abs Drift tells you how far the portfolio has wandered from policy. Out of Band tells you how many positions need action. Largest Drift names the single worst offender. Cash Weight tells you whether the buffer needs a refill.

Pass 2 - the absolute drift bar chart (5 seconds). The chart on the right shows which positions are furthest from target. Long bars mean bigger trades. If most bars are short, the portfolio is well-aligned; if a handful are long, you have a targeted rebalance, not a wholesale one.

Pass 3 - the drift heatmap (30 seconds). The drift column on the holdings table uses a red-white-green color scale. Red cells are overweight (sell candidates), green cells are underweight (buy candidates), white cells are aligned. The action column is color-coded too. Run your eye down it and you have the trade list in your head.

Pass 4 - the sector pie pair (1 minute). Flip to the Sector Exposure sheet. Two pie charts (current weight and target weight) make sector-level concentration obvious in a way the holdings table cannot. If technology is much bigger on the current chart than the target chart, the trade list is going to be tech-heavy.

The dashboard does not tell you whether the market is high or low. It tells you whether your portfolio is where you said you wanted it. That is the only question rebalancing answers.

Choosing a glide path

The Scenario Glide Paths sheet exists because there is no single "right" drift tolerance. It depends on three frictions:

• Tax friction. Every sell in a taxable account realizes a gain or loss. A tighter band means more trades, which means more realized gains in a taxable account. A wider band means fewer trades. Tax-advantaged accounts (IRA, 401k, HSA) have no tax friction, so a tighter band is fine.
• Commission friction. Most brokers in 2026 are commission-free on equities, so this is mostly zero, but spread costs and price impact still scale with trade frequency.
• Time horizon. A 30-year investor can ride out larger drifts because the long-run discipline still dominates. A 5-year investor cannot afford weights to wander.

The dashboard runs all three bands simultaneously and tells you the trade count and the cash used for each. A typical observation: Conservative (0.5 percent) triggers roughly twice as many trades as Balanced (1.0 percent), and Aggressive (2.5 percent) triggers fewer than half as many. Pick the band that matches your frictions and your horizon. There is no prize for over-trading.

Tax-aware routing

The Tax-Aware Sleeve sheet exists because sells in a taxable account are not free. The sheet shows each holding's unrealized gain or loss percentage and routes trades through a simple rubric:

• Embedded gain greater than 50 percent in taxable. Sell only in a tax-advantaged account or with an offsetting loss. The capital gains bill in taxable can dwarf the rebalance benefit.
• Embedded gain between 10 and 50 percent in taxable. Trim only if a loss elsewhere offsets the realized gain.
• Near cost basis (within plus or minus 10 percent) in taxable. Free to trade. No material tax friction.
• Embedded loss greater than 10 percent in taxable. Candidate for tax-loss harvest. Sell, then buy a similar (not substantially identical) holding to maintain exposure.

The sheet does not file your taxes for you and does not model holding period, state tax, qualified dividend treatment, or specific lot selection. It is a routing aid, not a tax return. Used as a routing aid, it can meaningfully reduce realized gains in a typical mid-year rebalance.

Download links - mid-year portfolio rebalancing dashboard template

Both files are free to download. The static sample is pre-filled with illustrative values (data as of 2026-05-30) and has every MarketXLS formula attached as a cell comment so you can see what powers each number. The live template is empty of static data - every metric is a MarketXLS formula that updates when you open the file in Excel with the MarketXLS add-in installed.

Download the templates:

• - Pre-filled with current illustrative data and formula comments on every data cell
• - Live-updating formulas, zero static data; edit the yellow input cells and watch the whole dashboard reprice

How to swap in your own portfolio

The template ships with a worked 24-position book as the example. Swap it for your own in three steps:

1. Open the Holdings sheet (the yellow tab). Edit the yellow cells in each row: ticker, share count, cost basis per share, and target weight. Add or delete rows as needed; the Dashboard formulas reference the Holdings sheet by row, so keep the row count consistent or extend the formula range.
2. Set your global inputs. Drift tolerance (cell C5), glide path mode dropdown (C6), lot rounding dropdown (C7), cash balance (F5), cash target weight (F6), and account type (F7).
3. Refresh formulas. With the MarketXLS add-in installed, hit Refresh in the MarketXLS ribbon (or just save and reopen). Every QM_Last, StockReturnYTD, Beta, PERatio, ReturnOnEquity, DividendYield, MarketCapitalization, Sector, and StockVolatilityThreeMonths formula recomputes against the latest market data.

That is the whole loop. Five minutes to swap in your portfolio, five minutes to read the dashboard, then a trade list waiting on the Rebalance Trades sheet.

Frequently asked questions

Is mid-year a better rebalancing date than end of year?

Neither is objectively better. Mid-year has the practical advantage of avoiding December's thin liquidity and tax-driven cross-currents, and it gives you the rest of the calendar year to pair gains with potential losses. End of year has the simplicity of doing everything once. Many advisors run both: a light review in June and a fuller rebalance plus tax-loss harvest in November or December. The dashboard works the same in either month.

How wide should my drift tolerance band be?

A useful default is 1.0 percent (the Balanced glide path). If most of your holdings are in tax-advantaged accounts (IRA, 401k, HSA), tighter is fine - 0.5 percent (Conservative) will trade more often and keep weights tightly aligned. If most of your holdings are in a taxable account with embedded gains, wider is better - 2.5 percent (Aggressive) will trade less and defer realized gains. The Scenario Glide Paths sheet runs all three bands so you can see the trade count tradeoff in one view.

Do I need to rebalance every position when one position drifts?

No. The dashboard only flags positions outside the band. Everything inside the band is labeled Hold and stays untouched. A typical mid-year rebalance might trade 3 to 8 positions in a 24-position book, not all 24.

What happens to cash during a rebalance?

Cash is treated like a regular position with its own target weight. Sells refill cash; buys deplete cash. If the rebalance generates more sell dollars than buy dollars, cash rises above target and the next month's contributions can be deployed into underweights. If buys exceed sells, cash falls below target and you either add new contributions or live with a temporarily depleted buffer until the next rebalance.

Does this template handle bonds, ETFs, and international stocks?

Yes. Any ticker that MarketXLS supports works in the formulas. ETFs (SPY, AGG, VTI, VXUS, BND) and ADRs are pulled the same way as US single stocks. International local listings depend on the exchange coverage in your MarketXLS subscription tier - check the MarketXLS pricing and feature page for the current list of supported exchanges.

How is this different from a robo-advisor's automatic rebalance?

Robo-advisors run their rebalance opaquely, based on their model, with their tolerance bands, on their schedule. This template puts every parameter in front of you: which positions, which targets, which tolerance band, which glide path, which tax routing. It is a transparent, owner-operator alternative for investors who want to understand and override every input.

Can I use this for a 60/40 stocks-and-bonds portfolio?

Yes. Replace the 24 single stocks with two ETF positions (a broad equity ETF for the 60 and a broad bond ETF for the 40) plus cash. The whole dashboard works identically with two holdings or with 200. The KPI tiles, drift heatmap, trade list, and glide paths all scale.

The bottom line

A mid-year portfolio rebalancing dashboard exists for one reason: to take the hardest part of investing (sticking to your plan when the market is making you doubt it) and turn it into a five-minute mechanical check. You set targets when you are calm. You rebalance to those targets when the dashboard tells you to. The discipline is the value, not the prediction.

The premium template ships with KPI tiles, embedded charts, a drift heatmap, a glide path comparator, sector exposure, and a tax-aware sleeve - eleven sheets, every metric live via MarketXLS formulas, branded cover page, frozen panes, conditional formatting. Swap in your portfolio, set your drift tolerance, and you have a one-screen view of every trade your policy is asking you to make.

Build your own at https://marketxls.com or book a demo to see how MarketXLS turns Excel into a real-time portfolio dashboard with thousands of live functions, including the ones used in this template.