How to Create a Budget Spreadsheet in Excel Step by Step

A budget only works if you can see, in one place, what comes in, what goes out, and what is left. Excel is perfect for this because it does the maths for you and updates instantly when your bills change. You do not need advanced formulas to build a spreadsheet that helps you control your money.

This guide builds a complete monthly budget from a blank workbook, with SUM formulas, a remaining-balance calculation, and a reusable template you can copy every month.

Quick Answer

Open a blank Excel workbook, list your income sources and add them with a SUM formula. Below that, list expense categories with planned and actual columns, total each section, and subtract total expenses from total income to see what is left. Format amounts as currency, save the file as your master template, and copy it for each new month.

Before You Start

• Income details: Your take-home pay after tax, plus any regular side income, benefits, or freelance payments. Use the amount that actually reaches your bank account.
• Recent spending: Your last two or three bank and card statements. These show your real categories and amounts instead of guesses.
• Fixed bills list: Rent or mortgage, utilities, phone, internet, insurance, subscriptions, and loan payments with their usual amounts.
• Excel access: The desktop app, Excel on the web with a free Microsoft account, or the mobile app all work. The steps below use desktop menu names.

Microsoft’s Excel help and learning centre on support.microsoft.com explains every formula used here.

Step 1: Create the Workbook and Title Area

1. Open Excel and choose Blank workbook.
2. Click cell A1 and type Monthly Budget. Increase the font size to 16 or 18 and click Bold in the Home tab.
3. In A2, type the month and year, for example November 2026.
4. In A3 type Item, in B3 type Planned, in C3 type Actual, and in D3 type Difference. Select A3 to D3 and click Bold.
5. Widen columns A to D so nothing is cut off. Double-click any boundary between column letters at the top to auto-fit.
6. Save immediately. Press Ctrl + S, name the file Monthly Budget Template, and save it in a Finance folder in Documents or OneDrive.

Step 2: Build the Income Section

1. In A4, type INCOME and make it bold. Leave columns B to D on this row empty.
2. Starting in A5, list one income source per row: Salary (take-home), Freelance work, Benefits, and Other income.
3. In column B beside each source, type the planned amount. In column C, type the actual amount when the money arrives. At the start of the month you can copy the planned figures across and correct them later.
4. Suppose your income rows run from row 5 to row 8. In A9, type Total Income and make it bold.
5. In B9, type =SUM(B5:B8) and press Enter. In C9, type =SUM(C5:C8) for actual income.
6. In D9, calculate the difference with =C9-B9. A positive result means you received more than planned.

Step 3: Build the Expense Sections

Fixed Expenses

1. Leave one blank row after Total Income. If Total Income is on row 9, type FIXED EXPENSES in A11 as a bold header.
2. List your fixed bills one per row: Rent or mortgage, Council tax, Gas and electricity, Water, Internet, Mobile phone, Insurance, Loan payment, and Subscriptions.
3. Enter the planned amount for each in column B. For fixed bills, the actual amount in column C will normally be identical, so copy the figures across.
4. Add a Total Fixed Expenses row under the list with SUM formulas in columns B and C, exactly as you did for income.

Variable Expenses

1. Leave a blank row, then add a bold header VARIABLE EXPENSES.
2. List flexible categories: Groceries, Transport and fuel, Eating out, Shopping and clothing, Entertainment, Health and personal care, Gifts, and Miscellaneous.
3. Set a realistic planned amount for each in column B, based on your recent statements rather than wishful thinking. A planned figure you always miss teaches you nothing.
4. During the month, update column C with what you actually spend. Updating it weekly from your banking app takes five minutes.
5. Add a Total Variable Expenses row with SUM formulas in columns B and C.

Savings as an Expense Line

Add a small section called SAVINGS with rows such as Emergency fund and Holiday or goal savings. Treating savings as a planned outgoing, rather than whatever happens to be left, is the single habit that makes budgets succeed. Total this section with SUM formulas in the same way.

Step 4: Add the Summary That Ties Everything Together

1. Leave a blank row after your last total, then type a bold header SUMMARY.
2. Create a row labelled Total Income and link it to your income total. If your actual income total is in cell C9, type =C9 in the summary cell. Linking means the summary updates automatically.
3. Create a row labelled Total Expenses. Add your three totals together. For example, if fixed, variable, and savings actual totals sit in C20, C31, and C36, type =C20+C31+C36, adjusting the references to your own sheet.
4. Create the most important row, Money Left Over, with Total Income minus Total Expenses, for example =C40-C41 using your summary cells. Make this row bold and larger.
5. Add the same summary for the planned column using the column B totals. Comparing planned left over with actual left over shows whether the month went to plan.

For more walkthroughs in this style, browse the software and apps how-to guides on Network Ustad for Excel, Word, and other everyday tools.

Step 5: Add Difference Formulas and Currency Formatting

Difference Column

1. For each data row, column D should show actual minus planned. In the first data row, type =C5-B5, changing the row number to match.
2. Copy the formula down. Select the cell, then double-click the small fill handle in its bottom-right corner. Excel adjusts the row numbers automatically.
3. For expenses, a negative difference is good news, because it means you spent less than planned. Keep this in mind when reading the sheet.

Currency Formatting

1. Select all amount cells in columns B, C, and D.
2. On the Home tab, in the Number group, choose Currency, or press Ctrl + Shift + 4 for the default currency format.
3. If the currency symbol is wrong, open Format Cells from the corner arrow of the Number group, choose Currency, and pick the correct symbol with two decimal places.

Step 6: Add a Simple Overspending Warning

1. Select the Difference cells for your variable expense rows in column D.
2. On the Home tab, click Conditional Formatting, then Highlight Cells Rules, then Greater Than.
3. Enter 0 as the value, choose a light red fill, and click OK. Because expense differences here are actual minus planned, a positive number means overspending and the cell turns red automatically.

Step 7: Use and Copy the Template Each Month

1. At the start of a new month, right-click the sheet tab, choose Move or Copy, tick Create a copy, and rename the new sheet with the month name. Update the title in cell A2.
2. Clear the Actual column values from the copied sheet, review the Planned figures against any bill changes, and you are ready in under five minutes.
3. Once a quarter, compare three months side by side. Categories that are always over plan need a higher planned amount or a genuine spending change.

Common Mistakes to Avoid

• Budgeting gross pay instead of take-home pay: Always budget the amount that reaches your bank, or every month will look impossible.
• Forgetting irregular costs: Annual insurance, subscriptions, and holidays destroy monthly budgets. Divide each yearly cost by twelve and add it as a monthly line.
• Typing totals by hand: Hand-typed totals go stale when you edit a row. Always use SUM and linked formulas.
• Making too many categories: Fifteen to twenty categories is plenty. Fifty categories means you will stop updating the sheet.
• Setting unrealistic planned amounts: Base planned figures on real recent spending, then improve them gradually.
• Never updating the Actual column: A budget filled in only on the first of the month is a prediction, not a tool. Update it weekly.

Conclusion

You now have a working budget spreadsheet: income at the top with SUM totals, fixed and variable expenses in their own sections, savings treated as a planned outgoing, and a summary that shows your money left over with one linked formula. Currency formatting and a red overspending warning make it readable at a glance. Save this file as your master template, copy it each month, update the actual figures weekly, and review the pattern every few months. The spreadsheet is simple on purpose, because the best budget is the one you actually keep using.

Frequently Asked Questions

How do I budget if my income changes every month?

Base your planned income on your lowest typical month, not your average. Budget the essentials against that safe figure, then when extra income arrives, assign it deliberately to savings or goals. Freelancers often update the Actual income column as each payment lands.

Can I build this budget in free Excel on the web?

Yes. Excel on the web with a free Microsoft account supports SUM formulas, currency formatting, sheet copying, and conditional formatting, which is everything this guide uses. The menu names are almost identical, and your file saves automatically to OneDrive.

What is the difference between Planned and Actual columns?

Planned is what you intend to earn or spend, set at the start of the month. Actual is what really happened, updated during the month. The gap between them shows exactly which estimates are unrealistic and which spending quietly creeps up.

How many expense categories should I have?

Most households do well with around fifteen to twenty categories in total. If a category is always tiny, merge it into Miscellaneous. If one category hides several big behaviours, such as Shopping covering clothes, gadgets, and gifts, split only that one.