Start with a straightforward structure: income, expenses, and the difference

A budget spreadsheet in Excel works best when you keep the layout straightforward. Open a blank workbook and create columns for the category of money coming in or going out, the amount, and notes about where that number came from. Then add rows for each type of income (salary, side work, tax refunds) and each type of expense (rent, groceries, utilities, insurance). At the bottom, use a formula to subtract total expenses from total income — that final number tells you whether you have money left over or a shortfall.

The reason this works is that you see everything at once. You are not hunting through multiple sheets or trying to remember what you entered last month. A single page with income at the top, expenses in the middle, and the bottom-line result at the end takes five minutes to read and update.

Start by listing your actual numbers from the last month or two. Do not guess. Pull your bank statements, credit card bills, and pay stubs. Write down what you actually spent on groceries, gas, and coffee — not what you think you should spend. A budget built on real numbers works. One built on wishes does not.

Key Takeaways

  • Organize your spreadsheet with income at the top, expenses in the middle, and a subtotal formula at the bottom that shows whether you have money left over.
  • Use your actual bank and credit card statements from the last two months to fill in numbers, not estimates of what you think you spend.
  • Create separate rows for each expense category so you can see which ones take the most money and which ones you can adjust.
  • Use Excel formulas like SUM() to add up totals automatically, so the spreadsheet recalculates when you change a number.
  • Update your spreadsheet monthly by entering what you actually spent, then compare it to what you budgeted to find where you went over or under.

Set up your column headers and income section

In cell A1, type "Category". In B1, type "Amount". In C1, type "Notes". These three columns are all you need to start.

In A2, type "Income" as a section header. Then in the rows below, list each source of money: "Salary", "Freelance work", "Tax refund", or whatever applies to you. Put the dollar amount in column B next to each one. In the Notes column, you might write "monthly paycheck" or "expected in April" — anything that helps you remember where the number came from or when it arrives.

Once you have listed all income sources, go to the row below the last one and type "Total Income" in column A. In column B of that row, type the formula =SUM(B2:B7) — but change B2:B7 to match wherever your income numbers actually are. When you press Enter, Excel adds them up automatically. Now if you change any income number, the total updates by itself.

Add your expense categories and amounts

A few rows below your Total Income, type "Expenses" in column A as a new section header. Then list every type of money that goes out: rent or mortgage, utilities, groceries, transportation, insurance, phone, internet, subscriptions, childcare, medical, debt payments, and anything else you spend on regularly.

Put the dollar amount for each expense in column B. Use your bank and credit card statements to find real numbers. If you pay rent once a month, that is your rent number. If you spend $120 a month on groceries on average, use $120. If you have a car payment, insurance, and gas, list those as separate rows so you can see how much transportation costs in total.

Do not skip the small things. A $5 coffee four times a week is $80 a month. Streaming services add up. Parking fees, tolls, and ATM charges are real expenses. The point of a budget is to see where your money actually goes, and that only works if you count everything.

Use formulas to calculate totals and your bottom line

Below your last expense, type "Total Expenses" in column A. In column B, use the formula =SUM(B[first expense row]:B[last expense row]). For example, if your expenses start in row 10 and end in row 25, type =SUM(B10:B25). This adds up all your expenses automatically.

A few rows below that, type "Remaining" or "Surplus/Deficit" in column A. In column B, type the formula =B[Total Income row]-B[Total Expenses row]. If your Total Income is in B8 and Total Expenses is in B27, type =B8-B27. This shows you at a glance whether you have money left over (a positive number) or whether you are spending more than you earn (a negative number).

These formulas do the math for you. When you update a number — say you find out your electric bill was $10 less than you thought — the Total Expenses and Remaining amounts recalculate when ready. You do not have to do the arithmetic yourself.

Format your spreadsheet so it is straightforward to read

Select the cells that contain your section headers — "Income", "Expenses", "Total Income", "Total Expenses", and "Remaining". Right-click and choose "Format Cells". Make them bold, or give them a light background color so they stand out from the regular rows. This takes 30 seconds and makes the spreadsheet much easier to scan.

For your money amounts, select all the cells in column B that contain numbers. Right-click, choose "Format Cells", and select "Currency". Set it to your country's currency (US Dollar, Canadian Dollar, Euro, etc.). Excel will automatically add the dollar sign and show two decimal places. This makes it clear that these are money amounts, not just numbers.

Make column A wider so your category names are not cut off. Double-click the line between columns A and B at the top — Excel will auto-fit the width. Do the same for columns B and C if needed. A spreadsheet that is straightforward to read is one you will actually use.

Update your budget monthly and compare actual spending to what you planned

At the end of each month, go back to your spreadsheet. Check your bank and credit card statements for what you actually spent. Update the numbers in column B to match reality. If you budgeted $200 for groceries but spent $240, change the number to $240. If you spent less than you planned, update it to the lower amount.

After you update all the numbers, look at your Remaining row. Did you come out ahead or behind? If you spent less than you earned, you have money to save or put toward debt. If you spent more, you now know which categories went over and can adjust next month.

The real value of a budget spreadsheet is not the first month — it is the pattern you see over three or four months. You might realize that groceries always run $50 more than you planned, or that you spend twice as much on dining out as you thought. Once you see the pattern, you can decide whether to adjust your budget to match reality or change your spending habits.

Add a second sheet to track spending by month

After you have run your budget for a few months, create a second sheet to see the trend. Right-click the sheet tab at the bottom and select "Insert Sheet". Name it "Monthly Summary".

In this new sheet, create columns for Month, Total Income, Total Expenses, and Remaining. Then for each month, type the month name and pull the numbers from your monthly budget sheets. You can reference another sheet by typing =Sheet1!B8 (where Sheet1 is the name of your first budget sheet and B8 is the cell with Total Income). This pulls the number automatically.

After three or four months, you will see whether your income is steady, whether your expenses are creeping up, and whether you are consistently coming out ahead or behind. That pattern is what lets you make real changes — not guesses about what might help.

Frequently Asked Questions

Should I create a separate sheet for each month or use one sheet for the whole year?

One sheet per month is clearer. You can see one month at a glance without scrolling, and it is easier to compare January to February when they are on different sheets. After a few months, create a summary sheet that pulls the totals from each month so you can spot trends across the year.

What if my income or expenses change from month to month?

Use your average from the last few months. If you earn $3,000 some months and $3,500 others, use $3,250 as your budgeted income. If groceries range from $180 to $220, budget $200. This gives you a realistic middle ground and shows you when a month is unusually high or low.

Can I use conditional formatting to highlight when I go over budget?

Yes. Select the cells where you compare actual spending to budgeted amounts, go to the Home tab, click Conditional Formatting, and choose a rule like "highlight if greater than" the budgeted amount. Excel will color those cells automatically, making overspending obvious at a glance.

How do I handle irregular expenses like car repairs or medical bills?

Add a row for "Irregular Expenses" or "Emergency Fund" and estimate how much you need to set aside each month. If your car needs $500 in repairs every two years on average, that is about $21 a month. Budget for it so you are not caught off guard when it happens.

Should I include savings as an expense?

Yes. Treat savings like a bill you have to pay. If you want to save $200 a month, add a row for "Savings" and put $200 in it. This way your Remaining amount shows what is left after you have paid yourself first, not just after you have paid everyone else.