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

896 stars 143 forksAI, LLMs & Agents Plugin marketplace

Install

Claude Code plugin
/plugin marketplace add jwangkun/claude-for-financial-services-cn

The repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add jwangkun/claude-for-financial-services-cn --skill china-audit-xls
Manual install
git 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-xls

Personal 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 | ✓ |
Read the full skill on GitHub

Details

Skill name
china-audit-xls
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

896

jwangkun/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.

AI, LLMs & Agents143

China Accrual Schedule

896

jwangkun/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]".

Finance & Crypto143

China Accrual Schedule

896

jwangkun/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]".

Finance & Crypto143

China Dcf Model

896

jwangkun/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]".

AI, LLMs & Agents143

China AI Readiness

896

jwangkun/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]".

AI, LLMs & Agents143

China Lbo Model

896

jwangkun/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.

AI, LLMs & Agents143

Browse the most popular Claude skills, all ai, llms & agents skills, or write your own with the skills generator.