Yes—you can make a free personal budget spreadsheet in Excel by setting up a monthly plan and a transaction log, then using a few built-in formulas to total spending. The layout below works in Excel for Microsoft 365 on Windows; it can also be adapted in Excel for Mac or Excel for the web, though ribbon details may differ.
What a personal budget spreadsheet does
A personal budget spreadsheet gives you one place to compare money coming in with money assigned to bills, everyday expenses, savings, and debt payments. Unlike a bank balance, which shows what remains at a moment in time, a budget helps explain where money is expected to go and whether actual transactions are matching that plan.
A useful starter workbook needs two sheets:
- Monthly Plan: the month being tracked, take-home income, spending categories, planned amounts, actual totals, and the difference between plan and reality.
- Transactions: a dated record of purchases, bills, refunds, and transfers that you want counted in the budget.
This is a manual spreadsheet, not a connected banking service. You enter transactions yourself or copy them from account statements. That takes some regular attention, but it also means the workbook does not need your bank password or direct access to your accounts.
Set up the workbook in Excel
Create a blank workbook and rename the first sheet Monthly Plan. In B2, enter the first day of the month you are budgeting for as a real Excel date, such as November 1, 2026. In A3, type Monthly take-home income, and enter an illustrative amount of 3200 in B3. Use the income figure that makes sense for your own plan; for a simple monthly budget, many people start with take-home pay rather than gross salary.
Starting in row 6, create these headings: Category in column A, Planned in B, Actual in C, and Remaining in D. Enter categories in A7:A14. For example, use Housing, Utilities, Groceries, Transport, Insurance, Debt payments, Personal, and Savings. Put your planned monthly amount beside each category in B7:B14. Reserve row 15 for totals, and use A17 and B17 for a separate estimate of income remaining after recorded outflows.
On a second sheet named Transactions, make row 1 contain Date, Category, Description, and Amount in columns A through D. Enter one transaction per row below it. Use actual dates in column A and category names that match the Monthly Plan entries exactly. Enter expenses as positive numbers and refunds as negative numbers. For instance, a $42 grocery purchase is 42, while a $10 refund is -10. Consistency matters more than whether you type a currency symbol; Excel can display the values as currency without storing the symbol in the cell.
Use formulas to total spending
With the transaction log laid out as described, the Actual column can add entries for the chosen category and month. With the month start date in Monthly Plan!B2, the category name in Monthly Plan!A7, and transaction dates, categories, and amounts in Transactions!A2:A500, Transactions!B2:B500, and Transactions!D2:D500, enter this in Monthly Plan!C7. For example, if the log has two November grocery purchases of $120 and $85, the formula returns 205. Copy it down through C14.
=SUMIFS(Transactions!$D$2:$D$500,Transactions!$B$2:$B$500,$A7,Transactions!$A$2:$A$500,">="&$B$2,Transactions!$A$2:$A$500,"<"&EDATE($B$2,1))
The date conditions include the first day of the selected month and exclude the first day of the next month. This is more reliable than checking only a month number, because it keeps transactions from different years separate. The formula uses SUMIFS and EDATE, which are available in Microsoft 365 Excel. Make sure the dates in the transaction log are stored as Excel dates, not text that merely looks like a date.
With the planned amount in B7 and actual spending in C7, put this formula in D7 to show what remains in that category’s plan. If the Groceries plan is 300 and the example actual total is 205, it returns 95. Copy it down through D14.
=B7-C7
With planned category values in B7:B14, put this in B15 to total the plan. For the example category plans of 1200, 180, 350, 200, 150, 250, 200, and 300, the result is 2830.
=SUM(B7:B14)
With actual category totals in C7:C14, put this in C15 to total recorded outflows. If the example actuals are 1200, 165, 205, 145, 150, 250, 130, and 300, the result is 2545.
=SUM(C7:C14)
With take-home income in B3 and total recorded outflows in C15, put this in B17 for a simple income-minus-outflows estimate. With the illustrative income of 3200 and outflows of 2545, it returns 655.
=B3-C15
That last figure is not automatically “extra money.” It is only as complete as the transactions you entered, and it may include amounts you deliberately allocated to savings or debt payments. Label it accordingly and avoid treating a partial month as a final result.
Choose categories that fit your household
There is no single category list that suits everyone. Categories should be detailed enough to help you make decisions, but not so numerous that logging every purchase becomes a chore. A person who spends heavily on commuting may want separate fuel and public transit lines; someone working from home may not need that distinction.
Start with recurring obligations and broad flexible expenses. Depending on your situation, a useful list may include:
- Housing, utilities, and insurance
- Groceries, dining out, and household supplies
- Transport, health, and personal spending
- Debt payments, savings goals, and irregular expenses
Irregular costs are easy to overlook because they do not appear every month. Annual renewals, seasonal bills, repairs, gifts, and school costs can be assigned a monthly set-aside. For example, an expected $600 annual expense averages $50 per month if you choose to reserve for it evenly. That is a planning calculation, not a guarantee that the bill will arrive in equal installments.
Make the spreadsheet easier to maintain
A budget is useful only if the information stays current enough to guide choices. Pick a routine you can sustain: for example, enter purchases a few times a week and reconcile the log against account statements at month-end. Keep descriptions short but recognizable, such as “weekly groceries” or “electric bill,” rather than relying on vague labels.
Format money cells as currency and dates as dates. In Excel for Microsoft 365 on Windows, select the relevant cells and use the Number Format controls on the Home tab. You can also use Home > Conditional Formatting > Highlight Cells Rules to flag values that exceed a threshold, such as a category with spending above its plan. Treat visual alerts as prompts to review the data, not proof that a purchase was wrong.
At the end of each month, save a copy or preserve the month’s results before changing the month selector. If you overwrite the same plan each month, earlier planned figures may be lost. One approach is to duplicate the Monthly Plan sheet for a new month and update B2, while keeping the transaction sheet as a single dated log. Another is to create a separate workbook for each year. Choose the arrangement that makes historical comparisons easiest for you.
Common spreadsheet problems and fixes
The most frequent issue is a category mismatch. “Dining” and “Dining out” are different text values to Excel, so a transaction may not appear in the expected total. Use a consistent list of category names and check spelling when a total looks unexpectedly low.
Another common problem is entering a transaction date as text. If a date is not recognized as a date, the monthly SUMIFS conditions may exclude it. Re-enter it in a recognizable date format or use Excel’s date formatting tools, and confirm that sorting the date column behaves chronologically.
Be clear about transfers. Moving money from checking to savings is not consumption, but you may choose to count the transfer as a Savings allocation in your budget. If both the withdrawal and deposit are recorded in the same transaction log, counting both as positive outflows can distort totals. Decide whether the log tracks spending only or all movements between your accounts, then apply that rule consistently.
Finally, check for missing transactions and duplicate imports. A credit card purchase may appear in a card account and again when you pay the card from checking. If you record both as expenses, you count the same spending twice. The card payment is generally a transfer for tracking purposes when the individual card purchases have already been logged.
Spreadsheet versus a budgeting app
A spreadsheet is a good fit if you want control over categories, formulas, and where your information is stored, and you do not mind entering data manually. It can be adjusted for unusual pay schedules, shared household expenses, or savings targets without waiting for an app feature. It also makes the calculations visible: you can inspect how totals are produced.
A budgeting app may be more convenient if it can import transactions from your financial institutions and categorize them automatically. That convenience can depend on the app, the institution, account eligibility, and the permissions you grant. Review current pricing, data practices, and connection terms directly with the provider before signing up. An app is not necessarily free just because it offers a free tier, and automated categories can still need correction.
You can also start from a free template, but check that it supports the way you want to budget and that formulas are understandable. A template with many charts is not automatically more useful than a plain sheet you can maintain. Excel for the web may be available at no cost with a Microsoft account, subject to Microsoft’s current account and service terms; some features and interface details differ from the desktop Microsoft 365 app.
Privacy and safe handling
A personal budget can reveal sensitive details about income, bills, debts, and habits. Keep the workbook in a location you control, use device security and account protections, and be cautious about emailing or sharing it. If you use a shared computer, do not leave the file open or saved where other users can access it.
A spreadsheet is not a bank account, and formulas do not verify that a bill was paid or that a transaction is genuine. Compare entries with official account records, and contact the financial institution if a charge appears unfamiliar. Avoid entering account passwords, full payment-card numbers, or other secrets into ordinary budget cells. These steps are general privacy practices, not financial, tax, investment, or legal advice; check actual account terms with your institution or consult a qualified professional when you need advice about your circumstances.
Frequently Asked Questions
Where can I get a free personal budget spreadsheet?
You can create one in a blank Excel workbook using the two-sheet layout above, or look for a template through Excel’s template options. Review the formulas and sharing settings before entering personal information.
Can I use this budget spreadsheet in Google Sheets?
The basic layout and SUMIFS approach can be adapted to Google Sheets, but this setup is written for Excel. Check the formula separators and date handling in your spreadsheet locale, and confirm that any functions or formatting behave as expected after importing a workbook.
How often should I update a personal budget?
Update it often enough that you can still make useful decisions—weekly is a practical starting point for many people. Reconcile totals against account records at least once per month and investigate differences rather than assuming the spreadsheet is correct.
Should savings count as an expense in my budget?
That depends on what you want the totals to show. You can treat a planned savings contribution as an allocation so it competes with other uses of income, while keeping it distinct from purchases. Make the choice explicit and avoid counting an internal transfer twice.
Why does my actual spending total show zero?
Check that the selected month in B2 is a real date, the transaction dates fall within that month, category spelling matches the plan, and amounts are numeric. Also confirm that the SUMIFS ranges cover the rows where your transactions are entered.
Related
- Excel Hide Columns When Printing Without Changing Data
- Free Debt Snowball Payoff Spreadsheet: Build One in Excel
- Debt Snowball Calculator Spreadsheet: Free Excel Setup
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Group Rows: How to Add and Use the Drop-DownsTo group rows in Excel for Microsoft 365 on Windows, select the rows using their row numbers, then…
- Export to CSV vs Excel: Which Format Should You Choose?Choose CSV when you need a lightweight, widely compatible file containing plain tabular data; choose an Excel workbook…
- Removing Formatting in Word: Clear Text and StylesTo remove formatting in Microsoft Word for Microsoft 365 on Windows, select the text and choose Home >…
- How to Highlight a Full Row in Excel AutomaticallyTo highlight a full row in Excel once, select its row number and choose Home > Fill Color.…
- How to Add a Drop-Down List in Excel: Step-by-Step GuideTo add a drop-down list in Excel for Microsoft 365 on Windows, select the cell or cells, choose…
- Wedding Budget Spreadsheet: Track Every Cost in ExcelYes. Create a wedding budget spreadsheet in Excel by listing each expense, its estimated and actual cost, and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.