Make Saving Fun With The Saver’s Smile Savings Spreadsheet!

If you prefer a visual demonstration, here’s a video tutorial.

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.

But wait…

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.

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.

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.

If you have any questions that weren’t answered here, feel free to contact me.