Excel gives you a straightforward way to track income and spending

Excel is a spreadsheet program that lets you organize numbers in rows and columns, making it useful for budgeting because you can see all your money in one place, do math automatically, and watch your spending patterns over time. You do not need to be comfortable with formulas or advanced features — a basic budget in Excel uses simple addition and subtraction that the program handles for you once you set it up.

The core idea is simple: create columns for income sources and expense categories, enter your numbers, and let Excel calculate totals and show you where your money goes. This article walks you through building a monthly budget from scratch, using features that come built into Excel, and organizing your information so you can actually use it to make spending decisions.

Key Takeaways

  • A basic Excel budget has three sections: income at the top, expense categories in the middle, and a summary showing what is left over at the bottom.
  • Excel's SUM function adds numbers automatically, so you enter your amounts once and the totals update themselves when you change a number.
  • Organizing by category — groceries, utilities, transportation — makes it easier to spot where you are spending the most and where you can cut back.
  • You can create a new sheet for each month or use one sheet and update the numbers, depending on whether you want to compare months side by side or keep things simple.

Setting up your budget structure in a new spreadsheet

Open Excel and start with a blank spreadsheet. In the first cell (the box in the top-left corner), type a title like "Monthly Budget — January 2025" so you know what you are looking at. Leave a blank row below it, then start your budget layout.

Create three main sections. First, list your income sources: in one column write "Income" as a header, then list each source below it (salary, side work, benefits, anything you receive). In the next column, write the amount for each. Second, create an "Expenses" section below your income, listing categories like rent, utilities, groceries, transportation, insurance, and anything else you spend money on regularly. Third, at the bottom, create a row for "Total Income," "Total Expenses," and "Remaining" (income minus expenses).

Do not worry about making it perfect yet — you are just laying out the structure so you can see what goes where. Once the layout is in place, you will add the formulas that do the math for you.

Using formulas to calculate totals automatically

Excel's SUM function adds up a range of numbers for you. Click on the cell next to "Total Income," then type =SUM( followed by the first cell containing an income amount, a colon, and the last cell containing an income amount, then close with ). For example, if your income amounts are in cells B3 through B5, you would type =SUM(B3:B5) and press Enter. Excel calculates the total and displays it in that cell.

Do the same for "Total Expenses" using the cells that contain your expense amounts. Then, for "Remaining," click on the cell and type = followed by the cell with your total income, a minus sign, and the cell with your total expenses. For example, =B8-B15. Press Enter, and Excel shows you what is left after expenses.

The power of this approach is that if you change any income or expense amount, all three totals update automatically. You do not have to recalculate by hand — Excel does it for you instantly.

Organizing expenses by category to see spending patterns

Instead of listing every single transaction, group your spending into categories that match how you actually spend money. Common categories are housing (rent or mortgage), utilities (electric, water, internet), groceries, transportation (car payment, gas, transit), insurance, phone, entertainment, and personal care. Add a category for "Other" or "Miscellaneous" to catch things that do not fit elsewhere.

For each category, enter your budgeted amount — the number you plan to spend, not what you actually spent. If you are not sure what to budget, look at your bank or credit card statements from the past two or three months and average them. This gives you a realistic starting point based on your actual behavior, not a guess.

Once you have your budget set up with categories, you can see at a glance which categories take the biggest chunk of your money. If rent is 40 percent of your income and groceries are 15 percent, you know where most of your money goes. This makes it easier to decide where to cut back if you need to save more or if your income drops.

Tracking actual spending against your budget

After you set up your budgeted amounts, create a second column next to each category for "Actual" spending. Each time you spend money, enter the amount in the "Actual" column for that category. At the end of the month, you can compare what you budgeted to what you actually spent.

Add a third column called "Difference" and use a formula to subtract actual from budgeted: =B3-C3 (if B3 is your budgeted groceries and C3 is your actual groceries). A positive number means you spent less than planned; a negative number means you spent more. This shows you which categories you are over or under without having to do the math yourself.

Some people update this weekly as they check their bank account; others do it once a month. Either way, the act of entering your spending forces you to notice where your money actually goes, which is often different from where you thought it went.

Creating separate sheets for different months or purposes

Excel lets you create multiple sheets within one file — think of them as tabs at the bottom of the screen. You can create one sheet for each month, which makes it easy to compare January to February to March and see if your spending is getting better or worse over time.

To add a new sheet, right-click on the sheet tab at the bottom and select "Insert Sheet." Name it with the month and year. Copy your budget structure from the previous month (select all the cells, copy, then paste into the new sheet), then update the amounts for the new month. This way you keep a record of every month without having to scroll through one giant spreadsheet.

Alternatively, if you prefer to keep everything in one sheet, you can create columns for each month side by side: January in columns B and C, February in columns D and E, and so on. This lets you see all your months at once and spot trends quickly. Choose whichever layout makes sense to you — there is no single right way.

Using basic formatting to make your budget easier to read

Once your numbers are in place, a little formatting makes your budget much easier to use. Make your headers bold by selecting them and clicking the Bold button. Use a slightly larger font for your title so it stands out. Add a background color to your header row — select the cells, then click the fill color button and choose a light color that does not make the text hard to read.

Format your numbers as currency so they display with dollar signs and two decimal places. Select all the cells with amounts, right-click, choose "Format Cells," select "Currency," and click OK. This makes it instantly clear that you are looking at money, not just numbers.

You can also add borders to separate sections — select a range of cells, right-click, choose "Format Cells," go to the "Border" tab, and select a border style. These small touches do not change how the budget works, but they make it much easier to read and less likely that you will misread a number or forget what a column represents.

Frequently Asked Questions

Do I need to know formulas to use Excel for budgeting?

No. You only need two formulas: SUM to add up totals, and basic subtraction to find the difference between budgeted and actual amounts. Both are simple enough that you can copy the pattern from one cell to another without understanding how they work. Excel has built-in help if you get stuck.

What if my income or expenses change during the month?

Update the number in the cell and Excel recalculates everything automatically. If you get a bonus, change your salary amount and your total income updates. If you spend more on groceries than expected, change that number and your remaining balance adjusts. This is one of the main reasons Excel is useful for budgeting — you can see the impact of changes instantly.

Can I use Excel on my phone or tablet?

Yes. Excel is available as a free app for iPhone, iPad, and Android devices. The mobile version has fewer features than the desktop version, but it handles basic budgeting fine. You can create and edit your budget on your phone, and it syncs to your computer if you save it to OneDrive or another cloud service.

Should I include savings as an expense category?

Yes. Treat savings like any other expense — give it a category and a budgeted amount. This way you see savings as part of your plan, not as something that happens only if money is left over. Many people find it easier to stick to savings goals when they are built into the budget from the start.

What if I want to track spending by week instead of by month?

Create a sheet for each week or use columns for each week in one sheet, the same way you would for months. Weekly tracking gives you more detail and helps you catch overspending faster, but it also takes more time to update. Start with monthly if you are new to budgeting, then switch to weekly if you want more control.