Net Worth Tracker: How to Calculate and Track It Month by Month in Google Sheets

Net Worth Tracker: How to Calculate and Track It Month by Month in Google Sheets

Capture dated snapshots for each account in Google Sheets, roll up assets and liabilities with SUMIFS, compute net worth and delta, and visualize trends with a chart. Use IMPORTRANGE to link Aspire or choose a one-time template for single snapshots.

Net worth equals total assets minus total liabilities. In Google Sheets, capture a dated snapshot each month, roll up account balances into asset and liability totals, compute net worth, and chart the trend. The sheet should produce a monthly net worth column, a month-to-month delta column, and a simple trend chart for quick inspection.

What to include (assets, liabilities, and valuation rules)

Items to track

• Assets: cash and checking, savings, brokerage, retirement accounts, real estate (market value), business equity, cash value life insurance, and other investments.
• Liabilities: mortgage principal, student loans, car loans, credit card balances, personal loans, and other outstanding principal.

Valuation rules (be consistent)

• Market versus book value: use market value for investments and property for an up-to-date net worth. Use book value for illiquid or hard-to-price holdings if you prefer conservative reporting, and note that choice in the ledger.
• Joint accounts: record the full balance and annotate ownership splits in a note column if you need your personal share.
• Illiquid assets: use the best available estimate and explain the method in notes.
• Monthly valuation date: pick one date each month, for example the last business day, and use it across all accounts. Consistency matters more than exact timing.

Setup in Google Sheets (Accounts tab + Monthly Ledger tab)

Sheet structure

• Tab 1: Accounts — a running register of account balances and values over time.

  • Example columns: Date, Account, Category, Value, Notes.
  • Each snapshot adds rows with the snapshot date and account value so you can SUM by date and category.

• Tab 2: Monthly Ledger — one row per month with summary totals and net worth.

  • Example columns: Snapshot Date (A), Total Assets (B), Total Liabilities (C), Net Worth (D), Delta (E).

Creating the Accounts register

• Keep Accounts as raw input. Every month add rows like 2026-09-30, "Chase Checking", "Cash", 12345, "reconciled". That lets you SUM by date.

Formulas to roll up totals

• If you use separate Asset and Liability sheets you can use simple sums such as:
  • =SUM(Assets!C2:C)
  • =SUM(Liabilities!C2:C)
• If you use the Accounts register, use SUMIFS to pick values for the snapshot date and category. Example patterns:
  • Total Assets in Monthly Ledger row 2 (B2): =SUMIFS(Accounts!Value, Accounts!Date, $A2, Accounts!Category, "<>Liability")
  • Total Liabilities in Monthly Ledger row 2 (C2): =SUMIFS(Accounts!Value, Accounts!Date, $A2, Accounts!Category, "Liability")

Monthly snapshot formula pattern

• If you prefer month-end lookups, an example is: =SUMIFS(Accounts!Value, Accounts!Date, EOMONTH($A2,0)) Adjust this if your Accounts!Date entries are literal snapshot dates.

Net worth and delta

• Net worth (D2): =B2-C2
• Month-to-month delta (E3 compared to prior month): =D3-D2 Use the actual column where you put Net Worth in your sheet.

Worked example layout

• Accounts tab headers: A2: Date, B2: Account, C2: Category, D2: Value, E2: Notes. Fill rows with snapshots.
• Monthly Ledger example rows:
  • A2: 2026-01-31, B2: (formula to sum assets for 2026-01-31), C2: (formula to sum liabilities for 2026-01-31), D2: =B2-C2, E2: (blank for first month)
  • A3: 2026-02-28, B3: sum formula for that date, C3: sum liabilities, D3: =B3-C3, E3: =D3-D2

A note about ranges

• Use open-ended ranges like Accounts!D2:D so new rows are included automatically.

Visualizing month-to-month change

Charts and a compact summary table

• Create a trend chart: select Monthly Ledger dates and Net Worth, Insert chart, choose Line chart, and add axis labels.
• Add a small summary table with Month, Net Worth, Delta, and % Change. Populate cells with formulas that reference Monthly Ledger. For example percent change can use a delta divided by the prior net worth, adjusting references as needed.

Conditional formatting and sparklines

• Highlight negative deltas red and positive deltas green.
• Add a sparkline: =SPARKLINE(range_of_net_worth)

Placement

• Put the last 12 months table and chart side by side on a Dashboard tab or on Monthly Ledger for a compact view.

Integrating with the Aspire Budgeting Spreadsheet and one-time templates

Linking to Aspire

• Use IMPORTRANGE to bring balances from Aspire into Accounts. Example: =IMPORTRANGE("spreadsheet_url","Sheet1!A2:D") then map imported rows to your Accounts layout or use the imported rows directly in SUMIFS.
• Manual copy is fine if you export monthly from Aspire or your bank and paste values into Accounts with the snapshot date.

Continuous tracker versus one-time template

• Continuous tracker: ongoing snapshots, live links, and a historical time series. Use IMPORTRANGE or scripts for automation. Best if you want habit and history.
• One-time template: a single snapshot with simple inputs. Use a single-sheet template when you only need a net worth number for a report or application, then archive or discard it.

Which to choose

• Choose a continuous tracker for ongoing monitoring and a one-time template for occasional snapshots.

Best practices, automation, and maintenance checklist

Monthly routine

• Reconcile accounts on your chosen valuation date.
• Confirm imported values match provider statements.
• Add a note column for out-of-period or estimated values.

Automation options

• Use IMPORTRANGE for workbook links, IMPORTDATA for CSV feeds, and IMPORTXML for simple public endpoints.
• For heavier automation, Google Apps Script can fetch authenticated APIs, but that requires credentials and more maintenance.

Safety and sharing

• Never paste bank credentials into Sheets. Grant access only to people you trust and prefer read-only links for viewers.

Maintenance checklist

• Reconcile monthly, confirm valuation date, annotate estimates, back up a copy quarterly, and archive old versions if needed.

FAQ

Q: How should I value retirement accounts that show different reporting dates?

A: Use the providers most recent statement or your chosen monthly valuation date and annotate any out-of-period valuations in the ledger so readers know when values arent same-day.

Q: Can I automatically pull bank balances into Google Sheets?

A: Google Sheets can import data from linked APIs or CSV exports and functions like IMPORTRANGE/IMPORTDATA can help, but many institutions require third-party tools or manual exports, explain trade-offs and security considerations.

Q: How do I treat loan principal versus interest for net worth tracking?

A: Count the outstanding loan principal as a liability; track interest separately in budgeting or in Aspire if you want to analyze cost but dont mix interest expense into the liability balance.

Q: Is it better to keep the tracker in the same workbook as my budget?

A: It depends, linking keeps data in one place and simplifies reconciliation, while a separate workbook reduces accidental changes, give guidance on when to combine versus separate and how to link safely.