Feb 23, 2025

Cory Diary : Making Sense on Tracking Expenses

Over the decades i do quite a few attempts to track expenses. None of this works well because it requires alot of work and therefore I only do them briefly. Now, I have fine-tune much simpler way to collect expense data in-which I like to share.

Regardless using ATM or Credit Card Payment or Giro or .... they are recorded in the saving account. This includes salary, dividends, transfers etc. Therefore the data is already there. There is no need to manually replicate data into another tracking app.

On a regular monthly or bi-monthly basis depending on your bank search limit, we can download the information into Excel. Tag those with high expenses and those that aren't expenses. Usually different columns. Is that simple.

Afterwhich, play with the data as you wish in Excel.



The effort only takes like 15 min to 30 min depending on individual specific needs. For me, I will combine all the data into an excel tab for the entire year. And break them into monthly grouping. I also have remark columns for specific situation for example credit card is usually lump sum payment. So I would look at the card statement, and add remarks on key expenses. One thing to watch is to single out non-expenses or transfer to another saving, investment accounts etc.

Once the data is cleaned, we can investigate how to manage our expenses better. Ofcourse you can use this to track different income or returns.



A sample of Year 2024 Expenses. Ofcourse there is no decrease ....


Cory Diary
2025-0223

CoryLogics Invest Chat - No Coin, No Porn, No Penny

Telegram CoryLogics <= Link to Telegram Chat
Telegram Cory Channel <= Link to Channel

Disclaimer: The articles presented in this blog reflect personal opinions and are intended for informational and sharing purposes only. Not responsible of errors. Readers are advised to seek professional guidance when making financial decisions and should take full responsibility for their choices.









No comments:

Post a Comment