bank-recon
Perform bank reconciliation between bank statement and general ledger Excel files. Supports custom thresholds for amount matching and semantic description matching. Use when the user wants to reconcile financial records, find matching transactions, and generate a reconciliation report in Excel.
Install via CLI (Recommended)
clawhub install openclaw/skills/skills/chipmunkrpa/bank-reconBank Reconciliation Skill
This skill automates the process of matching bank statement records with general ledger entries.
Workflow
- Input Verification: Identify the paths to
bank_data.xlsxandgl_data.xlsx. - Threshold Configuration: Ask the user for a reconciliation threshold (e.g., "Allow matches within $1.00?"). Default is $0.00.
- Execution: Run the
scripts/recon_logic.pyscript to process the files. - Reporting: Provide the resulting
recon_results.xlsxfile which details:- Matched records from both sides.
- Match basis (Amount, Description, or both).
- Variances within the threshold.
Tool Usage
Run the reconciliation script using Python:
python3 scripts/recon_logic.py <bank_xlsx> <gl_xlsx> <output_xlsx> <threshold>
Description Matching Logic
The skill uses semantic matching to identify common vendor names, invoice IDs, or transaction references between the bank description and GL memo.
Metadata
Not sure this is the right skill?
Describe what you want to build — we'll match you to the best skill from 16,000+ options.
Find the right skillPaste this into your clawhub.json to enable this plugin.
{
"plugins": {
"official-chipmunkrpa-bank-recon": {
"enabled": true,
"auto_update": true
}
}
}Related Skills
redline
Review and redline DOCX contracts paragraph by paragraph with tracked changes, clause-level risk analysis, and draft comment responses. Use when a user wants contract revisions that are specific to each paragraph or bullet, especially for privacy, security, data-processing, liability, AI, or other negotiated legal terms.
accounting-finance-system-research
Research and solve "how do I do this?" questions inside accounting and finance software systems (ERP, GL, AP/AR, billing, close, and reporting tools). Use when a user needs operational steps, setup guidance, or troubleshooting help in a specific system and wants the result documented as a quick memo or simple Q-and-A DOCX.
finresearchclaw
Finance, accounting, and investment research automation via the FinResearchClaw repo. Use when asked to run autonomous finance research workflows such as event studies, factor-model research, accounting regressions, forecast-error analysis, valuation research, or investment research pipelines. Prefer execution in this order: (1) Codex/ACP Codex when available, (2) Claude Code/ACP Claude, (3) direct API/config mode only as a fallback.
brd-reviewer
Review Business Requirements Documents in `.docx` format by reading the existing BRD, extracting paragraph-level context, drafting clarification questions for unclear statements, and producing a final Word document that combines comments and tracked changes. Use when the user wants a BRD reviewed, challenged for ambiguity, or redlined with proposed wording improvements while preserving Word-native review features.
relativity-deposition-question-builder
Develop deposition question sets from Relativity-exported PDF productions using a user-provided legal theory. Use when tasks involve reviewing opponent-produced PDFs, extracting per-page document IDs from the bottom-right corner (if two numbers appear, use the smaller one), mapping document relevance to a legal theory, and drafting questions grouped by document ID with required rationale and supporting quotes.