How to Build a Personal Budget Tracker in Google Sheets

Building your own budget tracker takes about 20 minutes and teaches you formulas you'll use forever. This guide builds a complete tracker step by step — from blank sheet to a working monthly budget with automatic category totals.

Step 1: Create the Transactions Sheet

This is where you enter every income and expense. Add these column headers:

Format row 1: bold text, colored background, bottom border. This is your data entry sheet.

Step 2: Set Up Categories

Create a second sheet called "Categories" with your budget limits:

Step 3: Data Validation for Category Column

Link your B column to the Categories sheet so you only enter valid categories:

1. Select column B in Transactions sheet
2. Data → Data Validation → List from range
3. Enter: Categories!$A$2:$A$20

Now B column shows a dropdown. Consistent categories = reliable formulas.

Step 4: Summary Sheet Formulas

Create a third sheet "Summary" with these formulas:

Total Income

Total Expenses

Net Savings

Savings Rate

Format this cell as percentage. Target: above 20%.

Spending by Category

Budget vs Actual Alert

Step 5: Monthly Filtering

Filter spending by month (replace 1 with any month number):

Step 6: Add a Chart

1. Select your category names and spending totals
2. Insert → Chart → Pie chart or Bar chart
3. Instantly see which categories are eating your budget

Step 7: Conditional Formatting Alerts

1. Select your category spending cells
2. Format → Conditional formatting
3. Rule: Greater than → [link to budget cell]
4. Formatting style: Red background

Cells turn red automatically when you exceed your budget for that category.

What You've Built

• ✅ Transaction log with category dropdown
• ✅ Auto-calculated income and expense totals
• ✅ Per-category spending vs budget comparison
• ✅ Visual budget alerts (red = over budget)
• ✅ Monthly filtering formulas
• ✅ Savings rate calculation