Templates · Investing
Free Dividend Income Tracker Template
Keep track of every dividend you earn across all your holdings. Monitor your yield, payment dates, ex-dividend dates, and projected annual income. Also tracks DRIP reinvestments and year-over-year income growth.
- Investing
- Tracker
- Free template
What's included
This tracker includes 4 sections covering everything you need.
Dividend Holdings
All your dividend-paying positions with yield and income numbers.
| Ticker | Shares | Annual Dividend/Share | Yield % | Payment Frequency | Annual Income | DRIP Enabled |
|---|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- | --- |
Payment Calendar
When your dividends are coming and how much to expect.
| Month | Ticker | Ex-Dividend Date | Payment Date | Expected Amount | Received |
|---|---|---|---|---|---|
| --- | --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- | --- |
Income by Month
Your monthly dividend income and how it is adding up for the year.
| Month | Dividend Income | YTD Total | vs Last Year |
|---|---|---|---|
| --- | --- | --- | --- |
| --- | --- | --- | --- |
DRIP Log
New shares you picked up through dividend reinvestment.
| Date | Ticker | Dividend Amount | Shares Acquired | Reinvestment Price |
|---|---|---|---|---|
| --- | --- | --- | --- | --- |
| --- | --- | --- | --- | --- |
How to use this template
Follow these steps to get the most out of this template.
- 1
List every dividend-paying stock or fund you own with its current annual dividend per share.
- 2
Note how often each one pays (monthly, quarterly, semi-annual, annual) and typical ex-dividend dates.
- 3
Add up your total expected annual dividend income across everything.
- 4
Each month, check what you actually received against what you expected.
- 5
If you use DRIP, log the new shares and reinvestment price so your cost basis stays accurate.
- 6
Compare this year's income to last year's — you want to see that number growing.
Who this template is for
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.
Why use Clarity instead?
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.
- Automatic transaction imports from 12,000+ institutions
- Real-time portfolio values and net worth tracking
- AI-powered spending insights and budget recommendations
- Tax-ready reports with automatic cost basis calculations
- One dashboard for banks, brokerages, crypto, and DeFi
Frequently Asked Questions
What is a good dividend yield?
For solid, established companies, 2-5% is a normal range. If you see yields above 6%, treat that as a warning sign — the company may cut its dividend. Pay more attention to dividend growth rate (how much it increases each year) than current yield. A 2% yield growing 10% annually will beat a flat 5% yield within a decade.
Should I reinvest dividends or take the cash?
If you are still building wealth, reinvesting (DRIP) lets compounding do its thing. If you are retired or close to it and need the income, take the cash. One smart move: reinvest inside tax-advantaged accounts and take cash in taxable ones to manage your tax bill.
How are dividends taxed?
Qualified dividends get the friendlier long-term capital gains rates (0%, 15%, or 20%). Ordinary (non-qualified) dividends are taxed like regular income. Most US stock dividends are qualified as long as you held the stock for 60+ days. REITs and foreign stocks often pay ordinary dividends.
Related templates
Other templates you might find useful.
Investment Portfolio Tracker
See all your investments in one place — stocks, bonds, ETFs, mutual funds, the works. Track your cost basis, see how much you have gained or lost, check your asset allocation, and keep tabs on dividend income.
InvestingStock Portfolio Spreadsheet
A stock tracker for people who pick their own companies. Get detailed per-position tracking, sector allocation breakdowns, and realized vs. unrealized gain calculations — all the way down to lot-level detail.
RetirementRetirement Savings Planner
Figure out if you are saving enough to retire comfortably. Track your contributions, calculate your employer match, project how your money will grow, and see whether your future self will thank you. Covers 401(k), IRA, Roth IRA, and more.
Ready to go beyond spreadsheets?
Clarity connects to your financial accounts and automates what this template does manually. Real-time data, zero data entry, and AI-powered insights.