Getting it into your agent
One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.
npx skills add vivy-yi/finance-skills --skill reconciliation-automationgit clone --depth 1 https://github.com/vivy-yi/finance-skillsWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/skills/vivy-yi/finance-skills/reconciliation-automation)<a href="https://agentmods.dev/skills/vivy-yi/finance-skills/reconciliation-automation"><img src="https://agentmods.dev/badge/skills/vivy-yi/finance-skills/reconciliation-automation/github.svg" alt="Measured on agentmods" height="20"></a>Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.
<a href="https://agentmods.dev/skills/vivy-yi/finance-skills/reconciliation-automation"><img src="https://agentmods.dev/badge/skills/vivy-yi/finance-skills/reconciliation-automation.svg" alt="Reviewed on agentmods" width="80" height="20"></a>What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00100 | $0.02229 |
| Opus 5 | $0.00050 | $0.01115 |
| Sonnet 5 | $0.00020 | $0.00446 |
| Haiku 4.5 | $0.00010 | $0.00223 |
Grade A, and why
reconciliation-automation scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 9d ago.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
How it starts
The opening of the file, as written. The whole thing — 240 lines — stays where its author put it; the contents beside it link to each section on GitHub.
加载上下文
首次使用时： 读取 ../../CLAUDE.md 获取场景级配置（银行账户列表/数据源状态）。
/reconciliation-automation — 自动对账
Examples
→ 示例：用户说"帮我自动跑一遍银行调节表的核对"，系统应调用本技能，执行银行调节表自动核对。
→ 示例：用户说"有几个银行账户调节不出来，帮我看看差异在哪里"，系统应调用本技能，分析银行调节表未达项。
→ 示例：用户说"帮我们设置一个自动调节规则，让系统自动匹配银行流水"，系统应调用本技能，配置银行流水自动匹配规则。
对账原理
企业视角 vs 银行视角：
企业付款 100 元：
- 企业账面：记录一笔 100 元付款（企业已付）
- 银行记录：跨行转账可能延迟 1-2 天到达（银行未付）
银行扣费（手续费）：
- 银行记录：已扣 50 元手续费（银行已付）
- 企业账面：可能未记账（企业未付）
→ 对账的作用：找出这两类差异，生成调节表
第一步：数据导入
从 [BANK] 导出对账单：
银行企业网银 → 历史交易查询 → 筛选对账期间 → 导出 Excel/CSV
字段要求：交易日期 / 交易金额 / 对方账户 / 摘要 / 交易类型（收入/支出）
从 [ERP] 导出银行凭证：
ERP → 银行模块 → 导出当月所有银行凭证
字段要求：凭证日期 / 凭证金额 / 银行账户 / 对方账户 / 摘要
第二步：数据标准化
统一日期格式：
原始格式 → 标准格式
2026/6/15 → 2026-06-15
2026年6月15日 → 2026-06-15
06/15/2026 → 2026-06-15（注意美式日期）
统一金额格式：
原始格式 → 标准格式
1,000.00 → 1000.00
￥1,000 → 1000.00
(1,000) → -1000.00（括号为负数）
第三步：自动匹配
匹配算法
精确匹配条件（同时满足）：
条件1：|企业付款金额| = |银行扣款金额|（允许 ±0.01 元误差）
条件2：企业付款日期与银行扣款日期在 ±3 个工作日内
条件3：对方账户一致（或可追溯到同一笔交易）
匹配分类
| 匹配结果 | 条件 | 标记 |
|---|---|---|
| 双向已达 | 企业已付 & 银行已付，金额日期一致 | ✅ 已达账 |
| 企业已付银行未付 | 企业已付，但银行尚无记录 | ⚠️ 银行未达（企业付） |
| 银行已付企业未付 | 银行已付，但企业尚无记录 | ⚠️ 企业未达（银行付） |
| 金额差异 | 金额不完全一致 | ⚠️ 金额差异待查 |
| 无法匹配 | 金额/日期均无法对应 | ❌ 异常需排查 |
第四步：未达账项处理
银行未达（企业已付，银行未付）
正常未达（可接受）：
情形：跨行转账，本行已付但对方银行未到账
处理：标记为"在途资金"，在调节表中作为加项
金额通常在 1000-50000 元之间
1-2 个工作日后会自动到达
处理：✅ 标记"正常在途"，定期跟踪
异常未达（需排查）：
情形：转账时间超 5 个工作日仍银行未达
可能原因：
- 收款账户信息错误（账号/户名不符）
- 收款银行系统延迟
- 触发反欺诈模型被拦截
处理：
1. 联系付款银行查询交易状态
2. 如确认失败，办理退汇
3. 退汇后重新发起正确付款
企业未达（银行已付，企业未付）
正常未达（可接受）：
情形：银行扣收手续费/账户管理费/利息税
企业通常在次月收到银行对账单后入账
处理：标记为"银行待记账项"，在调节表中作为减项
金额通常较小（≤ 1000 元）
异常未达（需排查）：
情形：银行已扣款但企业无对应凭证
可能原因：
- 银行扣收了我方未知的费用（如罚款/年费）
- 银行系统记录错误
- 被不明扣款
处理：
1. 立即联系银行查询扣款原因
2. 如为银行错误，要求银行退款
3. 如为企业漏记账，补录凭证
4. 如为不明扣款，保留追诉权利并报案
第五步：生成银行调节表
═══════════════════════════════════════════════════════════
银行调节表
═══════════════════════════════════════════════════════════
银行账户：[开户行 + 账号]
对账期间：[YYYY年MM月]
调节日期：[YYYY-MM-DD]
编制人：[姓名]
═══════════════════════════════════════════════════════════
企业账面余额：[X,XXX,XXX.XX] 元
加：银行已收企业未收（[X] 笔）：
1. [日期] [金额] 元 — [原因：如在途资金]
2. [日期] [金额] 元 — [原因：如手续费待入账]
小计：[X,XXX.XX] 元
减：银行已付企业未付（[X] 笔）：
1. [日期] [金额] 元 — [原因：如手续费待入账]
2. [日期] [金额] 元 — [原因：如不明扣款待查]
小计：[X,XXX.XX] 元
调整后企业余额：[X,XXX,XXX.XX] 元
银行对账单余额：[X,XXX,XXX.XX] 元
差异：[X.XX] 元（差异应为 0）
═══════════════════════════════════════════════════════════
差异为 0：[✅ 对账完成] / 差异不为 0：[❌ 须排查]
═══════════════════════════════════════════════════════════
【未达账项跟踪】
银行未达（企业付）：
- [金额] 元，[日期起]，状态：[在途/异常/已到账]
- [金额] 元，[日期起]，状态：[在途/异常/已到账]
企业未达（银行付）：
- [金额] 元，[日期起]，状态：[待入账/异常/已入账]
- [金额] 元，[日期起]，状态：[待入账/异常/已入账]
【下一步行动】
→ [如差异为 0] 对账完成，流转至下一节点
→ [如差异不为 0] 须排查差异原因后再完成对账
═══════════════════════════════════════════════════════════
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- 9d ago First seen · 240 lines · 100 tokens per session scan A 349d6e9d1487
reconciliation-automation is a skill published in the GitHub repository vivy-yi/finance-skills (29 stars, last pushed 3mo ago), licensed MIT. It adds 100 tokens to every session and 2,229 once invoked, about $0.0005 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-09-03.
Other skills, from other repositories
wealth-structure
A framework for thinking about wealth through ownership, responsibility, leverage, and avoiding risks that could end your progress.
alpha-vantage
Access real-time and historical stock market data, forex rates, cryptocurrency prices, commodities, economic indicators, and 50+ technical indicators via the Alpha Vantage API. Use when fetching stock prices (OHLCV), company fundamentals (income statement, balance sheet, cash flow), earnings, options data, market…
hedgefundmonitor
Query the OFR (Office of Financial Research) Hedge Fund Monitor API for hedge fund data including SEC Form PF aggregated statistics, CFTC Traders in Financial Futures, FICC Sponsored Repo volumes, and FRB SCOOS dealer financing terms. Access time series data on hedge fund size, leverage, counterparties, liquidity…
edgartools
Python library for accessing, analyzing, and extracting data from SEC EDGAR filings. Use when working with SEC filings, financial statements (income statement, balance sheet, cash flow), XBRL financial data, insider trading (Form 4), institutional holdings (13F), company financials, annual/quarterly reports (10-K…
asc-ppp-pricing
Set territory-specific pricing for subscriptions and in-app purchases using current asc setup, pricing summary, price import, and price schedule commands. Use when adjusting prices by country or implementing localized PPP strategies.
fred-economic-data
Query FRED (Federal Reserve Economic Data) API for 800,000+ economic time series from 100+ sources. Access GDP, unemployment, inflation, interest rates, exchange rates, housing, and regional data. Use for macroeconomic analysis, financial research, policy studies, economic forecasting, and academic research requiring…