Importing from Hargreaves Lansdown

Export your HL transaction history as CSV and import it to automatically build your portfolio records.

Last reviewed

Exporting your data from Hargreaves Lansdown

Hargreaves Lansdown allows you to download your transaction history as a CSV file from your online Client Area. Each account (ISA, SIPP, Fund and Share) must be exported separately.

How to export

  1. Sign in to your client area at www.hl.co.uk
  2. Navigate to My Accounts and select the account you wish to export
  3. Click “Download transactions”
  4. Choose CSV as the file format
  5. Select the date range you wish to include
  6. Click “Download” to save the file to your computer
If you hold multiple accounts with HL (e.g. Stocks & Shares ISA and a SIPP), you will need to export and import each account separately. The import wizard handles each file independently.

Supported formats and columns

The import wizard recognises Hargreaves Lansdown exports in CSV format by these column headings: description, quantity, trade date, transaction category, value. The default currency is GBP.

Recognised transaction types

  • buy, purchase, switch in: recorded as Buy
  • sell, sale, switch out: recorded as Sell
  • dividend, distribution, income distribution: recorded as Dividend
  • reinvest, reinvestment: recorded as Dividend reinvestment
  • transfer in: recorded as Transfer in
  • transfer out: recorded as Transfer out
  • stock split: recorded as Stock split
  • bonus issue: recorded as Bonus issue
  • coupon: recorded as Coupon
  • accrued interest paid: recorded as Accrued interest paid
  • accrued interest received: recorded as Accrued interest received
  • redemption, maturity: recorded as Redemption

Costs

This export has no per-trade cost column, so no dealing charges are read from it.

Rows set aside

Some rows are recognised but not imported. The review step lists each one and why:

  • Unrecognised action — not imported
  • Cash transaction — not currently imported
  • Date could not be read — not imported
  • A number on this row could not be read — check it and add it by hand

Anything else in the Transaction Category column, including cash interest, platform charges and other corporate actions such as rights issues and mergers, is set aside rather than imported. The review step lists each one with the reason it was left out.

PDF statement support

HL statements can also be uploaded in PDF format. The import wizard supports PDF extraction using our self-hosted document processing system. Your financial documents never leave our servers without your approval. However, CSV is recommended for the most accurate and fastest import.

Step-by-step import

Once you have your HL CSV or PDF file ready, follow these steps to import it:

  1. Open Import statements in the sidebar, under Estate & assets → Portfolio
  2. Drag and drop your HL file, or click to browse (CSV or PDF supported)
  3. The system will automatically detect the HL format and parse your transactions
  4. Review the parsed transactions: rows that need attention carry a confidence badge
  5. Resolve any flagged items (unrecognised securities, low-confidence rows, or pence/pound discrepancies)
  6. Confirm the import to create your transaction records

Screenshot, for illustration only

The broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs toThe broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs to
The broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs toThe broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs to
The importer on its first step, upload, where you say what kind of statement it is, whose it is and which account it belongs to.
HL exports may include platform charges, annual management fees, and cash interest alongside your trades. These are kept out of your transaction history, and the review step lists them so you can see what the file contained. To record the charges themselves against your account, upload the PDF monthly statement, which itemises them.

Cost line-item extraction

The HL transaction CSV carries no per-trade cost columns: dealing commission and stamp duty reserve tax appear only on the PDF contract note, and platform fees and the annual management charge only on the PDF monthly statement. To capture itemised costs, upload the relevant PDF as well. Our document extraction system reads each charge and files it under the right cost type.

See Understanding investment costs (opens in a new tab) for how each cost affects cost basis in each supported jurisdiction.

Common issues

Prices in pence rather than pounds

HL often quotes UK share prices in pence (GBX) rather than pounds (GBP). For example, a share priced at 1,250p rather than £12.50. Where the Unit Cost column is marked (p), the price is divided by 100 so it lands in pounds. If a price looks unusually high during review, it may be a pence value that carried no such marker. You can correct it manually during the review step.

No structured ticker symbols

Unlike some brokers, HL does not include ticker symbols or ISIN codes in its CSV exports. Securities are identified by description only (e.g. “Fundsmith Equity Fund I Acc”). The import wizard uses fuzzy matching to identify the correct security from the description. If a match cannot be determined automatically, you will be prompted to select the correct security during review.

Mixed account types

If you export from multiple HL accounts (ISA, SIPP, General Investment Account), import each file separately and use the account selector at upload to say which account it belongs to. Rows are still checked against your other uploads, so a trade that appears in two files is flagged rather than counted twice.

Reinvested dividends

HL records a reinvested dividend as its own category, which is imported as a reinvestment rather than a plain dividend. Where HL also prints a matching buy row for the shares acquired, both rows appear in review. They hold different amounts, so they are not treated as duplicates of one another. Remove whichever you do not want to keep before confirming.

Before you import

Dedicated reader: Hargreaves Lansdown files are read by a reader built for their layout, without AI.

These parts of the Statement import guide apply to every broker:

Related pages

Can’t find what you’re looking for?

Our support team is here to help. Contact us and we’ll get back to you as soon as possible.

Contact us

We use cookies to improve your experience. See our Cookie policy (opens in a new tab) for details.