Barclays

use .CSV format – The downloaded Barclays .xls file must first be loaded into Excel and saved as a .csv file (use the first Save As .csv option in the Excel Save As list – do not use MSDOS or any other .csv save options). The example shows an ISA account but you would only need to download data for your GIA.

NOTE: The Barclays report does not give a ticker symbol, so a pseudo-ticker is made up from the Barclays Description by UKCGT. This means that if you also load the Barclays trade csv and other brokers csvs, some share tickers may 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

You should change all Barclays tickers to match the Trading 212 ticker because they are the same shares. i.e. change all instances of TESCO-1361435820 to TSCO. UKCGT will try to identfy the correct share ticker – but it may not always be successful. There is also a ‘Convert to tickers’ button if you paste in any Trades which contain descriptive names instead of tickers.

Example .csv after saving a barclays as a .csv within Excel and before loading into UKCGT…

Scroll to Top