Investment Portfolio Tracker

Start Here
A professional multi-account portfolio management guide explaining how to use the workbook. It includes a quick-start workflow, color code guide, price update options, glossary of key terms, best practices, privacy and security notes, and tips for long-term portfolio tracking.

Quick Start Guide
Walks users through the core workflow: set preferences in the Settings tab, add investment accounts, enter holdings, track transactions, review the dashboard, and check the Rebalancing tab when allocation drift appears.

Color Code Guide
Explains workbook color coding: blue cells for user input, green cells for auto-calculated formulas, and red cells for warnings or action-needed areas.

Price Update Instructions
Includes guidance for manually updating current prices, copying prices from a broker export, or using Google Sheets with GOOGLEFINANCE for supported assets.

Glossary of Key Terms
Defines important tracker terms including asset class, cost basis, current value, gain/loss, allocation, target allocation, drift, rebalancing, tax-advantaged accounts, ticker/symbol, dividend yield, and XIRR.

Settings
A portfolio settings sheet for choosing the base currency, setting target asset allocation, entering warning and critical drift thresholds, adding monthly contribution settings, and optionally recording benchmark return assumptions.

Target Asset Allocation
Includes asset class targets for US Stocks, International Stocks, Bonds, Real Estate, Cash, Alternatives, and Crypto, with descriptions for each category.

Rebalancing Thresholds
Includes warning drift threshold and critical drift threshold settings, used by the rebalancing alerts to flag when an asset class has moved too far from target allocation.

Contribution Settings
Includes a monthly contribution input that can support rebalancing suggestions and future allocation planning.

Benchmark Returns
Includes optional benchmark return rows for S&P 500, Total Stock Market, and a 60/40 Portfolio.

Accounts
A multi-account tracking sheet with fields for account name, account type, tax-advantaged status, institution, and notes. Example account types include taxable brokerage, Roth IRA, 401k, HSA, and crypto exchange.

Holdings
A holdings tracker for recording each investment position. Fields include ticker or symbol, asset name, asset class, account, shares or units, average cost, total cost basis, current price, current value, gain/loss dollars, gain/loss percentage, dividend yield percentage, and notes.

Holding Formulas
The holdings sheet includes formulas for total cost basis, current value, dollar gain/loss, and gain/loss percentage based on shares, average cost, and current price.

Transactions
A transaction log for recording date, account, ticker or symbol, transaction type, shares or amount, price, fees, and notes. Example transaction types include buy, dividend, and contribution.

Dashboard
A portfolio dashboard showing total portfolio value, total cost basis, total gain/loss, total gain/loss percentage, asset allocation vs. target, top winners and losers area, contribution summary fields, and account-by-account breakdown.

Asset Allocation vs. Target
The dashboard summarizes current value, current percentage, and target percentage by asset class, using data from the holdings and settings sheets.

Account Breakdown
The dashboard includes an account-level summary showing total value and percentage of portfolio by account.

Rebalancing
A rebalancing alerts and suggestions sheet that compares current percentage against target percentage, calculates drift, displays alert status, and suggests possible action.

Rebalancing Status Logic
The workbook uses alert statuses such as critical, warning, and OK based on drift thresholds. Suggested actions include trim/sell to rebalance, add/buy to rebalance, or no action needed.

Next Contribution Suggestions
Includes a monthly contribution reference and areas for identifying underweight asset classes where new money could be allocated first.

How to Rebalance Guide
Explains how to identify drift, rebalance with new money, consider tax implications before selling, review annually or when drift exceeds thresholds, and use tax-advantaged accounts when appropriate.

Please note that this is a digital product, so no physical product will be shipped to you.

Upon purchase, you will receive an email containing a secure download link to an Excel workbook consisting of approximately 7 worksheets.

Please ensure you enter a valid email address at checkout and check your spam or promotions folder if you do not see the delivery email in your main inbox.

If our emails are delivered to your Spam or Promotions folder, please mark them as Not Spam and move them to your Primary Inbox. This helps ensure uninterrupted access to your purchases and future communications.