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 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).
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.
Tera says
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!
Maja Ojsteršek says
Get template by click here get template.
Patrick Clopton says
can I change from pounds to dollars some how?
Maja Ojsteršek says
Sure, select fields > click on 123 > More Formats > More currencies and select your currency:
Lizzie says
is ther anyway to change it to the american dollar sign
Maja says
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!
marissa says
Great template! Thanks!
Maja says
Thank you, Marissa! 🙂
Rhonda Swan says
Tracking your spending is such a good idea. Otherwise you will have no idea where your money is going. Great post.
Maja says
Totally agree! Thank you, Rhonda. 😉
Manisha says
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
Maja says
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!