data-reconciliation

What problem does it solve?

This Skill addresses the critical need for data accuracy and consistency by systematically comparing datasets from multiple sources to identify and report discrepancies, duplicates, and orphaned records.

Core Features & Use Cases

• Discrepancy Identification: Compares records across systems using defined keys to find mismatches in values.
• Duplicate Detection: Scans individual datasets to identify and report duplicate entries.
• Orphan Record Reporting: Highlights records present in one system but missing from another.
• Use Case: Regularly reconcile financial transaction data between your accounting software and bank statements to ensure all entries are accounted for and match precisely, preventing financial errors and compliance issues.

Quick Start

Use the data-reconciliation skill to compare the 'source_transactions.csv' and 'target_transactions.csv' files using 'transaction_id' as the matching key and report any value mismatches in the 'amount' field.