Building a budget in Excel means listing income and expenses, using SUM formulas to total each section, then subtracting expenses from income to see what’s left.
A spreadsheet won’t tell you where your money went if the categories don’t match your real life. The way to create a budget in Excel that stays accurate is to list every income source in one section, every expense in another, and let a few SUM formulas calculate the difference. Once the structure is in place, updating it each month takes about ten minutes.
What You Need Before You Start
You need a blank workbook, your recent income and expense numbers, and a rough idea of your spending categories. No formulas beyond basic addition and subtraction are required — Excel’s SUM function and a single subtraction formula cover the heavy lifting. Anyone with Excel for Windows, macOS, or the web can follow these steps.
Setting Up A Budget In Excel: The Category Structure That Works
The most reliable way to build a budget in Excel is to separate income and expenses into distinct sections, use SUM formulas for totals, and let a subtraction formula show your surplus or deficit. The same category structure works whether you use a monthly grid, a percentage-based layout like 50/30/20, or a running balance sheet.
- Open a new workbook and label column A with your categories. Many people place months across row 1 (January through December) and categories down column A, but a single-month layout works fine to start.
- List your income sources in rows — salary, freelance, side gigs, or any other regular money coming in. Leave a row labeled Total Income right below the last source.
- Apply the SUM formula to Total Income: click the cell, type
=SUM(, select the cells above it with your income amounts, type), and press Enter. The row now shows the combined total. - List every expense category in a separate section a few rows below. Common categories include rent or mortgage, utilities, groceries, transportation, insurance, subscriptions, dining out, and savings. Leave a row labeled Total Expenses below the last expense line.
- Apply the SUM formula to Total Expenses the same way you did for income.
- Calculate your net amount in a cell below Total Expenses with
=then the Total Income cell-then the Total Expenses cell — for example,=B5-B15. A positive number means income covers expenses. A negative number means you’re spending more than you bring in. - Save the workbook with a name like “Monthly Budget” so you can reuse the same structure next month.
Two Budget Layouts Compared
The structure above works for any layout. Three common approaches share the same income-versus-expenses core, but each organizes categories differently and suits a different spending style.
| Layout | How Categories Are Organized | Best For |
|---|---|---|
| Monthly Grid | Categories down the left side, months across the top, each month gets its own column with the same formulas repeated | People who want to see every month side by side and track seasonal changes in spending |
| 50/30/20 Budget | All expenses split into three buckets — 50% for needs, 30% for wants, 20% for savings and debt — with percentage formulas checking each bucket against total income | Those who prefer a broad target system rather than detailed line-by-line tracking |
| Running Balance | Each row is one transaction or paycheck with three columns: income, expense, and a running balance that carries forward from the previous row | People who want to see their account balance change with every entry, not just a monthly summary |
Using Microsoft’s Free Budget Template
Microsoft offers free budget spreadsheet templates in Excel for the web. You can open a template, replace the sample values with your own data, and save or print the result without building the layout from scratch.
To use this method, navigate to Microsoft’s budget template gallery in your browser, double-click the template you want, and double-click the template again inside Excel for the web to open it. Replace the category names and numbers in the template cells with your own information, then save the workbook or share it as a PDF. The template already includes formulas, so totals update automatically as you change values.
This workflow works in any browser and does not require a specific Windows or macOS version, though the template page notes it is designed for Excel for the web. If you use the desktop version of Excel, you can also download the template and open it directly.
Mistakes That Throw Off A Spreadsheet Budget
Even a well-structured spreadsheet can give misleading results if a few common errors creep in. Watch for these:
- Mixing income and expenses in the same section. Keeping them separate makes totals easy to audit. A combined list forces you to scan each row to see what is incoming and what is outgoing.
- Typing totals instead of using formulas. When you type a number into a Total row, the cell does not update when you change individual expense amounts. A SUM formula updates automatically every time you edit a value.
- Leaving out categories that occur once or twice a year. Annual subscriptions, insurance premiums, and car registration costs are easy to forget. Divide the annual amount by 12 and include it as a monthly line item to avoid surprises.
- Building the budget once and never updating it. A budget is a living document. If actual spending differs from your estimates, adjust the categories or amounts so the spreadsheet reflects reality.
- Overwriting formulas with hard numbers. Accidentally typing a value into a formula cell breaks the automatic calculation. If the total stops changing, check that the formula is still in place.
How Often Should You Update Your Budget?
A budget spreadsheet that sits untouched for six months will drift further from your actual spending every week. The minimum that keeps it useful is one update each month: replace estimated numbers with actual amounts, adjust next month’s projections, and check whether your net amount is positive or negative. During the first month, a weekly five-minute check catches categories that need adjustment before they throw off the whole sheet. After three months of consistent updates, the spreadsheet becomes a reliable tool instead of a one-time exercise — and the formulas mean the math stays correct no matter how many times you change the numbers.
References & Sources
- Microsoft. “Budget Templates.” Official gallery of free budget spreadsheet templates for Excel for the web.