Yes—you can make a free home budget spreadsheet in a blank Excel workbook, or adapt a free template available through Excel or another reputable provider. A simple monthly sheet needs only planned income, planned expenses, actual amounts, and a formula showing what remains; the example below works in Excel for Microsoft 365 on Windows.
What a home budget spreadsheet does
A home budget spreadsheet puts expected household income and spending in one place so you can compare your plan with what actually happened. It does not need to predict every purchase or use complicated accounting rules. For many households, a monthly overview is enough to reveal whether recurring bills, flexible spending, savings, and debt payments fit within take-home income.
Unlike a bank statement, a budget is forward-looking: you enter what you expect to receive and spend, then update it with real figures. That distinction matters. A budget can show that groceries are planned at $650 while actual spending is $710; a statement only reports the transactions after they occur. A spreadsheet also makes it easy to change assumptions, compare months, and see how a change in one category affects the amount left over.
A spreadsheet is not automatically a financial recommendation. It is a way to organize your own numbers. The illustrative calculations here are basic arithmetic, not financial, tax, investment, or legal advice. For loan balances, interest, or payment amounts, check the lender’s actual terms or consult a qualified professional.
Build a free monthly budget in Excel
Open a blank workbook in Excel for Microsoft 365 on Windows and create one worksheet named Monthly Budget. Use a basic layout with category names in column A, planned amounts in column B, and actual amounts in column C. Put the following labels in the indicated rows:
- Row 2: Category, Planned, Actual.
- Rows 3–4: income sources such as Paychecks and Other income.
- Row 5: Total income.
- Row 7: Category, Planned, Actual.
- Rows 8–14: expense categories such as Housing, Utilities, Groceries, Transportation, Insurance, Debt payments, and Other spending.
- Row 15: Total expenses.
- Row 17: Money left after expenses.
Enter each amount as a positive number. If a category does not apply, leave its planned amount at zero or leave the cell blank. Keep income and expenses in separate sections; that makes the totals easier to check and prevents a positive expense amount from being confused with income.
With planned income in B3:B4 and actual income in C3:C4, enter =SUM(B3:B4) in B5 and =SUM(C3:C4) in C5. If planned income is $4,200 and actual income is $4,200, each formula returns $4,200.
With expense amounts in rows 8 through 14, enter =SUM(B8:B14) in B15 and =SUM(C8:C14) in C15. For example, if planned expenses are $3,600, B15 returns $3,600. If actual expenses total $3,740, C15 returns $3,740.
With total income in row 5 and total expenses in row 15, enter =B5-B15 in B17 and =C5-C15 in C17. In the example, the planned amount left is $4,200 − $3,600 = $600; the actual amount left is $4,200 − $3,740 = $460. A negative result means the entered expenses exceed the entered income for that month; it is a signal to review the figures, not a diagnosis of why it happened.
Choose categories that match your household
Start with categories you can understand and use consistently. A very long list can make updates tedious, while a single catch-all category hides useful detail. The right level of detail depends on what you want to learn. For instance, someone trying to manage food spending may separate groceries from restaurants; someone who rarely needs that distinction can keep them together.
- Income: regular pay, irregular work, benefits, or other money expected during the month. Use take-home amounts if your goal is to compare the budget with money available in your account.
- Recurring essentials: housing, utilities, insurance, phone service, and regular transportation costs.
- Flexible spending: groceries, fuel, dining out, household supplies, and personal purchases.
- Less frequent costs: annual renewals, seasonal expenses, repairs, gifts, or other bills that do not arrive every month.
- Goals and obligations: savings contributions and debt payments, if you want them visible in the same monthly plan.
For a bill paid once a year, you can either record the full payment in the month it is due or set aside a monthly amount in your plan. For example, a $600 annual bill corresponds to $50 per month when divided evenly across 12 months. That calculation helps with planning, but it does not mean the money is automatically available; the timing of income and payments still matters.
Enter actual spending and keep the sheet current
There are two straightforward ways to fill the Actual column. You can enter a monthly total for each category after reviewing account activity, or keep a separate transaction log and summarize it. The first approach is quick and often sufficient. A transaction log offers more detail, but it requires consistent categories and more frequent data entry.
For a basic log, add a worksheet named Transactions with Date in A1, Category in B1, and Amount in C1. Enter each expense as a positive amount in rows 2 through 200, and use category names that match the labels in the budget sheet. For example, use Groceries every time rather than alternating among Grocery, Food shop, and Supermarket.
With transaction categories in Transactions!B2:B200, transaction amounts in Transactions!C2:C200, and the category label in Monthly Budget!A8, enter =SUMIF(Transactions!$B$2:$B$200,A8,Transactions!$C$2:$C$200) in Monthly Budget!C8. If the log has three Groceries entries of $80, $45, and $25, and A8 contains Groceries, the formula returns $150. Copy the formula down for other expense categories. The dollar signs keep the transaction ranges fixed when you copy it; the A8 reference changes to A9, A10, and so on.
This example assumes that the log contains expenses only. If you also record income or refunds, decide how to classify them before relying on the total; otherwise an expense total may not mean what you expect. For a first budget, entering one actual monthly total per category can be clearer than building a detailed log immediately.
Make the spreadsheet readable and easier to check
Format the amount columns as currency using Home > Number format dropdown > Currency. Keep the same currency and decimal style throughout the workbook. Select the header row and use bold text or a fill color to distinguish labels from data. You can widen columns by dragging the boundary between their letters, or double-click that boundary to fit the contents.
Consider using a different fill color for cells where you type numbers and leaving formula cells with a neutral fill. This visual cue reduces the chance of replacing a total with a manually entered value. You can also select the top row and use View > Freeze Panes > Freeze Top Row if a long transaction list makes its column labels hard to see while scrolling.
Before trusting a result, check that every planned category is included in the total range and that the actual figures cover the same month as the plan. A simple test is to add a small known amount to one category and confirm that the total changes by exactly that amount. When you copy a formula, click a few copied cells and check that their references point to the intended rows.
Use monthly budgets for irregular costs and variable income
Some household costs do not fit neatly into a repeating monthly pattern. Car repairs, school expenses, annual subscriptions, and heating bills can vary by season. Leaving them out because they are not due this month can make a budget look more comfortable than it is. Add a category such as Home maintenance or Annual bills, then decide how you want to represent its timing: record actual payments when they occur, or plan a monthly contribution toward the future cost.
Income may also vary from month to month. In that case, avoid treating an unusually strong month as guaranteed. A spreadsheet can show separate income sources or allow the plan to be updated when a payment is known. If pay arrives weekly or every two weeks, be explicit about which pay dates fall in the month being budgeted; some calendar months contain more paydays than others. The spreadsheet will calculate correctly only from the amounts and dates you provide.
It can help to keep a short note beside an unusual amount, such as “annual insurance” or “one-time repair.” That context makes later comparisons more useful. A single high month does not necessarily indicate a lasting change in spending, just as one low month does not guarantee the same result next month.
Spreadsheet, template, or budgeting app?
A blank spreadsheet offers control and can be kept simple, but you create the categories and formulas yourself. A template can save setup time, though you should inspect its formulas, labels, and instructions before entering private information. A budgeting app may automate some transaction imports or reports, depending on its features and your accounts, but it can involve account connections, subscriptions, or data-sharing choices.
For a basic monthly plan, Excel is useful when you want editable rows, transparent formulas, and a file you can store locally or in a cloud location you choose. A template is a good starting point if it clearly separates income, planned spending, actual spending, and totals. An app may be more convenient if automatic transaction categorization is important, but automation can still require review when a transaction is assigned to the wrong category.
There is no need to choose a complex tool just because it has more charts. A small workbook that you update regularly can be more useful than a detailed system that is difficult to maintain. You can also start with the monthly sheet and add a transaction log or a separate worksheet for each month only when you have a specific reason.
Privacy, backups, and common spreadsheet mistakes
A budget can reveal sensitive details about income, bills, and household habits. Store it somewhere appropriate for that information, use a password on the device or account that holds it, and be cautious about uploading it to an unfamiliar template site. Avoid including account passwords, full card numbers, or other credentials in worksheet cells. If you share a workbook, check which sheets and details the recipient can see.
Keep a backup if the workbook matters to you. A separate copy or a trusted version-history feature can help recover from accidental changes. Before replacing a template’s formulas or making a large structural edit, save a copy. Spreadsheet totals are only as dependable as their inputs and ranges, so review the workbook after adding rows: a formula such as SUM(B8:B14) will not include a new category placed in row 16 unless you adjust the formula.
- Do not enter the same purchase twice, such as once from a transaction import and once by hand.
- Use one consistent category spelling when formulas match transactions to categories.
- Do not mix income and expenses in one total unless the formula is designed for that purpose.
- Check whether a number is planned or actual before interpreting it.
- Remember that a spreadsheet does not update itself when a bill, paycheck, or account balance changes.
Frequently Asked Questions
Can I get a free home budget spreadsheet?
Yes. You can create one in a blank Excel workbook without buying a budgeting program, or look for a free template from a source you trust. Review the formulas and privacy terms before adding household information.
What should a home budget spreadsheet include?
At minimum, include income, expense categories, planned amounts, actual amounts, and totals showing income less expenses. Add a transaction log, savings goals, or irregular-cost categories only if they help answer a real question for your household.
Is Excel or Google Sheets better for a home budget?
Either can handle a straightforward monthly budget. Excel is a natural choice if you already use Microsoft 365; Google Sheets is useful when browser access and collaborative editing are priorities. Consider where the file will be stored and who can access it, as well as which program you prefer to maintain.
How often should I update my budget?
Update it often enough that actual spending is not difficult to reconstruct. Some people enter transactions as they occur; others review totals weekly or at the end of the month. The important point is to use a consistent routine and compare figures for the same period.
Why does my budget show a negative amount left over?
In this layout, the remaining amount is total income minus total expenses. A negative result means the entered expenses exceed the entered income for that period. Check for a missing or duplicated amount, then review whether the plan or actual figures need updating; the formula itself cannot explain the cause.
Related
- DMC Thread Inventory Spreadsheet: What to Track
- How to Embed a Clipchamp Video in PowerPoint: Steps
- DMC Floss Inventory Spreadsheet: A Practical Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Hide and Unhide Columns in Excel: ShortcutsIn Excel for Microsoft 365 on Windows, select a column or any cell in it and press Ctrl+0…
- Protect an Excel Workbook From Opening with a PasswordTo stop people opening an Excel workbook without your permission, encrypt it with a password: in Excel for…
- How to Import Excel Data Into Google Earth on DesktopTo import Excel data into Google Earth, save the worksheet as a CSV file, then open it in…
- How to Count Visible Rows in Excel After FilteringTo count entries that remain visible after you filter a list, use Excel’s SUBTOTAL function: for a column…
- How to Copy an Excel File to WordTo copy Excel content into Word, select the cells in Excel, press Ctrl+C, switch to Word, and press…
- Add Dropdown Options in Google Sheets: A Practical GuideTo add dropdown options in Google Sheets, select the cell or range, choose Insert > Dropdown, and enter…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.