How to track dividends accurately
Most dividend records go wrong in the same five places. Here is what to capture, how to handle ex-dates, DRIP, withholding tax and currencies, and how to stop the whole thing being a monthly chore.
Record five fields
Ticker, shares held on ex-date, per-share amount, pay date, net received.
Watch the ex-date
Ownership before the ex-date decides whether you get paid at all.
Keep gross and net
Withholding tax hides in the gap between the two figures.
Step 1 · Capture the five fields that matter
A dividend record is only useful if it can answer two questions later: how much income did this holding produce, and was it paid on time? That needs five fields per payout:
- Ticker · including the exchange suffix, so RIO.L and RIO are not confused.
- Shares held on the ex-dividend date · not today's share count.
- Dividend per share · in the currency it was declared in.
- Pay date · when cash actually arrived.
- Net amount received · after withholding tax and any broker fee.
Everything else, yield-on-cost, monthly income, forecast income, is derived from those five fields. Get them right and the rest calculates itself.
Step 2 · Track the ex-dividend date, not just the pay date
The ex-dividend date is the cut-off. You must already own the shares when the market opens on that day, which in practice means buying the day before at the latest. The pay date can be two to six weeks later, and for some funds considerably longer. If your records only contain pay dates, you lose the ability to plan purchases around income, and you will occasionally wonder why a holding you bought "before the dividend" paid you nothing. A dividend calendar that shows both dates side by side removes that guesswork.
Step 3 · Handle DRIP as two events
Reinvested dividends are still income. Record the cash payout, then record the share purchase it funded as a separate transaction. If you skip the first step your income history is understated and your yield-on-cost is wrong; if you skip the second, your cost basis drifts. Our DRIP calculator shows the compounding effect once those two events are recorded properly.
Step 4 · Deal with tax and currency before it compounds
Foreign dividends usually arrive net of withholding tax, commonly 15% on US shares for UK investors with a completed W-8BEN, and more without one. Record the gross and net figures so the difference is visible and reclaimable.
Multi-currency portfolios need one more decision: which rate to use. Use the rate on the pay date for income records and keep a single display currency for reporting, otherwise year-on-year comparisons become meaningless. The dividend tax calculator estimates what you will actually keep in the UK, US and EU.
Step 5 · Automate the repetitive part
Manual tracking works until you hold more than about ten positions, at which point the monthly reconciliation becomes the reason people stop. A dividend tracker matches announced payouts to the shares you held on each ex-date, flags estimated dates against confirmed ones, and projects the next twelve months of income. You still review it, you just stop typing it.
Frequently asked questions
What information do I need to track a dividend?
Five things: the ticker, the number of shares you held on the ex-dividend date, the dividend per share, the pay date, and the net amount actually received after any withholding tax or fees.
What is the difference between the ex-dividend date and the pay date?
The ex-dividend date decides who gets paid, you must own the shares before that date. The pay date is when the cash actually lands, usually two to six weeks later. Tracking only the pay date means you can miss the deadline to qualify.
How do I track dividends if I reinvest them (DRIP)?
Record the cash dividend first, then record the shares bought with it as a separate purchase. That keeps your income history intact and your cost basis accurate, merging the two hides how much income the portfolio actually produced.
How should I handle foreign withholding tax?
Record both the gross dividend and the net amount you received. The difference is the withholding tax, which you may be able to reclaim or offset. If you only record the net figure, your yield calculations will understate the holding.
How often should I update my dividend records?
Once a month is enough if you are recording manually, most payouts settle within a few days of the pay date. Automatic tracking removes the chore entirely by matching payouts to your holdings as they are announced.