Start with a complete inventory
List the places where your wealth lives. Include bank and brokerage accounts, pensions, crypto, property, private investments, businesses, cash and valuable physical assets.
Then list liabilities. A net worth view without debt is an asset total, not a financial position.
Choose one home currency
Keep the original currency of every account, but choose one currency for your combined view. Historical snapshots should use historical exchange rates; applying today’s rate to the past silently rewrites your financial history.
Decide how you will value physical assets
Use a repeatable source and avoid updating illiquid assets based on every optimistic market headline. Monthly or quarterly estimates can be sufficient depending on the asset.
Record contributions separately
A portfolio that grew because you added money did not necessarily perform well. Track deposits and withdrawals when you want to measure the investment return behind the balance.
Close the month
Pick a regular date, update the important balances, and record a snapshot. Then ask:
- What changed?
- Why did it change?
- Did the change move me toward my goal?
- What deserves attention next?
The review is where tracking becomes useful.
Create rules before the first update
Decide what you will include, which date closes the month and where each valuation comes from. For example, use the final business day of every month, the lender’s current mortgage balance and one consistent property estimate.
These rules remove unnecessary decisions from future reviews. They also prevent a good or bad month from influencing how optimistically you value an asset.
Organize accounts by institution and purpose
Separate the institution from the account held there. One bank may contain a checking account and savings account; one broker may contain several investment products. This structure makes institution concentration visible without losing account-level detail.
Record the original currency of each holding. A combined home-currency view is useful, but the underlying currency remains necessary for understanding exchange-rate exposure.
Handle assets that do not update monthly
Not every asset needs a new valuation every month. A private company or piece of art may remain unchanged until credible information becomes available. Record the date and source of the estimate rather than manufacturing movement.
For property, choose a conservative repeatable approach. Updating quarterly can be more honest than reacting to every nearby listing.
Review quality before chasing precision
A good system is complete enough to guide decisions and simple enough to maintain for years. An estimate consistently applied is often more useful than a theoretically perfect number that makes you abandon the process.
Check for duplicate holdings, missing liabilities, stale values and unexplained jumps. If a balance changed substantially, note whether it came from a contribution, withdrawal, valuation change, market return or currency movement.
Frequently asked questions
Can I track net worth in a spreadsheet?
Yes. A spreadsheet is flexible, but you are responsible for the structure, formulas, historical rates and maintenance. See Hugo vs spreadsheet for a practical comparison.
Should balances be updated on exactly the same date?
Aim for a consistent monthly window. Small timing differences are usually less important than maintaining the habit, but large market-sensitive portfolios benefit from closer alignment.
How do I correct a historical mistake?
Correct the source value when possible and document the reason. Avoid silently changing methodology across the timeline.
Do I need daily transaction data?
No. Net worth tracking needs reliable balances and valuations. Daily transaction feeds answer a different question, as explained in net worth tracking versus budgeting.