How to Track Your Expenses?

by Vinaya HS on March 6, 2007

in Finance

Thanks for visiting Capital Advisor. I frequently update this blog to cover various topics on personal finance such as investment strategies, financial products that you should buy and ones that you really should stay away from, financial calculators, emerging themes such as early retirement and financial independence, and much more. You can Subscribe through Email and receive new articles directly in your Inbox or you can Subscribe through the RSS Feed and receive new articles in your feed reader.

Here’s an expense tracking template (Microsoft Excel workbook) I have been fiddling around with since January, 2007. It’s very simple to use and allows you to track your expenses to the rupee.

Fill in the “Sources of funds” section whenever you draw cash from an ATM or bank, make a payment from your savings account via ECS or check, or spend on your debit or credit card. Fill in the “Application of funds” section whenever you have an expense (cash, credit, check, or ECS). The cell labeled “Cash position” should be positive (meaning you have cash in your wallet) or should be zero (meaning you don’t have a dime in your wallet). The value in this cell is computed automatically. The idea is to match sources of cash/credit with uses of cash/credit.

Use the “Template” worksheet to create a fresh template at the start of each month and rename the worksheet as appropriate.

Download the expense tracker template.

Click here for an example / demo.

It’s worked extremely well for me. I now know exactly where my cash/credit is going. Check it out and let me know what you think of it.




Thanks for reading this article. I'd love to hear your opinion. Please use the comments section below to share your thoughts. I frequently write new articles that also cover several other aspects of personal finance including credit cards, financial goals, health insurance, income tax, life insurance, mutual funds, retirement planning, and much more. You can Subscribe through Email and receive new articles directly in your Inbox or you can Subscribe through the RSS Feed and receive new articles in your feed reader.

{ 3 comments… read them below or add one }

Hemant March 10, 2007 at 12:21 PM

Hey That’s a very helpful template! Will help me understand and figute out where those Sing Dollars mysteriously disappear every month! :-D Thanks!

Neel March 22, 2007 at 1:07 PM

on the same lines check this website…
http://www.rupeex.com
you can track all the expenses…even your investments !
right now the feature is free..make hay while sun shines….

LittilGurl March 26, 2007 at 4:27 PM

hey this is FANTASTIC!! wanted to create something similar.. now I can just save time and use this ;) cool!!

Previous post:

Next post: