• Skip to primary navigation
  • Skip to main content
  • Skip to footer
MOD MAJA Ojsteršek

MOD BOUTIQUE AGENCY

Websites and branding

  • 🚨 Simplify Your Business
  • FREE: The Client Flow Check
  • Client Machine
  • Free & premium courses
  • FREE: BRAND QUIZ
  • Brand & Website

How to Track Your Expenses with Free Google Sheets

14/02/2016

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.

expenses_1-en

2. Get template or create your own

Get template by click here 👉 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).
HOW TO TRACK YOUR EXPENSES WITH FREE GOOGLE SHEETS

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.
HOW TO TRACK YOUR EXPENSES WITH FREE GOOGLE SHEETS

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.

 

 

 

Posted Under: Organization & Productivity
Objavljeno v: Organization & Productivity

KAKO IZBRATI KLJUČNE
BESEDE
Free online course
How to Choose Keywords
START NOW

Reader Interactions

Morda te zanima tudi:

Related posts:

3 Areas that Should be Planned Every Month to Grow Your Business + Freebie
3 Areas that Should be Planned Every Month to Grow Your Business + Freebie
5 tips for more done in less time and less stress
5 tips for more done in less time and less stress
3-je načini, kako prihraniti denar in čas v svojem biznisu
3 Ways to Save Your Business Money and Time

Comments

  1. Tera says

    30/06/2021 at 22:18

    Hi!
    I have logged into my google account but when I enter the information above: [emaillocker]https://docs.google.com/spreadsheets/d/1dAXzzFn7zUR6nFp-Ltsgcfa_3Wp6EQ_Oc9vNucVhW8U/copy [emaillocker]

    it does not bring anything up.
    Please advise.
    Thank you!

    Reply
    • Maja Ojsteršek says

      02/07/2021 at 09:32

      Get template by click here get template.

      Reply
  2. Patrick Clopton says

    10/07/2019 at 22:08

    can I change from pounds to dollars some how?

    Reply
    • Maja Ojsteršek says

      11/07/2019 at 06:18

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

      Reply
  3. Lizzie says

    22/03/2017 at 22:33

    is ther anyway to change it to the american dollar sign

    Reply
    • Maja says

      23/03/2017 at 06:15

      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!

      Reply
  4. marissa says

    22/03/2016 at 10:20

    Great template! Thanks!

    Reply
    • Maja says

      22/03/2016 at 13:09

      Thank you, Marissa! 🙂

      Reply
  5. Rhonda Swan says

    01/03/2016 at 05:01

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

    Reply
    • Maja says

      01/03/2016 at 07:34

      Totally agree! Thank you, Rhonda. 😉

      Reply
  6. Manisha says

    15/02/2016 at 17:39

    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
    Manisha

    Reply
    • Maja says

      15/02/2016 at 20:07

      Hi. First you have to log in into your Google Account. Then just go to: [emaillocker]https://docs.google.com/spreadsheets/d/1dAXzzFn7zUR6nFp-Ltsgcfa_3Wp6EQ_Oc9vNucVhW8U/copy [emaillocker]. Have fun!

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer

MOD – BOUTIQUE AGENCY

Websites and branding

MOD – BOUTIQUE AGENCY

Want to make our planet better? But your recognition is minimal? Let’s create a brand and website that will automatically attract new customers!

  • Facebook
  • Instagram
  • Pinterest
  • YouTube

Want to get blog post notification? Subscribe to my newsletter!

Uporabne povezave

  • Portfolio
  • Online Courses
  • Hi, I’m Maja
  • Contact

Copyright © 2018–2026 MOD | Pogoji | Zasebnost
Copyright © 2018–2026 MOD | Terms | Privacy