본문으로 건너뛰기
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

리뷰

아직 리뷰가 없습니다. 사용해 본 소감을 남겨 주세요.

댓글

로그인 없이 쓸 수 있습니다. 사용 후기, 질문, 작동하지 않은 환경 등을 편하게 남겨 주세요.

아직 댓글이 없습니다. 첫 댓글을 남겨 보세요.

보내면 바로 공개됩니다. 이메일 주소나 전화번호 같은 개인 정보는 쓰지 마세요. URL은 2개까지입니다.

0 / 1,000자

이 양식은 reCAPTCHA로 보호되며 Google 개인정보처리방침 및 서비스 약관이 적용됩니다.

같은 저장소의 스킬

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-cn8422026년 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-cn8422026년 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-cn8422026년 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-cn8422026년 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-cn8422026년 9월 14일 업데이트

Forensic financial analysis for A-share companies. Identifies discrepancies, potential irregularities, and earnings quality issues in Chinese financial statements. Adapted from the original break-trace skill for CAS accounting and Chinese market red flags. Triggers on "A股财务核查", "财务异常", "forensic analysis China", "财务舞弊", "earnings quality China", or "investigate [company] financials".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

jwangkun/claude-for-financial-services-cn8422026년 9월 14일 업데이트

jwangkun의 스킬 모두 보기

이 스킬의 문제 신고