Back to brokers & apps

Hargreaves Lansdown

How to import account summary as opening balance

You can import your current holding summary in to Sharesight following Read this help guide the step-by-step instructions below.

1 - Download your Hargreaves Lansdown account summary as a spreadsheet file.

2 - Go to Gemini

3 - Upload the file.

4 - Copy paste the prompt below

Task
Column mapping & transformation rules
Column A – Opening balance date
Header: Opening balance date
Source: Spreadsheet created at row
Format: YYYY-MM-DD

Column B – Instrument code
Header: Instrument code
Source: Code column
Review the Ticker column. If a value is 2-4 letters (like BARC), treat it as a Ticker. If a value is 7 characters and alphanumeric (like B42NVC3), treat it as a SEDOL and map it to its corresponding ISIN.
Column C – Market code
Header: Market code
Determine stock exchange using the Instrument code column
Use Sharesight-supported market codes only:
https://www.sharesight.com/au/supported-stock-exchanges-managed-funds-mutual-funds/
If the Instrument code is an ISIN (fund), use the market code FundUK for GBP-denominated UK funds.
Mapping rules
If Instrument code is an ISIN → FundUK
If Instrument code is a ticker:
USD → NASDAQ or NYSE (choose the most appropriate based on the company)
GBP → LSE
No default or generic market codes are allowed (e.g. FUND, MUTUAL, OTHER)
Column D – Cost Base
Header: Cost Base
Source: Cost(£) column 
Column E – Quantity
Header: Quantity
Source: Units held column

5 - Click Export to Sheets > Open Sheets

Please review and confirm that the instrument code (ticker or ISIN) is correct before importing, as incorrect codes can result in trades being matched to the wrong investment. Fund names and descriptions may not uniquely identify a single security.

6 - Download the spreadsheet as .csv file

download as csv

7 – Login to Sharesight.

8 - On the Get your investments into Sharesight page, select the Upload a self managed CSV tile.

Get started

9 - Select Opening balances for each holding

10 - Click the Upload a file button.

11 – Select the file.

12 - Click import.

How to import new trades

You can manually add ongoing trades or email the contract note using steps below:

  1. Go to your Hargreaves Lansdown account

  2. Download the contract note as a PDF

  3. Email the trade confirmation to your portfolio email address

The trade should be added in the portfolio in 5 minutes.