NOTE: The Barclays report does not give a ticker symbol, so a pseudo-ticker is made up from the Barclays Description. This means that you cannot load the Barclays trade csv with other brokers because the share tickers will not match unless you carefully edit the Barclays tickers in the Trades list before pressing Calculate, e.g.
S 21/06/2021 TESCO-1361435820 657 2.2805631659 0 0 < – Barclays sell
B 22/06/2021 TSCO 100 2.2805631659 0 0 <- Trading 212 buy
.CSV format example – Barclays .xls file must first be loaded into Excel and saved as a .csv file (first .csv option in the Excel Save As list – do not use MSDOS or other .csv save options).
ID1426854-002 (Investment ISA),,,,,,,
,,,,,,,
Investment,Date,Order Status,Account,Buy/Sell,Quantity,Cost/Proceeds,Country
Tesco PLC ORD 6 1/3P,06/10/2025,Completed,Investment ISA,Buy,31,145.90 ,GBR
Ishares V Public Limited Company ISHRS S&P 500 INF TECH SECT ETF USD ACC,16/09/2025,Completed,Investment ISA,Buy,50,”1,476.90 “,GBR
Berkeley Group Holdings (The) PLC ORD 5.6110477936P,16/09/2025,Completed,Investment ISA,Sell,40,”1,450.73 “,GBR
Artemis Global Income I Acc,18/08/2025,Completed,Investment ISA,Buy,3354.526,”10,500.00 “,NotSpecified
Royal London Global Equity Select M Acc,15/08/2025,Completed,Investment ISA,Sell,3552.1641,”10,525.07 “,NotSpecified
Ishares V Public Limited Company ISHRS S&P 500 INF TECH SECT ETF USD ACC,10/07/2025,Completed,Investment ISA,Buy,18,496.64 ,GBR
Astrazeneca PLC ORD SHS $0.25,03/06/2025,Completed,Investment ISA,Buy,5,540.61 ,GBR
Astrazeneca PLC ORD SHS $0.25,10/05/2025,Completed,Investment ISA,Buy,1,103.79 ,GBR
Astrazeneca PLC ORD SHS $0.25,30/01/2025,Completed,Investment ISA,Buy,3,345.09 ,GBR