Yes—you can make a free budget spreadsheet in Excel by listing categories, planned amounts, actual spending, and formulas that total income and expenses. The simple template below works in Excel for Microsoft 365 on Windows and can also be recreated in Excel for the web or other spreadsheet apps.
What a free budget spreadsheet should include
A useful budget template should make it easy to compare what you expected to receive or spend with what actually happened. It does not need elaborate charts or dozens of tabs. Start with one monthly worksheet and include:
- Categories: recognizable labels such as pay, rent, groceries, transport, and phone.
- Planned amounts: the figures you expect for the month.
- Actual amounts: what you received or spent.
- Totals: income, spending, and the amount left after spending.
- A review point: a place to record notes or explain unusual changes.
Keeping planned and actual figures separate is important. If you replace your original plan with the amount you spent, you lose the comparison that helps you see where the month differed from expectations. A budget is a tracking tool, not a promise that every category will stay fixed.
Build the basic Excel layout
Open a blank workbook in Excel for Microsoft 365 on Windows. In row 1, create these headings: A1 Category, B1 Type, C1 Planned, D1 Actual, and E1 Favorable variance. Enter one category per row, using Income or Expense in column B. For a small example, use rows 2 through 8:
- Pay — Income — planned 4000 — actual 4000
- Side work — Income — planned 300 — actual 250
- Rent — Expense — planned 1400 — actual 1400
- Utilities — Expense — planned 220 — actual 245
- Groceries — Expense — planned 500 — actual 560
- Transport — Expense — planned 200 — actual 180
- Phone — Expense — planned 80 — actual 80
These are illustrative amounts, not typical costs or recommended targets. Use your own currency and figures. To the right, create a summary with G1 Summary, H1 Planned, and I1 Actual. Put Total income in G2, Total spending in G3, and Left after spending in G4. This arrangement keeps the source entries in one area and the calculations in another.
Format the planned and actual columns as currency: select the relevant cells, then use Home > Number Format in Excel’s ribbon. You can also make the heading row bold and widen columns so labels are readable. These are optional presentation choices; the calculations work without special formatting.
Use formulas to total the budget
The following formulas assume the example layout above. With Type in B2:B8, Planned amounts in C2:C8, and Actual amounts in D2:D8, enter this in H2 to total planned income: =SUMIF($B$2:$B$8,"Income",$C$2:$C$8). It returns 4300, because 4000 + 300 = 4300. With the same category types and actual amounts in D2:D8, enter this in I2 for actual income: =SUMIF($B$2:$B$8,"Income",$D$2:$D$8). It returns 4250, because 4000 + 250 = 4250.
With the same Type and amount columns, enter this in H3 to total planned expenses: =SUMIF($B$2:$B$8,"Expense",$C$2:$C$8). The result is 2400: 1400 + 220 + 500 + 200 + 80. Enter this in I3 to total actual expenses: =SUMIF($B$2:$B$8,"Expense",$D$2:$D$8). The result is 2465: 1400 + 245 + 560 + 180 + 80.
With planned income in H2 and planned spending in H3, enter this in H4 to calculate the planned remainder: =H2-H3. It returns 1900 (4300 − 2400). With actual income in I2 and actual spending in I3, enter this in I4: =I2-I3. It returns 1785 (4250 − 2465). A positive remainder means the listed income exceeds the listed spending; it does not automatically account for omitted bills, transfers, or other obligations.
To compare each row, with Type in B2, Planned in C2, and Actual in D2, enter this in E2 and fill it down through E8: =IF(B2="Income",D2-C2,C2-D2). For the Pay row, the result is 0. For Side work, it is −50, because actual income is 50 below plan. For Utilities, it is −25, because actual spending is 25 above plan. This formula treats a positive result as favorable: income above plan or spending below plan. A negative result flags the opposite, but it does not say whether the difference is serious; context matters.
Make the template fit a monthly routine
Choose a consistent period, such as a calendar month, and decide how you will enter transactions. Some people record purchases as they happen; others update the sheet from bank or card statements once or twice a week. Either approach can work if the routine is frequent enough that details are not forgotten. Use the same period for planned and actual figures, and avoid mixing a monthly plan with several months of actuals.
At the start of the period, fill in the planned column. During the month, update actuals using a consistent method. At the end, check that the totals are plausible against your statements, then review the biggest differences. If a grocery total is over plan, for example, check whether the cause was a one-off gathering, higher prices, or a category that was too low. You can use what you learn to adjust the next month’s plan rather than silently rewriting this month’s original target.
If you want transaction-level detail, add another worksheet with Date, Description, Category, and Amount columns. Keep the summary budget on its own sheet and enter category totals there. A transaction list is more work to maintain, but it can help explain how an actual amount accumulated. Do not add detail you will not keep current.
Account for irregular and changing costs
Monthly bills are not the whole picture. Annual renewals, seasonal utilities, vehicle repairs, gifts, and other occasional costs may not appear every month. If you leave them out, the apparent remainder can look larger than the money available after foreseeable expenses. One practical option is to give occasional costs their own category and record the amount you actually set aside or spend. Another is to add a separate worksheet listing the expected timing and amount of less frequent bills.
Income may also vary. If pay or freelance income changes from month to month, keep the actual figure tied to the month it was received and avoid treating an uncertain amount as guaranteed. You can add an income category for each source if that makes comparison more useful. The spreadsheet can organize information, but it cannot determine which assumptions are right for your circumstances.
Choose a template that suits your needs
A downloadable template can save setup time, but inspect its structure before entering personal figures. Check whether it distinguishes income from expenses, shows planned and actual amounts separately, and makes its totals understandable. A template with an unfamiliar formula or many hidden sheets may be harder to maintain than a small workbook you create yourself.
- Use a simple monthly sheet if your main goal is comparing a plan with actual totals.
- Use a transaction register if you need to categorize individual purchases and reconcile totals.
- Use a multi-month workbook if you want to compare months, but check that each month uses the same categories and period.
- Skip features you will not use: dashboards, debt schedules, and charts can be useful, but they are not required for a working budget.
When copying a template, confirm that the formulas cover all your rows. If you insert new categories below a formula’s range, the total may not include them. Either extend the formula ranges or place new entries within the range the summary already uses. Check the results with a small hand calculation before relying on a copied workbook.
Free access, costs, and alternatives
You can build the example without buying a separate budget product. Excel for the web is available at no charge with a Microsoft account, although it runs in a browser and requires internet access for online use. The Excel desktop application’s availability depends on the license or subscription you have. Check Microsoft’s current account and product details for the terms that apply to you; access and included features can change.
Google Sheets and LibreOffice Calc are alternatives for a basic budget. The same layout and common SUMIF and IF calculations can be recreated in them, but menus and some details differ. If you share a workbook with someone, confirm that both people can access the file and agree on who updates it. Exporting between spreadsheet formats can also affect formatting or features, so inspect the saved copy rather than assuming every element transferred perfectly.
Protect your budget data and avoid common errors
A budget can reveal sensitive details about income, bills, and spending. Store it in an account and location you trust, use a strong account password, and avoid placing identifiable financial information in a public or shared link. If a workbook is stored on a shared computer, consider who can open that account or device. Do not treat a spreadsheet password as a substitute for secure storage or careful sharing settings.
Common mistakes include mixing planned and actual amounts, entering an expense as a positive income, omitting a category, and extending the data without extending the formulas. Check the Type column for consistent spelling because SUMIF looks for the text specified in its formula. Also decide whether transfers between your own accounts count as spending; counting the transfer and then counting the purchase it funded can double-count the money. The right treatment depends on what the sheet is intended to measure, so use one consistent rule.
A spreadsheet is an organizer, not financial, tax, investment, or legal advice. It may not capture pending transactions, bank timing, fees, or every relevant obligation. For consequential decisions, check actual account and contract terms and consult a qualified professional when appropriate.
Frequently Asked Questions
Where can I get a free budget spreadsheet template?
You can create the layout above in a blank Excel workbook, or look for a downloadable template from a source you trust. Review its formulas and sharing or storage requirements before entering personal information.
Can I use a budget spreadsheet without paying for Excel?
Excel for the web is available without charge with a Microsoft account. The desktop app may require a qualifying license or subscription, so check the current terms for your account.
What is the easiest way to track actual spending?
Enter actual amounts from your records on a regular schedule, such as weekly, and use the same categories as the plan. A separate transaction worksheet can help if category totals alone do not explain differences.
Should savings be listed as an expense?
It depends on what you want the summary to show. You can list a planned savings transfer as an allocation so the remainder reflects money assigned to savings, or track it separately. Be consistent and avoid counting the same transfer twice.
Why does my budget total look wrong?
Check that the formula range covers every category, that Type entries match the formula’s criteria, and that amounts are in the intended columns. Compare the result with a manual addition of a few sample rows to find omissions or double-counting.
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
- How to Make a Poster from PowerPoint SlidesTo make a poster from PowerPoint slides, create a slide at the poster’s final page size, arrange the…
- Can You Create Outlook Rules in OWA? Here’s HowYes. You can create and manage Outlook rules in Outlook on the web (OWA) to sort incoming email,…
- Repair Excel in Windows 11: Practical Fixes and StepsTo repair Excel in Windows 11, first restart your PC and check whether the problem affects Excel itself…
- Calculate Age in Excel From a Date of BirthTo calculate someone’s age in completed years in Excel, enter their date of birth in A2 and use…
- PowerPoint Slideshow Continuous Loop: Setup and FixesYes. In the Microsoft PowerPoint desktop app, open Slide Show > Set Up Slide Show and select Loop…
- Excel Insert Page Break Shortcut: Windows and MacIn Excel for Microsoft 365 on Windows, press Alt, P, B, I in sequence to insert a page…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.