How to Automate Your Budget in Google Sheets with SUMIFS (No Add-ons)

Most people quit budgeting in week two — not because they lack discipline, but because their spreadsheet asks them to do math every time they look at it. The fix is to stop calculating and start automating: log a transaction, and let formulas categorize it, total it, and flag it when a category goes over budget.

This guide shows the exact automation layer we build into our Personal Finance Dashboard, using only built-in Google Sheets functions. No add-ons, no scripts.

What “automated” actually means here

Three things happen without you touching a formula:

Every transaction gets a total — spending per category per month updates itself.
Budget vs. actual compares itself — you see “over budget” before you overspend.
The dashboard redraws itself — charts and KPIs recalculate on every new row.

The only manual step left is entering the transaction. That’s the point.

Step 1 — Build the Transactions sheet (the only tab you touch)

Create a sheet called Transactions with these columns:

A	B	C	D	E
Date	Description	Category	Amount	Type

Then add dropdowns so logging is two clicks:

Select column C → Data → Data validation → add your categories (Housing, Groceries, Dining, Transport, Utilities, Health, Entertainment, Shopping, Subscriptions, Other).
Select column E → Data → Data validation → Income, Expense.

Now every row is machine-readable. A sample row: 2026-10-14 | Blue Bottle | Dining | 6.75 | Expense.

Step 2 — The SUMIFS formula that runs everything

On a new sheet called Budget, list your categories in column A and your monthly budget in column B. In column C (“Spent this month”), paste:

=SUMIFS(Transactions!$D:$D,
        Transactions!$C:$C, $A2,
        Transactions!$E:$E, "Expense",
        Transactions!$A:$A, ">="&EOMONTH(TODAY(),-1)+1,
        Transactions!$A:$A, "<="&EOMONTH(TODAY(),0))

Read it like a sentence: sum the Amount column, where the Category matches this row, where Type is Expense, and where the Date falls inside the current month. EOMONTH(TODAY(),-1)+1 is the first day of this month; EOMONTH(TODAY(),0) is the last. The formula follows the calendar forever — you never update it.

Income works the same way — just change "Expense" to "Income":

=SUMIFS(Transactions!$D:$D,
        Transactions!$E:$E, "Income",
        Transactions!$A:$A, ">="&EOMONTH(TODAY(),-1)+1,
        Transactions!$A:$A, "<="&EOMONTH(TODAY(),0))

Step 3 — Budget vs. actual, with automatic warnings

Still on the Budget sheet, add three more columns:

Remaining: =B2-C2
% used: =IFERROR(C2/B2,0) (format as percent)
Status: =IF(C2>B2,"Over budget",IF(E2>0.8,"Close to limit","On track"))

Then make the numbers impossible to ignore:

Select the % used column → Format → Conditional formatting.
Add a rule: Greater than 1 → red fill.
Add a rule: Between 0.8 and 1 → amber fill.
Add a rule: Less than 0.8 → green fill.

Now your budget tells you where you stand without you reading a single number.

Step 4 — A 12-month trend that draws itself

On a new sheet, build a 12-row table: month label, income, expenses, net. The income cell for “three months ago” is:

=SUMIFS(Transactions!$D:$D,
        Transactions!$E:$E, "Income",
        Transactions!$A:$A, ">="&DATE(YEAR(EDATE(TODAY(),-3)),MONTH(EDATE(TODAY(),-3)),1),
        Transactions!$A:$A, "<="&EOMONTH(EDATE(TODAY(),-3),0))

Drag that pattern across 12 rows, select the table → Insert → Chart → Line chart. You now have a trend chart that grows on its own — no monthly copy-paste.

Step 5 — The dashboard

Create a Dashboard sheet with four big numbers that reference the sheets above:

Income this month: the income SUMIFS above
Spent this month: the expense SUMIFS above
Net saved: =income - spent
Savings rate: =IFERROR((income-spent)/income, 0)

Put the line chart and a pie chart (spending by category) next to them, and you have a one-page dashboard that answers “where is my money going?” in three seconds.

The two mistakes that break automation

Mistake 1: typing categories instead of picking them. “Dining out” and “Dining” are two categories to SUMIFS. Always use the dropdown.

Mistake 2: mixing income and expenses in one column. Keep Type as a separate column — it’s what lets one formula serve both income and expense reports.

Skip the build — start from a working version

The structure above — SUMIFS engine, dropdowns, conditional formatting, trend chart, savings goals, dashboard — is exactly what our Personal Finance Dashboard ships with, pre-built and tested in both Google Sheets and Excel. It takes about 10 minutes to make it yours, versus an afternoon of formula debugging.

Automate the comparison, not the logging. The spreadsheet’s job is to tell you the truth fast — your job is only to record what happened.

Related reading: