How tracking investments instead of expenses changed my life!

How I achieved financial independence by tracking investments and increasing them instead of micro-managing and tracking monthly expenses. You can download the investment tracker that I use.

Published: January 2, 2020 at 11:02 am

Last Updated on January 10, 2021

As I opened a new column labelled Jan 2020 in the spreadsheet, I realised that I have been tracking monthly investments for long term goals in the same excel file from Jan 2011. A transition from tracking expenses to tracking systematic investments has changed the way I look at money and has taken me to financial independence within a decade of regular employment starting from a net worth of minus three lakhs (I was in debt).

Before we begin, as announced on Youtube, a video lecture series on Goal-Based Portfolio Management: Techniques to reduce fear, uncertainty, & doubt will be launched soon. This will discuss strategies to use and manage the right asset allocation no matter what the market condition is. FAQ about the course can be found here and here. You can register via this Googe Forms link for a notification upon launch. Note: the course is not about mutual funds or stocks. It is about goal-based investing and asset allocation for DIY investors ready to take it to the next level.

Some history about expense tracking. I have the account notebooks maintained by my great grandfather (would crumble into bits if I try to open it), my grandfather, and of course, my parents – using which I was able to write about, Inflation in India: Some Real Numbers.

My parents managed the expenses and tracked them until Jan. 2006. When my dad fell ill, I started to use his notebook along with my wife to track expenses. We used the so-called envelope system like my parents. We used plastic dabbas instead of envelopes because they tore often when we repeatedly checked if they were empty or not!

In the envelope system, each type of monthly expense – milk, vegetables, salary for paid help etc. – would be placed in an individual container at the start of the month. The idea is that the basic and mandatory monthly expenses are accounted for, at the start of the month itself.  Only the amount in the container should be (theoretically speaking!) used for a particular expense. Each month we would try and keep some dabbas in different places in the house to see if that would prove lucky and reduce our expenses. No such luck.

In 2007, I switched from a notebook to a graphing software called Microcal Origin. I had never used Excel at that time.  I still maintain that file but do not update it.

Soon when I started making retirement and goal planning calculators, my emphasis shifted from “how are we spending?” to “how much are we investing?”. That was a bit of a watershed moment for us.  The goal each month was to invest as much as possible. Initially, I was not able to invest as much the calculators told me to.

Somewhere along the line, I realised that as long we invested enough, it did not matter how much we spent (without borrowing). That is when I decided to give up the envelope system.

The key,  in my opinion, is to track investments. Not expenses and not definitely not returns (at least for the first few years). So I created columns in Excel where the monthly investment target for retirement and other long-term goal were listed for the current year. I decided to increase this investment amount by say, 8-10% each year.

Later on I developed it into a monthly tracker (download link below) which everyone could use. Here is a screenshot to illustrate my point.

Financial goal tracker for investments

I tried to beat the target as much as possible that it irritated my wife. At times we did not have enough to meet monthly expenses because I would have invested a large chunk of my salary as soon as I got it.  Yes, ‘pay yourself first’, expenses  = income – investments, and all that sort of thing. It worked wonders to my net worth.

Unfortunately, I was a little too obsessed about investing. For close to 6  years, I was able to invest like clockwork. Thankfully, much of that was during the sideway market after 2008.

Unfortunately, soon I witnessed the perils of unexpected recurring expensesMy mom broke her hip (read about my experience with cashless mediclaim)  and required an attendant. This sent my cash flow for a toss. My investment schedule was severely affected and it took me quite a while to recover. Fortunately, the markets started to move up around that time and all that “capital in the market” paid off big time. By December last year, I was able to catch up with my investment schedule.

My point is, first I was obsessed with tracking expenses. I got over that but instead became obsessed about investing each month. I soon realised that life can make investing regularly difficult at times. Now I am a lot more relaxed. As long as I meet my target for the year, I am fine. Don’t need to do it each month.

Systematic investing with a little luck from the market has taken me to financial independence: This is my 2019 personal financial audit: Have you done yours?

Older versions of above Post:

If you are a young earner, I suggest you do not track your expenses or spending habits (get rid of those budgeting apps). Instead, focus on your long-term goals and how much you need to invest for each of them. Set your targets and do your best to meet it at least on a yearly basis. If you do it on a monthly basis, you can engage in some guilt-free spending faster!

From Jan 2011 to Jan 2010 the total monthly investment for long term goals has increased at an annualized rate of 17%. My target is 10% but it is not possible to do that each year. There will be some good and some bad years. The key is to improve the investment amount as much as we possibly can each year.

You can use this monthly financial tracker for this purpose. This is based on the version that I use, but only much neater! Download the monthly financial tracker

Do share if you found this useful

How to profit from content writing: is our new ebook for those interested in getting side income via content writing. It is at available at a 50% discount for Rs. 500 only!
Did you know? We have more than 900+ videos on YouTube to explore! Join our YouTube Community!

Use our Robo-advisory Excel Template for a start-to-finish financial plan!

Join our courses in exclusive Facebook Groups!

  • 520+ members are now part of our new course: How to get people to pay for your skills! (watch 1st lecture for free). Learn how to get people to pay for your skills! Whether you are a professional or small business owner who wants more clients via online visibility or a salaried person wanting a side income or passive income, we will show how to achieve by showcasing your skills and building a community that trusts you and pays you!
  • Goal-based portfolio management! Join 2125+ members and get clarity on how to plan for your goals and achieve the necessary corpus no matter what the market condition is!! Watch the first lecture for free!  One-time payment of Rs. 3000 only. No recurring fees! Life-long access to videos (10+ hours content)  in an exclusive Facebook Group! Reduce fear, uncertainty and doubt while investing! Learn how to plan for your goals before and after retirement with confidence.

Want to check if the market is overvalued or undervalued? Use our market valuation tool (will work with any index!) or you buy the new Tactical Buy/Sell timing tool!
We publish mutual fund screeners and momentum, low volatility stock screeners .every month.
About the Author Pattabiraman editor freefincalM. Pattabiraman(PhD) is the founder, managing editor and primary author of freefincal. He is an associate professor at the Indian Institute of Technology, Madras. since Aug 2006. Connect with him via Twitter or Linkedin Pattabiraman has co-authored two print-books, You can be rich too with goal-based investing (CNBC TV18) and Gamechanger and seven other free e-books on various money management topics. He is a patron and co-founder of “Fee-only India,” an organisation to promote unbiased, commission-free investment advice. He conducts free money management sessions for corporates and associations based on money management. Previous engagements include World Bank, RBI, BHEL, Asian Paints, Cognizant, Madras Atomic Power Station, Honeywell, Tamil Nadu Investors Association, IIST Alumni Association. For speaking engagements write to pattu [at] freefincal [dot] com
About freefincal & its content policy Freefincal is a News Media Organization dedicated to providing original analysis, reports, reviews and insights on developments in mutual funds, stocks, investing, retirement and personal finance. We do so without conflict of interest and bias. Follow us on Google News. Freefincal serves more than one million readers a year (2.5 million page views) with articles based only on factual information and detailed analysis by its authors. All statements made will be verified from credible and knowledgeable sources before publication. Freefincal does not publish any paid articles, promotions, PR, satire or opinions without data. All opinions presented will only be inferences backed by verifiable, reproducible evidence/data. Contact information: letters {at} freefincal {dot} com (sponsored posts or paid collaborations will not be entertained)
Connect with us on social media
Our publications

You Can Be Rich Too with Goal-Based Investing

You can be rich too with goal based investingPublished by CNBC TV18, this book is meant to help you ask the right questions, seek the correct answers, and since it comes with nine online calculators, you can also create custom solutions for your lifestyle! Get it now. It is also available in Kindle format.
Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want Gamechanger: Forget Start-ups, Join Corporate and Still Live the Rich Life you wantThis book is meant for young earners to get their basics right from day one! It will also help you travel to exotic places at low cost! Get it or gift it to a young earner.

Your Ultimate Guide to Travel

Travel-Training-Kit-Cover-new This is an in-depth dive analysis into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, how travelling slowly is better financially and psychologically with links to the web pages and hand-holding at every step. Get the pdf for Rs 199 (instant download)
Free android apps