How to Build a Quarterly Net Worth Spreadsheet That Holds Up for a Year

I have watched a lot of engineers spend two weekends building a personal finance system and then abandon it by quarter two. The pattern is the same as in side projects: ambition outruns the maintenance budget, the system rots, the data stops being trustworthy, and the whole thing slides into the same drawer as the abandoned home automation project.

This is a walkthrough of how to build a quarterly net worth spreadsheet workflow that is boring enough to survive. The whole thing is one tab, eight rows, and a small habit. If the workflow is more complicated than that, it will not last twelve months.

Photo by Connor Scott McManus on Pexels

What the spreadsheet actually needs to do

Three things, in this order:

1. Capture a small set of inputs per quarter so the quarterly snapshot takes ten minutes.
2. Produce four output numbers: net worth, liquidity ratio, debt-to-asset ratio, and percentile.
3. Plot a trendline of the headline metric across at least four quarters.

That is the whole spec. Everything else is feature creep that increases the chance you abandon the workflow.

Step 1: lay out the columns

One row per quarter. Columns:

• quarter_label (Q1 2026, Q2 2026, ...)
• snapshot_date (the actual day you ran it)
• assets_liquid (checking, savings, taxable brokerage, money market)
• assets_retirement (401(k), IRA, Roth IRA, HSA, pension cash value)
• assets_real_estate (current realistic home value minus selling costs)
• assets_vehicles (sum of trade-in values)
• assets_other (business equity, crypto, anything else)
• liabilities_secured (mortgage, HELOC, auto)
• liabilities_unsecured (credit cards, student loans, personal loans)
• monthly_expenses (your realistic monthly burn)
• notes (one or two sentences of context for the quarter)

That is eleven inputs plus the label and date. The four output columns come from formulas.

Keep the same column order every quarter. Resist the urge to add columns. The amount of data you actually need is the amount that fits on a small phone screen.

Step 2: write the four formulas

Net worth is straightforward:

net_worth = assets_liquid + assets_retirement + assets_real_estate
          + assets_vehicles + assets_other
          - liabilities_secured - liabilities_unsecured

Liquidity ratio:

liquidity_ratio = assets_liquid / monthly_expenses

Debt-to-asset ratio:

debt_to_asset = (liabilities_secured + liabilities_unsecured)
              / (assets_liquid + assets_retirement
                 + assets_real_estate + assets_vehicles + assets_other)

Percentile is the one formula you cannot reasonably do in a sheet without an interpolation table from the Survey of Consumer Finances. Two practical options: either skip it and rely on the trendline plus the ratios, or copy the percentile from a tool like https://evvytools.com once per quarter when you do the snapshot. Either is fine; the trendline is doing most of the work.

Step 3: pick how you will value the squishy categories

Three categories are squishy and will silently drift if you do not commit to a rule.

Home value. Pick a single source and stick with it. The lower of two algorithmic estimates minus 6 to 8 percent for selling costs is the convention. Picking the optimistic one one quarter and the conservative one the next produces a fake trendline.

Vehicle value. The Kelley Blue Book trade-in number is the conservative honest number. Use that consistently across quarters. Do not switch to private-party value when you want a bigger number.

Business equity. If you own a private business, either pick a conservative trailing-earnings multiple and document the rule, or omit it entirely from net worth and track it separately as a memo line. Including a paper enterprise value silently inflates the trendline.

The rule for all three: pick a methodology you can replicate, and commit to using it for at least four quarters. The trendline is the signal; arbitrary methodology changes destroy it.

Photo by Walls.io on Pexels

Step 4: define the quarterly run as a checklist

The point of the checklist is that running the snapshot becomes routine, not a project. Write it once and follow it every quarter.

1. Open every asset account in tab groups (bank, brokerage, retirement). Copy balances into the sheet.
2. Open every liability account. Copy balances.
3. Update the home value using the agreed methodology. Update vehicle trade-ins.
4. Look at the last three months of credit card and checking statements; estimate realistic monthly expenses.
5. Write one or two sentences of context for the quarter in the notes column.
6. Verify the four formulas produced sensible numbers.
7. Save the file.

A reliable thirty-minute workflow the first quarter, and a reliable ten-minute workflow every quarter after that.

Step 5: build the trendline chart

The chart is just net_worth plotted against snapshot_date. Linear. No smoothing. One line.

After two snapshots you have a slope. After four you can see whether the slope is steady or changing. After eight you have two years of data and the trendline is doing real work; small habit changes are visible as slope changes.

Add a second line for liquidity_ratio if it helps you read the chart, but keep the chart spare. The dashboard you maintain is the dashboard that survives. Three lines maximum.

Step 6: review on a fixed day

Pick a recurring day each quarter and put it in your calendar with a non-negotiable label ("net worth snapshot, 30 min, do not skip"). The first weekend of the month after each quarter ends works.

The fixed-day pattern is what separates this from "I will track my finances when I get to it." Tracking finances when you get to it is a hobby; tracking them on a fixed cadence is instrumentation.

What the trendline catches

Things this spreadsheet has caught in real practice:

• A 2 percent annual raise that disappeared into lifestyle inflation (net worth flat across four quarters despite higher income).
• A car loan rollover that quietly added $8,000 in liabilities without registering as a "big decision."
• A retirement contribution mistake (capped at the default 3 percent for two years after starting a job) that showed up as a slope that was too gentle for the income.
• A medical bill in collections that nobody had thought about for eighteen months.

In each of those cases, the individual statements showed nothing wrong. The trendline made it obvious.

Reference sources worth pinning

A small set of canonical references makes the spreadsheet more trustworthy:

• The Consumer Financial Protection Bureau for plain-language regulatory guides on credit, mortgages, and consumer protections.
• The Federal Reserve's Survey of Consumer Finances for the household wealth distribution behind any percentile lookup.
• The FDIC for deposit insurance limits and the relevant cap reference when sizing liquid buffers.
• KBB above for vehicle valuations.

Pin them in a references cell at the top of the sheet. You will use them less than you think and be glad they are there when you do.

The longer read on interpreting the numbers

This piece is the build instructions. The interpretation, including how to read the percentile result without panicking or getting complacent and how to act on the ratios, sits in a longer guide on telling if your net worth is on track for your age that pairs well with the spreadsheet workflow.

The spreadsheet is the system you operate. The longer guide is the runbook for what to do when the metrics tell you something.