How Do You Keep Track of Investment Records Efficiently? Seeking Your Advice!

pnjani
To maintain investment records for bank fixed deposits, bonds, NSC, RD, company fixed deposits, LIC details, passport details, driving license details, and details of filed IT returns, you can create a systematic filing system or use digital tools like spreadsheets or personal finance management software.

There are software solutions available specifically designed for managing investment records and financial details. Some popular options include Quicken, Personal Capital, and Mint. These tools can help you track and organize your investments efficiently.

Thank you in advance for your assistance.
msmhaskar
I downloaded a budget planner. It seems to be a useful tool, but I am a little bit confused about how I can set up reminders for my premiums, birth dates, etc. Could you please provide detailed clarification on this matter? Thank you.
msmhaskar
Dear Jignesh,

Thank you for the nice spreadsheet. It seems very useful. I am a little bit confused about how to enter data to remind me about insurance premiums, birth dates, etc. Do I need to update the data every month, or does it set a schedule automatically? Please clarify.

Also, I have a file (thanks to the original creator; I received this file via email) that you may find helpful for developing another one. Thank you.
1 Attachment(s) [Login To View]

jiguparmar
You only need to enter your details once. If you have an annual premium, enter it in the I Premium Date column. If you pay premium twice a year, enter the dates in the I and II columns. For those with a premium three times a year, fill in the I, II, and III columns.

To set a birthday reminder, open the birthday sheet, enter your data, and it will remind you when the month arrives. Please note that the main sheet only displays reminders for FD, insurance, and birthdays. To input data, access the individual sheets.

For more updates on Excel tools and other resources, visit the following link: <link outdated-removed> (Search on Cite | Search on Google)
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute