A useful monthly budget in Excel separates income, planned spending and savings, then compares the plan with actual amounts to show what remains. This guide is for anyone managing a personal or shared household budget.
Before you start
You need monthly income figures and records or reasonable estimates for household expenses. If you are creating the workbook online in OneDrive, you also need a Microsoft account. An existing budget template that you can edit in Excel is another starting point.
For a shared budget, agree with the other people included on the month and the categories before entering figures.
1. Choose or create a monthly budget workbook
Choose a Microsoft template or start blank
Microsoft’s Spanish-language Excel catalog lists “Presupuesto personal simple,” “Flujo de efectivo personal simple” and “Seguimiento de dinero personal,” among other options such as “Visión financiera” and “Calculadora de gastos.” Choose a listed personal-budget or cash-flow template if you want a prepared starting point. The catalog also offers a blank-workbook route. These are catalog options; their names alone do not establish that every template has the same layout.
To create a blank workbook online, go to OneDrive.com and sign in with a Microsoft account. Select Agregar nuevo, then choose the Excel workbook type. The workbook opens in Excel for the web, ready for editing. Microsoft says changes are saved automatically when you edit the workbook in the browser.
You can also open Microsoft’s Spanish-language Excel budget catalog and select its option to start with a budget template or a blank workbook. A Microsoft account is required for the OneDrive route. The automatic-save behaviour described here applies to Excel for the web and OneDrive, not necessarily to a separately downloaded third-party file.
2. Set the monthly period and organise income and expenses
Use a monthly period for this budget. Microsoft also describes weekly, quarterly and annual tracking, but a month is a practical fit for recurring household bills and month-to-month comparisons.
Create one row for each income source or spending category. Use columns for the item or category, planned amount, actual amount and variance, or keep equivalent columns already present in your template. Record income separately from outgoings, and include a separate row for savings if you want the remaining balance to show money that has not been assigned.
Group expenses by how they behave
Fixed expenses stay at roughly the same amount each month. Examples include rent or a mortgage, health insurance and car payments. Variable expenses are necessary but can change, such as food, vehicle maintenance, electricity and water. Discretionary expenses can vary considerably, including dining out, streaming subscriptions and clothing.
Use categories that fit your household. Do not label every cost as fixed: distinguishing costs that change helps you identify which amounts need closer review. Housing, utilities, debt payments and transport can also have their own rows if that makes the budget easier to follow.
3. Enter planned income, expenses and savings
Enter the expected income for the month and the amount you plan to assign to each expense category and savings goal. The figures should use the same monthly period as the rest of the sheet.
Estimate variable income
If your income changes from month to month, Mujer Financiera’s tutorial recommends averaging the previous six months of income. Add those six amounts and divide the total by six to get a starting estimate. This is that publisher’s suggested method, not a universal budgeting rule. Label the estimate so it is clear that the planned figure is an average rather than a guaranteed amount for the coming month.
Set spending and savings limits
You can assign amounts directly to the categories that matter to you. The 50/30/20 split is another optional method: 50% of income for needs, 30% for wants and 20% for savings. It is one budgeting approach, not a requirement for using an Excel template. If you use it, treat the percentages as planned allocations and enter the resulting amounts in the relevant rows.
Calculate a remaining balance in a custom layout
The following cell layout is illustrative, not Microsoft’s template layout. Put planned income in B2 and actual income in C2. Put planned expenses and savings in B3:B6, with their actual amounts in C3:C6. If savings is included as an outflow, the planned balance is planned income minus planned expenses and savings:
=B2-B3-B4-B5-B6
For the actual balance, use the same relationship with the actual column:
=C2-C3-C4-C5-C6
Adjust the cell references if your rows or columns differ. Microsoft’s own template uses its integrated formulas, so keep those formulas when using that workbook. Include savings as an allocated outflow when the balance is meant to show money still unassigned.
4. Record actual transactions and compare them with the plan
As income arrives and expenses occur, enter each actual amount in the matching category and month. If your template has transaction-tracking fields, use them to record the amounts; otherwise, update the actual column for each category. Keep the actual figures for the same month as the plan so the comparison is meaningful.
Compare each month with its plan
In the illustrative layout from the previous step, planned spending is in B3 and actual spending is in C3. Enter this formula in the variance cell for that row:
=B3-C3
A positive result means actual spending was below plan. A negative result means it exceeded plan. Apply the same planned-minus-actual relationship to other expense rows, changing the cell references for each row. This is an example for a custom worksheet, not Microsoft’s exact formula or cell layout. Microsoft says its personal-budget template calculates differences between projected and actual costs automatically, so use its existing calculations rather than replacing them.
Compare the entries with the records you used to track the month. Missing or miscategorised transactions make category totals incomplete, even if the spreadsheet calculates them correctly.
5. Check the remaining balance and revise the next budget
Review planned and actual amounts by category, the calculated differences and the remaining balance. A positive expense variance under the planned-minus-actual formula means that category came in below plan; a negative one means it went over. Use the recorded spending to adjust the next month’s limits where needed.
If the balance does not reconcile with your records, check for omitted income or expenses and confirm that the formula refers to the intended rows. A spreadsheet total cannot show whether every transaction was entered. In Excel for the web, edits to the OneDrive workbook save automatically while you work in the browser.
Check the result and avoid common errors
The workbook is ready for review when it shows the selected month’s planned and actual income and expenses, the differences between them, and a remaining balance that agrees with the figures entered. If it does not, check for missing or miscategorised transactions, incorrect formula references, and savings that were left out even though the balance is meant to show unassigned money.
Quick reference
- Period: one month.
- Suggested columns: category, planned amount, actual amount and variance.
- Expense variance: planned amount minus actual amount. A positive result means spending was below plan; a negative result means it was above plan.
- Remaining balance: income minus expenses and any savings allocation treated as an outflow.
Where to get an Excel personal budget template
Start with Microsoft’s official Spanish-language budget template catalog for the named template examples used in this guide. Choose a workbook and check its categories before entering figures. Keep any built-in formulas; the cell references below illustrate a custom worksheet rather than the layout of every Microsoft template.
