I have been doing this religiously every day and it helps a lot when I know where my money goes. Armed with this knowledge, I can then act to reduce or increase the amount spent/earned based on the categories that I have defined. You can do this tracking for free by using google documents, openoffice or downloading a free app into your hand-phone. I prefer doing this via google documents, so that I can access it as long as I have an internet connection.
Some of the columns that I have been using are as follows: (You can customize this to your own liking)
- Year
- Month
- Day
- Type (Example: Meals, Transport, Income)
- Category (Example: Lunch, MRT Top Up, Salary)
- Description (Example: Chicken Rice)
- Amount
How do you do your expense tracking?
I would record the large ticket items such as insurance premiums, membership fees (e.g. gym, club), income tax at another worksheet since it may make certain months look extremely heavy.
ReplyDeleteHi Maomao. I would consolidate them together in one spreadsheet so that i would know how much inflows and outflows i have in a particular month!
ReplyDeleteMerry xmas! :)