메뉴
Extract bank PDF/CSV to transactions.json with running-balance proof (pull bank lines with balance proof). Prefer CSV; Maybank Islamic PDF adapter when needed.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
| name | extract-bank-statement |
| description | Extract bank PDF/CSV to transactions.json with running-balance proof (pull bank lines with balance proof). Prefer CSV; Maybank Islamic PDF adapter when needed. |
Bank lines → structured transactions with proof, not vibes.
pdfplumber / CSV → layout adapter → Decimal balance proof → Excel / JSON
shared/guardrails.md and references/bank_statement_extraction.md.python3 scripts/extract_bank.py \
--input /path/to/statements \
--output ./outputs/bank.xlsx \
--also-json ./workpapers/transactions.json \
--client-slug <slug> \
--fail-on-error
# detect only
python3 scripts/extract_bank.py --input /path/to/statements --detect-only
# CLI
npx @cynco/accounting-skills extract ./statements --out ./bank.xlsx --json ./txns.json
| Adapter | Status |
|---|---|
maybank_islamic_pdf | Production (pdfplumber + line proof) |
cimb_csv | Production (debit/credit CSV + balance proof) |
generic_csv | Production (flexible headers) |
| Other PDF brands | Ask CSV — do not freestyle 1000 lines in chat |
Maybank-only direct script (still valid):
python3 scripts/extract_maybank_islamic_pdf.py \
--input /path/to/statements \
--output ./bank.xlsx \
--also-json ./workpapers/transactions.json \
--fail-on-error
line_balance_ok / open–close proof in extract meta| Input | Action |
|---|---|
| Maybank Islamic PDF | extract_bank / Maybank script |
| CIMB / generic CSV | extract_bank CSV adapters |
| Other bank digital PDF | Prefer CSV; else new adapter (copy Maybank pattern) |
| Scanned image PDF | Ask for CSV or OCR pipeline — not vision freestyle |
Done when: transactions.json (and optional xlsx) written, line/open–close balance proof passes (or must stop recorded), source register updated.
--fail-on-error must be set for production extractsDefault for throw-work: dump a folder, "do the accounting", "sort my books", year end, prepare financial statements / MPERS pack without naming a stage. One intake then books; resumes from engagement_state.json. Depth-scoped done.
Human pack (HTML board) plus statements when depth needs them. Use when presenting books, opening the pack, or drafting FS/notes from adjusted TB.
Prove the job for this engagement depth (books scorecard or full QC).
Optional router if lost — which slash to use. Prefer saying do the accounting.
Scaffold clients/<slug> folder layout. Use when new client folder or workspace layout. Also the shelf step: organize scattered docs by entity and period before extract (see shared/shelf-first.md).
Firm profile cold-start (not a client dump). Use when set up the firm or first install.