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.




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!
Get template by click here get template.
can I change from pounds to dollars some how?
Sure, select fields > click on 123 > More Formats > More currencies and select your currency:

is ther anyway to change it to the american dollar sign
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!
Great template! Thanks!
Thank you, Marissa! 🙂
Tracking your spending is such a good idea. Otherwise you will have no idea where your money is going. Great post.
Totally agree! Thank you, Rhonda. 😉
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
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!