The Envelope Budget Method in Google Sheets

An envelope budget spreadsheet gives every spending category a fixed amount that refills on the 1st of each month. Groceries get $450, eating out gets $150, and when an envelope is empty you stop spending from it. In Google Sheets that's one tab with three formulas: what goes in, what you've spent this month and what's left. It's cash stuffing without the cash, and you don't need a bank feed for it.

What is the envelope budget method?

The method is older than spreadsheets. People cashed their paycheck, split the bills into paper envelopes marked "Groceries", "Gas" and "Fun", and spent only from the matching envelope. When the grocery envelope ran out, grocery shopping stopped until next payday.

The rules are short:

• Fill each envelope at the start of the month. The amounts come from your income, before any spending.
• Spend only from the matching envelope. Every purchase belongs to exactly one envelope.
• Empty means stop. You either wait for the refill or move money from another envelope on purpose.

Digital envelopes keep those rules and drop the cash. Apps such as Goodbudget are built around the idea, and they do some things well: they sync a shared household budget across phones, and their Premium plan can import transactions. If you'd rather keep your numbers in a file you own, or you don't want a bank connection at all, a Google Sheet does the same job with a few formulas.

Envelope budgeting is close to zero-based budgeting in a spreadsheet. Both give money a job before you spend it. The difference is the focus. Zero-based budgeting is about the plan adding up to your income. Envelopes are about the limit on each category while the month is happening.

How do I make an envelope budget spreadsheet?

You need an Expenses tab (Date, Category, Amount) and an Income tab (Date, Source, Amount). Any tracker works. If you don't have one yet, start with the free Google Sheets expense tracker template, or let Voice Sheet create its free Personal Finances template.

Then add an Envelopes tab with this layout:

Data starts in row 6. Rows 1–4 hold the month settings.

Step 1: Set the month

Put three date cells in column H, so every envelope refills on the same day:

H1 changes by itself on the 1st, so the envelopes refill without you copying the sheet or editing ranges. It's the same approach as the Voice Sheet template's Settings tab.

Step 2: List your envelopes

Fill columns A to C. A typical set for a $3,400 monthly income:

Reset envelopes start again from the refill amount each month. Roll envelopes keep what's left over, so they can build up for costs that don't come every month.

Step 3: Check that every dollar is in an envelope

In H4, subtract the envelopes from this month's income:

=SUMIFS(Income!C:C, Income!A:A, ">="&H1, Income!A:A, "<"&H2) - SUM(B6:B)

This should read 0. Above 0 means some money has no envelope yet. Below 0 means you've filled envelopes with money you don't have.

The refill formula

This is the part that makes the sheet behave like envelopes. In D6, total this month's spending for the envelope:

=SUMIFS(Expenses!C:C, Expenses!B:B, A6, Expenses!A:A, ">="&$H$1, Expenses!A:A, "<"&$H$2)

In E6, work out what's left. Reset envelopes are just Refill minus Spent. Roll envelopes add up every refill since the system started and subtract everything ever spent from them:

=IF(C6="Roll",
  B6*(DATEDIF($H$3,$H$1,"M")+1)
  - SUMIFS(Expenses!C:C, Expenses!B:B, A6, Expenses!A:A, ">="&$H$3, Expenses!A:A, "<"&$H$2),
  B6-D6)

Fill both formulas down. Here's how they behave:

• On the 1st, H1 moves to the new month. Spent drops to 0 and every Reset envelope shows its full refill again.
• A Roll envelope gets one more refill each month. If Car repairs had $120 left at the end of November, it shows $180 on 1 December.
• Last month's expenses stay put on the Expenses tab. Nothing is deleted.

One caution: the Roll formula multiplies the current refill by the number of months. If you change a Roll envelope's refill amount, reset H3 to the current month and add the old balance as a one-off line. Or keep Roll refills fixed for the year.

For more on how SUMIFS and the date window work, see SUMIFS by month in Google Sheets.

Overspending rules

Paper envelopes can't go below zero. An envelope budget spreadsheet can, so the rules have to come from you. Write them on the tab so you don't renegotiate them every month:

1. Look before you spend. Check Left before a non-routine purchase, the way you'd look inside a cash envelope.
2. Empty means closed. When Left reaches 0, that category is done until the 1st.
3. Cover overspending from another envelope, never from next month. If Groceries is at −$30, move $30 out of Fun money. Lower one envelope's refill and raise the other's, so H4 still reads 0. To keep the original plan, log moves on a separate tab, as in the zero-based guide's Moves tab.
4. Bills and Savings don't lend. Only flexible envelopes (eating out, fun, clothes) can give money away mid-month.
5. Keep a small Buffer envelope. $50–100 marked Roll gives you somewhere honest to take money from when the month surprises you.
6. Review repeat offenders. If the same envelope borrows three months running, the refill is too low. Raise it next month and take the difference from somewhere else.

Make the limits visible with Format → Conditional formatting on column E: red below 0, yellow under 10% of the refill, green otherwise.

Using the Voice Sheet template as your envelopes

If you use Voice Sheet's Personal Finances template, its Monthly Budget tab already works like a set of Reset envelopes. Each category has a budget you set once, a formula subtracts everything logged in that category this month, and the result resets on the 1st. The app shows it as the monthly budget dashboard: a card per category with what's left, or "Over by" once you've gone past it.

The template's categories are Food, Transport, Utilities, Rent, Entertainment, Health and Other, and you can edit the budgets any time. For Roll envelopes, add the Envelopes tab above in the same spreadsheet. It reads the same Expenses tab, so every entry updates both.

Logging is what makes envelopes work

Cash envelopes work because you watch the money run out. A digital envelope only works if your spending lands in the sheet right away, not on Sunday night from memory.

With Voice Sheet, each purchase becomes a row in your own Google Sheet. The free version gives you a form built from your columns, with your envelope names as a dropdown. With Premium, you can log expenses by voice: say "eating out 18 at the taco place" and it fills the date, category and amount. Voice input is English only. Voice Sheet doesn't connect to your bank, so your envelopes reflect the purchases you record, including cash. That's useful if you mix cash envelopes with digital ones. Our guide to tracking expenses without linking your bank covers that setup.

Envelopes, 50/30/20 or zero-based?

They combine well. Many people plan the month zero-based, then treat the flexible categories as envelopes and check Left before they spend. Start with five or six envelopes, log every purchase, and look at the Left column once a week. After a month you'll know which refills were realistic.