Agent skill

Cn Ib Diligence Workpaper

by QiushenZou in QiushenZou/cn-investment-banking-skills

Structure Chinese investment-banking due-diligence materials into traceable schedules, testing workpapers, exception logs, and closure records.

Apache-2.0Auto-check passedDocuments & Office

Install Cn Ib Diligence Workpaper

skills CLI
$ npx skills add QiushenZou/cn-investment-banking-skills --skill cn-ib-diligence-workpaper -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install QiushenZou/cn-investment-banking-skills cn-ib-diligence-workpaper --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/QiushenZou/cn-investment-banking-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/cn-ib-diligence-workpaper .claude/skills/cn-ib-diligence-workpaper && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
cn-ib-diligence-workpaper
GitHub stars
102
Token cost
~1.4k tokens
SKILL.md length
576 words
Files
8 (incl. scripts, references, assets)
Skills in repo
11
Repo updated
First seen
Licence
Apache-2.0

At a glance

Structure Chinese investment-banking due-diligence materials into traceable schedules, testing workpapers, exception logs, and closure records.

  • Works in 8 steps: Define the workpaper objective → Build the population → Select and document procedures → …
  • Sponsorship diligence involving 关联方、董监高、银行流水、资金往来、客户供应商、合同、资质证照、房产租赁、子公司、股权沿革、合规证明、抽样核查、访谈、函证
  • SKILL.md covers Principles, Workflow and Outputs
  • Runs Python scripts from its folder; calls python3

What it does

Cn Ib Diligence Workpaper is an agent skill from QiushenZou/cn-investment-banking-skills. Structure Chinese investment-banking due-diligence materials into traceable schedules, testing workpapers, exception logs, and closure records. Use for IPO、再融资、并购重组 or sponsorship diligence involving 关联方、董监高、银行流水、资金往来、客户供应商、合同、资质证照、房产租赁、子公司、股权沿革、合规证明、抽样核查、访谈、函证 or Excel底稿. Use cn-ib-document-control when the task is only tracking receipt, signatures, originals, scans, and versions.

Its SKILL.md is about 1.4k tokens, which your agent loads only when the skill is triggered. The skill folder holds 11 other files, including scripts, reference files and assets (for example `agents/openai.yaml`, `references/evidence-standard.md` and `references/exception-protocol.md`).

It sits in Documents & Office, covering Excel spreadsheets and Fundraising and pitch decks. It works with Microsoft Excel. The repository describes itself as: Agent Skills for Chinese IPO sponsor execution: diligence, filing production, pre-submission QC, regulatory inquiries, and filing refresh. The licence is Apache-2.0.

When your agent uses it

  • Sponsorship diligence involving 关联方、董监高、银行流水、资金往来、客户供应商、合同、资质证照、房产租赁、子公司、股权沿革、合规证明、抽样核查、访谈、函证
  • Tasks that involve Excel spreadsheets
  • Tasks that involve Fundraising and pitch decks

Example prompts

  • “/cn-ib-diligence-workpaper”

Requirements

  • Python 3

Workflow steps

8 steps, taken from the step headings in SKILL.md.

  1. Define the workpaper objective
  2. Build the population
  3. Select and document procedures
  4. Record evidence
  5. Evaluate exceptions
  6. Validate the workpaper
  7. Form the conclusion
  8. Review and close

What it can do on your machine

Read from SKILL.md and the folder at commit b71a38c. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Ships 2 files in scripts/ (Python), which the agent can run.

    Shell commands in SKILL.md call:

    • python3

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Cn Ib Diligence Workpaper loads about 1.4k tokens when it runs, and up to ~2.2k if it reads all its reference files. Until then it costs about 103 tokens; SKILL.md has 576 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~103
When it runs · the whole SKILL.md, loaded when a task matches
~1.4k
With references · SKILL.md plus every file in references/, read only if the agent opens them
~2.2k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); the scripts in this folder are not scanned.

SKILL.md

The full file from QiushenZou/cn-investment-banking-skills at commit b71a38c, republished under its Apache-2.0 licence (© QiushenZou). 576 words, ~1,371 tokens.

Download SKILL.mdSave it as .claude/skills/cn-ib-diligence-workpaper/SKILL.md (or your agent's skills folder). This skill also uses 7 other files; get the full folder from GitHub.
name
cn-ib-diligence-workpaper
description
Structure Chinese investment-banking due-diligence materials into traceable schedules, testing workpapers, exception logs, and closure records. Use for IPO、再融资、并购重组 or sponsorship diligence involving 关联方、董监高、银行流水、资金往来、客户供应商、合同、资质证照、房产租赁、子公司、股权沿革、合规证明、抽样核查、访谈、函证 or Excel底稿. Use cn-ib-document-control when the task is only tracking receipt, signatures, originals, scans, and versions.

CN IB Diligence Workpaper

Turn unstructured evidence into a reproducible workpaper that links objective, population, procedure, evidence, exception, conclusion, reviewer, and closure.

Principles

  1. Start from the diligence objective, not from the available files.
  2. Preserve population, period, entity, sample method, and evidence provenance.
  3. Separate factual evidence, management explanation, analyst calculation, and professional conclusion.
  4. Never infer no exception from missing evidence.
  5. Record contradictory evidence rather than selecting the more convenient source.
  6. Do not claim sponsor, legal, or accounting sign-off. Route judgment to the responsible professional.
  7. Apply confidentiality and personal-data minimization. Never place live bank-account or identity data in public examples.

Workflow

1. Define the workpaper objective

State:

  • assertion or risk addressed;
  • entity and period;
  • population and completeness source;
  • materiality or review threshold;
  • planned procedure;
  • expected evidence;
  • responsible preparer and reviewer.

Read references/workstreams.md for common workstreams. Tailor the objective to the transaction instead of copying a generic checklist.

2. Build the population

Before selecting samples or summarizing findings:

  1. identify the source system or source schedule;
  2. record extraction date and preparer;
  3. reconcile population totals to an independent record where possible;
  4. preserve excluded records and exclusion rationale;
  5. mark incomplete populations as a scope limitation.

Do not treat a management-prepared list as complete without a completeness procedure.

3. Select and document procedures

Possible procedures include:

  • inspection;
  • recalculation;
  • external confirmation;
  • interview;
  • database or public-record search;
  • source-to-ledger tracing;
  • ledger-to-source vouching;
  • cross-document comparison;
  • analytical review;
  • full-population rule scan;
  • risk-based or statistical sampling.

Record why the procedure addresses the stated risk. For samples, record population size, selection logic, sample size, and selected IDs.

4. Record evidence

Use assets/workpaper-template.csv or equivalent XLSX fields. Read references/evidence-standard.md.

Minimum lineage:

text
workpaper_id, workstream, objective, procedure, subject, period,
population_source, sample_basis, source_document, source_location,
evidence_date, preparer, reviewer, status, exception,
management_explanation, conclusion, follow_up, closure_evidence

Retain calculations as formulas in spreadsheets. Keep assumptions in labeled cells and cite source documents in comments or evidence columns.

5. Evaluate exceptions

Read references/exception-protocol.md. For each exception:

  • describe the observed fact;
  • state the expected condition;
  • quantify the amount or scope where possible;
  • obtain and label management explanation;
  • identify corroborating or contradictory evidence;
  • assess whether the population or other samples may be affected;
  • assign owner and deadline;
  • record the closure test and evidence.

Avoid vague labels such as 已解释 without the explanation and corroboration.

Show full SKILL.md (214 more words)Show less
6. Validate the workpaper

For a CSV-form workpaper, run:

bash
python3 scripts/validate_workpaper.py workpaper.csv --output review-issues.csv

The script checks required lineage, duplicate IDs, invalid statuses, unsupported conclusions, and exception closure. Inspect the original evidence before resolving its findings.

For Word-format diligence questionnaires, run:

bash
python3 scripts/scan_questionnaire_completeness.py questionnaire.docx --output questionnaire-review.csv

The scanner distinguishes unchecked yes/no controls from drafting placeholders. It flags conflicting or unanswered selections and affirmative answers with apparently blank detail fields. A signature warning means only that execution cannot be verified from the DOCX package; it is not proof that a signature or seal is missing. Convert legacy .doc files only in a temporary directory before scanning.

7. Form the conclusion

Conclude only within the tested scope. Use formulations such as:

  • 在上述核查范围及程序下,未发现……;
  • 发现以下例外,尚待……;
  • 由于未取得……,暂无法就……形成结论.

Do not use 不存在任何问题 when testing was sampled, evidence was incomplete, or exceptions remain open.

8. Review and close

Completion requires:

  • objective and population are defined;
  • source and location are traceable;
  • calculations are reproducible;
  • exceptions have owners and follow-up;
  • conclusion matches evidence and scope;
  • reviewer and review date are recorded;
  • resolved exceptions retain closure evidence;
  • confidential data is protected.

Outputs

Deliver:

  1. structured workpaper schedule;
  2. exception log;
  3. evidence-gap list;
  4. open follow-up list by owner;
  5. scoped conclusion and limitations;
  6. reviewer-ready closure status.

Use temporary directories for extraction and previews. Save only final requested workpapers in the deal folder.

© QiushenZou, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 7 other files (scripts, references, assets) in skills/cn-ib-diligence-workpaper of QiushenZou/cn-investment-banking-skills.

  • SKILL.md
  • agents/openai.yaml
  • assets/workpaper-template.csv
  • references/evidence-standard.md
  • references/exception-protocol.md
  • references/workstreams.md
  • scripts/scan_questionnaire_completeness.py
  • scripts/validate_workpaper.py

Open the folder on GitHubat commit b71a38c

Compare with similar skills

Cn Ib Diligence Workpaper next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Cn Ib Diligence Workpaper compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Cn Ib Diligence Workpaper this skillQiushenZou/cn-investment-banking-skills102—~1.4kAutomated safety check: PassApache-2.0
Officecli Commonly TemplatesTeam-Commonly/commonly1.4k—~1.7kAutomated safety check: PassApache-2.0
Investment Due Diligence Reportxiaoyuge886/aigc198—~2.1kAutomated safety check: PassMIT
Officecli Skillsmingchen666/Reviva244—~2kAutomated safety check: PassNone
Officecli Document Workflowskuramatata/my-pi-agent114—~1kAutomated safety check: PassNone
Runway Monte Carlomohitagw15856/pm-claude-skills1.4k—~973Automated safety check: PassMIT

Similar skills

  • Officecli Commonly Templates

    Team-Commonly/commonly

    A skill your agent uses when producing a polished, Commonly-branded deliverable (.docx brief / memo, .xlsx data matrix, .pptx deck) and you do not have specific brand guidance from the user.

    1.4k GitHub stars~1.7k tokensUpdated yesterday
    Documents & OfficeAuto-check passed
  • 投资尽调报告专业生成工具。当用户需要撰写投资尽调报告、尽职调查报告、投资分析报告时使用此skill。支持处理Excel财务数据、PDF文档等多种格式数据源,自动生成包含执行摘要、业务分析、财务分析、风险提示、投资建议等核心章节的专业报告。无论用户明确要求"写报告"还是提到"分析投资标的"、"评估项目"、"做DD"等相关需求时,都应使用此skill。

    198 GitHub stars~2.1k tokensUpdated 2 mo ago
    Documents & OfficeAuto-check passed
  • Officecli Skills

    mingchen666/Reviva

    Unified OfficeCLI skill for creating, reading, and editing Office files.

    244 GitHub stars~2k tokensUpdated yesterday
    Documents & OfficeAuto-check passed
  • Officecli Document Workflow

    skuramatata/my-pi-agent

    A skill your agent uses when my-pi-agent needs to create, inspect, beautify, restyle, validate, or modify Office files through the official OfficeCLI MCP.

    114 GitHub stars~1k tokensUpdated 3 mo ago
    Documents & OfficeAuto-check passed
  • Runway Monte Carlo

    mohitagw15856/pm-claude-skills

    Cash runway as a distribution, not a number — Monte Carlo simulated.

    1.4k GitHub stars~973 tokensUpdated 2 days ago
    Business, Finance & HRAuto-check passed
  • Datapack Builder

    w95/awesome-claude-corporate-skills

    Build professional financial services data packs from various sources including CIMs, offering memorandums, SEC filings, web search, or MCP servers.

    244 GitHub starsUsed in 1 repo~6k tokens
    Business, Finance & HRAuto-check passed

More from QiushenZou/cn-investment-banking-skills

All 11 skills in this repo
  • Cn Ib Document Control

    QiushenZou/cn-investment-banking-skills

    Build, maintain, and review document-control registers for Chinese investment-banking transactions.

    102 GitHub stars~1.1k tokensUpdated 1 mo ago
    Auto-check passed
  • Cn Ib Filing Refresh Control

    QiushenZou/cn-investment-banking-skills

    Plan, execute, and review Chinese IPO or refinancing filing refreshes across reporting periods, transaction changes, inquiry responses, and document versions.

    102 GitHub stars~1.4k tokensUpdated 1 mo ago
    Auto-check passed
  • Cn Ib Inquiry Response Review

    QiushenZou/cn-investment-banking-skills

    Decompose and review Chinese IPO and refinancing regulatory inquiry responses for complete issue coverage, evidence, intermediary procedures, explicit opinions, filing synchronization, and follow-up…

    102 GitHub stars~1.3k tokensUpdated 1 mo ago
    Auto-check passed
  • Cn Ib Ipo Workflow

    QiushenZou/cn-investment-banking-skills

    Route and control Chinese IPO sponsor-execution work by lifecycle stage.

    102 GitHub stars~851 tokensUpdated 1 mo ago
    Auto-check passed
  • Cn Ib Memo Builder

    QiushenZou/cn-investment-banking-skills

    Turn source materials into concise, source-backed Chinese investment-banking memos with clear facts, analysis, decisions, risks, and actions.

    102 GitHub stars~1.1k tokensUpdated 1 mo ago
    Auto-check passed
  • Cn Ib Regulatory Case Research

    QiushenZou/cn-investment-banking-skills

    Find, screen, rank, and synthesize Chinese capital-markets regulatory precedents and comparable filing responses.

    102 GitHub stars~1.1k tokensUpdated 1 mo ago
    Auto-check passed

Works with

Questions about Cn Ib Diligence Workpaper

What does Cn Ib Diligence Workpaper do?

Structure Chinese investment-banking due-diligence materials into traceable schedules, testing workpapers, exception logs, and closure records. Cn Ib Diligence Workpaper is an agent skill from QiushenZou/cn-investment-banking-skills. Structure Chinese investment-banking due-diligence materials into traceable schedules, testing workpapers, exception logs, and closure records.

When should I use Cn Ib Diligence Workpaper?

Cn Ib Diligence Workpaper fits situations like: sponsorship diligence involving 关联方、董监高、银行流水、资金往来、客户供应商、合同、资质证照、房产租赁、子公司、股权沿革、合规证明、抽样核查、访谈、函证; tasks that involve Excel spreadsheets; tasks that involve Fundraising and pitch decks.

How do I install Cn Ib Diligence Workpaper in Claude Code?

Run `npx skills add QiushenZou/cn-investment-banking-skills --skill cn-ib-diligence-workpaper -a claude-code`. Or copy the skill folder (skills/cn-ib-diligence-workpaper in QiushenZou/cn-investment-banking-skills) into .claude/skills/cn-ib-diligence-workpaper in your project. Claude Code loads it when a task matches its description.

How do I install Cn Ib Diligence Workpaper in Codex?

Run `npx skills add QiushenZou/cn-investment-banking-skills --skill cn-ib-diligence-workpaper -a codex`. Or copy the skill folder (skills/cn-ib-diligence-workpaper in QiushenZou/cn-investment-banking-skills) into .agents/skills/cn-ib-diligence-workpaper in your project. Codex loads it when a task matches its description.

Can I use Cn Ib Diligence Workpaper in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add QiushenZou/cn-investment-banking-skills --skill cn-ib-diligence-workpaper -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/cn-ib-diligence-workpaper, .gemini/skills/cn-ib-diligence-workpaper, .github/skills/cn-ib-diligence-workpaper and .opencode/skills/cn-ib-diligence-workpaper in your project.

What does Cn Ib Diligence Workpaper need to run?

Going by SKILL.md and its folder, Cn Ib Diligence Workpaper needs Python for the scripts in its folder and the command-line tools its instructions call (python3). Our summary lists: Python 3.

Does Cn Ib Diligence Workpaper access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Cn Ib Diligence Workpaper safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.

What licence does Cn Ib Diligence Workpaper use?

Cn Ib Diligence Workpaper is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Cn Ib Diligence Workpaper use?

About 1.4k tokens (SKILL.md is roughly 5.5k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 798 tokens, read only when the agent opens those files.

What are the alternatives to Cn Ib Diligence Workpaper?

Skills that share tags, products or a category with Cn Ib Diligence Workpaper: Officecli Commonly Templates (Team-Commonly/commonly, 1.4k stars), Investment Due Diligence Report (xiaoyuge886/aigc, 198 stars), Officecli Skills (mingchen666/Reviva, 244 stars) and Officecli Document Workflow (skuramatata/my-pi-agent, 114 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Cn Ib Diligence Workpaper?

QiushenZou (a GitHub user) maintains it in QiushenZou/cn-investment-banking-skills, which has 102 GitHub stars. The repository holds 11 skills in this directory. The repository was last updated on August 17, 2026.

Source: QiushenZou/cn-investment-banking-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.