A budget creation spreadsheet is a workbook for listing expected income and expenses, comparing those plans with actual amounts, and seeing what remains. In Excel for Microsoft 365 on Windows, start with columns for item, type, planned amount, actual amount, and difference; add totals with SUMIF so you can review the month at a glance.
What a budget spreadsheet is for
A budget turns a broad intention such as spending less into a set of amounts you can check. A spreadsheet is useful because you can adapt its categories, calculate totals automatically, and keep a month-by-month record without relying on a fixed paper form. It can be as simple as a list of income and bills or as detailed as a plan that separates recurring expenses, flexible spending, savings, and debt payments.
A budget is a planning tool, not a guarantee that every bill or expense will match the estimate. The value comes from making assumptions visible and updating them when reality differs. For example, if groceries regularly exceed the planned amount, that difference gives you a reason to revisit the estimate rather than assuming the spreadsheet itself will solve the problem.
Choose a time period and useful categories
Monthly budgets are a practical starting point for many households because rent, utilities, subscriptions, and pay are often monthly. A weekly or biweekly view may suit someone paid on that schedule, but the workbook should still account for less frequent bills. A yearly expense such as an insurance renewal can be represented by setting aside part of its expected cost each month, while recording the full payment in the month it is due.
Choose categories that help you make decisions without creating needless data-entry work. Start with a manageable set, then split a category only when the added detail would change what you do. Typical categories include:
- Income: wages, freelance income, benefits, or other expected receipts.
- Fixed expenses: rent or mortgage, insurance, loan payments, and recurring subscriptions.
- Flexible expenses: groceries, transport, dining, household purchases, and personal spending.
- Savings and goals: planned transfers or contributions you want to track separately.
- Irregular costs: repairs, annual fees, gifts, and other expenses that do not arrive every month.
Use take-home income if you want the budget to represent the cash available to spend. If you include gross income instead, you would also need to account for deductions such as taxes and workplace contributions, or the apparent amount available may be misleading. This is a tracking choice, not a tax calculation.
Set up the worksheet in Excel
Open a blank workbook and enter a month or date range near the top, such as June 2026. In row 1, create these headings: Item in A1, Type in B1, Planned in C1, Actual in D1, and Difference in E1. Add one transaction or budget line per row, starting in row 2. Use consistent type labels such as Income, Expense, and Savings; inconsistent labels can cause category totals to omit entries.
For a small budget, you can enter the figures directly. For easier reading, select the data range and use Home > Number to apply a currency format. Avoid typing a currency symbol into every amount as text: numeric values are easier to total and compare. If you want a structured table that expands when you add lines, select the range and choose Insert > Table. Confirm that the table has headers.
For the worked example below, rows 2 through 8 contain: salary, Income, 4000 planned and 4000 actual; side income, Income, 200 and 150; rent, Expense, 1500 and 1500; groceries, Expense, 600 and 640; utilities, Expense, 180 and 170; transport, Expense, 250 and 220; and savings transfer, Savings, 500 and 500. These are illustrative amounts, not typical costs or recommendations.
Add formulas for differences and totals
With the item names in A2:A8, types in B2:B8, planned values in C2:C8, and actual values in D2:D8, enter this in E2 and fill it down through E8: =D2-C2. The salary row returns 0 because actual income of 4,000 matches its 4,000 plan. For groceries, the difference is 40 because actual spending is 640 against a plan of 600. A positive result is not automatically good or bad: for income it means more than planned, while for an expense it means spending above plan.
To create a category summary, enter Income, Expense, and Savings in G2:G4, and use H for planned totals and I for actual totals. With types in B2:B8, planned amounts in C2:C8, and the category label in G2, enter this in H2: =SUMIF($B$2:$B$8,G2,$C$2:$C$8). It returns 4,200 for planned income. Fill the formula down to H4 to total the other two types.
With the same type range in B2:B8, actual amounts in D2:D8, and the category label in G2, enter this in I2: =SUMIF($B$2:$B$8,G2,$D$2:$D$8). It returns 4,150 for actual income. Fill down through I4. The example gives planned and actual expenses of 2,530 each, and planned and actual savings of 500 each.
With planned totals in H2:H4, enter this in H5 to calculate the planned amount left after expenses and savings: =H2-H3-H4. The result is 1,170. With actual totals in I2:I4, enter this in I5: =I2-I3-I4. The result is 1,120. The 50 difference reflects actual income being 50 lower than planned; the example’s actual expenses and savings match their plans. Label row 5 clearly, such as Left after expenses and savings. This is a simplified cash-flow view, not a statement of account balances or a forecast of every future obligation.
Make the sheet easier to maintain
Use formatting to make important information easier to find, rather than to decorate every cell. Bold the headings, freeze the header row if the list is long, and keep the same number format throughout each amount column. You can use Home > Conditional Formatting > Highlight Cells Rules to call attention to values, but first decide what the formatting means. For example, highlighting positive expense differences can reveal overspending, but a single rule applied to all rows would also highlight positive income differences.
Consider keeping planned amounts separate from actual amounts. Enter the plan before the period begins, then update actuals as transactions occur or at a regular review. If actual figures are copied from a bank export, check that each item is counted once and that transfers between your own accounts are not mistakenly treated as new income or spending. A note column can record a due date, payment frequency, or reason for an unusual amount.
For recurring monthly planning, duplicate the worksheet for each month or create a separate transaction log and summary. Duplicating a sheet is straightforward, but it can make annual comparisons cumbersome if category names or layouts change. A single log with a date column is more flexible for analysis, though it requires a little more setup. Choose the approach you are likely to keep current.
Common problems and how to avoid them
- Forgetting irregular expenses: Include annual or seasonal costs in the plan, even if you track the payment in a different month from the monthly set-aside.
- Mixing planned and actual figures: Keep them in separate columns so a revised estimate does not erase what you originally expected to spend.
- Using inconsistent category names: A value such as Expense with an extra space may not match the summary label. Reuse labels consistently.
- Entering amounts as text: Numbers imported with symbols or other characters may not calculate as expected. Check the cell format and whether Excel recognizes the value as numeric.
- Double-counting transfers: Moving money from checking to savings changes where money is held, but should not be counted as income in both accounts. Decide whether the budget treats savings as a planned outflow and apply that choice consistently.
- Leaving formulas out of new rows: If you add items below a regular range, a formula that only covers rows 2 through 8 may not include them. Expand the ranges or use an Excel table and verify totals after adding data.
When a total seems wrong, inspect the source values and formula ranges before rebuilding the workbook. Select a formula cell to see its references in the formula bar. Also check whether a blank line or a category spelling variation has split the data. A spreadsheet can calculate accurately while still giving an incomplete answer if its inputs or ranges are incomplete.
Template or custom spreadsheet?
A ready-made template can save setup time and may already include summaries or charts. It is a sensible choice if its categories and calculations are understandable and you can remove features you do not need. Before relying on a template, inspect formulas, confirm the period it assumes, and check whether it distinguishes planned amounts from actual amounts.
A custom worksheet takes longer to build but gives you control over how you classify costs and what the summary emphasizes. It may be preferable when a template’s assumptions do not fit, such as when you need to track irregular income or separate reimbursements. A bank or budgeting app may reduce manual entry, but it can involve account connections, fees, or data-sharing considerations; check its current terms and capabilities rather than assuming every service offers the same protections or features.
Costs, privacy, and responsible use
Excel may be available through a Microsoft 365 subscription, a work or school license, or another eligible arrangement; access and included features depend on the license. A basic budget can also be made in spreadsheet software that you already have. Check Microsoft’s current product and license information for applicable pricing instead of relying on an old price quoted elsewhere.
A workbook can contain sensitive information. Use category descriptions rather than account numbers, passwords, or full card details. Store the file in a location you consider appropriate, limit sharing permissions, and be cautious about sending an unprotected copy by email. If you use cloud storage, review the account’s sharing settings and the service’s current privacy and security information.
Use the sheet to organize information, not as a substitute for checking account statements, contract terms, or professional advice. Loan costs, interest calculations, taxes, and other obligations depend on actual terms and individual circumstances. Confirm figures with the lender or a qualified professional where appropriate; this example is not financial, tax, investment, or legal advice.
Frequently Asked Questions
What is the simplest way to make a budget spreadsheet?
Make columns for item, type, planned amount, and actual amount. List income, expenses, and savings separately, then compare totals and update actuals regularly. Add a difference column if you want to see where the plan and results diverge.
Can Excel calculate a monthly budget automatically?
Yes. Functions such as SUMIF can add planned or actual amounts by a category label, and subtraction formulas can show what remains. The calculations depend on accurate entries, consistent labels, and ranges that include all relevant rows.
Should savings count as an expense in a budget?
It depends on what you want the summary to show. Treating a planned savings transfer as a separate use of income can make the remaining amount clear, but do not also count the transfer as an expense in another part of the same summary.
How often should I update my budget spreadsheet?
Update it often enough that you can still identify what a transaction was—weekly works for some people, while others enter figures as they occur. Review the plan and actual totals at least once each budget period and adjust future estimates when patterns change.
Can I use the same spreadsheet for every month?
Yes. You can duplicate a monthly sheet or keep transactions in one dated list and summarize them by period. Duplicated sheets are easy to understand, while one continuous log can make comparisons easier if its dates, categories, and formulas are set up consistently.
Related
- Savings Goal Tracker Worksheet: Build One in Excel
- Animated Text in PowerPoint: How to Add and Control It
- Conditional Formatting in PivotTables: How It Works
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Compressing Images in PowerPoint: Steps and SettingsIn PowerPoint for Microsoft 365 on Windows, select a picture, go to Picture Format > Compress Pictures, choose…
- How to Center a Table on a Page in Excel for PrintingTo center a table on a printed page in Excel, open Page Layout, launch the Page Setup dialog,…
- Close Excel Shortcut: Windows and Mac KeysTo close the active workbook in Excel for Microsoft 365 on Windows, press Ctrl+W or Ctrl+F4. On a…
- How to Switch Back to the Old Outlook View on WindowsTo switch back to the old Outlook on Windows, turn off the New Outlook toggle near the upper-right…
- Excel Keyboard Shortcut to Highlight a Cell with ColorIn Excel for Microsoft 365 on Windows, select the cell or range and press Alt, H, H to…
- Can You Insert a Horizontal Line in Word?Yes. In Microsoft Word for Microsoft 365 on Windows, you can insert a horizontal line from Home >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.