If you own more than a couple of dividend stocks, you eventually want one place that answers three questions: How much will I earn this year? When does each payment arrive? Is any of it at risk?
There are two common ways to get there: a spreadsheet you maintain yourself, or a dividend tracker app. Both work. This guide shows you how to build a solid dividend spreadsheet, where spreadsheets tend to break down, and how to decide when an app is worth it.
What a Dividend Tracker Needs to Show
Whatever tool you use, a useful dividend tracker covers five things:
- Holdings — ticker, shares owned, and what you paid.
- Annual income — what each position pays per year, and the total.
- Payment schedule — which months each holding pays, so you can see your income month by month.
- Yield on cost — the yield on the money you invested, not today's price.
- Dividend safety — an early warning if a payout looks stretched.
The first four are math. The fifth takes research. That split matters when you choose a tool.
Option 1: Build a Dividend Spreadsheet
A spreadsheet is free, flexible, and private. Here is a layout that covers the essentials.
The columns
| Column | What goes in it | Example |
|---|---|---|
| A — Ticker | Stock or ETF symbol | JNJ |
| B — Shares | Shares you own | 25 |
| C — Avg Cost | Average price you paid per share | $150.00 |
| D — Price | Current share price | $160.00 |
| E — Annual Dividend | Annual dividend per share | $5.00 |
| F — Pay Months | Months it pays | Mar, Jun, Sep, Dec |
The formulas
Add these calculated columns (row 2 shown):
- Annual income:
=B2*E2→ 25 × $5.00 = $125.00 - Monthly average:
=B2*E2/12→ $10.42 - Current yield:
=E2/D2→ $5.00 ÷ $160 = 3.13% - Yield on cost:
=E2/C2→ $5.00 ÷ $150 = 3.33% - Position value:
=B2*D2→ $4,000
Total the annual income column and you have your portfolio's yearly dividend income. Divide by 12 for a monthly average. (For a deeper dive on that last formula, see our guide to yield on cost.)
Where spreadsheets break down
A spreadsheet only knows what you type into it. In practice that means:
- Prices and dividends go stale. Every dividend raise, cut, or price move is a manual update. Miss one and your income total is wrong.
- The payment calendar is all manual. You have to look up and enter each holding's pay months, then build a month-by-month view yourself.
- Safety is invisible. A spreadsheet will happily show a 12% yield without telling you the payout ratio is over 100%.
- It's awkward on a phone. Checking your income on the go means scrolling a wide grid on a small screen.
None of these are deal-breakers for a small, stable portfolio. They get painful as you add positions.
Put this into practice — free
Get your number in seconds with a free calculator — no signup, no email.
Dividend tracking tips, every morning
One income idea a day, plus raises, cuts, and ex-dividend reminders. Free.
Free. No spam. Unsubscribe anytime.
Option 2: Use a Dividend Tracker App
A dividend tracker app does the lookups for you. With DividendPro's free dividend tracker, the workflow is:
- Type a ticker. Price, annual dividend, yield, and sector fill in automatically.
- Enter your shares. Average cost is optional — add it when you want accurate yield on cost and gain/loss.
- Read your income. Annual and monthly income, a dividend calendar, and safety scores appear right away.
You don't link a brokerage account, and you don't need to sign up to try it — holdings are saved in your browser. The Free plan covers up to 3 stocks; Pro ($7/mo) covers 50 with cloud sync, and Premium ($12/mo) is unlimited. Both paid plans start with a 7-day free trial with no credit card.
Spreadsheet vs. App at a Glance
| Spreadsheet | Dividend tracker app | |
|---|---|---|
| Cost | Free | Free tier; paid plans for larger portfolios |
| Setup time | 30–60 minutes for formulas and layout | About a minute per holding |
| Price & dividend updates | Manual | Automatic |
| Payment calendar | Build it yourself | Built in |
| Dividend safety | Your own research | Safety scores included |
| Customization | Unlimited | Limited to the app's features |
| Privacy | Stays on your computer | No brokerage linking; data you choose to enter |
Which Should You Use?
Stick with a spreadsheet if you hold only a few positions, enjoy building your own models, or want custom calculations no app offers.
Switch to an app if you hold more than a handful of stocks, you've caught your spreadsheet with stale numbers, or you want to see when your income arrives without building a calendar by hand.
Plenty of investors do both: an app for day-to-day income tracking and a spreadsheet for one-off what-if modeling.
A Simple Weekly Routine (Either Tool)
- Log new buys the day you make them, including shares and cost.
- Check the month ahead for upcoming payments so you know what cash is coming.
- Review dividend announcements — raises, cuts, and special dividends — and update your numbers.
- Once a quarter, compare actual income received to what you projected.
Bottom Line
Tracking dividend income comes down to keeping accurate holdings and up-to-date dividend data. A spreadsheet gives you full control at the cost of manual upkeep; a tracker app trades some flexibility for automatic updates, a built-in payment calendar, and safety checks.
If you want to see your own numbers now, open the free tracker and add your first stock — no signup or brokerage login required. Planning your next step instead? Try the dividend income calculator to see how much you need invested to hit your income goal.
This article is for educational purposes only and is not financial advice.