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]".
How do I install this agent skill?
npx skills add https://github.com/jwangkun/claude-for-financial-services-cn --skill china-audit-xlsIs this agent skill safe to install?
- Gen Agent Trust Hubpass
The china-audit-xls skill is a comprehensive framework for auditing A-share financial models according to Chinese Accounting Standards. It focuses on logic verification and data cross-checking using established financial data providers without any malicious code, obfuscation, or unauthorized data access patterns.
- Socketwarn
1 alert: gptAnomaly
- Snykpass
Risk: LOW · No issues
What does this agent skill do?
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 免费备选)
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 | ✓ |
| Consistent formulas | Same formula across periods | ✓ |
| No circularity (unless intended) | Circular refs flagged | ✓ |
| Error handling | IFERROR used where needed | ✓ |
| Named ranges | Key cells named | ✓ |
| Sheet references | Cross-sheet refs work | ✓ |
| Broken links | No external links or all work | ✓ |
Common hardcodes to find:
- Growth rates embedded in formulas
- Multiples typed into cells
- Shares outstanding hardcoded
- Tax rates not in assumptions
Step 3: Historicals Cross-Check
Cross-check against source data:
| Line Item | Model | iFind / AkShare / 巨潮 | Difference | Explanation |
|---|---|---|---|---|
| 营业收入 | ||||
| 营业成本 | ||||
| 归母净利润 | ||||
| 总资产 | ||||
| 净资产 | ||||
| 经营现金流 |
Cross-check tolerance:
- Revenue, profit: ±2%
- Balance sheet: ±1%
- Cash flow: ±3% (timing differences)
Step 4: CAS Compliance Check
CAS-specific checks:
| Check | Description |
|---|---|
| Revenue net of VAT | 营业收入 not gross |
| R&D expensed | Not capitalized (unless criteria met) |
| Tax calculation | 25% / 15% rate applied correctly |
| Minority interest | Separated from parent equity |
| Government grants | Correct classification |
| 合同负债 | Recognized appropriately |
| 信用减值损失 | CAS 22 model applied |
Step 5: Balance Sheet Integrity
BS checks:
| Check | Formula | Pass |
|---|---|---|
| BS balances | Assets = L + E | ✓ |
| Cash flow ties | Ending cash = Beginning + Net CF | ✓ |
| Debt schedule | Short + Long = Total debt | ✓ |
| Share count | Shares × Price = Market cap | ✓ |
| Minority interest | Correct % applied | ✓ |
Step 6: Forecast Logic Check
Forecast quality:
| Check | Description | Pass |
|---|---|---|
| Growth reasonable | Within industry range | ✓ |
| Margins stable | No unexplained jumps | ✓ |
| Working capital | Trends with revenue | ✓ |
| CapEx | Consistent with depreciation | ✓ |
| Debt service | Can be serviced from FCF | ✓ |
| Dividend | Consistent with policy | ✓ |
Growth rate benchmarks:
| Metric | Conservative | Base | Optimistic |
|---|---|---|---|
| Revenue growth | 5-10% | 10-20% | 20-30% |
| Margin expansion | 0 ppts | 0-2 ppts | 2-5 ppts |
| Tax rate | 25% | 25% | 15% (if 高新) |
Step 7: Valuation Check
Valuation audit:
| Method | Check | Pass |
|---|---|---|
| DCF | WACC reasonable (6-10%) | ✓ |
| DCF | Terminal growth < GDP growth | ✓ |
| DCF | FCF positive in base case | ✓ |
| Comps | Peer group appropriate | ✓ |
| Comps | Multiples reasonable | ✓ |
| Football field | Min/median/max consistent | ✓ |
WACC components (China):
| Component | Typical Range |
|---|---|
| Risk-free rate (CGB 10Y) | 2.0-3.0% |
| Equity risk premium | 6-8% |
| Cost of debt | 3-6% |
| Tax rate | 25% (15% for 高新) |
Step 8: Sensitivity & Scenario Check
Sensitivity audit:
| Check | Description |
|---|---|
| Sensitivity tables | Key variables tested |
| Scenarios | Base / Bull / Bear |
| Tornado chart | Key drivers identified |
| Monte Carlo (if used) | Assumptions reasonable |
Step 9: Common A-share Model Errors
Error checklist:
| Error | Detection | Fix |
|---|---|---|
| 收入用含税 | VAT not removed | Divide by 1.13 |
| 税率错误 | Wrong rate applied | Verify 高新 status |
| 单位错误 | 千元 vs 万元 | Standardize |
| 季度加总错误 | Q+Q ≠ Annual | Check sum |
| 增长率计算 | Wrong base period | Verify formula |
| 少数股东损益 | Missing | Add if applicable |
| 折旧年限 | Wrong | Check FA notes |
Step 10: Audit Report
Standard audit output:
【模型审计报告】[Company] [Date]
一、结构检查
[Structure assessment]
二、公式检查
[Formula audit results]
三、历史数据核对
[Cross-check results]
四、CAS合规检查
[CAS compliance]
五、预测逻辑检查
[Forecast quality]
六、估值检查
[Valuation audit]
七、发现的问题
[List of issues with severity]
八、建议修复
[Recommended fixes]
总体评价: [Pass / Pass with conditions / Fail]
Quality Checks
Before completing:
- All structural checks passed
- No hardcodes found
- Historicals cross-checked
- CAS compliant
- BS/CF integrity verified
- Forecast logic sound
- Valuation reasonable
- All issues documented
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: Skip iFind, use AkShare onlywind-only: Wind only, error if unavailablewind-fallback: Wind first, fallback to iFind → AkShare
How can the creator link this skill?
Add the canonical catalog link to the repository README so users can inspect current installs and available audits. The publishing guide covers the complete discovery path.
<a href="https://skillzs.dev/skills/jwangkun/claude-for-financial-services-cn/china-audit-xls">View china-audit-xls on skillZs</a>