Blush graphic titled Monthly Budget Template for Google Sheets

Monthly Budget Template for Google Sheets: How to Set One Up and Stick to It

A monthly budget template in Google Sheets needs three things: a list of categories with a planned amount for each, one log where you record every transaction, and a formula that adds the log up so you can compare planned against actual. Set it up once, copy it each month, and spend about 10 minutes a week keeping it current.

Below is how to build your own, step by step. If you would rather skip the setup, our monthly budget template for Google Sheets (it also works in Excel) comes with the formulas, a dashboard and a filled-in example.

What should a monthly budget template include?

A template only has to answer one question: how much of this month's money is left, and where did the rest go? These parts cover it:

  • Income: every paycheque, side income and benefit you expect this month.
  • Fixed bills: rent or mortgage, utilities, phone, insurance and subscriptions, with due dates.
  • Flexible spending: groceries, gas or transit, eating out, kids, personal.
  • Debt payments: the minimum for each debt, plus any extra you plan to pay.
  • Savings: your emergency fund, plus money set aside for costs that don't come monthly.
  • Planned, actual and difference columns: the difference column is the part you will actually look at.

Twelve to twenty categories is plenty when you start. You can split one later if it gets too big to be useful.

How do you make a monthly budget in Google Sheets?

You need two tabs. Open a new sheet and rename the first tab Log and the second Budget.

  1. Set up the Log tab. Use four columns: Date, Category, Description, Amount.
  2. Add a category dropdown. Select the Category column and choose Data, then Data validation, then Dropdown (from a range), and point it at your category list. This stops "Grocery" and "Groceries" from being counted separately.
  3. Set up the Budget tab. List your categories in column A, your planned amounts in column B, the actual total in column C and the difference in column D.
  4. Add the actual formula. In C2, this adds up November 2026 spending for the category in A2:

=SUMIFS(Log!D:D,Log!B:B,A2,Log!A:A,">="&DATE(2026,11,1),Log!A:A,"<"&DATE(2026,12,1))

  1. Add the difference formula. In D2, type =B2-C2, then copy both formulas down the list. A negative number means you went over.
  2. Copy it for next month. Duplicate the Budget tab and change the two dates in the formula.

That is a working budget. What it won't give you is a year view, debt order or savings progress, and those take longer to build. The ready-made budget spreadsheet for Google Sheets and Excel has eight tabs that include a yearly dashboard, a bill tracker, a debt payoff calculator with snowball and avalanche order, and savings goals.

How do you budget for costs that don't come every month?

Car insurance, Christmas, school fees and repairs are what usually break a monthly budget, because they are real costs that never appear on a normal month's list. The usual fix is a sinking fund:

  1. List each cost you expect in the next 12 months and what it will roughly be.
  2. Divide each by the number of months until it is due.
  3. Add those amounts to your budget as a monthly savings line.

A $600 insurance bill due in 12 months becomes $50 a month. When the bill arrives, the money is already there and the month stays on plan.

How do you keep up with a budget spreadsheet?

Most budget spreadsheets are dropped for one of two reasons: updating them takes too long, or the totals only appear after the month is over, when it is too late to change anything. A short routine fixes both.

  • Update it once a week. Pick a set time and enter the week's transactions from your banking app. It takes about 10 minutes.
  • Check only the difference column. You don't need to read the whole sheet, only the categories running over.
  • Try a daily number. Take what is left after bills and divide it by the days until your next payday. It gives you one figure to remember.
  • Line bills up with payday. Add due dates to your bill list, and ask your providers whether a date can move closer to when you get paid.
  • Share it. If you budget with a partner, use the Share button so you are both looking at the same sheet. Only one of you has to enjoy spreadsheets; the other can just read the summary.

Paying off debt at the same time? Read how to create a debt payoff tracker in Excel or Google Sheets. If you are in school, our student budget spreadsheet guide works by semester instead of by month.

Is there a free budget template for Google Sheets?

Yes. Google Sheets has a basic monthly budget in its template gallery (File, New, From template gallery), and the two-tab version above costs nothing to build. Those are good places to start. A paid template is worth it when you want the year view, debt plan and savings goals without building and fixing them yourself.

Do you prefer a spreadsheet or paper?

Spreadsheets do the adding for you and are easy to share. Paper is harder to ignore when it sits open on the table, and some people find writing numbers down makes them stick. If that is you, the printable budget and money planner has monthly and paycheque budgets, bill trackers, sinking funds and a 52-week savings challenge.

Budget templates that are ready to use

FAQ

Can I use an Excel budget template in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets, or use File, Import from a blank sheet. Formulas such as SUMIFS work in both. Check the charts and formatting after you import, since they can look slightly different.

How many budget categories should I have?

Start with 12 to 20. Too few and you can't see where the money went; too many and logging becomes a chore. If one category keeps taking a large share of your spending, split it in two.

How often should I update my budget spreadsheet?

Once a week is enough for most people. Daily works if you enjoy it, but monthly usually means you find out about overspending after it is too late to do anything about it.

What is the difference between a monthly budget and a paycheque budget?

A monthly budget plans all of a month's income and costs together. A paycheque budget plans each pay separately and assigns bills to the pay they fall after, which helps if you are paid weekly or every two weeks and money runs short before payday.

Back to blog

More from the blog

Read all articles