Every budgeting app wants $8 to $15 a month for the privilege of categorizing your own money. That is $96 to $180 a year — spent on budgeting instead of savings. A spreadsheet does the same job for free, gives you complete control over the categories, and never sells your transaction data to advertisers.
This guide walks you through building a monthly budget spreadsheet from scratch. By the end, you will have a working system that takes 15 minutes to set up and 5 minutes a week to maintain. I will also link a free template you can copy and start using today.
YNAB costs $14.99/month. Monarch Money is $9.99/month. Copilot is $11.99/month. These are fine tools, but they all share the same problem: they add a recurring cost to the act of watching your money. For someone trying to get spending under control, that is backwards.
Spreadsheets win on four fronts:
The one real tradeoff: you have to enter numbers yourself. No automatic bank sync. But here is the thing — manually entering a $47 DoorDash order makes you feel that $47 in a way that an auto-imported transaction never does. The friction is the feature.
Before you build a spreadsheet, you need a target. The 50/30/20 rule, first described by Elizabeth Warren in All Your Worth, gives you one:
| Category | % of Take-Home Pay | Example ($4,500/mo) |
|---|---|---|
| Needs — rent, utilities, insurance, groceries, minimum debt payments | 50% | $2,250 |
| Wants — dining out, streaming, hobbies, travel, new clothes | 30% | $1,350 |
| Savings & Debt — emergency fund, extra debt payments, retirement, investing | 20% | $900 |
| Total | 100% | $4,500 |
This is a starting point, not a cage. If you live in a high-cost city and rent eats 40% by itself, your “needs” bucket will be bigger. If you are aggressively paying off debt, maybe you flip it to 50/20/30 (needs/wants/savings). The ratio gives you a framework to measure against — not a rule that makes your life miserable.
Key insight: The 50/30/20 split applies to take-home pay (after taxes and deductions), not gross income. If you earn $65,000 but take home $4,500 a month after taxes and health insurance, build your budget on $4,500.
Google Sheets, Excel, or LibreOffice Calc — any of them work. Create a new file and name it “2026 Monthly Budget” or whatever year you are starting. Create one tab per month (Jan, Feb, Mar, etc.) so you can track trends over time without one sheet getting cluttered.
Row 1 should list every source of money hitting your account this month:
| Income Source | Expected | Actual |
|---|---|---|
| Primary job (take-home) | $4,500 | |
| Freelance / side hustle | $400 | |
| Other (dividends, refunds, etc.) | $0 | |
| Total Income | $4,900 |
The “Expected” column is your plan. The “Actual” column gets filled in as money arrives. If your income varies (freelancers, tip earners, commission), use your lowest recent month as the expected number and treat anything above it as bonus savings.
Fixed expenses are the same every month (or close to it). These are your non-negotiables:
| Fixed Expense | Budgeted | Actual | Difference |
|---|---|---|---|
| Rent / Mortgage | $1,450 | ||
| Car payment | $385 | ||
| Car insurance | $140 | ||
| Health insurance | $0 (deducted from paycheck) | ||
| Phone | $55 | ||
| Internet | $65 | ||
| Subscriptions (streaming, gym, etc.) | $85 | ||
| Total Fixed | $2,180 |
The “Difference” column is a simple formula: =Actual - Budgeted. Negative means you spent less than planned (good). Positive means you went over.
These change month to month. Be specific — “Food” is too broad. Split it:
| Variable Expense | Budgeted | Actual | Difference |
|---|---|---|---|
| Groceries | $450 | ||
| Dining out / coffee / takeout | $200 | ||
| Gas / transportation | $120 | ||
| Household (cleaning, toiletries) | $60 | ||
| Clothing | $75 | ||
| Entertainment / hobbies | $100 | ||
| Personal care (haircut, etc.) | $40 | ||
| Gifts / donations | $50 | ||
| Misc / unexpected | $100 | ||
| Total Variable | $1,195 |
This is not “whatever is left over.” Savings is a line item, same as rent. Pay it first.
| Savings / Debt | Budgeted | Actual |
|---|---|---|
| Emergency fund | $300 | |
| Extra debt payment | $400 | |
| Retirement (beyond employer match) | $200 | |
| Short-term goal (vacation, car fund) | $100 | |
| Total Savings | $1,000 |
At the very bottom, one summary block tells you if the month works:
Total Income - (Fixed + Variable + Savings) = Remaining
$4,900 - ($2,180 + $1,195 + $1,000) = $525 buffer
A positive number means your plan is feasible. A negative number means something needs to give before the month starts — cut a variable category, push a savings goal back, or find more income. Solving this equation before the month begins is the entire point of budgeting.
The number one mistake is building 40 categories because it feels thorough. You will not maintain 40 categories. Ten to fifteen is the sweet spot. Here is the hierarchy:
Must track separately (high-value insight):
Fine to lump together (low-value granularity):
If a category consistently surprises you (“I spent HOW much on Amazon?”), split it out next month. Let the data tell you where granularity matters.
Pre-built monthly budget spreadsheet with the 50/30/20 framework, auto-calculating dashboard, and 12 monthly tabs ready to go. Google Sheets — make a copy and start entering your numbers in 2 minutes.
Download Free Budget Template$5.50 for coffee. $3.20 for a parking meter. $12 for a quick lunch. These feel insignificant individually but compound to $200-400/month for most people. The solution is simple: enter purchases the same day. Set a daily reminder at 9pm — open the spreadsheet, enter today’s spending, close it. Two minutes.
If you have never tracked spending before, do not guess your category budgets. Instead, track for one month with zero restrictions. Just record everything. Then use actual spending as your baseline and cut 10-15% from the categories where you were uncomfortable with the number. A budget built on fantasy numbers gets abandoned by week three.
Went $40 over on dining out? That is data, not failure. The spreadsheet’s job is to show you reality — not to punish you. If you consistently spend $250 on dining out but budget $150, the budget is wrong, not you. Either raise the budget and cut elsewhere, or acknowledge that this is the category you are actively working to reduce.
Car registration ($300 in March). Amazon Prime ($140 in January). Holiday gifts ($500 in December). These blow up months that otherwise look fine. The fix: add a “sinking fund” row where you save a small amount monthly toward known annual costs. $300 car registration = $25/month set aside. When the bill hits, the money is already there.
The subscription trap: The average American spends $219/month on subscriptions and underestimates by about $100. Before budgeting anything else, pull your bank statement and list every recurring charge. Most people find 2-4 subscriptions they forgot they were paying for.
January budgets fail by February because people set aggressive targets, blow them, and conclude budgeting does not work. The spreadsheet works when you use the Actual column to learn your real patterns. Three months of honest data is worth more than a single “perfect” month that never repeats.
A budget spreadsheet only works if it reflects reality. Here is the minimal maintenance that keeps it alive:
That is it. The total time commitment is about 30 minutes per month. Less than one episode of whatever you are streaming.
The template above works for straightforward single-income budgeting. But some situations need more structure:
If you have outgrown the basic template and want a pre-built system that handles irregular income, automatic category totals, a visual dashboard, and 12-month trend tracking without you wiring any formulas — that is what the paid version is for.
Auto-calculating dashboard, 12-month trend view, irregular income handling, sinking funds, and debt payoff integration. Built for people who tried the basic template and want the full system without building it themselves.
Get the Full Budget SystemIs Google Sheets or Excel better for budgeting?
Google Sheets is better for most people because it is free, accessible from any device (phone, tablet, work computer), and auto-saves. Excel is better if you work offline frequently or need advanced features like Power Query for importing bank CSVs. Both handle basic budget formulas identically.
How often should I update my budget spreadsheet?
Daily entry is ideal but weekly works if you save receipts or check your bank app once a week. The critical rule is: never let more than 7 days pass without entering transactions. After a week, you forget what half the charges were and start guessing, which makes the data useless.
What if my income changes every month?
Use your lowest income month from the past three months as your budget baseline. When a higher-income month hits, allocate the surplus deliberately: extra to savings, extra to debt, or one specific want you have been deferring. Do not raise your entire spending baseline because of one good month.
How many categories should a budget have?
Between 10 and 15 categories is the sweet spot. Fewer than 10 and you lack the specificity to identify problem areas. More than 20 and you spend more time categorizing than actually managing money. Start with 12 categories and split any that consistently surprise you.
Should I budget based on gross or net income?
Always net (take-home). Your budget should only include money that actually hits your bank account. Taxes, health insurance premiums, and 401k contributions deducted from your paycheck are already gone before you can spend them. Budget the number on your deposit, not the number on your offer letter.