How often to refresh, and why monthly is the right cadence.
Daily net-worth tracking is noise and stress. Annual is too infrequent to catch errors. Monthly hits the sweet spot for most households, with quarterly a defensible alternative.
The signal-to-noise problem
A diversified portfolio's daily volatility is approximately 0.5–1.0 % on average days and 2–5 % on event days. A typical household balance sheet is 50–70 % in equity-correlated assets (super, investment portfolio, residential property correlated with broader asset markets). Daily fluctuation in net worth on a $500,000 base is plausibly $2,500–$25,000.
Daily tracking exposes you to this noise without delivering meaningful signal. The trajectory information that justifies tracking emerges only over weeks and months. Daily tracking is therefore not just unnecessary — it is actively counterproductive, because it conditions you to react to noise as if it were signal.
Why monthly works
- Smooths daily volatility. A month-end snapshot averages over enough trading sessions to dampen normal market fluctuation.
- Catches errors quickly. A forgotten BNPL account, a credit-card balance you didn't know existed, an investment statement you've been ignoring — all surface within 30 days. Annual tracking lets a missed liability compound for a year.
- Aligns with statement cycles. Most accounts produce statements monthly. Refreshing balances at month-end aligns with the data you'll have access to.
- Time-efficient at steady state. After the first 60-minute setup, monthly refresh takes 15–20 minutes per cycle.
Quarterly is the minimum defensible cadence
Some households cannot sustain monthly tracking. Quarterly works as a fallback for households where the asset and liability mix is stable and slow-moving. The trade-off:
- Pros: Lower time commitment. Aligned with super statement cycles in Australia.
- Cons: Errors and forgotten accounts can compound for up to 90 days. Trajectory signal is correspondingly slower.
Annual tracking is too infrequent for the figure to be useful as anything except a tax-time data point.
The spreadsheet template structure that works
A simple two-tab spreadsheet covers most cases:
- Tab 1: Accounts. One row per account (each bank account, brokerage, super, mortgage, credit card). Columns: account name, institution, account type, current balance, last updated. About 15–25 rows for a typical household.
- Tab 2: History. One row per month. Columns: month-end date, total assets, total liabilities, net worth, liquid net worth, optional notes. About 12 rows per year.
The Accounts tab is the live data; the History tab is the trajectory record. A simple formula on the History tab pulls totals from the Accounts tab, so refreshing the Accounts tab is the only manual work each month.
What the trajectory tells you
Twelve months of monthly snapshots reveal three useful patterns:
- Net worth growth rate. Compound monthly growth rate annualised. Compare to your saving rate plus expected investment return; mismatches indicate spending leakage or valuation drift.
- Cyclicality. Bonus months, tax-refund months, holiday-spending months. The trajectory is rarely a straight line; understanding its shape lets you plan around it.
- Account drift. Specific accounts that grow or shrink faster than the household average. The information shows you which accounts are doing the work and which are not.
When to recalibrate the basket
The list of accounts you track should be reviewed annually. New accounts opened during the year, accounts closed, and any meaningful change in asset composition (a property purchase or sale, a job change that changes super provider) all require Accounts-tab updates. Without this annual review, the tracking accumulates stale entries that distort the trajectory.