10 Google Sheets Formulas Every Budget Spreadsheet Needs (With Examples)

Building a budget spreadsheet from scratch? You don't need complex macros or paid tools—Google Sheets has a built-in formula toolkit powerful enough to automate expense tracking, generate spending reports, and monitor your net worth. Here are the 10 formulas every budget spreadsheet needs, ready to copy and paste.

TL;DR: Use SUMIFS to total expenses by category and month, QUERY to build dynamic spending reports, SPARKLINE to visualize progress, GOOGLEFINANCE for net worth updates, and IF/ARRAYFORMULA to automate categorization. Each formula is copy-paste ready with examples below.

What is SUMIFS and how do I use it to track spending by category?

SUMIFS sums a range of values based on multiple criteria—exactly what you need to answer "How much did I spend on groceries this month?"

Formula:

=SUMIFS(amount_range, category_range, "Groceries", date_range, ">="&DATE(2026,6,1), date_range, "<"&DATE(2026,7,1))

In a real budget sheet where Column A = Date, Column B = Category, Column C = Amount:

=SUMIFS(C:C, B:B, "Groceries", A:A, ">="&DATE(2026,6,1), A:A, "<"&DATE(2026,7,1))

This sums all amounts in Column C where the category is "Groceries" AND the date falls in June 2026. Change the dates and category names to match your sheet. You'll use this formula dozens of times—once per category, once per month—to build your budget dashboard.

How do I create a dynamic spending report with QUERY?

QUERY lets you write database-like statements in Google Sheets. Instead of manually filtering rows, QUERY does it for you and updates automatically.

Formula:

=QUERY(A:C, "select B, sum(C) where A >= date '"&TEXT(DATE(2026,6,1),"yyyy-mm-dd")&"' group by B label sum(C) 'Total'")

This pulls data from columns A (date), B (category), C (amount) and groups spending by category for any date on or after June 1, 2026. Every transaction you add updates the report instantly. Use QUERY when you want a filterable, sortable summary without manual work.

What does SPARKLINE do for budget tracking?

SPARKLINE embeds a tiny chart inside a cell—perfect for visualizing if you're on track with category budgets.

Formula:

=SPARKLINE(A1:A12, {"charttype", "column"; "max", 500})

If A1:A12 contains your weekly grocery spending (say, $45, $62, $38...), this creates a mini bar chart capped at $500. Glance at your budget dashboard and instantly see if spending is trending up or down. Pair it with conditional formatting to flag overspending.

How do I track net worth with GOOGLEFINANCE?

GOOGLEFINANCE fetches live stock, crypto, and currency prices. If you own index funds or hold crypto, use this to auto-update your net worth.

Formula:

=GOOGLEFINANCE("TICKER", "price")

Example for S&P 500 ETF (SPY):

=GOOGLEFINANCE("NASDAQ:SPY", "price")

For crypto (Bitcoin):

=GOOGLEFINANCE("CURRENCY:BTCUSD")

Store these prices in a column, multiply by quantity (shares or coins), and sum the total. Your net worth updates every 15 minutes during market hours without manual work.

How do I calculate my budget variance (actual vs. planned)?

Variance tells you how far off-track you are. Use a simple IF formula to flag when actual spending exceeds your plan.

Formula:

=IF(actual_amount > budget_amount, actual_amount - budget_amount, 0)

Or, to show variance as a percentage:

=IF(actual_amount > 0, (actual_amount - budget_amount) / budget_amount, 0)

If your grocery budget is $400 but you spent $450, this shows +$50 overage (or +12.5%). Use conditional formatting to color overspending red and under-budget spending green.

Can I automate category assignment with ARRAYFORMULA?

Yes. If you have a transaction list with amounts and descriptions, use ARRAYFORMULA with nested IFs to auto-categorize.

Formula:

=ARRAYFORMULA(IF(A2:A="","",IF(ISNUMBER(SEARCH("amazon",A2:A)),"Shopping",IF(ISNUMBER(SEARCH("whole foods",A2:A)),"Groceries","Other"))))

This scans column A (transaction descriptions) and assigns "Shopping" if it contains "amazon", "Groceries" if it contains "whole foods", and "Other" as default. Adjust keywords and categories to match your spending habits. This saves hours of manual categorization each month.

How do I calculate running totals (cumulative spending)?

Running totals show your cumulative spend month-to-date or year-to-date—helpful for staying aware of how quickly money flows out.

Formula:

=SUM($C$2:C2)

Placed in row 2 and dragged down, this sums from C2 to the current row. Each row shows cumulative total, so you can see at a glance if you're $1,000 or $5,000 into your monthly budget by mid-month.

How do I compare this year to last year with INDEX and MATCH?

If you're building a year-over-year budget comparison, use INDEX/MATCH to pull corresponding periods from last year.

Formula:

=IFERROR(INDEX(last_year_range, MATCH(this_month, last_year_dates, 0)), "No data")

This finds the same month in your last year's data and pulls the total, letting you compare "June 2025 spending vs. June 2026 spending" side by side. Perfect for spotting trends.

What's the best way to calculate sinking fund progress?

Sinking funds (separate savings buckets for future expenses like insurance, holidays, or car maintenance) need progress tracking. Use SPARKLINE + a percentage bar.

Formula (for progress percentage):

=current_sinking_fund_balance / sinking_fund_goal

Formula (for formatted progress bar):

=REPT("▓", ROUND(current_balance / goal * 20, 0)) & REPT("░", 20 - ROUND(current_balance / goal * 20, 0))

This creates a visual bar (■■■■■░░░░░) showing 25% progress, for example. Pair with our sinking funds tracker guide for a complete system.

How do I get monthly budget summaries without manually updating?

Use a dashboard that pulls data from your transaction log. Combine SUMIFS (by category and month) with a simple date selector.

For a given month, sum all "Dining" expenses:

=SUMIFS(transactions!C:C, transactions!B:B, "Dining", transactions!A:A, ">="&DATE(2026,6,1), transactions!A:A, "<"&DATE(2026,7,1))

Once you set this up for each category and each month, your dashboard updates automatically every time you add a transaction. No more manual monthly reconciliation.

How do I know if my budget spreadsheet is working?

A budget that isn't reviewed is just data entry. Use these formulas to build a one-page dashboard you actually check weekly:

• Top row: Year-to-date spending by major category (SUMIFS)
• Chart: Monthly trend (SPARKLINE)
• Alert row: Categories over budget (IF + variance)
• Net worth widget: Updated prices (GOOGLEFINANCE) + totals

If you're spending 30+ minutes a month on spreadsheet updates, you've overcomplicated it. The formulas above should get you to 10 minutes. For ready-made templates, check out SheetFolk's budget spreadsheet library—every formula is pre-built and copy-paste ready.

Set up your budget spreadsheet the right way

The formulas above work best when your data is organized consistently: dates in one column, categories in another, amounts in a third. If you're building from scratch, follow our guide to making a budget spreadsheet in Google Sheets to set up the structure correctly.

For tracking personal finances beyond budgeting, build a personal finance tracker to include investments, debt, and net worth in the same system.

Also check out SpendCull if you want to add receipt scanning and automated expense categorization to your budget workflow.

Disclaimer: This post provides informational guidance on spreadsheet formulas for budget tracking. It is not financial advice. Please verify all calculations and consult with a financial advisor before making major financial decisions. Budget spreadsheets are tools for tracking, not guarantees of financial outcomes.