Hargreaves Lansdown Dividend Tracker: Track Your HL Dividend Income

If you hold income shares at Hargreaves Lansdown, you know roughly what they pay you, and you have probably never seen it laid out properly: income by month, by holding, over the years, against what you paid for each position. HL records every dividend it pays into your account, so the data exists. What HL does not provide is a Hargreaves Lansdown dividend tracker that turns those records into a view of your income. This guide covers where dividends live in HL, how to get them out, how to build an income history and a yield-on-cost figure, and how to see your income across an ISA, a SIPP and a Fund & Share Account together.

Where Dividends Appear in HL

Each dividend or fund distribution is paid into the cash balance of the account that holds the investment, and it appears as a row in that account's transaction history with the date, the payer and the amount. If you have chosen to reinvest income automatically, the reinvestment appears as a separate purchase row. That is the whole of HL's dividend reporting: a list of cash events, per account. There is no monthly income chart, no yield on cost, no forward view of what is due, and no total across accounts.

How to Export Your HL Dividends

The dividend rows come out with the rest of the transaction history.

• Log in at hl.co.uk and open the account (ISA, SIPP or Fund & Share).
• Go to Transaction history and set the date range to cover as many years as you want in your income history. Longer is better; a five-year income chart is far more useful than one year.
• Use the Download / Export option and choose CSV, or copy the table into Excel and save it.
• Repeat for each account that holds income investments.

In the file, dividend rows are identifiable by their description and by having a cash amount with no share quantity. Fund distributions from income units look the same. Purchases and sales are the other rows, and you want those too: yield on cost needs to know what you paid.

Skip the spreadsheet

Import your HL export and see your income by month

Upload the file as it downloaded. Openbook rebuilds your holdings, shows dividend income by month and by holding, works out yield on what you paid, and combines every HL account into one income view.

Import your portfolio →

Building an HL Dividend Income Spreadsheet

A workable income spreadsheet from the HL export has three parts.

• An income log. Filter the export to dividend and distribution rows, keep the date, payer and amount, and add a month column. A pivot table summing amount by month gives your income history; by payer gives your income by holding.
• A cost basis. From the purchase rows, sum the amount paid for each holding (remembering that HL quotes UK share prices in pence, so convert if you calculate from price and quantity rather than the amount column).
• Yield on cost. For each holding, the last twelve months of income divided by what you paid. This is the figure income investors should watch, because it tells you what your money is actually earning rather than what a new buyer would get today. Our dividend tracker guide explains why the two diverge so much for long-held positions.

Two HL-specific things to handle. Because the export has no ticker codes, income and purchases for the same holding have to be grouped by name, which is fine as long as HL has named them consistently. And if you hold the same income share in two accounts, remember to add them together on a summary tab, or your income by holding will be understated.

What a Dedicated Dividend Tracker Adds

• Income across every account. ISA, SIPP and Fund & Share Account combined, by month and by holding, without a summary tab to maintain.
• Yield on cost and current yield side by side, so you can see which holdings have grown into high earners and which have stopped.
• Dividend growth by holding, which is the leading indicator of a durable income and the thing a list of cash events hides.
• Concentration of income. How much of your income depends on your largest two or three payers. UK income portfolios built around names like Legal & General (LGEN), National Grid (NG.) and British American Tobacco (BATS) are often far more concentrated than their owners realise.
• Reward and Risk on every payer. Openbook scores UK and US-listed companies on Growth, Momentum, Profitability and Valuation for Reward, and Volatility, Financial Solvency, Operational Quality and Size for Risk. For an income investor the Risk side, and Financial Solvency in particular, is the early warning that a dividend may not be sustainable. The methodology explains each factor.

No card required

Set the income view up once

Create a free Openbook account, import your HL accounts, and your dividend income by month, yield on cost and income concentration are there each time you log in.

Create a free account →

Projecting Your Future HL Income

Once you know what each holding pays and what you paid for it, the natural next question is what the income becomes if you keep reinvesting. Our free dividend calculator projects income, yield on cost and portfolio value over time with or without reinvestment. Pair it with your actual HL income history and the projection starts from real numbers rather than a guess. For the mechanics of UK dividends, including ex-dividend and payment dates and how tax applies inside and outside an ISA, our guide to how UK dividends work is the place to start.

Dividend Dates: What HL Shows and What It Does Not

Every dividend has three dates that matter: the ex-dividend date, before which you must own the shares to receive it; the record date, when the register is checked; and the payment date, when the cash arrives. HL's transaction history records only the last of these, the day the money landed in your account. That is enough for an income history but not for planning. If you want to know what is due in the coming months, or whether a purchase you are considering will qualify for the next payment, you need the ex-dividend and payment dates from the company's own calendar. Our FTSE 100 dividend calendar and UK dividend calendar guides cover where to find them and how to read them, and a tracker that knows each holding's dates can show income due as well as income received.

Tax on HL Dividends: Why the Account Matters

Dividends paid into a Stocks & Shares ISA or a SIPP are free of income tax, and there is nothing to report. Dividends paid into a Fund & Share Account are taxable above the annual dividend allowance, at rates that depend on your income tax band, and you are responsible for reporting them. The allowance has been cut sharply in recent years, so income investors holding dividend shares outside a tax wrapper are increasingly likely to owe tax on them. Two practical consequences. First, sum the dividend rows from the Fund & Share Account export by tax year and keep the figure with HL's consolidated tax certificate. Second, if you are building an income portfolio, put the highest-yielding holdings inside the ISA first; the export makes it easy to see which account each payer sits in and how much income is exposed. Our ISA vs general account guide goes through the decision.

Common Problems Tracking HL Dividends

• Income and purchases not lining up. HL names holdings consistently, but a fund's income and accumulation versions are different holdings. Check the name.
• Reinvested dividends counted twice. Automatic reinvestment shows as a dividend row and a purchase row. Count the dividend as income and the purchase as cost; do not count the purchase as income.
• Yield on cost that looks too good. Usually the pence problem in the cost basis: a UK share bought at 250p recorded as 250 pounds. Use the amount column for cost, not price times quantity.
• Missing early years. Widen the export date range. The income chart is only as long as the history you export.

Bringing It Together

A dividend tracker earns its keep by answering three questions that a list of cash events cannot: is my income growing, what is it actually earning on the money I put in, and how much of it depends on a handful of companies. Once the HL export is in a tracker, those are one screen each. If you also hold income investments elsewhere, the same import takes AJ Bell, interactive investor and Trading 212 files, so your whole income picture ends up in one place.

Next step

See your HL income properly

Income by month and by holding, yield on cost, income concentration and a Reward and Risk score on every payer, across every HL account. Bring the export; the rest is done for you.

Open your portfolio →

You can Compare LGEN, NG, BATS side by side on Openbook, or find stocks with the screener.