Importing from AJ Bell

Export your AJ Bell (Youinvest) transaction history as CSV and import it to automatically build your portfolio records.

Last reviewed

Exporting your data from AJ Bell

AJ Bell provides a straightforward CSV download of your transaction history through its online platform. You can export data for each account individually.

How to export

  1. Sign in to your AJ Bell account at www.ajbell.co.uk
  2. Navigate to my account
  3. Select transaction history
  4. Choose the date range you wish to include
  5. Click “Download CSV” to save the file to your computer
AJ Bell’s transaction history includes all activity across your selected account. If you hold multiple accounts (ISA, SIPP, Dealing Account), export and import each one separately for the clearest records.

Supported formats and columns

The import wizard recognises AJ Bell exports in CSV format by these column headings: amount, date, description, price, quantity, type. The default currency is GBP.

Recognised transaction types

  • buy, purchase: recorded as Buy
  • sell, sale: recorded as Sell
  • dividend: recorded as Dividend
  • reinvestment: recorded as Dividend reinvestment
  • transfer in: recorded as Transfer in
  • transfer out: recorded as Transfer out
  • notional distribution, accumulation distribution, excess reportable income: recorded as Notional distribution
  • equalisation: recorded as Equalisation

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
  • A number on this row could not be read — check it and add it by hand

Platform fee, platform charge, charge, annual charge, management fee and fee 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. Cash interest and anything else, including corporate actions such as splits and consolidations, is set aside, and the review step names each row and why.

PDF statement support

AJ Bell statements can also be uploaded in PDF format. The import wizard supports PDF extraction using our self-hosted document processing system. CSV is recommended for the most accurate and fastest import.

Your financial documents never leave our servers without your approval.

Step-by-step import

Once you have your AJ Bell CSV or PDF file ready, follow these steps to import it:

  1. Open Import statements in the sidebar, under Estate & assets → Portfolio
  2. Drag and drop your AJ Bell file, or click to browse (CSV or PDF supported)
  3. The system will automatically detect the AJ Bell format and parse your transactions
  4. Review the parsed transactions: rows that need attention carry a confidence badge
  5. Resolve any flagged items (unrecognised securities or low-confidence rows)
  6. Confirm the import to create your transaction records

Screenshot, for illustration only

The broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs toThe broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs to
The broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs toThe broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs to
The importer on its first step, upload, where you say what kind of statement it is, whose it is and which account it belongs to.
Platform fees and charges are recognised and kept out of your holdings, but they are not thrown away: each is recorded as an account charge, so what the account costs you stays visible without distorting your portfolio.

Cost line-item extraction

AJ Bell prints its charges as their own rows rather than as columns on a trade row, so they cannot be attached to an individual trade. Platform fees and charges become account charges and annual charges become annual maintenance, both of which appear under Account Detail once the import completes. The CSV carries no per-trade commission or stamp duty column, so upload the PDF contract note as well if you need those itemised against the trade.

See Understanding investment costs (opens in a new tab) for how each cost affects cost basis in each supported jurisdiction.

Common issues

Platform fees and charges

AJ Bell’s CSV export can include platform fees and charges alongside your trades. Rows whose Type is Platform fee, Platform charge, Charge, Annual charge, Management fee or Fee are kept out of your holdings, so they never appear as transactions, and each is recorded as an account charge instead. A charge row that is a refund is set aside rather than booked as a further charge. Cash interest and any other row type are set aside and listed in the review step.

Fund descriptions without tickers

AJ Bell exports typically use fund names rather than ticker symbols or ISIN codes. The import wizard uses fuzzy matching against the fund description to identify the correct security. If a match cannot be determined automatically, you will be prompted to select the correct security during the review step.

Regular investment transactions

Rows whose Type is Buy or Purchase are imported as buy entries, including purchases made through a regular investing plan. If a row carries a different Type label, it is set aside and named in the review step, and you can add that transaction by hand.

Accumulation funds and equalisation

Rows whose Type is Notional distribution or Accumulation distribution record the income an accumulation fund kept and reinvested, and Equalisation rows record the equalisation part of a fund’s first distribution. Both are imported as adjustments to the holding’s cost rather than as cash paid to you. A distribution, dividend or equalisation row with a blank Amount, or a buy or sell with a blank quantity or price, is set aside and named in the review step rather than booked as zero.

Multiple account wrappers

AJ Bell offers ISA, SIPP, Lifetime ISA, and General Investment Accounts. Each account wrapper produces a separate CSV export. Import each file individually and use the account selector at upload to say which account it belongs to, so your records reflect the correct account structure.

Before you import

Dedicated reader: AJ Bell files are read by a reader built for their layout, without AI.

These parts of the Statement import guide apply to every broker:

Related pages

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

We use cookies to improve your experience. See our Cookie policy (opens in a new tab) for details.