How to Track Your Net Worth in India (Without Excel)
Tired of manually updating Google Sheets? Learn how to automatically track your entire net worth in India — EPF, PPF, stocks, mutual funds, real estate, and gold.
If you are reading this, you probably have a giant, messy Excel sheet where you try to manually update your stock prices, mutual fund NAVs, EPF balance, and bank accounts at the end of every month. It's exhausting, error-prone, and always out of date. Here is the modern way to do it.
In this guide, we will cover the exact formula to calculate your net worth in India, why spreadsheets eventually fail every Indian investor, the three main tracking methods (with pros and cons of each), a complete checklist of Indian assets and liabilities to include, and how to set up a free, automated net worth tracker in under 10 minutes.
What is Net Worth? (The Formula)
Before diving into tools, let us get the definition right. Your net worth is the single most important number in your financial life. It tells you your true financial position — not just how much you earn, but how much you actually own.
NET WORTH = Total Assets − Total Liabilities
Everything you own minus everything you owe
A person earning ₹25 LPA with ₹40 Lakhs in loans may have a lower net worth than someone earning ₹10 LPA who has been investing via SIPs for 8 years. Income is vanity, net worth is sanity. Read our complete FIRE and net worth tracker guide for the full picture.
Real Example: Calculating Net Worth for an Indian Household
Let us walk through a real-world calculation for Rahul and Priya, a dual-income couple in Bangalore:
✅ Their Assets
- • Bank savings: ₹3,50,000
- • FDs: ₹5,00,000
- • Rahul's EPF: ₹12,00,000
- • Priya's EPF: ₹8,00,000
- • Joint PPF: ₹6,00,000
- • Mutual Funds (SIPs): ₹15,00,000
- • Zerodha stocks: ₹8,00,000
- • Gold jewelry: ₹4,00,000
- • Flat (market value): ₹85,00,000
- Total Assets: ₹1,46,50,000
❌ Their Liabilities
- • Home loan outstanding: ₹52,00,000
- • Car loan: ₹4,50,000
- • Credit card balance: ₹35,000
- Total Liabilities: ₹56,85,000
Net Worth:
₹89,65,000
(₹1,46,50,000 − ₹56,85,000)
Now imagine doing this calculation manually every month, logging into 7+ different apps and portals to get updated numbers. That is exactly the problem a net worth tracker in India solves.
Complete Indian Assets & Liabilities Checklist
Most people undercount their assets or forget liabilities. Use this comprehensive checklist to make sure you capture everything:
Assets to Include
Cash & Deposits
- • Savings accounts (all banks)
- • Fixed Deposits (FDs)
- • Recurring Deposits (RDs)
Government Schemes
- • EPF / VPF balance
- • PPF balance
- • NPS (National Pension System)
- • Sukanya Samriddhi Yojana
- • Post Office schemes (NSC, KVP, SCSS)
Market Investments
- • Mutual Funds (SIPs + Lumpsum)
- • Direct stocks (Zerodha, Groww, Upstox)
- • Sovereign Gold Bonds (SGBs)
- • Corporate bonds / debentures
Physical & Other
- • Real estate (market value)
- • Physical gold & jewelry
- • LIC / insurance surrender value
- • Vehicle resale value (optional)
Liabilities to Include
Secured Loans
- • Home loan outstanding
- • Loan against property (LAP)
- • Car / vehicle loan
- • Gold loan
Unsecured Loans
- • Personal loan
- • Education loan
- • Credit card outstanding balance
- • BNPL (Buy Now Pay Later) dues
Other
- • Informal borrowings from family
- • Office advances / salary advances
- • Pending tax liabilities
Why Excel and Google Sheets Fail for Indian Net Worth Tracking
Spreadsheets are great when you are just starting out with 2-3 investments. But they break down fast as your wealth grows. Here are the five specific pain points every Indian investor hits:
1 GOOGLEFINANCE() is Broken for Indian Stocks
The =GOOGLEFINANCE("NSE:RELIANCE") function frequently returns #N/A errors, stale prices from days ago, or simply does not work at all for many mid-cap and small-cap NSE/BSE stocks. Google has never officially guaranteed support for the Indian market feed.
2 No Way to Auto-Fetch Mutual Fund NAVs
Indian mutual fund NAVs are not available via GOOGLEFINANCE. You need custom Apps Script macros that scrape AMFI's API — but these scripts break every few months when AMFI changes their data format. One broken script = your entire sheet shows stale values.
3 EPF, PPF, and NPS Require Manual Entry
There is zero automation available for government schemes. You have to log into the EPFO portal (which is notoriously slow), the PPF bank portal, and the NPS website separately, then manually copy-paste balances into your sheet. Every. Single. Month.
4 ₹ Formatting is a Mess
Google Sheets and Excel default to Western number formatting (1,234,567). Getting proper Indian formatting (12,34,567) with Lakhs and Crores requires custom format strings that break when you copy cells or share the sheet.
5 Single Point of Failure
Usually only one person in the household understands how the complex spreadsheet works. If something happens to them, the family has zero visibility into where their money is. This is a real and dangerous risk for Indian families.
The Typical Indian Investor's Nightmare
You own shares of Reliance on Zerodha, an SBI mutual fund on Groww, a PPF account at HDFC Bank, FDs at ICICI, EPF from your current and previous employer, gold jewelry in a locker, and a flat with an SBI home loan.
To figure out your net worth today, you have to log into 7+ different apps and portals, copy the numbers into Excel, and subtract the loan from the assets. By tomorrow, the stock market changes and your sheet is out of date again. This entire process takes 30-45 minutes every month.
3 Methods to Track Net Worth in India (Compared)
Here are the three main approaches, with honest pros and cons of each:
| Feature | Excel / Google Sheets | US-Based Apps | India-First Tracker (NxWorth) |
|---|---|---|---|
| Indian Stock Prices | Broken GOOGLEFINANCE | ❌ US stocks only | ✅ Zerodha auto-sync |
| Mutual Fund NAVs | Complex scripts break | ❌ US funds only | ✅ All Indian MFs |
| EPF / PPF / NPS | Manual entry only | ❌ Not supported | ✅ Native support |
| Real Estate & Gold | Manual cell | ❌ Not supported | ✅ Manual + live gold price |
| Liability Tracking | Manual formulas | Partial | ✅ Auto-subtracted |
| Currency Format | Western (1,234,567) | \$ only | ✅ ₹ (12,34,567) |
| Family / Multi-Member | Complex tabs | Single user | ✅ Whole family |
| Historical Trend Charts | Manual chart creation | Yes | ✅ Beautiful dark-mode charts |
| Monthly Time Required | 30-45 minutes | N/A (no Indian data) | 5-10 minutes |
| Price | Free but time-heavy | \$10-30/month | ✅ 100% Free |
How to Set Up Your Net Worth Tracker in 10 Minutes
Here is the exact step-by-step process to go from zero to a fully working net worth tracker in India:
1 Create a Free NxWorth Account (1 min)
Go to nxworth.com/signup. Enter your email and password. No credit card, no phone number required.
2 Add Your Bank & FD Balances (2 min)
Enter balances for all your savings accounts and Fixed Deposits. Check your banking apps or last bank statement for accurate numbers.
3 Connect Zerodha for Stocks & MFs (2 min)
Link your Zerodha Kite account using your API key. Your entire stock portfolio and mutual fund holdings will auto-sync with live prices. Follow our step-by-step Zerodha connection guide.
4 Add EPF, PPF, and NPS Balances (2 min)
Check your EPF balance on epfindia.gov.in or the UMANG app. Check PPF at your bank's online portal. Enter NPS balance from the CRA portal. These are manual entries updated monthly.
5 Add Real Estate & Gold (1 min)
Enter the estimated market value of any property you own. For gold, enter the weight — the app can calculate value using live gold prices. For a property, use recent sales in your area as a benchmark.
6 Add All Liabilities (2 min)
Enter your home loan outstanding, car loan, personal loan, and credit card balance. These are subtracted from assets to show your true net worth.
Done! Your Dashboard is Ready
Your net worth is now calculated and displayed on your dashboard with beautiful charts showing your asset allocation, liability breakdown, and net worth trend over time. From next month, the update process takes just 5-10 minutes — only update manual entries (EPF, real estate) while stocks and MFs auto-sync.
The 10-Minute Monthly Net Worth Review Routine
The key to building wealth is consistency. Set a recurring calendar reminder for the 1st of every month and follow this routine:
- Update EPF balance from EPFO portal or UMANG app (takes 2 min).
- Update PPF / NPS from your bank or CRA portal (1 min).
- Update real estate estimate if you have seen recent sales in your area (30 sec).
- Update loan outstanding — check your EMI app for latest principal balance (1 min).
- Review your net worth trend — did it go up or down? By how much? Why? (2 min).
- Check your FIRE progress — what percentage of your FIRE number have you reached? (1 min).
- Celebrate the wins — if your net worth crossed a milestone (₹25 Lakhs, ₹50 Lakhs, ₹1 Crore), take a moment to appreciate your progress. 🎉
5 Common Mistakes When Tracking Net Worth in India
Net Worth Milestones to Celebrate 🎯
Tracking becomes addictive when you set milestones. Here are the key net worth milestones for Indian professionals:
| Milestone | What It Means | Typical Age (FIRE track) |
|---|---|---|
| ₹0 (Debt-Free) | Net worth turns positive. All debt repaid. Huge psychological milestone. | 24-28 |
| ₹10 Lakhs | First real cushion. ~6-month emergency fund established. | 25-27 |
| ₹25 Lakhs | Compound interest starts becoming noticeable. Your money is working for you. | 27-29 |
| ₹50 Lakhs | Half a Crore. Major inflection point. Growth accelerates visibly. | 28-31 |
| ₹1 Crore | The "Crorepati" milestone. Psychological freedom. You could Coast FIRE. | 30-34 |
| ₹3+ Crores | Full FIRE territory for many Indian families. Financial Independence achieved. | 35-42 |
Read our age-specific benchmarks: Net Worth at 25, Net Worth at 30, and Net Worth at 40.
Frequently Asked Questions
How do I calculate my net worth in India?
Net Worth = Total Assets − Total Liabilities. Add up all your assets (bank accounts, FDs, EPF, PPF, NPS, mutual funds, stocks, real estate, gold, LIC policies) and subtract all your liabilities (home loan, car loan, personal loan, credit card debt). The result is your true net worth in ₹.
What is the best way to track net worth in India?
Use a dedicated India-first net worth tracker like NxWorth that natively supports EPF, PPF, NPS, mutual funds, Zerodha stocks, real estate, and gold. It displays values in Lakhs and Crores and auto-syncs your portfolio. Google Sheets works initially but breaks as your wealth grows.
Should I include my house in net worth?
Yes — include the current market value as an asset AND the outstanding home loan as a liability. If your flat is worth ₹1.2 Crores with ₹80 Lakhs loan remaining, the net contribution to your net worth is ₹40 Lakhs.
Should I include EPF and PPF in my net worth?
Absolutely. EPF and PPF are significant retirement assets. For a salaried professional with 10+ years of experience, the EPF balance alone can be ₹15-25 Lakhs. Not including it means drastically underestimating your net worth.
How often should I track my net worth?
Monthly is ideal. Set a calendar reminder for the 1st of every month. Spend 10-15 minutes updating manual entries and reviewing your trend. Avoid daily tracking — short-term market noise is misleading.
Why does GOOGLEFINANCE not work for Indian stocks?
GOOGLEFINANCE() frequently returns #N/A errors or stale data for NSE/BSE stocks. Google has never officially guaranteed Indian market support. Mutual fund NAVs are not available at all through this function.
Is there a free net worth tracker for India?
Yes. NxWorth is 100% free — no hidden fees, no premium tiers, no credit card required. It supports EPF, PPF, NPS, mutual funds, Zerodha stock sync, real estate, gold, and all Indian liabilities. Sign up here.
Track Your Entire Financial Life
Join smart investors across India who use NxWorth to track net worth, manage expenses, and plan for financial independence.
Create Free Account