bankreconciliatie

What it does

This skill automates the tedious process of bank reconciliation by programmatically matching bank statements against accounting records. It processes two CSV files and identifies matches based on amounts and dates, incorporating a configurable tolerance window for timing differences.

Why use this skill

Manual reconciliation is prone to human error and time-consuming. This developer-focused tool uses a Python-based logic engine to perform mechanical matching, allowing accountants to focus exclusively on exceptions. Unlike simple prompts, this skill handles various CSV formats (European and US decimal/date separators), detects column headers automatically, and provides a structured audit trail of matched versus unmatched items.

Supported tools

• Standard CSV exports from banking portals and accounting software
• Python 3 backend for robust data processing
• Flexible data parsing (supports dd/mm/yyyy and yyyy-mm-dd)

The Output

The agent generates a summary report including the number of exact matches, tolerance matches (date drift), and a detailed list of unmatched items with hypothetical reasons (e.g., timing difference, missing entry, or rounding error) to guide final human verification.

Built by Nex AI. More skills and info at nex-ai.be and slopsome.com.