Do you think spreadsheets are boring?
Who doesn’t, eh?
Well, not anymore.
With this gamified Google Sheets savings template, you get happier and more motivated as you watch your savings grow.
As it does, the special picture starts to form! The more you save, the more complete the picture becomes.
When you reach your goal, you get a fully-formed Smiley face to reward you for your dedication.
This spreadsheet tells you how much to save per day, week, and month to reach your saving goals on time. It’s super easy to use and can be used for all kinds of saving goals.
HOW TO USE YOUR SAVER'S SMILE SAVING SPREADSHEET
After purchasing the Google Sheets Saver’s Smile Savings Spreadsheet, you’ll be redirected to a view only Google Sheets template.
In order to start using your savings spreadsheet, click File in the top menu bar and choose make a copy.
Name your spreadsheet and you’re ready to get started.
When you first open your Saver’s Smile Savings Spreadsheet, you’ll see this:
There are ugly error messages like “#VALUE!” and “#N/A“.
Those are there because you haven’t entered your information yet.
To get started, specify how much you want to save:
Next, decide the time frame you want to save in:
I want to save $10,000 within one year, so that’s what I entered.
Now that you have the first row filled out, the “#VALUE!” messages are gone. In their places, you’ll see how much you should save per day, week, and month to achieve your saving goal.
These values don’t take your interest into account.
To determine how much you should save per month counting interest, choose “Daily” or “Monthly” under Does your bank compound monthly or daily? from the drop down menu.
If you don’t know how often your bank compounds interest, just call and ask. The Federal Reserve Board requires them to tell you if you ask.
Once you know how often your bank compounds interest and you’ve entered your interest rate, you’ll see how much you should deposit into your savings account per month to reach your goal.
The last cell you’ll need to fill out before you are ready to start saving is the Started With cell. Here you can enter how much money is already in your savings account.
Now, the current amount in my savings account is $5.
Adding Money To Your Savings Account
It’s time to start saving!
After you add money to your savings account, track it with your savings spreadsheet.
To do this, use the tabs to navigate to the current month.
In the top row, list your income sources. For example, you could have Job, side hustle, and gifts.
In each column, enter the amount of money you saved from that source.
The rows represent the dates.
Put the money you add in the row that corresponds to the date.
If you withdraw from your savings account (why would you do that?), you can add a minus symbol ( – ) in front of the amount you withdrew.
That amount will be red, so you can easily distinguish between money added and money withdrawn.
Changing The Dates On Your Savings Spreadsheet
The Saver’s Smile Savings Spreadsheet only supports 5 years, starting from January 2019.
If you are starting from a different year, you can change the year by holding CTRL + H on PC or ⌘ + H on Mac.
In the Find field, type the year you want to change and in the ‘replace’ field, type the year you want to replace it with. Then click Replace All.
For example, if I start saving from 2020, here’s what I would do:
And then I’d repeat the process to enter the correct years for the entire 5 years that I’m using my spreadsheet for.
If you have any questions that weren’t answered here, feel free to contact me.