Importing from interactive investor
Export your transaction history from interactive investor (ii) and import it to automatically build your portfolio records.
Last reviewed
Exporting your data from interactive investor
interactive investor allows you to download your transaction history as a CSV file from the My Accounts section. This export includes all trades, dividends, and account activity.
Downloading your transaction history
- Sign in to your interactive investor account at ii.co.uk
- Navigate to my accounts from the top navigation menu
- Select the account you wish to export (e.g. ISA, Trading, SIPP)
- Go to transaction history
- Set your desired date range using the date filters
- Click “Download” to save the CSV file to your computer
Supported formats and columns
The import wizard recognises interactive investor exports in CSV format by these column headings: date, description, price, quantity, type. The default currency is GBP.
Recognised transaction types
buy,purchase,regular investment,regular investment buy,regular buy: recorded as Buysell,sale: recorded as Selldividend: recorded as Dividendreinvestment: recorded as Dividend reinvestmenttransfer in: recorded as Transfer intransfer out: recorded as Transfer out
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
- Withholding tax with no matching dividend on the same date — not imported
- A number on this row could not be read — check it and add it by hand
Fee, platform fee, charge and annual charge rows are not transactions, so they are not added to your holdings. They are still captured: each becomes an account charge you can see against the account. A row with only a Credit value, or one described as a refund, is set aside instead of being booked as a further charge. Stamp duty rows are recorded as a transaction tax.
Cash interest and any other row type, including corporate actions, are set aside rather than imported. The review step lists each one with the reason it was left out, so nothing disappears without being shown to you.
Step-by-step import
Once you have your interactive investor CSV file ready, follow these steps to import it:
- Open Import statements in the sidebar, under Estate & assets → Portfolio
- Drag and drop your ii CSV file, or click to browse
- The system will automatically detect the interactive investor format and parse your transactions
- Review the parsed transactions: rows that need attention carry a confidence badge
- Resolve any flagged items (e.g. unrecognised SEDOLs or ambiguous descriptions)
- Confirm the import to create your transaction records
Screenshot, for illustration only




Cost line-item extraction
interactive investor prints its charges as their own settlement rows rather than as columns on a trade row, so they cannot be attached to an individual trade. Platform fees and annual charges become account charges, which appear under Account Detail once the import completes. Stamp duty becomes a transaction tax recorded against the statement.
Common issues
Prices in pence vs pounds
interactive investor may display share prices in pence (e.g. 1250p) rather than pounds (e.g. £12.50) for UK-listed equities. Where the price ends in a p, it 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 p, and you can correct it there.
Debit and credit columns
Unlike many brokers that use a single amount column, interactive investor separates transaction values into Debit and Credit columns. Whichever of the two carries a value becomes the amount of the transaction, so a purchase takes its debit and a sale its credit.
SEDOL identifiers
interactive investor uses SEDOL (Stock Exchange Daily Official List) codes rather than ticker symbols. SEDOLs are seven-character alphanumeric identifiers used primarily for UK and Irish securities. The SEDOL is carried through as the security identifier when we look the holding up. If it is not recognised, you can manually select the correct security during review.
Fund and investment trust names
Fund names on interactive investor may differ from their official names (e.g. abbreviated or platform-specific names). The SEDOL column is used as the primary identifier, so name differences do not affect the import. If a fund cannot be matched by SEDOL, the description field is used as a fallback.
Data security
Your uploaded files are processed using our self-hosted document processing system. Your financial data never leaves our servers without your approval. The file itself is kept in your document vault so you can open the original statement alongside the imported rows, and you can delete it from there whenever you wish.
Before you import
Dedicated reader: interactive investor files are read by a reader built for their layout, without AI.
These parts of the Statement import guide apply to every broker:
- Which files work: file types, size limit and plans
- Which statement to download: history, holdings or both
- Password-protected files: what we ask for and what we keep
- Number and date formats: decimal commas and day-first dates
- Currencies: base currency, statement rates, pence
- Checking your import: totals, holdings differences, gaps and duplicates
- Undoing an import: removing what one file added
- Fixing problems: what each import message means
Related pages
- Statement import overview: General guide for all supported brokers
- Portfolio transactions: Managing and editing your transaction history
- Portfolio overview: Understanding your portfolio dashboard
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
