Net Worth Tracker in Google Sheets: Build It Honest on Both Sides

Why Net Worth Is the Right Metric to Track

Income can be high and wealth still minimal if spending keeps up. An 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. I learned this lesson on the business side long before I ever tracked it personally: a balance sheet full of assets, stock and machinery can look substantial while the liabilities on the other side quietly eat into it. The spreadsheet only tells the truth if you are honest about both columns, not just the one that feels good to look at.

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.

For a quick one-off figure before you build anything, the net worth calculator does the arithmetic.

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 thorough: 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 it is really 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:

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 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. The net worth milestones framework turns that into checkpoints you can put in the same sheet.

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.

A Limit Is Not Money

One of the mistakes I watched other business owners make, and worked to avoid at our mill, was treating the cash credit limit as if it were profit: spending against the sanctioned ceiling as though it were the business's own money. A limit is permission to borrow. Every rupee drawn against it is a liability, and it starts costing interest the day it is drawn.

Households make the same mistake in smaller sizes. A credit card limit, a pre-approved personal loan, an overdraft against an FD, a Buy Now Pay Later line: none of these belongs on the asset side of your tracker. The unused part is not wealth, and the used part goes on the liability side the day you draw it. If your tracker has a row called "available credit", I would delete it.

The other half is the reconciliation the mill runs on. The balances in your tracker should match the statements they came from: the bank balance to the bank statement, the fund value to the CAS, the loan outstanding to the lender's statement. A net worth figure built from memory is an estimate; one built from statements is a number you can decide with.

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 (it becomes inoperative only if it lies unclaimed for 36 months after you retire after 55, settle abroad or die) 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. NPS invests across equity (E), corporate bonds (C), and government securities (G) based on your allocation choice, and 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:

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 motivating.

Using the Tracker to Plan Debt Payoff

The liability register 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 ₹30 lakh home loan at 9%, you are paying approximately ₹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 ₹2 lakh prepayment on a ₹30 lakh home loan at 9% with 15 years remaining reduces the tenure by approximately 2 years and saves roughly ₹5–6 lakh in interest over the life of the loan. The loan prepayment strategy guide covers when prepaying beats investing.

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:

Liabilities:

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

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

Annual expenses at this life stage: approximately ₹8.5 lakh

Milestone analysis: Investable net worth of ₹48.1 lakh ÷ ₹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 ₹65 lakh home makes total net worth look large, but the actual income-generating, retirement-funding corpus is ₹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 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.

One More Example: When the Number Starts Negative

Say a simple sheet lists savings of ₹1.5 lakh, mutual funds of ₹9 lakh, EPF of ₹9 lakh and gold of ₹2 lakh against a home loan of ₹34 lakh and a car loan of ₹3.2 lakh, and leaves the house itself off the asset side. Net worth reads −₹15.7 lakh. That negative is not a verdict, because the house is missing; what the quarterly trend reveals is the real question: is the home loan shrinking faster than the other assets are growing?

Keep It Small Enough to Keep

The common failure is not a wrong formula. It is building a 50-tab model you update once and abandon, or valuing assets optimistically so the number flatters you.

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. The best net worth tracker is the one you will actually open four times a year, and I would take consistency over precision every time.

Your Setup 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

This tracker shows you where you stand; it does not tell you what to do about it. For decisions on asset allocation, debt payoff order, or anything with real money behind it, that call is worth making with a SEBI-registered investment adviser or your CA, not a spreadsheet.