Skip to content
The title slide and first slides of the Investment Portfolio Tracker template

Investment Portfolio Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Style
Modern
Difficulty
Beginner
Updated
November 6, 2026

Every slide (4)

Overview

This template keeps a record of your investment funds. The Holdings tab lists each fund with its asset class, the units you own, what you paid and today's price, and works out the value, gain or loss and return.

The Contributions tab logs the payments you make into each fund. The Dashboard shows the money invested, the value now and the overall return, with a pie chart of how the portfolio is spread across shares, bonds, property and cash.

It comes with sample data. Make a copy, then replace the sample funds and prices with your own. Formulas and charts update on their own, and the template does not give investment advice.

Useful for

  • Checking the value of a portfolio once a month
  • Seeing how much of your money sits in shares, bonds or cash
  • Keeping a record of regular contributions for a tax return or review

What's included

  • 4 tabs: Dashboard, Holdings, Contributions, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Holdings: a table
  • Contributions: a table
  • 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

Is this Investment Portfolio Tracker template free?

Yes. Download the template and use it in Google Sheets or Excel at no cost.

Does it work in Excel?

Yes. Download the .xlsx file to open it in Excel. The formulas and charts work in both Excel and Google Sheets.

Does the template include fees and tax?

No. The cost and value are the figures you type in. If you want fees or tax in the gain, include them in the cost paid.

  • #net-worth
  • #investment-portfolio-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…