Create a Budget Spreadsheet

How to Create a Budget Spreadsheet (the Easy Way)

I used to think the hardest part of budgeting was sticking to the budget. It isn’t. The hardest part is the blank spreadsheet — that moment when you open a new file and realize you have to invent every income line, every expense category, and every formula from scratch before you can even type your first number. Most people quit right there, and I nearly did too.

That is exactly why we built this free budget spreadsheet maker. Instead of starting from nothing, you pick the kind of budget you’re making and the tool builds the whole spreadsheet around you: the right income sources, the right expense categories, running totals, charts, and a reality check against the 50/30/20 rule. When you’re happy with it, you download it as a working Excel spreadsheet, open it in Google Sheets, or save a clean PDF — with the SUM formulas already built in, so the file keeps recalculating as your numbers change.

How the Budget Maker Works

1. Choose your timeframe — weekly, biweekly, monthly, or yearly. If you’re paid every two weeks, budget every two weeks; the budget should match the rhythm of your money, not fight it.
2. Pick your budget type. A wedding budget and a small business budget have almost nothing in common, so each template starts you off with categories built for that exact situation.
3. Fill in your numbers. Every row, name, and category is editable — add rows, remove groups, rename anything. The tool saves automatically as you type, so you can close the tab and pick up later.
4. Read your results. A donut chart shows where the money goes, a bar chart compares income against spending, and the 50/30/20 check tells you whether your plan leans too hard on wants at the expense of savings.
5. Download it. Export a real budget spreadsheet for Excel or Google Sheets with live formulas, save a printable PDF, or grab a CSV.

A Budget Spreadsheet Template for Every Situation

A generic budget spreadsheet template forces you to delete half the rows and guess the rest. These are built specifically for the budget you’re actually making:

• Personal budget template — everyday money for one person: housing, bills, food, transport, debt payments, fun, and savings.
• Home and household budget template — the whole home, including upkeep, supplies, kids, and pets.
• Family budget template — childcare, school fees, activities, and the college fund get their own lines.
• Wedding budget template — venue and catering, attire, photography, flowers, stationery, and a contingency line, because there is always a contingency.
• Event budget template — parties, showers, and gatherings, with ticket income and sponsors on the funds side if you need them.
• Business budget template — revenue at the top, then payroll, marketing, software, operations, and taxes set aside, so you can see profit at a glance.
• Project budget template — labor, materials, equipment, and contingency for scoped work.
• Travel budget template — flights, lodging, food, activities, and travel insurance, so the vacation doesn’t follow you home on a credit card statement.
• College student budget template — tuition, books, rent, the meal plan, and a realistic line for eating out.
• Home renovation budget template — permits, trades, materials, fixtures, and the 15–20% contingency every contractor will tell you to keep.
• Nonprofit budget template — donations and grants on the income side; programs, admin, and fundraising costs on the other.
• Retirement budget template — Social Security, pension, and withdrawals against healthcare, everyday living, and the fun you retired for.
• New baby, holiday, moving, and grocery budgets — the short-lived budgets that wreck the long-term ones when nobody plans them.

Weekly, Biweekly, Monthly, or Yearly?

Most advice defaults to a monthly budget template, and monthly is a fine place to start — most bills arrive monthly. But I’ve found the best timeframe is simply the one that matches your paycheck. If you’re paid weekly, a weekly budget template keeps every number small and concrete. If you’re paid every two weeks, a biweekly budget template means every budgeting period starts with a deposit, which makes the whole thing feel winnable. A yearly budget template is the right lens for annual planning, businesses, and anyone who wants to see the big picture — insurance premiums, holidays, and other lumpy expenses stop being surprises when they’re on the page.

Whichever you choose, the tool shows your totals converted to every other timeframe too. Seeing a modest weekly habit expressed as a yearly number is occasionally life-changing.

How to Make a Budget in Excel

If you’d rather build your budget spreadsheet in Excel by hand, here is the structure that works:

1. Put your income sources in the first rows and total them with a SUM formula.
2. Group expenses into categories — housing, utilities, food, transport, debt, fun, savings — and give each category a subtotal.
3. Add a grand total of all category subtotals, then a final row that subtracts total spending from total income. That last number is the whole point of the budget.
4. Format the category headers so your eye can find them, and leave a few blank rows in each group for the expenses you forgot (there are always expenses you forgot).

Or skip all of that: the Excel file this budget maker downloads already contains that exact structure with the SUM formulas in place. Open it, change any number, and every subtotal, the grand total, and the left-over figure recalculate instantly — it behaves exactly like a budget spreadsheet you built yourself, minus the hour of setup.

How to Create a Budget in Google Sheets

Google Sheets is my pick for shared budgets — couples, roommates, committees — because everyone can edit the same file from their phone. To use this tool as a Google Sheets budget template, download the Excel file, then go to sheets.google.com, open a blank sheet, and choose File, then Import, then Upload — or just drag the file into Google Drive and double-click it. The formulas carry over intact. Once it opens, use File and then Save as Google Sheets to keep it in your Drive permanently, and share it with whoever shares the budget.

The 50/30/20 Budget Spreadsheet Check

The 50/30/20 rule is the most useful budgeting guideline I know, precisely because it’s simple: aim to spend about 50% of your after-tax income on needs, 30% on wants, and 20% on savings and debt payoff. It’s not a law — housing alone can eat 50% in an expensive city — but it’s an honest mirror.

In this tool, every category group carries a Need, Want, or Savings tag (you can change any of them), and the 50/30/20 check compares your actual split to the targets with a bar for each. If your savings slice is thin, you’ll see it immediately, along with how much of your income you haven’t assigned to anything yet. Give every dollar a job, even if the job is savings — that idea comes from zero-based budgeting, and you can run this tool that way too: keep assigning categories until the left-over figure reads exactly zero. See the 50/30/20 calculator

Planned vs. Actual: Where Budgets Go to Die

A budget you write once and never look at again is a wish. Switch on the tool’s actual-spending column and it becomes a budget tracker: planned next to actual, with the difference calculated for every row, every category, and the bottom line. The downloaded spreadsheet keeps both columns and their formulas, so at the end of the week or month you type in what really happened and the sheet tells you the truth.

Prefer Pen and Paper?

Some people budget better on paper, and I completely get it — there’s a reason printable budget worksheets remain so popular. If that’s you, use the PDF download for a clean printable budget sheet of your own numbers, or browse our printable budget worksheets and bill tracker printables for ready-to-print pages you can fill in by hand.

Frequently Asked Questions

How do I make a budget spreadsheet?

List your income sources at the top and total them. Group your expenses into categories, subtotal each category, then subtract total expenses from total income to see what’s left. Our free budget spreadsheet maker builds that entire structure for you — categories, totals, formulas, and charts — and lets you download it for Excel or Google Sheets.

How do I make a budget in Excel?

Create an income section with a SUM total, expense categories with subtotals, and a final row that subtracts spending from income. Or download the Excel file from this budget maker — it arrives with all of those SUM formulas already working, so it recalculates as you edit it.

How do I create a budget in Google Sheets?

Download the Excel file from the budget maker, then drag it into Google Drive and open it, or use File, Import, Upload inside a blank Google Sheet. The formulas transfer intact. Save it as a Google Sheet and share it with anyone who shares the budget.

What is the 50/30/20 rule?

It’s a guideline suggesting about 50% of after-tax income goes to needs, 30% to wants, and 20% to savings and debt payoff. This tool tags each category as a need, want, or savings and shows how your actual plan compares to those targets.

Should my budget be weekly, biweekly, or monthly?

Match your paycheck. Paid every two weeks? Budget biweekly, so every period starts with a deposit. Most bills are monthly, which is why the monthly budget is the default — but the tool converts your totals between weekly, biweekly, monthly, and yearly so you can see all of them.

Is this budget spreadsheet maker really free?

Yes — completely free, with no sign-up and no email required. Your budget saves automatically in your own browser, and the Excel, Google Sheets, PDF, and CSV downloads are all included.

Does the downloaded spreadsheet include formulas?

Yes. The Excel and Google Sheets downloads include live SUM formulas for every category subtotal, total income, total spending, and the left-over amount, plus difference formulas if you track actual spending. Change any number and everything recalculates.