How to Track Your Expenses with Free Google Sheets

How to Track Your Expenses with Free Google Sheets

One of the keys to gaining control of your finances is knowing exactly where you spend your money. To track your expenses and also incomes you can simply use Google Sheets. Just for you, I prepare template to track both income and expenses.

And it’s free!

So let’s go!

With this steps I will show you how to use template to track your expenses with Google Sheets:

1. Choose Your Spending Categories

Try to group each purchase based on similarities, e. g. Groceries contain all food and drinks you buy in the store. If you have different incomes try to group them too.


2. Get template

3. Edit

Then go to template and on the first tab “Overview” you should add your groups of expenses and incomes. Just simply rename “Expense 1” to e.g. “Groceries”.

Don’t edit the table with all expenses and incomes (it will be updated when you add your first expense or income in next tabs).

4. Track your expenses

For every month, you have one tab on which you should add your expenses and incomes. For every group of expenses or incomes, you have one column with a name that you add in previous step.

Every time you get income or have some expenses, just add it and in the same time, overview tab will be updated automatically. That’s it!

Why use Google Sheets? It’s free, accessible from everywhere with any device and simple to use. Need more reasons? Check my post 5 reasons to love Google Drive.

Want to get blog post notification? Subscribe to my newsletter! + free access to all my freebies
SURE! >>

  • Manisha
    Posted at 17:39h, 15 February Reply

    Hi – I am very interested in the spreadsheet but I can’t seem to access the template from the posting. Maybe my configuration is off. Can you please send it to my email address?
    Thank you

  • Rhonda Swan
    Posted at 05:01h, 01 March Reply

    Tracking your spending is such a good idea. Otherwise you will have no idea where your money is going. Great post.

    • Maja
      Posted at 07:34h, 01 March Reply

      Totally agree! Thank you, Rhonda. 😉

  • marissa
    Posted at 10:20h, 22 March Reply

    Great template! Thanks!

    • Maja
      Posted at 13:09h, 22 March Reply

      Thank you, Marissa! 🙂

  • Lizzie
    Posted at 22:33h, 22 March Reply

    is ther anyway to change it to the american dollar sign

    • Maja
      Posted at 06:15h, 23 March Reply

      Of course. You just chose all fields you want to change the format and then click Format > Number > Currency then you will see changed format!

  • Patrick Clopton
    Posted at 22:08h, 10 July Reply

    can I change from pounds to dollars some how?

    • Maja Ojsteršek
      Posted at 06:18h, 11 July Reply

      Sure, select fields > click on 123 > More Formats > More currencies and select your currency:

Post A Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.