Skip to content
The title slide and first slides of the Asset Allocation Tracker template

Asset Allocation Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 16, 2026

Every slide (5)

Overview

Enter each fund or account on the Holdings tab with its asset class and value. On Targets, give every class a target share and an allowed drift, which is how far it can stray before you act. The sheet works out the value and share now, the gap to target in percent points, the dollars to move and an action column reading Buy, Sell or Hold.

The Rebalance tab shows the portfolio total, whether your targets add up to 100 percent, how many classes need action and the class furthest above target, with a chart of actual against target shares. In the sample, US stocks sit 6 points over and bonds 5 under, so those two flag. The targets are yours to set; the sheet only measures against them.

Useful for

  • Check each quarter whether stocks have outgrown their target
  • Decide where new money should go before selling anything
  • See the whole mix across brokerage and retirement accounts

What's included

  • 4 tabs: Holdings, Targets, Rebalance, How to use
  • Holdings: a table with 2 summary figures
  • Targets: a table
  • Rebalance: a dashboard with 5 summary figures
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Holdings tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What is asset allocation?

It is how your money is split between types of investments such as stocks, bonds, real estate and cash. Your target split depends on your goals and comfort with risk.

How frequently should an asset mix be reviewed?

Many investors review once or twice a year, or when a class drifts past a set band. The Allowed drift column lets you define that band for each class.

What does drift mean in a portfolio?

Drift is the difference between a class share today and its target. Growth in one class raises its share and lowers the others even if you add nothing.

  • #investment-tracker
  • #asset-allocation-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More investment tracker templates

See all 14

Also in Finance

All finance templates
Get this template

Preparing your template…