How to Easily Track Your Expenses with Google Sheets in 2021 (Free Template)

Use this “Digital Household Booklet 2021” to set spending and saving budgets, stick to them and keep a good overview of your expenses with Google Sheets.

Updated for 2021: Digital Household Booklet, with section for “Budget” per non-fixed category for each month, and a “Planned” savings section where you can write out how much you plan to save per month.

Table of Contents (only works on Desktop, not on mobile)
· Background info
· Reasons I use this Google Sheet
· Is this template a good fit for you?
· Free Links to this template
· How to use: Fast version
· How to use: Elaborate version
· Mac Desktop shortcuts & doing calculations
· Final steps for easy access to your template

Background info

The article first introducing the template has gained a lot of views and reads over time. Since people seem to like it, here we are with an updated template for the upcoming year, with some minor adjustments. And budgets and savings goals.

Screenshot of first ever article stats.

The need for an expense overview arose when I was dead broke several years ago and running behind on rent. I had to be extremely strict as to where every cent went. If not, I’d be in trouble. This dread clenching…