Creating a Budget Dashboard in Google Sheets

A budget dashboard shows charts, progress bars, and key metrics at a glance - instead of scrolling through transaction lists to understand where your money went.

Skip the setup: The Monthly Budget Template includes a pre-built dashboard ready to use.

What Makes a Good Budget Dashboard

A good budget dashboard combines key elements: summary metrics (total income, spending, savings rate), category breakdown (where money goes), trend visualization (spending patterns over time), progress tracking (goals and limits), and at-a-glance status indicators for quick financial health assessment.

Design principles matter. Most important information goes at the top. Use clear labels and descriptions. Maintain consistent color coding. Minimize clutter. Most importantly, build it to update automatically when data changes.

Dashboard Structure

A recommended layout places the monthly summary (income, spending, savings) at the top. Below that, category spending progress bars on the left and a spending-by-category pie chart on the right. A monthly spending trend line chart comes next, followed by savings goals progress at the bottom.

┌─────────────────────────────────────────┐
│  Monthly Summary (Income/Spend/Savings) │
├─────────────────────────────────────────┤
│  Category Spending     │  Spending by   │
│  Progress Bars         │  Category Pie  │
├─────────────────────────────────────────┤
│  Monthly Spending Trend (Line Chart)    │
├─────────────────────────────────────────┤
│  Savings Goals Progress                 │
└─────────────────────────────────────────┘

Creating Summary Metrics

Key numbers to display include total income (sum of income entries), total spending (sum of expense entries), net (income minus spending), and savings rate (net divided by income). The workhorse here is SUMIF, which adds up amounts that match a single condition. For a deeper walkthrough of these building blocks, see our guide to Google Sheets formulas for budgeting. Here are the formulas:

Total Income: =SUMIF(Transactions!Category,"Income",Transactions!Amount)

Total Spending: =SUMIF(Transactions!Type,"Expense",Transactions!Amount)

Net: =Income-Spending

Savings Rate: =IF(Income>0,(Income-Spending)/Income,0) (format as percentage)

Category Spending Summary

Create a table that pulls spending by category, showing budget, actual, remaining, and percentage used for each category.

The key formula uses SUMIF: =SUMIF(Transactions!Category,A2,Transactions!Amount) where A2 contains the category name. Remaining amount is simply =Budget-Actual. Percentage used is =IF(Budget>0,Actual/Budget,0).

Visual Progress Bars

The Google Sheets SPARKLINE function creates in-cell charts that visually represent progress:

=SPARKLINE(PercentUsed,{"charttype","bar";"max",1;"color1",IF(PercentUsed>1,"red","green")})

This creates a horizontal bar that fills based on percentage spent, shows green when under budget, and red when over budget. An alternative is conditional formatting: select the % Used column, go to Format > Conditional formatting, and apply a color scale from green (low) to red (high).

Spending by Category Chart

To create a pie chart, select category names and amounts, go to Insert > Chart, choose Pie chart, and customize colors and labels. For maximum usefulness, exclude fixed bills if you want to focus on discretionary spending, use consistent category colors across charts, and show percentages or amounts (not both).

Monthly Trend Chart

Create a monthly summary table showing month, income, spending, and net. Use SUMIFS to sum by month against a date range: =SUMIFS(Amount,Type,"Expense",Date,">="&DATE(2026,1,1),Date,"<"&DATE(2026,2,1)). Then select the data, Insert > Chart, choose Line chart, and add multiple series for income and spending.

Savings Goals Progress

Track multiple goals in a table showing goal name, target amount, current balance, and progress percentage.

Add visual progress bars with: =SPARKLINE(Progress,{"charttype","bar";"max",1;"color1","#4285f4"}). Calculate months remaining at current savings pace with: =(Target-Current)/MonthlyContribution. For a standalone version of this section, see how to build a savings goal tracker spreadsheet.

Conditional Formatting for Status

Apply conditional formatting to quickly show status: green for under budget/on track, yellow for approaching limit (80-100%), and red for over budget/behind on goals. For category spending status, use: =IF(Actual/Budget>1,"Over",IF(Actual/Budget>0.8,"Warning","Good")), then format cells based on text values.

Automation Tips

Automation makes dashboards more useful. Filter to current month automatically with: =SUMIFS(Amount,Month,MONTH(TODAY()),Year,YEAR(TODAY())). Use UNIQUE to dynamically list categories: =UNIQUE(Transactions!Category). For complex filtering, QUERY is powerful: =QUERY(Transactions!A:D,"SELECT B, SUM(D) WHERE C='Expense' GROUP BY B").

Sample Dashboard Layout

Rows 1-3 contain header and summary cards (Income, Spending, Savings Rate). Rows 4-12 show category progress with budget, actual, and progress bars. Rows 13-25 hold charts - pie chart on the left, line chart on the right.

Common Dashboard Mistakes

Dashboards summarize - don’t try to show every transaction (too much data). Build formulas that pull from transaction data so updates are automatic. Use consistent number formats, colors, and styles throughout. If you’ll check on your phone, test that the layout works on smaller screens.

Using Existing Templates

Building from scratch takes time. The Monthly Budget Template includes a pre-built dashboard with automated calculations, visual progress tracking, category summaries, and budget-versus-actual comparisons. Starting with a template lets you customize rather than build from zero.

The Summary dashboard in the Premium Monthly Budget Template, with the same summary cards, progress bars, and status indicators this guide builds by hand.

Related

• Monthly Budget Template - Pre-built dashboard
• How to Build a Personal Financial Dashboard in Google Sheets - the broader six-tile version that adds net worth, debt, and investments
• 15 Essential Google Sheets Formulas for Personal Finance - the SUMIF, SUMIFS, and SPARKLINE reference behind these tiles
• Google Sheets Formulas for Budgeting
• Google Sheets vs Excel for Budgeting
• Savings Goal Tracker

---

A budget dashboard turns a wall of transactions into a few numbers you can read at a glance. Build the summary cards and category table first, then layer on the SPARKLINE bars and charts once the data is flowing. If the formulas are the sticking point, the Google Sheets formulas for budgeting guide walks through each one on its own before you wire them into a dashboard.