DividendMapper
UKDividendTracking

What is a dividend tracker, and does every UK income investor need one?

A practical UK dividend tracker guide: what a dividend tracker does, when a free spreadsheet is enough, and when a dedicated tracker tool earns its place in an ISA, SIPP, or GIA wrapper mix.

11 min readUpdated 28 July 2026

A dividend tracker is a tool that records each dividend payment your portfolio generates and surfaces what that income means over time: yield on cost, dividend growth, the four dates that govern each payout, and tax-year allocation across your ISA, SIPP, and GIA wrappers. This guide covers what a UK dividend tracker must do to be useful, which approach fits which portfolio, and how to read the output.

If you searched for "dividen tracker" with a typo, you are in the right place. Everything below applies whether you typed it correctly or not.

What a UK dividend tracker must do

Five jobs matter. Everything else is decoration.

1. Record each payment, per wrapper, per tax year. Every dividend has a gross amount, a UK or foreign withholding-tax slice, a payment date, and a destination wrapper (ISA, SIPP, or GIA). A tracker that drops any of these columns breaks the self-assessment workflow at year end. The £500 dividend allowance (2026/27) only matters if you can see your total dividend income per tax year per wrapper in one place.

2. Show yield on cost and dividend growth per holding. Trailing yield tells you what the market is pricing now. Yield on cost tells you what your actual return is on the price you paid. For a position held five years with growing dividends, yield on cost is the number that compounds, not the trailing yield on a stock screener. A tracker that does not surface both is showing you a marketing metric, not your income.

3. Project the next 12 months of income, per month. Knowing what your portfolio pays you next month matters more than knowing what it paid last quarter. A good tracker maps ex-dividend dates against your holdings and produces a monthly forecast so you can plan cash flow, reinvestment, and pension contributions.

4. Capture the four dividend dates, not just the payment. The declaration date, ex-dividend date, record date, and payment date each tell you something different. None of the nine free tracker tools in the SERP explains this; a UK guide that omits the cycle leaves readers buying after the ex-div and wondering why they got no payout.

5. Reconcile UK-specific costs (SDRT, foreign WHT, dividend allowance) automatically. UK share purchases carry 0.5% Stamp Duty Reserve Tax that compounds against your cost basis. US dividends arrive 15% lighter once W-8BEN is filed, or 30% lighter without it. A tracker that ignores either of these shows a YoC trajectory that is fiction.

The four dividend dates, and why they are not the same

Most tracker pages mention "ex-dividend date" without explaining the rest of the cycle. A UK income investor who understands all four dates makes better buy timing decisions and reconciles payments against broker statements without guessing.

|| Date | Who decides | Why it matters for you | || :--- | :--- | :--- | || Declaration date | Company board | The first public signal. RNS announcement. Use it to plan purchases before the ex-div. | || Ex-dividend date | Set by the company, normally 1 business day before record date | Buy on or after this date and you miss the next payout. The price typically drops by the dividend amount on this date. | || Record date | Set by the company | Whose name is on the share register at close of business on this date receives the dividend. Brokers handle this for you. | || Payment date | Set by the company, typically 2 to 4 weeks after record date | Cash lands in your broker account. The only date that affects your cashflow. |

Worked example, Shell (LSE:SHEL) interim 2026:

Date (illustrative)Event
23 July 2026Declaration: $0.344 per share interim dividend announced
13 August 2026Ex-dividend date on LSE
14 August 2026Record date
21 September 2026Payment date, USD converted to GBP by your broker

If you buy Shell shares on 13 August or later, you do not receive the $0.344. The price on 13 August typically opens about $0.34 lower than the 12 August close. A tracker that only logs payment date hides the buy-timing decision entirely.

The dividenddata.co.uk ex-dividend calendar surfaces this data per EPIC across FTSE 100, FTSE 250, FTSE SmallCap, FTSE Fledgling, AIM, and Main Market. No free tracker does the same for your actual holdings.

SDRT, foreign WHT, and the £500 dividend allowance

Three UK-specific costs show up on every GIA dividend portfolio. Trackers that ignore any of them produce wrong YoC, wrong net income, and a wrong tax bill.

Stamp Duty Reserve Tax (SDRT), 0.5% on UK share purchases. Charged on the purchase price of UK shares bought in a GIA. Inside an ISA or SIPP, SDRT does not apply. Crucially, DRIP reinvestments inside a GIA also carry SDRT, which compounds against your cost basis over years. A position you have DRIP-ed for 6 years has paid SDRT on every reinvestment, and a tracker that ignores this shows a YoC that is too high. DividendMapper records SDRT against each trade lot and surfaces the cumulative figure per holding.

Foreign withholding tax (WHT) on US dividends, 30% default, 15% with W-8BEN. US-listed stocks (NYSE:KO, NYSE:JNJ, NYSE:PG, NYSE:MSFT) deduct US tax at source. Without a W-8BEN form on file with your broker, the default 30% applies and you cannot reclaim it. With W-8BEN, the rate drops to 15% under the US-UK double-tax treaty, and what arrives in your broker account is 85% of the gross dividend. A tracker that records "gross dividend" without the foreign-WHT slice shows a trailing yield and a YoC that are inflated by exactly the treaty-rate percentage.

£500 dividend allowance (2026/27). The first £500 of dividend income in a GIA in a tax year is tax-free. Above £500, basic-rate taxpayers pay 8.75%, higher-rate 33.75%, additional-rate 39.35%. ISA and SIPP dividends do not count against the £500. A tracker that does not split income per wrapper forces you to reconcile this by hand in February.

Worked example, £1,200 of GIA dividends from a US stock (illustrative):

StepFigure
Gross dividend$1,000.00
Less 15% US WHT (W-8BEN on file)$150.00
Net received in GBP (assume 0.79 rate)£671.10
Above £500 dividend allowance£171.10 taxable
Tax at 33.75% (higher-rate)£57.75
Net after UK tax£613.35

A tracker that ignores WHT shows £790 net. A tracker that ignores the £500 allowance shows £0 UK tax. Both are wrong.

A concrete 12-month dividend forecast

Most dividend tracker pages show inputs and outputs but no example. Here is what a 12-month forward cash-flow forecast looks like for a sample £50,000 ISA holding a mix of UK and US dividend payers.

Sample portfolio (illustrative):

|| Holding | Allocation | Yield | Annual income | || :--- | ---: | ---: | ---: | || LSE:NG. (National Grid, semi-annual) | 12% | 5.0% | £300 | || LSE:AZN (AstraZeneca, semi-annual) | 14% | 2.1% | £147 | || LSE:ULVR (Unilever, quarterly) | 10% | 3.4% | £170 | || LSE:VOD (Vodafone, semi-annual) | 8% | 6.8% | £272 | || NYSE:KO (Coca-Cola, quarterly) | 10% | 3.1% | £155 | || NYSE:JNJ (Johnson & Johnson, quarterly) | 12% | 3.2% | £192 | || NYSE:PG (Procter & Gamble, quarterly) | 8% | 2.4% | £96 | || LSE:SWDA (iShares Core MSCI World ETF, quarterly) | 16% | 2.0% | £160 | || LSE:IGLT (iShares Gilts ETF, semi-annual) | 10% | 4.0% | £200 | || Total | 100% | 3.4% blended | £1,692 / year |

Monthly forecast (after ex-dividend date mapping):

|| Month | Expected income | Notes | || :--- | ---: | :--- | || April | £138 | SWDA + IGLT ex-div | || May | £0 | Quiet month, no ex-divs in sample | || June | £192 | JNJ + PG ex-div | || July | £155 | KO ex-div | || August | £300 | NG. + AZN semi-annual | || September | £170 | ULVR + IGLT semi-annual | || October | £147 | AZN second interim | || November | £272 | VOD interim | || December | £160 | SWDA + KO | || January | £158 | ULVR + PG second quarterly | || February | £0 | Quiet | || March | £0 | Quiet | || Total | £1,692 | Matches annual projection |

USD-to-GBP exposure (illustrative, W-8BEN on file):

KO ($65 net of 15% WHT), JNJ ($192), PG ($96): US dividends gross $353, foreign WHT $53, net to wrapper £258. ISA wrapper, so no further UK tax.

The point of this table is not the numbers. The point is that a tracker which maps ex-dividend dates against your actual holdings produces a monthly cash-flow line you can plan around. A tracker that only shows "annual yield: 3.4%" gives you no insight into which months are heavy and which are dry.

| DividendMapper produces this monthly forecast for any ISA, SIPP, or GIA portfolio, with reinvestment assumptions toggleable per holding.

The ex-dividend calendar that powers this forecast deserves its own view, because the searcher who types "dividend tracker" is almost always trying to answer one question: when do my holdings pay me, and how do I see it. That comes next.

A 12-month ex-dividend calendar for a UK income portfolio

The sample portfolio from the previous section mapped to a real ex-dividend calendar for the next twelve months. Dates are illustrative and pulled from each company's published payment schedule as of mid-2026; an actual tracker refreshes these daily.

HoldingPayment cadence20262027
LSE:NG. (National Grid)Semi-annual, Aug / Feb interim + final21 Aug 202626 Feb 2027 (final), 20 Aug 2027 (interim)
LSE:AZN (AstraZeneca)Semi-annual, Mar / Sep interim + final15 Sep 2026 (interim), 26 Mar 2027 (final)14 Sep 2027 (interim)
LSE:ULVR (Unilever)Quarterly, Mar / Jun / Sep / Dec4 Jun 2026, 3 Sep 2026, 3 Dec 20264 Mar 2027, 3 Jun 2027
LSE:VOD (Vodafone)Semi-annual, Feb / Aug1 Aug 2026 (interim)5 Feb 2027 (interim), 1 Aug 2027 (interim)
NYSE:KO (Coca-Cola)Quarterly, Apr / Jul / Oct / Dec1 Jul 2026, 1 Oct 2026, 15 Dec 20261 Apr 2027
NYSE:JNJ (J&J)Quarterly, Mar / Jun / Sep / Dec10 Jun 2026, 10 Sep 2026, 10 Dec 202610 Mar 2027
NYSE:PG (Procter & Gamble)Quarterly, Feb / May / Aug / Nov15 May 2026, 15 Aug 2026, 14 Nov 202615 Feb 2027
LSE:SWDA (MSCI World ETF)Quarterly, Apr / Jul / Oct / Dec28 Apr 2026, 28 Jul 2026, 28 Oct 202628 Jan 2027 (actual paid Jan for Dec quarter-end)
LSE:IGLT (Gilts 0-5yr ETF)Semi-annual, Mar / Sep28 Sep 202629 Mar 2027

A tracker that surfaces this calendar visually (a horizontal "next 30 days" strip, then a month-by-month strip, then a year strip) lets you plan cash flow by sight rather than by calculation. Most UK tracker landing pages put exactly this calendar image as a hero feature; the editorial guide version of it is what appears above.

DRIP share-count growth, a worked example

When a dividend is reinvested rather than paid out, your share count grows. The growth compounds, and after five years a position held with DRIP looks meaningfully different from the same position held without DRIP. The maths is short and worth seeing.

Worked example, LSE:SHEL (Shell) DRIP, 5 years, 2021 to 2026:

|| Item | Figure | ||---|---| || Starting position | 1,000 shares, bought 1 July 2021 at £17.40 | || DRIP status | On, dividends reinvested at the payment-date price | || Interim dividends paid 2021-2026 | 4 payments totalling $1.49 per share | || Final dividends paid 2021-2025 | 5 payments totalling $1.95 per share | || Total cash dividends received (gross USD) | $3,444.00 over 5 years | || Reinvestment prices (illustrative, ex-div-adjusted) | ranged £14.20 to £28.60 | || Shares accumulated by reinvestment | 159 shares (varies by interim price) | || Ending position | 1,159 shares | || Yield on cost (5-year average dividend / original cost) | 7.9% | || Trailing yield at end of period (5-year average dividend / current price) | 4.4% |

Without DRIP, the same investor would have ended 2026 with 1,000 shares and roughly $3,444 of cash sitting in the broker account, uninvested. With DRIP, the cash has been deployed into 159 additional shares that will pay dividends themselves next year. The gap widens every year after.

A tracker that does not model DRIP either understates YoC (because it leaves reinvested dividends out of cost basis) or understates share count (because it leaves reinvested shares off the position total). Either error is structural.

How to import broker statements into a UK dividend tracker

The most common reason a UK investor abandons a tracker is that they cannot get their broker data in cleanly. The five UK brokers the DM reader is most likely to use have different export formats, different DRIP behaviour, and different quirks.

Hargreaves Lansdown

  1. Log into HL, go to Accounts, choose the relevant account (ISA / SIPP / GIA / Fund and Share Account).
  2. Click Statements and Activity, then choose Export. The CSV export covers the date range you select and includes per-trade lines, per-dividend lines, and per-FX-conversion lines.
  3. Open the CSV in a spreadsheet and confirm column headers before upload. HL uses Date / Type / Description / Quantity / Price / Value / Charges for trades and Date / Type / Description / Tax / Net Amount for dividends.
  4. Map the columns in your tracker. Sharesight, DividendMapper, and Snowball all have HL preset mappings.
  5. DRIP on UK shares: HL reinvests automatically into the same line. The dividend line shows as DIVIDEND with Quantity and Price zero; a separate BORDEREAUX trade line shows the reinvestment. Your tracker needs both lines to model the position correctly.

AJ Bell

  1. Log into AJ Bell YouInvest, go to Portfolio, then Activity.
  2. Export as CSV. AJ Bell's dividend lines include a Tax column for UK and foreign withholding tax separately.
  3. DRIP on UK shares: AJ Bell reinvests into the same line on payment date. The reinvestment shows as a Purchase trade with Type = Reinvestment. Your tracker matches the Purchase line against the prior Dividend line on date and ticker.
  4. Freetrade transfers into AJ Bell: AJ Bell preserves the cost basis from the originating broker; do not double-count the Freetrade purchase.

Trading 212

  1. Open Trading 212 app or web, go to History, choose the relevant account, then Export. The CSV covers trades, dividends, deposits, and transfers.
  2. Trading 212 DRIP behaviour is the caveat from earlier: US stocks do not DRIP, dividends land as cash and stay as cash. The export shows DIVIDEND lines with no matching reinvestment trade.
  3. If you hold both ISA and GIA sub-accounts in Trading 212, the export includes an Account column; map this to your tracker's wrapper field.

Interactive Investor

  1. Log into ii, go to My Accounts, choose the relevant account, then Activity, then Export.
  2. ii's CSV includes a separate line for the ii dealing charge and the ii platform fee per trade, both of which need to land in the trade-cost column.
  3. ii offers an optional auto-feed to Sharesight and DividendMapper for a small monthly fee, which removes the manual export step.

Freetrade

  1. Open Freetrade app, go to the relevant account (ISA / GIA / SIPP), then Activity, then Export.
  2. Freetrade's CSV includes GIA, ISA, and SIPP as separate accounts in the same export; map on the Account column.
  3. DRIP on UK shares: Freetrade reinvests for free. DRIP on US shares: limited at present, mostly cash held.

Common import mistakes

  • Forgetting to import the wrapper column. If your CSV has an Account or Wrapper column and the tracker does not pick it up automatically, every dividend goes into a single GIA bucket and your £500 allowance reconciliation breaks.
  • Double-counting on transfer. When shares move from one broker to another, both broker statements show a Transfer out and Transfer in pair. These cancel out on share count and cost basis; if your tracker treats them as a buy and a sell you double your cost basis and double your dividend count.
  • Mixing gross and net dividends. Some brokers (ii, HL) report the net dividend after withholding tax; others (AJ Bell US) report the gross dividend with the tax in a separate column. Set your tracker to gross by default and let it apply WHT separately.

Tracker comparison: what each UK tool actually does for £50,000

Six trackers a UK income investor typically considers, with the columns that matter for an ISA + SIPP + GIA portfolio at £50,000 total:

|| Tool | Free tier | Paid tier | UK wrapper support | SDRT against cost basis | W-8BEN 15% rate | Forward income calendar | DRIP / reinvestment | Mobile app | CSV / PDF tax-year export | ||---|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:| || Sharesight | 1 portfolio, 10 holdings | £30-£60 / year | ISA, SIPP, GIA, SSAS, JISA, Fund and Share Account | Yes (per-lot) | Yes | 3 years | Yes | No | Yes (HMRC format) | || DividendMapper | Limited preview | Subscription tiers, GBP billing | ISA, SIPP, GIA, with wrapper-level reporting | Yes (per-lot) | Yes | 12 months | Yes | Web + PWA | Yes (per wrapper, per tax year) | || Snowball Analytics | 1 portfolio, 1 broker | From £4.99 / month | ISA, SIPP, GIA | Partial | Yes | 12 months | Yes | Yes | Yes (CSV) | || DiviTrack (Trading 212 centric) | 1 portfolio, 100 holdings | £5.99 / month | ISA, GIA, Trading 212 only | No | Yes (UK and US) | 1 year | Yes (calendar export to iCal) | Yes | Yes | || TrackYourDividends | US-only free | $9.99 / month or $99.99 / year | US only (Plaid) | No | Yes | 2 years | Yes | Yes | Limited | || The Dividend Tracker | 10 holdings | From $5.95 / month | US, CA, UK (limited) | No | Yes | 2 years | Yes | Yes (iOS + Android) | Yes |

Total annual cost for a £50,000 three-wrapper UK portfolio

A worked example for a UK DIY investor with £50,000 split across an ISA (£25,000), a SIPP (£15,000), and a GIA (£10,000), holding 12 UK and 4 US stocks across two brokers:

|| Tool | Annual subscription | Free tier sufficient? | Notes | ||---|---:|:---:|---| || Sharesight Premium | £54 / year | No (need HMRC tax report and broker auto-feed) | Cheapest paid path for an investor who needs HMRC-format exports | || DividendMapper Standard | £48 / year | Yes for £50k with one broker | Single-tier subscription, no per-feature upsell | || Snowball Analytics Pro | £59.88 / year (£4.99 / month) | No | | || DiviTrack Premium | £71.88 / year (£5.99 / month) | Borderline (Trading 212 only) | Cheapest if everything is at Trading 212 | || TrackYourDividends Premium | £79.20 / year ($99.99) | No (US scope) | Not a real option for a UK multi-wrapper portfolio | || The Dividend Tracker Premium | £65.40 / year ($5.95 / month) | Borderline | UK support limited |

The cheapest UK-focussed path is a spreadsheet plus a £48 / year DividendMapper subscription for the HMRC-format exports at self-assessment time. The cheapest paid-only path is Sharesight Premium at £54 / year. Free tiers from every UK tool become useless once you add a second broker or a US stock.

The point of this table is not which tool wins. It is that a searcher evaluating "dividend tracker UK" cannot get this comparison anywhere else. The Sharesight vs DividendMapper page goes deeper on those two specifically.

The three UK approaches

1. Spreadsheet (free, manual)

A structured spreadsheet is the right tool for a single-broker, buy-and-hold ISA of 5 to 15 UK stocks. It is free, you own your data, and the fields can be exactly what you need.

Columns a UK dividend tracker spreadsheet needs:

  • Ticker (or EPIC for LSE-listed names), number of shares, purchase price, broker, wrapper (ISA / SIPP / GIA)
  • SDRT paid on the purchase lot (for GIA buys)
  • Payment date, gross dividend, foreign WHT, net received, currency of payment
  • Yield at time of payment, cumulative yield on cost
  • Per-tax-year running total per wrapper (6 April to 5 April)

Cost: zero. Time: 30 to 60 minutes per month for 10 stocks. Limit: cross-broker, multi-currency, and dividend-growth analytics become painful past 15 holdings or 2 brokers.

2. Broker-native dividend views (free, automatic)

Hargreaves Lansdown, AJ Bell, Trading 212, Interactive Investor, and Freetrade all show dividend income per holding with a running annual total. For an investor who holds everything at one broker and never needs to consolidate, this is often enough.

What broker tools miss:

  • No cross-broker consolidation. Two brokers means two views, no combined picture.
  • No yield-on-cost trending across the full portfolio.
  • No dividend-growth analytics.
  • No 6 April to 5 April tax-year allocation across wrappers.
  • No SDRT running total against cost basis.
  • No foreign-WHT tracking for US holdings (HL and AJ Bell show the gross only).

The moment you add a SIPP at a second broker, or hold a US stock alongside your UK ISA, your combined dividend picture is no longer visible in either platform.

UK broker import reality (August 2026):

BrokerCSV exportDRIP on US stocksReal-time ex-div alerts
Hargreaves LansdownYesYesNo
AJ BellYesYesNo
Interactive InvestorYesYesYes (paid)
Trading 212Yes (manual)No (cash held)No
FreetradeYesLimitedNo

Trading 212 does not DRIP US stocks: dividends land as cash. A tracker that assumes reinvestment on every holding will overstate YoC for Trading 212 users.

3. Dedicated dividend tracker (paid or freemium)

Tools like Sharesight, DividendMapper, Snowball Analytics, DiviTrack, and Nestor sit outside your broker. They import transactions, capture dividends automatically, and add analytics that broker-native views do not offer: yield on cost, dividend-growth rate, multi-broker consolidation, ex-dividend calendars, and forward income forecasting.

What to look for in a UK-focussed dividend tracker:

FeatureWhy it matters for UK investors
ISA / SIPP / GIA wrapper taggingWithout it, you cannot reconcile dividend income against the £500 allowance or self-assessment.
UK tax-year reporting (6 April to 5 April)Self-assessment runs to UK tax years, not calendar years. A tracker that reports per calendar year adds manual reconciliation.
UK and foreign withholding tax recorded separatelyUS dividends arrive with 15% WHT already deducted (or 30% without W-8BEN). SDRT applies to UK share purchases at 0.5%. Both must appear as their own columns for accuracy.
SDRT recorded against the cost basis lotDRIP reinvestments in a GIA carry SDRT. Without it, YoC drifts from reality over years.
W-8BEN treaty-rate awarenessRecords the 15% WHT on US dividends, not the 30% default. Catches broker mistakes.
DRIP / reinvestment handlingReinvested dividends must update your share count and cost basis, or yield on cost drifts from reality.
Ex-dividend calendar (next 12 months)Lets you forecast monthly income, plan cash flow, and time new purchases before or after the ex-div date.
Dividend-growth rate per holdingDistinguishes a 4% yielder with 8% annual dividend growth from a 6% yielder with flat or declining payouts.
Multi-broker importHL, AJ Bell, Trading 212, Interactive Investor, Freetrade, iWeb cover most UK DIY investors. Manual re-entry at one of these is the main reason trackers get abandoned.
Data export (CSV) and PDF tax-year reportYour data must come out cleanly. Lock-in is the silent risk of any third-party tracker.
UK pricing in GBP and UK support hoursUS-domiciled trackers in USD with US support hours create friction when a UK bug blocks your self-assessment.
Four dividend dates capturedDeclaration, ex-div, record, payment. Without declaration and record, you cannot reconcile against broker statements.

The Sharesight vs DividendMapper comparison goes deeper on where each dedicated tool fits.

For UK investors with a single-broker buy-and-hold portfolio of 5 to 15 stocks, a structured spreadsheet covers the essentials. The threshold for switching is not portfolio value but complexity: more than one broker, foreign holdings, DRIP modelling, or dividend-growth data feeding retirement projections.

How a UK tax-year dividend report should look

At self-assessment time you need a single view per wrapper per tax year. A good tracker exports this without manual reconstruction.

|| Tax year 2026/27 | Gross dividends | UK WHT | Foreign WHT | SDRT paid | Net to wrapper | || :--- | ---: | ---: | ---: | ---: | ---: | || ISA | £X,XXX | £0 | £0 | £0 | £X,XXX | || SIPP | £X,XXX | £0 | £0 | £0 | £X,XXX | || GIA | £X,XXX | £0 | £XXX | £XXX | £X,XXX | || Total taxable (GIA only) | £X,XXX | | | | £X,XXX |

The £500 dividend allowance (2026/27) applies only to dividends above the ISA and SIPP shields. A tracker that does not split gross, UK WHT, foreign WHT, and SDRT per wrapper forces you to rebuild this by hand in February.

DividendMapper exports this report as PDF and CSV per tax year per wrapper.

Bed & ISA, the 5 April dividend harvest

A UK-specific move that no free tracker surfaces: between 6 January and 5 April each year, you can sell a GIA holding and buy it back inside your ISA, a "Bed & ISA". The sale crystallises a capital gain but the repurchase moves the holding into the ISA shelter for future dividends.

Why the timing matters:

  • The 5 April ISA contribution deadline applies to subscriptions, not to holdings. You can move existing GIA holdings into your ISA at any time, but doing so between 6 January and 5 April lets you capture any ex-div dates that fall before 5 April in the ISA wrapper.
  • If your GIA dividend is expected to fall in March 2027 and your ISA has £8,000 of remaining allowance, selling and re-buying inside the ISA means the March dividend lands tax-free instead of as a GIA receipt that counts against your £500 allowance.
  • DividendMapper flags holdings where a Bed & ISA move would shelter the next expected dividend before 5 April.

A tracker that does not surface this is leaving a tax-saving lever on the table for anyone whose GIA dividend income exceeds £500.

DRIP and reinvestment tracking

When a dividend is reinvested rather than paid out, the tracker must update share count and cost basis, or yield on cost drifts from reality. DividendMapper treats reinvestment as a synthetic buy at the payment-date price, keeping YoC and dividend-growth-rate calculations consistent over time. Most UK broker views do not surface this at all, which is why long-held DRIP positions often show a stale cost basis in broker reports.

ETF total return with DRIP, a UK comparison (illustrative, 5-year period 2021 to 2026):

|| ETF | Initial £10,000 grew to | Annualised total return | || :--- | ---: | ---: | || LSE:VHYL (Vanguard FTSE All-World High Dividend Yield) | £14,830 | 8.2% | || LSE:VUKE (Vanguard FTSE 100 UK) | £13,210 | 5.7% | || LSE:IGLS (iShares UK Gilts 0-5yr) | £10,920 | 1.8% | || LSE:SWDA (iShares Core MSCI World) | £15,470 | 9.1% |

Total return includes price change plus reinvested dividends. The trailing yield alone understates each by the dividend component (typically 2 to 4 percentage points). A tracker that only shows trailing yield will not show you this.

Weekly and monthly payers, UK context. Most UK income investors target quarterly payers. Some US-listed names pay monthly or weekly (Realty Income monthly, some covered-call ETFs weekly). A tracker that assumes a single payment cadence mis-forecasts cash flow by weeks. DividendMapper supports custom payment-frequency overrides per holding.

Common dividend-tracking mistakes UK investors make

Ignoring FX on US-listed stocks. KO and JNJ dividends land in GBP at whatever rate applies on payment date. A tracker that ignores FX shows a misleading trailing yield and an inaccurate YoC trajectory. The GBP figure can move 5 to 10% year on year from FX alone.

Mixing gross and net yields. The headline yield on a stock screener is gross (before US WHT for US stocks, before UK income tax for GIA holdings). Your personal yield is the net amount that actually lands in your account, post-WHT and post-FX.

Ignoring special dividends and return-of-capital events. One-off dividends and return-of-capital distributions are not recurring income. Counting them in your annual dividend total inflates your sustainable-income estimate. A £0.50 special in one quarter is not a 5% annual yield.

Stale cost basis after DRIP. A position you have DRIP-ed for 6 years has a cost basis that includes reinvested dividends at each payment date, plus SDRT on each reinvestment lot in a GIA. A tracker that ignores either component shows a YoC that is too high by the reinvestment plus SDRT amount.

Missing the £500 dividend allowance reconciliation. Without a per-wrapper per-tax-year total, you discover the tax bill only at self-assessment. With it, you know in Q3 whether to harvest dividends into an ISA before 5 April.

Recording gross US dividends and ignoring W-8BEN status. If you filed W-8BEN, the rate is 15%. If you did not, it is 30%. Recording the wrong rate for the wrong broker means your tracker is wrong by 15% of every US dividend, every quarter.

When a spreadsheet is enough and when you need a dedicated tool

FactorSpreadsheet worksDedicated tool helps
Portfolio size5 to 15 holdings15 or more holdings
Number of brokers12 or more
Trade frequencyBuy-and-hold, few trades per yearRegular rebalancing or dividend reinvestment
Foreign holdingsUK onlyUS or other foreign stocks with FX conversion
DRIP enabledManual logging fineAutomated reinvestment across many holdings
Retirement planningNot yet projecting forwardUsing dividend-growth data for income forecasts
Time available30 to 60 min/month willing to spendWant to reduce tracking time to around 10 min/month
Tax-year reportingWilling to rebuild from broker statementsWant a one-click PDF per wrapper per tax year

Most UK income investors with a single-broker, buy-and-hold portfolio of 5 to 15 stocks can manage perfectly well with a structured spreadsheet. The moment you hold accounts at more than one broker, hold foreign stocks with DRIP, or want dividend-growth data for retirement planning, a dedicated tracker starts making sense.

How dividend tracking connects to retirement-income planning

The Retirement Income Calculator projects how much income your dividend portfolio could produce in future years, using Bear, Base, and Bull growth scenarios. The accuracy of those projections depends on your portfolio's actual dividend-growth trend, which only comes from sustained tracking.

A practical example: a UK investor holds 10 dividend-paying stocks across an ISA and a GIA.

Year 1: Starts a manual tracking spreadsheet. Records each dividend payment, updates yield on cost quarterly. Total tracking time: around 30 minutes per month. Dividend-growth data is too sparse to feed meaningful projections.

Year 2: Opens a SIPP at a second broker. Now tracking across three accounts. The spreadsheet is harder to maintain, and one ex-dividend date is missed. The dividend-growth record, while patchy, now covers enough time to estimate per-stock trends.

Year 3: Adopts a dedicated tracker that imports transactions and auto-captures dividend events. Tracking time drops to around 10 minutes per month. The tracker's dividend-growth data feeds the retirement calculator. Bear / Base / Bull scenarios are now anchored in real portfolio behaviour rather than assumed averages.

The threshold for switching from manual to automated tracking is not portfolio value but portfolio complexity: number of accounts, frequency of trades, whether the investor needs dividend-growth data for retirement planning, and whether they need a tax-year report per wrapper.

Frequently asked questions

What is the difference between dividend tracking and portfolio tracking?

Portfolio tracking monitors your total investment value: share prices, asset allocation, and overall return. Dividend tracking specifically measures income: how much each holding pays, when, and how that income is trending over time.

Do I need a paid dividend tracker as a UK investor?

Not necessarily. For a single-broker portfolio of 5 to 15 UK stocks, a well-structured free spreadsheet is sufficient. Paid trackers become valuable when you have multiple brokers, multi-currency holdings, or need dividend-growth analytics.

How does dividend tracking help with UK self-assessment?

Good tracking gives you a per-tax-year, per-wrapper breakdown covering the 6 April to 5 April cycle. At self-assessment time you know exactly how much dividend income fell in each ISA, SIPP, or GIA without reconstructing totals from broker statements.

What should a UK dividend tracker include for tax purposes?

It should record gross dividend, UK and foreign withholding tax deducted, payment date, and the wrapper it landed in. It should also flag total dividends against the £500 dividend allowance for the relevant tax year, plus SDRT on UK share purchases.

Does DividendMapper include DRIP and reinvestment tracking?

Yes. DividendMapper logs each reinvestment against the original lot, keeping your share count, cost basis, and yield on cost accurate as the position compounds.

Can I export a UK tax-year dividend report from DividendMapper?

Yes. DividendMapper produces a per-tax-year, per-wrapper dividend summary grouped by ISA, SIPP, and GIA, with gross, withholding tax, and net columns suitable for self-assessment.

What is the difference between ex-dividend date, record date, and payment date?

Declaration date is when the company announces the dividend. Ex-dividend date is the cutoff for who receives the next payout: buy on or after this date and you miss it. Record date (one business day after ex-div) is the share-register snapshot. Payment date is when cash lands in your broker account, typically two to four weeks later.

Does DividendMapper handle SDRT and W-8BEN treaty rates on US dividends?

Yes. UK purchases of UK shares carry 0.5% Stamp Duty Reserve Tax recorded against the trade lot. US-listed dividends are recorded with the W-8BEN treaty rate (typically 15%) as the foreign withholding tax, not the 30% default that applies without the form on file.

Which UK brokers can I import dividend data from into a tracker?

The five UK DIY brokers with the cleanest CSV exports are Hargreaves Lansdown, AJ Bell, Interactive Investor, Trading 212, and Freetrade. Each has different column headers, different DRIP behaviour on US shares, and a separate wrapper-tag column that must be preserved on import to keep ISA, SIPP, and GIA income distinct for self-assessment.

Which dividend tracker is cheapest for a £50,000 UK portfolio across ISA, SIPP, and GIA?

For a £50,000 split across an ISA, SIPP, and GIA, the cheapest UK-focussed path is a free spreadsheet plus a £48 per year DividendMapper subscription used to generate the HMRC-format tax-year export at self-assessment. The cheapest paid-only path is Sharesight Premium at £54 per year. Every UK tracker's free tier becomes unusable once you add a second broker or a US holding.

How does DRIP change my share count and yield on cost over five years?

A position held with DRIP for five years ends with more shares than a position held without. Worked example: 1,000 LSE:SHEL shares bought 1 July 2021 at £17.40, DRIP on for all 9 dividend payments through 2026, ends at 1,159 shares. Without DRIP, the same investor ends 2026 with the original 1,000 shares and roughly $3,444 of uninvested cash in the broker account.

What is an ex-dividend calendar and why does it matter for a UK dividend tracker?

An ex-dividend calendar lists the date by which you must own a share to receive the next dividend, plus the payment date when the cash actually lands in your broker account. A UK dividend tracker that maps ex-dividend and payment dates against your actual holdings produces a month-by-month cash-flow forecast you can plan around; a tracker that only shows trailing yield gives no insight into which months are heavy and which are dry.

Where to next

Disclaimer: This is for informational purposes, not financial or tax advice. Tax rates and allowances change. Check current HMRC guidance before making decisions.

This is not financial or tax advice. Allowances, rates and contribution caps change. Verify against gov.uk and your broker before acting.