菜单
General ledger reconciliation for A-share companies. Adapts the original gl-recon skill for Chinese accounting standards, chart of accounts, and common reconciliation items. Triggers on "A股总账核对", "总账调节", "GL reconciliation China", "科目余额表", or "reconcile [company] accounts".
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
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]".
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".
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".
Roll forward fund accounting records for new reporting periods. Adapts the original roll-forward skill for Chinese fund administration and reporting requirements. Triggers on "基金账务滚动", "账务更新", "roll forward fund", "update fund books", "基金新期间", or "roll forward [fund] [period]".
Write variance commentary for A-share fund performance and portfolio changes. Adapts the original variance-commentary skill for fund accounting and Chinese fund reporting conventions. Triggers on "基金业绩点评", "组合表现分析", "variance commentary fund", "基金表现分析", "业绩归因", or "commentary on [fund] performance".
万得 Wind 金融数据 MCP 技能 — 44 个工具覆盖 A 股/港美股/基金/指数/债券/公告/宏观/分析 8 大服务域
| name | china-gl-recon |
| description | General ledger reconciliation for A-share companies. Adapts the original gl-recon skill for Chinese accounting standards, chart of accounts, and common reconciliation items. Triggers on "A股总账核对", "总账调节", "GL reconciliation China", "科目余额表", or "reconcile [company] accounts". |
Perform A股总账核对 — comprehensive general ledger reconciliation for Chinese companies.
get_financials(ticker, "balance") → Balance sheet accounts
get_financials(ticker, "income") → P&L accounts
Common Chinese COA structure:
| Category | Account Code Range | Key Accounts |
|---|---|---|
| 资产 (Assets) | 1001-1999 | Cash, AR, inventory, PPE |
| 负债 (Liabilities) | 2001-2999 | AP, debt, provisions |
| 所有者权益 (Equity) | 3001-3999 | Capital, reserves, retained earnings |
| 成本 (Cost) | 4001-4999 | COGS, production costs |
| 损益 (P&L) | 5001-5999 | Revenue, expenses, gains/losses |
Key accounts to reconcile:
| Account | CAS Code | Reconciliation Item |
|---|---|---|
| 银行存款 | 1002 | Bank statement |
| 应收账款 | 1122 | AR aging |
| 其他应收款 | 1187 | Related party, advances |
| 存货 | 1403 | Inventory count |
| 固定资产 | 1601 | Fixed asset register |
| 应付账款 | 2202 | Supplier statements |
| 应付职工薪酬 | 2211 | Payroll records |
| 应交税费 | 2221 | Tax returns |
| 未分配利润 | 3405 | P&L close check |
BS recon checklist:
| Account | GL Balance | Supporting Docs | Reconciled Amount | Difference |
|---|---|---|---|---|
| 货币资金 | Bank statements | |||
| 应收账款 | Aging report | |||
| 预付款项 | Supplier statements | |||
| 存货 | Count sheets | |||
| 其他应收款 | Detail listing | |||
| 长期股权投资 | Investment records | |||
| 固定资产 | Asset register | |||
| 应付账款 | Supplier confirmations | |||
| 应付职工薪酬 | Payroll records | |||
| 应交税费 | Tax returns | |||
| 短期借款 | Loan agreements | |||
| 长期借款 | Loan agreements |
Bank recon:
| Item | GL | Bank Stmt | Difference |
|---|---|---|---|
| Balance per GL | ¥XX | ||
| Add: Deposits in transit | ¥XX | ||
| Less: Outstanding checks | ¥XX | ||
| Add/Less: Errors | ¥XX | ||
| Adjusted GL balance | ¥XX | ||
| Balance per bank | ¥XX | ||
| Reconciled | ✓ / ✗ |
Common reconciling items (China):
AR aging recon:
| Aging | GL Balance | Aging Report | Confirmed | Difference |
|---|---|---|---|---|
| 0-30 days | ||||
| 31-60 days | ||||
| 61-90 days | ||||
| 91-180 days | ||||
| >180 days | ||||
| Total |
AR recon items:
AP recon:
| Vendor | GL Balance | Vendor Statement | Confirmed | Difference |
|---|---|---|---|---|
| Total |
Inventory recon:
| Item | GL | Count | Difference | Reason |
|---|---|---|---|---|
| 原材料 | ||||
| 在产品 | ||||
| 产成品 | ||||
| Total |
Inventory recon items:
FA recon:
| Asset | GL | Register | Tag Count | Difference |
|---|---|---|---|---|
| Total |
FA recon items:
Payroll recon:
| Item | GL | Payroll Records | Tax Filing | Difference |
|---|---|---|---|---|
| 工资 | ||||
| 社保 | ||||
| 公积金 | ||||
| 个税 | ||||
| Total |
Tax recon:
| Tax Type | GL | Tax Return | Difference |
|---|---|---|---|
| 增值税 | |||
| 企业所得税 | |||
| 附加税 | |||
| 个税 | |||
| 社保/公积金 |
P&L to retained earnings:
期初未分配利润
+ 本年净利润 (from P&L close)
- 提取盈余公积
- 提取任意公积
- 应付股利
= 期末未分配利润
Verify:
| Issue | Detection | Resolution |
|---|---|---|
| 在途资金 | Bank recon | Timing difference |
| 未达账项 | Bank recon | Follow up |
| 关联方挂账 | AR/AP aging | Related party recon |
| 发票差异 | Tax recon | Timing/cut-off |
| 折旧差异 | FA recon | Policy check |
| Item | Treatment |
|---|---|
| 增值税 | Pass-through, check VAT output/input |
| 政府补助 | Verify classification |
| 股份支付 | Expense recognition check |
| 汇兑损益 | FX difference verification |
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, wind-only (Wind only), wind-fallback (Wind first, fallback to iFind → AkShare): Skip iFind, use AkShare only