Dividend tracking: spreadsheet or tool?

Every dividend investor builds the spreadsheet eventually. Ticker, shares, dividend per share, a SUM at the bottom. Feels great for about three months.

This article is not going to tell you the spreadsheet is stupid. It is the opposite of stupid: it is usually the first honest attempt an investor makes at knowing what their portfolio actually pays them, rather than what a yield figure on a screener implies it should. The question is narrower and more practical. At what point does the maintenance cost of a manual dividend ledger exceed the cost of software that does the same bookkeeping automatically, and what exactly breaks first?

Why the spreadsheet feels right at the start

A small dividend portfolio is a small bookkeeping problem. Three stocks, four payments a year each, twelve rows. You know every position because you chose every position. Entering a dividend takes thirty seconds and doubles as a pleasant ritual, the investing equivalent of counting the till at closing time.

There is also a genuine learning benefit. Typing the numbers in yourself teaches you the difference between a declared dividend, a gross payment, and the net amount that actually lands, faster than any article can, including this one. If you have never tracked dividends manually, doing it for a quarter is honestly worth the effort.

The trouble is that dividend portfolios grow in exactly the dimensions spreadsheets handle worst: more positions, more countries, more currencies, and more history. None of it breaks the spreadsheet on day one. All of it breaks the spreadsheet eventually.

Where the spreadsheet cracks

Withholding tax. Your US dividend typically arrives 15% lighter, the treaty rate, assuming your broker filed your W-8BEN; otherwise it's 30%. Every other country takes its own cut at its own rate. Gross numbers from the internet overstate what you'll actually see. You need net, per country, per position.

Currency. That $0.24 Apple dividend needs converting at the rate on the payment date, not today's rate. Multiply by four payments a year times every US position you own.

Changes. Dividends get raised, cut, and paused. Your spreadsheet knows nothing until you tell it. The moment you stop maintaining it, holiday, busy quarter, it silently rots.

History. "How much did I receive in 2024 vs 2025?" needs data entry going back years. Most spreadsheets start "from now" and never backfill.

A worked example: one dividend, five steps

Take a boring, common case. You are a European investor holding 100 shares of a US stock that pays $0.24 per share each quarter. The amount that lands in your account is not $24.

Step one, the gross amount: 100 × $0.24 = $24.00. Step two, US withholding tax at the 15% treaty rate: $3.60. Step three, the net dollar amount: $20.40. Step four, conversion to euros at the exchange rate on the payment date; at EUR/USD 1.094 that comes to about €18.65. Step five, whatever handling fee your broker applies to the currency conversion, if any.

Now suppose the W-8BEN was never filed and withholding ran at the default 30% instead. The same payment nets $16.80. Over a full year on this one position, that is gross dividends of $96.00 arriving as $81.60 at the treaty rate versus $67.20 without it, a difference of $14.40. Not ruinous. But you only notice it if your records show net amounts per payment, per country, which is precisely the level of detail manual spreadsheets tend to skip in favor of a gross yield copied from a website.

Multiply those five steps by four payments a year, by every foreign position you hold, and the pleasant ritual stops being pleasant.

What your broker already knows

Here's the thing: your broker's account statement contains every dividend you were ever paid, dated, taxed, in the original currency. The complete, correct history exists. It's just trapped in an export file nobody opens.

This is the part that makes manual dividend tracking feel faintly absurd once you notice it. You are re-typing, from memory or from confirmation emails, information that already exists in structured, machine-readable form, with the withholding and the currency conversion already applied by the people who executed the payment. The problem was never missing data. The problem is that the data lives in a CSV in your downloads folder, and a spreadsheet cannot read it unless you do the reading.

The maintenance bill nobody budgets for

Every manual system carries an invisible subscription fee, paid in attention rather than euros. For a dividend spreadsheet, the recurring work is: entering each payment as it arrives, checking announced dividend changes for every holding, updating share counts after every buy and sell (your projected income depends on them), and adjusting for the occasional special dividend, spin-off, or ticker change. Do all of that, every month, indefinitely, and the spreadsheet stays accurate.

Nobody does all of that every month indefinitely. The typical failure is not a broken formula, it is a quiet gap: the two months you skipped over the summer, the new position that never got a dividend row, the cut you didn't hear about because you don't read every earnings release. The spreadsheet keeps producing a total. The total is simply no longer true, and nothing in the file will tell you so. A wrong number that looks exactly like a right number is worse than no number at all.

When a tool wins

If you hold three dividend stocks, keep the spreadsheet, sincerely, it's fine. The tool starts winning when you hold ETFs and foreign stocks (currency + tax math), when you want projected income (which needs live dividend data per holding), or when you want history without archaeology.

There is a scale argument underneath this. Dividend complexity grows multiplicatively, positions times payments times currencies times withholding rates, while your patience grows not at all. A tracker also survives the events that quietly kill spreadsheets: switching brokers, holding accounts at more than one broker, and the simple passage of time. And if your dividends arrive in several currencies, the conversion question alone is a reason to automate; we've written separately about multi-currency portfolio tracking and why "just track everything in dollars" quietly undercounts.

The honest comparison

Cost. The spreadsheet is free in money and expensive in time. A tracker is the reverse. Which is cheaper depends entirely on what your evenings are worth to you, an input most people set to zero and shouldn't.

Accuracy. The spreadsheet is as accurate as your last update. A tracker built on broker statements is as accurate as your last upload, and an upload takes a minute, whereas an update takes an evening.

Control. The spreadsheet wins, genuinely. You can model anything in a spreadsheet, dividend growth scenarios, yield-on-cost pet theories, color coding of dubious usefulness, and no tool will ever match that flexibility. If tinkering is the part you enjoy, keep a spreadsheet on top of clean data, not instead of it.

History. The tracker wins by default, because your broker's files carry the full record back to your first trade and the spreadsheet starts whenever you started caring.

Pick based on which of these you actually value, not on which one feels more virtuous.

What the automated version looks like

BullBenchmark reads dividends straight from your broker statements, net, converted, dated, and adds the forward view: expected payouts for the next twelve months based on current holdings. The spreadsheet you meant to maintain, maintaining itself.

Because it works from export files rather than a live connection, there is no broker login to hand over, a distinction we care about enough to have written about separately. You download the statement, you upload the statement, and the dividend history assembles itself, including the years you never got around to backfilling.

The first week of BullBenchmark is free, no card, upload the export you just downloaded and see where you stand.

Related: The dividend calendar, decoded