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
- Sign in to your AJ Bell account at www.ajbell.co.uk
- Navigate to my account
- Select transaction history
- Choose the date range you wish to include
- Click “Download CSV” to save the file to your computer
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 Buysell,sale: recorded as Selldividend: recorded as Dividendreinvestment: recorded as Dividend reinvestmenttransfer in: recorded as Transfer intransfer out: recorded as Transfer outnotional distribution,accumulation distribution,excess reportable income: recorded as Notional distributionequalisation: 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.
Step-by-step import
Once you have your AJ Bell CSV or PDF file ready, follow these steps to import it:
- Open Import statements in the sidebar, under Estate & assets → Portfolio
- Drag and drop your AJ Bell file, or click to browse (CSV or PDF supported)
- The system will automatically detect the AJ Bell format and parse your transactions
- Review the parsed transactions: rows that need attention carry a confidence badge
- Resolve any flagged items (unrecognised securities or low-confidence rows)
- Confirm the import to create your transaction records
Screenshot, for illustration only




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.
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:
- 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
