A budget spreadsheet is the simplest money tool that actually works: it shows where your money is supposed to go, where it really went, and the gap between the two. You don't need an app or a finance degree. You need one sheet, four sections and a handful of formulas.
This guide walks you through building one from scratch in Excel or Google Sheets. Every formula works in both.
Step 1: Gather your numbers
Before you open a spreadsheet, collect the last two or three months of:
- Take-home pay (what lands in your account after tax and deductions), from your pay stubs or bank statements.
- Fixed bills: rent or mortgage, insurance, phone, internet, loan payments, subscriptions.
- Variable spending: groceries, gas, dining out, shopping. Your bank and card statements show this.
- Irregular costs: annual subscriptions, car registration, gifts, back-to-school. Look back over the whole last year for these.
Averaging two or three months gives you realistic numbers instead of hopeful ones.
Step 2: Set up the layout
Create a sheet with four columns: Category, Planned, Actual and Difference. Then make four sections, top to bottom:
| Section | Example categories |
|---|---|
| Income | Salary, partner's salary, side income |
| Fixed expenses | Rent, insurance, phone, internet, subscriptions |
| Variable expenses | Groceries, gas, dining out, personal care, fun money |
| Savings & debt | Emergency fund, sinking funds, retirement, extra debt payments |
Keep categories broad. Twelve to twenty categories is plenty; fifty is a recipe for giving up in week two. Put a Total row at the end of each section.
Tip: Treat savings as an expense line, not as "whatever is left over". If it isn't in the plan, there usually isn't anything left over.
Step 3: Add the formulas
Say your income categories are in rows 5–8, with Planned in column B and Actual in column C.
- Section total:
=SUM(B5:B8)in the Total row (and the same for column C). - Difference for each row:
=C5-B5. For income, positive is good. For expenses, flip it:=B12-C12so that positive always means "better than planned". - Money left to assign: income total minus all three spending totals, for example
=B9-B18-B26-B32. In a zero-based budget you keep adjusting categories until this is exactly 0, so every dollar has a job. - Savings rate:
=B32/B9, formatted as a percentage.
Add conditional formatting to the Difference column: green when the value is 0 or more, red when it's below 0. In Excel use Home → Conditional Formatting → Highlight Cells Rules; in Google Sheets use Format → Conditional formatting.
Step 4: Track actual spending
Planned numbers are a guess. Actual numbers are the truth. The easiest way to fill the Actual column is a transactions log on a second tab with columns Date, Description, Category and Amount.
Then the Actual cell for each category adds up the log automatically:
=SUMIFS(Transactions!D:D, Transactions!C:C, A12)
This sums every amount in column D of the Transactions tab where the category in column C matches the category name in A12. Use Data validation (a dropdown list of your categories) on the Category column so a typo like "Grocerys" doesn't fall through the cracks.
Log spending two or three times a week. It takes five minutes and it's the habit that makes the whole budget work.
Step 5: Review at the end of each month
At month end, look at three things:
- Biggest overspend. Was the plan unrealistic, or was it a one-off? Adjust next month's Planned amount if the plan was the problem.
- Money left over. Move it to savings or debt before it disappears.
- Surprises. Any expense you didn't plan for is a candidate for a sinking fund.
Then copy the sheet for next month. After a few months, add an annual summary tab that pulls the monthly totals together, so you can see trends across the year.
Common budget spreadsheet mistakes
- Using gross pay. Budget the money you actually receive, not your salary before tax.
- Forgetting irregular costs. The $600 car insurance bill every six months is a monthly cost of $100. Plan for it monthly.
- Too many categories. If logging feels like a chore, merge categories.
- Making it perfect before starting. Your first month's plan will be wrong. That's normal: the second month is always better.
- Ignoring paycheck timing. If you're paid every two weeks, a monthly budget can look fine while you still run short before payday. The paycheck budget method fixes that.
Build it yourself or use a template?
Building your own spreadsheet is a great way to understand your money, and everything above is enough to get started today. If you'd rather skip the setup, a template gives you the structure, formulas, charts and annual dashboard ready to go, so you can spend that hour on your numbers instead of on formatting.
This article is general education, not financial advice.