Envelope budgeting in a spreadsheet (without the paper envelopes)

Envelope budgeting is zero-based budgeting with better metaphors. Money sits in named buckets. When a bucket is empty, you stop or you move money on purpose.

The physical version was literal: cash in labeled paper envelopes, and when the dining envelope was empty, dinner was at home. The spreadsheet version keeps the constraint and drops the trip to the ATM.

Spreadsheet version

Each envelope is a row: name, monthly fill amount, current balance. Income hits a “Ready to assign” cell. You distribute until that cell is zero.

Spending reduces the matching envelope. Overspending requires an explicit transfer from another envelope, and that’s the point. The tradeoff is visible.

One structural note: envelopes are not accounts. Your checking balance is one number; the envelopes are a plan for how that number is spoken for. As long as the sum of envelope balances matches the cash you actually hold, the model is honest. When it drifts, the usual cause is a transaction that never got assigned, so reconcile before you go hunting for a formula bug.

Categories should match the way your transactions already arrive. If your feed says “Groceries” and your envelope says “Food and household,” you’ll do a translation step every week until you stop doing it at all. See how to categorize transactions for keeping those names stable.

Why people like it

It makes tradeoffs concrete. “Dining is empty” is clearer than “I vaguely overspent.”

It also front-loads the decisions. You choose once a month, calmly, instead of relitigating every purchase at the point of sale. And it handles irregular costs naturally: an envelope you fill monthly and drain twice a year is exactly how annual bills should behave.

Why people quit

Too many envelopes. Daily assignments. Guilt theater. If the system needs a nightly ritual, it won’t survive a busy season.

The other failure mode is envelopes that never change a decision. A $12 monthly line for parking has never once made anyone act differently. It just adds a row to maintain and a small red number to feel bad about. Precision that doesn’t alter behavior is cost without benefit.

A sane default

Start with 8–12 envelopes. Refill monthly. Review weekly. Merge envelopes that never change decisions.

A workable starting set: housing, utilities, groceries, dining, transport, health, subscriptions, personal spending, and one or two savings targets. Cover the fixed bills first, then the variable categories, then whatever is left goes to goals rather than staying vaguely unassigned.

Expect to adjust the fill amounts for a couple of months. The first pass is a guess, the second is a correction, and by the third you have numbers that reflect your actual life instead of your intentions.

When it’s overkill

If your fixed costs are stable, your surplus is comfortable, and you already know where the money goes, envelopes add ceremony without insight. Tracking the trend by category is enough. Envelopes earn their keep when money is tight, when two people share a pool, or when spending genuinely surprises you month to month.

Apps like YNAB productize this. A spreadsheet does the same job with less lock-in, especially when transactions arrive by sync instead of being typed. The method is identical either way; only the data entry differs.