Back
Tracking Passive Income
Dividends and Tax
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.
214 views
Share
3 likes
THEA MCANDREW
Asked on 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