Dividends

Dividend tracking: spreadsheet or tool?

Most dividend investors build a spreadsheet at some point: ticker, shares, dividend per share, and a SUM at the bottom. It works well for a small portfolio, and it stops being maintained as the portfolio grows.

The question in this article is when the upkeep of a manual dividend ledger costs more than software that reads the same figures from your broker's files, and what breaks first. The short answer is that a spreadsheet holds up for a few domestic stocks and breaks first on withholding tax, currency conversion and history.

The sections below cover what the spreadsheet does well, where it breaks, what maintaining it involves, and how the two options compare on cost, accuracy, control and history.

What the spreadsheet does well

A small dividend portfolio is a small bookkeeping problem. Three stocks with four payments a year each is twelve rows. You know every position because you chose every position, and entering a dividend takes thirty seconds.

There is also a learning benefit. Typing the numbers in yourself teaches you the difference between a declared dividend, a gross payment and the net amount that lands in your account, faster than any article can. If you have never tracked dividends by hand, one quarter of doing so shows where those differences come from.

Dividend portfolios grow in the dimensions a spreadsheet handles worst: more positions, more countries, more currencies and more history. None of that breaks the spreadsheet on day one. Each of them adds work every month, until the file is no longer kept up.

Where the spreadsheet breaks

Withholding tax. A US dividend typically arrives 15% lower, the treaty rate, if your broker filed your W-8BEN. Without that form the rate is 30%. Every other country withholds at its own rate, so gross figures from a website overstate what you receive. You need the net amount, per country, per position.

Currency. A $0.24 Apple dividend has to be converted at the exchange rate on the payment date, not at today's rate. That is four conversions a year for every US position you own.

Changes. Dividends are raised, cut and paused. The spreadsheet does not know until you enter the change. After a holiday or a busy quarter the totals are out of date, and nothing in the file shows it.

History. A question like how much you received in 2024 compared with 2025 needs data going back years. Most spreadsheets start on the day they were created and are never backfilled.

A worked example: one dividend in five steps

Take a 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 less than $24.

The gross amount: 100 × $0.24 = $24.00.
US withholding tax at the 15% treaty rate: $3.60.
The net dollar amount: $20.40.
Conversion to euros at the exchange rate on the payment date. At EUR/USD 1.094 that is about €18.65.
Any fee your broker charges for the currency conversion.

Now suppose the W-8BEN was never filed and withholding ran at the default 30%. The same payment nets $16.80. Over a full year on this one position, gross dividends of $96.00 arrive as $81.60 at the treaty rate and as $67.20 without it, a difference of $14.40.

You only see that difference if your records show net amounts per payment and per country. That is the level of detail a manual spreadsheet tends to skip in favor of a gross yield copied from a website.

Multiply those five steps by four payments a year and by every foreign position you hold. That is the work the spreadsheet asks of you every quarter.

What your broker already knows

Your broker's account statement contains every dividend you were ever paid, with the date, the tax withheld and the original currency. The complete history exists. It sits in an export file that most people never open.

Manual tracking means re-typing, from memory or from confirmation emails, information that already exists in machine-readable form. The withholding and the currency conversion were already applied by the broker that executed the payment. The file is a CSV in your downloads folder, and a spreadsheet cannot read it unless you do the reading.

What maintaining the spreadsheet involves

A dividend spreadsheet stays accurate as long as four things are done every month.

Enter each payment as it arrives.
Check announced dividend changes for every holding.
Update share counts after every buy and sell, because projected income depends on them.
Adjust for the occasional special dividend, spin-off or ticker change.

Few people do all of that every month for years. The typical failure is a gap rather than a broken formula. Two months are skipped over the summer, a new position never gets a dividend row, or a cut goes unnoticed because nobody reads every earnings release.

The spreadsheet keeps producing a total, and nothing in the file shows that the total is no longer correct.

When a tool pays off

With three dividend stocks, the spreadsheet does the job. A tool starts to pay off when you hold ETFs and foreign stocks, which add currency and tax arithmetic, when you want projected income, which needs current dividend data per holding, or when you want history without reconstructing it from old statements.

The work grows multiplicatively, positions times payments times currencies times withholding rates. A tracker also survives the events that end most spreadsheets, such as switching brokers, holding accounts at more than one broker, and a few years passing.

If your dividends arrive in several currencies, every payment needs its own conversion at the rate of its payment date. Multi-currency portfolio tracking explains why converting at today's rate instead of the rate on each payment date changes your numbers.

How the two compare

Cost. The spreadsheet is free in money and costs time. A tracker is the reverse. Which is cheaper depends on what an evening of data entry is worth to you.

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

Control. The spreadsheet wins. You can model anything in it, from dividend growth scenarios to yield on cost, and no tool matches that flexibility. If modelling is the part you enjoy, a spreadsheet can sit on top of clean exported data rather than replace it.

History. The tracker wins, because your broker's files carry the full record back to your first trade, and the spreadsheet starts on the day you created it.

Which of the four weighs most for you? The answer tends to change as the number of positions, countries and years grows.

What the automated version looks like

BullBenchmark reads dividends from your broker statements, net, converted and dated, and adds a forward view: expected payouts for the next twelve months based on your current holdings. You download the statement, you upload it, and the dividend history is rebuilt, including the years you never backfilled.

Because it works from export files rather than a live connection, there is no broker login to hand over. That distinction is covered in why we'll never ask for your broker login.

BullBenchmark reads the transaction export from your broker and shows your return next to the S&P 500 and the Nasdaq 100, fed with the same deposits on the same dates, in your own currency. The first two weeks are free and no card is needed.