How Google Sheets help me make better financial decisions + tracking expense template

How Google Sheets help me make better financial decisions + tracking expense template

Of course, the Sindhi writes an article about money – what a cliché
10 years ago, I was upset with my parents for not buying me the new “Beyblade burst launcher”.
Who am I kidding? I’m still upset…Where’s my launcher, dad? It’s been 10 years.

Anyway, I respect their decision. While the 12-year-old me would disagree and lock himself up and give my parents the silent treatment,

I. Respect. Their. Decision.

Why? It has taught me to be more responsible and intentional with my purchases.
I was saving wherever it was reasonable, I was doing good. At least I thought so…you see, I thought I was in control by just saving some rupees. Where did I spend 90 bucks the day before? I couldn’t recall… and I didn’t take any action either.

A few months later, while just casually strolling through the internet, I happened to stumble on this powerful quote, so powerful it has changed my life.

“If you can’t measure it, you can’t manage it” – Peter Drucker

And this stuck with me. What do I do next? I grab unused A4 sheets and start keeping a track of my expenses. Before turning to the bed, I would update this sheet, without fail. It became a habit.
But, things had to change. I got my first job! I had more money at my disposal, which would also mean – I would have more expenses than I used to.
While writing my expenses down on a piece of paper was therapy to me (could I be more Sindhi?), it wasn’t practical anymore.

I started looking at apps…

Were they time-saving? Yes
Did I have any control? No

What did I do? I created a google sheet. Revised it multiple times and now I have the perfect sheet, well… perfect for me.And I want to show you how I did it.

Here’s a public version of the google sheet: click here

As you can see, I have divided this into 2 major sheets:

  1. Transaction history
  2. Summary of my expenses over the last few months

How to use this sheet – File>Make a copy
Edit the months and start filling in your data. Take note of the cell numbers as you add in multiple rows. Going through the comments on the google sheet will clear your doubts.

This sheet gives me clarity as to how much I can spend for this month/how much I should be saving.  At the same time, I’ve also learned to not go so hard on myself. After all, we’re all here to have fun.  

Not sure if it’s this sheet or my Sindhi DNA, but I’m pretty confident about my money habits. 🙂

While I cannot fully provide technical support, please feel free to reach out in case of queries.
And don’t be afraid to create your own versions, after all – we want this to be easy and fun.

P.S: Here’s an image of some of the sheets that I was referring to, with the “If you can’t measure it, you can’t manage it” cover of course.

Have you read my previous blog post on how to market your podcasts using Instagram stories? Click here
Back to Top