Getting started

A budget template in Google Sheets: build it with SUMIFS in 20 minutes

Build your own budget template in Google Sheets with a data tab, a monthly budget-versus-actual tab and SUMIFS formulas that work.

Editorial illustration for A budget template in Google Sheets: build it with SUMIFS in 20 minutes

Two tabs are enough for a working Google Sheets budget template: a Data tab with one row per expense, and a Budget tab that uses SUMIFS to total each category for the month you choose. The formulas below are exact; paste them and adjust the ranges. Once a sheet gets heavy, an app can take over the data entry.

Tab one: a Data sheet that stays tidy

Name the first tab Data. Put these headers in row 1: Date in A, Category in B, Amount in C, Account in D, Note in E. One expense per row, dates as real dates, amounts as plain numbers with no rupee sign typed in. Select column B from row 2 down, open Data, then Data validation, and add a dropdown from a list of your categories so spellings never drift.

Tab two: the Budget sheet

Name the second tab Budget. In cell B1 type the first day of the month you want to look at, for example 01-04-2026 as a real date. Build the table from row 3 down.

ColumnHeaderWhat goes in
ACategoryFood, Rent, Transport and so on, typed once
BPlannedYour planned amount for the month
CActualFormula pulling the total from Data
DLeftPlanned minus Actual

In C4, for the category named in A4, enter this formula:

=SUMIFS(Data!$C$2:$C$500, Data!$B$2:$B$500, $A4, Data!$A$2:$A$500, ">="&$B$1, Data!$A$2:$A$500, "<="&EOMONTH($B$1,0))

In D4 enter =B4-C4 and copy both formulas down. SUMIFS takes the sum range first, then each criteria range followed by its criterion. The EOMONTH function returns the last day of the month in B1, so the formula picks up exactly one month. Change B1 and the whole sheet moves to another month.

A worked example

Say B1 holds 01-04-2026, Food is planned at ₹9,000, and Data holds these April food rows: ₹2,400, ₹3,150, ₹1,980 and ₹1,300. The Actual cell returns 2,400 + 3,150 + 1,980 + 1,300 = ₹8,830, and Left shows 9,000 - 8,830 = ₹170. A row dated 02-05-2026 is ignored because it falls after the month end.

How do you total everything and spot overspending?

  • Total planned: =SUM(B4:B15)
  • Total actual: =SUM(C4:C15)
  • Flag overspending: select D4:D15, choose Format, then Conditional formatting, then Less than 0, and pick a red fill.
  • Check nothing is missing: =SUMIFS(Data!$C$2:$C$500, Data!$A$2:$A$500, ">="&$B$1, Data!$A$2:$A$500, "<="&EOMONTH($B$1,0)) gives the month's full spending. If it differs from the Actual total, a category is missing from your list.

What breaks a Sheets template?

  • Dates typed as text, which SUMIFS cannot compare. Click a cell: if it left-aligns, it is probably text.
  • Category spellings that do not match exactly, such as Groceries on one row and Grocery on another.
  • Rows added below row 500. Extend the ranges or use a larger number.
  • Amounts pasted with a currency symbol or commas as text.

One more habit worth having: freeze row 1 on both tabs (View, then Freeze, then 1 row) so headers stay visible, and protect the Budget formulas with a range protection so you do not overwrite them by accident while typing amounts. A template you have to repair every month will be abandoned by June.

When a sheet stops being enough

A template is a good start and costs nothing. It gets tiring when you are typing forty UPI payments a week or reading a PDF statement row by row. At that point an expense tracker such as SpendixAI can take statement uploads in PDF, CSV or Excel, let you review rows before saving, and categorise them, while you keep the sheet for anything custom. You can also download CSV from reports and keep a sheet alongside.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports