Personal finance management
I don’t know much about financial management and obviously its importance. Had a subject in my college about finance management. I used to sleep in that class. But nowadays I feel it is very important to manage finance. But conventional way of book keeping is not attractive to most peoples especially peoples travelling all the time. This post is for such people and who have internet access most of the time. Ability to use own memory as a buffer is added advantage. I am big fan of google, its products are beyond perfect. they dont offer free application/product/service for financial management. But we can do it with google docs, gmail quick links with little effort.
Our focus is personal/family finance management.
Google Docs Steps:
1. Goto google docs from your gmail.
2. Create New -> Form
3. Give name for form (e.g. Expense Details). One spreadsheet will be created in the same name for viewing datas
4. Add required fields (Date of Transaction, Time of Transaction, Paid to, Amount, Description)
5. Save the form.
6. Email the form to your gmail ID. Don’t forget to check “Include form in email body”.
Gmail Quick Links part:
1. By the time, you may have received the email with the form.
2. Goto Settings -> Labs in gmail.
3. Enable the “Quick Links”. Save the changes. Quick links area will appear on the left corner of the gmail.
4. Now open the received mail with the form.
5. Now click “Add Quick link” link at quick links area. Name the link appropriate name like “Expense Details”.
Just click the link “Expense Details”. The respective email will be brought to foreground even from the abyss. Enter the details. Submit the form. Simple. Quick links avoids the pain of searching the form for entering expenses details. Now your gmail has a form to enter the time to time expenses in addition to checking emails. I’ll check my mail more than four times a day. So it is very helpful. We can email the form to any people. With little coordination we can make family finance management interesting.
All you have to do is enter the expenses whenever you get the time to surf. At background the details will be logged into the spreadsheet created for the form. You can do the tallying part at end of the month or week. You can have different forms (Income Details, Debt Details). The form fields are not limited to just text boxes, you can have checkboxes, text areas, etc.
I m exploring how to automatically generate balance sheets and cash flow statements within google docs. I will update this post if I find how to do it.






