Net Worth Tracking & Asset Allocation Audit

Template Overview

Connecting your sensitive bank logins, investment portfolios, and debt ledgers to cloud budgeting apps exposes your entire financial life to third-party data brokers, credential leaks, and corporate tracking.

Financial sovereignty requires data sovereignty. A disciplined quarterly net worth audit conducted in a local, private Markdown ledger provides clarity without surveillance: calculating total liquid assets, retirement holdings, real estate equity, liabilities, and true portfolio asset allocation.

This template provides a comprehensive financial audit framework: balance sheet snapshot, asset allocation breakdown against target benchmarks, liability and debt payoff ledger, quarterly savings rate calculation, and annual financial milestone scorecards.

Markdown Template Structure

Copy the block below or click Download .md File to add this template directly to your personal vault:

---
title: "Finance: [Year] Q[Quarter] Net Worth & Asset Audit"
date: [YYYY-MM-DD]
audit_period: "[e.g., Q3 2026]"
currency: "[USD ($) / EUR (€) / GBP (£)]"
total_net_worth: "[Formatted Currency String]"
quarterly_change_delta: "[+/- Percentage / Dollar Amount]"
confidentiality: "Strictly Personal & Confidential"
tags: [personal, finance, net-worth, asset-allocation, wealth]
---

# Finance: [Year] Q[Quarter] Net Worth & Asset Audit — [YYYY-MM-DD]

## 1. Executive Balance Sheet Summary
$$\text{Net Worth} = \text{Total Assets} - \text{Total Liabilities}$$

| Category | Prior Quarter | Current Quarter | Dollar Delta | Percentage Delta |
| :--- | :--- | :--- | :--- | :--- |
| **Total Liquid Cash & Equivalents** | $45,000 | $52,000 | +$7,000 | +15.5% |
| **Tax-Advantaged Retirement (401k/IRA)**| $280,000 | $298,000 | +$18,000 | +6.4% |
| **Taxable Brokerage Investments** | $165,000 | $176,500 | +$11,500 | +6.9% |
| **Real Estate & Illiquid Assets** | $420,000 | $420,000 | $0 | 0.0% |
| **TOTAL ASSETS** | **$910,000** | **$946,500** | **+$36,500** | **+4.0%** |
| *Less: Mortgages & Liabilities* | ($310,000) | ($306,200) | -$3,800 | -1.2% |
| **TOTAL NET WORTH** | **$600,000** | **$640,300** | **+$40,300** | **+6.7%** |

## 2. Asset Allocation Breakdown vs Target Benchmark
| Asset Class | Current Value | Actual % | Target % | Rebalancing Action Needed |
| :--- | :--- | :--- | :--- | :--- |
| **US Total Market Equities (VTI)** | $310,000 | 59.0% | 60.0% | In balance (hold) |
| **International Equities (VXUS)** | $105,000 | 20.0% | 20.0% | Perfect balance |
| **Fixed Income / Treasury Bonds (BND)**| $52,500 | 10.0% | 10.0% | In balance |
| **Cash & Emergency Reserve** | $52,000 | 9.9% | 10.0% | Fully funded (6 months runway) |
| **Alternative / Speculative** | $6,000 | 1.1% | 0.0% | Do not allocate further capital |

## 3. Liabilities & Debt Payoff Schedule
| Liability Name | Creditor | Interest Rate (%) | Remaining Balance | Target Payoff Date |
| :--- | :--- | :--- | :--- | :--- |
| **Primary Home Mortgage** | First National Bank | 3.125% (Fixed) | $306,200 | [YYYY-MM-DD] |
| **Automobile Loan** | Auto Credit | 0.0% Promo | $0 (PAID OFF) | Completed |
| **Credit Card Debt** | Various | 0.0% (Paid monthly) | $0 | Always $0 balance |

## 4. Quarterly Cash Flow & Savings Rate Audit
- **Gross Quarterly Income:** $[Amount]
- **Net Post-Tax Income:** $[Amount]
- **Total Quarterly Living Expenses:** $[Amount]
- **Net Capital Saved / Invested:** $[Amount]
- **Calculated Savings Rate:**
  $$\text{Savings Rate} = \frac{\text{Net Capital Saved}}{\text{Net Income}} = [XX.X]\%$$

## 5. Annual Milestone Goals & Rebalancing Directives
- [ ] Maintain 6 months of living expenses ($48,000) in high-yield local treasury reserve.
- [ ] Max out annual tax-advantaged retirement contributions by Q4.
- [ ] Direct all incremental excess savings into broad-market index funds.

Filled Real-World Example

Here is a realistic example demonstrating how this template captures actual deliberations:

---
title: "Finance: 2026 Q3 Net Worth & Asset Audit"
date: [YYYY-MM-DD]
audit_period: "Q3 2026"
currency: "USD ($)"
total_net_worth: "$714,800"
quarterly_change_delta: "+$32,400 (+4.75%)"
confidentiality: "Strictly Personal & Confidential"
tags: [personal, finance, net-worth, asset-allocation, wealth]
---

# Finance: 2026 Q3 Net Worth & Asset Audit — [YYYY-MM-DD]

## 1. Executive Balance Sheet Summary
$$\text{Net Worth} = \$988,000 - \$273,200 = \$714,800$$

| Category | Q2 2026 | Q3 2026 | Delta ($) | Delta (%) |
| :--- | :--- | :--- | :--- | :--- |
| **Liquid Cash (Treasuries/HYSA)** | $48,000 | $52,000 | +$4,000 | +8.3% |
| **Tax-Advantaged (Roth IRA / 401k)**| $340,000 | $358,000 | +$18,000 | +5.3% |
| **Taxable Index Brokerage** | $210,000 | $228,000 | +$18,000 | +8.6% |
| **Home Equity (Conservative Est.)** | $350,000 | $350,000 | $0 | 0.0% |
| **TOTAL ASSETS** | **$948,000** | **$988,000** | **+$40,000** | **+4.2%** |
| *Mortgage Balance Remaining* | ($265,600) | ($273,200)* | -$7,600 | Principal paid down |
| **TOTAL NET WORTH** | **$682,400** | **$714,800** | **+$32,400** | **+4.75%** |

*\*Note: Reflected accurate principal amortized schedule.*

## 2. Asset Allocation Breakdown vs Benchmark
| Asset Class | Current Balance | Actual % | Target % | Action |
| :--- | :--- | :--- | :--- | :--- |
| **VTI (US Total Stock Market)** | $385,000 | 60.3% | 60.0% | Maintain hold |
| **VXUS (International Market)** | $127,500 | 20.0% | 20.0% | Target achieved |
| **BND (Total Bond Market)** | $64,000 | 10.0% | 10.0% | Target achieved |
| **Treasury Cash Reserve** | $52,000 | 8.1% | 10.0% | Allocate Q4 savings here |
| **Speculative / Angel** | $9,500 | 1.6% | 0.0% | No new allocations |

## 3. Liabilities & Debt Payoff
- **Primary Residence Mortgage:** Fixed rate 2.875%; remaining principal $273,200. Zero intention of paying off early due to low borrowing cost relative to treasury yield.
- **Consumer Debt:** $0.

## 4. Cash Flow & Savings Rate
- **Q3 Post-Tax Income:** $46,200
- **Q3 Total Household Outflows:** $24,800
- **Q3 Net Invested Savings:** $21,400
- **Measured Savings Rate:**
  $$\frac{\$21,400}{\$46,200} = 46.3\%$$

## 5. Action Items for Next Quarter
- [x] Auto-deposit Q4 IRA catchup allocation.
- [x] Rebalance $3,000 from VTI into Treasury Reserve to hit exact 10% cash target.

When to Use and When to Avoid

When to Use

• Conducting quarterly or annual personal net worth audits in private Markdown.
• Analyzing portfolio asset allocation percentages against target rebalancing models.
• Tracking mortgage amortization, student debt payoff, and consumer liability reduction.
• Calculating post-tax personal savings rates and monitoring financial runway.

When to Avoid

• Tracking daily day-trading stock fluctuations or high-frequency options trades.
• Logging corporate GAAP accounting books for public corporations.
• Managing shared corporate payroll distributions for enterprise employees.
• Recording casual coffee shop expense receipts.

On-Device AI Integration

Audit personal finances and net worth with Oyma on macOS:

Analyze the quarterly financial statements and asset holdings:
1. Synthesize the executive balance sheet table calculating total assets, liabilities, and net worth delta.
2. Structure the asset allocation comparison table against target benchmark percentages.
3. Formulate the debt reduction schedule and calculate the post-tax quarterly savings rate.
4. Establish concrete rebalancing directives and financial milestone actions for next quarter.
Output in clean, confidential CommonMark.

Your private financial records and net worth calculations remain strictly on your Mac.