What should you download from Hargreaves Lansdown?
A transaction history for each account (Fund and Share Account, Stocks and Shares ISA, SIPP), downloaded as a CSV or spreadsheet, covering the period since your first deal. Sign in, open the account and look for its transaction or portfolio history, where HL offers statements and downloads. Menu names change; check HL's help centre for the current steps.
HL's quarterly investment reports (PDF) also work: your AI can read them, though a CSV is quicker and is the format Worthbase's tests cover.
Which columns does Worthbase use?
The export starts with a few lines of account details (client name, number and date range) before the header row. The columns are Trade date, Settle date, Reference, Description, Unit cost (p), Quantity and Value (£). The quirks:
- Prices in pence.
Unit cost (p)of9,850.00means £98.50 a share. Your AI records the price in pounds. - Charges inside the value.
Value (£)is what you paid or received, including dealing charges. Your AI works out the charge as the difference from units times price, and Worthbase adds it to the cost base of a buy or takes it off the proceeds of a sale. - References tell you the type. Deals start with
B(buy) orS(sell). Rows such as the account management fee aren't trades; your AI can record fees separately if you want them tracked. - Day-first dates, such as
20/06/2025. The trade date is used, not the settlement date.
What should you ask your AI?
Here's the transaction history (CSV) for my Hargreaves Lansdown Fund and Share Account. Add the deals to that account in Worthbase, converting prices from pence to pounds. Check the closing holdings against my HL portfolio and show me the preview before saving.
What does the preview show?
New holdings, the number of buys and sells, rows already recorded (skipped as duplicates, matched on HL's reference), conflicts, warnings, and the realised gain or loss on each sale. Nothing is saved until you approve.
How do you check the import?
Compare units per holding with your HL portfolio. If they don't match, the usual cause is a deal or corporate action outside the export's date range, or a transfer in from another provider.
Questions
Does Worthbase connect to my HL account?
No. Worthbase never asks for broker logins. You download the file and your AI reads it.
Should I import my ISA and SIPP too?
You can import their trades the same way, or record each one by its balance from a statement. Either way they count in your net worth.
Hargreaves Lansdown is a trademark of its owner; Worthbase isn't affiliated with it.
