How to Track Your ISA, SIPP and GIA in One Portfolio View

Most UK self-directed investors hold accounts across two or three platforms. A Hargreaves Lansdown SIPP opened years ago. A Vanguard Stocks and Shares ISA added later for the low charges on index funds. Perhaps an Interactive Investor dealing account for the flat-fee structure when the portfolio grew. Each platform shows its own slice of the picture. None shows the whole.

This guide gives you the exact steps to export your holdings from each of the four most common UK platforms and combine them into a single portfolio view — including the idiosyncratic Vanguard export process that every other guide omits.

TL;DR

• Viewing accounts separately hides concentration risk and tax-wrapper allocation mistakes that only become visible in aggregate.
• A consolidated view tells you your true position: what you actually own, in which wrapper, and whether your asset allocation reflects your intent.
• The fastest path: export CSVs from each platform using the steps below, then import to a consolidated tracker that maps accounts to tax wrappers automatically.
• Brokers covered: Trading 212, Hargreaves Lansdown, AJ Bell, Interactive Investor, and Vanguard UK.

Why you need one view across ISA, SIPP and GIA

The problem is not that you have multiple accounts. It is that you cannot see them simultaneously.

Consider a typical scenario: a Trading 212 ISA opened for its zero-commission dealing, a Hargreaves Lansdown SIPP accumulated over the years, and an Interactive Investor GIA for flat-fee trading as the portfolio grew. Each platform shows its own slice. Viewed separately, each account looks diversified. In aggregate, you may hold 60% of your net worth in large-cap US technology companies without knowing it. The ETFs have different names and different TERs, but the underlying exposure is nearly identical.

Beyond concentration, three practical risks compound over time:

Wrapper allocation mistakes. Growth assets belong in ISAs and SIPPs where gains accumulate tax-free. Interest-bearing assets may belong in GIAs depending on your personal allowance position. Holding your highest-growth assets in a taxable account while bond funds sit inside your ISA is a common and costly error — one that is invisible until you look at all three wrappers together.

Overlap. UK investors who diversify across platforms often inadvertently concentrate in the same underlying positions. Two LifeStrategy funds from different providers may share 70% of their underlying holdings.

Inaccurate asset allocation. Rebalancing decisions made on a single account basis are unreliable. You cannot rebalance a portfolio you cannot see.

The options: spreadsheet, tracker, or do nothing

A spreadsheet works. Plenty of experienced investors maintain meticulous Google Sheets models that calculate allocation, overlap, and currency exposure. The brittleness is the problem: one missed dividend reinvestment, one corporate action you did not capture, and the numbers drift. For investors with more than two platforms, manual maintenance becomes a part-time job.

HL's own portfolio view — accessible under the "Portfolio Analysis" tab — is excellent for what it does, but it only sees accounts held at HL. It is not a solution for the multi-platform problem.

Morningstar X-Ray requires manual entry of all positions and does not natively map to UK tax wrappers.

A dedicated consolidated tracker such as Invormed accepts CSV imports from all four platforms covered in this guide, maps holdings to their tax wrappers automatically, and maintains the aggregate view going forward. That is the fastest path to a reliable single picture.

How to export from Trading 212

Trading 212 is Invormed's lead broker integration — the two are partners, and the T212 importer is the platform's most refined integration. If your Trading 212 account is an ISA or an Invest (GIA) account, Invormed detects the wrapper type automatically from the exported file.

Export is available via the web platform at app.trading212.com.

Step 1. Log in and select History from the left navigation panel.

Step 2. In the History view, select Export (top right of the page).

Step 3. Choose your date range. For a full portfolio history, select from your account open date to today. Click Export CSV.

The file downloads immediately. Trading 212's CSV is notably clean by UK broker standards — it combines both transaction history and sufficient detail to reconstruct current holdings in a single file, rather than requiring separate holdings and activity exports.

Key columns in the T212 CSV: Action, Time, ISIN, Ticker, Name, Quantity, Price per share, Currency, Total, Currency (Total), Exchange rate, Result, Currency (Result), Withholding tax, Currency (Withholding tax), Transaction fee, Finra fee, Stamp duty, Notes, ID.

Invormed and Trading 212 are partners — the T212 importer is the platform's most polished integration, with automatic column mapping, wrapper detection (ISA vs Invest account), and full cost basis reconstruction from the transaction log.

How to export from Hargreaves Lansdown

HL offers a direct CSV download from the account summary page. The path varies slightly between the web platform and the mobile app; these instructions cover the web platform at online.hl.co.uk.

Step 1. Log in and navigate to My Accounts in the top navigation.

Step 2. Select the specific account you want to export (Stocks and Shares ISA, SIPP, or Fund and Share Account). Note that each account must be exported separately — HL does not provide a cross-account export in a single file.

Step 3. On the account page, select the Portfolio tab. You will see a table of your current holdings with market values.

Step 4. Scroll to the bottom of the holdings table. Click Download portfolio as CSV.

The downloaded file is named in the format portfolio_[account-type]_[date].csv. Key fields in the HL CSV:

• Stock — the holding name
• Sedol — the SEDOL identifier
• Units — number of units or shares held
• Price (p) — current price in pence
• Value (£) — current market value in sterling
• Cost (£) — your total cost basis
• Gain/Loss (£) and Gain/Loss (%) — unrealised P&L

The file does not include the account type (ISA, SIPP, GIA) in the data rows — only in the filename. When importing to a tracker, you will need to label each file by its wrapper type.

Repeat this process for each HL account you hold.

How to export from AJ Bell

AJ Bell operates two distinct platforms: YouInvest (the full-featured platform at ajbell.co.uk) and Dodl (their simplified app-only product). The export process differs between them.

AJ Bell YouInvest

Step 1. Log in to your YouInvest account at ajbell.co.uk and select My Portfolio from the account navigation.

Step 2. Within My Portfolio, select the account to export (ISA, SIPP, or Dealing Account).

Step 3. On the holdings view, look for the Download or Export option — displayed as a small icon or link below the holdings table. Select Download as CSV.

The YouInvest CSV includes:

• Investment name
• SEDOL / ISIN
• Quantity
• Current price
• Current value
• Book cost
• Gain/Loss

As with HL, each account type must be downloaded separately.

Dodl

Dodl is a simplified investing app with no web portal — it is mobile-only. As of 2026, Dodl does not offer a native CSV export function. To extract your holdings data, you have two options:

1. Manual transcription from the in-app holdings screen.
2. Contact AJ Bell support to request a data export under your GDPR data portability rights (Subject Access Request). This typically returns your transaction and holdings history as a structured file within 30 days.

If your AJ Bell account is on Dodl, switching to YouInvest (which is free to do) unlocks the full export functionality.

How to export from Interactive Investor

Interactive Investor distinguishes between a holdings export (current positions) and a transaction history export (all past trades). For a current portfolio snapshot, you want the holdings export.

Step 1. Log in at ii.co.uk and navigate to My ii in the main navigation.

Step 2. Select Portfolio from the My ii submenu. You will see your current holdings across all ii accounts on a single screen.

Step 3. Above the holdings table, select Download or look for the export icon. Choose Download holdings as CSV.

ii's holdings CSV fields include:

• Holding — investment name
• EPIC — exchange ticker (where applicable)
• ISIN
• Quantity
• Price
• Value
• Book cost
• Total return (£)
• Total return (%)
• Account type — notably, ii includes the account type (ISA, SIPP, Trading Account) in the CSV data rows, not just the filename

The inclusion of the Account type column is useful: a single ii export file can contain all your ii holdings across all wrappers, correctly labelled.

Transaction history is available separately via My ii → Activity → Download transactions. This produces a CSV with date, description, quantity, price, and settlement amount — useful for cost basis reconstruction but separate from the current holdings snapshot.

How to export from Vanguard UK

Vanguard UK's personal investor platform (vanguardinvestor.co.uk) does not offer a direct holdings CSV download button in the same way HL, AJ Bell, or ii do. This is the most commonly searched frustration among UK investors trying to aggregate their portfolios.

The options available as of 2026:

Option 1: Transaction history PDF or CSV (the workaround)

Step 1. Log in at vanguardinvestor.co.uk and navigate to My Portfolio from your account dashboard.

Step 2. Select Transaction history from the account menu.

Step 3. Set the date range to cover your full investment period and select Download or Export. Vanguard provides this as a CSV containing all buy and sell transactions, with fields including:

• Date
• Transaction type (e.g., Regular investment, Reinvestment)
• Fund name
• Amount (£)
• Units
• Price per unit (£)

This is a transaction log, not a current holdings snapshot. To derive current holdings from it, you sum units purchased minus units sold for each fund.

Option 2: Account statements

Vanguard UK generates quarterly PDF statements accessible under Documents in your account. These show current holdings with values but are not machine-readable without manual extraction.

Option 3: Use a tracker that ingests transaction history

Tools including Invormed accept Vanguard UK transaction CSVs and reconstruct current holdings and cost basis from the transaction log automatically. This is the most practical path for Vanguard account holders.

A note on Vanguard ISA vs general account: the transaction CSV does not include the account type in the column data. If you hold both a Vanguard ISA and a Vanguard general account, you will receive separate CSV files. Label them at download.

Combining them: mapping accounts to tax wrappers

Once you have your CSVs, you need to:

1. Label each file by wrapper type before combining: hl-sipp.csv, vanguard-isa.csv, ii-gia.csv.
2. Normalise the holding identifier — most platforms include ISIN or SEDOL, which you should use as the common key rather than fund names (which vary across platforms even for identical funds).
3. Map each holding to its wrapper — this is the step most spreadsheet approaches handle clumsily.
4. Reconcile overlapping positions — if you hold the same fund across multiple accounts, sum the units and calculate the blended cost basis.

A wrapper-mapped consolidated view lets you calculate:

• Total exposure by asset class (not just per account)
• Tax wrapper balance: what percentage of your total portfolio is sheltered in ISA/SIPP versus exposed in GIA
• Effective allocation vs intended allocation
• Unrealised gains by wrapper — relevant for CGT planning

Invormed accepts CSVs from all four platforms and maps each import to its tax wrapper automatically, handling the ISIN normalisation and overlap detection as part of the import process.

What you will actually see

A worked example: an investor holds £52,000 split across a Trading 212 Stocks and Shares ISA (£14,000), a Hargreaves Lansdown SIPP (£22,000), a Vanguard ISA (£11,000), and an Interactive Investor dealing account (£5,000).

In isolation, each account looks diversified. The T212 ISA holds a global equity tracker and several individual US equities, accumulated commission-free. The HL SIPP holds Fundsmith Equity and a global equity tracker. The Vanguard ISA holds LifeStrategy 80%. The ii dealing account holds a few UK equities and a technology sector ETF.

In aggregate, the picture is different:

• US equity exposure: 71% — the T212 ISA's individual US equities and global tracker, Fundsmith's top holdings, LifeStrategy's underlying allocation, and the technology ETF all point at the same underlying companies.
• UK equity exposure: 11% — concentrated in the GIA, meaning any gains are exposed to CGT rather than sheltered.
• ISA/SIPP as a share of total portfolio: 90% — the wrapper structure is favourable; the GIA allocation is small.
• Growth assets in GIA: yes — the UK equities and technology ETF held in the dealing account are the highest-volatility holdings. Any appreciation is taxable.

Without the consolidated view, none of this is visible. The T212 ISA looks fine. The HL SIPP looks fine. The Vanguard ISA looks fine. The ii account looks fine. Together they reveal a concentration and wrapper allocation issue worth acting on.

FAQ

How do I see my ISA and SIPP together?

The only way to view them together is to export from both platforms and combine the data, either manually in a spreadsheet or via a portfolio tracker that accepts multiple CSV imports. Platform-native views (including HL's own portfolio analysis) are siloed to that platform's accounts only.

Can I aggregate Hargreaves Lansdown and Vanguard in one place?

Yes. Export from HL via My Accounts → Portfolio → Download portfolio as CSV, and from Vanguard via the transaction history download. Import both into a consolidated tracker and label each by account type. Invormed accepts both formats and maps them to ISA, SIPP, and GIA wrappers automatically.

Does Vanguard UK offer a CSV export?

Not a current holdings snapshot in the way HL or ii do. Vanguard UK provides a transaction history CSV which can be used to reconstruct current holdings. Some consolidated trackers, including Invormed, accept the transaction CSV and calculate current holdings from it automatically.

How often should I update my consolidated view?

For most investors, once per month is sufficient for portfolio review purposes. The critical thing is consistency — updating all accounts at the same point in time so the snapshot is coherent.

Does Dodl (AJ Bell) allow CSV export?

Not natively. Dodl is app-only and does not have a CSV export feature as of 2026. Options are: manual transcription from the app, a GDPR Subject Access Request to AJ Bell, or migrating the account to AJ Bell YouInvest which does offer full CSV export.

What is the difference between a holdings export and a transaction history export?

A holdings export shows your current positions: what you hold, at what price, with what value and cost basis today. A transaction history export shows all historical activity: every buy, sell, and dividend payment. For building a current portfolio view, you need the holdings export. Some platforms (particularly Vanguard UK) only offer transaction history, from which current holdings must be derived.

Does Invormed work with Trading 212?

Yes. Trading 212 is Invormed's lead broker integration — partners since launch. Invormed imports T212 CSVs natively with full column mapping and tax-wrapper detection (ISA vs Invest account). The T212 importer requires no manual field matching and handles the full transaction history to reconstruct current holdings and cost basis automatically.