To track dividend income, keep two numbers apart: the income you have already received, payment by payment, and the forward income your current holdings are set to pay over the next twelve months. Everything else — yield on cost, dividend growth, tax withheld — hangs off those two. Here is what to record, how to read the yields without fooling yourself, and when a spreadsheet stops being enough.
Received income is history: the cash that actually arrived, on the dates it arrived, after whatever tax was taken at source. It is a fact, it never changes once recorded, and it is what goes on a tax return and into an honest calculation of what the portfolio has returned.
Forward income is an estimate: each holding’s current annual dividend per share multiplied by the shares you hold now. It answers “what will this portfolio pay me over the next year if nothing changes?” — the number to plan spending around. It moves every time you buy, sell, or a company raises, cuts or suspends its dividend.
Mixing them up is the most common tracking mistake. A portfolio built up over the year can have forward income well above anything it has paid so far; a portfolio holding a company that has just cut its dividend has a forward figure below last year’s receipts. Both numbers are right; they answer different questions.
A dividend log needs a row per payment, with at least these columns:
| Field | Why it is there |
|---|---|
| Ticker and shares held | The payment is per share; the shares you held on the ex-date decide the total. |
| Ex-dividend date | The date you had to own the shares by. It explains why a recent purchase did not pay. |
| Payment date | When the cash actually arrives — the date your income belongs to. |
| Amount per share | The figure the company sets, and the one whose growth you want to follow. |
| Gross amount | Per share × shares. The number before any tax. |
| Tax withheld | Taken at source before the money reaches you; needed at tax time. |
| Net amount and currency | What actually landed, in the currency it was paid in. |
The two dates trip people up most. The ex-date decides whether you are paid, the payment date when; a dividend can go ex in one month and pay in the next, and a monthly income summary should be built on payment dates. The ex-dividend date explainer covers all four dividend dates and the rule for when you have to own the shares.
An illustration on an invented holding: 200 shares bought at $40, held for five years while the company raised its dividend and the share price rose.
| Year 1 | Year 6 | |
|---|---|---|
| Shares held | 200 | 200 |
| Original cost | $8,000 | $8,000 |
| Share price | $40.00 | $64.00 |
| Annual dividend per share | $1.20 | $1.60 |
| Annual income | $240 | $320 |
| Current yield | 3.0% | 2.5% |
| Yield on cost | 3.0% | 4.0% |
Current yield is the dividend yield anyone buying today would get: $1.60 ÷ $64 = 2.5%. Yield on cost is the annual dividend against what you paid: $320 ÷ $8,000 = 4.0%. Both are correct. Yield on cost is a good record of how the holding has grown its payout for you, and a pleasant number to watch climb.
It is a poor number to decide with. The $12,800 the position is now worth (200 × $64) could be sold and put elsewhere, and what that money earns where it sits is 2.5%, not 4.0%. When you compare a holding with an alternative, use the current yield; keep yield on cost as the history of the decision you already made.
In the example the dividend per share rose from $1.20 to $1.60 — 33% over five years, or about 5.9% a year as a compound annual growth rate (1.05925 ≈ 1.333). Track that per-share growth separately from the growth of your total income. Total income also grows when you add money or reinvest dividends, and a portfolio whose income rose 30% because you bought more shares has learned nothing about the companies in it.
Growth says nothing about safety. A company paying out more than it earns is funding the dividend from borrowing, savings or asset sales, and that cannot last. The payout ratio — dividends against earnings, and better still against free cash flow — is the first check, and a ratio creeping up year after year while the dividend still grows is the pattern that comes before cuts.
Record dividends gross and net. For a US investor in US companies the broker usually withholds nothing and reports the year’s dividends on Form 1099-DIV, which shows how much of the total is qualified — taxed at lower rates than ordinary dividends. An investor outside the US holding US shares typically has 30% withheld at source by default, often reduced to a treaty rate such as 15% once a W-8BEN form is on file with the broker. A US investor holding foreign shares may see the other country’s tax withheld, which can sometimes be claimed back as a foreign tax credit. The rules depend on where you live and the type of account, so treat the net amount as the record and the gross as the starting point for your tax return.
Record each payment in the currency it was paid in, and convert it to your home currency at the rate on the payment date if you want a total. Converting a year of payments at today’s rate mixes a currency move into your income figure.
A spreadsheet is a perfectly good dividend tracker for a handful of holdings. You control every column, it costs nothing, and typing in each payment makes you look at it. The received-income half is easy: one row per payment, a sum per month and per year.
The forward half is where spreadsheets wear thin. Forward income needs each company’s current dividend per share, which changes whenever a company raises or cuts it; upcoming ex-dates need a calendar you would otherwise look up company by company; and a stock split silently breaks every per-share figure you typed. A tracker earns its place when it derives those from your holdings and a dividend calendar, so the forward figures stay current without retyping. Whichever you use, the received-income log should be yours and complete, because it is the only record of what actually happened.
The portfolio tracker keeps both halves. Received income goes in as transactions of type Dividend — ticker, amount and date — beside your buys and sells, and the portfolio performance figure on the dashboard counts them. The forward half is derived from what you hold:
On Ultimate, the Intrinsic Value tab includes a Dividend Discount Model for what a stream of dividends is worth, and the Fair Value tab’s Dividend lens reads today’s yield against the company’s own history. A CSV import or a connected broker account, also part of Ultimate, can bring dividend payments in with the rest of your history instead of typing them.
Tracking a portfolio is free within the free plan’s limits; the portfolio tracker guide shows how to set one up. Every new account gets Ultimate for seven days once the email address is confirmed, with no card.
Educational only. Not investment or tax advice; tax rules differ by country and account.
Lemma Analysis gives independent investors both lenses in one terminal — a stock screener and an intrinsic value tool for the fundamentals, alongside price history and charts for timing.