Debt, investing and retirement
Dividend Income Tracker Template: Worked Example
The short answer
Beat the Scatter: a dividend tracker turns scattered payouts into one calendar: five holdings paying $1,066 a year, $189.50 in June and again in December.
A dividend income tracker template beats the Scatter. The Scatter is the statement system that splits your paydays across accounts and months until you cannot see your own income. Meet Priya. She holds five dividend stocks across two accounts. She could not answer one plain question: how much will my holdings pay me this year? The data sat in five places. The answer sat in none. One tracker page later, the answer is in front of her: $1,066 a year, month by month. She was never missing money. She was missing the sight of it.
This article is educational information, not financial or tax advice. Dividend tax rules vary by account and country. Check the IRS pages below and your own records before you act on any figure here.
What should a dividend tracker record for each holding?
Record six facts per holding: the name, the share count, the price you paid, the current price, the dividend per share, and the pay months. From those six, the tracker derives the rest: annual income, current yield, and yield on cost. Skip the pay months and you own a list, not a calendar. The month a dividend lands is half the value of tracking it. The IRS treats most stock dividends as income in the year you receive them; IRS Topic No. 404 sets out the basic rules.
What does the worked example show for five holdings?
Here is a mini portfolio of five holdings, built the way a tracker holds them. Prices and payouts are round teaching figures, not quotes.
| Holding | Shares | Dividend per share | Annual income | Pay months |
|---|---|---|---|---|
| A | 120 | $2.40 | $288.00 | Mar, Jun, Sep, Dec |
| B | 60 | $3.60 | $216.00 | Feb, May, Aug, Nov |
| C | 200 | $0.96 | $192.00 | Jan, Apr, Jul, Oct |
| D | 40 | $5.20 | $208.00 | Jun, Dec |
| E | 90 | $1.80 | $162.00 | Monthly |
| Total | $1,066.00 |
Each annual figure is shares times dividend per share: 120 times $2.40 is $288.00, and so on down the column. The five sum to $1,066.00 a year. Now spread that income across the year. A pays $72.00 each quarter. B pays $54.00 each quarter. C pays $48.00 each quarter. D pays $104.00 twice a year. E pays $13.50 each month.
| Month | Income | Month | Income |
|---|---|---|---|
| Jan | $61.50 | Jul | $61.50 |
| Feb | $67.50 | Aug | $67.50 |
| Mar | $85.50 | Sep | $85.50 |
| Apr | $61.50 | Oct | $61.50 |
| May | $67.50 | Nov | $67.50 |
| Jun | $189.50 | Dec | $189.50 |
The twelve months sum to the same $1,066.00. June and December spike, because A and D pay in the same weeks. That shape is the point, and it is the Scatter's defeat in one table. Priya can now plan around her income: a bill due in June has help coming, and a thin month like January needs a buffer, not a hope.
What is the difference between yield and yield on cost?
Current yield divides the dividend by today's price. Yield on cost divides it by the price you paid. Holding A pays $2.40 a share. Priya paid $30.00 a share, and the stock now trades at $48.00. Her current yield is 5.0%: $2.40 divided by $48.00. Her yield on cost is 8.0%: $2.40 divided by $30.00. The first number prices the stock for a new buyer. The second prices her own patience. Track both. When a company raises its dividend, your yield on cost rises with it, while a new buyer still starts at the current yield. That gap is the receipt: $2.40 on a $30.00 cost pays her 8.0%, no matter what the stock costs a stranger today.
What is the ex-dividend date trap?
To receive a dividend, you must own the stock before its ex-dividend date. Buy on or after that date and the seller keeps the payment, even though you hold the stock on pay day. The trap cuts both ways. New buyers chase a pay date and miss the income. Sellers sell a day too soon and lose a payment they waited a quarter to earn. A tracker that logs ex-dates next to pay dates stops both errors. One glance tells you the last day to buy, and the day the cash should land.
How does reinvesting change the picture?
Reinvested dividends buy more shares, and more shares pay more dividends. If Priya reinvests the full $1,066.00 at a 5% yield, next year pays $53.30 more, with no new savings from her pay. The growth is slow at first, then it stacks. One caution from the tax side: a reinvested dividend is still a dividend. IRS Topic No. 409 covers capital gains and losses, and the cost base of shares bought with reinvested payouts matters when you sell. Log each reinvested payment in the tracker, with its date and price, so your records stay clean.
Which account should hold your dividend stocks?
Placement matters, and it is personal. In Canada, the RRSP vs TFSA guide walks the registered-account choice for self-employed savers, and the TFSA contribution room guide shows how to check your exact room before you add funds. US dividends paid into some accounts face withholding tax, and the rules differ by account type and treaty. Do not move holdings on a rule of thumb. Check your own room, your own tax slip, and your own plan first. The tracker's job is narrower: whichever account holds the stock, the income shows up in one calendar.
Should you track in an app, a spreadsheet, or Notion?
Judge each tool by one test: can it show your next twelve months of income on one page? A broker app fails that test. It shows one account well and the whole picture poorly, which is the Scatter with a login. A spreadsheet can pass, but the upkeep is yours: you build each formula and each view, and you keep them true. A template is the middle path, and for most holders it is the right one: the setup is done, and the calendar is the page you open. The Notion Template: Dividend Income Tracker is the done-for-you form of this exact setup: four linked databases for holdings, the dividend calendar, the income ledger, and the annual summary, with 21 formulas for yield, yield on cost, and forward income. Whichever route you pick, the test stands: if it cannot show twelve months on one page, it is a list, not a tracker. For the goal behind the income, the Coast FIRE guide shows when invested savings can carry your spending on growth alone. One year on this system, Priya's future is written in months: $189.50 in June, $189.50 in December, and no month under $61.50. She stopped guessing what her money pays her. She became an owner who gets paid on a schedule she can read.
Do the math.
FAQ
What is a dividend income tracker template? It is a ready-made page or sheet that logs each holding once and then shows your dividend income by month and by year. You record shares, dividend per share, and pay months. The template derives annual income, current yield, and yield on cost for you.
How do I calculate my annual dividend income? Multiply shares by the dividend per share for each holding, then add the results. In the worked example, five holdings pay $288.00, $216.00, $192.00, $208.00, and $162.00, which sum to $1,066.00 a year.
What is yield on cost? Yield on cost is the annual dividend per share divided by the price you paid per share. A stock paying $2.40 that you bought at $30.00 has a yield on cost of 8.0%. It measures the income your own purchase earns, not the income a new buyer would get today.
What is the ex-dividend date? It is the first day the stock trades without the right to the next dividend. Buy before that date and you receive the payment. Buy on or after it and the seller receives it instead. A good tracker logs the ex-date beside the pay date for each holding.
Are reinvested dividends taxable? In the US, a dividend you reinvest is still a dividend in the year it is paid, even though you never hold the cash. The shares it buys add to your cost base, which matters when you sell. Log each reinvested payment with its date and price so the record is ready at tax time.
Sources
- Internal Revenue Service, Topic No. 404, Dividends: https://www.irs.gov/taxtopics/tc404
- Internal Revenue Service, Topic No. 409, Capital Gains and Losses: https://www.irs.gov/taxtopics/tc409
About Kollaz
Kollaz: Smart financial tools for modern money. We build spreadsheets that answer real money decisions with real math. Browse the shop: etsy.com/shop/kollaz. Get the planner: Notion Template: Dividend Income Tracker.