Tuesday, March 10, 2009

Sort-of-New-Year resolution: Expense logging

Manju's standard reply every year is 1024 x 768. Which I adapt after I have seen his.

Otherwise, I think I can make this my New Year resolution: logging every expense on an Excel sheet.

I've been doing it since the mid of Jan, and you won't see it until you feel it. There are multiple entries, but none so costly requiring a 'cut' in expenses. Yet the month end balance is large.

I try to be as deep in details as possible: every receipt is reproduced, with items' weight/volume and price noted, ensuring a price per weight column helping to compare similar products from two retailers.

Just looking at one month's total is scary enough. I highly recommend it for anyone. No point of complaining of lack of time: it's just a matter of remembering to enter all expenses, you can do it while say watching a movie.

This is not exactly a budget excel sheet: it is just an expense sheet for comparisons. The expenses can always be tallied with a credit card statement or a bank statement, but if you are thorough it won't be necessary.

In fact, I challenge you. Keep it for atleast one month: each and every paisa or penny spent, note it in Excel and add it up for the month. It is the middle of the month, doesn't matter at all.

I can tell you one thing: You will quiver in your feet. It also helps compare prices over time: I have noticed that some items have decreased in price dramatically, while others have increased a bit. This will prove to be a brilliant historical archive too - 5 years down the line you can track inflation on your own or brag about the intricate pricings of a bygone era.

There are several online expense tracking sites, but they do not ensure privacy. Maintain a simple Excel sheet.

Leave a comment about your trials.

4 comments:

தோகை said...

Have you tried
Money Manager Ex?
I use it for over an year (15 months exactly) and there are tools to graph/track income/expense and supports SQL statements, and also simple query GUI. It's very simple and intuitive compared to all the GnuCash/Money software out there.

«charlie|thotti» said...

Moneymanager is impressive, but
I record all items on all the receipts too, which can be done here also I guess. I will keep money manager for when things get complicated..For now the excel sheet is sufficient..

Everyone else, do give it a try.

a fan said...

a recession effect? :)

I was keeping an expense log in college days, bcos i wanted to spend the small extra money of my monthly installment wisely.

Good that, u started it.
xl sheet is the best for all financial matters including investing.

One thing which i used to do when i was in US, try to pay for almost everything using card. In that way, it's one sheet which gives a consolidated spending.

«charlie|thotti» said...

@a fan
Recession effect... well I used to note them down in a notebook, it's more streamlined now.
As for card, some shops don't accept credit cards.

Firefox 3 Firefox 3 Firefox 3 Firefox 3 Firefox 3 Firefox 3