Templates · Investing
Free Portfolio Rebalancing Worksheet
Figure out exactly what to buy and sell to get your portfolio back on target. This worksheet shows the drift in each asset class and suggests trades, including tax-efficient options so you keep more of your gains.
- Investing
- Worksheet
- Free template
What's included
This worksheet includes 4 sections covering everything you need.
Current vs Target Allocation
A side-by-side look at where your portfolio is vs. where you want it to be.
| Asset Class | Target % | Current Value | Current % | Drift % | Target Value | Action |
|---|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- | --- |
Rebalancing Trades
The specific trades that would bring everything back into line.
| Asset Class | Fund/ETF | Buy/Sell | Dollar Amount | Shares (approx) |
|---|---|---|---|---|
| --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- |
Tax Impact Estimate
A heads-up on the tax bill you might trigger by selling overweight positions.
| Fund/ETF | Sell Amount | Est. Gain/Loss | Short-Term? | Est. Tax Impact |
|---|---|---|---|---|
| --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- |
Rebalancing Log
A record of past rebalancing events so you can see your history.
| Date | Reason | Trades Made | Notes |
|---|---|---|---|
| --- | --- | --- | --- |
| --- | --- | --- | --- |
How to use this template
Follow these steps to get the most out of this template.
- 1
Enter your target asset allocation percentages (they should add up to 100%).
- 2
Plug in the current market value of each asset class.
- 3
The worksheet shows the drift and flags which classes are over or under weight.
- 4
Look at the suggested trades — try rebalancing with new contributions first to avoid selling.
- 5
Check the tax impact estimate before selling anything in taxable accounts.
- 6
Log the rebalancing event and set a reminder for next time (quarterly or when drift passes 5%).
Who this template is for
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.
Why use Clarity instead?
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.
- Automatic transaction imports from 12,000+ institutions
- Real-time portfolio values and net worth tracking
- AI-powered spending insights and budget recommendations
- Tax-ready reports with automatic cost basis calculations
- One dashboard for banks, brokerages, crypto, and DeFi
Frequently Asked Questions
How often should I rebalance my portfolio?
Rebalance when any asset class drifts more than 5% from target, or on a set schedule like quarterly or semi-annually. Doing it more often just racks up transaction costs and taxes without meaningfully improving returns.
What is the most tax-efficient way to rebalance?
Start by directing new contributions to the underweight classes. Next, rebalance inside tax-advantaged accounts (IRA, 401k) where there is no tax hit. Only sell in taxable accounts as a last resort, and harvest losses when you can to offset gains.
Should I rebalance across all accounts or within each account?
Across your total portfolio. That gives you the flexibility to hold tax-efficient stuff (stocks) in taxable accounts and tax-inefficient stuff (bonds, REITs) in retirement accounts — while still hitting your overall targets.
Related templates
Other templates you might find useful.
Investment Portfolio Tracker
See all your investments in one place — stocks, bonds, ETFs, mutual funds, the works. Track your cost basis, see how much you have gained or lost, check your asset allocation, and keep tabs on dividend income.
InvestingStock Portfolio Spreadsheet
A stock tracker for people who pick their own companies. Get detailed per-position tracking, sector allocation breakdowns, and realized vs. unrealized gain calculations — all the way down to lot-level detail.
Net WorthNet Worth Tracker
Find out what you are actually worth financially. List everything you own (bank accounts, investments, property, crypto) and everything you owe (mortgages, student loans, credit cards), then watch your net worth change month over month.
Ready to go beyond spreadsheets?
Clarity connects to your financial accounts and automates what this template does manually. Real-time data, zero data entry, and AI-powered insights.