Exportable Data

It is worth reading for yourself

But yes, £12,300 of net gains is allowed free of tax this tax year.

Is there any news for exporting data to CSV from the desktop version of the app?

Thanks for the work you do!

Yes. That feature is already available. Look under History.

Would be really good to have a specified annual statement for tax purposes.
As mentioned by some people above, Spain is quite strict, has a FIFO policy and normally you would present all the paperwork to the specialist (Gestoria), they have accountants and lawyers and try to prevent as much trouble as possible with the tax office and if there is any they will help you sort it out. But you do need to present a proper statement.
Something I get both from the bank and DeGiro where I have my other portfolios.

5 Likes

Any google sheet / exce guru has created a dashboard? :pleading_face::pleading_face::pleading_face::pleading_face::pleading_face::pleading_face:

If you would like anything added, post a suggestion in the the thread and I’ll have a look later this week :blush:

1 Like

T212, THIS INFORMATION IS A MUST ALSO FOR PORTUGAL (yes, in capitals letters, some of us are asking for this for months not only in this forum but also by email). Thank you.

I do find it interesting how lots of countries have their own unique tax laws. In the short term, would the broker statement confirming your holding as at ex date, the information on the company website, and the broker statement confirming the net dividend received not carry enough evidence for the tax authority?

You can prove your position, and what the Gross dividend would have been, and what you received Net?

That way you should have enough evidence to avoid double taxation?

Longer term, reading between the lines, I think a PDF statement that shows your opening position, all your trading activity, and ending positions that could be run based on set dates. So it could be run April to March for UK residents, Jan to Dec for yourself and so on.

It would also be ideal (I think, potentially), if it listed a summary of dividends received from which country, and the gross/net/tax paid for the period.

Then it may also need for some countries, details of realised capital gains and losses?

Would that cover everything - I think if we can help scope out the specifications and or design with the user base on this forum, and get enough people behind it, it may bump up development in the priority list?

I’ve not looked at the csv extract for a couple of weeks, but I think most the data needed is in there, we might just want a more official 212 pdf version that could be run?

1 Like

I suspect the problem occurs mostly for those who are not completing their tax returns themselves, and that it is their accountant who is making difficulties. An accountant does not wish to have to look up data in external sources, or will want to charge higher fees if she must, (though I would think she should know the various withholding tax rates).

I expect the data that Trading 212 provide is sufficient for completing tax returns in all countries. You just fill in your tax return using that data, together with other publicly available data that you can look up about withholding tax rates, gross dividends paid, and payment dates. If an audit were ever to take place, you will have no trouble proving you reported the right taxable income. (I do not know any country that actually requires taxpayers to submit copies of all their broker and bank statements together with their tax return.)

Dividend payment dates are a particular issue. Strictly speaking (at least in the UK) dividend tax is due on the amount of local currency the foreign dividend would buy on the official payment date, not on the date a few days later when the investor actually receives it in his account. In times of rapidly fluctuating exchange rates this can make a difference. However, a really professional tax accountant will have set themselves up knowing how to quickly extract these dates and exchange rate data.

1 Like

It’s not a matter of calculating the dividends etc. Let’s say the withholding tax if a dividend is 30%. You can just do <amount_received>/0.7 for the gross and you’re done,
The problem is proving it to the tax office. They need an official broker document stating gross amount received in your currency, net amount and tax paid. You can get in trouble if you don’t have that document.

2 Likes

When do they need this? Must it be submitted as an attachment to your tax return every year? Or is only needed if you are audited? In the UK it would only be at an audit that one would need to produce such statement. If that happened, and I felt I did not already have it, then I would go back to Trading 212 for a bespoke statement.

It’s for an audit. But I had asked for a statement with dividend information and the answer was they couldn’t give me one

Could the Export CSV have the Foreign Exchange Rate of the dividends? (It already shows the Foreign Exchange Rate of the buying/selling transactions.)

2 Likes

Sorry, haven’t read the whole thread as quite long. So can you export your holdings info from the web / desktop version but not App? So a list of total share holdings at that point in time?

Hi In2deep.

As far as I’m aware, the Exportable data is a full transaction history.

Cheers Dougal. I will have a look. So you don’t think there is an extract that will just show you volume of holdings in the various stocks/funds?

Not that I’ve seen other than your monthly statements no.

Be careful aggregating as found out stock split not covered in transactions

Is it possible to export data in Excel (xls) instead of CSV?

Excel can read CSV files? Is CSV not just the older single XLS tab version?