DIVIDENDS AND TAX
Tracking Passive Income
Hi - I am curious what everyone is using to track their dividends each year? I want to go back 3+ years and pull together the history and then keep it updated. Are you using Excel or is there an easier app/software available? It also isn't clear to me when doing this kind of exercise, do we include franking credits or not? As always, I greatly appreciate this forum & all of your knowledge. Thanks.
THEA MCANDREW
25 May 2025
Comments (2)
Sign in to add a comment
Hi Thea,
You could do this by using a tracker like Sharesight or Navexa. Sharesight is free up to 10 holdings so that might be a better fit to get started.
From there you’d have to input all your past trades so that iti can build an income history from all the dividends you would have received during that time and how much.
You can definitely do it in excel by using old dividend statements you would’ve received. This will just be more ongoing effort to manage and keep track of though, so it’s up to you.
As for franking, I definitely record that myself because it is technically income – on your tax return it literally goes in the income column as well as the ‘tax paid’ column.
Hope that’s useful.
Reply
2 likes
Related posts
Dividends and Tax
Investing and tax time
I am brand new to investing and up until this date have had very simple tax returns which I was comfortable completing m...
Dividends and Tax
What do I need to do when I comes to Tax return time?
New investor here - Saw a few people mention that they didn’t organise paperwork or their tax return info in time. What ...
Dividends and Tax
W8-BEN Tax Form
Hello Fellow Pearlers, Under Transactions -> Reports -> "US broker statements and documents" section, the W8-BEN Tax Fo...