← Back to Skills Marketplace
runkecheng

银行账单对账进度查询

by runkecheng · GitHub ↗ · v1.0.2 · MIT-0
cross-platform ✓ Security Clean
51
Downloads
0
Stars
0
Active Installs
3
Versions
Install in OpenClaw
/install bank-reconciliation-query
Description
查询银行账单对账进度。当用户问某个银行的账单对账进度(如「XX银行对账进度如何」「XX支行对完了吗」)时使用。数据源为飞书多维表格「绑卡_银行账单汇总统计」→「绑卡银行对账表」。绑定字段完整定义见 references/schema.md。
README (SKILL.md)

银行账单对账进度查询

数据源

  • 多维表格: 绑卡_银行账单汇总统计
  • 数据表: 绑卡银行对账表
  • 视图: 银行对账(view_id=vewMajMqop

查询流程

1. 获取记录

按用户输入的银行名称/简称筛选记录(filter 参数用 contains 匹配 银行简称 字段):

feishu_bitable_app_table_record(
  action="list",
  app_token="OAAObourea2XKGsPjFQcyeX8nBb",
  table_id="tblEf5Jz9ncE0QDG",
  view_id="vewMajMqop",
  page_size=100,
  filter={conjunction:"and", conditions:[{field_name:"银行简称", operator:"contains", value:["关键词"]}]}
)

返回记录包含 fields 对象,字段定义见 references/schema.md

2. 解析对账状态

关键规则(🛑 务必严格执行):

25年(202504~202512)

  • 均已出账,查询时无需关注,不展示

26年(202601~202605)

每个月独立判断,根据 lookup 字段 2026XX 是否有金额决定:

条件 解读
2026XX 无此字段 / 无金额 账单未到或该月无交易
2026XX 有金额,且对应 XX对账完成 = 完成 / 对账完成但暂不开票 ✅ 对账完成
2026XX 有金额,且对应 XX对账完成 字段不存在、为空或非完成状态 ⚠️ 未对账完成,需跟催
2026XX 有金额且为 0.0万 该月无交易金额

⚠️ 字段名注意: 各月描述字段命名不统一,不要猜字段名,直接从返回的 record.fields 中取现有字段来判断。见 schema.md 的「字段匹配规则」。

出账状态

  • 2603出账 / 2604出账 / 2605出账 = 已出账 → 该月已出账
  • 缺少该字段或不等于 已出账 → 未出账

3. 输出格式

标准输出结构(🛑 每条必须标注年度-月度,防止混淆):

{银行全称}({银行简称})
商务:{商务姓名} | 对账周期:{月度/季度/半年度/年度} | 账单周期:{周期描述}

**📋 对账进度:**

| 时间 | 金额 | 出账 | 对账完成 |
|------|:----:|:----:|:--------:|
| 25年(历史) | — | ✅ 均已出账 | — |
| 26年1月 | XX | — | ✅ 完成 |
| 26年2月 | XX | — | ✅ 完成 |
| 26年3月 | XX | ✅ 已出账 | ✅ 完成 |
| 26年4月 | XX | ✅/❌未出账 | ❌ 未对账 |
| 26年5月 | XX | ✅/❌未出账 | ❌ 未对账 |

判断对照表:

状态标签 条件
已完成 XX对账完成 = 完成 / 对账完成但暂不开票
待对账/未对账 XX对账完成 字段为空/不存在,但有金额
无账单/未到 2026XX 无金额,或金额=0.0万,且对账完成字段为空

25年数据: 均已出账,统一展示为一行「25年(历史)— ✅ 均已出账 —」即可,不逐月展开。

Usage Guidance
Install this only where the agent is allowed to access the specified Feishu Bitable and view bank reconciliation amounts and business contact information. Use appropriately scoped Feishu credentials because the skill is read-only by instruction, but it still exposes sensitive business data to the agent during use.
Capability Assessment
Purpose & Capability
The stated purpose is to answer bank reconciliation progress questions, and the artifact only instructs the agent to query a specific Feishu Bitable, interpret defined fields, and format the results.
Instruction Scope
Runtime instructions are scoped to filtering records by bank short name, reading returned fields, and presenting monthly reconciliation status; no unrelated commands, prompt overrides, mutation steps, or hidden behavior were found.
Install Mechanism
The artifact contains only markdown files, SKILL.md and references/schema.md, with no executable scripts, binaries, install hooks, or package installation steps.
Credentials
The skill requires Feishu/API access and reads business/financial reconciliation data plus staff names, which is sensitive but disclosed and directly necessary for the stated purpose.
Persistence & Privilege
No persistence, background workers, local indexing, credential harvesting, privilege escalation, or create/update/delete authority is described.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install bank-reconciliation-query
  3. After installation, invoke the skill by name or use /bank-reconciliation-query
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.2
- Output format simplified: 25年(历史)数据统一合并为一行,仅标注已出账,不再逐月展示。 - 26年账单进度表中的字段简化,去除「状态」列,仅保留时间、金额、出账、对账完成四项,更清晰明了。 - 进一步强调对账结果解读规则及字段匹配注意事项,减少歧义。 - 保持核心判断规则、接口调用方式与之前版本一致。
v1.0.1
No visible changes detected in this version. - No updates to code or documentation were found. - Functionality and instructions remain unchanged.
v1.0.0
- Initial release of the skill for querying bank reconciliation progress. - Supports user queries about the reconciliation status for specific banks and months. - Connects to Feishu Bitable "绑卡_银行账单汇总统计" → "绑卡银行对账表" as the data source. - Returns detailed 2026 month-by-month reconciliation status, including amounts, billing, and completion statuses based on strict schema field matching. - Ignores all 2025-related data per business rules.
Metadata
Slug bank-reconciliation-query
Version 1.0.2
License MIT-0
All-time Installs 0
Active Installs 0
Total Versions 3
Frequently Asked Questions

What is 银行账单对账进度查询?

查询银行账单对账进度。当用户问某个银行的账单对账进度(如「XX银行对账进度如何」「XX支行对完了吗」)时使用。数据源为飞书多维表格「绑卡_银行账单汇总统计」→「绑卡银行对账表」。绑定字段完整定义见 references/schema.md。 It is an AI Agent Skill for Claude Code / OpenClaw, with 51 downloads so far.

How do I install 银行账单对账进度查询?

Run "/install bank-reconciliation-query" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is 银行账单对账进度查询 free?

Yes, 银行账单对账进度查询 is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does 银行账单对账进度查询 support?

银行账单对账进度查询 is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created 银行账单对账进度查询?

It is built and maintained by runkecheng (@runkecheng); the current version is v1.0.2.

💬 Comments