Google Sheets Monthly Finance Tracker: A Simple Build That Works
A minimal Google Sheets finance tracker that takes 30 minutes to set up and 30 minutes per month to maintain. No macros. No complexity.
There are three kinds of personal finance spreadsheets. The first kind gets built over a weekend and abandoned within a month — too complex to maintain, too many formulas that break. The second kind never gets built because the perfect setup keeps getting deferred. The third kind is a simple, slightly ugly sheet that you've actually been using for two years because it takes 30 minutes a month and tells you what you need to know.
This guide builds the third kind.
The design principles here are deliberate:
- Minimal structure: enough to answer the questions that matter, not enough to become a project in itself
- No macros: everything done with standard Sheets formulas that any beginner can understand and fix
- One tab for each function: no cramming everything onto one overwhelming sheet, no unnecessary fragmentation either
- Maintainable in 30 minutes per month: if it takes longer than that consistently, you'll stop doing it
The Five-Tab Structure
Open a new Google Sheet. Rename it something like "Personal Finance 2025" or use a year-agnostic name if you plan to keep adding to it year over year. Create five tabs with these exact names — consistency matters when you're looking for something at 9pm:
- Monthly Summary
- Expense Log
- Net Worth
- Investments
- Goals
Here's what goes in each.
Tab 1: Monthly Summary
This is the tab you look at first when you open the sheet. It should answer: how much came in, how much went out by category, how much was saved, and is that good or bad compared to your target?
Row structure (one row per month, months going down):
| Column | What goes here |
|---|---|
| A | Month (e.g., "Apr 2025") |
| B | Total Income (salary + any other income) |
| C | Housing (rent / home loan EMI) |
| D | Food (groceries + eating out) |
| E | Transport (fuel, Ola/Uber, metro, vehicle EMI) |
| F | Utilities (electricity, water, internet, mobile) |
| G | Healthcare (doctor, pharmacy, tests) |
| H | Education (fees, courses, books) |
| I | Debt Payments (personal loan, credit card) |
| J | Personal (clothing, haircut, subscriptions) |
| K | Entertainment (OTT, movies, events) |
| L | Irregular (one-off large expenses) |
| M | Total Expenses (=SUM(C:L) for that row) |
| N | Savings / Investments (SIPs, PPF, manual transfers) |
| O | Net Cash Flow (=B - M - N) |
| P | Savings Rate (=N/B, formatted as %) |
Monthly target row: Above the data rows, add one row labelled "Target" with your intended amounts for each category. This becomes your budget vs actual reference.
Conditional formatting: Select column P (Savings Rate). Format → Conditional formatting → if value is less than your target savings rate (say 25%), make it red. If above, green. You'll see at a glance whether the month was on track.
You don't fill this tab manually. You fill Tab 2 (Expense Log) throughout the month, and this tab pulls totals from there using SUMIF.
Tab 2: Expense Log
This is the working tab. Every transaction goes here.
Column structure:
| Column | What goes here |
|---|---|
| A | Date (formatted as DD/MM/YYYY) |
| B | Description (brief: "BigBasket", "Petrol", "Doctor visit") |
| C | Amount (₹, positive numbers only) |
| D | Category (same categories as Monthly Summary: Housing, Food, Transport, etc.) |
| E | Account (HDFC Savings, HDFC Credit Card, Cash, etc.) |
| F | Notes (optional: "annual subscription", "Apoorva's school fee") |
How to fill it: Once a month, download your bank statement and credit card statement. Go through each transaction line by line and enter it here. For credit card expenses, enter them in the month they were charged, not the month the bill was paid. This gives you an accurate picture of when you actually spent the money.
The SUMIF formula for Monthly Summary: In the Monthly Summary tab, for each month's Food total (column D), the formula is:
=SUMIF('Expense Log'!$D:$D,"Food",'Expense Log'!$C:$C)
But this pulls all food expenses ever, not just for one month. To filter by month, use:
=SUMIFS('Expense Log'!$C:$C, 'Expense Log'!$D:$D, "Food", 'Expense Log'!$A:$A, ">="&DATE(2025,4,1), 'Expense Log'!$A:$A, "<"&DATE(2025,5,1))
Adjust the DATE values for each month's row. This looks intimidating once but you copy it across all category columns and it works correctly.
Wrap SUMIF in IFERROR to handle months that have no data yet:
=IFERROR(SUMIFS(...),"")
This prevents error messages in future empty rows.
Tab 3: Net Worth
This tab is updated monthly with a single row. Over time it becomes the most useful tab in the sheet — a running record of your financial progress.
Column structure:
| Column | What goes here |
|---|---|
| A | Month |
| B | Bank Accounts (combined balance across all savings accounts) |
| C | Fixed Deposits |
| D | Mutual Funds (current NAV × units — from CAMS/KFintech statement) |
| E | Direct Equity (current market value from DEMAT) |
| F | EPF (from EPFO passbook online) |
| G | PPF |
| H | NPS |
| I | Gold (market value) |
| J | Real Estate (conservative estimate — update annually, not monthly) |
| K | Total Assets (=SUM(B:J)) |
| L | Home Loan Outstanding |
| M | Car Loan |
| N | Personal Loan / Credit Card Carried Balance |
| O | Total Liabilities (=SUM(L:N)) |
| P | Net Worth (=K-O) |
Add a line chart using column P. Select the Month column and Net Worth column together, insert a chart. This single line graph — net worth over time — is the most motivating thing in the entire tracker. When it's going up and to the right, you know the system is working.
Tab 4: Investments
This tab gives you a consolidated view of what you've invested, where it is, and roughly what it's worth now.
Column structure:
| Column | What goes here |
|---|---|
| A | Investment Name |
| B | Type (Equity MF / Debt MF / Direct Equity / FD / EPF / PPF / NPS / Gold) |
| C | Platform / Account (Zerodha, CAMS, HDFC Bank, EPFO, etc.) |
| D | Amount Invested (total cost basis) |
| E | Current Value (updated monthly or quarterly) |
| F | Absolute Return (=E-D) |
| G | Return % (=(E-D)/D, formatted as %) |
| H | Start Date |
| I | Notes (FD maturity date, SIP amount, etc.) |
At the bottom, add totals:
- Total Invested:
=SUM(D:D) - Total Current Value:
=SUM(E:E) - Overall Return %:
=(SUM(E:E)-SUM(D:D))/SUM(D:D)
For SIPs with multiple purchase dates, the "amount invested" is the running total of all SIP instalments made so far. Current value is what the MF portfolio is worth today.
For XIRR on a SIP: create a separate small section with two columns — one for cash flows (all monthly SIP amounts as negative numbers, plus current value as a positive number in the final row) and corresponding dates. Then =XIRR(cashflows_range, dates_range) gives you the annualised return accounting for the timing of investments.
Tab 5: Goals
Each financial goal gets one row. This tab answers: what am I saving for, how much do I need, and am I on track?
Column structure:
| Column | What goes here |
|---|---|
| A | Goal Name |
| B | Target Amount (₹) |
| C | Target Date |
| D | Monthly Contribution |
| E | Current Saved |
| F | Progress % (=E/B, formatted as %) |
| G | Months Remaining (=DATEDIF(TODAY(),C,"M")) |
| H | On Track? (=IF((B-E)/G<=D,"Yes","No")) |
The "On Track?" column checks whether your monthly contribution is enough to reach the goal by the target date, ignoring investment returns for simplicity. If you're investing the goal savings, the actual target will be reached sooner — this is a conservative check.
The 30-Minute Monthly Process
Once the sheet is built, maintaining it takes about 30 minutes per month. Here's the exact sequence:
-
Download statements (5 mins): bank statement and credit card statement for the previous month. Most banks let you download a PDF or CSV from net banking.
-
Enter expenses (15 mins): go through each transaction in the bank statement and enter it in the Expense Log. Skip salary credits and investment transfers (those aren't expenses). For credit card transactions, enter the individual purchases, not the total bill payment.
-
Update Net Worth (5 mins): check current balances — bank account (net banking), MF value (CAMS app or KFintech app), EPF (EPFO portal). Enter the month's row in the Net Worth tab.
-
Check Summary (5 mins): look at the Monthly Summary tab. Which categories ran over? What's the savings rate? Any surprises?
That's it. The sheet does the rest.
Sharing With a Partner
In Google Sheets, go to Share → enter your partner's email → Editor access. Both of you can now update the sheet. Agree on one rule: whoever enters expenses uses the same category names. Inconsistent category names break the SUMIF formulas. Keep a note of the category list somewhere visible on the sheet itself — a small reference table in a corner of the Monthly Summary tab works well.
If you want view-only access for one person and editing for the other, use Viewer permission for the view-only person. They can see everything but cannot edit.
Adding a Tax Planning Tab to the Tracker
The five-tab structure covers month-to-month finance and net worth well. For most Indian salaried professionals, a sixth tab — Tax Planning — completes the annual picture.
Column structure for the Tax Planning tab:
| Row | Field | Amount |
|---|---|---|
| 1 | Financial Year | FY 2025-26 |
| 2 | Gross salary (estimated for year) | |
| 3 | Standard deduction | Rs.75,000 |
| 4 | Section 80C | |
| 5 | EPF (employee side, auto) | |
| 6 | ELSS investments YTD | |
| 7 | PPF contribution YTD | |
| 8 | LIC premium | |
| 9 | Home loan principal YTD | |
| 10 | Total 80C used | =SUM(above 80C rows) |
| 11 | 80C limit | Rs.1,50,000 |
| 12 | 80C remaining | =Max(0, 11-10) |
| 13 | Section 80D | |
| 14 | Health insurance premium (self+family) | |
| 15 | Health insurance premium (parents) | |
| 16 | Total 80D | =SUM |
| 17 | Section 80CCD(1B) — NPS extra | |
| 18 | NPS Tier 1 contribution YTD | |
| 19 | 80CCD(1B) limit | Rs.50,000 |
| 20 | 80CCD(1B) remaining | =Max(0, 19-18) |
| 21 | Estimated taxable income | =2-3-10-16-18 (simplified) |
| 22 | Estimated tax (old regime) | (calculate separately) |
| 23 | Estimated tax (new regime) | (calculate separately) |
| 24 | Recommended regime | (your conclusion) |
Update this tab monthly as you make contributions. By December, you can see exactly how much 80C capacity remains and whether you need to invest more in ELSS before March 31 — rather than doing a panic calculation in February.
SUMIF Formula Reference for the Expense Log
The SUMIF formulas that connect the Expense Log to the Monthly Summary are the most technically complex part of the tracker. Here is a complete reference for all standard categories, formatted for copy-paste:
For the Monthly Summary row for April 2025, these formulas pull from the Expense Log tab:
Housing:
=IFERROR(SUMIFS('Expense Log'!$C:$C,'Expense Log'!$D:$D,"Housing",'Expense Log'!$A:$A,">="&DATE(2025,4,1),'Expense Log'!$A:$A,"<"&DATE(2025,5,1)),0)
Replace "Housing" with each category name and adjust the DATE values for each month's row. Copy this formula across all category columns for each month. Once built for April, you can copy the row to May and change only the DATE(2025,4,1) and DATE(2025,5,1) parts to DATE(2025,5,1) and DATE(2025,6,1).
To make this easier, put the year and month number in helper cells at the top of the Monthly Summary tab:
- Cell A1: "Year" → enter 2025
- Cell B1: "Start Month" → enter 4 (April)
Then the formula becomes:
=IFERROR(SUMIFS('Expense Log'!$C:$C,'Expense Log'!$D:$D,"Housing",'Expense Log'!$A:$A,">="&DATE($A$1,ROW()-OFFSET_ROWS,1),'Expense Log'!$A:$A,"<"&DATE($A$1,ROW()-OFFSET_ROWS+1,1)),0)
Where OFFSET_ROWS is the number of rows between your header and the first data row. This approach makes the entire Monthly Summary self-updating based on the dates in column A.
This article is for educational purposes only. It describes general spreadsheet-building approaches and is not personalised financial advice. Consult a qualified financial advisor for advice specific to your situation.