Nestor - Dividend Tracker

Net Worth It

BusinessEducation

Listen

All Episodes

The Trading212 Power User's Guide to Dividend Tracking

Discover how to export and interpret your Trading 212 dividend CSV to reveal your true tax year income, avoid common pitfalls, aYour Trading212 dividend history is recorded in full—but it's sitting in a CSV file, not your app. This episode walks you step-by-step through finding your export, understanding each column, and spotting the hidden quirks that silently break spreadsheets. Discover why your payment date (not ex-dividend date) decides your tax year, the pence-to-pounds currency conversion that catches almost every investor, and why the withholding tax column can show zero when tax was taken. With the ISA deadline 5 days away and new dividend tax rates taking effect April 6, get your complete income picture now. Import your Trading212 CSV into Nestor and let the app calculate your tax-year totals, ISA/GIA split, allowance position, and net yield per holding—automatically.

From the team behind Nestor – Dividend Tracker

https://www.nestordividendtracker.co.uknd get the dividend picture your broker won't show.


Chapter 1

Cold Open

Unknown Speaker

You've got a Trading 212 account. You can see every dividend that's ever landed. The broker keeps a record of all of it. So you should be able to pull your full income picture together pretty easily — right?

Sophie

The data is all there. It's just not in the app. It's sitting in a file most investors have never opened, with columns that look straightforward — and one or two quirks that will silently wreck your numbers if you don't know they're there.

Unknown Speaker

That's what we're doing today. Step by step — where to find the file, what's actually in it, and how to turn raw data into the income picture your broker never gives you. Let's get into it.

Chapter 2

Introduction

Unknown Speaker

Welcome to Net Worth It — the UK dividend investing podcast that shows you what you actually keep. I'm Matt.

Sophie

And I'm Sophie. This podcast is for educational and informational purposes only. It does not constitute financial advice. The value of investments can fall as well as rise, and you may get back less than you invest. Past performance does not guarantee future results. Always do your own research and consider seeking advice from a qualified, FCA-regulated financial adviser.

Unknown Speaker

In episode thirteen, we walked through the five things Trading 212 doesn't tell you about your dividends. Today is the practical follow-up — how to get your data out, what the columns actually mean, and how to build the income picture from scratch. The tax year ends in five days. This is the right moment.

Chapter 3

The Problem

Unknown Speaker

So here's what happened after episode thirteen aired. I went into the app, I could see my dividend history on screen — individual payments, dates, tickers. But I wanted to know my actual tax year total. How much have I earned from April sixth to now. And I just... couldn't get that number. There's no summary. There's no total. It's just a list.

Sophie

That's the gap the episode was describing. The transaction data is all there — Trading 212 records every payment down to the penny. What the app doesn't do is sum it up by tax year, separate your ISA income from your GIA income, or calculate what any of it means for your allowance. That's synthesis, not data. And synthesis is what the export is for.

Unknown Speaker

So the export is how you get the raw material. Then you do the work yourself.

Sophie

Exactly. Or you feed it into a tool. But either way, the starting point is the same — you need to get the data out first. And that part is actually pretty quick.

Unknown Speaker

Walk me through it then. Where do I find the export?

Sophie

On mobile, tap the menu icon at the bottom of the screen — the three lines. Then tap History. In the top right of the History screen there's an Export icon — it looks like a document with an arrow. Tap that and you get four checkboxes: Dividends, Orders, Transactions, and Interest.

Unknown Speaker

And on the website?

Sophie

Same idea. Click your profile name in the top right, go to History, and the Export icon is there. You pick your date range and what you want to export, and the file downloads as a CSV — that's a spreadsheet file that opens in Excel, Google Sheets, or pretty much anything.

Unknown Speaker

Easy enough. But I've heard there's a catch with the date range?

Sophie

There is. Trading 212 gives you a maximum of three hundred and sixty-five days per export file. So for a full tax year — April sixth to April fifth — you need two sequential exports. Cover April sixth to October fifth with the first, and October sixth to April fifth with the second. Put both files side by side in your spreadsheet and you've got the complete year.

Unknown Speaker

That's the kind of thing no one tells you about until you're already confused. Right, so I've got my file. What am I actually looking at?

Sophie

That's where it gets interesting. And there's something in the columns that catches almost everyone off guard — something that will quietly break your maths if you miss it. Let me walk you through it.

Chapter 4

The Explanation

Sophie

So you've got the file open. Twelve columns. Most of them look obvious — ticker, date, number of shares, how much landed in your account. But there are a few things in there that will give you the wrong answer if you don't know they're there.

Unknown Speaker

What's the first one?

Sophie

The timestamp. And this one matters more than people realise. The time column shows exactly when each dividend was paid. That payment date is the legally relevant date. Under ITTOIA 2005 section three-eight-four, dividends are taxed in the tax year they're paid — not when the company goes ex-dividend. So a company can go ex-dividend in late March, and if the payment date falls on or after April sixth, that dividend belongs to the new tax year. At the new tax rates.

Unknown Speaker

The app might show a March date though. If you're going by what you see on screen, you'd put it in the wrong year.

Sophie

That's exactly it. The app tends to surface the ex-dividend date because that's when you stop being eligible for the payment. But for HMRC, the ex-date is irrelevant. The timestamp in the CSV is the one doing the legal work. And this year specifically, that distinction costs real money — basic rate goes from eight point seven five to ten point seven five percent from April sixth, higher rate from thirty-three point seven five to thirty-five point seven five. A payment that lands before April fifth is taxed at the old rate. After April sixth — the new one.

Unknown Speaker

Right, so you need the CSV date, not what the app shows. What's the other quirk you mentioned?

Sophie

This one's the one that catches almost everyone. UK stocks on the London Stock Exchange are quoted in pence. Not pounds. So in the CSV, the currency column for those stocks shows GBX — that's the code for pence. The price-per-share figure will be in pence. If you open that file and start pulling numbers into a spreadsheet without knowing that, your calculations will be wrong. Not slightly wrong. A hundred times wrong.

Unknown Speaker

How would you even know? If you're just looking at the file, there's nothing that screams "warning."

Sophie

There isn't. The column header says "Currency (Price / share)" and it says GBX. That's the only signal. If you don't recognise GBX as pence, you build your spreadsheet on bad numbers and the output looks plausible — the amounts aren't absurd, they just don't match reality. It's the kind of error that goes undetected for months.

Unknown Speaker

That's uncomfortable. What about the withholding tax column?

Sophie

That one can mislead you in a different way. For UK stocks the column will show zero — and that's correct, no withholding tax applies. For US stocks where you've filed a W-8BEN form, you'd typically see fifteen percent of the gross. But for some foreign stocks, it can also show zero even when withholding tax was technically applied somewhere in the chain. The column reflects what Trading 212 deducted — not necessarily everything that happened at the source.

Unknown Speaker

So zero doesn't mean nothing was taken.

Sophie

Right. You might think you received the full gross payment when you didn't. The broker's record is accurate about what they credited to your account. What happened upstream of that is a separate question — and the zero in that column doesn't answer it.

Unknown Speaker

So you've got the currency quirk potentially making your numbers a hundred times out, you've got payment dates that could land your dividend in the wrong tax year, and you've got withholding tax figures that might not tell the whole story. And you wouldn't know any of this just from looking at the app.

Sophie

That's the thing about a raw data file. The ingredients are all there. But the file itself doesn't flag anything — it just presents the numbers. Knowing what to look for is the part the broker doesn't give you. And that's what makes the gap between having the data and actually understanding your income position much wider than most people expect.

Unknown Speaker

And there's one more thing that makes this easier — which brings us to the Nestor bit.

Chapter 5

How to See This

Unknown Speaker

So if someone doesn't want to build this spreadsheet from scratch — is there a shorter route?

Sophie

The Trading 212 export is the same starting point either way. If you import that CSV into Nestor, it handles the quirks we just described and then goes further. Tax year totals calculated from the payment date, not the ex-date. ISA and GIA income separated because you've imported them from separate account exports. Your GIA total checked against the five hundred pound allowance. Net yield calculated per holding from your actual cost basis. And a forward income projection based on recent payment history.

Unknown Speaker

Same file, different output.

Sophie

Exactly. Nestor doesn't replace the export — you still do that directly from Trading 212 the same way we described. It just does the maths on the other end. And it handles the pence-to-pounds conversion automatically, which is one less thing to get wrong in a spreadsheet.

Unknown Speaker

That's the part I'd definitely get wrong.

Sophie

It's not a guarantee of any outcome — just a way to see your current numbers clearly. The ISA deadline is Sunday. Having those numbers before then seems worth doing.

Chapter 6

Key Takeaway

Sophie

So here's what to take away. You came into this episode thinking the data you need is somewhere in the Trading 212 app — you just couldn't find it. The data is there. It's just not in the app. It's in a file you export in about thirty seconds, and once you have it, the picture comes together: tax year income, allowance position, net yield per holding. The broker records everything. The synthesis is the part you have to do — or hand off.

Unknown Speaker

The CSV is the bridge. Get it out, and the numbers start making sense.

Chapter 7

Closing

Unknown Speaker

If you've been listening to this series and you've never pulled your Trading 212 dividend export, do it this week — there are five days left in the tax year and it takes about two minutes. If you want to skip the spreadsheet, import it into Nestor and the calculations happen straight away — link is in the show notes. One question for you: have you ever checked whether your year-to-date dividend total has actually cleared your five hundred pound allowance — or are you guessing? Reply to us on Spotify or Apple Podcasts, we genuinely read them.

Sophie

Remember, nothing in this episode is personal financial advice. For decisions about your own portfolio, consider consulting an FCA-regulated adviser.

Unknown Speaker

See you Thursday for Your 72-Hour Tax Year Checklist — everything you need to check, top up, and decide before Sunday's ISA deadline. That's the season finale.

Sophie

See you then.