How to Build a Personal Balance Sheet in Google Sheets

Quick answer. Assets = Liabilities + Net worth. That is the entire balance sheet. In Google Sheets it becomes a list of accounts and balances on two tabs and one subtraction formula (=B-C) on a third. The Net Worth Tracker is the same sheet repeated month after month with a chart on top.

A balance sheet sounds corporate. The term comes from accounting and historically lived in ledger books at companies, not on kitchen tables. The math is identical for an individual: what you own minus what you owe, on a given date.

The reason to build one for yourself is the same reason companies do. A balance sheet shows your financial position at a single point in time, with no opinions, no projections, no “should.” It’s a snapshot. Once you have one, you have a baseline. Once you have a baseline, the next one becomes a comparison.

This guide walks through the build from scratch: tabs, categories, formulas, a worked example, and the monthly routine that keeps the sheet useful instead of stale.

The accounting equation, translated for personal finance

The textbook version is:

Assets = Liabilities + Equity

For a company, equity is what owners would have left if every asset were sold at book value and every debt paid. For an individual, equity is just your net worth. So the personal version reads:

Net worth = Assets - Liabilities

Same equation, rearranged. That single line is the entire purpose of the sheet. Everything else - the categories, the formatting, the chart - exists to make that one number trustworthy and easy to update.

If you want the long-form derivation of the formula and a worked example with named dollar amounts, the companion piece How to Calculate Your Net Worth covers it. This article focuses on the Google Sheets build.

Setting up the file

Open a fresh Google Sheets file. Name it something you’ll find in six months, like “Personal Balance Sheet 2026.”

Create three tabs at the bottom:

1. Assets - one row per account or holding
2. Liabilities - one row per debt
3. Summary - totals and net worth

Three tabs is enough. Some people use one. We keep them separate because asset rows and liability rows have different cadences (investments move daily, mortgages monthly), and it’s easier to scan a single category at a time.

On each tab, freeze row 1 so the headers stay visible when you scroll. View -> Freeze -> 1 row.

Asset categories

Six categories cover most personal balance sheets. List them in roughly liquidity order, most liquid first.

Cash and equivalents

• Checking accounts
• Savings accounts (high-yield or otherwise)
• Money market funds
• Physical cash worth tracking (skip anything under $200)

Taxable investments

• Brokerage accounts
• Crypto (use today’s value; expect it to move)
• Treasury direct holdings
• HSAs being used as investment accounts

Retirement accounts

• 401(k), 403(b), TSP
• Traditional IRA, Roth IRA
• SEP IRA, SIMPLE IRA, solo 401(k)
• Pension lump-sum present value, if vested and quotable

Real estate

• Primary residence at current market value (Zillow, Redfin, or a recent appraisal)
• Rental properties
• Land

Vehicles

• Cars, motorcycles, RVs at Kelley Blue Book private-party value
• Boats

Other

• Vested employer equity (RSUs at current share price, options at intrinsic value)
• Equity in a private business, if you have a recent valuation
• Collectibles, only if you’d realistically sell them, at realistic prices

Most personal items - furniture, clothing, electronics, jewelry you wear daily - get excluded. They depreciate fast and don’t have a clean market value. Including them tends to inflate the balance sheet without adding signal.

For the Assets tab, use these columns:

Date matters more than people expect. Real estate and vehicle values drift; refreshing them quarterly or annually is fine, but the date column tells you when each number was last current.

Liability categories

Liabilities are the principal balance owed, not the monthly payment.

• Mortgage (current outstanding balance, not original loan amount)
• HELOC balance
• Auto loans
• Student loans (federal and private)
• Credit card balances (actual balance, not credit limit)
• Personal loans
• Tax debt
• Medical debt in collections or on a payment plan
• Money owed to family or friends, even at zero interest

Recurring bills you pay on schedule - rent, utilities, subscriptions, insurance premiums - are not liabilities. They’re expenses. A liability is a principal balance you owe. If your rent is $2,000 next month, that’s a future expense, not a debt on your balance sheet today.

Use the same column structure as Assets:

The formulas

Three formulas run the whole sheet.

On the Assets tab, in a totals row at the bottom of column D:

=SUM(D2:D)

The open-ended D2:D lets you add new asset rows without updating the formula. Useful when you open an HSA next year and want to drop it in.

Same on the Liabilities tab:

=SUM(D2:D)

On the Summary tab, set up three labelled rows (we’ll use rows 5, 6, and 7 to leave room for a title and a date at the top):

That =B5-B6 is the entire balance sheet. Every other cell on the sheet exists to feed it.

A sample balance sheet

Here is a fully populated example using placeholder numbers. Copy this structure and replace the figures.

Assets (as of June 1, 2026)

Liabilities (as of June 1, 2026)

Summary

That’s a complete personal balance sheet. Twenty-five cells of data, three formulas, one number at the bottom.

Conditional formatting for trend visibility

The single net worth number is useful. The change month over month is more useful.

On the Summary tab, add column C for last month’s net worth (you’ll copy this month’s number into C7 at the next update). Then add column D for the difference:

D7: =B7-C7

Apply conditional formatting on D7: green if positive, red if negative. Format -> Conditional formatting -> Single color, “is greater than 0” and “is less than 0” rules.

The first month, the comparison cell will be blank. After month two, it shows the dollar change. After month twelve, you have a year of monthly deltas, which is what most people want from a balance sheet over time.

The monthly update routine

Block 15 to 30 minutes once a month. A repeating day tends to stick - the first weekend of the month, payday, or anything you’ll remember.

The routine, in order:

1. Open the sheet.
2. Log in to each financial institution where you hold an asset or a debt. Copy current balances into column D.
3. Update the date column to today’s date.
4. Spot-check the Summary tab. The net worth number should be in the same neighborhood as last month, give or take normal market movement. If it’s wildly off, you mistyped something.
5. Before closing, copy this month’s net worth from B7 into C7 so next month’s difference cell has a comparison value.

The bottleneck is logging in to accounts, not the spreadsheet itself. Once your password manager is set up and you know which accounts matter, the actual data entry takes about five minutes.

Real estate and vehicle values don’t need a monthly refresh. Update them quarterly or annually using Redfin, Zillow, or KBB. Leaving the same number for three months is fine; the dating column tells you when it was last current.

For people who want this automated, the companion piece on automating net worth updates in Google Sheets walks through GOOGLEFINANCE, IMPORTHTML, and a couple of API tricks.

Common balance sheet mistakes the first time

A few patterns show up in almost every personal balance sheet first draft.

Including stuff that isn’t liquid. Listing a sofa at $850 and the gas grill at $400 doesn’t help. You’d never sell them at those prices, and you’d lose half to a buyer’s market if you tried. The convention is to exclude depreciable personal items.

Counting the credit card limit as a liability. The liability is the balance, not the limit. A $20,000 limit with a $1,400 balance is a $1,400 liability.

Forgetting 401(k) loans. If you’ve borrowed from your 401(k), the loan is a liability. The remaining 401(k) balance is the asset. Some statements net these; for the balance sheet, keep them separate so you can see the gross.

Double-counting joint accounts. Couples often track separately for a while, then realize the joint savings account got added on both sheets. Pick a convention: split 50/50, attribute to one partner, or move to a combined household sheet. The detailed tradeoff is covered in the piece on combined vs separate tracking for couples.

Using purchase price for cars. A car loses value every year. Use Kelley Blue Book private-party value, not what you paid in 2021.

Treating future income as an asset. A pension you’ll collect in 20 years isn’t a current asset unless it has a quotable present value today. Social Security and expected raises belong in retirement planning, not on this sheet.

Snapshot or tracker

A personal balance sheet is a snapshot. A net worth tracker is the same balance sheet repeated over time with the deltas visualized.

If you only want today’s number, one tab and one formula is enough. The three-tab structure above works. You’ll get one number, you’ll know where you stand, and you can come back next quarter.

If you want the trend, you need either monthly columns added to the same file or a dedicated tracker. A trend includes the line going up and to the right most months, the dip when the market drops, and the recovery a few months later.

Three signs you’re ready for a tracker rather than a snapshot:

1. You’ve kept a balance sheet for two or three months and find yourself wanting to compare them.
2. You’d rather see a chart than do mental math from a list of numbers.
3. You want benchmark context - how your number compares to age-bracket medians, for instance.

When that happens, copying month-by-month columns into a single sheet works for a while, but it becomes awkward past 12 columns. A purpose-built template handles it more cleanly.

Templates that fit

If the by-hand build runs out of room, three of our templates pick up where it stops:

• Personal Financial Statement (Essentials) - A formal, print-ready balance sheet in the standard format banks accept. The version that gets attached to a mortgage application or business credit line.
• Net Worth Tracker - The balance sheet repeated month after month, with a 12-month trend chart, account-level history, and age-bracket benchmarks. $35 once.
• Financial Planning Spreadsheet - A 40-year life projection layered on top of the balance sheet, with net worth, cash flow, and retirement timing in one file.

For a first balance sheet, building it by hand once teaches the structure. By the time the manual version starts to feel limiting, the case for a template makes itself.

Related

• How to Calculate Your Net Worth (Formula, Example, Template)
• How to Calculate Your Net Worth in Google Sheets (Step-by-Step)
• Free Net Worth Tracker Spreadsheet: Download, Walkthrough, and 3 Alternatives