How to set up a budget template in Google Sheets

Where Google's own budget templates are in Sheets on a computer and on a phone, how to build a simple budget template yourself with a dropdown and SUMIF, and how to keep it filled in.

Bujit teamUpdated 7 min read

Also in: 日本語, Deutsch, Português (Brasil), Español, Français, 한국어

No bank login and no account. Your expenses are stored on your phone, and we never sell your data.

Quick answer

Google Sheets has budget templates built in. On a computer, go to Sheets, click Template Gallery at the top right and click a budget template; a copy opens for you to fill in. To build your own instead, list categories with a planned amount, log purchases on a second sheet, and total each category with SUMIF.

Where
Template Gallery, top right of Sheets
On a phone
Sheets app, New, Choose template
Key formula
SUMIF, one per category
Next month
File, then Make a copy
Five steps to a budget template in Google Sheets: go to Sheets, click Template Gallery, pick a budget, fill in the copy, keep a blank one
On this page
  1. How to open Google's budget template in Google Sheets
  2. How to build your own budget template in Google Sheets
  3. What a spreadsheet budget doesn't do
  4. How to use Bujit next to your Google Sheets budget
  5. Which should you use?
  6. Questions people ask
  7. Sources

How to open Google's budget template in Google Sheets

Google makes its own templates for Sheets, and budgets are among them. They're free with a Google account and open as your own copy, so you can change anything. Before you fill one in, have your numbers ready: working out your monthly income and expenses takes one evening with your pay stubs and bills.

  1. Open Google Sheets on a computer. Go to Google Sheets in your browser and sign in to your Google account.
  2. Click Template Gallery. It's at the top right of the Sheets home page. Don't see it? Click Menu at the top left, then Settings, and turn on Display recent templates on home screens.
  3. Click a budget template. A copy of the template opens, yours to edit.
  4. Keep a blank copy for next month. Before you fill it in, click File, then Make a copy, type a name and choose where to save it. At the start of each month, copy that blank one again.
  5. Make it yours. Rename this month's copy and fill it in with your own numbers.

On a phone, open the Google Sheets app on iPhone, iPad or Android, tap New in the bottom corner, tap Choose template, then tap the template you want.

How to build your own budget template in Google Sheets

A template of your own takes longer to set up, but it has exactly your categories and does exactly the sums you want. You need two sheets in one file: Budget for the plan and Transactions for every purchase.

  1. Set up the Budget sheet. In row 1, type four headings: Category, Planned, Spent and Left. From row 2 down, list your categories in column A and what you plan to spend on each in column B.
  2. Set up the Transactions sheet. Add a second sheet and name it Transactions. Give it four headings: Date, Description, Category and Amount, so categories end up in column C and amounts in column D.
  3. Add a category dropdown. On Transactions, select the Category cells from C2 down, click Data, then Data validation, then Add rule. Under "Criteria," choose Dropdown from a range, select your categories on the Budget sheet and click Done. Every purchase now gets a category from your list, spelled the same way.
  4. Total each category with SUMIF. On the Budget sheet, in C2, type =SUMIF(Transactions!C:C, A2, Transactions!D:D) and copy it down. It adds up every purchase whose category matches the name in column A. In D2, type =B2-C2 and copy it down to see what's left.
  5. Turn overspending red. Select the Left column, click Format, then Conditional formatting. Under "Format cells if," choose Less than, enter 0, pick a red fill and click Done. A category that runs over turns red.

Here's how the Budget sheet reads partway through a month, with made-up numbers:

PlannedSpentLeft
Housing$1,550$1,550$0
Food$500$362$138
Transport$400$215$185
Shopping$250$274-$24, in red
Fun$150$60$90
A budget template in Google Sheets: the Budget sheet in the middle of a month

Not sure which categories to list? A short list of categories most budgets start from fits on one screen. Working in Excel instead? The same SUMIF formula works there, and setting up a budget template in Excel walks through the Excel menus.

What a spreadsheet budget doesn't do

  • It only knows what you type in. Every purchase is a new row with four cells. Miss a few days and the Spent column is wrong without telling you.
  • It's slowest where you spend. You're at a checkout or a gas pump with your phone in hand. Adding a row there means opening the file, finding the next empty row and typing into small cells.
  • It warns you only when you look. The red Left cell appears when you open the sheet, not when you pay.
  • Cash needs remembering. A card purchase is at least in your bank statement later. Cash leaves no record unless you write it down.
Your own Sheets templateBujit
Plans income and savingsAny rows you likeNo, spending only
Totals each categoryWith SUMIFSpent of each limit, with a bar
Adding a purchase on your phoneA new row with four cellsManual Entry, or a Shortcuts automation for Apple Pay taps on iPhone
Warns before a category runs outNo, turns red once it's over, when you open the sheetA banner when you add an expense in the app
Needs an accountA Google accountNo account
Needs a bank loginNoNo
A Google Sheets budget template you build and Bujit, side by side

How to use Bujit next to your Google Sheets budget

Bujit, the expense tracker we make, doesn't connect to Google Sheets. It can sit next to your sheet, though: the plan stays in the sheet, and Bujit does the logging while you're out. No bank login, no account.

In Bujit

Get Bujit
  1. Keep the plan in your sheet. Each category's planned amount stays in the template, along with income and savings if you've added rows for them.
  2. Copy the spending plan into Bujit. Open Budgets, tap Set on the Monthly Budget card (or Edit total budget once it has one), enter the total of your sheet's spending categories as the Amount and tap Save. Then tap Set a budget under each category, enter its planned amount and tap Save. To match a category from your sheet, tap the gear on Home, then Categories, then +.
  3. Choose when to hear about it. Drag Notify me at on a category's card to the percentage you want, such as 80%. A banner tells you when an expense you add in the app passes it.
  4. Log as you pay. Tap + at the top right, then Manual Entry, enter the amount, what it was for and the category, and tap Save.
  5. Fill in the sheet once a month. On the 1st, open History, tap This Month and choose Last Month, then tap a category to see its total. On last month's Transactions sheet, add one row per category with that total, and SUMIF fills in Spent.
Bujit's Home screen with this month's total and category bars, the numbers to copy into a budget template in Google Sheets
Log purchases as you pay, then copy each category's total into your sheet at the end of the month.

Budgets in Bujit count the calendar month and start again on the 1st, with nothing carried over, the same as a new copy of your sheet. A category's card says Approaching limit past 80% and Over budget by the amount once you pass it. On iPhone, a Shortcuts automation can log each Apple Pay purchase when you tap your iPhone to pay; it sorts them into Bujit's six built-in categories, so if your sheet uses other names, touch and hold a tap in History, tap Edit and move it before you copy the totals. Those taps don't show the budget banner when you pay. Voice entry and receipt scanning are part of Bujit Pro; they send what they need to Google Gemini, and only after you agree. Your expenses are stored on your phone.

Which should you use?

  • You want a budget in Sheets today: Google's own template from the Template Gallery, filled in with your numbers.
  • You want your categories and your formulas: your own template with a Budget sheet, a Transactions sheet and SUMIF.
  • You do most of your budgeting at a laptop once a week: either template, filled in from your bank and card statements.
  • You'd rather log purchases on your phone as you pay: keep the plan in Sheets and log in an expense app like Bujit, then copy the totals across once a month.

Whichever you pick, set a time to fill it in, like Sunday evening. A template nobody updates is just last month's plan.

Questions people ask

Does Google Sheets have a budget template?

Yes. Google's own templates include budgets, alongside resumes and order forms. On a computer, go to Google Sheets, click Template Gallery at the top right and click the template you want. A copy of it opens for you to fill in.

Why can't I see the Template Gallery in Google Sheets?

It can be hidden. On the Sheets home page, click Menu at the top left, then Settings, and turn on Display recent templates on home screens. Template Gallery then shows at the top right again.

Can I use a Google Sheets budget template on my phone?

Yes. In the Google Sheets app on iPhone, iPad or Android, tap New in the bottom corner, tap Choose template, then tap the template you want to use.

How do I make my own budget template in Google Sheets?

Make one sheet with your categories and a planned amount for each, and a second sheet for purchases with a date, a description, a category and an amount. Add a dropdown to the category column, then total each category on the first sheet with SUMIF.

What formula adds up a budget category in Google Sheets?

SUMIF. With purchases on a sheet named Transactions, categories in column C and amounts in column D, =SUMIF(Transactions!C:C, A2, Transactions!D:D) adds up every purchase whose category matches the name in A2.

How do I reuse my budget template next month?

Keep a blank copy. Before you fill in your template, click File, then Make a copy, give it a name and choose where to save it. At the start of each month, make a copy of that blank one, so last month's purchases stay behind.

Does Bujit work with Google Sheets?

Not directly: Bujit doesn't connect to Google Sheets. You can keep the plan in your sheet and log purchases in Bujit as you pay, then add each category's monthly total from Bujit's History to the sheet at the end of the month.

Sources

Track it in seconds

No bank login and no account. Your expenses are stored on your phone, and we never sell your data.

Free to download. Optional Pro plans available.

Track spending by voice