I had earlier written about maintaining your personal finance data. I told you how it can help your dependents.
Now I dint tell you how I organize those. I usually have an excel sheets for that.
I do have created a website accessible locally connected to my local database where I import these data from excel to web app. This acts as an additional back up.
i do it for a simple reason that i will have track of my cash flows,updated information of my financial data .i have a consolidated report. hence it is also important to update it periodically
Now what information do I have in excel? I have 5 major sheets and below is the structure
Sheet1->my Mutual Fund Investments. You can see I have goals attached to each asset class
It contains below columns
Next sheet contains info on tax declaration to save Income tax
|Tax saving Products||Amount||Financial year|
In the next sheet I have Income tax projection for the whole financial year. I cannot show it here since its huge table data
In the next sheet I have Insurance details
Next sheet shows Bank deposits data
The next sheet contains information on additional income other than you salary/regular paycheck
This may include the rent you get from your property
The last sheet contains all addition information you may like to keep. i have my LPG gas connection details stored
This is how I maintain master data . do it if you like this idea. Again this is for day 3 of my photo challenge. photos are very small . but it conveys appropriate message from me .
PS:click on the image if its not clearly visible