Portfolio Management

How to Track Your Dividend Portfolio

Monitor dividend income, reinvestments, and performance with the right tools. Compare spreadsheets, apps, and automated tracking methods.

What You'll Learn

  • 5 methods for tracking dividend income (from simple to advanced)
  • Best apps and tools for dividend tracking
  • How to calculate forward dividend income and yield on cost
  • Free spreadsheet template you can copy

5 Methods to Track Dividends

Method 1

Broker Statements (Easiest)

Best for Beginners

Your broker automatically tracks all dividends received. Check monthly/quarterly statements or online dashboard. Zero effort required.

Pros:

  • • Completely automatic
  • • 100% accurate
  • • No setup needed
  • • Free

Cons:

  • • Only shows past dividends
  • • Can't forecast future income
  • • Limited if you have multiple brokers
  • • No custom reporting

Best Broker Dashboards:

  • Fidelity: "Income" tab shows monthly dividend history and projections
  • Schwab: "Dividends & Capital Gains" report with calendar view
  • M1 Finance: "Dividends" page shows yield on cost and projected income
Method 2

Simple Spreadsheet (Recommended)

Best Balance

Track holdings in Google Sheets or Excel. Calculate forward dividend income and yield on cost. Update monthly or quarterly.

StockSharesCost BasisAnnual DivForward IncomeYOC
JNJ50$7,500$4.76$2383.2%
PG40$6,000$3.76$1502.5%
KO100$5,500$1.94$1943.5%
Total190$19,000-$5823.1%

Key Formulas:

  • Forward Income = Shares × Annual Dividend
  • Yield on Cost (YOC) = Forward Income / Cost Basis
  • Portfolio Yield = Total Income / Total Cost Basis
Method 3

Dividend Tracking Apps

Most Features

Dedicated apps designed specifically for dividend investors. Automatic dividend updates, portfolio analysis, and projections.

DivTracker (Free)

Recommended

Best free dividend tracker. Calendar view of upcoming dividends, portfolio analysis, dividend safety scores.

  • • iOS and Android apps
  • • Automatic dividend updates
  • • Forward income projections
  • • Portfolio diversification analysis

Seeking Alpha ($20/month)

Premium

Professional-grade portfolio tracker with dividend analysis, alerts, and research.

  • • Portfolio tracker with dividend projections
  • • Dividend safety ratings (A-F)
  • • Alerts for dividend cuts/increases
  • • Access to analyst research

Simply Safe Dividends ($10/month)

Focused on dividend safety analysis. Portfolio tracker with risk scores.

  • • Portfolio safety score
  • • Dividend sustainability ratings
  • • Income projections
  • • Watchlist alerts
Method 4

Portfolio Trackers (Mint, Personal Capital)

General investment apps that sync with your broker. Track dividends alongside other investments.

Personal Capital (Free)

  • • Syncs with all major brokers
  • • Shows total dividend income
  • • Portfolio allocation analysis
  • • Net worth tracking

Empower (Free)

  • • Automatic broker sync
  • • Income tracking by month
  • • Investment checkup tool
  • • Retirement planner
Method 5

Advanced Spreadsheet with Macros

For power users. Automated spreadsheet that pulls live stock prices and dividend data. Full control and customization.

Features:

  • • Google Finance/Yahoo Finance API integration
  • • Automatic price updates
  • • Dividend history tracking
  • • Custom calculations (CAGR, IRR, etc.)
  • • Charts and visualizations

Setup Time: 2-4 hours initial setup, but worth it for serious investors with 20+ holdings

Get Our Free Dividend Tracking Template

Google Sheets template with formulas for forward income, YOC, and portfolio analysis

Free forever
Unsubscribe anytime
No spam

Key Metrics to Track

Forward Dividend Income

How much dividend income you'll receive over the next 12 months based on current holdings and dividend rates.

Formula:

Forward Income = Σ(Shares × Annual Dividend)

Example: 50 shares JNJ × $4.76 = $238/year

Yield on Cost (YOC)

Dividend yield based on your purchase price, not current price. Shows true return on your investment.

Formula:

YOC = (Annual Dividend / Cost Basis) × 100

Example: $4.76 / $150 = 3.2% YOC

Dividend Growth Rate

How fast your dividend income is growing year-over-year. Track by stock and portfolio-wide.

Example:

2024 Income: $2,500

2025 Income: $2,750

Growth Rate: 10%

Portfolio Diversification

Track what percentage of income comes from each sector and stock. Avoid over-concentration.

Guidelines:

  • • No single stock over 10% of income
  • • No sector over 30% of income
  • • 15-25 stocks ideal for diversification

Setting Up Your Tracking System

Step-by-Step Setup Guide

1

Choose Your Method

Beginners: Broker statements. Serious investors: Spreadsheet or app.

2

Record Current Holdings

List all dividend stocks with: ticker, shares, purchase price, purchase date.

3

Add Current Dividend Rates

Look up annual dividend for each stock. Update quarterly when dividends increase.

4

Calculate Forward Income

Multiply shares by annual dividend for each stock. Sum for total portfolio income.

5

Set Update Schedule

Update monthly (add new purchases) or quarterly (after dividend increases announced).

Common Tracking Mistakes

Not Tracking Reinvested Dividends

If you DRIP (automatically reinvest), your share count increases. Update your tracker after each reinvestment or you'll underestimate forward income.

Forgetting to Update After Dividend Increases

Companies announce dividend increases quarterly. If you don't update, your projections will be low. Set calendar reminders for earnings season.

Tracking Too Many Metrics

Start simple. Track forward income and YOC. Add complexity later if needed. Over-tracking leads to abandoning the system.

Start Tracking Your Dividends Today

Choose the tracking method that fits your needs. Start simple with broker statements, then upgrade to spreadsheet or app as your portfolio grows. Consistent tracking helps you stay motivated and make better investment decisions.

Related Guides