Net Worth Statement Template
Use the workbook's Net Worth sheet to organise a dated list of assets and liabilities. It is a starting point for your own records, not an official lender, legal, tax, or government form.
Want to compare your balances month by month? Use the free Excel net worth tracker template and its monthly history sheet. This page focuses on preparing a dated statement.
- Editable Asset & Liability Rows
- Automatic Net Worth Calculation
- 57 Inspected Workbook Formulas
- Manual Monthly History and Trend Chart
- Asset Allocation Sheet and Chart
- No Built-In Bank or Market-Data Connection
No email or account required. Replace every fictional sample balance before use.
Illustrative dated snapshot
Net Worth
As of June 30, 2026
Assets
Liabilities
Inspected workbook · 19 September 2026
What is actually in the free workbook
We inspected the exact Basic XLSX served by this site. It contains four worksheets: Net Worth, Monthly History, Asset Allocation and Instructions. Its formulas calculate asset and liability totals, month-to-month changes, net worth and allocation; two charts show history and allocation. A representative input change also recalculated correctly in a disposable LibreOffice copy. The published download was not changed.
| Checked | What we observed | Boundary |
|---|---|---|
| Balance sheet | Assets minus liabilities feeds the current and prior net-worth totals. | Replace every fictional sample balance before personal use. |
| Monthly review | The history sheet has 24 dated rows, net-worth formulas and a trend chart. | You copy totals into history manually. Blank future rows calculate as zero and the chart plots them, so do not treat unused rows as observed history. |
| Allocation | Cash, investment, property and other-asset rows feed percentages and a chart. | This is an asset mix, not investment advice or holding-level analysis. |
| Connections and currency | The workbook has no bank feed or live market-data connection. | Use one reporting currency. Convert mixed-currency balances before entry and record the rate/date separately. |
| Recalculation check | Changing one current balance by 1,000 increased total assets and net worth by 1,000 in LibreOffice; 57 formulas and two chart objects remained present. | This is a representative LibreOffice check, not certification of every edit or every Excel version. |
| Google Sheets conversion | The exact XLSX converted into a private QA Sheet with four tabs, 57 formulas, no formula errors and both chart objects present. | Visual round-trip comparison found that the allocation legend text and monthly chart category labels were lost. Verify or rebuild those labels. The private QA copy is not the public template. |
A working balance sheet, not an official form
This page serves the same inspected Basic XLSX as the Excel tracker owner. Use its Net Worth sheet to organise a dated snapshot. If a lender, adviser, court or public body requires a statement, follow that recipient's form, evidence and signature rules.
When You Need a Net Worth Statement
A net worth statement is your personal balance sheet. It shows exactly what you own, what you owe, and the difference. Here's when it matters most.
Preparing for a Loan Application
Use the workbook to assemble dated balances before an application. A lender may require its own form, supporting statements, valuation method, or signatures, so follow the lender's instructions rather than submitting this file by default.
Financial Planning
Use one as-of date and note the source of each balance or estimate. If you share the file with an adviser, confirm what information they need and remove identifiers they did not request.
Legal or Administrative Preparation
A professional or public body may ask for an asset-and-liability inventory. This workbook can help you gather figures, but it is not a legal form and does not replace the recipient's requirements or professional advice.
Gather dated balances before filling the statement
Use balances from the same date where possible. Record the source and date for estimates so a reader can distinguish statement balances from property, business, vehicle, or collectible valuations.
Current statements
Collect recent bank, investment, retirement, mortgage, loan, and card balances. Use the outstanding liability, not the original amount borrowed.
Valuation notes
For assets without a daily market price, note the estimate date, method, and source. Keep uncertain values visibly separate from cash and quoted investments.
Recipient requirements
If a lender, adviser, court, or public body requested the statement, follow its required form and instructions. This workbook is a starting point, not a substitute for those requirements.
Avoid adding account numbers, passwords, or login credentials. Confirm the recipient and their approved transfer method before sharing a completed file.
Match the template to the job
The right route depends on whether you need a dated working snapshot, recurring monthly history, or a browser-accessible copy. A third-party form remains a separate requirement.
Dated working snapshot
Use the inspected workbook to assemble assets, liabilities, and a calculated total as of one date. Transfer the results to a recipient's required form when one is provided.
Private monthly tracking
Choose the Excel net worth tracker when you want an offline file, editable categories, and a history sheet for monthly comparisons.
Shared or cloud-based tracking
Use the Google Sheets version when browser access and sharing matter more than keeping the workbook solely on one device.
Before you use any template: confirm that it keeps assets and liabilities separate, records the valuation date, shows the assets-minus-liabilities calculation, and lets you explain estimates for property, private businesses, or other assets without a daily market price.
Frequently Asked Questions
Common questions about net worth statements.
What is a net worth statement?
A net worth statement is a dated list of assets and liabilities that calculates assets minus liabilities. A lender, adviser, court, or public body may require its own form, valuation rules, evidence, and signatures.
What should I include on a personal net worth statement?
Assets include: cash and bank accounts, investments (stocks, bonds, mutual funds), retirement accounts (401k, IRA, pension), real estate at current market value, vehicles, business interests, and personal property of significant value. Liabilities include: mortgages, car loans, student loans, credit card debt, personal loans, tax obligations, and any other money owed.
When do I need a formal net worth statement?
A third party may request one for lending, advice, legal, estate, or administrative work. Follow the recipient's required form and instructions; this workbook is only a starting point for organising balances.
How is a net worth statement different from a net worth tracker?
A net worth statement is a snapshot at one point in time. A tracker records a series of snapshots to show change. The downloadable workbook contains a Net Worth sheet and a manually maintained Monthly History sheet; it is not an official third-party form.
Should I include my primary home in my net worth?
For a personal calculation, a home can be recorded as an asset and its mortgage as a liability. If someone else requested the statement, use that recipient's valuation and inclusion rules. The workbook has editable rows but does not calculate a separate investable-net-worth figure unless you adapt it.
Related Templates
More tools to track and grow your wealth.
Net Worth Tracker (Excel)
Track your net worth over time with monthly snapshots and charts.
Google Sheets Net Worth Tracker
Upload the XLSX for browser access and sharing, then verify the total and both charts after conversion.
How to Calculate Net Worth
Step-by-step guide to what to include and exclude.
Want an App Instead?
Download the inspected workbook for manual use, or compare the PopaDex app when recurring updates and compatible account connections would save time. Connection availability varies by institution and account type.
Standard
Free manual net-worth tracking in one consistent currency
- Privacy-first
- Dark mode
- Manual aggregation
- Monthly snapshots
- Community access
- AI assistant access via MCP (public tools)
Premium
For multi-currency tracking and automated connections with supported institutions
- Everything in Standard
- Automated connections at supported institutions
- Multi-currency support
- Advanced insights & analytics
- AI Finance Copilot for your PopaDex portfolio
- Couples accounts
- Priority customer support
Check the price, billing interval and cancellation terms at checkout. Read plan details.
Not ready to commit? Try the interactive demo
What a personal financial statement contains
A personal financial statement is a dated list of assets, liabilities, and the resulting net worth. Enter liquid accounts, investments, and realistically valued property on the asset side. Enter the outstanding balance of each mortgage, card, or loan on the liability side. Net worth equals total assets minus total liabilities; annual income belongs in a separate cash-flow section, not in the asset total.
For a basic worked balance sheet, consider $20,000 cash, $80,000 investments, and a $300,000 home against a $240,000 mortgage and $10,000 other debt. Assets total $400,000, liabilities total $250,000, and net worth is $150,000. The same template can be adapted to these eight situations. All figures below are fictional USD illustrations; use a single valuation date and show the original currency if an account is held elsewhere.
1. Basic household
$20,000 cash + $80,000 investments + a $300,000 home = $400,000 in assets. A $240,000 mortgage + $10,000 other debt = $250,000 in liabilities. Net worth: $150,000. Update loan balances and asset values, rather than reusing original purchase or loan amounts.
2. Comprehensive asset valuation
Suppose a household has $35,000 cash, $190,000 investments, a home valued at $420,000, and a $20,000 vehicle: $665,000 in assets. With a $275,000 mortgage and $8,000 vehicle loan, net worth is $382,000. Label the home and vehicle valuation sources and dates. An estimate is less certain than a current account statement; do not present the total as an appraised sale price.
3. Young professional with student debt
$6,000 cash + $18,000 retirement savings = $24,000 in assets. A $31,000 student-loan balance and $2,000 card balance make liabilities $33,000, so net worth is negative $9,000. The negative number is a starting snapshot. Track the loan balance, emergency cash, and retirement contributions separately so progress is visible even when the total is below zero.
4. Dual-income couple
Partner A has $30,000 in individual assets and Partner B has $45,000; they jointly hold $25,000 cash and a $400,000 home. Total household assets are $500,000. A joint $280,000 mortgage plus $15,000 in individual loans leaves $205,000 household net worth. Keep ownership labels on every line; a household view should not silently change legal ownership.
5. Property-heavy household
A primary home worth $500,000 and a rental worth $250,000, plus $40,000 cash, create $790,000 in assets. Mortgages of $330,000 and $175,000 create $505,000 in debt, giving $285,000 net worth before selling costs or tax. Keep one row for each property and mortgage; the rental’s equity is $75,000, not its $250,000 market value.
6. Business owner
Personal cash of $25,000, investments of $70,000, and a documented $150,000 estimate of ownership equity in a business total $245,000 in assets. Against $20,000 personal debt, net worth is $225,000. Do not add the business’s cash again if it is already reflected in the equity estimate. A personally guaranteed business loan may need a separate risk note even when it is not a current personal liability.
7. Pre-retirement household
$55,000 cash + $600,000 retirement accounts + $120,000 taxable investments + $350,000 home = $1,125,000 in assets. A $125,000 mortgage gives $1,000,000 net worth. The total does not mean $1 million is immediately spendable: separate accessible cash from retirement accounts and home equity, and keep future pension income in a planning worksheet rather than adding it as a current asset without a defensible present value.
8. Debt-focused household
$9,000 cash + a $16,000 car = $25,000 in assets. A $12,000 car loan, $8,000 card balance, and $23,000 student loan total $43,000 in liabilities, so net worth is negative $18,000. List each debt’s current balance alongside its interest rate and minimum payment in a separate payoff schedule. Paying $1,000 of principal improves net worth by $1,000 if other values do not change.