Home Docs Broker CSV Export Guide

UK broker CSV export & compatibility guide

How to export your transaction history from major UK investment platforms and import it directly into Omnicogi without sharing broker passwords.

Omnicogi uses a zero-credential architecture. Instead of asking for your bank passwords or using invasive Open Banking scrapers that break constantly, Omnicogi ingests official transaction CSV files generated directly by your broker.

Data Sovereignty First: Your broker login details, 2FA codes, and bank security credentials remain strictly private. Exporting a CSV file gives you complete control over what data enters the analysis engine.

1. Step-by-step export instructions by broker

Interactive Investor and Fidelity International are Tier 1 supported: a purpose-built parser reads their export format directly, reconciled against real statements. Every other broker (including Hargreaves Lansdown, Trading 212, AJ Bell, Vanguard UK, Interactive Brokers and Freetrade) is experimental during Early Access: it imports through Omnicogi's generic column-matcher, which recognises common CSV headers automatically, but you may need to map a column or two and should check the result.

Don't see your broker? Upload your CSV export in-app and we'll map your schema in future. If a file won't import, the app offers to send us its column headers with one tap. It sends the headers only, never your rows or amounts.
Interactive Investor (ii) Tier 1 · Supported

How to download your transaction history:

  1. Log in to your Interactive Investor desktop account.
  2. Navigate to Portfolio and select the relevant account (Trading Account, ISA, or SIPP).
  3. Click on History & Transactions.
  4. Select your date range (e.g. All available history or Custom date range).
  5. Click the Download / Export icon at the top right of the table and choose CSV.

Tip: II exports include full transaction types (Buys, Sells, Dividends, Corporate Actions, and Monthly Fees). Omnicogi parses and classifies all rows automatically.

Fidelity International (UK) Tier 1 · Supported

How to download your transaction history:

  1. Log in to your Fidelity UK online account.
  2. Select your account (ISA, SIPP, or Investment Account).
  3. Go to Transactions & Orders (or Account Activity > History).
  4. Set the date filter to your desired historical range.
  5. Click Download to spreadsheet (CSV) located above the table.

Note on Settlement Dates: Fidelity records both Trade Date and Settlement Date. Omnicogi uses the trade execution date to ensure accurate XIRR and Section 104 cost pooling.

Trading 212 (Invest / ISA) Experimental

How to download your transaction history:

  1. Log in via the web portal or mobile app.
  2. Go to History (bottom right icon or left navigation bar).
  3. Click the Export icon (downward arrow).
  4. Select Custom Period and toggle all fields (Orders, Dividends, Transactions).
  5. The 365-Day Rule: Trading 212 restricts each export batch to a maximum of 365 days. If your trading history spans 3 years, download three separate files (e.g. 2023, 2024, 2025). Omnicogi automatically merges and deduplicates them.
Hargreaves Lansdown (HL) Experimental

How to download your transaction history:

  1. Log in to your HL online account.
  2. Select your Stocks & Shares ISA, SIPP, or Fund & Share Account.
  3. Click on the Transactions tab.
  4. Select View all history or choose custom dates.
  5. Click the Export to CSV / Excel link at the bottom of the table.
AJ Bell & Vanguard UK Experimental
  • AJ Bell: Navigate to My account > Documents & Statements > Transaction history, choose your dates, and click Export to CSV.
  • Vanguard Investor UK: Under My Accounts > Transaction History, filter by date range and select Download CSV.

2. Broker formatting quirks & how Omnicogi resolves them

Broker QuirkThe ProblemHow Omnicogi Handles It
Overlapping CSV Exports Exporting "Last 12 months" every quarter creates duplicate rows. Omnicogi generates cryptographic transaction hashes to deduplicate identical trades automatically.
GBX (Pence) vs GBP (£) LSE stocks quote in pence (e.g. 2450p) while funds quote in pounds (£24.50). Omnicogi normalises all London Stock Exchange pricing units to prevent 100x valuation errors.
Corporate Actions & Ticker Changes A company changes ticker or merges, breaking history. Omnicogi maps trades by unique ISIN and SEDOL identifiers rather than volatile ticker symbols.
Missing Cash Movements Broker CSV logs trades but omits platform custody fees or uninvested interest. Adding a single point-in-time Snapshot immediately detects and reconciles any ledger variance.

3. The Import Diagnostics & Reconciliation workflow

When you drop your CSV into Omnicogi, our calculation engine executes a 4-step pipeline:

Header & Format Detection

Identifies broker template, delimiter, date encoding (DD/MM/YYYY vs YYYY-MM-DD), and currency columns.

Security Resolution

Matches trade descriptions to verified securities via global ISIN/SEDOL directories and market feeds.

Clean Cash & Section 104 Ledger Construction

Separates external deposits from internal reinvestments and builds running average cost pools for CGT.

Snapshot Validation

Cross-references calculated share quantities against your official broker valuation statement.

Important Notice: Omnicogi is a portfolio tracking and data analytics tool, not a registered financial adviser or tax agent. CSV parsing and calculation outputs are provided for personal record-keeping and educational purposes. Always verify calculations against your official broker statements and consult a qualified tax adviser or accountant for tax filing.
Getting Started Next: Snapshots & Reconciliation

On this page