Skills

China Gl Recon

General ledger reconciliation for A-share fund administration.

Install

npx skills add jwangkun/claude-for-financial-services-cn --skill china-gl-recon -g -a claude-code -y
Category
Engineering
Updated
2mo ago
License
Apache-2.0
Context cost
Lightabout 1,242 tokens
Runs scripts
No, instructions only

What it does

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

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:

Read the whole SKILL.md on GitHub

More in Engineering