I created a google spreadsheet template for tracking dividend income. Thought Iād share it here. This is identical to dividend diplomatās spreadsheet. Been a big fan of their dividend income journey. My goal is to do the same - grow my dividends with sound /dividend champ companies year-on-year.
One adjustment Iād probably recommend is aligning the dates to the tax year to help with the tax return (assuming itās a general account, not an ISA).
Does it include non-US stocks, etfs and funds? Google Docs hasnāt seemed to be able to get the prices for UK-domiciled mutual funds in the last yearā¦
@adavid Yep, my spreadsheets have been sad since March 2018.
@ytsruh would your thing get price for eg a Vang lifestrategy mutual fund, (say ACDT / B4PQW15 / GB00B4PQW151 )? Itās been a long time since I used Excel but would give it a try. (Iām asking you because I donāt see a way to get the Stock ābitā in the Data menu when Iām using O365.)
I can see youāve manually input the dividend return for Feb and May in CTY.
Is there a technical solution for calculating this return in Google Docs ( i.e. to input the dividend return in the correct column based on the pay date and your holdings)? Or are you doing this manually from company listings / Google / LSE etc.?
Unfortunately, I donāt know how to this programmatically. When I receive my dividends i just input the amount manually.
I would then summarise all of it in another sheet that looks like below. This me allows to compare year on year growth in my dividend income. Iād love to get to a point where my dividend income can sustain my lifestyle one day. In the meantime, re-invest everything back.
With regards to re-investing dividends back. Some brokers allow DRIP but others do not and it can get really expensive. I usually wait until dividends accumulate to say 1K before re-investing back just to make it worthwile with 9 quid commission.Fortunately with FreeTrade, I donāt need to wait for my dividends to accumulate as I can re-invest it with zero to minimal commission.
When I get around to it: Iāll work out a way of grabbing yield and/or dividend per share from somewhere, so it requires as little manual entry as possible.
You could probably pull in ex-dividend dates, payment dates and so on too.
Iām all ears, if anyone in the hive mindās got any ideas!