How to Create a Personal Finance Dashboard in Google Sheets

Tracking your money doesn't have to mean paying for a fancy budgeting app with features you’ll never use. A personalized financial dashboard in Google Sheets gives you complete control, flexibility, and a crystal-clear view of where your money is going. This guide will walk you through building a simple yet powerful personal finance dashboard from scratch, no advanced spreadsheet wizardry required.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Choose Your Weapon: Why Google Sheets?

While slick budgeting apps are popular, there’s a strong case for the humble spreadsheet, especially Google Sheets. Unlike desktop software, it's cloud-based, meaning you can access and update your budget from any device, anywhere. It's also completely free and surprisingly powerful.

Building your own dashboard offers several key advantages:

• Total Customization: Track exactly what matters to you. Want to monitor your "Coffee" category or see your savings rate for a specific goal? You're in control.
• No Subscriptions: It's 100% free. You won’t get nudged to upgrade to a premium plan to unlock essential features.
• Deeper Understanding: The process of building the dashboard itself forces you to engage with your finances on a deeper level. You’re not just a user, you’re the architect of your own financial system.

Step 1: Laying the Foundation (Setting Up Your Tabs)

Organization is the key to a stress-free dashboard. We’ll start by creating three essential tabs (or "sheets") in our Google spreadsheet. Open a new Google Sheet and rename the default tabs at the bottom of the screen.

Here’s the structure you’ll need:

1. Transactions: This will be the heart of your system. You'll log every single income and expense transaction here. It’s your financial ledger.
2. Categories: A simple reference sheet to list all your spending and income categories. This keeps your data clean and organized.
3. Dashboard: This is where the magic happens! We'll pull data from the other tabs to create summary metrics and visual charts, giving you a quick overview of your financial health.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 2: Track Everything in the 'Transactions' Sheet

The 'Transactions' sheet is where your raw data lives. It requires consistency, but it’s the engine that powers your entire dashboard. Start by creating the following column headers in row 1:

• Column A: Date
• Column B: Description (e.g., "Grocery Store," "Paycheck," "Netflix Subscription")
• Column C: Category
• Column D: Amount (the dollar value)
• Column E: Type (Income or Expense)

Your sheet should look like a simple table. Before you start logging expenses, let's make it smarter.

Pro Tip: Use Dropdown Menus for Categories

To avoid typos and keep your categories consistent (e.g., "Food" vs. "food"), we'll create a dropdown menu in the Category column. This is a game-changer for data accuracy.

1. First, go to your 'Categories' tab. In Column A, list all your expense categories (e.g., Rent, Groceries, Utilities, Gas, Entertainment). In Column B, list your income categories (e.g., Paycheck, Freelance, Side Business).
2. Now, go back to the 'Transactions' sheet. Click on cell C2 (the first cell under your 'Category' header).
3. From the menu, navigate to Data > Data validation.
4. In the Data validation window:
5. Finally, click on cell C2 again, and copy-paste it or drag the little blue square at the bottom-right corner of the cell down the entire column.

Now, every cell in your 'Category' column will have a neat dropdown menu, preventing mistakes and making transaction logging much faster.

Step 3: Calculating Key Metrics on the 'Dashboard' Sheet

With your transaction log set up, it’s time to move to the 'Dashboard' tab and calculate some high-level numbers. This is where you get a quick snapshot of your financial health for any given period.

Let's set up a small area in your dashboard to show Total Income, Total Expenses, and Net Savings.

Formula for Total Income

Find a cell in your dashboard, label it "Total Income," and in the cell next to it, enter this formula:

=SUMIF(Transactions!E:E, "Income", Transactions!D:D)

Let’s break it down:

• SUMIF tells Google Sheets to add numbers together only if they meet a certain condition.
• Transactions!E:E is the range anywhere in Column E of our "Transactions" sheet (the 'Type' column).
• "Income" is the condition. We're telling it to look for the word "Income."
• Transactions!D:D is the sum range where all of the 'Amounts' live. If a row in the range meets our condition, it will be added to the total.

Formula for Total Expenses

Similarly, for "Total Expenses," use this formula. It’s almost identical, but it looks for the word "Expense" instead:

=SUMIF(Transactions!E:E, "Expense", Transactions!D:D)

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Calculating Net Savings & Savings Rate

These are simple calculations that don't need complex formulas.

• Net Savings: Simply subtract your Total Expenses cell from your Total Income cell. If your Total Income is in B2 and Total Expenses is in B3, the formula is =B2-B3.
• Savings Rate: Divide your Net Savings by your Total Income and format the cell as a percentage. Using the same cells as above, the formula would be =(B2-B3)/B2. Remember to click the '%' icon in the toolbar!

Step 4: Visualize Your Data with Charts

Numbers are great, but charts tell a story. Let's create two essential visuals for your dashboard: an expense breakdown and an income vs. expense trend over time.

Create an Expense Breakdown Pie Chart

To see where your money really goes, a pie chart is perfect. We first need to summarize your spending by category.

1. Go to your 'Transactions' sheet. Select all your data (from 'Date' down to your last transaction).
2. From the menu, go to Insert > Pivot table.
3. A new dialog will pop up. Choose "New sheet" and click "Create."
4. A new "Pivot table" sheet will appear. In the Pivot table editor on the right:

You now have a clean summary table of exactly how much you spent in each category. Let’s move this data into our Dashboard.

1. Insert the chart: Go to your pivot table and select just the Category name plus their monthly spend.
2. From the menu, go to Insert > Chart.
3. Google Sheets will likely suggest a Pie chart, but if not, you can select it from the 'Chart type' dropdown in the Chart editor.
4. Use the drag handles on the chart, cut-and-paste to move to your Dashboard sheet, and customize its appearance - change titles, colors, and labels to make it clear and readable. Add a title like "Expense Breakdown."

Creating an Income vs. Expense Trend Chart For the Year

This chart will help you see if you're making progress month-over-month. For that, you’ll need to add a "month" column to your 'Transactions' tab.

1. Go to your transaction spreadsheet, right-click the Date (A) column header, and click 'Insert 1 column right.'
2. In B1, add 'Year-Month' header text.
3. Next, in cell B2, put the following Array Formula and it should create a month row value for you automatically:

=ARRAYFORMULA(IF(ISBLANK(A2:A), "", TEXT(A2:A, "YYYY-MM")))

Now we do more or less the same for the pivot table except with slightly different settings:

You now have a clean monthly summary of your Income vs. Expenses per month that will automatically update every month to bring your dashboard and business to life.

1. Setup Pivot Table: First, insert a new pivot onto a new sheet from our updated 'Transactions' page from the top menu bar 'Insert > Pivot Table'.
2. Adjust Settings: In your 'Pivot table editor' sidebar, under 'Rows', add your new 'Year-Month' column. Under 'Columns', select your 'Type' (income/expenses) column from the dropdown. Lastly, under 'Values', select Amount to add them up. Voila! You’ve completed your data!

Create the Income/Expenses Line Chart

1. Staying right where you are, select the 'Months' and both the Expenses and Income total, and click from the top menu bar 'Insert > Chart'. This data usually creates a 'Line chart' automatically, and select this option if not.
2. Use the three-circle dropdown, copy your finished chart, and take it back to your 'Dashboard' tab, then customize it how you like with a descriptive title so you can always gain insights at just a quick glance. I prefer "Monthly Financial Summary."

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 5: Make Your Dashboard Interactive

A static dashboard is good, but an interactive one is even better. We can add a "Slicer" to filter your dashboard by month, allowing you to see your financial snapshot for any period instantly.

1. Go to your Dashboard tab.
2. Navigate on the header menu to 'Data > Add a Slicer'.
3. In the slicer sidebar, select your new "Year / Month" column as the 'Data Range' and then click on your Pivot Table chart that shows your monthly spending and do the exact same.

You can see your monthly finances, but you must reset the data for a full picture.

Remember to reset and unfilter all the checkboxes in your slicers after reviewing past performance, or you will show old information until new transactions are added, and you might worry there are missing funds unnecessarily.

Final Thoughts

Creating your own personal finance dashboard in Google Sheets puts you firmly in control of your financial journey. You now have a custom-built system that tracks exactly what you want, helps you visualize your progress, and empowers you to make smarter decisions about your money.

While DIYing it in Google Sheets is incredibly rewarding, staying consistent with manual data entry can become a significant chore over time. At Graphed we built a tool to eliminate that busywork entirely. Our platform allows you to securely connect your various data from different marketing and analytics, and popular business apps, allowing you the power to instantly create custom real-time dashboards and reports simply by asking questions in plain English. No more CSV downloads, no messy pivot tables - just clear answers about your business and finances in seconds.