协作头脑风暴
brainstorming
在实现前澄清需求、探索设计选择,并形成清晰的开发方向。
china-gl-recon【开发与工程】General ledger reconciliation for A-share fund administration. Tracks fund accounting reconciliations including securities, cash, income, and expense accruals. Adapted from the original gl-recon skill for fund accounting standards. Triggers on "基金总账核对", "基金科目核对", "GL reconciliation fund", "fund accounting recon", or "reconcile [fund] books".
独立 GitHub 快照 · 自动分类 · 以原作者文档为准
Perform 基金总账核对 — comprehensive general ledger reconciliation for fund accounting.
wind-mcp(需 WIND_API_KEY 密钥,以 ak_ 开头)get_financials(ticker, "balance") → Portfolio company BS
get_fund_data(fund_code) → Fund holdings and NAV
get_quote(ticker) → Security prices
Fund accounting COA:
| Category | Accounts | Purpose |
|---|---|---|
| 资产 (Assets) | Securities, cash, receivables | Investments |
| 负债 (Liabilities) | Payables, accruals | Amounts owed |
| 所有者权益 | NAV | Fund value |
| 收入 (Revenue) | Dividends, interest, gains | Investment income |
| 费用 (Expenses) | Management fee, custodian fee | Fund costs |
| 已实现损益 | Realized gains/losses | Trading P&L |
| 未实现损益 | Unrealized appreciation | Mark-to-market |
Securities holdings recon:
| Security | Ticker | Fund Records | Custodian | Difference | Status |
|---|---|---|---|---|---|
| Total |
Reconciliation items:
Cash recon:
| Account | GL Balance | Bank Statement | Custodian | Difference |
|---|---|---|---|---|
| 清算备付金 | ||||
| 结算备付金 | ||||
| 银行存款 | ||||
| Total |
Income reconciliation:
| Type | Fund Records | Custodian | Source Docs | Difference |
|---|---|---|---|---|
| 现金股息 | ||||
| 股票股息 | ||||
| 债券利息 | ||||
| 回购利息 | ||||
| 基金分红 | ||||
| 已实现利得 | ||||
| Total |
Expense reconciliation:
| Expense | Fund Records | Custodian | Invoice/Contract | Difference |
|---|---|---|---|---|
| 管理费 | ||||
| 托管费 | ||||
| 交易佣金 | ||||
| 审计费 | ||||
| 信息披露费 | ||||
| 律师费 | ||||
| Total |
Accrual reconciliation:
| Accrual Type | Calculation | Custodian | Difference |
|---|---|---|---|
| 应收股息 | |||
| 应收利息 | |||
| 应付管理费 | |||
| 应付托管费 | |||
| 应付交易费用 |
NAV reconciliation:
| Component | Fund Books | Custodian | Difference |
|---|---|---|---|
| Securities | |||
| Cash | |||
| Receivables | |||
| Payables | |||
| Accruals | |||
| NAV |
NAV per unit check:
| Fund | Custodian | Difference | |
|---|---|---|---|
| NAV (¥) | |||
| Shares outstanding |
P&L reconciliation:
| P&L Item | Fund Books | Verified | Notes |
|---|---|---|---|
| 收入合计 | |||
| 费用合计 | |||
| 已实现损益 | |||
| 未实现损益 | |||
| 利润合计 |
Trade recon:
| Trade Date | Security | Type | Quantity | Price | Fund | Custodian | Match? |
|---|---|---|---|---|---|---|---|
Exception log:
| # | Exception | Type | Amount | Resolution | Status |
|---|---|---|---|---|---|
| Standard | Applies |
|---|---|
| 基金会计核算 | All funds |
| 企业会计准则 | Private funds |
| 证券投资基金信息披露 | Disclosure requirements |
| Issue | Cause | Resolution |
|---|---|---|
| 交易时滞 | T+1 settlement | Track trades in transit |
| 分红时滞 | Ex-date vs pay-date | Accrue correctly |
| 费用计提 | Timing differences | Standardize cut-off |
| 估值差异 | Different pricing sources | Agree on source |
Before completing:
Data Source Mode Switch: Set env var
IFIND_DATA_SOURCE_MODEto control data source preference.
ifind-only(strict): Use iFind only, error if unavailableifind-fallback(default): iFind preferred, fallback to AkShareakshare-only: Skip iFind, use AkShare onlywind-only: Wind only, error if unavailablewind-fallback: Wind first, fallback to iFind → AkShare