# Budget vs Actual Report in Google Sheets: Category Variance

- URL: https://betteranalyst.com/data-connectors/google-sheets/budget-vs-actual
- Published: 2026-10-28
- Updated: 2026-10-28
- Author: David Bressler, Founder (https://betteranalyst.com/authors/david-bressler)

> **Summary:** A budget vs actual report compares what you planned to spend or earn with what happened, by category and month, and shows the variance in dollars and percent. If your budget and transactions already live in Google Sheets, Better Analyst can match the two tabs, calculate variances and year-to-date totals, and explain the biggest gaps.

Data source: [Google Sheets](https://betteranalyst.com/data-connectors/google-sheets)

Build a budget vs actual report from Google Sheets tabs: monthly variance in dollars and percent by category, year-to-date totals, and what to flag.

## Who this report is for

Small-business owners, finance leads and department heads who keep the budget in one Google Sheet tab and actual spending in another and want a monthly variance review without rebuilding SUMIFS each month.

## What the report includes

*Metrics and dimensions in this report*

| Metric | Source field | Why it matters |
| --- | --- | --- |
| Budget | Budget tab: Month, Category, Budget columns (your headers) | The plan for each category and month. |
| Actual | Actuals tab: Date, Category, Amount columns (your headers) | Transactions summed by category and month to compare with the plan. |
| Variance ($) | Calculated: Actual − Budget | The size of each gap in currency, which decides what is worth discussing. |
| Variance (%) | Calculated: (Actual − Budget) ÷ Budget | Puts small and large categories on the same scale. |
| Year-to-date variance | Calculated: cumulative Actual − cumulative Budget | Separates one-off monthly timing differences from a real overspend. |

## How to build it in Better Analyst from Google Sheets

1. Share the Google Sheet with sheets@betteranalyst.com. Viewer access is enough; the connector never edits your sheet.
2. In Better Analyst, open Connectors, choose Google Sheets, paste the sheet URL and click Connect. Better Analyst checks the sharing, reads the tabs and syncs the data.
3. Make sure both tabs use the same category names and that the budget has one row per category per month; Better Analyst can also map near-matching names if you ask.
4. Ask for monthly and year-to-date variance by category, flagging anything more than 10% and $1,000 over budget.

## Questions to ask

- “Compare actual spending to budget by category for September and year to date.”
- “Which categories are more than 10% over budget year to date?”
- “Explain the three largest variances this month using the transaction descriptions.”
- “Forecast full-year spend by category at the current run rate.”

## Sample output

Sample data for illustration, not real account data.

*Sample data: September budget vs actual (illustrative)*

| Category | Budget | Actual | Variance $ | Variance % | YTD variance % |
| --- | --- | --- | --- | --- | --- |
| Payroll | $84,000 | $86,100 | $2,100 | 2.5% | 1.1% |
| Software | $6,500 | $8,320 | $1,820 | 28.0% | 19.4% |
| Advertising | $18,000 | $15,400 | -$2,600 | -14.4% | -6.2% |
| Travel | $3,000 | $4,950 | $1,950 | 65.0% | 12.8% |

## Charts to use

- **Variance by category** (Diverging bar chart): Over- and under-budget categories on either side of zero, sorted by size.
- **Cumulative budget vs actual** (Line chart): Year-to-date budget and actual lines, so persistent overspend stands out from timing.

## Keep it up to date

Schedule the variance review for the 5th of each month, after the books close, and deliver it by email. If you'd rather keep everything in Sheets, a Data Flow can write the variance table back to a new tab in the same spreadsheet on a schedule.

## Further reading

- [Budget vs actual report in Excel](https://betteranalyst.com/blog/how-to-build-a-budget-vs-actual-report-in-excel)
- [Chart budget variance](https://betteranalyst.com/blog/how-to-show-budget-variance-in-an-excel-chart)
- [Google Sheets connector](https://betteranalyst.com/data-connectors/google-sheets)
- [SUMIFS in Google Sheets](https://betteranalyst.com/google-sheets/sumifs-function)
- [Better Analyst for finance teams](https://betteranalyst.com/solutions/finance)

[Try Better Analyst free](https://betteranalyst.com/signup)

## Frequently asked questions

### How do I calculate budget variance?

Variance = Actual − Budget. For costs, a positive number is an overspend; for revenue, a positive number is good. Variance % = (Actual − Budget) ÷ Budget.

### What variance is worth investigating?

Set a threshold that combines percent and amount, for example over 10% and over $1,000, so a 50% overspend on a $40 line doesn't crowd out a 4% overspend on payroll.

### Can I do this with SUMIFS instead?

Yes: =SUMIFS(Actuals!C:C, Actuals!B:B, A2, Actuals!A:A, ">="&start, Actuals!A:A, "<="&end) sums actuals per category and month. Better Analyst writes and runs the equivalent for every category and month at once.