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.

How tracking investments instead of expenses changed my life

Published: January 2, 2020 at 11:02 am

Last Updated on

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.

Want to know how to reduce fear, doubt and uncertainty while investing for financial goals? Sign up for our lectures on goal-based portfolio management and join our exclusive Facebook Community

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
Hate ads but would like to support the site? Subscribe to our ad-free newsletter and get beautifully formatted full articles delivered to your inbox!

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 topics of money management. 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 on the basis of money management. Previous engagements include World Bank, RBI, BHEL, Asian Paints, Cognizant, Madras Atomic Power Station, Honeywell, Tamil Nadu Investors 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. We operate in a non-profit manner. All revenue is used only for expenses and for the future growth of the site. 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 kind of paid articles, promotions or 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 investingThis book is meant to help you ask the right questions, seek the right 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 a deep dive analysis into vacation planning, finding cheap flights, budget accommodation, what to do when traveling, how traveling 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 Apps for your Android Phone

Comment Policy

Your thoughts are the driving force behind our work. We welcome criticism and differing opinions.Please do not include hyperlinks or email ids in the comment body. Such comments will be moderated and I reserve the right to delete the entire comment or remove the links before approving them.

9 Comments

  1. ha ha .. saw this link right after opening a new sheet in my expense tracker ( doing it from 2005).. this system has definitely helped in terms of evaluating spending patterns in various stages of my life as well as plan budget ( hoping to stick to it) for the upcoming year!

  2. In the investment tracker, in the Goal Planner sheet, does the cell “Current value of EPF or NPS corpus” refer to the entire corpus that has been built thus far (including FD, MF etc) or only the EPF and NPS?

  3. Learned new golden rule that dont track expenses.. track your monthly investments…. as long as you meet your yearly investment targets… thank you for sharing the post.

  4. Dear Sir,

    I fully agree to the fact that tracking investment instead of tracking expenses will change the game.

    But, I would like to advise newbies in Personal Finance to track expenses at least for first year. This is very essential. When we track for a year, we get a complete picture of our expenses. With the data of that 12 month’s expenditure, we can clearly identify where are we overspending, which expenses can be avoided etc… This helps in setting a realistic investment goal and sticking to investment goals. After that we can move on to tracking investments instead of expenses. But, first step in the process should be tracking expenses.

  5. Dear Sir,
    In your new year message in the video (Ten money resolutions for 2020) you had asked DIY investors to unsubscribe from Freefincal and other forums and do more useful things in life, if confidant of whatever we have learnt. Now, I think I should have done that, since I am now in a dilemma whether to subscribe or not to these videos !!!

Leave a Reply

Your email address will not be published. Required fields are marked *