Personal Finance Dashboard in Google Sheets: Build Yours for Free (2026)

Mint is gone. YNAB costs $109/year. Monarch Money charges $99.99/year. But you don't need any of them. A well-built Google Sheets personal finance dashboard does everything these apps do — and you own it completely. Here's how to build one that actually works.

What Your Dashboard Should Track

The problem with most budgeting apps is they show you data but don't give you understanding. You see that you "overspent on dining" but you don't know if that's a one-time event or a pattern, or how it affects your bigger financial picture.

A personal finance dashboard does more than track transactions. It connects the dots between your monthly budget, your long-term wealth building, and the specific goals you're working toward — all on one screen.

A complete personal finance system tracks:

• Monthly budget — planned spending vs. actual spending by category
• Transaction log — every dollar in and out, categorized
• Net worth — assets minus liabilities, tracked monthly over time
• Savings goals — emergency fund, vacation, down payment, etc.
• Debt payoff — balances, interest rates, payoff timeline
• Spending trends — how your spending patterns change month to month

We'll build all of this across six tabs. None of it requires anything more complex than SUMIF formulas.

The 6-Tab Architecture

Tab 1: Monthly Budget

The budget tab is where you set your spending plan for the month. It compares what you planned to spend against what you actually spent, by category.

Budget Tab Structure

Set up three columns per month: Budgeted, Actual, and Difference. The Actual column pulls from your Transaction Log using SUMIFS. The Difference column is just =Budgeted - Actual.

The SUMIFS formula to pull actual spending for "Groceries" in March 2026 from your Transaction Log:

Conditional Formatting for Budget Status

Make your Difference column visually useful: select the column, go to Format → Conditional Formatting, and set:

• Green background: cell value > 0 (under budget — good)
• Yellow background: cell value between -50 and 0 (slightly over)
• Red background: cell value < -50 (significantly over budget)

Now your budget tab tells you the story instantly without reading numbers.

Tab 2: Transaction Log

Your transaction log is the raw data behind everything else. Every purchase, payment, and income deposit goes here.

How to Import Bank Transactions

Most banks let you export transactions as a CSV file. Download it, open it in Google Sheets, and copy-paste into your Transaction Log. You'll need to map the bank's columns to yours and add the Category column manually — that's the part you can't automate easily without a paid app. Budget about 10-15 minutes per week to categorize transactions.

Tab 3: Net Worth Tracker

Net worth is your most important single financial number. Assets minus liabilities. Track it monthly and you'll see whether you're actually making progress — regardless of what any one month's budget looks like.

Assets to Track

• Checking accounts (current balance)
• Savings accounts
• Brokerage / investment accounts
• 401(k) / IRA / retirement accounts
• Home value (use Zillow estimate or purchase price)
• Vehicle value (use KBB private party value)
• Other assets (business equity, rental property, etc.)

Liabilities to Track

• Mortgage balance
• Auto loan balance
• Student loan balance
• Credit card balances (sum of all cards)
• Personal loans
• Other debt

The structure: rows are asset/liability categories, columns are months. The last row is your net worth formula: =SUM(Assets) - SUM(Liabilities). Update the balances once a month — first of the month or last Sunday of the month, whichever you'll stick to.

After 12 months, you'll have a chart showing your net worth trajectory. That line going up is the most motivating thing in personal finance.

Tab 4: Savings Goals

Savings goals keep you from spending money you've mentally allocated somewhere. Each goal gets its own row.

The Monthly Needed Formula

For each goal, calculate how much you need to save per month to hit the target:

This formula updates automatically every month, so as you save more or as the deadline approaches, the required monthly contribution adjusts. No manual updates needed.

Progress Bars with Formulas

You can create a visual progress bar in Google Sheets using the REPT function:

This displays a block-filled bar followed by the percentage. It's a simple visual trick but surprisingly satisfying when goals start filling up.

Tab 5: Debt Payoff Tracker

If you have debt, this tab is where you manage payoff strategy. It calculates payoff timelines so you can compare the debt avalanche (highest interest first) vs. debt snowball (lowest balance first) methods.

Debt Tracker Columns

Months to Payoff Formula

Example: A $4,200 balance at 22.49% APR with $300/month payments:

Returns approximately 16.3 months — you'd be debt-free in under 17 months.

Debt Avalanche vs. Snowball

Avalanche (mathematically optimal): Pay minimums on all debts. Put every extra dollar toward the highest-interest debt first.

Snowball (psychologically effective): Pay minimums on all debts. Put every extra dollar toward the lowest balance first. Generates quick wins that keep you motivated.

The avalanche saves more money. The snowball gets more people to stick with it. Pick the one you'll actually follow.

Tab 6: The Dashboard

The dashboard is your command center. It pulls summary numbers from every other tab and presents them at a glance. You should be able to open this tab and understand your entire financial situation in 30 seconds.

What the Dashboard Shows

• This Month: Budget vs. actual (single number — over or under, by how much)
• Net Worth: Current balance + change from last month
• Savings Goals: Top 3 goals with progress percentages
• Debt: Total balance remaining + months to debt-free date
• Spending this month: Mini breakdown by top 5 categories
• Income this month: Total received vs. same month last year

Dashboard Formula Examples

All these formulas reference your other tabs. Keep them simple:

• Current net worth: =NetWorth!B[last row]
• Net worth change: =NetWorth!B[last row] - NetWorth!B[second to last row]
• Total remaining debt: =SUM(DebtTracker!B2:B20)
• This month budget surplus/deficit: =SUM(Budget!D2:D50)

Adding Charts That Actually Inform

Charts in a personal finance dashboard aren't decoration — they reveal patterns that numbers alone hide. Add these four:

1. Net Worth Over Time (Line Chart)

Source: Net Worth tab, monthly totals. This is the only chart that matters for your long-term financial health. Watch the line trend upward over 12–24 months.

2. Spending by Category (Pie or Bar Chart)

Source: Monthly Budget tab, actual spending by category. Use a bar chart (horizontal) if you have more than 6 categories — it's easier to read than a cramped pie chart.

3. Income vs. Expenses (Bar Chart, Monthly)

Source: Transaction Log, filtered by month. Two bars per month — income and total expenses. The gap between them is your savings rate. Make the gap bigger over time.

4. Debt Balance Over Time (Line Chart)

Source: Debt Tracker, monthly balance totals. Watching this line decline is genuinely motivating. Update it monthly as you make payments.

The Monthly Review Routine

The spreadsheet only works if you use it. Here's the monthly routine that takes 30–45 minutes and keeps your finances under control:

That's it. 30–45 minutes per month is what full financial clarity costs. Most people spend more time scrolling Netflix deciding what to watch.

Spending Categories That Work

The category list that works for most households — granular enough to be useful, simple enough to not be a burden:

Related Guides

• Net Worth Tracker in Google Sheets
• Savings Goal Tracker in Google Sheets
• Debt Snowball vs. Avalanche — Google Sheets Calculator
• Budget by Paycheck in Google Sheets
• Freelance Income & Expense Tracker