Posted in

How to Create a Budget Spreadsheet for Beginners: 4 Columns, 3 Formulas

A laptop showing a simple budget spreadsheet with planned and actual columns, for how to create a budget spreadsheet for beginners.

You know money is leaking somewhere, but you cannot say where, and that is exactly the problem a budget spreadsheet solves. It is a simple table that shows what you planned to spend, what you actually spent, and the difference, so the leak has a name and a number. This guide explains how to create a budget spreadsheet for beginners, from a blank sheet to a working monthly budget, in about thirty minutes, with only three formulas to learn.

You will get the exact column layout, the formulas with real cell references, a starter list of categories, the 50/30/20 split as a default plan, and a weekly routine that keeps the sheet honest. No template purchase, no budgeting app subscription, and no finance degree are needed. A free Google Sheets account is enough.

What Is a Budget Spreadsheet?

A budget spreadsheet is a table that tracks your money in and your money out, one row per spending category, with a planned amount, an actual amount, and the difference between them. That is the whole idea. Every popular budgeting guide uses the same four-column layout, because four columns are all it takes: Category, Planned, Actual, and Difference. The spreadsheet does the adding for you, so you spend your time looking at the numbers, not calculating them.

It differs from a budgeting app in one useful way: you build it, so you understand it. Apps hide the logic behind buttons and categories you did not choose. A spreadsheet shows every number and every formula, and you can change any of it in seconds. It also costs nothing. Google Sheets, Excel Online, and LibreOffice Calc are all free, and a budget spreadsheet works the same in all three, so pick the one you already have an account for.

The spreadsheet answers three questions every month. How much money came in? How much went out, and where did it go? And how much is left? If you can answer those three, you have a budget, and you can make decisions from it instead of guessing. If the difference column shows you spent $120 more on eating out than planned, the fix is obvious. Without the sheet, that $120 just disappears into the month.

Set It Up in 30 Minutes

Open a blank sheet and give it a name with the month, like Budget November 2026. Put your income at the top. In cell A1 write Income, in B1 write the source, like Paycheck, and in C1 write the take-home amount. Use take-home pay, not gross pay, because gross pay includes tax and deductions you never see. If your pay varies, use the lowest recent month as the planned figure, so the budget works even in a slow month.

Now build the main table, starting in row 3. The headers go in row 3: A3 Category, B3 Planned, C3 Actual, D3 Difference. Then list your categories in column A, starting in row 4. A good beginner list has 10 to 15 categories, which is enough to see where money goes without tracking every coffee separately. Start with these: Housing, Utilities, Groceries, Transport, Insurance, Phone, Minimum debt payments, Savings, Eating out, Entertainment, Shopping, Health, and Personal. You can split or merge categories later, once you see which ones actually need detail.

Fill in the Planned column with your best guess for each category, based on last month’s bank statements. Do not guess from memory, memory underestimates spending by a wide margin. Open your last two bank statements, add up each category, and use those totals. If groceries were $420 last month, plan $420, not the $300 you wish they were. An honest plan is useful, an optimistic one is not.

The whole setup takes about thirty minutes: ten minutes to list income and categories, ten minutes to check last month’s statements and fill in the planned amounts, and ten minutes to add the formulas below. After that, the sheet needs about ten minutes a week to stay current.

The Three Formulas You Need

You only need three formulas, and each one is simple. First, the total income formula. In the cell under your income amounts, type =SUM() with the income cells inside the brackets, for example =SUM(C1:C2) if your income is in C1 and C2. Second, the total expenses formula, in the same style, for example =SUM(B4:B16) for the planned column and =SUM(C4:C16) for the actual column. Third, the difference formula, in each row of column D: =B4-C4, which subtracts actual from planned, so a positive number means you spent less than planned and a negative number means you spent more.

One more formula ties it together: money left. In a cell below the table, type =total income minus total expenses, for example =C18-C19 if income is in C18 and expenses in C19. That single number is the health of your month. If it is positive, you have money to save or to move to a category that ran over. If it is negative, the budget has a problem you need to fix this month, not next month.

Two optional extras are worth adding once the basics work. A transaction log tab, where you paste each purchase with its date and category, lets you use =SUMIF() to auto-total each category from the log, so you never type an actual amount by hand again. And conditional formatting on the Difference column, green when you are under budget and red when you are over, makes the problem rows visible at a glance. Both take five minutes to set up, and both pay for themselves every week.

A Complete Starter Example

Here is a copy-ready starter layout for a single person with $3,000 take-home pay. The categories use the 50/30/20 split as the default plan: 50 percent for needs, 30 percent for wants, and 20 percent for savings and extra debt payments. That split is a useful starting point, not a law, and the savings row is where an emergency fund gets built, $400 at a time.

Category Planned Actual Difference
Housing (rent) $1,000 $1,000 $0
Utilities $150 $142 $8
Groceries $350 $368 -$18
Transport $150 $140 $10
Insurance $120 $120 $0
Phone $50 $50 $0
Minimum debt payments $100 $100 $0
Savings $400 $400 $0
Eating out $200 $260 -$60
Entertainment $100 $85 $15
Shopping $150 $140 $10
Health $80 $80 $0
Personal $50 $45 $5
Total $2,900 $2,930 -$30

Read the story the table tells. Needs come to about $1,920, wants to about $545, and savings to $400, close to the 50/30/20 split on $3,000 of take-home pay. Eating out ran $60 over, which is the one problem row, and the fix is visible: either plan $260 for eating out next month and cut $60 from shopping, or cook two more dinners at home a week. The sheet does not judge, it just shows the number, and the number makes the decision easy.

Adjust the categories to your life. A parent adds Childcare. A driver adds Car maintenance. A student adds Course materials. The right number of categories is the number that lets you see a problem when it appears. If a category never changes, merge it into another one. If one category keeps hiding two different kinds of spending, split it.

The Weekly Routine That Keeps It Honest

A budget spreadsheet fails when it goes stale, so the routine matters more than the setup. Once a week, on Sunday evening, spend ten minutes on it. Open your bank app, add the week’s spending to the Actual column or to the transaction log, and check the Difference column. If a category is already over with a week left in the month, decide now what to cut, while there is still time to act. If a category has money left over, move it to savings immediately, before it gets spent by accident.

At the end of the month, spend twenty minutes closing it out. Copy the sheet for the next month, carry over the categories, and adjust the Planned column using what you actually spent. If groceries were $368 two months in a row, plan $370, not $350. A budget that never changes is a budget that is not being read. The first month is always the least accurate, and the third month is usually the first one that feels right, so give the sheet three months before judging it.

Common beginner errors are easy to avoid. Do not budget with gross pay, or the plan will be short every month. Do not create forty categories, or updating the sheet becomes a chore you quit. Do not set the planned amounts from wishes instead of statements, or the sheet will show red every month and you will stop looking at it. And do not skip the weekly update, because a month of unrecorded spending is a month of guessing, which is what you had before the spreadsheet.

Google Sheets or Excel: Which Is Better?

For a beginner budget, Google Sheets is the better default. It is free, it auto-saves every change, it works on your phone, and you can share it with a partner without sending files back and forth. Excel Online is free too, and it is the better choice if you already live in Microsoft 365 or want the desktop Excel features later. LibreOffice Calc is free and works offline, which suits anyone who prefers keeping files on their own computer. The formulas in this guide work identically in all three, so the choice is about habit, not capability.

One practical tip: build the sheet on a computer, then use it on your phone. Typing formulas on a phone keyboard is slow, but checking a balance or adding a purchase on the phone is easy once the sheet exists. The Sheets and Excel phone apps both handle a budget table well, and the weekly update is much more likely to happen if you can do it from the sofa in ten minutes.

Frequently Asked Questions

What should a budget spreadsheet include?

Income, fixed and variable expenses, savings, and totals. The core table is four columns: Category, Planned, Actual, and Difference, with one row per spending category, plus a total income line, a total expenses line, and a money-left line. That is enough. A transaction log tab is a useful extra, but it is not required to start.

Is Google Sheets or Excel better for budgeting?

Google Sheets is free, auto-saves, and works well on phones and shared budgets, so it is the best default for most beginners. Excel Online is also free and suits Microsoft 365 users. The budget works the same in both, so choose the one you already use.

How many categories should I use?

Start with 10 to 15. Fewer than 10 hides where the money goes, and more than 15 turns the weekly update into a chore. Split a category when it keeps hiding two different kinds of spending, and merge categories that never change.

How often should I update it?

Weekly, in about ten minutes, ideally on Sunday evening. Add the week’s spending, check the Difference column, and fix any category that is already over before the month ends. At month end, spend twenty minutes closing out and setting next month’s planned amounts from what you actually spent.

Do I need a template or can I build my own?

You can build your own. A blank sheet, four columns, and three formulas are enough, and building it yourself means you understand every number in it. Templates save ten minutes of setup, but they often include categories you do not need and formulas you cannot explain, so a self-built sheet is usually the better first budget.

What formulas do I need?

Three: =SUM() for totals, a subtraction like =B4-C4 for the difference in each row, and income minus expenses for money left. An optional fourth, =SUMIF(), auto-totals each category from a transaction log. Those three cover the whole budget.

Conclusion

A budget spreadsheet is four columns, three formulas, and ten minutes a week. Start with your take-home pay, list 10 to 15 categories from last month’s bank statements, plan each one honestly, and let the Difference column show you where the money actually goes. Use the 50/30/20 split as a starting point, update the sheet every Sunday, and adjust next month’s plan from what you really spent. The first month will be rough, the third month will feel right, and by then the spreadsheet will be telling you the truth about your money, which is the whole point.

For a second opinion on the layout, see The Money Perspective’s beginner spreadsheet guide and Doable Atlas on building a simple spreadsheet in eight steps.

Leave a Reply

Your email address will not be published. Required fields are marked *