Back to Directory
research
Data quality & reconciliation with exception
Reconciles data sources using stable identifiers (Pay Number, driving licence, driver card, and driver qualification card numbers), producing exception reports and “no silent failure” checks. Use when you need weekly matching with explicit reasons for non-joins and mismatches.
Installation
Run this in your terminal or add to your configuration:
# Clone into your skills directory
git clone ...About this Skill
- Initial release of the data-reconciliation-exceptions skill.
- Reconciles multiple data sources using stable identifiers (Pay Number, driver documents).
- Produces comprehensive exception reports with explicit reasons for each non-match or mismatch.
- Implements “no silent failure” checks—pipelines stop when anomalies or tolerance breaches are detected.
- Provides clear input requirements, configurable normalization, and threshold options.
- Outputs a detailed CSV report categorizing every record (matched, missing, duplicate, mismatch, invalid).