Tracking Your Expenses

Bookmark / Share

  • Only your savings is your money
  • Track your expenses to see your current real situation
  • Focus on FAT expenses and decrease them slowly
  • Download expense tracking template

I believe that this is one of the most important processes that you can do for your finances. You need to understand where your money is going. Remember, your money is not what you receive in your wages each month, it is the money that is left over after paying your mortgage/rent, utility bills, additional taxes, and any other payments that you have to make. Your disposable income is your money.

I’ve heard people say, “shure, I know where I am spending my money! I know how much I spend on petrol every month! I already know how much I spend on food every month! I can’t change any of that”. My reply is usually, You think you know but until you start tracking those expenses you don’t really know. I was surprised by this myself, I thought I was spending about €50 per month in diesel for the car. After tracking my expenses, I found it was closer to €70.

There are some tracking apps out there, like Ynab, Spending Tracker, Money Manager that may help you with this. However, I track my expenses the old fashioned way with Excel. I spend about an hour each month entering my expenses from my bank account. I try to use my debit card for any purchases that I make. So that I can transfer the transactions to my spreadsheet.

Once I had enough data I was able to see what I was really spending my money on. There were a lot of surprises; for example how much my car was actually costing me. I kept the fuel costs separate to other car costs like insurance, tax, maintenance etc.. Just so that I can see what my average monthly fuel costs are.

Each month after I enter the data, I look at each category and see which one I can focus on in order to decrease even if it is only a 1% decrease. For example, can I change electric providers to get a cheaper rate. Try to focus on the FAT expenses first; FAT expenses are Food, Accommodation, and Transport. They are usually the highest expenses.

I don’t take this too far though; I don’t want to reduce my current standard of living too much.
A friend said this profound statement to me last week, which I think is worth sharing; “Now that we are tracking our expenses and putting more into savings, we actually enjoy eating out and specials events even more now. Where before we would eat out on a regular basis and go to special events whenever we felt like it. Once we took that away from ourselves, there is more value to them now.”

You can get a template of my Excel file here: https://drive.google.com/file/d/1pRjOpOsRuUw5mg5MhcTMuWaKO0L9ib__/view?usp=sharing

Feel free to download it and customise it as you wish.

I fill in the information in the Data tab under the appropriate month. I put my wage information under the following month as I receive my wages at the end of the month and that money is used for my expenses in the following month. For example, At the end of April, I received my wages but I add that to May as that money will be used for expenses in May.

Averages Tab: this tab displays the last 12 months averages, total spent on the category for the year, monthly averages and total for previous year. I use this tab to see what I am spending my money on for each category and also to see what the delta is between the last 12 months average with the averages of the previous year. I look at the FAT expenses; Food, Accommodation, Transport and try to decrease these each year; even if it is only by 1%.
LInes 40 & 41, calculates how much I will need in investments for retirement. This is based on the 25 times annual expenses and the 4% rule. More on this later.

Avg – Yr Tab. This tab pulls the averages and totals from the Average tab and calculates whether the expense averages have increased or decreased. Column F will highlight the cells in green if the expense decrease year-over-year (YoY). It will highlight in red if the expense average increased.

Charts Tab. The four charts on the left; Necessary Spend, Discretionary Spend, Income, Total Expense show the trends for each. The other chart show profit/loss for each month; this is a simple calculation of total income minus expenses.

Comment below what you think about this or if you have any suggestions for improvement.


Bookmark / Share

Related Post

Leave a Reply

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