pre-formatted spreadsheet to track personal/household expenses

May 8, 2011 · 1 comment

email

Track ExpensesFor many people, managing money is more difficult than earning. While we are sure from where its coming, many a times we have no clues where its going. The solution is to track your income and expenses, but implementing it practically is not so easy. It is sometimes complex, many a times a burden and all the time a boring ritual needs to be done daily.

I tried few software but found them complex/tedious, then came some websites but they vanished if I am not connected and I can not remain connected at all the time. Putting in a simple text file or writing on notepad can continue up to the time that you no longer recognize or understand random numbers written everywhere in notepad or simple file.

One solution I found which is working pretty well since 2 years is that I took blank spreadsheet in Excel and formatted it so we just need to put daily transactions/values in it and it should show in easy and nice way. A non-technical person should be able to use it with ease, is the primary requirement. My wife usually making entries in it and much satisfied. Its a daily 2 minute work.

Download the spreadsheet from here. [Updated link to new latest spreadsheet for 2012-13]

I’ve edited it to start from Jan. 2012-Dec. 2012.

It may look bit complex initially if you are not aware about Microsoft Excel.

Update as on Dec. 2011: Posted new article having latest spreadsheet, please check it here.

* Investorshine.com is not for profit site with an aim to spread personal finance literacy and enable ordinary people to make better finance decisions. You won’t find any advertisements or endorsement about any products on this site. Please spread the words by sharing it on facebook/twitter etc.

Other related articles you may like:

* Pre-formatted spreadsheet to track personal finance, expenses for 2012
* Banks are not so good and safe as you think for your money.
* Providing fake house rent can cost your job.

Leave a Comment

Notify me of followup comments via e-mail. You can also subscribe without commenting.

{ 1 trackback }

Previous post:

Next post: