An automated AI agent skill designed to query and parse complex bank statement reconciliation progress directly from Feishu Bitable applications.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install bank-reconciliation-query
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install bank-reconciliation-query using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Bank Reconciliation Query?
The bank reconciliation query skill is a specialized automation component designed for Openclaw Skills that connects an AI agent to multi-dimensional Feishu Bitable databases. It enables conversational intelligence to look up, evaluate, and report the real-time status of bank reconciliations across various financial institutions, clearing houses, and banking branches.
By interfacing directly with underlying relational datasets, this skill helps finance departments eliminate manual spreadsheet tracking. It translates direct user prompts, such as checking specific branch progress or audit deadlines, into precise database queries while normalizing inconsistent dataset structures behind the scenes.
Bank Reconciliation Query Use Cases
- Financial managers checking if a specific bank branch has concluded monthly reconciliations.
- Operations teams auditing bill release statuses for automated financial pipelines.
- Identifying missing statements or unreconciled balances that require immediate human follow-up.
- Consolidating historical financial data from past years with active fiscal cycles.
How Bank Reconciliation Query Works
- Extract and Filter: The skill catches natural language triggers (e.g., "How is the reconciliation going for Bank X?") and maps them to a targeted search using a
containsoperator against the designated bank nickname field. - Fetch Data Records: It executes an asynchronous call using
feishu_bitable_app_table_recordto pull records from the multi-dimensional table viewvewMajMqop. - Evaluate Accounting Rules: The skill executes automated evaluation logic to divide data timelines, ignoring finalized historical logs (such as past data from 2025) while strictly auditing active 2026 data arrays month-by-month.
- Status Mapping: It evaluates field amounts and string tags to classify accounting periods into standardized states: Completed, Pending Reconciliation, or No Bill/Not Arrived.
- Format Response: The raw evaluated data matrix is structurally printed into a developer-friendly Markdown table template for clear visibility.
Bank Reconciliation Query Setup
To deploy this skill within your ecosystem, map your Openclaw Skills runtime configuration to bind the following multi-dimensional Feishu Bitable parameters:
# Example Environment Setup for Bitable App Integration
EXPORT FEISHU_APP_TOKEN="OAAObourea2XKGsPjFQcyeX8nBb"
EXPORT FEISHU_TABLE_ID="tblEf5Jz9ncE0QDG"
EXPORT FEISHU_VIEW_ID="vewMajMqop"
Ensure that your agent has access tokens containing read/write scopes for the target Bitable environment before calling the tool configuration layer.
Bank Reconciliation Query Data Schema & Taxonomy
The skill relies on specific relational keys within the references/schema.md framework. Because field names can fluctuate between monthly entries, the skill maps data directly out of the returned record.fields payload using structural validation rather than guessing hardcoded strings.
Core Schema Field Profiles
| Field Reference | Data Type | Parsing Logic / Business Definition |
|---|---|---|
银行简称 |
String | Used as the target query parameter for filtering data records. |
2026XX |
Currency / Float | Monthly transaction volume. Empty or 0.0 indicates a zero-transaction month. |
XX对账完成 |
Enum / String | State string matching. Explicitly checks for "完成" or "对账完成但暂不开票". |
260X出账 |
Enum / String | Bill release confirmation indicator. Explicitly checks for "已出账". |
商务姓名 |
String | Assigned business point of contact. |
对账周期 |
String | Reconciliation cadence descriptor (e.g., Monthly, Quarterly, Annually). |
Bank Reconciliation Query Advanced Features
- Historical Data Compaction: Automatically compacts older structural logs into generalized single-line summaries to preserve context windows.
- Dynamic Schema Normalization: Parses unstable table schemas natively by inspecting runtime payload objects (
record.fields) instead of brittle hardcoded attributes. - Automated Reminder Triggers: Highlights un-reconciled intervals where financial values exist but lack sign-offs, flagging records requiring urgency actions.
SKILL.md
Loading
Related Openclaw Skills
axiom-cron-whisperer
A fast, dependency-free Python tool and API designed to translate standard 5-field cron syntax into plain-English or French descriptions.
axiom-uuid-analyzer
A deterministic, standard library-powered UUID inspector to parse, validate, and extract metadata from UUID versions 1 through 8.
axiom-hash-multi
A zero-dependency, streaming multi-algorithm hash generator that computes up to five distinct cryptographic hashes simultaneously for strings or files.
axiom-phone-e164
A high-performance python utility to parse, validate, and convert local or international phone numbers into the standardized E.164 format without external dependencies.
HeartFlow
HeartFlow is an advanced cognitive engine that gives AI systems self-reflection, multi-layered memory, and event-driven personality emergent behaviors.
Food Review Monitor
An automated delivery review monitoring and intelligent analysis skill that helps food and beverage businesses track customer feedback across multiple platforms.
Featured*
