If you have ever checked your bank balance on the 20th of the month and wondered where your paycheck went, you are not alone. A monthly budget spreadsheet fixes that by showing you, in plain numbers, what you planned to spend versus what you actually spent. It is free, takes about 30 minutes to build, and works in Google Sheets or Excel with zero special skills.
This guide walks you through creating your own, with the exact columns, categories, and formulas. No paid app, no finance degree. Just a laptop and honest numbers.
Key Takeaways
- A monthly budget spreadsheet tracks income, planned spending, and actual spending in one table you update yourself.
- The five core sections are Income, Fixed Expenses, Variable Expenses, Savings, and a Summary row with simple formulas.
- You only need three formulas: SUM, a subtraction for remaining money, and a percentage for savings rate.
- Use 8 to 12 broad categories, update the sheet once a week, and keep the setup under 30 minutes.
- Free Google Sheets is the best starting tool; upgrade to a template or app only if you stop using the manual version.
What Is a Monthly Budget Spreadsheet?
A monthly budget spreadsheet is a simple table, usually in Google Sheets or Excel, where you list income at the top, planned spending by category in the middle, and actual spending next to it for comparison.
Each row is a spending category with three money columns: planned, actual, and the difference. The bottom totals everything and shows whether you saved or overspent. That planned-versus-actual comparison turns vague money anxiety into fixable numbers.
Why Build a Budget Spreadsheet Instead of Using an App?
A spreadsheet gives you something no app can: total control. You see every number because you typed it yourself, and typing in that $14 lunch forces you to notice it. Manual tracking builds spending awareness faster than automatic syncing ever does.
Spreadsheets are also free forever, private, and endlessly flexible, with no subscription or bank connection needed.
That said, if you try the spreadsheet for two months and stop updating it, automation wins. Our guide to the best budgeting apps and templates of 2026 covers when to switch.
What Do You Need Before You Start?
You need four things, and you probably have all of them already:
- A free spreadsheet tool. Google Sheets is free in any browser; Excel works too.
- Your income numbers. Your monthly take-home pay. If income varies, use your lowest typical month.
- Two to three months of spending history from bank or card statements, so your first budget uses real numbers, not guesses.
- Thirty quiet minutes. Setup is one-time; maintenance is about 10 minutes a week.
Gather numbers before you open the spreadsheet. Guessing from memory is one of the classic budgeting mistakes beginners make, and it guarantees a budget that falls apart in week one.
The 5 Core Sections of Every Monthly Budget Spreadsheet
Every good budget spreadsheet template has the same five sections.
1. Income
List every income source on its own row: salary, freelance pay, side hustle income, anything regular. Add a SUM total at the bottom. This number is your starting line.
2. Fixed Expenses
Bills that barely change month to month: rent or mortgage, insurance, loan payments, subscriptions, phone bill. List each with its exact amount.
3. Variable Expenses
These change every month: groceries, dining out, gas, shopping, entertainment, personal care. Set each planned limit from your last three months of real spending, trimmed by about 10 percent. This is where most people find their hidden savings.
4. Savings and Debt Payoff
Treat savings like a bill. Add rows for your emergency fund, retirement contributions, and extra debt payments. Paying yourself first, right after income arrives, is the habit that separates people who build wealth from people who do not.
5. Summary Row
At the bottom, three formulas do the thinking: total income minus total expenses equals money left over, and money left over divided by income equals your savings rate. If the first number is negative, your budget just told you exactly how much to trim.
How to Create a Monthly Budget Spreadsheet in 7 Steps
Here is the exact build process. Follow it in order and you will have a working budget spreadsheet in about half an hour.
Step 1: Open a blank sheet and name your columns
Create four columns: Category, Planned, Actual, and Difference. Add the month name at the top. This planned-versus-actual layout is the heart of the system.
Step 2: Fill in your income section
Type “INCOME” as a header, list each income source on its own row, and add a total row with =SUM(B2:B5) (adjust row numbers to match your sheet).
Step 3: Add fixed expenses
Type “FIXED EXPENSES” and list every recurring bill with its exact amount, then add a SUM total. Most people have 5 to 8 fixed expenses.
Step 4: Add variable expenses with realistic limits
Type “VARIABLE EXPENSES” and list groceries, dining out, transport, shopping, entertainment, and personal care. Set each Planned amount from your real three-month average, minus about 10 percent, then add a SUM total.
Step 5: Add your savings rows
Type “SAVINGS” and add rows for emergency fund, retirement, and extra debt payoff. The 50/30/20 budget rule suggests aiming for 20 percent of income to savings eventually, but start where you are.
Step 6: Build the summary formulas
At the bottom, add:
- Total Income: the SUM of your income section
- Total Expenses: the SUM of all expense and savings sections
- Money Left Over:
=TotalIncome - TotalExpenses - Savings Rate:
=MoneyLeftOver / TotalIncome, formatted as a percentage
If Money Left Over is positive, you are done. If it is negative, trim a variable category until it turns positive.
Step 7: Enter actuals once a week
Each week, spend 10 minutes typing actual spending into the Actual column. The Difference column (=Planned - Actual) flags where you overspent. Pair this with a 10-minute weekly money review and your budget stays alive instead of becoming a January-only ritual.
The Only Budget Spreadsheet Formulas You Need
You do not need to learn spreadsheet software. Three formulas run your entire budget.
SUM adds things up. =SUM(B2:B10) adds every number in cells B2 through B10. Use it for income totals, expense sections, and grand totals.
Subtraction finds what is left. =B20-B35 subtracts total expenses from total income. This answers the only question that matters: did I spend less than I earned?
Division gives you percentages. =B37/B20 divides money left over by total income. Format as a percentage and you have your savings rate.
That is the complete list. If you can type those three, your spreadsheet is as powerful as any paid tool for planning.
Monthly Budget Spreadsheet Categories: The Full List
Keep 8 to 12 categories total, then customize this starter list to your life:
Fixed: Housing, Utilities, Insurance, Phone, Internet, Subscriptions, Loan payments, Childcare
Variable: Groceries, Dining out, Transport and gas, Shopping, Entertainment, Personal care, Pets, Gifts
Savings: Emergency fund, Retirement investing, Extra debt payoff, Sinking funds (car repairs, holidays, annual bills)
Google Sheets vs Excel vs a Free Template: Which Should You Use?
Google Sheets is the best choice for most beginners. It is free, autosaves to the cloud, works on your phone, and lets you share the budget with a partner. For couples, that shared access alone makes Sheets the winner.
Excel makes sense if you already pay for Microsoft 365 or prefer working offline on a desktop. More powerful, but you will not need those extras for a monthly budget.
A free pre-made template is the fastest start. Google Sheets has built-in budget templates under File, then New, then From template gallery, with columns and formulas ready-made. Expect to delete and rename rows, since someone else’s categories rarely match your life.
Start with whichever gets you going this week. You can rebuild in month two once you know which categories you actually use.
5 Spreadsheet Budgeting Mistakes to Avoid
Guessing your numbers. Building a budget from memory instead of bank statements creates fantasy limits you will break by week two. Always start from three months of real data.
Creating 30 categories. Over-detailed spreadsheets die fast. If updating your sheet takes more than 15 minutes a week, simplify until it does.
Skipping the weekly update. A spreadsheet you update monthly is a history book, not a budget. The weekly 10-minute entry is what makes the numbers useful while you can still act on them.
Forgetting irregular expenses. Car insurance paid twice a year, annual subscriptions, holiday gifts. Divide each by 12 and save that amount monthly in a sinking fund row, or these “surprise” bills will wreck your budget twice a year.
Hiding from red numbers. When a Difference cell goes negative, that is your budget working, not failing. Adjust the plan, not your honesty.
Frequently Asked Questions
What is a monthly budget spreadsheet?
A monthly budget spreadsheet is a table in Google Sheets or Excel where you record income, planned spending by category, and actual spending each month. It compares plan versus reality, so you can see exactly where your money goes and adjust before next month.
How do I make a budget spreadsheet in Google Sheets for free?
Open Google Sheets, create a blank spreadsheet, and set up four columns: Category, Planned, Actual, and Difference. Add income, fixed expenses, variable expenses, and savings as rows under section headers, then use SUM for totals. Setup takes about 30 minutes and costs nothing.
How often should I update my budget spreadsheet?
Update the Actual column once a week, about 10 minutes. Review the full month on the first weekend of the new month and set fresh Planned amounts from what you learned.
Can I use a budget spreadsheet with irregular income?
Yes. Base your Planned column on your lowest typical month, not your best one. In high-income months, send the extra straight to savings or debt payoff instead of raising spending limits.
Is a spreadsheet better than a budgeting app?
A spreadsheet wins on control, privacy, and cost, if you will enter numbers weekly. An app wins on automation and real-time alerts. Pick the one you will actually use.
The Bottom Line
A monthly budget spreadsheet is the simplest, cheapest way to take control of your money. Five sections, three formulas, 30 minutes of setup, 10 minutes a week. That small effort replaces money anxiety with clear numbers and a plan you can follow.
Build yours today using the steps above. And once the system is running, keep it healthy with a monthly money reset so every dollar keeps its job.
This article is for general information only and is not financial advice.