Track dividend income across all your holdings. Monitor yield, payment frequency, ex-dividend dates, and annual income projections. Includes DRIP tracking and year-over-year income growth analysis.
This tracker includes 4 sections covering everything you need.
All positions that pay dividends with yield and income calculations.
| Ticker | Shares | Annual Dividend/Share | Yield % | Payment Frequency | Annual Income | DRIP Enabled |
|---|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- | --- |
Upcoming dividend payment dates and expected amounts.
| Month | Ticker | Ex-Dividend Date | Payment Date | Expected Amount | Received |
|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- |
Monthly dividend income totals and running annual total.
| Month | Dividend Income | YTD Total | vs Last Year |
|---|---|---|---|
| --- | --- | --- | --- |
| --- | --- | --- | --- |
Shares acquired through dividend reinvestment.
| Date | Ticker | Dividend Amount | Shares Acquired | Reinvestment Price |
|---|---|---|---|---|
| --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- |
Follow these steps to get the most out of this template.
List every dividend-paying holding with its current annual dividend per share.
Note the payment frequency (monthly, quarterly, semi-annual, annual) and typical ex-dividend dates.
Calculate your total expected annual dividend income across all holdings.
Track actual payments received each month against expectations.
If you use DRIP, log the new shares acquired and their reinvestment price for cost basis tracking.
Compare year-over-year dividend income growth to ensure your income stream is increasing.
Dividend investors building passive income streams.
Retirees who rely on dividend income for living expenses.
Investors pursuing a dividend growth investment strategy.
Anyone who wants to project future passive income from their portfolio.
This template is great for manual tracking, but Clarity automates everything for you. Connect your bank accounts, brokerages, exchanges, and wallets and see real-time data without entering a single number.
For established companies, 2-5% is typical. Yields above 6% may signal risk — the company might cut its dividend. Focus on dividend growth rate (annual increase) rather than current yield alone. A 2% yield growing at 10% per year will surpass a static 5% yield within a decade.
During the accumulation phase, reinvesting (DRIP) compounds your returns significantly. If you are in or near retirement and need income, taking cash makes sense. Consider reinvesting in tax-advantaged accounts and taking cash in taxable accounts to control your tax liability.
Qualified dividends are taxed at long-term capital gains rates (0%, 15%, or 20%). Ordinary (non-qualified) dividends are taxed as regular income. Most US stock dividends are qualified if you held the stock for 60+ days. REITs and foreign stocks often pay ordinary dividends.
Other templates you might find useful.
Investment Portfolio Tracker
Track all your investments in one spreadsheet — stocks, bonds, ETFs, mutual funds, and alternatives. Includes cost basis tracking, gain/loss calculations, asset allocation percentages, and dividend income.
InvestingStock Portfolio Spreadsheet
A focused stock portfolio tracker with detailed per-position tracking, sector allocation, and realized/unrealized gain calculations. Built for active stock pickers who need lot-level detail.
RetirementRetirement Savings Planner
Plan your retirement savings with contribution tracking, employer match calculations, projected growth, and income replacement analysis. Covers 401(k), IRA, Roth IRA, and other retirement vehicles.
Clarity connects to your financial accounts and automates what this template does manually. Real-time data, zero data entry, and AI-powered insights.