net-worth
Calculate net worth from assets and liabilities with a formatted statement.
- License 许可
- MIT
- 最近更新
- 2026-11-09
- Stars
- ★ 0
- Forks
- 0
01 前言 Front Matter
- name
- net-worth
- source
- https://github.com/openaccountant/skills
- license
- MIT
- description
- Calculate net worth from assets and liabilities with a formatted statement.
- imported_at
- 2026-09-20
- source_path
- personal/net-worth/SKILL.md
- source_repository
- openaccountant/skills
03 SKILL.md 正文
Net Worth Tracker
Overview
Calculates your net worth by combining transaction-derived data (savings deposits, investment contributions, debt payments) with user-provided account balances. Produces a formatted net worth statement and tracks changes over time.
Wilson Tools Used
transaction_search— find savings deposits, investment contributions, and debt payments to identify accounts and activity
Workflow
-
Run
transaction_searchwithquery: "savings OR transfer to savings OR deposit"andmonths: 3to identify savings account activity. -
Run
transaction_searchwithquery: "investment OR 401k OR IRA OR brokerage OR Vanguard OR Fidelity OR Schwab"andmonths: 3to find investment contributions. -
Run
transaction_searchwithquery: "mortgage OR loan payment OR student loan OR auto loan"andmonths: 3to find liability-related payments. -
From the results, compile a list of accounts detected (savings accounts, investment accounts, loan accounts).
-
Ask the user to provide current balances for each detected account, plus any accounts not visible in transactions (home value, vehicle value, other assets, credit card balances).
-
Organize into a net worth statement:
ASSETS ────────────────────────────────── Checking Accounts $X,XXX.XX Savings Accounts $X,XXX.XX Investment Accounts $X,XXX.XX Retirement (401k/IRA) $X,XXX.XX Property $X,XXX.XX Vehicles $X,XXX.XX Other Assets $X,XXX.XX ────────────────────────────────── TOTAL ASSETS $XX,XXX.XX LIABILITIES ────────────────────────────────── Credit Cards $X,XXX.XX Student Loans $X,XXX.XX Auto Loans $X,XXX.XX Mortgage $X,XXX.XX Other Liabilities $X,XXX.XX ────────────────────────────────── TOTAL LIABILITIES $XX,XXX.XX ══════════════════════════════════ NET WORTH $XX,XXX.XX ══════════════════════════════════ -
If the user has run this skill before and provides previous balances, calculate the change in net worth and show the delta.
-
Highlight the biggest contributor to net worth growth or decline.
Without Wilson
- Open a new Google Sheets spreadsheet or download a net worth template (NerdWallet and Mint both offer free ones).
- Create two sections: Assets and Liabilities.
- For assets, log in to each account and record current balances:
- Bank accounts: check your banking app or website
- Investment accounts: Vanguard (balances page), Fidelity (portfolio summary), Schwab (account summary)
- Retirement: check your 401k provider portal or most recent statement
- Property: use Zillow Zestimate or Redfin estimate (search your address)
- Vehicles: check Kelley Blue Book (kbb.com) private party value
- For liabilities, gather current balances:
- Credit cards: check each card's current balance online
- Student loans: log into studentaid.gov for federal, or your servicer for private
- Mortgage: check your most recent statement or lender portal
- Auto loans: check your lender portal or most recent statement
- Sum assets and liabilities separately, then calculate:
Net Worth = Total Assets - Total Liabilities. - Save the file with today's date. Repeat monthly to track trends.
- In Google Sheets, use
=SUM(B2:B8)for total assets and=SUM(B10:B15)for total liabilities. Net worth:=B9-B16.
Important Notes
- Wilson can identify accounts from transaction activity but cannot determine current balances. The user must provide balances manually.
- Property and vehicle values are estimates. Use conservative figures.
- Net worth is a snapshot — it changes daily with market fluctuations. Monthly tracking is sufficient for most people.
- Do not include personal property (furniture, electronics, clothing) unless it has significant resale value.
04 同仓库更多 Skills
dei-assessment
Assess diversity, equity, and inclusion with metrics. TRIGGERS - Use when user needs help with dei-assessment related tasks.
dei-action-plan
Create DEI action plans with goals and initiatives. TRIGGERS - Use when user needs help with dei-action-plan related tasks.
culture-fit-assessment
Design culture add assessment processes. TRIGGERS - Use when user needs help with culture-fit-assessment related tasks.
cowork-to-code-bridge
Use an already-installed, independently verified cowork-to-code bridge to run narrowly approved actions on the user's own macOS, Linux, or WSL2 machine through a local file queue.
counter-offer-response
Draft counter-offer responses for retention. TRIGGERS - Use when user needs help with counter-offer-response related tasks.
continuous-feedback-system
Design continuous feedback systems. TRIGGERS - Use when user needs help with continuous-feedback-system related tasks.