How do you build a monthly budget spreadsheet in Excel?
Start from your bank statement and build a monthly budget sheet in about 40 minutes that updates itself and flags overspending in color.
Short answer
In a new workbook create three sheets named Transactions, Categories and Summary. On Transactions type the headers Date, Month, Category, Description, Amount, Type and press Ctrl+T to turn them into a table. Add a drop-down to the Category column with Data > Data Validation. On Summary use SUMIFS to total by category and month, then use Conditional Formatting to paint over-budget lines red.
What you need
Step by step
Create the three-sheet skeleton
Open Excel and pick Blank workbook. Right-click the sheet tab at the bottom, choose Rename and name it Transactions, then use the plus button to add two more sheets named Categories and Summary. Keeping raw data, the category list and the report apart stops your formulas from breaking at month end.
Type the header row
On the Transactions sheet, starting in cell A1, type Date, Month, Category, Description, Amount and Type across the row. The Type column will hold either Expense or Income. Six headers on a single row is all you need for tables and PivotTables to behave in the later steps.
Convert the data to a table
Select A1:F1 and press Ctrl+T, tick My table has headers and click OK. On the Table Design tab type Transactions in the Table Name box. Every new row you add now joins the table automatically, so you never widen formula ranges by hand.
Wire the category list to a drop-down
On the Categories sheet type Category in A1 and list 8 to 12 items below it, such as Rent, Building fees, Groceries, Utilities, Transport, Health, Education, Fun, Savings. Back on Transactions select column C and go to Data > Data Validation > Allow: List, then type =Categories!$A$2:$A$20 in the Source box. This kills the wrong totals that come from typing variants.
Set the date, month and currency formats
Select column A and pick Short Date from Home > Number, then select column E, pick Currency and set the symbol and 2 decimal places. In B2 enter =TEXT([@Date],"mmmm yyyy") to build the month label. The Month column is what lets you compare months side by side in the summary.
Build the totals on the Summary sheet
On Summary list the category names down from A2 and the month labels such as January 2025 across from B1. In B2 enter =SUMIFS(Transactions[Amount],Transactions[Category],$A2,Transactions[Month],B$1) and drag it right and down. Add a column with your monthly target typed in by hand and a variance cell of =B2-target.
Color the lines that go over
Select the variance column and go to Home > Conditional Formatting > Highlight Cells Rules > Greater Than, enter 0 and choose Light Red Fill. Add a Less Than rule with a green fill for anything under target. At month end you can see where you overspent without reading a single number.
Freeze, save and back up
On Transactions select cell A2 and choose View > Freeze Panes > Freeze Top Row. Then use File > Save As to save the file to OneDrive or your Documents folder as Budget-2025.xlsx. Make it a habit to download your statement in the first week of each month and paste the new rows under the table.
Tips
Watch out
The most common mistake is typing category names by hand on every row. Case differences and trailing spaces are usually forgiven, but a misspelled or accent-stripped variant counts as a separate category and your SUMIFS totals come out short with no error shown. Set up the Data Validation list before you enter any data, and save the file as .xlsx: saving as CSV strips every formula and format.
Frequently asked questions
+I do not have Excel. Can I do this for free?
Sign in at office.com with a Microsoft account and use Excel for the web at no cost. Ctrl+T, Data Validation and SUMIFS all work there, and the same logic applies in Google Sheets.
+Should I separate formula arguments with a comma or a semicolon?
English Excel with US regional settings uses a comma as the argument separator and a period for decimals. Many European locales, including Turkish, use a semicolon for arguments and a comma for decimals.
+How do I record credit card installments?
Enter one row per month for the amount you actually pay rather than the full purchase, and note something like 3/12 in the Description column. That keeps your monthly cash outflow honest.
+Will the sheet slow down as it grows?
A few thousand rows is no problem. Write SUMIFS formulas only in the cells you use rather than down whole columns, and start a fresh file for each year.
+How do I build inflation into the budget?
Instead of typing a fixed target, multiply the previous month's target by a rate cell, for example =C2*(1+$H$1). Put your expected monthly increase in H1 and update it from that one place.
Sources and verification
Last verified: September 15, 2026. tell us. Menu names, function names and separators follow English Excel with US regional settings; localized builds use translated function names and a semicolon argument separator.
This content is for information only; for official procedures the relevant institution’s current announcements take precedence. Details: disclaimer.