Taking Full Advantage Of A Franked Dividend Tracking Spreadsheet

A franked dividend tracking spreadsheet is a good idea for anyone who is interested in investing especially for profits. As the name suggests, it tracks the interest yield and as a result helps the investor to make better decisions.

Investing entails buying stocks that pay periodically. This will enable you as an investor to get a regular income flow from the investments you have made. In addition, there would also be apreciations in your portfolio as the stocks and your other holdings gain value.

As time goes on, managing your investments become cumbersome and could be exhausting. This is where the franked dividend tracking spreadsheet comes in. It makes it very easy to manage your investments and supervise your earnings easily.

Uses Of Franked Dividend Tracking Spreadsheet

Knowing fully well that this spreadsheet helps you to keep tabs on your earnings, it is now important that you know how you can fully utilise this technology to build your portfolio. As we go ahead, you’ll discover how you can fully use this technology to better your finances.

The most popular use is for tracking annual yield. Not only can you calculate the total income from the previous year, you can also calculate the expected income for the next 12 months. Therefore you can track your forward annual yield with the franked dividend tracking spreadsheet.

As an investor, you might have several investments with different brokers. Keeping tabs on all of them at once is definitely not an easy job. This franked dividend tracking spreadsheet allows you to see all the income transactions from all your different brokerage organised in one place.

Going forward, you can also decide to use this franked dividend tracking spreadsheet to create distinct groups for your portfolios. That also means that you can also track the accounts of your spouse or other family members that are connected.

It also makes it quite easy to track all the above in a minimalist approach. All your income is presented in form of a report for easier understanding. You’ll get a detailed report about all the interests that have been paid to you.

How To Create A Franked Dividend Tracking Spreadsheet

Interestingly, you can manually create your own tracker in a few simple steps. This is very important so that you will not be stuck or going in circles in your investment life. Simply follow the steps below to create a franked dividend tracking spreadsheet.

  • The first thing to do is to list your holdings and the details you want to track.
  • Afterwards, you’ll setup the details of your stock. It is here that you’ll list out your holdings for each account.
  • The next step is to diversify your reporting by assigning a sector to your stock holdings.
  • After that, you have to setup for the rate of returns.
  • In this step, you’ll setup the transactions that you want to track. It could be transactions that involve tax or even all.
  • The last step is to set up your income tracking.


A franked dividend tracking spreadsheet makes it very easy for you to monitor your earnings. Take full advantage of this technology today and be up to date with your investments comfortably.


Navigating the intricate maze of news with precision, Jason strikes with clarity and depth. On, he distills the essence of current events, offering readers a sleek, informed perspective.

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button