balance-sheet
Build a balance sheet (bilan) from a Well workspace. Use when the user asks for a balance sheet, bilan, assets/liabilities/equity, or financial position at a point in time.
适合你，如果你需要快速从 Well 数据生成资产负债表。
npx oh-my-skill add wellapp-ai/well/balance-sheetcurl -fsSL https://oh-my-skill.com/install.sh | bash -s -- wellapp-ai/well/balance-sheetnpx oh-my-skill verify wellapp-ai/well/balance-sheet怎么用
商店整理自技能原文 · 版本 782601c · 表述以原文为准装上后，Claude 能根据您的 Well 工作空间中的已过账总账数据，生成指定日期（as-of date）的资产负债表。它会按资产（Actif）和负债/权益（Passif）两大类别分组并显示小计，同时检查两边是否平衡（Actif = Passif ✓/✗）。如果总账为空，则回退显示现金头寸并标注。
当您要求生成资产负债表、bilan、资产/负债/权益，或询问某个时间点的财务状况时触发。
技能原文 SKILL.md
Balance sheet (bilan) from Well
Like the P&L, the balance sheet comes from the posted ledger, not from raw documents. It is a point-in-time snapshot: balances of the balance-sheet accounts as of a date.
Do this
- Discover the schema (
well:querying-well-data): well_get_schema("ledger_accounts")— chart of accounts. Balance-sheet accounts are the asset/liability/equity classes (French plan comptable: classes 1–5; income-statement classes 6–7 are excluded).well_get_schema("journal_entries")/journal_entry_lines— posted movements with debit/credit and dates.well_get_schema("account_balances")— Well may expose computed balances directly; prefer these when present, they are the canonical balance per account.- As-of date: filter postings with
date _lte <as_of>(a balance sheet is cumulative from inception, not a period). - Compute each account balance (sum of debits − credits, or read
account_balances), then group by class: - Actif (assets): debit-normal balances (classes 2, 3, 4-debit, 5).
- Passif (liabilities + equity): credit-normal balances (classes 1, 4-credit).
- Check it balances: total Actif must equal total Passif. If it doesn't, surface the gap rather than hiding it — it usually means unposted entries or a period filter mistake.
Do NOT
- Do not derive assets/liabilities from invoice or bank-transaction lists directly; use the posted ledger /
account_balances. - Do not assume account-class conventions without reading the chart of accounts.
If the ledger is empty
Say the books aren't posted yet. A bank accounts + account_balances snapshot can give a cash position (not a balance sheet) as a clearly-labelled fallback.
Present it
Two columns — Actif and Passif — grouped by class with subtotals, the as-of date, the currency, and an explicit "Actif = Passif ✓/✗" balance check.