How to Make a Money Tracker in Google Sheets

Tracking your money shouldn’t feel like a chore, but cluttered apps and expensive software often make it one. Creating your own money tracker in Google Sheets puts you in complete control, allowing you to build a system perfectly tailored to your financial goals - for free. This tutorial will guide you step-by-step through building a powerful, automated money tracker, from creating your first transaction log to generating insightful charts and a live dashboard.

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

How to Set Up Your Financial Hub in Google Sheets

The foundation of any good tracker is a clean, organized space to log your data. A well-structured sheet makes it easier to add formulas and visualizations later on. Let’s start with a blank canvas and build it from the ground up.

Step 1: Create a New Sheet and Define Your Columns

First, open Google Sheets and create a new blank spreadsheet. Give it a clear name like "My 2024 Money Tracker." It's best practice to rename the first tab at the bottom from "Sheet1" to "Transactions." This will be where you log every single income and expense item.

Now, set up your headers in the first row. A solid starting point includes these five columns:

• A1: Date - The date the transaction occurred. Keeping your sheet sorted by this column helps maintain a clear chronological history.
• B1: Category - What kind of transaction is it? (e.g., Groceries, Rent, Salary). This is the most important column for analysis purposes.
• C1: Description - A brief note for context. This could be "Weekly shopping" for a grocery expense or "Client Project X" for an income item.
• D1: Income ($) - For any money coming in. Leave this blank if it's an expense.
• E1: Expense ($) - For any money going out. Leave this blank if it's income.

Separating Income and Expense into their own columns makes writing formulas for totals much simpler than using a single "Amount" column with positive and negative numbers.

Step 2: Use Data Validation for Consistent Categories

Inconsistent data is the biggest enemy of accurate reporting. One month you might log "Groceries," the next "Supermarket," and the one after just "Food." This makes it impossible to accurately total your spending for that category. We can solve this permanently with Data Validation, which creates a dropdown list of pre-set categories.

Create Your Category List:

1. Click the "+" icon in the bottom-left corner to add a new sheet. Rename it to "Categories."
2. In column A, list all your typical expense categories (e.g., Rent/Mortgage, Groceries, Utilities, Gas, Dining Out, Entertainment, Subscriptions).
3. In column B, list your income sources (e.g., Salary, Freelance, Side Hustle, Interest).

Apply the Dropdown to Your Transactions Sheet:

1. Go back to your "Transactions" tab.
2. Click on the header for Column B to select the entire column.
3. In the menu, go to Data > Data validation.
4. A sidebar will appear. Click "+ Add rule."
5. Under "Criteria," select "Dropdown (from a range)."
6. Click the grid icon to select your data range. Navigate to your "Categories" sheet and select all your expense and income categories (e.g., Categories!A:B). Click OK.
7. Under "Advanced options," change the display style to "Arrow" for a cleaner look and ensure "Show a warning for invalid data" is selected (or "Reject input" for stricter control).
8. Click "Done."

Now, when you click on any cell in the Category column, a dropdown arrow will appear, letting you select from your standardized list. This single step will save you massive headaches later.

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

Automate Your Tracker with Essential Formulas

This is where your static spreadsheet evolves into a dynamic, automated tool. Formulas will automatically calculate your running balance, total your spending, and power your dashboard without you having to touch a calculator.

Calculating Your Running Balance

A running balance shows you your financial health after every transaction. Let's add a Balance column to see your total change over time.

1. Go to your "Transactions" sheet and type "Balance ($)" in cell F1.
2. If you're starting from scratch, the balance for your first transaction is just Income minus Expense. In cell F2, enter this formula:

`=D2-E2`

1. For the next row (cell F3), you need to take the previous balance and add the new income and subtract the new expense. The formula is:

`=F2+D3-E3`

You can now click the small blue square (the fill handle) on the bottom-right of cell F3 and drag it down. The formula will automatically adjust for each row. While this works, a more advanced formula can do this automatically for the entire column, so you don't have to drag it down every time you add a new entry.

The Advanced (Set-It-and-Forget-It) Method

For a hands-off approach, you can use a single ARRAYFORMULA. This powerful function applies a calculation to an entire range of cells. Delete all the individual formulas in your Balance column (F) and enter this single formula into cell F2:

`=ARRAYFORMULA(IF(A2:A<>"", SUMIF(ROW(A2:A), "<="&ROW(A2:A), D2:D) - SUMIF(ROW(A2:A), "<="&ROW(A2:A), E2:E), ""))`

This looks intimidating, but here's a brief breakdown: SUMIF(ROW(A2:A), "<="&ROW(A2:A), ...) cleverly calculates a running total for the Income and Expense columns down to the current row. The IF(A2:A<>""... part ensures the formula only runs if there's a date in Column A, keeping your sheet clean.

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

Building Your Master Financial Dashboard

A Dashboard gives you a high-level, snapshot view of your financial health. Add another sheet by clicking the "+" icon and rename it "Dashboard." This is where we'll summarize all the data from your "Transactions" log.

Step 1: Calculate Your Key Metrics

Set up some simple labels for your main metrics. For example:

• In A1: Total Income
• In A2: Total Expenses
• In A3: Net Savings

Now, let's use the SUM function to pull the data from our "Transactions" sheet.

• In cell B1 (next to Total Income), enter:

`=SUM(Transactions!D:D)`

• In cell B2 (next to Total Expenses), enter:

`=SUM(Transactions!E:E)`

• In cell B3 (next to Net Savings), simply subtract your expenses from your income:

`=B1-B2`

Just like that, you have a live summary. Every time you add a new transaction, these totals will automatically update.

Step 2: See Where Your Money is Going: A Category Breakdown

This is arguably the most useful part of a money tracker. Here, we'll use the SUMIF function to total expenses for each category.

1. On your "Dashboard" sheet, find a clear space (e.g., column D) and add a header like "Expenses by Category."
2. In the cells below (D2, D3, etc.), list out the exact same expense categories you created in your "Categories" sheet. You can copy and paste them to avoid typos.
3. Next to your first category (in cell E2), enter this SUMIF formula:

`=SUMIF(Transactions!B:B, D2, Transactions!E:E)`

Let's quickly break this down:

• Transactions!B:B is the range where your categories are located (your criteria range).
• D2 is the specific category we're looking for on the dashboard (your criterion, e.g., "Groceries").
• Transactions!E:E is the range of numbers you want to add up if the criterion is met (your sum range).

Now, just like with the simple balance formula, click the fill handle on the bottom-right of cell E2 and drag the formula down for all your categories. It will automatically update to look for the category in each corresponding row.

Visualize Your Finances with Charts and Graphs

Numbers and tables are great for detail, but charts are great for instantly understanding trends and proportions. Google Sheets makes turning your summary data into visuals simple.

Create a "Spending by Category" Pie Chart

A pie chart is perfect for showing what percentage of your spending goes to each category.

1. On your "Dashboard" sheet, select the data you just created in your "Expenses by Category" table - both the category names and their totals.
2. Go to the main menu and click Insert > Chart.
3. Google Sheets is smart and will often default to a pie chart, which is what we want. If it doesn't, you can select "Pie chart" from the Chart Type dropdown in the Chart Editor sidebar.
4. Use the "Customize" tab in the editor to change colors, add labels, and give your chart a title.

This chart gives you an immediate visual answer to the question, "Where does my money actually go?"

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

Build a Monthly "Income vs. Expense" Bar Chart

To see your cash flow over time, comparing monthly income to expenses is incredibly valuable. This requires one small addition to our "Transactions" sheet.

1. Add a 'Month' Helper Column: Go to your "Transactions" tab, and in cell G1, add the header "Month." In cell G2, enter this formula to automatically extract the month and year from your date column:

`=ARRAYFORMULA(IF(A2:A<>"",TEXT(A2:A, "MMM YYYY"),""))`

This formula will automatically fill the month for every row with a date.

1. Create a Monthly Summary Table on the Dashboard: On your dashboard, you first need a list of the unique months. Find a free space and use the UNIQUE formula:

`=UNIQUE(Transactions!G2:G)`

It will create a list of all the months present in your log.

1. Calculate Totals with SUMIFS: Now that you have your list of months (let's say it starts in cell G2 on your dashboard), add "Income" and "Expense" headers next to it.

• For income, use:

`=SUMIFS(Transactions!D:D, Transactions!G:G, G2)`

• For expense, use:

`=SUMIFS(Transactions!E:E, Transactions!G:G, G2)`

Drag both formulas down for all your months.

1. Create the Chart: Now, select your complete monthly summary table (months, income totals, and expense totals). Go to Insert > Chart. A column or line chart is perfect for this. It provides a crystal-clear view of which months you saved money and which months you overspent.

Bonus: Pro Tips to Supercharge Your Tracker

• Use Conditional Formatting: Make important data stand out. Go to Format > Conditional formatting to set up rules. You can make any expense over $100 turn red or highlight your running balance in green when it's above a certain threshold.
• Set Up a Budget Column: On your dashboard's category breakdown, add a "Budget" column where you manually enter your monthly goal for each category. Then, add a final "Difference" column (Actual - Budget) to see if you're on track. Use conditional formatting to turn negative numbers red to quickly spot overspending.
• Connect a Google Form: For easy data entry on the go, create a Google Form with fields for Date, Category, Description, and Amount. You can link a form's responses to automatically populate a new row in your Google Sheet, meaning you can log an expense from your phone in seconds.

Final Thoughts

Creating your own money tracker in Google Sheets is an empowering way to take command of your financial wellness. By methodically setting up your sheets, using sensible formulas, and visualizing your data, you've built a personalized, infinitely expandable system that works exactly how you need it to, without any subscription fees.

While building your tracker provides full control, maintaining it and linking data from dozens of disconnected platforms and bank accounts can quickly become another manual chore. We built Graphed to solve this by transforming hours of data wrangling into simple conversations. Connect your data sources once, then ask something like "show me a dashboard of my spending vs. budget by category," and watch as a real-time dashboard is instantly created for you - no formulas required.