Free Budget Template: Build One in Google Sheets or Excel
A free budget template is only useful if it fits your life. Downloaded templates often come with dozens of categories you never use and formulas you do not understand. The fix is easy: build your own in Google Sheets or Excel in under an hour, using three simple tabs and a couple of beginner-friendly formulas.
Key takeaways
- A homemade budget template beats a downloaded one because every category and formula makes sense to you.
- Three tabs are enough: a category plan, a transaction log and a monthly summary.
- One formula, SUMIFS, does most of the work by adding up spending per category and month.
- Keep it simple at first, then add extras like sinking funds or a net worth tab once the habit sticks.
If you have ever typed "budget template free" into a search bar, you are far from alone. According to Google Trends, "budget template free" and "google sheets budget template" are among the most searched budgeting terms of the past year. People clearly want a ready-made starting point that costs nothing.
Both Google Sheets and Microsoft Excel offer built-in budget templates, and those are a perfectly fine place to start. But many people open a template, feel overwhelmed by its 50 rows of categories and never come back. Building your own takes a little longer on day one, yet it saves you hours of confusion later. You will know exactly what every cell does and how to change it.
This guide is general information to help you organize your money. It is not financial or tax advice.
Google Sheets or Excel: which should you use?
Either one works well for a personal or small freelance budget. The formulas in this guide work the same way in both. The choice mostly comes down to habit and how you like to work.
Google Sheets fits if
- You want to share the budget with a partner and edit at the same time
- You use a mix of devices and want everything in the browser
- You already use other Google tools for work or home
Excel fits if
- You already have Microsoft Excel through work or a subscription
- You prefer to keep files on your own computer
- You like more formatting and charting options
Whichever you pick, protect the file. Turn on two-factor authentication for your Google or Microsoft account, and keep a backup copy somewhere safe. A budget holds sensitive details about your life, so treat it with the same care as your bank login.
The three-tab layout
A simple, durable budget template has just three tabs. Create a new blank spreadsheet and rename the tabs at the bottom to Plan, Transactions and Summary.
Tab 1: Plan
This is where you list your categories and how much you plan to spend in each one per month. Keep it to about 10 to 15 categories. Add a column for the type of category so you can group needs, wants and savings later if you like.
| Category | Type | Monthly plan | Notes |
|---|---|---|---|
| Rent | Need | $1,200 | Due on the 1st |
| Groceries | Need | $450 | Weekly shop plus top-ups |
| Eating out | Want | $150 | Includes coffee runs |
Tab 2: Transactions
This is your running log. Every purchase, bill and payment goes here, one row each. You can type them in, paste them from a bank export or add weekly totals if you prefer a lighter touch. Add a Month column so formulas can sort spending by month easily.
| Date | Month | Description | Category | Amount |
|---|---|---|---|---|
| 2026-12-01 | 2026-12 | Monthly rent | Rent | 1200 |
| 2026-12-03 | 2026-12 | Supermarket | Groceries | 82.40 |
| 2026-12-04 | 2026-12 | Lunch with a client | Eating out | 27.50 |
Enter amounts as plain positive numbers for spending. Keep income on its own rows with a category called Income, so it is easy to total separately.
Tab 3: Summary
This tab compares what you planned with what you actually spent. It pulls categories from the Plan tab and totals from the Transactions tab, so you never type the same number twice.
| Category | Plan | Actual | Difference |
|---|---|---|---|
| Rent | $1,200 | $1,200 | $0 |
| Groceries | $450 | $478 | -$28 |
| Eating out | $150 | $112 | $38 |
Step by step: build it in under an hour
- Create the file and tabs. Open a blank spreadsheet in Google Sheets or Excel and add three tabs named Plan, Transactions and Summary.
- Fill in the Plan tab. List your categories in column A, their type in column B and the monthly plan in column C. Use last month's real spending as your guide, not your hopes.
- Set up the Transactions tab. Add the headings Date, Month, Description, Category and Amount in row 1. In the Month column, a formula like
=TEXT(A2,"yyyy-mm")turns the date into a month label automatically. - Add a drop-down for categories. Use data validation on the Category column and point it at the category list on the Plan tab. This prevents typos like "Grocery" versus "Groceries," which would break your totals.
- Build the Summary tab. In column A, link to your categories with a formula like
=Plan!A2. In column B, link to the plan amount with=Plan!C2. - Add the Actual formula. Put the month you want to review in cell F1 of the Summary tab, for example 2026-12. Then in column C use
=SUMIFS(Transactions!E:E, Transactions!D:D, A2, Transactions!B:B, $F$1). This adds up every amount for that category in that month. - Calculate the difference. In column D, use
=B2-C2. Positive numbers mean you spent less than planned. Negative numbers mean you went over. - Add totals and a little color. Total each column at the bottom and use conditional formatting to turn negative differences a soft red. That is the whole template.
Pro tip
Freeze the top row on the Transactions tab so the headings stay visible as the list grows. It is a tiny change, but it makes the log far easier to read on a phone screen when you add purchases on the go.
Worked example: a freelancer's December
Hypothetical example
Imagine Priya, a freelance translator, builds this template on a Sunday afternoon. She plans $1,200 for rent, $450 for groceries, $150 for eating out and $300 for her "pay myself" transfer into savings. By mid-December her Summary tab shows groceries at $310 and eating out at $135, with two weeks to go. The soft red warning on eating out is not there yet, but she can see it coming. She decides to host a potluck instead of going out for a holiday dinner, and her eating out line ends the month at $148. No guilt, no drama, just a clear picture and a small choice.
Priya also adds a category called Tax set-aside. Every time a client pays, she moves a share into a separate savings account and logs it here. That way the money for her tax bill never looks like spending money. If you freelance, this one category can save you a lot of stress.
Useful extras once the basics work
After a month or two, you may want a little more from your template. Add these one at a time, only when you feel the need.
- A sinking funds section. Sinking funds are money you set aside regularly for a known future expense, such as car repairs, insurance premiums, holidays, gifts or annual subscriptions. Add a row per fund with a target amount and a monthly contribution.
- A yearly view. Copy the Summary tab and change the formula to look at a full year instead of one month. This shows which categories creep up over time.
- A simple chart. A bar chart of Plan versus Actual by category makes the month easy to understand at a glance.
- A net worth tab. List what you own and what you owe, then subtract. Update it monthly or quarterly. The trend tells you far more than any single number.
- A 50/30/20 check. Since you already have a Type column, you can total needs, wants and savings to see how your spending compares with the popular 50/30/20 guideline.
Common mistake
Typing category names freehand in the Transactions tab. One extra space or a different spelling means SUMIFS will not count that row, and your totals will look lower than reality. Always use a drop-down list for categories, and check the Summary total against your bank balance now and then.
Keeping your template running
A template is only as good as the habit behind it. A short weekly session of about 15 minutes to add transactions, plus a monthly look at the Summary tab, is enough for most households. At the start of each new month, change the month cell on the Summary tab and the whole sheet updates.
Once a year, make a fresh copy of the file for the new year. Keep the old one as an archive. This keeps the Transactions tab from growing too large, and it gives you a tidy record to look back on. If you run a small business alongside your personal budget, keep that in a separate file or proper bookkeeping software. Mixing the two in one sheet makes both harder to read.
Your budget template checklist
- Create a blank spreadsheet with Plan, Transactions and Summary tabs
- List 10 to 15 categories with a type and a monthly plan
- Add a Month column with a TEXT formula on the Transactions tab
- Set up a category drop-down using data validation
- Add SUMIFS formulas to total actual spending by category and month
- Add a Difference column and color negative numbers
- Turn on two-factor authentication and keep a backup copy
- Schedule a weekly 15-minute update and a monthly review
Frequently asked questions
Is a built-in template good enough?
It can be. The built-in budget templates in Google Sheets and Excel are a fine starting point. If you find yourself ignoring half the rows or not trusting the formulas, that is a sign a simpler homemade version will serve you better.
Can I import transactions from my bank?
Many banks let you download transactions as a CSV file, which you can paste into the Transactions tab. You may need to tidy up the columns to match your headings. Check what your bank offers in its online banking area.
What if my income changes every month?
Plan your categories around a lower, typical month rather than your best one. A common rule of thumb for freelancers is to budget on your lowest typical month and send anything extra to savings, taxes or a buffer.
Should I use an app instead?
Apps can save time by pulling in transactions automatically. A spreadsheet gives you more control and costs nothing. Some people use both. If you try an app, check its current features, pricing and privacy policy first.
Related reading
The bottom line
A free budget template does not need to be fancy. Three tabs, a category drop-down and one SUMIFS formula give you a clear, flexible budget in Google Sheets or Excel. Because you built it, you understand it, and that makes you far more likely to keep using it.
Set aside an hour this week, build the basic version and use it for one month before adding any extras. Simple and steady wins every time.
