How to Track Dividend Income: Spreadsheet, Broker or Tracker
Dividend income arrives in small payments, across several accounts, in more than one currency, with tax taken before it lands. Here are the eight numbers worth tracking, the three ways to track them, and where each one breaks down as the portfolio grows.
Photo by Austin Distel on Unsplash
Dividend income is easy to receive and hard to see. It arrives in dozens of small payments a year, from several accounts, often in two or three currencies, with tax taken before it reaches you. Your broker shows each payment as a line in a statement. What it does not show is the number you actually want: how much you were paid this year, how that compares with last year, and what is still to come.
Tracking closes that gap. This article covers what to record, the three ways to record it, and the point at which each one stops working.
The eight numbers a dividend record needs
A record that only lists payments is a receipt, not a tracker. To answer the questions an income investor asks, it needs eight things per payment, and four totals built from them.
Per payment:
- Holding and account. Which stock or fund, and which broker or wrapper it sits in.
- Ex-dividend date and payment date. The first decides whether you were owed it; the second is when it landed.
- Gross amount per share, and the number of shares. Together they give the gross payment, and they let you spot a raise or a cut.
- Currency of the payment. A US dividend into a euro account is two numbers, not one.
- Withholding tax taken at source, by the company's country.
- Net amount received, in the currency of the account.
- The exchange rate on the payment date, so the net amount can be stated in your base currency.
- Whether it was reinvested, and at what price, because reinvested dividends are both income and a new lot.
From those, the four totals:
- Income received this year, in your base currency, gross and net.
- Income still expected this year, from announced dividends on what you hold.
- Trailing twelve months against the twelve before, so growth is visible without waiting for December.
- Withholding by country, because that is the number a tax return and a reclaim form both ask for.
If a method cannot produce those four totals across every account, in one currency, it is not tracking your dividend income. It is tracking part of it.
Method one: the spreadsheet
A spreadsheet is the honest starting point, and for a portfolio of ten holdings in one account and one currency it is enough. One row per payment with the eight columns above, a pivot by month and by holding, and a chart.
Where it holds up:
- Full control. Every column is yours, every formula is visible.
- Free, and it works offline.
- A good teacher. Typing each payment by hand makes you notice the raise, the cut, and the withholding you did not expect.
Where it breaks:
- Entry is manual, and it never stops. Thirty holdings paying quarterly is 120 rows a year. Monthly payers and ETFs push it past 200. Most spreadsheets die of a missed quarter.
- Exchange rates are a second job. Each foreign payment needs the rate on its date, looked up and typed.
- Expected income needs data you do not have. To know what is still coming, you need each holding's next ex-date and amount, which means visiting thirty investor-relations pages.
- Several brokers means several exports in several formats, reconciled by hand.
A free template is the right first step. Treat it as the thing you outgrow, not the thing you scale.
Method two: the broker's own screen
Every broker shows a dividend history, and some show a projection. For a single account it is the least effort: nothing to enter, nothing to reconcile.
Where it breaks:
- One broker, one account. The ISA at one broker and the taxable account at another never appear on the same screen, and nobody keeps a whole portfolio at one broker for twenty years.
- Its currency, its rules. A broker reports in the currency of the account, nets withholding its own way, and rarely shows the gross.
- History is short. Change broker and the record stays behind. Five years of income becomes a folder of PDFs.
- Forecasts are thin. A broker's projection covers what it holds, at last year's rate, without the raise announced last month.
Use the broker's screen for what it is: the source of truth for the payments in that one account. It is the input to a record, not the record.
Method three: a portfolio tracker
A portfolio tracker takes the statements from every broker and builds one record from them. The eight fields come from the import, the exchange rates and the expected payments come from market data, and the four totals are computed rather than typed.
What to expect from a good one:
- Import from every broker. A CSV or Excel export from any broker, read without a supported-broker list, or a direct connection that syncs in the background.
- One currency. Every payment converted at the rate on its date, into the base currency you choose, with the original kept.
- Gross, withholding and net on every line, and a withholding total by country for the tax return.
- Received and expected side by side: what landed this year and what is announced but not yet paid, with the ex-dates on a calendar.
- Growth without a spreadsheet. This year against last, trailing twelve months, income by sector and by country, and the raises and cuts flagged when they happen.
- A record that outlives the broker. Move accounts and the history comes with you.
Cadances is built as that record. It consolidates positions from every broker and platform into one portfolio and reconciles every dividend ever received, grouped by month with gross, withholding and net in your base currency; shows the year as a calendar of received and expected payments; flags per-share raises and cuts; and exports the dividends and the withholding by country for the tax return. Dividend tracking is one of the things it does, next to performance, tax and allocation, which is the point: the income sits in the same record as the portfolio that produces it.
Which one, at which size
| Situation | Enough |
|---|---|
| Under ten holdings, one broker, one currency | The broker's screen, or a spreadsheet if you want a chart. |
| Ten to thirty holdings, or two currencies, or two brokers | A spreadsheet with discipline, or a tracker. |
| More than thirty holdings, or three or more accounts, or foreign withholding to reclaim | A tracker. The spreadsheet will lapse. |
| Income you plan to live on | A tracker, because the number you need is the net across everything. |
Three habits that matter more than the tool
Record the gross, not only the net. The net is what you got. The gross is what the company paid, and it is the number that shows a raise or a cut, and that the tax return asks for.
Reconcile once a quarter. Compare the record with the broker statements. A missing payment, a wrong exchange rate or a duplicate import is easy to fix at three months and impossible at three years.
Keep the record out of the broker. The broker's statement is the evidence. The record is yours, and it should survive a change of broker, a closed account, or a platform that shuts down.
Questions people ask
What is the best way to track dividend income?
For a small, single-account portfolio, a spreadsheet with one row per payment. For several brokers, foreign holdings, or a portfolio you live on, a portfolio tracker that imports every account and converts to one currency.
How do I track dividends from multiple brokers?
Export the transaction history from each broker as CSV or Excel and combine them in one record, or use a tracker that imports the files or syncs the accounts and shows the payments together in one currency.
Should I track gross or net dividends?
Both. The gross shows what the company paid and reveals raises and cuts. The net is what reached you. The difference is withholding tax, which you need by country for your tax return and any reclaim.
How do I track dividends in different currencies?
Record each payment in its own currency, then convert it to your base currency at the exchange rate on the payment date. A tracker does this automatically; in a spreadsheet, add a rate column and look it up per payment.
Do I need to track reinvested dividends?
Yes. A reinvested dividend is income for the tax year and a new purchase lot with its own cost basis. Record both, or the cost basis of the holding drifts and the income goes uncounted.
Income ideas, every two weeks.
One short email every other week: a new piece from the Journal and one number worth knowing. No noise, no selling.
Keep reading
All articles →
How Many Dividend Stocks Should You Own? 20 to 30, and Why
Twenty to thirty dividend stocks across at least eight sectors, or fewer on top of a broad ETF core, is the rule of thumb. Here is the reasoning behind it, what one dividend cut costs at each portfolio size, why to weight by income rather than by value, and three shapes that work.
How to Rebalance a Dividend Portfolio Without Paying for It
In an income portfolio, drift shows up in your dividends before it shows up in your portfolio value. Here is how to spot it with a worked example, the three triggers that tell you when to act, and the four ways to rebalance, from the one that costs nothing to the one that costs capital gains tax.
A Dividend Income Portfolio Example: 100,000 Across Ten Sleeves
A worked model portfolio of 100,000 split across ten sleeves, with the weight, yield and income of each, the share of income that two sectors quietly carry, what the calendar and the tax bill look like, and what the income becomes after ten years of growth and reinvestment.