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.
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.