Monthly Envelope Budget in Excel: Split Income into Envelopes and Track Spending

Many households know their income but not where it goes. Money runs out before the month ends and nobody knows why. The envelope method is old and simple: you divide income in advance into envelopes for housing, food, transport, savings and so on, and never spend more from an envelope than it holds. You spend consciously instead of being surprised at month end.

This sheet is the digital version of the envelopes. You enter net income and set percentages, it works out each envelope’s amount, you record spending through the month, and it shows what is left, the percent used and each envelope’s status in colour, with summary cards and a chart of budget against spending.

Who is it for?

• Households wanting to control monthly spending
• Employees whose salary runs out before the month
• Anyone who wants to save a fixed percentage
• Couples managing a shared budget

What is inside the sheet?

• Income and month entry
• Eight envelopes with editable percentages
• Budget, spent, left and percent used
• Colour status per envelope with a bar
• A check that the total is 100%
• Cards: budgeted, spent, left, savings rate, envelopes over limit
• A chart and a guide sheet

How to use it

1. Enter your monthly net income and the month.
2. Adjust each envelope’s percentage until the total is 100%.
3. Record what you spend in each envelope through the month.
4. Watch the colours: green on track, yellow near limit, red over.
5. At month end review overspent envelopes and adjust next month’s shares.

Formulas used

• Budget = share × income
• Left = budget − spent
• Percent used = spent ÷ budget
• Savings rate = savings envelope spent ÷ income

Worked example from the sheet itself

Income of 15,000 with shares: housing 30%, food 15%, transport 8%, bills 8%, kids 7%, savings 15%, fun 7% and other 5% (95% in total).

• Actual spending is 13,830 against 14,250 budgeted.
• Three envelopes went over: food, transport and fun, and the savings rate is 15%.
• Left of income is 1,170 and 5% shows as unallocated.

How the envelope method works

The idea is that every riyal has a job before the month starts. Instead of spending from one pot and estimating what is left, you create envelopes with limits. When the food envelope is empty you do not raid savings; you cut spending or reallocate on purpose. These limits give freedom: you know you can spend the fun envelope without guilt.

There are no paper envelopes in the sheet, but the principle is the same: budget, then spent, then left.

Setting the envelope percentages

There is no right percentage for everyone. The shares in the template are just a start: housing 30% and savings 15%. If your rent is high the housing envelope will rise at the expense of others. Start by recording what you really spend for two months, then tune the shares to realistic numbers.

Make savings the first envelope, not the last: allocate it the moment salary arrives, because what is left after spending rarely suffices.

When an envelope goes over

Going over is a signal, not a failure. Ask: was the limit unrealistic? was it an emergency? is it a habit? If an emergency, take from the “other” envelope or one you underspent. If a habit, adjust the share next month or change the habit.

Yellow envelopes (near limit) are your chance to act before they overrun.

Emergency fund and bigger goals

Savings can hold two goals: an emergency fund covering three to six months of spending, then goals such as Hajj, a car or school fees. You can split savings into two envelopes by renaming “other”, for instance.

Tips to stay consistent

• Record spending daily in a minute, not in the last week.
• Have spouses review the numbers together weekly.
• Adjust shares every three months to match reality.
• Print the summary and put it where everyone can see it.

Tips for best results

• Keep a copy for each month to compare.
• Start with simple shares and do not over-complicate the envelopes.
• Use “other” for what fits nowhere, then review it monthly.

Frequently asked questions

Can I rename the envelopes?

Yes, type any name in the yellow cells.

What if the total exceeds 100%?

A warning “Over 100%” appears.

Does it handle variable income?

Enter the lowest expected income and revisit at month end.

Does it suit one person?

Yes, with fewer envelopes.

Download the sheet

Press the download button at the top of the page to get the Excel file. It includes a full guide sheet, yellow input cells and formulas protected from accidental edits. The sheet is also available in Arabic from the language switcher.

The figures and shares in the template are illustrations and not financial advice.