Expense tracking and Budgeting tips

Every time when I go for a trip and return home my mom use to calculate the expense and note it in diary. I used to make fun of her but now I started realizing the importance of it and started following it. The most common  problem is we often we forget to remember whom we have lent and how much. I will try to explain here on what are the various ways/tools I followed to keep track of my expenses.

Excel template:


My friend shared me an excel template called KharchaPani(Download), thanks for the unknown creator of this template, its a life saver. I started entering daily expenses and loans I took/gave. It is very simple and gives a basic chart for  your income vs expenses. The problem I faced with this is you have to always track the latest version and the merge issues if you have two copies one at home and one at office. This tool can be an alternate for online tools available for those who are afraid of privacy.

Buxfer:


I then moved on to an online expense tracking tool Buxfer. I used it for almost 5 years, its free and it has lot of features that reduces your manual work. It allows you synchronize with your bank account (For Indian users it allows only ICICI and HDFC).

You can create Wallet as an account and store the amount in you wallet and add manual transactions daily. For the transactions that you made with your debit/credit card it will sync automatically with your bank account and create an entry here, only thing you need to take care is tagging the transaction.

There is feature to create automatic transaction which I use it for recurring expense like Loan, Rent etc. It creates an entry with predefined tag and also generate alert as sms or mail.

Buxfer is a really cool tool, it gives you a lot of analysis of how we spend and also gives you projections on whether you will overshoot your budget.


Intuit


Currently I started using free trial of Intuit for my expense tracking(Intuit Trial). The paid version comes at 402.80 per year. Intuit is known for their famous softwares like Quicken and Turbo tax. Intuit acquired Mint in 2009 and gained lots of expertise in online personal finance tracking tools.

Man I love this tool. You can synchronize almost all the major bank accounts in india. It also helps me to synchronize my portfolio from money control and form ICICI direct which is a major plus. I can view my entire financial status at one point. It has alerts and remainder too!!

Initially I was worried about the data security but my friend who is working for Intuit explained me about the level of security which somehow eased my initial jitters.

-----

The major advantage I gained after tracking my expenses are

• It induced my interest for learning other areas of personal finance.
• I can easily track the money I loaned.
• I stopped taking loans from my friends, since I budget every expense an year ahead.
• I always know how much cash I will have at any particular point of time for that year.
• I never missed my Insurance payments and bills.
• I started advising my Dad  :) 

Disclaimer: I suggest you to please analyze the security features of whatever tools you want to use and make an informed decisions.