One balance a month per account is the whole job. Everything else, twenty four months of net worth, the gain on every holding, the drift on your allocation and what to buy or sell to correct it, comes from that.

WHAT YOU GET
One Excel file, nine working tabs, over 1,400 live formulas.

1. Start Here. Read it once, then you are running.
2. Setup. Your asset classes, target net worth, current and retirement age.
3. Accounts. Every account, its institution, type and asset class.
4. Balances. The one tab you type in. One balance a month, twenty four months.
5. Holdings. Units, average cost, latest price, gain, loss and weight.
6. Liabilities. Every debt, its rate, months remaining and interest still to pay.
7. Allocation. Actual against target, the drift, and the amount to rebalance.
8. Net Worth History. Twenty four months, with month on month change.
9. Dashboard. Net worth, change this month and year, progress to target, years to retirement.

HOW IT WORKS
Emerald cells are yours. White cells calculate. Two years of a worked example are seeded in.

IMPORTANT
This is a tracking spreadsheet, not financial advice. Prices are typed by you, not fetched live.

WORKS WITH
Excel on Mac and Windows, Microsoft 365, and Google Sheets via File, Import, Upload. No add ons, no subscription.

INSTANT DOWNLOAD
Yours the moment you buy. Message me if anything does not work and I will fix it.