Record Your Expenses

In my previous posts, you have seen my monthly and annual budgets. Now it is time I explained how I actually track and record my expenses, so I know how I am performing compared to the budgeted numbers.

Most of our expenses are paid through debit cards. But in some cases, the vendor does not accept a card, in which case we use cash. We use two debit cards to make payments. Both cards are setup to send an email to me when any amount is debited from the bank. We make online payments or money transfers via NetBanking or Google Pay. We use only one wallet, which is in BigBasket. When we don’t want to go out to buy stuff or if something we want is not available in the local shops, we use BigBasket. To make it easy, so anyone can buy groceries online (including my mom), without having to worry about paying via NetBanking or using debit card, I opened a wallet in BigBasket.

Given this information, tracking is a simple affair. As usual, I just use a spreadsheet to track all my expenses. First, any time I get an email from my bank about an expense made on debit card, I add the expense to the spreadsheet within the day so I remember what the expense is for. This covers all the online and offline transactions made via debit cards. For cash purchases, we don’t usually track them unless they are paid for non-food related things. For example, my daughter’s skating fees is paid in cash, so that has to be tracked separately. Otherwise all cash expense is considered as food expense. At the start of every month I take stock of how much cash we have and then at the end of the month, deduct the cash left. The difference is what is considered as food and cash expenses. The same is the case with BigBasket wallet. The difference between the end of month and start of the month is considered as the food and cash expenses. Next, all annual expenses are tracked separately from the monthly ones. Enough talking, now for some numbers then.

Record of my expenses for January 2019 (click to enlarge)

The above image is a snapshot of my monthly and annual expenses for January 2019. On the left are the list of expenses (monthly and yearly in separate columns) as they happened by date. On the right (with colored background) are the accumulated expenses for each expense type. That is how I go about tracking my expenses. In some months, there may be no expenses under some expense types, for example vehicle insurance. So the monthly expenses will be less in some months and a lot more in others. While my monthly budget is Rs. 53,000, I spent about Rs. 30,000 in January and about Rs. 25,000 so far in February.

If you want to understand where you are spending, you too should consider tracking expenses, perhaps not in such detail, but at least at a high level. I did not have time to keep track of my expenses so accurately before I retired, but now I do 🙂

Join the club

Get all the latest posts straight into your inbox

7 thoughts on “Record Your Expenses”

  1. Have you tried any of the tracking apps like Moneyview or Walnut? They use SMS data to filter spend by categories – food, grocery, travel etc. The good part is you don’t need to track manually. You can also filter out data (eg: corp credit card). The bad part is it’s a bit of a black box where sometimes legit SMSes are ignored. The cash spent is tracked as ATM withdrawals which also send out SMSes. The assumption is that everyone in the house uses bank accounts linked to a single phone number which receives all these transactional SMSes.

  2. Thanks for pointing out the apps!

    Never tried or even explored expense tracking apps, mainly because I am not sure they will be able to categorize correctly. I might buy a birthday gift from Lulu which sells groceries and toys among other things. So I will have to manually move the expense to a different category. Not sure if these apps have a way to export as xls because I need to do some analysis on my spend. Might as well put the effort in doing a spreadsheet.

    Having said that, it may be better to use an app if one is time constrained and don’t need the analysis part.

  3. Yes, it works well for lazy / busy folks who don’t want to spend time on expense tracking. And yes, you will need to re-categorize every now and then. They do have a export + email CSV – but it’s only the parsed SMS data – not aggregated.

    1. Instead of replying to your comment, I might have just commented. And may be you subscribed to “replies” only. Lets see if you see this comment in your email

  4. Those apps which scans our SMS and eMails scare me to the core…I can’t trust them especially when we get all the OTPs, temporary passwords over phone. I would rather stick to the traditional way of recording expenses (never did that in my life so far) than relying on these unreliable apps

Leave a comment