{Free Template} How To Track Expenses With Spreadsheet Like A Pro

I partner with some companies (only the good ones!) that I think will be beneficial to my readers. If you purchase through my links, I'll get a small commission at no extra cost to you! To know more please read my disclaimer.

If you find the post helpful, please share it around!

how to track expenses with spreadsheet - new 2-min

When I first started getting more serious about my finances, the first thing I did was to learn how to track my expenses. Until I learn how to track expenses with spreadsheet like a pro.

Just because I would have a bit more clarity and control of where my money goes.

It sets up for everything that I wanna do with my money later.

I started to track expenses with a spreadsheet on a monthly basis and I’ve realized that I don’t usually remember the things that I had spent my money on by the end of the month.

I wasn’t doing the envelope tricks cause I’m just not a fan of holding cash, and even if I were to do it, with moving one envelope’s money to another, I just couldn’t keep up with just how much exactly I had used for each category and for what things exactly.

So instead, I started tracking my expenses daily, and weirdly enough, it has worked out for me until now.

I thought I’d share my thoughts on how I came up with the system and how I usually do it.

But first, I think it’s important for us all to learn the importance of tracking where your money goes.


Related Posts That You Might Like:


Why You Need To Track Your Expenses

I know some people who would just spend their paychecks and only pay their bills at the end of the month when there’s sadly not enough balance. Thankfully, that’s not the majority of people I know – if you are in this bracket of people, I hate to break it down to you, but you’d need to have an intervention on how you’re managing your money…

There are also others who are a lil bit more responsible and would pay their bills once their paychecks come in and just use the leftover money they have on personal things. And hopefully, that had worked out well for them.

However; for someone like me, who is itching to know how did my $100 bill becomes $5 bill in just one day, I kinda need to start tracking how exactly I’ve been spending my money daily.

Also because, without knowing where your money goes, it’s going to be harder for you to start budgeting in the future.

If you’d like to read more on why budgeting is important, you can read this article from TheBalance on 7 reasons why you should budget your money.

So Set A Specific Budget

When you start budgeting, you’d be needing to set aside a specific amount of money in different categories of expenses that you can use every month. If you’re not sure of your spending pattern, you might put less budget in a category that you usually spend the most – and when you overspend the category, you’ll feel demotivated and give up on it entirely.

I’m saying this cause I’ve gone through it, boo…

Crying GIFs | Tenor

Of course, you can start budgeting without having the trouble of tracking your expenses, but from my experience, tracking your money first will definitely give you a clearer picture of how much to budget in each category.

When I first started tracking my expenses, I realized that I’ve been spending over $100 per month on bubble teas. The price of bubble tea averages at $9. I had about 10 bubble teas per month, at least twice per week OMG.

Ever since then, my bubble tea budget per month has been set at $40. I still have it once per week. What is a week without bubble tea, am I right?!

So when you know you’re overspending in some areas, then you can put rules and shift your spending pattern, that’s aligned with your #moneygoals.

How I Prepare My Google Sheet

I’ve started tracking my money ever since I’ve started earning money.

I’m just very conscious about where my money goes and so I just started building my own spreadsheet bit by bit. Also because I wasn’t aware of all the advanced apps out there before and I kinda have a specific template in my head, that I thought would be easier to be put on a spreadsheet.

Over the years, I’ve kinda perfected how I’d like my spreadsheet to look like and… *drum roll* I’m going to share it here! (Yay?)

Episode 9 Wink GIF by The Bachelorette - Find & Share on GIPHY
If you’d like to grab the EXACT template I’m going to show you, you can grab it below for FREE 🙂

[convertkit form=1525648]

My method is to create a Google Sheet (personally because I’ve been a Google fan and I use a lot of Google products including my phone hehe) because it’s very easy to be updated on mobile and can be easily accessed anywhere.

I create 1 sheet with multiple tabs in it but everything is basically inter-connected.

Below are the tabs that I have:

  1. Overview
  2. Recurring Payment
  3. Savings Goals
  4. Transportation
  5. Food Out
  6. Office Expenses (optional)
  7. Groceries (optional)
  8. Personal Spending (optional)

1) Overview:

how to track your expenses #1-min

This is where I will put down all of my incomes (I break down my fixed income to other miscellaneous incomes from Cashback or claims), my fixed expenses, my investment accounts, my savings & of course, my guilt-free spending! 🙂

Each column will represent each month and at the end of each column, it will show me whether I would have a positive or a negative balance at the end of the month.

Preferably I would be having 0 so that I know all of the extra money will be put into my savings account.

2) Recurring Payment

how to track your expenses #2-min

This is just to make me aware of all the recurring payments that I might need to remember such as car insurance, road tax, my Grammarly subscription, domain names, Wealthy Affiliate membership, and so on.

It’s best to put these payments on a separate tab so that you won’t get a shock of your life when the payments are due. I also usually plan these payments a few months ahead before the expenses come.

What I’d also do is to put a mark (X) of the items on the expenses tab, so I’d know exactly when to pay all of those recurring payments.

3) Savings Goals

how to track your expenses #3-min

Savings are pretty much a must, especially your emergency fund. If you have no savings whatsoever right now, make sure your first money goal is to actually save for the rainy days!

With savings, what you wanna do is to write your goals and give each of them a specific goal $$ value and how fast you would like to achieve them; 3/6/9 months? Then divide the $$ value by the number of months. You’ll get the amount of money you’d need to be saving every month starting now, to meet your goals!

4) Transportation

how to track your expenses #4-min

I personally created a new tab for this since there are a lot of transportation costs like GIRLLLLL.

Car insurance, car road tax, car maintenance, petrol, tolls, Uber/Grab/Lyft.

I definitely wish that I live in a place where there’s no necessity for me to own a car..

5) Food/Dining Out

how to track your expenses #5-min

So I started creating this Food Out category because sometimes you just never know how much you’ve actually been spending eating out.

Especially if you have fancy friends where fancy Friday dinners every week is a must and drinks every weekend is a routine!

I’ll be honest, I’m not a fan of spending too much eating out, so that’s why I would like to keep a closer eye on this category as I don’t wanna be over budget. If my budget for eating out for the month is getting low and there are friends who invite me out, I will literally tell them that I don’t have any budget left to go out.

Your real friends will understand.

Sometimes it does make your friends reluctant to invite you out again (sorry friends) but in order to compromise, I’ll usually invite them home for dinner and play board games instead.

6) Office Expense (Optional)

how to track your expenses office expenses

You don’t really need to do this tab, but I do it because my last office was located beside a shopping mall. It was so tempting to go out and eat there every day, which is not the most economical thing to do since a lot of restaurants in shopping malls are usually more expensive.

So I just like to keep track of that. As well as to restrain myself from buying a lot of junk food during lunch for snacking!

7) Groceries (Optional)

how to track your expenses grocery

Okay. I’ve gone crazy with grocery tracking.

You don’t really need to do this, but I like to keep track of every, single, thing I bought. Even salt, or toothpicks.

Because to me, I’d like to have the luxury of knowing when was the last time I bought my toothbrush and when do I need to buy them again. Sometimes, when there are big sales from a shop, I would also create a note just if my future self needs to know how I got that shampoo 50% cheaper than usual..

Also, kinda nice to know that I need to cut off from instant noodles since I could see that I’ve been religiously buying them every month.

8) Personal Spending (Optional)

how to track your expenses personal spending

I separated the tab into a few subcategories: Random Retails, Makeup, Clothing, Courses, Travels and House Things (because I bought a house. Read my post here if you would like to know how I bought my house at 25)

You honestly don’t need to copy everything that I do here cause it CAN be tedious! Create something that works for you and YOUR lifestyle! 🙂

Making Time To Fill Up Your Expenses

So you might be wondering, with all these crazy expenses, how do I actually have the time to fill in my expenses every day?

Before this, I would actually fill the sheet up every time I bought something – which is not the best way to do it, to be honest. Cause you don’t actually have all the time in the world to check in to the sheet every time you go out of the shop.

I actually got this idea when I was talking to my ex-colleague about tracking my expenses and he told me that he actually created an alarm clock every night to remind himself to fill up his sheet – and I was MINDBLOWN! ??

Ever since then, I’ve been setting up alarms at 10.30 pm every night to make sure I take the time to fill up my expenses tracker.

My advice is also not to skip so many days cause trust me, you won’t be able to remember all of your expenses after 4 days.

Different Ways of Tracking Expenses That I’ve Tried

The spreadsheet method is not the first method I’ve tried when tracking my expenses. I also tried a couple of other methods.

a) Paper: This could work, but sometimes I don’t wanna be bringing my papers everywhere I go and travel. I just want something easily accessible like, on my phone.

b) App: I know this has worked with a lot of people BUT it just doesn’t stick with me. I’ve paid for an app before but sometimes I just need to see the bigger picture and not only on the bar or pie chart they give me.

I Tried Oh Well GIFs - Get the best GIF on GIPHY

So… the winning method for me isssss spreadsheet! Just because I have much better control of how I want it to look and be like.

Creating Your Own Monthly Expenses Template

The expense tracker should be personalized to each individual. If you like certain methods, just go ahead with it.

It’s all about taking the first step to actually start tracking where your money goes and knowing exactly how to make your spending habits better.

So! I’ve shared MY favorite method. How about you, have you started tracking? Share with me in the comment section! 🙂

P/s: If you find value in my post, please help to share this around, on your social media, or even email it to someone. So more people will be empowered to manage their money better – and for me to know others are liking what I’m writing 🙂

If you find the post helpful, please share it around!

16 thoughts on “{Free Template} How To Track Expenses With Spreadsheet Like A Pro”

  1. Who doesn’t like to earn a little extra money, right? The author has given information from personal experience, which makes all these options mentioned here, reliable ones. As a student myself, I have searched ways to earn extra money multiple times over the internet. And I must say, this is one of the best pieces that I’ve come across. The author has not only discussed the various ways but has also given examples of various platforms where a person can try to earn money. This is the best part of this article. Also, she has shared her personal experience and thoughts about every single method, which makes it easy for us to filter our options. I am definitely going to try my hand at some of these methods!

    Reply
  2. Your posts are really amazing Wina. This is the 2nd one I read and I am super impressed on how clear and detailed they are. I love how you use photos and examples to really explain visually.

    This is really a good idea and something I always planned to do but never got around to. One thing is for sure, I know I spend too much on certain items. For instance, after downloading the Starbucks App a few years ago, and pre-authorizing my pay-pal to load my card with $25 each time my balance got below $5, I started to notice that I was getting paypal emails VERY often, to advise when “another $25 had been charged to my visa. Well silly me, it shouldn’t take a rocket mathematician to realize that when you spend almost $5/day on coffee, you are spending a ridiculous amount per month. I immediately started to make my coffee at work and saved so much money!!

    We need to be financially responsible and you chart is amazing and I never knew that good had this option. Thank you so much for sharing:)

    Reply
    • Aw, thanks so much for the kind words Cynthia 🙂

      It’s good that you noticed the spending and took control over it! 🙂 It’s a good thing to make bills payment on auto but not daily expenses. There’s a saying that it’s easier not to spend money when you only bring cash – cause you’ll feel the money going out!

      But I defo understood your situation, I also switched from buying coffee at Starbucks to making one at home. You can read my lifestyle changes post here 🙂

      And I’m glad you find the spreadsheet useful! Feel free to create your own !:)

      Reply
  3. Hello there once again, thanks a lot for sharing this masterpiece information here with us. Up until now it never occured to me that i would be able to use spreadsheet in calculating expenses, i think it is a brilliant way of tracking your finances just to be conscious of how much one has been spending and also to track your savings and lots more. Thanks for sharing this

    Reply
    • Glad you find it helpful 🙂

      And yes, tracking expenses on spreadsheet can be very useful and fun! You can make your own templates that suit you and your lifestyle!

      Reply
  4. Hey nice innovative article you have there. Having a detailed breakdown of how I spend my monthly salary has been very challenging and difficult for me, with your spreadsheet it will be much more easier to track and categories expenses of any sort. One unique feature I  love about the spreadsheet is that, you can easily retrieve previous budget/expenses . This is indeed a welcome development to personal finance management.

    Reply
    • Especially when you have multiple income streams, tracking your income can be very hard.

      This can be consolidated as your income & expense sheet, so you’ll have a go-to sheet every time you wanna do your taxes and look at the health of your finances. & yes! I love the fact that I can still see my finance pattern back in 2018! 😀

      Reply
  5. Hi there! this is an amazing article you have got here. I was how to make use of the spreed sheet but never thought of applying it to my personal financial life. For me, I think this is a good method to try out because I’m just like you; I’m not good at keeping cash.

    Thanks for sharing this with me, its helpful.

    Reply
    • Glad it’s helpful to you 🙂

      The best thing about spreadsheet is that you can personalize it as much as you want based on your lifestyle 🙂

      Reply
  6. Wow this is a great planning idea and also a way of managing ones finance. I’m also careless with cash with me as I spend more than I save even more than I earn which isn’t good at all. I will try this out, I just hope it works for me the same way it did for you.

    Thank you very much.

    Reply
    • Yea… that’s exactly what you wanna avoid – spending more than you earn cause you’ll always be in debt. I hope you’ll take some inspiration from here and start tracking your finances 🙂

      Reply
  7. Hello there, thank. You for this very detailed and informative post on how to track expenses with spread sheet, I mist day that this is a very timely post for me because I am realky faced with the challenge of remembering how I soend my monthly income most time I end up not even able to save nothing because of lack of tracking, i really hope to adopt this method to track in my expenses. Thanks for sharing.

    Reply
    • Hey Jomata, I’m glad you found this helpful!

      Especially when you do affiliate marketing and earning online, our income can vary month to month, so it’s always good to keep a tracking sheet of our monthly income & expenses! 🙂

      If your income is not fixed, what I usually do is to create 2 different accounts. All earnings will go to account A and I make it to make a monthly contribution to my daily use account B. This way, you won’t be spending all of your hard-earned money just like that 🙂

      Reply
  8. Hello!! I would love to use this exact budgeting template but I can’t seeem to find where I can download it! Could you link it here? I love your system!

    Reply

Leave a Comment