Dividend Tracker Spreadsheet: Free Google Sheets Template & Guide
What Is a Dividend Tracker Spreadsheet?
A dividend tracker spreadsheet is a Google Sheets tool that uses GOOGLEFINANCE to monitor dividend income, track payout dates, and calculate portfolio yield. With the right template, investors can visualize cash flow, reinvestment growth, and passive income over time without manual data entry.
A dividend tracker spreadsheet is a Google Sheets tool that uses GOOGLEFINANCE to monitor dividend income, track payout dates, and calculate portfolio yield. With the right template, investors can visualize cash flow, reinvestment growth, and passive income over time without manual data entry.
After-Tax, After-Fee Returns Comparator
See the real 10-year impact of fees and taxes on your returns
Most investors use the same tracker for all holdings. But dividend investors need something different: visibility into income generation.
Your goal isn't just "portfolio worth X." It's "portfolio generates $X/month in dividends."
A dividend tracker gives you that clarity.
What a Dividend Tracker Does
In one sheet, you see:
Holdings: Which stocks you own
Dividend yield: How much each pays
Income frequency: Quarterly, monthly, annually
Next payment dates: What's coming
Reinvestment: If you're compounding
Total yield: Your portfolio's income percentage
Real example:
$10,000 in AAPL @ 0.4% yield = $40/year
$10,000 in VTSAX @ 1.9% yield = $190/year
$5,000 in LPL @ 5.2% yield = $260/year
Total portfolio: $25,000
Total dividend income: $490/year
Effective yield: 1.96%
That clarity changes everything. You stop thinking "I own stocks" and start thinking "I generate $40/month in passive income."
Build Your Dividend Tracker in Google Sheets
Sheet Structure
Create this layout:
Ticker
Shares
Cost Basis
Current Price
Current Value
Annual Yield %
Annual Income
Freq
Last Payment
Next Payment
Reinvest?
AAPL
100
$150
$185
$18,500
0.4%
$74
Q
2/2/26
5/2/26
Yes
VTI
50
$200
$245
$12,250
1.9%
$233
Q
3/15/26
6/15/26
Yes
LPL
100
$50
$52
$5,200
5.2%
$271
M
1/15/26
2/15/26
Yes
Your columns:
Column A: Ticker
Stock symbol (AAPL, VTI, VTSAX, etc.)
Column B: Shares
How many shares you own.
Column C: Cost Basis
What you paid per share (historical, for tax tracking).
Column D: Current Price
Today's price per share.
Use this formula to pull live data:
=GOOGLEFINANCE("AAPL","price")
This auto-updates daily with current price.
Column E: Current Value
Formula:
=B2*D2
Shares × Current Price = What it's worth today
Column F: Annual Yield %
The dividend yield as a percentage.
For AAPL, the yield is approximately 0.4% annually.
Enter manually or:
=GOOGLEFINANCE("AAPL","yield")
Pulls the current yield from Google Finance.
Column G: Annual Income
Formula:
=E2*F2
Current Value × Yield % = Annual dividend income
For $18,500 at 0.4% = $74/year
Column H: Frequency
How often you get paid: Monthly (M), Quarterly (Q), or Annually (A)
Column I: Last Payment
Date of most recent dividend payment.
Column J: Next Payment
Expected date of next dividend.
Manual entry (you know when companies pay) or track based on frequency.
Column K: Reinvest?
Yes/No - Are you reinvesting dividends (DRIP)?
If yes, those dividends buy more shares automatically.
Advanced: Dividend Income Calendar
Add another sheet showing when you get paid:
Month | January | February | March | April | May | June
AAPL | | | $18.50 | | $18.50 |
VTI | | $58 | | $58 | | $58
LPL | $27 | $27 | $27 | $27 | $27 | $27
TOTAL | $27 | $85 | $45.50 | $85 | $45.50 | $85
This shows your monthly dividend cash flow in advance.
Portfolio-Level Summaries
At the bottom of your tracker, add:
Total Portfolio Value:
=SUM(E2:E100)
Total Annual Dividend Income:
=SUM(G2:G100)
Portfolio Yield (%):
=G101/E101
Monthly Average Dividend:
=E102/12
Years to $1M Portfolio (at current yield):
=(1000000-E101)/(E102)
Real example:
Total Value: $35,950
Total Annual Income: $578
Portfolio Yield: 1.61%
Monthly Income: $48
Years to grow: 47 years (at current yield, without additional contributions)
But that changes when you add contributions:
If you add $500/month:
Years to grow: 28 years
Years to $100k (intermediate milestone): 12 years
Track Dividend Growth
Create a separate sheet tracking your dividend income over time:
Month | Dividend Income | Trailing 12-Month | Shares Earned from DRIP
Jan 2025 | $45 | $45 | 0.2
Feb 2025 | $52 | $97 | 0.25
Mar 2025 | $48 | $145 | 0.23
...
Dec 2025 | $62 | $578 | 0.3
Jan 2026 | $48 | $581 | 0.24
The trailing 12-month column shows your annualized income at any point.
Why this matters: It shows your passive income growing. After 5 years:
Year 1 dividend income: $400/year
Year 3 dividend income: $680/year
Year 5 dividend income: $980/year
Your wealth is generating more wealth.
Tax Tracking
Dividends are taxable income. Track them:
Ticker | 2025 Income | Tax Rate | Federal Tax | State Tax | Net Income
AAPL | $74 | 22% | $16 | $3 | $55
VTI | $233 | 15% | $35 | $7 | $191
LPL | $271 | 22% | $60 | $12 | $199
By December, you know exactly:
How much dividend income you received
Estimated taxes owed
Net after-tax income
Real Dividend Investor Example
Let's say you're 50 and want dividend income to cover living expenses.
Year 1: $35,000 portfolio → $680/year income (1.9% yield)
Your goal: Generate $2,000/month ($24,000/year)
The tracker shows: You need $1.26M to generate that at 1.9% yield
Timeline calculation:
Current portfolio: $35,000
Target: $1,260,000
Monthly contribution: $1,000
Annual return: 7%
Years needed: ~26 years
Expertise: Written by a financial analyst with 10+ years of dividend investing experience and spreadsheet modeling expertise.
Get the Free Dividend Tracker Template
Frequently Asked Questions
How do I track dividends in Google Sheets?▾
Create a sheet with columns for ticker, shares, cost basis, current price, annual yield, and income frequency. Use GOOGLEFINANCE formulas to pull live prices and yields automatically.
What formulas do I need for a dividend tracker?▾
Use =GOOGLEFINANCE("TICKER","price") for live prices, =GOOGLEFINANCE("TICKER","yield") for yield, and multiply current value by yield percentage to calculate annual dividend income.
Can I import stock data into Google Sheets automatically?▾
Yes. The GOOGLEFINANCE function pulls real-time price and yield data directly into your spreadsheet without manual updates.
How do I calculate dividend yield in a spreadsheet?▾
Multiply the current value of a holding by its annual yield percentage. For example, $18,500 at 0.4% yield equals $74 in annual dividend income.
Is there a free dividend tracker template for Google Sheets?▾
Yes. This article provides a free dividend tracker spreadsheet template with pre-built columns, formulas, and layout for tracking yields, payouts, and portfolio growth.
