A basic budget spreadsheet is a monthly list of income and spending that compares what you plan to receive and spend with what actually happens. In Excel, create columns for category, type, budgeted amount, actual amount, and difference; add a small income-and-expense summary so you can see how much is left.
What a basic budget spreadsheet shows
A budget spreadsheet turns a broad question—“Where does my money go?”—into a set of amounts you can review and update. Its core job is to compare a plan with real transactions. The plan is an estimate made before or at the start of the month; actual amounts are what you record as income arrives and bills or purchases are paid.
A simple version can fit on one worksheet. It does not need elaborate charts, macros, or a long list of categories. At minimum, include income, expenses, and a calculation of the difference between them. A planned balance is useful too: it shows whether your intended income covers your intended outflows before the month begins.
For example, if your planned take-home income is $3,400 and your planned outflows are $3,000, the plan leaves $400. If actual income and expenses differ from those estimates, the actual balance will differ too. That gap is information to investigate, not proof that a budget has succeeded or failed.
Set up the worksheet
In Excel for Microsoft 365 on Windows, open a blank workbook and enter these headings in row 1: A1 Category, B1 Type, C1 Budgeted, D1 Actual, and E1 Difference. Add one category per row below them. Use Income or Expense consistently in column B; consistent labels let summary formulas group the rows correctly.
A small example might use rows 2 through 11:
- Salary — Income — $3,200 budgeted — $3,200 actual
- Other income — Income — $200 budgeted — $150 actual
- Rent, utilities, groceries, transport, insurance, subscriptions, savings transfer, and dining — Expense — enter a planned and actual amount for each
Enter amounts as numbers, not text such as “$1,200 per month.” To display a currency symbol, select the amount cells and use Home > Number to choose a currency or accounting format. The underlying values remain numbers, so Excel can add and compare them. The Mac version of Excel has the same basic worksheet and formula behavior; ribbon placement can vary slightly with window size and version.
Enter formulas for differences and totals
Decide what the Difference column means before filling it. In this example it is actual minus budgeted. With category names in A2:A11, types in B2:B11, budgeted amounts in C2:C11, actual amounts in D2:D11, and differences in E2:E11, enter this in E2 and copy it down through E11:
=D2-C2
For utilities budgeted at $180 and actually costing $195, the row’s difference is $15. For other expenses, a positive difference means spending exceeded the plan; a negative one means spending was below it. For income, however, a positive difference means actual income exceeded the plan. Because the same sign has different implications for income and expenses, do not treat every positive number as “bad” or every negative number as “good.”
To create a summary, put Summary in G1, Budget in H1, and Actual in I1. Put Income in G2, Expenses in G3, and Net in G4. With the types in B2:B11 and budgeted values in C2:C11, enter this in H2 to total planned income:
=SUMIF($B$2:$B$11,"Income",$C$2:$C$11)
For the same row layout, with actual values in D2:D11, enter this in I2 to total actual income:
=SUMIF($B$2:$B$11,"Income",$D$2:$D$11)
With the same ranges, enter this in H3 to total planned expenses:
=SUMIF($B$2:$B$11,"Expense",$C$2:$C$11)
With actual values still in D2:D11, enter this in I3 to total actual expenses:
=SUMIF($B$2:$B$11,"Expense",$D$2:$D$11)
Finally, with the summary totals in H2:H3 and I2:I3, enter the following formulas in H4 and I4, respectively, to calculate planned and actual net amounts:
=H2-H3
=I2-I3
In the example above, planned income is $3,400 and planned expenses are $3,000, so planned net is $400. Actual income is $3,350 and actual expenses are $2,992, so actual net is $358. The figures are illustrative; they do not predict what any household will earn or spend.
Choose categories that are useful
Categories should be detailed enough to answer questions you care about, but not so detailed that maintaining the sheet becomes a chore. “Food” may be enough for a quick overview. Separate “Groceries” and “Dining” if you want to compare those spending patterns. Likewise, combine small subscriptions into one line if individual services are not important to your review.
Start with regular income and bills, then add flexible spending and less frequent costs. Common categories include:
- Income: wages, benefits, freelance work, or other expected sources.
- Housing and bills: rent or mortgage, utilities, phone, and insurance.
- Everyday spending: groceries, transport, household items, and meals out.
- Goals and irregular costs: savings transfers, annual fees, repairs, or gifts.
There is no single required category scheme. If you label a transfer to savings as an expense, do so consistently and understand that the net figure then represents money left after that planned allocation. If you instead track savings separately, keep it out of the expense total and show it as its own line in the summary. The important point is to avoid counting the same money twice.
Make the sheet easier to maintain
Format the data as an Excel table by selecting the range and choosing Insert > Table, then confirm that the table has headers. A table makes the rows easier to filter and helps formatting carry into new rows. Keep summary cells outside the table so they are not mistaken for transaction categories. If you add rows, check that the summary formulas include them; table-based formulas can be a later improvement, but fixed ranges are easier to understand when starting out.
Freeze the heading row if you have enough categories to scroll: choose View > Freeze Panes > Freeze Top Row. You can also make headings bold and widen columns so labels are readable. Conditional formatting can draw attention to overspending, but use it thoughtfully: because the difference column mixes income and expenses, a simple rule that colors all positive differences red would mislabel some income results. You could instead apply a rule only to expense rows or review the Type column alongside the difference.
Keep actual amounts accurate
Choose a routine for updating actual amounts. Some people enter purchases as they occur; others update the sheet once a week from account records. Either way, record each amount in the correct month and category, and use the same treatment for refunds, reimbursements, and transfers each time. If an expense is shared or reimbursed, note whether the budget tracks the full purchase or only the portion you ultimately pay.
A monthly budget is a summary, not necessarily a transaction register. If you want to reconcile every purchase, add a separate Transactions worksheet with columns for date, description, category, and amount, then summarize those entries. That approach can reduce manual total errors but takes more setup. For a first budget, entering category totals directly may be simpler.
Common mistakes and useful checks
- Mixing planned and actual figures: Keep budgeted values in one column and actual values in another. Overwriting the plan each time spending changes removes the comparison.
- Inconsistent type labels: “Expense,” “Expenses,” and “expense ” may not behave as one consistent category in a summary. Reuse the same spelling and avoid extra spaces.
- Leaving blanks without a policy: A blank actual cell can mean “not entered yet,” while zero can mean “checked and nothing occurred.” Use a consistent practice so a partial month is not mistaken for a complete one.
- Forgetting annual or irregular costs: A month with no car repair or annual bill does not mean the cost never occurs. You can estimate a monthly amount for such costs, but keep the estimate visibly separate from a bill already paid.
- Assuming the planned balance is available to spend: Timing matters. A monthly total does not show which day income arrives or bills are due. Keep cash-flow timing in mind, especially when balances are tight.
Check that the category rows add up to the summary totals and that the net amount equals income minus expenses. If results look wrong, inspect the selected ranges, category spelling, and whether amounts were entered as numbers. A formula can calculate correctly while still summarizing incomplete or misclassified data.
Spreadsheet or budgeting app?
A spreadsheet is flexible, transparent, and easy to adapt. It is useful if you want to choose your own categories, understand the arithmetic, or keep a simple offline record. Its main trade-off is manual upkeep: you must enter figures, check formulas, and protect the workbook yourself.
A budgeting app may automate transaction imports or offer alerts, depending on the product and account connections available. That convenience can involve account access, service terms, and features that vary by provider. A notebook or a basic notes list is another option for someone who wants to record only a few totals. None of these formats guarantees that estimates will match actual spending; the useful choice is the one you can keep current and understand.
Privacy and safe handling
A budget may reveal income, bills, and spending habits. Save it somewhere appropriate for the sensitivity of that information, avoid sharing a public link, and consider who can access a shared device or cloud folder. Do not include account passwords, full payment-card numbers, or other credentials in the workbook. If you use a work computer or shared workbook, check applicable access and storage policies before entering personal details.
This example is for organizing a household budget, not financial, tax, investment, or legal advice. For decisions involving loan terms, fees, or repayment obligations, check the actual documents and terms with the lender; for specialized questions, consult a qualified professional.
Frequently Asked Questions
What should a basic budget spreadsheet include?
Include income and expense categories, a planned amount, an actual amount, and a summary that subtracts expenses from income. Add detail only when it helps you make a decision or answer a question.
How do I make a simple monthly budget in Excel?
Create the category and amount columns, enter planned figures, and add actual figures as the month progresses. Use formulas such as SUMIF to total income and expenses by type, then subtract expenses from income for the net amount.
Should savings count as an expense in a budget?
That depends on what you want the net figure to mean. You can treat a planned savings transfer as an outflow in the budget, or report savings separately. Apply your chosen method consistently and do not subtract the same transfer twice.
What does a positive budget variance mean?
It depends on the calculation and the row type. In this example, difference is actual minus budgeted: a positive expense difference means spending was higher than planned, while a positive income difference means income was higher than planned.
Can I use the same budget spreadsheet every month?
Yes. Save a clean template and make a copy for each month, or add a month field if you are building a longer-term workbook. Check formulas and update planned amounts when circumstances change rather than assuming last month’s figures still apply.
Related
- How to Open a TSV File in Excel
- How to Open a TXT File in Excel Without Losing Data
- How to Open a Query in Excel and Edit It in Power Query
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add a Header in Excel Across All Sheets at OnceTo add the same printable header to every worksheet in an Excel workbook, select or group the worksheet…
- How to Insert a Section Line in Word and Customize ItTo add a visual divider between sections in Microsoft Word, choose Insert > Shapes > Line, then drag…
- BI Conditional Formatting in Power BI: Rules and UsesBI conditional formatting uses color, icons, data bars, or other visual cues to make important values in a…
- Google Sheets Dropdown: How to Add a Blank OptionGoogle Sheets does not offer a dependable, built-in blank choice that users can select from a dropdown menu.…
- Excel Freeze Panes: Keep Headers Visible While ScrollingIn Excel for Microsoft 365 on Windows, go to View > Freeze Panes and choose Freeze Panes, Freeze…
- Open Excel Files in the Desktop App From Your BrowserTo open a spreadsheet that is already open in Excel for the web, choose Open in Desktop App…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.