Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceInvestment TrackingAsset Allocation & Rebalancing Planner

SpreadsheetInvestment TrackingFree

Asset Allocation & Rebalancing Planner

Current holdings against your target mix, drift by asset class and the trades that bring you back.

Shown with sample data

Colour

Asset Allocation & Rebalancing Planner

Current holdings against your target mix, drift by asset class and the trades that bring you back.

Portfolio value
$117,300
Classes out of range
2
Largest drift
9.5%
Current allocation
  • Global equities$75,70065%
  • Bonds$17,40015%
  • Home equities$9,8008%
  • Cash$8,3007%
  • Property$6,1005%

How to use it

  1. 1Set the target share for each asset class so they total 100%.
  2. 2Update each holding’s current value.
  3. 3Read the Trade column: positive means buy, negative means sell.
  4. 4Use new contributions to buy underweight classes before selling anything.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

Keep your portfolio at the risk level you chose. Enter each holding’s value and the target share for its asset class; the planner shows how far each class has drifted and the amount to buy or sell to rebalance, and flags classes outside your tolerance.

Who it’s for

  • Annual or quarterly rebalancing
  • Adding new money to the right place
  • Checking a multi-account portfolio

What’s included

  • Holdings sheet: Each holding and its value.
  • Allocation sheet: Target against current mix.
  • Settings sheet: Your tolerance.

How to use it

  1. 1Set the target share for each asset class so they total 100%.
  2. 2Update each holding’s current value.
  3. 3Read the Trade column: positive means buy, negative means sell.
  4. 4Use new contributions to buy underweight classes before selling anything.
Related searchesasset allocationportfolio rebalancingtarget allocationinvestment mixdiversification

Details

Format
Spreadsheet
Category
Investment Tracking
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetInvestment TrackingFree

Asset Allocation & Rebalancing Planner

Current holdings against your target mix, drift by asset class and the trades that bring you back.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Investment Tracking
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More investment tracking templates

View all
Investment Portfolio Tracker2 sheets

Portfolio value

$74,144

Unrealised gain

$13,013

Total return

21%

Allocation by asset class
51%
  • US stocks
  • International stocks
  • Bonds
  • Real estate
SpreadsheetInvestment Tracking

Investment Portfolio Tracker

Holdings, gains, allocation by asset class and the exact buys and sells to rebalance to your targets.

10 min setupPreview
Dividend Income Tracker3 sheets

Forward annual income

$1,439

Per month

$120

Portfolio yield

2%

Dividends by month
$183.04
$178.14
$172.74
$110.28
$106.08
SepJunMarOctJan
SpreadsheetInvestment Tracking

Dividend Income Tracker

Forward annual income, yield and yield on cost per holding, plus every payment logged by month.

10 min setupPreview
Crypto Portfolio Tracker2 sheets

Portfolio value

$49,891

Unrealised gain

$4,034

Realised gains this year

$1,270

Allocation by coin
48%
  • BTC
  • ETH
  • LINK
  • USDC
SpreadsheetInvestment Tracking

Crypto Portfolio Tracker

Holdings built from your buys, sells and staking rewards, with average cost, unrealised and realised gains, allocation and rebalancing.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ