本文へ移動
cccskills
無料GitHub で公開

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".

インストール方法を見る

含まれるファイル(1)

  • SKILL.md5.8 KB

SKILL.md(原文)

インストールする前に、エージェントに与えられる指示の中身を確認できます。

china-gl-recon

Purpose

Perform 基金总账核对 — comprehensive general ledger reconciliation for fund accounting.

Data Sources

Tier 0 — 万得 Wind(最全面付费数据)

  • 覆盖:A股/港美股/基金/指数/债券/宏观/研报/分析(44个工具)
  • MCP 服务:wind-mcp(需 WIND_API_KEY 密钥,以 ak_ 开头)
  • 优势:全市场覆盖面最广、数据最全面、包含研报和量化分析
  • 密钥申请:https://aifinmarket.wind.com.cn/#/home

Tier 1 — 同花顺 iFind(付费精确数据)/ AkShare MCP(Tier-2 免费备选)

get_financials(ticker, "balance")    → Portfolio company BS
get_fund_data(fund_code)              → Fund holdings and NAV
get_quote(ticker)                     → Security prices

Secondary Sources

  • 基金公司 — fund accounting system
  • 托管行 — custody records
  • Wind / Choice — market data

Workflow

Step 1: Identify GL Accounts

Fund accounting COA:

CategoryAccountsPurpose
资产 (Assets)Securities, cash, receivablesInvestments
负债 (Liabilities)Payables, accrualsAmounts owed
所有者权益NAVFund value
收入 (Revenue)Dividends, interest, gainsInvestment income
费用 (Expenses)Management fee, custodian feeFund costs
已实现损益Realized gains/lossesTrading P&L
未实现损益Unrealized appreciationMark-to-market

Step 2: Securities Reconciliation

Securities holdings recon:

SecurityTickerFund RecordsCustodianDifferenceStatus
Total

Reconciliation items:

  • 在途交易 (Trades in transit)
  • 配股/增发 (Rights issues)
  • 分红到账 (Dividend settlements)
  • 利息到账 (Interest settlements)

Step 3: Cash Reconciliation

Cash recon:

AccountGL BalanceBank StatementCustodianDifference
清算备付金
结算备付金
银行存款
Total

Step 4: Income Reconciliation

Income reconciliation:

TypeFund RecordsCustodianSource DocsDifference
现金股息
股票股息
债券利息
回购利息
基金分红
已实现利得
Total

Step 5: Expense Reconciliation

Expense reconciliation:

ExpenseFund RecordsCustodianInvoice/ContractDifference
管理费
托管费
交易佣金
审计费
信息披露费
律师费
Total

Step 6: Accrual Reconciliation

Accrual reconciliation:

Accrual TypeCalculationCustodianDifference
应收股息
应收利息
应付管理费
应付托管费
应付交易费用

Step 7: NAV Reconciliation

NAV reconciliation:

ComponentFund BooksCustodianDifference
Securities
Cash
Receivables
Payables
Accruals
NAV

NAV per unit check:

FundCustodianDifference
NAV (¥)
Shares outstanding

Step 8: P&L Reconciliation

P&L reconciliation:

P&L ItemFund BooksVerifiedNotes
收入合计
费用合计
已实现损益
未实现损益
利润合计

Step 9: Trade Reconciliation

Trade recon:

Trade DateSecurityTypeQuantityPriceFundCustodianMatch?

Step 10: Exception Report

Exception log:

#ExceptionTypeAmountResolutionStatus

China-Specific Considerations

Fund Accounting Standards

StandardApplies
基金会计核算All funds
企业会计准则Private funds
证券投资基金信息披露Disclosure requirements

Common Issues

IssueCauseResolution
交易时滞T+1 settlementTrack trades in transit
分红时滞Ex-date vs pay-dateAccrue correctly
费用计提Timing differencesStandardize cut-off
估值差异Different pricing sourcesAgree on source

Quality Checks

Before completing:

  • Securities reconciled
  • Cash reconciled
  • Income reconciled
  • Expenses reconciled
  • Accruals reconciled
  • NAV tied out
  • P&L reconciled
  • Exceptions resolved
  • Sign-offs obtained

Data Source Mode Switch: Set env var IFIND_DATA_SOURCE_MODE to control data source preference.

  • ifind-only (strict): Use iFind only, error if unavailable
  • ifind-fallback (default): iFind preferred, fallback to AkShare
  • akshare-only: Skip iFind, use AkShare only
  • wind-only: Wind only, error if unavailable
  • wind-fallback: Wind first, fallback to iFind → AkShare

レビュー

まだレビューはありません。使ってみた感想をお寄せください。

同じリポジトリのスキル

概要と使いどころ

Three-statement financial model for A-share stocks. Adapts the standard 3-statement-model methodology for Chinese accounting standards (CAS), Chinese GAAP differences, and AkShare-sourced financials. Use instead of the original 3-statement-model skill when building integrated IS/BS/CF models for Chinese listed companies.

日本語の概要は準備中です。原文の説明を表示しています。

jwangkun/claude-for-financial-services-cn8342026年9月14日 更新

Build accrual schedules for A-share companies tracking revenue recognition, expense accruals, and working capital timing. Adapted from the original accrual-schedule skill for CAS accounting and Chinese business practices. Triggers on "A股应计项目", "应计计提", "accrual schedule China", "应计账款分析", or "working capital accruals [company]".

日本語の概要は準備中です。原文の説明を表示しています。

jwangkun/claude-for-financial-services-cn8342026年9月14日 更新

Build accrual schedules for A-share fund administration. Tracks revenue recognition, expense accruals, and working capital timing for fund accounting. Adapted from the original accrual-schedule skill for fund accounting standards. Triggers on "基金应计项目", "应计计提基金", "accrual schedule fund", "NAV accruals", or "accruals [fund]".

日本語の概要は準備中です。原文の説明を表示しています。

jwangkun/claude-for-financial-services-cn8342026年9月14日 更新

Assess an A-share portfolio company's AI readiness for China-focused private equity investments. Evaluates data infrastructure, technology stack, talent, and AI adoption opportunities in the Chinese market context. Triggers on "A股公司AI评估", "AI readiness China", "AI assessment portfolio company", "AI转型评估", or "artificial intelligence readiness [company]".

日本語の概要は準備中です。原文の説明を表示しています。

jwangkun/claude-for-financial-services-cn8342026年9月14日 更新

Audit financial models and Excel workbooks for A-share analysis. Adapts the original audit-xls skill for Chinese financial modeling standards, CAS conventions, and A-share-specific checks. Triggers on "A股模型审计", "财务模型核查", "audit model China", "audit xlsx", "模型QC", or "check model [company]".

日本語の概要は準備中です。原文の説明を表示しています。

jwangkun/claude-for-financial-services-cn8342026年9月14日 更新

Forensic financial analysis for A-share fund holdings and portfolio companies. Adapts the original break-trace skill for fund administration context and Chinese market standards. Triggers on "基金持仓核查", "持仓异常", "forensic fund analysis China", "持仓质量分析", or "investigate [fund] holdings".

日本語の概要は準備中です。原文の説明を表示しています。

jwangkun/claude-for-financial-services-cn8342026年9月14日 更新

jwangkun のスキルをすべて見る

このスキルの問題を報告する