How to Track Monthly Expenses Using Google Sheets for Free
To track monthly expenses in Google Sheets, create a Log sheet with date, description, category, amount, and payment method columns, then build a Summary sheet using SUMIF formulas to total spending by category automatically. The entire setup takes under an hour and gives you full visibility into where every rupee goes each month.
What if you could see exactly where every rupee goes each month — without paying for an app, without connecting your bank account, and without complicated setup? Tracking monthly expenses in Google Sheets does exactly this, and you can have a working tracker built from scratch in under an hour. Here is how.
Step 1: Create Your Google Sheet and Set Up the Structure
Open Google Sheets (sheets.google.com) and create a new blank spreadsheet. Name it something clear — "Monthly Budget 2026" or "Expense Tracker." You need two tabs (sheets) inside this file:
- Tab 1: Log — where you enter every transaction daily
- Tab 2: Summary — where you see totals by category each month
To create a second tab, click the "+" at the bottom of the screen. Rename each tab by double-clicking it.
Step 2: Build the Expense Log Sheet
In your Log tab, create these columns in Row 1:
- Date (Column A)
- Description (Column B) — a short note on what the expense was
- Category (Column C) — the spending category (Groceries, Rent, Transport, etc.)
- Amount (Column D) — the amount spent
- Payment Method (Column E) — UPI, Cash, Credit Card, etc.
Bold Row 1 by pressing Ctrl + B to make headers stand out. Freeze the row by going to View → Freeze → 1 row. This keeps headers visible as you scroll down through hundreds of entries.
Step 3: Define Your Spending Categories
Pick 8 to 12 categories that match your life. Too few and detail is lost; too many and the system becomes tedious. Good starting categories:
- Housing (rent or home loan EMI)
- Groceries
- Dining Out
- Transport (fuel, auto, cab, metro)
- Utilities (electricity, gas, internet, phone)
- Health
- Entertainment
- Shopping (clothing, personal care)
- Savings Transfer
- Other
Consistency matters more than perfection. As long as you use the same category names every time, your summary will be accurate.
Step 4: Build the Summary Sheet with SUMIF Formulas
In your Summary tab, create two columns: Category (Column A) and Total Spent (Column B). List every category from your Log in Column A. In B2 (next to the first category), enter this formula:
=SUMIF(Log!C:C, A2, Log!D:D)
This formula says: look at all entries in Column C of the Log sheet; wherever the category matches what is in A2, add up the corresponding amounts in Column D. Copy this formula down for every category row.
Add a total row at the bottom using =SUM(B2:B11) (adjust the range to match your category count). This gives you your total monthly spending in one cell.
Step 5: Add Your Income and Calculate the Balance
At the top of your Summary sheet, create a simple income section:
- Row 1: "Monthly Income" | [your take-home amount]
- Row 2: "Total Spent" | [link to your SUM total from Step 4]
- Row 3: "Balance" | =B1-B2
The Balance cell tells you at a glance how much of your income is unaccounted for — this is your savings potential for the month.
Step 6: Use Conditional Formatting to Spot Overspending
In your Summary tab, select the Total Spent column. Go to Format → Conditional Formatting. Set a rule that turns cells red if the value exceeds your budgeted limit for that category. This gives you an instant visual warning when any category is running over.
Common Mistakes to Avoid
- Not logging expenses daily: Batching entries weekly works if you keep receipts, but most people forget small purchases after 2 days. Log at the end of each day — it takes 2 minutes.
- Using inconsistent category names: "Groceries" and "grocery" are different in SUMIF. Standardise from day one or your totals will be wrong.
- Only tracking from memory: Cross-check your log against your bank statement at month end to catch anything you missed.
This tracker requires zero financial knowledge to use, costs nothing, and gives you more visibility into your spending than most paid apps do. The discipline of entering each expense manually — that small friction — is actually part of what makes it effective.
Frequently Asked Questions
- How do I track expenses in Google Sheets?
- Create a Log sheet with columns for date, description, category, amount, and payment method. Then build a Summary sheet using SUMIF formulas to total spending by category automatically. Log each expense daily for accurate monthly totals.
- Is Google Sheets good for budgeting?
- Yes. Google Sheets is free, flexible, accessible from any device, and allows custom formulas and conditional formatting that most budgeting apps charge for. It requires more setup than apps but gives full control over your categories and calculations.
- What formula do I use in Google Sheets to sum expenses by category?
- Use SUMIF. The formula is: =SUMIF(Log!C:C, A2, Log!D:D) — where Column C is your category column in the Log sheet, A2 is the category name in the Summary sheet, and Column D is your amounts. Copy this down for each category.
- How many expense categories should I use in my budget?
- 8 to 12 categories is a practical range. Too few loses detail; too many makes daily logging tedious. Start with Housing, Groceries, Dining Out, Transport, Utilities, Health, Entertainment, Shopping, and Other — adjust based on your actual spending patterns.
- Can I use Google Sheets for expense tracking on my phone?
- Yes. The Google Sheets mobile app (Android and iOS) works well for daily expense logging on the go. The free app syncs automatically with your desktop version, so entries made on your phone appear immediately in your full tracker.