How to Create a Budget: Step-by-Step (With Spreadsheet Template)

To create a budget, list your net monthly income, list every expense category, assign each category an amount based on the 50/30/20 framework, and track actual spending against it each month. You can build this in a notebook, Excel, or Google Sheets — the format matters far less than actually using it consistently.

Step-by-Step: How to Create a Budget

1. Calculate your net monthly income. Use your actual take-home pay after taxes, not your gross salary.
2. List every expense category. Housing, utilities, groceries, transportation, debt payments, subscriptions, entertainment — be specific rather than lumping everything into "miscellaneous."
3. Apply the 50/30/20 framework. Assign 50% of income to needs, 30% to wants, 20% to savings and debt. See our complete breakdown of the 50/30/20 rule if you want the full framework with examples.
4. Build your spreadsheet (see the template structure below).
5. Track actual spending weekly. A budget only works if you compare the plan to reality regularly, not just at month-end.
6. Adjust monthly. Move money between categories as needed — a budget is a plan you adjust, not a rule you're locked into.

Simple Budget Spreadsheet Template

Use this column structure in Excel or Google Sheets:

The "Difference" column is where the real value is — it shows you exactly which categories are running over, so adjustments are specific rather than a vague sense that "spending feels too high."

How to Set Up a Budget in Excel

1. Create four column headers: Category, Budgeted, Actual, Difference
2. In the Difference column, use a simple formula: =Budgeted - Actual
3. List your categories as rows, grouped by needs/wants/savings if you want a visual 50/30/20 split
4. Use conditional formatting (Excel: Home → Conditional Formatting) to highlight any row where Actual exceeds Budgeted in red — this makes overspending visually obvious at a glance

How to Set Up a Budget in Google Sheets

The process is identical to Excel — the same formula (=Budgeted - Actual) and column structure work directly in Google Sheets. The main advantage of Sheets is automatic cloud saving and easy sharing if you're budgeting with a partner or family, since everyone can view and edit the same live document.

Budgeting for Different Situations

• Budgeting for yourself: the structure above works as-is
• Budgeting as a couple or family: add an "owner" column (whose income/expense) and agree on shared categories versus individual discretionary spending
• Budgeting on an irregular income: base your "Income" row on your lowest realistic monthly income, not an average, and treat any month above that as a bonus to allocate afterward
• Budgeting for young adults just starting out: start with just 3–4 broad categories (Needs, Wants, Savings, Debt) rather than granular subcategories — detail can come later once the habit is established

Frequently Asked Questions

How do I create a budget for myself? List your net monthly income, list your expense categories, apply the 50/30/20 split across them, and track actual spending weekly against the plan. A notebook, Excel, or Google Sheets all work equally well — the key is consistency, not the tool.

What's the easiest way to make a budget spreadsheet? Use four columns — Category, Budgeted, Actual, Difference — with a simple subtraction formula in the Difference column. This is enough structure to see exactly where you're overspending without building something overly complex.

How do I create a household or family budget? Follow the same core structure, but add a column identifying whose income or expense each line represents, and agree in advance on which categories are shared versus individual. See our guide to organizing household finances for the broader system this fits into.

How do I budget with an irregular income? Base your budget on your lowest realistic monthly income rather than an average, so you're never planning around money you might not actually receive that month. Any income above that baseline becomes a bonus you allocate afterward — to savings, debt, or investing.

How do I create a monthly budget as a beginner? Start with just four broad categories — needs, wants, savings, and debt — rather than detailed subcategories. List your net monthly income, apply a 50/30/20 split across those four categories, and track actual spending weekly. Detail can come later once the basic habit is established.

How can I create a realistic monthly budget? Base it on your actual spending from the last 90 days, not an idealized version of what you think you should spend. A budget built on unrealistic category estimates (too little for groceries, too little for entertainment) tends to fail within the first month because it doesn't reflect how you actually live.

What is the 70-10-10-10 budget rule? It's a less common variant of the 70/20/10 rule: 70% toward living expenses, with the remaining 30% split three ways — commonly 10% savings, 10% investing, and 10% debt repayment (some versions substitute "guilt-free spending" for one category). It isn't as standardized as 50/30/20, so confirm which specific version a source means.

Key Takeaways

• A budget needs four things: net income, expense categories, the 50/30/20 split, and consistent tracking.
• The specific tool (Excel, Google Sheets, notebook) matters far less than actually using it every week.
• The "Difference" column (Budgeted minus Actual) is what makes a budget useful — it shows exactly where to adjust.
• For irregular income, budget off your lowest realistic month, not an average.

---

This article is for educational purposes and isn't individualized financial advice. Consult a qualified professional for decisions specific to your situation.

Written by Montu Das, Editor & Founder of Smart Money Guide. Verify his MetLife Bangladesh advisor profile.