Skip to content
The title slide and first slides of the Penny Saving Challenge template

Penny Saving Challenge

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
23
Difficulty
Beginner
Updated
November 16, 2026

Every slide (23)

Overview

The penny challenge is the gentlest saving plan there is: put in one cent on the first day, two on the second and keep adding a cent each day. The final deposit is $3.65 and the whole year comes to $667.95. This sheet lists all 365 days with the deposit already worked out, a Saved marker and the amount the jar should hold if every day is done.

Progress adds up the total saved, the percent of the year complete and the number of days done, with a chart that compares each 30-day block with the plan. It works well with kids who like counting coins and with families who want one shared jar. Stop at day 100 for a shorter challenge that still reaches $50.50.

Useful for

  • Teach kids to count coins and save a little every day
  • Run a family jar all year and watch the total grow
  • Start a saving habit with almost no pressure

What's included

  • 3 tabs: Progress, Days, How to use
  • Progress: a dashboard with 4 summary figures
  • Days: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Days tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How much do you save with the penny challenge?

Saving one cent on day one up to $3.65 on day 365 adds up to $667.95. The Year total on the Progress tab shows this figure.

Can I do a shorter penny challenge?

Yes. Stop at day 100 and you will have saved $50.50. The Jar total column shows what the jar holds at any day.

What if we skip a few days?

Leave those days on To do and catch up later by adding more coins. The sheet counts only the days marked Saved.

  • #savings-tracker
  • #penny-saving-challenge
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More savings tracker templates

See all 22

Also in Finance

All finance templates
Get this template

Preparing your template…