L’interface est localisée ; les présentations et documents des Skills sont traduits automatiquement par IA dans votre langue. Le code, les commandes, chemins et termes techniques restent en version originale, et le document de l’auteur fait foi.
Explorer les Skills
Développement · SKILL.md

china-gl-recon

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

Independent GitHub snapshot · Automated classification · Original documentation governs

Documentation de la Skill

GitHub

name: china-gl-recon description: 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:

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
Skills enregistrées