Budget apps have one design flaw: they require trust in a third-party sync with every account you own. A spreadsheet requires trust in yourself — which, for many people, is more reliable. Here is how to build one that is honest, flexible, and done in under an hour.
What changed in 2026
- Google Sheets and Excel both added AI formula assistants — describe what you want in plain English and the formula gets written for you. No more hunting for SUMIF syntax.
- Open banking APIs made importing transactions easier, but plenty of people still prefer manual entry for the mindful friction it creates.
- Category inflation is real. Subscriptions, delivery apps, and streaming have multiplied — your categories need to reflect 2026 spending reality, not a 2015 template.
The five essential columns
Every budget spreadsheet needs exactly five columns per section:
| Column |
Purpose |
| Category |
Name of expense or income type |
| Budgeted |
What you plan to spend this month |
| Actual |
What you actually spent |
| Difference |
Budgeted minus Actual (green = under, red = over) |
| Notes |
"Why" context for any big variance |
That is it. Any additional columns — sub-categories, rolling 3-month averages, pie charts — can come later. Start with these five.
How to build it
- Open a new Google Sheet or Excel workbook. Name it "Budget — [Month Year]."
- Create three sections: Income, Fixed Expenses, Variable Expenses.
- List income first — take-home pay, side income, any recurring transfers in. Sum at the bottom.
- List all fixed expenses — rent/mortgage, car payment, insurance, loan minimums, subscriptions. These do not change month-to-month.
- List variable expenses — groceries, dining, fuel, entertainment, clothing, personal care. Estimate each based on last month's bank statements.
- Add a "Savings & Investing" section — treat it like an expense: 401(k) auto-contributions, emergency fund transfer, any investment transfers.
- Create a summary row: Total Income minus Total Expenses. In zero-based budgeting, this should equal zero — every dollar allocated.
- Add the Difference column with a simple formula:
=Budgeted - Actual and conditional formatting (red if negative).
Budget category starter list
| Section |
Categories |
| Income |
Take-home pay, side income, rental income |
| Fixed |
Rent/mortgage, car payment, insurance, subscriptions, loan minimums |
| Variable |
Groceries, dining out, fuel, transit, clothing, personal care, entertainment |
| Savings |
Emergency fund, investing, sinking funds (travel, car repair, gifts) |
| Irregular |
Medical, car maintenance, annual fees (divide by 12 and budget monthly) |
How to pick the right budgeting method
Not all spreadsheets use the same logic. Choose one and stick with it:
| Method |
Idea |
Best For |
| Zero-based |
Every dollar assigned until balance = 0 |
Detail-oriented spenders |
| 50/30/20 |
50% needs, 30% wants, 20% savings |
Simple, fast, good starting point |
| Pay yourself first |
Savings out first; rest is spendable |
Inconsistent savers |
| Envelope (digital) |
Fixed pool per category; stop when empty |
Overspenders on specific categories |
For a first spreadsheet, zero-based gives you the most visibility.
Common mistakes
Not accounting for irregular expenses. Annual car insurance, holiday gifts, and summer travel wreck monthly budgets if you forget them. Divide annual costs by 12 and add a monthly line.
Setting unrealistic variable budgets. Look at three months of actual spending before setting targets. Aspirational numbers lead to immediate failure and abandonment.
Only reviewing monthly. Monthly reviews catch problems too late. A weekly 10-minute check-in lets you adjust before the month blows up.
Tracking income after tax but forgetting pre-tax deductions. If your 401(k) comes out pre-paycheck, it is already "spent" — do not double-count it in savings.
What to skip
- Automated transaction import for a first budget. Manual entry creates mindful awareness; auto-import can let you ignore the numbers.
- Separate worksheets per category. One clean sheet beats a multi-tab maze when you are starting out.
- Copying someone else's categories verbatim. Your spending is yours. Start from your last three bank statements, not a template you found online.
FAQ
Google Sheets or Excel?
Both work identically for basic budgets. Google Sheets is free, syncs everywhere, and is easier to share with a partner.
How many categories should I have?
Aim for 10–20. Fewer than 10 loses insight; more than 25 becomes a chore to maintain.
What if I have irregular income?
Base the budget on your lowest expected month. Windfalls and extra income go to savings or debt first, not expanded spending.
Should my partner and I have one sheet or two?
One shared sheet with a clear view of household income and shared expenses, then each person keeps a personal discretionary column.
Where to go next