Skip to content
The title slide and first slides of the Cash Envelope Weekly Tracker template

Cash Envelope Weekly Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (6)

Overview

The cash envelope method puts a limit on each category by holding the money physically. This sheet mirrors the envelopes so you can see the numbers. The Envelopes tab lists each envelope with the cash you load each week and the number of weeks loaded. It adds up the cash loaded, subtracts what you have spent and shows the balance and a state of OK, Almost empty or Overspent.

Each purchase goes on the Weekly Log with a date, envelope, amount and note. The Balance tab shows the cash loaded, spent and left for every envelope with a column chart, and the percent of each envelope used. Sample envelopes cover groceries, gas, dining out, fun money, kids, personal care and pets. Change the names and weekly amounts to fit your own plan.

Useful for

  • Stick to a weekly cash limit for groceries and gas
  • Know what is left in each envelope before you shop
  • See which category runs out first

What's included

  • 4 tabs: Envelopes, Weekly Log, Balance, How to use
  • Envelopes: a table
  • Weekly Log: a table
  • Balance: a dashboard with 4 summary figures
  • 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 cash envelopes work?

You assign a category to each envelope, put cash in every week and pay only from that envelope. When it is empty, spending in that category stops until the next refill.

How do I record a refill?

Add one to Weeks loaded for each envelope when you add a new week of cash. The cash loaded figure updates.

What if I pay partly by card?

You can, but log only cash purchases here so the balance matches the cash in your envelopes.

  • #budget
  • #cash-envelope-weekly-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More budget templates

See all 61

Also in Finance

All finance templates
Get this template

Preparing your template…