China Audit Xls
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]".
Install
/plugin marketplace add jwangkun/claude-for-financial-services-cnThe repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.
npx skills add jwangkun/claude-for-financial-services-cn --skill china-audit-xlsgit clone --depth 1 https://github.com/jwangkun/claude-for-financial-services-cn.git /tmp/claude-for-financial-services-cn
mkdir -p ~/.claude/skills
cp -r /tmp/claude-for-financial-services-cn/agent-plugins/china-earnings-reviewer/skills/china-audit-xls ~/.claude/skills/china-audit-xlsPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# china-audit-xls ## Purpose Audit **A股财务模型** — comprehensive quality checks for Chinese equity financial models. ## 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 免费备选) ```python get_financials(ticker, "income") → Actuals for cross-check get_financials(ticker, "balance") → BS for cross-check get_financials(ticker, "cashflow") → CF for cross-check get_quote(ticker) → Market data ``` ### Secondary Sources - 巨潮 — source financials - 审计报告 — reference data ## Workflow ### Step 1: Structural Audit **Model structure checklist:** | Area | Check | Pass Criteria | |------|-------|--------------| | Cover page | Company, date, version | Present and accurate | | Assumptions | All key inputs centralized | No hardcoded values in calc | | Historicals | All periods populated | 3-5 years | | Forecast | Explicit forecast period | 3-5 years | | Valuation | DCF, comps, football field | All methods present | | Checks | Sum, balance, cross-ref | All checks green | | Documentation | Methodology notes | Clear and complete | ### Step 2: Formula Audit **Formula checks:** | Check | Description | Pass Criteria | |-------|-------------|--------------| | No hardcodes | All inputs in assumptions | ✓ |
Details
- Skill name
china-audit-xls- Repository
- jwangkun/claude-for-financial-services-cn
- Path
agent-plugins/china-earnings-reviewer/skills/china-audit-xls/SKILL.md- License
- Apache-2.0
- Repo updated
- 14 September 2026
FAQ
What does the China Audit Xls skill do?
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]".
How do I install the China Audit Xls skill?
Claude Code plugin: /plugin marketplace add jwangkun/claude-for-financial-services-cn. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is China Audit Xls popular?
It lives in jwangkun/claude-for-financial-services-cn, which has 896 GitHub stars and 143 forks.
Related skills
China 3 Statement Model
896jwangkun/claude-for-financial-services-cn
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.
China Accrual Schedule
896jwangkun/claude-for-financial-services-cn
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]".
China Accrual Schedule
896jwangkun/claude-for-financial-services-cn
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]".
China Dcf Model
896jwangkun/claude-for-financial-services-cn
Discounted cash flow (DCF) valuation model for A-share equities. This alias skill redirects to china-dcf, which provides comprehensive DCF modeling adapted for Chinese market conventions. Triggers on "A股DCF模型", "DCF估值", "DCF model China", "现金流折现", "discounted cash flow A-share", or "DCF [company]".
China AI Readiness
896jwangkun/claude-for-financial-services-cn
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]".
China Lbo Model
896jwangkun/claude-for-financial-services-cn
Leveraged buyout model for A-share and China-market LBO scenarios. Adapts the standard LBO-model methodology for Chinese debt markets, CAS accounting, and AkShare data. Use instead of the original lbo-model skill when analyzing leveraged buyouts involving Chinese targets or China-based sponsors.
Browse the most popular Claude skills, all ai, llms & agents skills, or write your own with the skills generator.