Skip to main content

10% off your first orderโ€” use codeat checkout.

Products/Investment Portfolio Tracker
Financial Services

Investment Portfolio Tracker

$9.99

One-time purchase ยท Instant download ยท Both formats included

Works with

Microsoft ExcelGoogle SheetsMac + WindowsiPad + ChromebookNo subscription required

Secure checkoutInstant delivery30-day refund

Live Preview

Scroll through tabs at the bottom to explore all worksheets.

Save with a Bundle

This template is included in these bundles. Get more templates and save:

What's Included

7 tabs, formulas pre-wired
Sample data plus a blank version
Conditional formatting and dropdowns set up
Works in Excel and Google Sheets

Overview

Track holdings, transactions, cost basis, and dividends across every account โ€” brokerage, IRA, 401(k), Roth โ€” in one workbook. Asset allocation views, performance dashboards, and benchmark comparison against S&P 500 and a custom index. Built for investors who want more than a Robinhood screenshot at tax time.

Know your numbers without building the workbook from scratch. 7 tabs with portfolio overview with cost basis, current value, and gain/loss and transaction log for buys, sells, fees, and dividends already calculating, covering Settings, Portfolio Overview, Transaction Log, Dividend Tracker and 3 more.

Designed for individual investors and financial advisors. Conditional formatting flags what needs attention; data validation stops the usual data-entry nonsense before it starts.

Worksheets Included (7)

Settings
Portfolio Overview
Transaction Log
Dividend Tracker
Asset Allocation
Performance Dashboard
Instructions

Key Features

  • Portfolio overview with cost basis, current value, and gain/loss
  • Transaction log for buys, sells, fees, and dividends
  • Actual vs. target asset allocation with rebalancing signals
  • Dividend income tracker with yield calculations
  • Performance dashboard with benchmark comparison

Ideal For

  • Individual investors
  • Financial advisors
  • Portfolio managers
  • Retirement planners

Common Questions

Does this work in Excel AND Google Sheets?
Yes. Every spreadsheet ships in two formats: a native .xlsx file (Excel 2016+) and a Google Sheets copy you can open in your browser. Formulas, formatting, and validation work identically in both. Pick whichever your team uses.
Will the formulas break if I add my own rows?
No. Formulas use structured references and dynamic ranges where it matters, so inserting rows mid-table extends the calculations automatically. The Instructions tab in each workbook explains which rows are formula-driven vs. your input.
Is there a password on the file?
Yes. The workbook is lightly sheet-protected to prevent accidental formula overwrites. The password is included in the Setup Guide PDF that ships with every purchase. You're free to unprotect any sheet once you're in.
What if I need a refund?
30-day money-back guarantee, no questions asked. Email hello@fennecpress.com with your order number and we'll process the refund within a business day.
Can I re-download the file later?
Yes. Create a free account at fennecpress.com/account after purchase and your downloads stay accessible. A copy also lands in the confirmation email you received at checkout.
Can I use this for my business / my clients?
Yes. You own your copy outright and can customize it, share it with your team, and use it for as many internal or client-facing projects as you want. You can't resell the template itself, but any work product you create using the template is entirely yours.

Get this template in the Financial Services Professional Suite

2 templates for $19.99, save 43%

View Bundle

Ready to Get Started?

Get instant access to Investment Portfolio Tracker

Secure Checkout
Instant Download
30-Day Refund
Powered by Stripe

Templates are tools, not advice. Nothing here is legal, tax, financial, or professional advice. Run big decisions past a qualified professional. Full terms.