domain-financial
Financial reporting rules: grain consistency, balance sheets, double-entry ledgers, fiscal year boundaries, period-over-period calculations.
适合你，如果你需要生成或校验符合规范的财务报表
npx oh-my-skill add signalpilot-labs/signalpilot/domain-financialcurl -fsSL https://oh-my-skill.com/install.sh | bash -s -- signalpilot-labs/signalpilot/domain-financialnpx oh-my-skill verify signalpilot-labs/signalpilot/domain-financial怎么用
商店整理自技能原文 · 版本 436a4c4 · 表述以原文为准Claude 将按照会计规则处理财务报告：从事实表聚合数据，确保报告粒度一致，正确拆分资产负债表中的留存收益和当年收益，在分类账中同时显示借贷双方，计算环比时首次返回 NULL。
当用户询问财务报告、资产负债表、分类账或期间对比时触发，要求使用交易事实表驱动或指定粒度。
技能原文 SKILL.md
Financial Reporting
Driving Table
When aggregating transactions or metrics, drive FROM the fact/transaction table (journal_entries, invoices, payments), not the dimension table (accounts, customers). Accounts with zero transactions MUST NOT appear in transaction reports - they have no data to aggregate.
Grain Consistency
All metrics in a report MUST operate at the same grain - mixing grains produces silently wrong totals.
Use COUNT() on a line-item fact table, not COUNT(DISTINCT document_id) - the grain is the line item, not the document, so COUNT() is consistent with SUM(amount).
NEVER use COUNT(DISTINCT) just because a key represents a document or entity - a transaction fact table's grain is the transaction row.
Do NOT use a YML column description to choose between COUNT(*) and COUNT(DISTINCT) - descriptions explain semantics, not aggregation method. The source table's grain determines the correct aggregation.
Balance Sheets
A balance sheet has exactly three components:
- Regular accounts (ASSET, LIABILITY, EQUITY) - cumulative running balances
- Retained Earnings - cumulative P&L from ALL prior fiscal years
- Current Year Earnings - cumulative P&L from the current fiscal year only
Query the project's configuration or organization table for fiscal year end settings - these values vary per tenant and MUST be used to compute the boundary, not hard-coded.
P&L transactions before the fiscal year boundary = Retained Earnings. P&L from the boundary onward = Current Year Earnings.
If the YML description specifies this earnings split, implement it exactly as written.
Double-Entry Ledgers
Every transaction has offsetting debits and credits - when unioning ledger entries, preserve BOTH sides.
Running balances MUST be computed with a window function ordered by transaction_date AND a deterministic tiebreaker (transaction_id or a sequence index) - ordering by date alone is non-deterministic when multiple transactions share a timestamp.
Period-Over-Period
See dbt-workflow "Incremental Models and Period-Over-Period Columns" for the full rule. On first build, period-over-period columns MUST be NULL. Do NOT substitute 0.