Setting Up an Investment Portfolio Tracker in Google Sheets or Excel

A practical guide to building a simple, calm investment portfolio tracker in Google Sheets or Excel. Learn what to record, how to keep it useful, and when to share it for family handovers and financial peace of mind.

6 min readPersonal investment records5 viewsSetting Up an Investment Portfolio Tracker in Google Sheets or Excel
— · 0 votes
Contents
  1. Why keep a portfolio tracker?
  2. What to include in your tracker
  3. Holdings register
  4. Transaction log
  5. How to set it up step by step
  6. Comparing Google Sheets and Excel for a portfolio tracker
  7. How to keep the tracker useful over time
  8. When and how to share the tracker
  9. Connecting the tracker to other important records

An investment portfolio tracker is a single spreadsheet where you record your holdings, transactions, and regular valuations. You can create one in Google Sheets or Microsoft Excel to see your investments clearly, keep your financial records in order, and leave a calm, understandable summary for your family if needed.

Why keep a portfolio tracker?

Investments often sit across different accounts, brokers, and asset types. Without a simple record, it is easy to lose track of what you own, how much you have contributed, and whether your money is growing. A tracker helps you answer everyday questions: "Did I already add money to that fund this month?" or "How much dividend income did I receive last year?" It also reduces stress when you need to find information quickly.

What to include in your tracker

A basic tracker needs two parts: a holdings register and a transaction log. The register shows your current positions. The log records every action you take, so you can always see how a position was built.

Holdings register

Create a sheet or table with one row per investment you currently hold. Useful columns are:

  • Asset name – e.g., "Vanguard Total Stock Market ETF" or "Company X shares".
  • Ticker symbol – if applicable, for quick lookup.
  • Account or broker – where the investment is held (e.g., "IRA", "Taxable", "Broker A").
  • Number of units – shares, bonds, or fund units.
  • Current price per unit – update this on your valuation dates.
  • Market value – calculated as units multiplied by price.
  • Total cost basis – how much money you originally invested (sum of all purchases).
  • Gain/loss – market value minus cost basis.

Transaction log

Keep a separate table with one row per transaction. Record:

  • Date – when the transaction happened.
  • Asset – what you bought or sold.
  • Type – buy, sell, dividend, contribution, withdrawal, transfer.
  • Amount – number of units or cash amount.
  • Price per unit – for buys and sells.
  • Fees – any commission or charges.
  • Account – where the transaction occurred.

Optional but useful columns: notes (e.g., "rebalanced", "tax-loss harvesting") and currency if you hold foreign assets.

How to set it up step by step

Follow these steps to create your tracker. The process is the same in Google Sheets and Microsoft Excel, though menu names may differ slightly.

  1. Create a new spreadsheet and name it clearly, e.g., Investment Portfolio Tracker 2025.
  2. Add two sheets (tabs) at the bottom: one called "Holdings" and one called "Transactions".
  3. Build the Holdings table. In the first row, type the column headers listed above. Format numbers as currency or percentages where appropriate.
  4. Build the Transactions table on the second sheet. Use one row per transaction, starting from your earliest record.
  5. Enter your current holdings. If you have old statements, enter the transactions that created them into the log first, then the holdings will make sense. If you are starting fresh, you can enter the current number of units and cost basis from your broker statements.
  6. Set a valuation date routine. Choose a regular day, such as the first of each month or every quarter, to update current prices and market values.
  7. Use simple formulas to reduce manual work. In the Holdings sheet, set Market Value = Units × Price, and Gain/Loss = Market Value − Cost Basis. In the Transactions sheet, you can sum total contributions or dividends with a SUMIF formula.

Comparing Google Sheets and Excel for a portfolio tracker

Both tools work well. Your choice depends on how you like to access and share your records.

FeatureGoogle SheetsMicrosoft Excel
AccessOnline, from any device with internetPrimarily desktop, with online version via OneDrive
SharingEasy real-time collaboration with a linkStrong sharing via OneDrive, but less seamless real-time editing
Offline useLimited without setupFull functionality installed on your computer
Formulas and functionsCommon functions available, but fewer advanced featuresMore powerful data tools and custom formulas
CostFree with a Google accountPaid (part of Microsoft 365) or one-time purchase

If you want to check your portfolio from your phone or share it easily with a spouse, Google Sheets is often more convenient. If you prefer working offline and need advanced data analysis, Excel may suit you better.

How to keep the tracker useful over time

A tracker only helps if it is up to date and easy to understand. Here are some calm, practical habits.

  • Record transactions promptly. When you buy or sell, add the row to your log the same week. That way you never face a pile of old statements.
  • Update prices on your valuation dates. Set a recurring reminder in your calendar, perhaps monthly. Manual price updates are fine for a simple tracker. Some people use Google Sheets functions like GOOGLEFINANCE to pull certain prices automatically, but that works only for some tickers and currencies; manual entry is reliable and keeps you aware of your assets.
  • Add notes for context. A short note like "sold half for home down payment" or "received dividend reinvested" helps you and your family understand later why a decision was made.
  • Back up your file. If you use Excel, save a copy to cloud storage or an external drive. Google Sheets automatically saves online, but you can also download a backup occasionally.

When and how to share the tracker

Your investment tracker is private, but there are moments when sharing it brings peace of mind.

  • With a spouse or partner: Sharing the tracker ensures you are both informed about your joint financial picture. You can keep one shared spreadsheet for household investments and update it together.
  • For family handover: If you manage investments for an older parent or you want your adult children to understand your accounts, a well-organized tracker is invaluable. It shows what exists, where it is held, and how to access it (though you should keep login details separate and secure, perhaps in a password manager).
  • With a financial advisor or tax professional: You can share a read-only copy or export your transaction log at tax time. This saves hours of gathering statements.

Before sharing, make sure the sheet has no sensitive account numbers or personal identifiers in the notes. If you include them, keep the file protected and share only with trusted people.

Connecting the tracker to other important records

Your investment tracker can sit alongside other calm, organized documents, such as a list of appointments, important questions for your advisor, and family handover notes. For example, you might keep a separate sheet in the same workbook called "Remember" where you jot down reminders like "review asset allocation in April" or "ask broker about fees on the ETF". This turns your tracker into a single calm place for financial thinking, not just numbers.

Start small. Create the two core sheets, enter your current holdings, and set a monthly reminder. The goal is not perfection but clarity. Over time, the tracker will become a reassuring part of your financial routine.

Related articles