I have been tracking my expenses since 2014 and recently switched from a Google Sheets template to a Google Sheets spreadsheet I stumbled upon on the blog Frugalisten.
Oliver is the author of Frugalisten and his spreadsheet made me want to switch things up. I amended his version slightly and can only highly recommend you to check out the original.
BTW: You can translate his content automatically with your browser! 🙂
If you want to use my version of the spreadsheet, please open the below link and go to VIEW -> MAKE A COPY. Please do not request edit access as this is a public version.
My money planner is structured in 3 tabs:
2020 – This tab contains all my expenses for the year, broken down into categories and includes metrics such as my saving rate in % per month and per year.
Budget – This tab is my budget tab. At the beginning of every month I look at it and calculate how much I expect to spend. Monthly expenses occur pretty much every month while annual/biannual expenses only several times per year.
Expenses – At the end of every month I fill in this tab. This tab lists all the stuff that I’ve purchased in any given month. Please note, I won’t list purchases such as toothpaste, soap or cleaning sponges.
This tab is solely reserved for purchases that can’t be “used up” such as a electronic items, household goods (fridge, pan, spoon, etc.), clothing .. I think you get the idea. 🙂
My favorite features
Now onto the features that I enjoy most about this particular Google Sheet.
Savings & Savings rate
This spreadsheet calculates my monthly savings (= income – expenses) in numbers and in % automatically. I aim for a savings rate of at least 50% per month and this feature helps me to stay on track (and also shows me when I’ve missed my goal).
Total & Average
The spreadsheet shows me the following data under Total & Averages:
- Total expenses
- Total income
- Average income
- Total income
- Total savings
- Average savings
- Savings rate
This feature is going to be especially interesting when the spreadsheet contains a year of data.
I went for a light green and rose color scheme and you can amend it to your wishes. I did choose to highlight “Groceries” because this is an expense that I like to keep a close eye on.
That was it for my tour through my new Google Sheet with which I track my expenses. Please note, all the numbers stated are just fillers and do not reflect my actual income nor spending. 😉 If you are familiar with my Berlin budget you have an idea of where my money goes to each month.
If you have any suggestions or need help with amending the spreadsheet to your liking, then please comment down below and I’ll get back to you. 🙂