bank-reconPerform bank reconciliation between bank statement and general ledger Excel files. Supports custom thresholds for amount matching and semantic description ma...
Install via ClawdBot CLI:
clawdbot install ChipmunkRPA/bank-reconGrade Limited — based on market validation, documentation quality, package completeness, maintenance status, and authenticity signals.
Calls external URL not in known-safe list
http://schemas.openxmlformats.org/spreadsheetml/2006/mainAudited Apr 16, 2026 · audit v1.0
Generated Mar 22, 2026
A small business owner reconciles monthly bank statements with their general ledger to ensure all transactions are accounted for and identify discrepancies. This scenario involves uploading Excel files from their bank and accounting software, using default thresholds for exact matching, and reviewing unmatched items to catch errors like missing entries or incorrect amounts.
A non-profit accountant performs bank reconciliation as part of annual audit preparation, matching donations and expenses between bank records and the GL. They use custom thresholds to handle rounding differences and semantic description matching to group similar transactions, ensuring compliance and accurate financial reporting for stakeholders.
An e-commerce finance team reconciles daily bank deposits with sales transactions from their GL to manage high volumes of customer payments and refunds. They leverage ID/key matching for order references and tolerance thresholds to account for currency conversion variances, quickly identifying unmatched items for follow-up.
A multinational corporation reconciles bank statements across different currencies with their centralized GL, using the skill to handle exchange rate fluctuations and threshold adjustments. Semantic matching helps align descriptions from various branches, streamlining the process and reducing manual effort in cross-border accounting.
A freelancer reconciles bank statements with their GL to track income and expenses for tax purposes, using simple Excel inputs with date, amount, and description. They rely on the default threshold for exact matches and review unreconciled tabs to catch missed invoices or personal transactions, ensuring accurate financial records.
Integrate this skill into accounting software offered as a subscription service, providing automated bank reconciliation as a premium feature. This enhances value for users by reducing manual work and improving accuracy, leading to higher retention and upsell opportunities for advanced financial tools.
Offer consulting services to businesses for customizing and implementing this bank reconciliation skill within their existing financial systems. Revenue comes from project-based fees for setup, training, and ongoing support, targeting organizations needing tailored solutions for complex reconciliation needs.
Provide a free basic version of the skill for individual users or small businesses, with paid add-ons for advanced features like higher thresholds, batch processing, or integration with other financial platforms. This model drives user adoption and monetizes through upgrades for enhanced functionality.
💬 Integration Tip
Ensure input Excel files have consistent three-column formats (date, amount, description) and test with sample data to verify matching logic before full deployment in production environments.
Scored Apr 19, 2026
Create, inspect, and edit Microsoft Excel workbooks and XLSX files with reliable formulas, dates, types, formatting, recalculation, and template preservation...
Data analysis tool for Excel, CSV, Word, PDF, TXT, Markdown files. Use when user needs to analyze, summarize, or compare data from multiple files. Supports f...
PDF智能处理工具 v2.1 | PDF Smart Tool. 支持PDF转换、OCR识别、合并拆分、数字签名、批量处理、水印添加、加密解密。触发词:PDF、转换、识别。
Generate hand-drawn style diagrams, flowcharts, and architecture diagrams as PNG images from Excalidraw JSON
PDF扫描件转Word文档。支持中文OCR识别,自动裁掉页眉页脚,保留插图,彩色章节封面页保留为图片。使用百度OCR API(免费额度1000次/月)。当用户要求把扫描PDF转成文字/Word时触发。
Convert public web pages into clean Markdown with markdown.new for AI workflows. Use when tasks require URL-to-Markdown conversion for summarization, RAG ing...