How to Track Dividends: A Complete Guide for Investors (2026)

To track dividends, record every payment with date, amount, source, currency, withholding tax, and reinvestment status. You can do this three ways: a spreadsheet (Excel or Google Sheets), your broker's built-in tools, or a dedicated dividend tracker like Capitally, Sharesight, or Snowball Analytics. Spreadsheets work for fewer than ~10 holdings; brokers cover their own accounts only; a dedicated tracker is the only option that consolidates everything across multiple brokers, currencies, and asset classes.

Without proper tracking you fly blind: missed payments, sloppy tax reporting, no DRIP visibility, and zero ability to forecast future income. With it, dividend investing becomes a measurable wealth-building system.

TL;DR

• Why track: missed payments, tax inefficiency, bad reinvestment decisions, no income forecast
• 3 ways to track: spreadsheet (manual, free), broker dashboard (auto, but locked to one broker), dedicated tracker (auto, multi-broker, full feature set)
• What to look for: auto import, dividend calendar, DRIP, withholding tax, multi-currency, yield on cost, forecasting
• Best for most investors: Capitally (privacy + tax accuracy + DRIP), Sharesight (global automation), Snowball Analytics (analytics-heavy)

Why track dividends? (and what you lose if you don't)

Why some investors consistently outperform while others stagnate often comes down to how seriously they track their portfolio. Without dividend tracking you expose yourself to four real costs:

• Missing payments. Dividends arrive on different schedules across stocks, brokers, and currencies. Without a calendar you'll miss the ones that didn't show up — and missed payments often mean dividend cuts you discovered too late.
• Tax inefficiency. Qualified vs ordinary, withholding tax on international stocks, taxable vs tax-advantaged accounts — without records you overpay every April. For US investors with international holdings, the foreign tax credit alone can be worth thousands.
• Bad reinvestment decisions. No DRIP visibility, no yield-on-cost data, no clue which positions are actually compounding. You re-buy underperformers and skip the workhorses.
• No income forecast. You can't plan retirement or financial independence around income you can't measure. Forward-looking dividend forecasts answer "how much will I get next year?" — which is the only number that actually matters for FI.

Tracking turns dividend investing from collecting random cash into a system you can optimize.

What you gain when you track properly

1. Master-level control

When you track meticulously, you see which positions are workhorses and which are dead weight. That informs:

• Which holdings to add to (the actual income drivers)
• Which to exit when they stop raising the dividend
• How cash dividends are diversified across sectors and currencies

2. Tax optimization

Dividends are taxed differently depending on type, account, and jurisdiction. Per the IRS Form 1099-DIV instructions, qualified dividends are taxed at long-term capital gains rates while ordinary (non-qualified) dividends are taxed as regular income — a difference that can move thousands of dollars per year for active dividend investors. Proper tracking lets you:

• Separate qualified vs ordinary dividends for accurate filing
• Track withholding on international stocks (and reclaim it where treaties allow)
• Plan strategic moves between taxable and tax-advantaged accounts

3. Income forecasting

The biggest upside of dividend tracking is being able to project future income with real accuracy. That becomes critical when you:

• Approach retirement and need predictable cash flow
• Set financial independence numbers
• Decide between reinvesting dividends and taking income

With a clear view of yield, growth rate, and payment schedule, the forecast stops being a guess.

How to track dividends — 3 methods

There are three legitimate ways to track dividends. Each works for a different type of investor — but the limitations of each matter.

Method 1: How to track dividends in a spreadsheet (Excel or Google Sheets)

The cheapest option (free) and the one most investors start with. Works fine until your portfolio grows past a handful of positions.

What to set up:

3-step setup:

1. Create the column structure above in Excel or Google Sheets
2. Manually enter every dividend payment (or use =GOOGLEFINANCE() for live data — Excel needs a paid add-in like Wisesheets)
3. Add summary formulas: total annual income, average yield on cost, sector breakdown, dividend calendar by month

What spreadsheets do badly:

• No auto-update. Every payment, every split, every special dividend is manual entry.
• Ex-dividend dates are manual. Miss one and you lose the next payment.
• Currency conversion is manual. A multi-currency portfolio gets messy fast.
• No reliable forecasting. Future income projections require complex DGR formulas you'll have to build by hand.
• Errors compound. A typo in one row can throw off yield-on-cost across multiple positions.

Spreadsheets work fine for fewer than ~10 holdings in a single currency. Past that, they break — slowly, then all at once. For a deeper comparison see Capitally vs Excel.

Method 2: How to track dividends with your broker

Most major brokers have some dividend tracking built in. The catch: each one only covers its own accounts, and the depth varies wildly.

How to track dividends on Robinhood: Robinhood shows received and pending dividends under History → Dividends, including the scheduled date and amount for upcoming payments. What it doesn't have: a true forward-looking calendar, growth-rate-based projections, withholding-tax breakdowns, or any multi-account view. Fine for casual use; thin for serious planning.

How to track dividends on Fidelity: Fidelity has the strongest broker-built dividend tools — dividend history, projected income, basic dividend calendar. US-focused. Doesn't see your Schwab or Vanguard accounts. Tax handling is solid for US qualified dividends, weaker on international.

How to track dividends on Schwab: Similar to Fidelity. Schwab supports DRIP enrollment per position, shows dividend history, has a basic income summary. Strong for US investors with everything at Schwab; nothing for multi-broker households.

How to track dividends on Vanguard: Minimal tooling. Dividend history is available; no calendar, no projections. Most Vanguard customers end up exporting to a spreadsheet or a third-party tracker.

How to track dividends on E*Trade / Merrill / others: Basic dividend history. Wide variation in quality.

What broker-built trackers do badly:

• Locked to one broker. If you have any other account — even a 401(k) at an old employer — you don't see the full picture.
• No multi-currency support for non-US investors with global holdings.
• Limited projections. Most show only what's announced, not estimates based on growth rates.
• Tax handling stops at qualified vs ordinary. Foreign withholding, treaty reclaims, and tax-lot specific identification are usually missing.
• You can't switch brokers without losing history.

What about Yahoo Finance? Yahoo Finance shows historical dividends per stock and has a basic dividend screener, but it doesn't track your dividends — there's no portfolio import, no payment calendar, and no income totals. Use it for research, not tracking.

Method 3: How to track dividends with a dedicated dividend tracker (recommended for most investors)

A dedicated dividend tracker imports transactions from any broker, handles every currency, calculates every metric, and projects future income. This is what serious dividend investors use.

What a dedicated tracker does that brokers and spreadsheets don't:

• Auto-imports transactions from any broker (CSV, API, or supported integrations)
• Multi-broker, multi-currency, multi-account in one consolidated view
• Dividend calendar showing exactly when each payment arrives
• Withholding tax handling for international stocks
• DRIP support so you see compounding effects in real time
• Yield on cost calculated across every purchase (not just last)
• Forward income forecasting based on actual growth rates
• Sector and geographic breakdowns to spot concentration risk
• Tax export for year-end filing

The market for dividend trackers is crowded. Top options:

Top Capitally alternatives compared

For a head-to-head review of the leading dividend trackers, see the best dividend tracker review. Quick summary:

Decision shortcut:

• Want global automatic tracking with broker sync? → Sharesight
• Want privacy + tax accuracy + DRIP visibility? → Capitally
• Want a free starter? → Getquin (or Digrin if you're focused only on dividend growth)
• Want a mobile-first experience? → DivTracker
• Want everything in one place including budgeting? → Empower (US only)

What features should a dividend tracker have?

A useful dividend tracker should provide all of these. Anything missing means manual workarounds.

Before you track: discovering dividend stocks

Tracking is what you do after you've bought. To find quality dividend stocks in the first place, see the dividend investing strategies guide for beginners and how to evaluate dividend stocks.

Quick note on screeners and research tools you'll see referenced often:

• JustETF — strong screener for dividend ETFs, especially UCITS for European investors
• Dividend.com — proprietary DARS™ ratings, dividend safety scores, ex-dividend calendars
• MarketBeat — clean screener with yield/market cap/sector filters and dividend alerts
• Seeking Alpha — letter grades on dividend safety, growth, yield, consistency
• Morningstar — economic moat, stewardship, fair value estimates, dividend coverage analysis

Use these to find quality dividend payers. Use a tracker (above) to manage what you actually own.

Frequently asked questions

Your next steps

Pick the tracking method that fits where you are now:

1. 0–10 holdings, single currency: start with a spreadsheet using the column structure above
2. Single broker, simple US portfolio: use the broker's built-in tools, export quarterly to verify
3. Multi-broker, multi-currency, or aiming for FI: start with Capitally — free trial, no broker credentials required

Then read these in-depth comparisons to understand the dividend-tracker landscape:

1. Best Dividend Trackers — head to head review
2. Capitally vs Snowball Analytics
3. Capitally vs Sharesight
4. Capitally vs getquin
5. Capitally vs Excel

Once you've picked a tracker, work through the dividend metrics deep dive to make sure you understand what each number you're tracking actually means.

Good luck with your investments.