[Feature Request 🔧] Annual Tax Certificate 💰

Ideas 💡
187

HL shows my total contribution for the year as when I added plus the 20% as an overall amount. FT doesn’t from what I can tell but the data isn’t clear to see properly.

189

That is your quarterly/annual statement. You can also see this directly using the contributions link on HL. HL does not provide SIPP accounts a tax certificate.

190

I totally understand this. But this is not quite what you originally said.

In summary, I agree Freetrade should mark clearly HMRC‘s 20% contribution in your SIPP activity.

1 Like
191

Vanguard do the same. Not the prettiest site you’ll see but the reporting and analysis tools available on a portfolio is excellent.

4 Likes
192

Look it’s really hard to explain this exactly in a short forum message.

1 Like
193

Vanguard shows like this:

Personal £4,500
Company £0
Third Party £0
Tax Relief £1,125

Total Contributions £5,625

… This is the kind of thing I would like from Free Trade!

3 Likes
194

@JamesBell make the export format the same as this calcluator? http://www.cgtcalculator.com then all we have to do is copy our trades into the website and we can easily get the CGT calcualtions.

1 Like
195

Any updates for GIA accounts?

1 Like
196

Hey everyone - just crossposting - as I mentioned above the first step in simplifying this activity at Freetrade is addition of an activity report showing buys, sells and income

You can see the first version of that extract shared on this thread → Download/export Activity feed to CSV

1 Like
197

@freetrade, how easy/difficult is it to buy a solution from a classic/well-settled platform with years of experience on this and apply it for us users?

198

I am going to be selling my stocks on Freetrade slowly and moving them to eToro, as my accountant told me the horror story that it would be to calculate capital gains on my GIA without a Consolidated Tax Report (which eToro produces - in fact, eToro also has a detailed guide on how to fill out a self-assessment form!). It’s quite sad, I love Freetrade, I’ve learned lots since I started trading with them, but this really is a nightmare.

10 Likes
199

Same here… can you please share a link to the guide?

1 Like
200

Couldn’t agree more. They management assured me it was being introduced but that was months ago. I believe Freetrade is the only platform that doesn’t provide this facility. Major failing.

| rodduartebr Rodrigo Duarte
2 November
I am going to be selling my stocks on Freetrade slowly and moving them to eToro, as my accountant told me the horror story that it would be to calculate capital gains on my GIA without a Consolidated Tax Report (which eToro produces - in fact, eToro also has a detailed guide on how to fill out a self-assessment form!). It’s quite sad, I love Freetrade, I’ve learned lots since I started trading with them, but this really is a nightmare.

4 Likes
202

Here’s the link, @ysibre

https://www.etoro.com/customer-service/tax-report-uk/

3 Likes
203

I’ve been asking for a tax certificate for the last few years on this platform, however I may as well have been whistling at the moon. They seem to be great at reducing customer service whilst increasing their charges. This will be the last year I attempt the admin nightmare of CGT and dividend taxes with FT.

205

I love the etoro tax report. Even tells you which box on the tax return the numbers go :heart_eyes:
Only prob with etoro is the exchange rate at the min is rubbish.

1 Like
206

To calculate CGT yourself using ( CGTCalculator online capital gains calculator for UK share trades) do the following:

  1. Using Freetrade export an activity statement of all time
  2. Email/Copy the export feed csv file to a PC/MAC and install Python 3
  3. Use the following python code to convert the activity statement for use with cgtcalc:
import csv
import sys
from datetime import datetime 
freetrade_activity_export_name=sys.argv[1] # freetrade export file
f = open('cgt_calc_results.csv', 'w', newline='', encoding='utf-8')
header = ['Type','Date','Ticker','Share_Quantity','Share_Price','Fees']
writer = csv.writer(f)
writer.writerow(header)
with open(freetrade_activity_export_name) as f:
    reader = csv.reader(f)
    for row in reader:
        if row[5]=="BUY" or row[5]=="SELL": # Only parse BUY and SELL rows
            fees="0"
            if row[5]=="BUY" and row[11]=="London Stock Exchange" and row[9]!="0": # Only UK stocks that are buys pay STAMP Duty and are not 0 (E.g AIM STOCKS)
               fees=row[9]
            if row[14]=="USD":# If USD then we have FX fees to take into account
                fees=row[20]
            trade_date=row[2]
            date_object = datetime.strptime(trade_date,"%Y-%m-%dT%H:%M:%S.%fZ") # Format the date so it can be converted
            formatted_date = date_object.strftime("%d/%m/%Y")
            company_name=row[0].replace(' ', '_')#Removing erronoes spaces in company names that cgtcalc will not accept.
            print(row[5]+" "+formatted_date+" "+company_name+" "+row[10]+" "+row[8]+" "+fees)          
            writer.writerow([row[5],row[2][:-14],company_name,row[10],row[8],fees])
  1. Run the script for example python ./freetrade_2_cgtcal.py export_activity.csv
  2. Copy the output into https://cgtcalc.galloway.me.uk/

Troubleshooting:
If a company has changed it’s name, then fix the company so it uses the same name throughout.

Disclaimer: I’m not an accountant and this is not financial advice.

207

Or …
Just give us a full tax report
:joy:what a faff all that is.
Something will bound to go wrong copy paste delete filter

2 Likes
208

Firstly I’m a Freetrade investor and have a Freetrade SIPP account and will continue to do so.
If you have money to invest outside of tax protected accounts then InvestEngine are an option. They provide full reports to your account automatically.

209

Much easier now we can export all activity history :slight_smile: