Calculate exactly how much to buy or sell in each asset class to bring your portfolio back to target allocation. Includes threshold-based triggers and tax-efficient rebalancing suggestions.
This worksheet includes 4 sections covering everything you need.
Side-by-side comparison of where you are vs where you should be.
| Asset Class | Target % | Current Value | Current % | Drift % | Target Value | Action |
|---|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- | --- |
Specific trades needed to restore target allocation.
| Asset Class | Fund/ETF | Buy/Sell | Dollar Amount | Shares (approx) |
|---|---|---|---|---|
| --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- |
Estimated tax consequences of selling overweight positions.
| Fund/ETF | Sell Amount | Est. Gain/Loss | Short-Term? | Est. Tax Impact |
|---|---|---|---|---|
| --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- |
History of past rebalancing events and outcomes.
| Date | Reason | Trades Made | Notes |
|---|---|---|---|
| --- | --- | --- | --- |
| --- | --- | --- | --- |
Follow these steps to get the most out of this template.
Enter your target asset allocation percentages (they should sum to 100%).
Input the current market value of each asset class in your portfolio.
The worksheet will calculate the drift from target and show which classes are over/under weight.
Review suggested trades — consider rebalancing with new contributions first to minimize selling.
Check the tax impact estimate before executing sells in taxable accounts.
Log the rebalancing event and set a reminder for the next review (quarterly or when drift exceeds 5%).
Investors who maintain a target asset allocation across multiple accounts.
DIY investors who rebalance quarterly or annually.
Anyone whose portfolio has drifted significantly due to market movements.
Financial planners helping clients maintain disciplined allocations.
This template is great for manual tracking, but Clarity automates everything for you. Connect your bank accounts, brokerages, exchanges, and wallets and see real-time data without entering a single number.
Most research supports rebalancing when asset classes drift more than 5% from targets, or on a set schedule (quarterly or semi-annually). More frequent rebalancing increases transaction costs and taxes without significantly improving returns.
First, direct new contributions to underweight asset classes. Second, rebalance within tax-advantaged accounts (IRA, 401k) where there are no tax consequences. Only sell in taxable accounts as a last resort, and harvest losses when possible to offset gains.
Rebalance across your total portfolio. This gives you flexibility to hold tax-efficient assets (stocks) in taxable accounts and tax-inefficient assets (bonds, REITs) in retirement accounts while maintaining your overall target allocation.
Other templates you might find useful.
Investment Portfolio Tracker
Track all your investments in one spreadsheet — stocks, bonds, ETFs, mutual funds, and alternatives. Includes cost basis tracking, gain/loss calculations, asset allocation percentages, and dividend income.
InvestingStock Portfolio Spreadsheet
A focused stock portfolio tracker with detailed per-position tracking, sector allocation, and realized/unrealized gain calculations. Built for active stock pickers who need lot-level detail.
Net WorthNet Worth Tracker
Calculate and track your net worth over time. List all assets (bank accounts, investments, property, crypto) and liabilities (mortgages, student loans, credit cards), then track your net worth month over month to see your financial trajectory.
Clarity connects to your financial accounts and automates what this template does manually. Real-time data, zero data entry, and AI-powered insights.