Spreadsheets

Cash envelope budget sheet: tracking envelopes in Excel

Track cash envelopes in Excel with a simple log, balance-left per envelope and a way to record transfers so totals still match your bank withdrawal.

Editorial illustration for Cash envelope budget sheet: tracking envelopes in Excel

A cash envelope budget sheet in Excel tracks each envelope's balance from three kinds of entries: cash added, cash moved between envelopes and cash spent. Record every entry in one log and let SUMIFS calculate the balance left in each envelope. A transfer is always two rows, one out and one in, so the total never drifts from the amount you withdrew.

How do I set up the Log tab?

Create a tab called Log with headers in row 1 and one row per event:

  • A: Date
  • B: Envelope - Groceries, Auto, School, Outings and so on
  • C: Type - Top-up, Spend, Moved in or Moved out
  • D: Amount in rupees
  • E: Note

Add dropdowns for B and C through Data, then Data Validation. Using a fixed list for Type is what makes the formulas reliable, so resist typing your own words.

How do I calculate the balance in each envelope?

On a Summary tab, list the envelopes in A2 downward and add four headers: Added, Moved in, Moved out and Spent. Then:

  • B2, added: =SUMIFS(Log!$D$2:$D$1000, Log!$B$2:$B$1000, $A2, Log!$C$2:$C$1000, "Top-up")
  • C2, moved in: the same formula with Moved in
  • D2, moved out: the same formula with Moved out
  • E2, spent: the same formula with Spend
  • F2, balance left: =B2+C2-D2-E2

Add a total at the bottom with =SUM(F2:F10). That figure should equal the cash physically in all your envelopes together. If you count the cash and enter it in H1, then =SUM(F2:F10)-H1 tells you how far off you are.

How do I record a move between envelopes?

Never edit a past spend to hide a transfer. Instead, add two rows with the same date and a matching note: one row with Moved out for the envelope giving cash, and one with Moved in for the envelope receiving it, both for the same amount. The two cancel in the total, so total cash stays equal to what you withdrew minus what you spent.

A worked example with made-up amounts

Say you withdraw ₹20,000 in cash on the 1st and fill four envelopes: groceries ₹8,000, auto ₹3,000, school ₹4,000 and outings ₹5,000. During the month you spend ₹5,200 on groceries, ₹2,100 on autos, ₹4,000 on school costs and ₹3,300 on outings, and you move ₹1,000 from groceries to outings.

EnvelopeAddedMovedSpentBalance
Groceries₹8,000-₹1,000₹5,200₹1,800
Auto₹3,000₹0₹2,100₹900
School₹4,000₹0₹4,000₹0
Outings₹5,000+₹1,000₹3,300₹2,700
Total₹20,000₹0₹14,600₹5,400

The balances add to 1,800 + 900 + 0 + 2,700 = ₹5,400, and 20,000 - 14,600 = ₹5,400, so the sheet and the wallet agree. The moves cancel out at the total, which is why the check works.

Keep a small buffer envelope for surprises such as a medical visit or a relative arriving unannounced. When it empties, refill it first next month. It stops the other envelopes from being raided, and the sheet will show how often you needed it.

What if an envelope runs empty early?

  1. Check whether the envelope was too small for the month; if so, move cash in from another envelope with a clear note.
  2. Do not borrow from an envelope meant for a fixed commitment such as school fees.
  3. If you keep needing the same transfer, raise the top-up next month and trim elsewhere.
  4. Record every spend, however small, on the day you make it.

Does this work with UPI and cards?

Cash envelopes only cover cash. Payments by UPI and card still appear in your bank or card statements. SpendixAI can import those statements and also lets you add cash expenses by hand, several at once if you tally the week, so cash and digital spending can sit in one place. The envelope sheet remains the better tool for deciding how much cash goes where.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports