How to Build and Maintain a Net Worth Tracker in Google Sheets

Net worth is the only financial number that tells the complete story. Salary tells you what you earn. Savings rate tells you what you keep. Investments tell you where you put money. Net worth — total assets minus total liabilities — tells you where you actually stand.

Most people have a rough intuition about their net worth. A spreadsheet turns that intuition into a specific, trackable number — and more importantly, into a trend that shows whether you're moving in the right direction.

Why Net Worth Is the Right Metric to Track

Income can be high and wealth still minimal if spending keeps up. Investment portfolio can look impressive while hiding large loans that wipe out much of its value. Net worth accounts for both sides of the equation — everything you own minus everything you owe.

Rising net worth means you're accumulating more in assets than you're adding in liabilities. This is the fundamental definition of financial progress.

Flat net worth despite a salary and savings often means one of two things: investments are growing but so are lifestyle liabilities (EMIs, credit card debt), or assets are growing but a large liability is also growing (often a home loan where the outstanding balance isn't falling fast enough in early years).

Declining net worth is a warning signal — often from market falls (temporary, in the case of equity) or from liabilities growing faster than assets.

Building the Tracker

The tracker has three parts: an asset register, a liability register, and a monthly summary that records the total over time.

Asset Register

Create one row per asset. The key is to be comprehensive — most people initially undercount their assets by forgetting EPF, PPF, and small FDs.

Liquid and Near-Liquid Assets:

• Savings account balances (all banks combined)
• Current account (if any)
• Liquid mutual funds held
• Short-duration FDs (maturing within 6 months)
• Emergency fund allocation

Invested Assets — Market Linked:

• Equity mutual funds (current portfolio value from CAS)
• Debt mutual funds
• Direct equity shares (from demat, at current market value)
• REIT and InvIT holdings
• ETFs (gold ETF, Nifty ETF, etc.)

Invested Assets — Fixed Return:

• Fixed deposits (principal + accrued interest, or market value if linked to any market)
• PPF balance (from passbook)
• EPF balance (from the EPFO member portal)
• NPS balance — Tier I and Tier II
• NSC, SCSS, or other small savings
• Bonds (government or corporate)
• Recurring deposits (present value)
• PF and gratuity from employer (if you have an approximate estimate)

Retirement and Long-Term:

• EPF + VPF accumulated value
• NPS corpus
• Superannuation fund (if applicable)
• Pension from employer (if defined benefit)

Real Assets:

• Primary residence (approximate market value)
• Rental/investment property (approximate market value)
• Vehicle(s) (current market value, depreciates)
• Physical gold and silver (at current spot price × weight)
• Other significant personal assets (jewellery at gold content value)

Other:

• Money lent to others (only if genuinely recoverable)
• Business equity or partnership stake (if valued)

For the tracker, enter the current value of each item. Update monthly for liquid and market-linked assets. Update annually for real estate, PPF, and physical assets.

Liability Register

Home Loan:

• Outstanding principal (from latest loan statement or net banking)
• Original loan amount (for reference)
• Monthly EMI
• Remaining tenure

Vehicle Loan:

• Outstanding principal
• Monthly EMI
• Remaining tenure

Personal Loans:

• List each separately with outstanding and rate

Education Loan:

• Outstanding principal
• Status (in moratorium, under repayment, complete)

Credit Card:

• Current balance if carried over (not the credit limit — only what you owe)
• Minimum payment

Informal Loans:

• Amounts owed to family or friends (if there's an expectation of repayment)

Don't include future liabilities — only what you currently owe.

Monthly Summary Tab

This is the most valuable tab for tracking progress. Add one row per month:

Month	Total Assets	Total Liabilities	Net Worth	Change vs Previous Month
April 2024	₹45,00,000	₹22,00,000	₹23,00,000	—
May 2024	₹46,20,000	₹21,70,000	₹24,50,000	+₹1,50,000
...

The asset total and liability total come from the asset and liability register tabs. The monthly summary captures the snapshot at month-end.

Over 24 months, this table becomes a chart that shows your net worth trajectory visually — one of the most useful financial charts you can have.

Setting Up the Chart

In the Monthly Summary tab, select the Month column and Net Worth column. Insert a line chart. This gives you a visual net worth trend line.

What to look for on the chart:

• Consistent upward slope: Good. Steady progress.
• Step changes up: Often from a bonus, inheritance, or lump-sum investment.
• Plateaus: May indicate a period of high expenses offsetting savings.
• Dips: Usually from market corrections in equity (temporary) or a large one-time expense. Did the net worth recover?
• Acceleration: This is the power of compounding showing up — later months should show larger absolute increases than earlier months, even at the same savings rate, because the base is larger.

Using Net Worth Data to Make Decisions

Debt payoff priority: If liabilities are a large percentage of total assets (say, above 40%), the focus should be on accelerating debt repayment before adding more investment risk. The guaranteed return from paying off a 14% personal loan beats the uncertain return from equity investment.

Asset allocation check: Within total assets, what percentage is liquid/accessible vs locked in real estate or illiquid instruments? If most of your net worth is in a home you won't sell, your financial flexibility is limited. This informs how aggressively to invest in liquid instruments.

Progress toward financial independence: Many people use net worth to track progress toward FI (financial independence) — the point where invested assets generate enough income to cover annual expenses. Seeing net worth numbers concretely makes that goal feel real rather than abstract.

Year-over-year comparison: At minimum, compare April-to-April. Did your net worth grow by more than your savings? (It should, if investments performed.) Did it grow faster than last year? Slower? Why?

A Note on Valuation Honesty

The tracker works only if it's honest. Common ways people inadvertently inflate their net worth:

• Valuing a second property at its purchase price rather than current market value
• Including the full value of a joint asset (e.g., jointly owned property) rather than just your share
• Forgetting to include informal loans you owe
• Using a credit card's credit limit as an asset (it's not — it's potential liability)

Use conservative estimates. Net worth calculated honestly and trending upward is far more valuable than an inflated number that doesn't reflect reality.

Start with a rough estimate in your first month — the exact number is less important than building the monthly habit. After six months, the accuracy improves and the trend starts to be meaningful.

Pulling EPF, PPF, and NPS Data Into the Tracker

These three instruments represent substantial wealth for most salaried professionals, yet they are often excluded from net worth tracking because the data isn't readily accessible. Here is how to pull each one:

EPF balance (EPFO portal): Log into member.epfindia.gov.in with your UAN. The passbook shows your current balance — employer contribution, employee contribution, and accumulated interest. EPF interest is credited once a year in March/April (the rate for FY 2023-24 was 8.25%). Update your tracker's EPF row with the passbook balance when it is updated, typically by the 10th of April for the previous financial year.

If you've changed employers without transferring your EPF, your old EPF account still earns interest (until it becomes inoperative — broadly, only after you reach 58 or retire and leave it unclaimed) and should be included. Transfer old EPF via the EPFO portal under "One Member One EPF Account" to keep everything consolidated under your current UAN.

PPF balance: Available in net banking for post office and bank-linked PPF accounts. SBI, HDFC, ICICI, and Axis all show PPF balance in their net banking under the accounts or deposits section. Update annually in April — PPF interest credited on March 31 will appear in the April statement.

NPS balance: Log into the NPS Trust portal (npscra.nsdl.co.in) with your PRAN. The Tier I balance represents your pension wealth. The NPS invests across equity (E), corporate bonds (C), and government securities (G) based on your allocation choice — the combined current value is your NPS row in the tracker. Check quarterly as NPS NAVs fluctuate.

Adding a "Year-on-Year Change" Column

The monthly net worth number is informative. The year-on-year comparison is more powerful for long-term pattern recognition. Add this column to your Monthly Summary tab:

Column Q	What Goes Here
YoY Change (Rs.)	=Current month net worth − same month last year's net worth
YoY Change (%)	=YoY Change Rs. / same month last year's net worth

The year-on-year percentage tells you whether your rate of wealth accumulation is accelerating or slowing. In the early years, net worth growth tends to be driven by savings rate. In later years, compounding on the existing corpus begins to contribute a larger share. Seeing this in the data — the point at which investment returns contribute more than new savings — is genuinely motivating.

Using the Tracker to Plan Debt Payoff

The liability register in the tracker is most valuable when used actively, not just as a recording mechanism. Add two calculated columns for each loan:

Interest paid this year: Approximate calculation — outstanding principal × interest rate. For a Rs.30 lakh home loan at 9%, you are paying approximately Rs.2.7 lakh/year in interest alone. This number, visible in your tracker, informs how aggressively to prioritise prepayment.

Remaining tenure: Most bank loan portals show this. Enter it in the tracker. As you make prepayments, update the outstanding and recalculate the tenure reduction. A Rs.2 lakh prepayment on a Rs.30 lakh home loan at 9% with 15 years remaining reduces the tenure by approximately 2 years and saves roughly Rs.5–6 lakh in interest over the life of the loan.

A Worked Net Worth Snapshot: Typical Profile at Age 35

To illustrate how all the components come together, here is a sample net worth calculation for a 35-year-old salaried professional in a Tier 1 city:

Assets:

Asset	Value (₹)
Savings account (HDFC)	1,80,000
Liquid fund (emergency)	3,20,000
Equity mutual funds (SIPs since age 27)	18,50,000
ELSS funds (lock-in expired)	4,20,000
EPF balance	8,70,000
PPF balance (7 years)	6,30,000
NPS Tier I	3,40,000
FD (ICICI, 2 years)	2,00,000
Primary home (estimated market value)	65,00,000
Vehicle (current market value)	5,50,000
Total Assets	1,18,60,000

Liabilities:

Liability	Outstanding (₹)
Home loan (HDFC, taken 3 years ago)	52,00,000
Car loan (Axis, 1 year remaining)	2,40,000
Total Liabilities	54,40,000

Net Worth: Rs.1,18,60,000 − Rs.54,40,000 = Rs.64,20,000

Investable Net Worth (excluding home and vehicle): Rs.48,10,000

Annual expenses at this life stage: approximately Rs.8.5 lakh

Milestone analysis: Investable net worth of Rs.48.1 lakh ÷ Rs.8.5 lakh annual expenses = 5.66× — squarely between Milestone 4 (5×) and Milestone 5 (10×). The home loan is the largest liability and is being steadily amortised.

This is a healthy financial picture for a 35-year-old, but it shows why tracking investable net worth separately matters: the Rs.65 lakh home makes total net worth look large, but the actual income-generating, retirement-funding corpus is Rs.48 lakh — a more realistic and actionable number.

Tracking Net Worth Across Life Events

Net worth doesn't grow linearly through life. Certain events cause significant one-time changes that can look alarming in the trend chart but are structurally correct:

Starting a home loan: Your total assets increase by the property value, but total liabilities increase by the loan amount. In the early years, the loan outstanding may exceed the property equity, temporarily suppressing net worth. Over 10–15 years, this inverts as the loan amortises and the property appreciates.

Having a child: Typically reduces net worth temporarily — one income may reduce, expenses increase, and new insurance costs appear. The net worth tracker should reflect this honestly rather than papering over it.

Changing jobs (career break): A break of 6–12 months without income pauses SIPs and may require drawing from savings, creating a visible dip in the trend chart. The important question after returning: how quickly does the net worth recover and resume its previous trajectory?

Inheritance: A one-time step change upward. Log it separately from operational net worth growth so you can distinguish inherited wealth from accumulated wealth — this matters for evaluating whether your own financial system is performing.

These events are visible in the tracker's trend chart. Reading the chart with context — knowing why a dip or step change occurred — is more useful than trying to smooth it out. The honesty of the tracker is what makes it a reliable decision tool.

---

This article is for educational purposes only. It describes a personal finance tracking framework. For investment and financial planning advice, consult a qualified financial advisor.

Putting this into practice

A real example

A simple sheet lists assets — savings ₹1.5 lakh, mutual funds ₹9 lakh, EPF ₹9 lakh, gold ₹2 lakh — against liabilities — home loan ₹34 lakh, car loan ₹3.2 lakh. Net worth reads −₹15.7 lakh, and the quarterly trend reveals the real question: is the home loan shrinking faster than the assets are growing?

A common mistake

Building a 50-tab model you update once and abandon, or valuing assets optimistically so the number flatters you.

When this doesn't apply

Don't over-engineer this. A ten-line sheet updated four times a year beats an elaborate model updated never. If precision is getting in the way of consistency, simplify.

Jay's operating note: The best net-worth tracker is the one you'll actually open four times a year. Consistency matters far more than precision.

Your decision checklist

• One sheet: assets in one block, liabilities in another
• Assets entered at realistic resale value
• Updated on the same date each quarter
• A single cell computes net worth = assets − liabilities
• A trend column or small chart to watch direction
• Review it quarterly, not daily