A Python-powered automation tool that transforms raw bank exports into consolidated, audit-ready Excel transaction workbooks.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install transaction-records-cn
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 transaction-records-cn 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 Transaction Record Generator?
This skill within the Openclaw Skills ecosystem is designed to streamline the complex task of financial reconciliation. It processes raw data exports from China Merchants Bank (CMB)—including current accounts and wealth management products—as well as corporate account statements. By automating the extraction and normalization of data, it eliminates the manual labor typically associated with monthly financial reporting.
The tool is particularly valuable for users needing to maintain a clear overview of their capital flow. It synthesizes disparate file formats like CSV, XLS, and XLSX into a single, structured Excel file that includes dedicated sheets for different account types and a summarized cash flow statement, ensuring all financial data is organized and accessible.
Bank Transaction Record Generator Use Cases
- Consolidating monthly bank statements from multiple CMB personal and corporate accounts.
- Automating the tracking of wealth management investments, including subscriptions and redemptions.
- Generating standardized cash flow summaries for archival and auditing purposes.
- Preparing clean financial data for import into secondary accounting or ERP systems.
How Bank Transaction Record Generator Works
- The user provides raw bank export files (CSV, XLS, or XLSX) containing a specific period identifier (YYYYMM) in the filename.
- The script parses the source data from current accounts, wealth management records, and corporate ledgers.
- Business logic is applied to categorize transactions, such as identifying wealth management dividends as interest.
- Balance calculations are performed using embedded Excel formulas to ensure dynamic updates when the file is opened.
- A final Excel workbook is generated, merging all accounts into a single file with a unified cash flow summary sheet.
Bank Transaction Record Generator Setup
To use this Openclaw Skills component, first install the required Python dependencies and then execute the script with the desired period.
# Install required libraries
pip install openpyxl xlrd
# Navigate to the skill directory
cd skills/transaction-records
# Generate records for a specific month (e.g., February 2026)
python scripts/transaction_records.py 202602
Bank Transaction Record Generator Data Schema & Taxonomy
The skill produces a single Excel file named Transaction_Record_YYYYMM.xlsx with the following structure:
| Sheet Name | Source Type | Description |
|---|---|---|
| CMB Current | CSV | Transaction details for current/savings accounts. |
| CMB Wealth | XLSX | Details of wealth management product transactions. |
| Corporate | XLS | Transaction history for corporate/business accounts. |
| Cash Flow | Summary | A consolidated view of all capital movements for archiving. |
Bank Transaction Record Generator Advanced Features
- Dynamic balance calculation using native Excel formulas for real-time accuracy.
- Intelligent handling of investment dividends, automatically converting units to interest remarks.
- Support for legacy .xls formats alongside modern .xlsx and .csv exports.
- Configurable initial balance settings for wealth management tracking.
- Automated generation of secondary accounting ledgers via integrated sub-scripts.
SKILL.md
Loading
Related Openclaw Skills
AI Executor Skill
A specialized AI image generation agent for e-commerce creative teams that automates high-quality asset production using top-tier AI models.
AI Quality Inspector
A specialized quality gatekeeper that audits e-commerce images for AI artifacts, brand consistency, and platform compliance.
AI Planner
A sophisticated creative engine that transforms raw e-commerce product requirements into optimized, production-ready image generation briefs.
OpenClaw Security Handbook (CN)
A comprehensive security auditing and hardening suite for OpenClaw environments based on the ZAST.AI security handbook.
image-collector
A professional image procurement tool designed to automatically collect, verify, and optimize news-related images from official sources.
Pipeline Keeper
Pipeline Keeper is an AI-driven sales judgment layer that transforms CRM data and spreadsheets into actionable daily push-lists and drafted follow-ups.
Featured*
