Skip to content
100 Envelope Challenge cover: a sample sheet with challenge goal, saved so far and left to save and a doughnut chart, beside the Dashboard and Envelopes tabs

100 Envelope Challenge

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
9
Difficulty
Beginner
Updated
November 13, 2026

Every slide (9)

Overview

The 100 Envelope Challenge is a year-long savings plan for anyone who wants a clear target. The Envelopes tab lists envelopes numbered $1 to $100, each with a status, the date it was filled, the method used and a notes column. The Dashboard shows the $5,050 goal, the amount saved so far, what is left, how many envelopes are filled and a doughnut chart of savings by method.

The sample sheet marks the first 27 envelopes as saved so you can watch the totals move. Make your own copy and reset each status to To do before you start. Keep one method for the whole challenge where you can, and note any bonus or extra cash in the notes so the record matches what you moved.

Useful for

  • Saving a set amount each week toward a year-end goal
  • Building a cash cushion for surprise bills
  • Showing children how small savings add up over a year

What's included

  • 3 tabs: Dashboard, Envelopes, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Envelopes: 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 Envelopes 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 do I start the 100 envelope challenge?

Label 100 envelopes from $1 to $100. Each week, fill the envelope that matches the week number, or fill them in any order you like. Record each one as Saved on the Envelopes tab with the date and the method you used.

Can I fill the envelopes in a different order?

Yes. Some people start with the smallest envelopes and others start with the largest. The total at the end is the same either way, but keeping to the numbers makes the Dashboard easier to read.

What if I miss a week?

Fill the envelope when you can and keep the same amount. Jot a line in the Notes column and you will remember how each draw went. A missed week does not change the $5,050 goal, only the date you finish.

  • #savings-tracker
  • #money-saving-challenge-100-envelope
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More savings tracker templates

See all 10

Also in Finance

All finance templates
Get this template

Preparing your template…