Budget Spreadsheet: How to Make One Step by Step

The short answer

To make a budget spreadsheet, list your monthly income, list your fixed and variable spending in categories, and subtract one from the other so you can see what is left. Then record what you actually spend each month and compare it with the plan. The spreadsheet itself is simple. The habit of updating it is what makes it useful.

Why a spreadsheet works

A budget is a plan for your money before the month starts. A spreadsheet suits that job for a few plain reasons. It is free if you already have Excel or use Google Sheets. It shows every number on one screen. And it does exactly what you tell it to, with no subscription, no bank connection and no app that changes its layout next year.

A spreadsheet is also easy to bend. If you are paid fortnightly, have irregular income or want to track a single savings goal, you can add a column. That flexibility is the main reason people stay with spreadsheets after trying budgeting apps.

Before you open the file: gather your numbers

You will build the sheet faster if you have the numbers in front of you. Pull together:

• Your last two or three months of bank and card statements
• Your pay details (amount after tax, and how often you are paid)
• A list of regular bills and subscriptions, with due dates
• Any debts, with the balance, the interest rate and the minimum payment
• Any savings you want to build, and by when

If your income varies, use a low but realistic figure, such as your lowest month of the past six. A budget built on a cautious number leaves room for good months to become extra savings.

Step 1: set up the income section

Start at the top of the sheet. Make one row for each source of income: wages, a side income, benefits or child support, whatever applies. Put the amount you actually receive, after tax, in a column for the month.

Add a total at the bottom using a sum formula. In both Excel and Google Sheets this is =SUM(B2:B5), adjusted to your cell range.

Step 2: list your spending categories

Below income, make a list of spending categories. Too few and the numbers hide useful detail. Too many and the sheet becomes a chore. Around 15 to 30 is a workable range for most households.

Here is a sensible starting set:

Group	Example categories
Housing	Rent or mortgage, rates or council tax, home insurance, maintenance
Utilities	Electricity, gas, water, internet, phone
Food	Groceries, eating out
Transport	Fuel, public transport, car insurance, registration, servicing
Health	Medical costs, pharmacy, dental, health insurance
Debt	Credit card payments, loans
Savings	Emergency fund, sinking funds, long-term savings
Personal	Clothing, hobbies, subscriptions, gifts
Other	Anything that does not fit above

Keep one category called “Miscellaneous” for the odd items. If it grows large over a few months, split it. That tells you something real about where your money goes.

Step 3: add columns for planned and actual

For each category, make three columns:

1. Planned: what you intend to spend this month
2. Actual: what you really spent
3. Difference: planned minus actual

The difference column is where a budget earns its keep. A positive number means you spent less than planned. A negative number means you went over. After a couple of months you will see which categories need a more honest figure.

For the difference, a formula like =B10-C10 works. Format negative numbers in red if you like, but a plain minus sign is enough.

Step 4: decide how to give every dollar a job

There are two common approaches, and either is fine.

Subtract method. Total income, minus total planned spending, equals what is left. Aim for the result to be zero or a small positive number. If it is negative, you have planned to spend more than you earn, and something has to change before the month starts.

Zero-based method. Every dollar of income is assigned to a category, including savings, until nothing is unassigned. It is the same arithmetic, framed as a deliberate decision about each dollar.

If you are unsure where to begin, many people use a rough rule such as 50/30/20, which puts about half of income toward needs, 30 per cent toward wants and 20 per cent toward savings and debt. It is a popular rule of thumb rather than a law, and it will not fit every household, especially where housing costs are high. Use it as a starting point and adjust to your real numbers.

Step 5: build in the costs that only happen sometimes

This is where many first budgets fail. Annual and occasional costs, such as car registration, insurance premiums, holidays and Christmas, land in one month and wreck it.

The fix is to divide the yearly cost by 12 and set that amount aside each month. These are called sinking funds, and our guide to sinking funds walks through how to set them up. Add a “Sinking funds” group to your category list, with one row per expense.

Step 6: log transactions

You have two options for the actual column.

Enter totals once a week. Add up your spending by category from your bank statement every Sunday, say, and type in the totals. It is quick and good enough for most people.

Keep a transaction log. Make a second sheet with columns for date, description, category and amount. Then use a SUMIFS formula on the budget sheet to total each category for the month. It takes more setup but gives you a searchable record.

A basic version of that formula looks like this: =SUMIFS(Transactions!D:D, Transactions!C:C, A10). It adds up every amount in column D where the category in column C matches the category named in cell A10. You can add a month condition as well.

A drop-down list for the category column, using data validation, stops typos from splitting one category into two.

Step 7: review once a month

Set a regular time, perhaps the first weekend of the month, and do four things:

• Compare planned and actual for each category
• Move any leftover or overspend with a short note on why it happened
• Adjust next month’s plan to reflect reality
• Check your savings and debt balances

Fifteen minutes is usually enough. The aim is not perfection. It is to notice drift while it is small.

Common mistakes

• Planning with hopeful numbers. If you spent 600 on groceries last month, do not budget 400 because it sounds sensible. Start with the real figure and trim it later.
• Forgetting irregular costs. See sinking funds above.
• Tracking too much detail. If a category never changes your decisions, merge it with another.
• Giving up after one bad month. An over-budget month is information. Note why, adjust and carry on.
• Mixing up budget and bank balance. A budget is a plan. Your bank balance is a fact. They are supposed to differ, and the actual column is how you reconcile them.

Budgeting by paycheck

Some people find a monthly view too loose, particularly if bills fall at different times of the month. In that case you can budget by paycheck instead: list each pay date, then assign the bills that fall before the next pay to that paycheck. Each pay is then planned on its own, so you can see which one is tight. The Paycheck Budget spreadsheet is built for this style, and it works for weekly, fortnightly and monthly pay.

Build it yourself or start from a template

Everything above can be built in an afternoon with a blank sheet, and doing so teaches you how the pieces connect. If you would rather not wire up formulas, charts and drop-downs from scratch, a ready-made workbook saves the setup time. The Chalkline Money System 2027 is one example: a single workbook covering the budget, a transaction log, bills, debt payoff, sinking funds and net worth, with a filled example so you can see each tab working. It is a tracking tool, not financial advice, and it works in any currency.

Whichever route you take, the checklist is the same.

Quick checklist

• Income listed after tax, using a cautious figure if it varies
• 15 to 30 spending categories grouped sensibly
• Planned, actual and difference columns for each
• Sinking funds for yearly and occasional costs
• A weekly or monthly routine for entering spending
• A monthly review slot in your calendar

Frequently asked questions

How do I make a budget spreadsheet in Google Sheets?

Open a blank Google Sheet, create an income section and a list of spending categories, then add planned, actual and difference columns. Use SUM for totals and SUMIFS if you keep a separate transaction sheet. If you already have an Excel file, you can upload it to Google Drive and open it with Google Sheets.

How many budget categories should I have?

Most households do well with 15 to 30. Fewer than that can hide where money goes, while more than that makes tracking tiresome. Merge categories that never change a decision, and split any that grow too large.

Should I budget weekly, fortnightly or monthly?

Match the budget to how you are paid and when bills fall due. Monthly works well if you are paid monthly and your bills are spread evenly. If you are paid weekly or fortnightly, or your bills cluster at certain times, budgeting by paycheck gives a clearer picture.

How long does it take to build a budget that works?

Expect the first version to be rough. Most people refine their figures over two or three months as they compare planned and actual spending. The first month teaches you the real numbers, and the budget gets more accurate from there.

If you want the structure built for you, the Chalkline Money System 2027 gives you a connected budget workbook to start from.