What does this compare?
It compares two CSV files by a matching key, then checks selected fields for differences. Excel support is optional with openpyxl.
Product details
Use this copy for Payhip, Ko-fi Shop, Gumroad, Lemon Squeezy, or a portfolio product page. Keep payment details inside the marketplace account, not in public issue comments or public listings.
Stop checking two spreadsheet exports by hand. The CSV Reconciliation Starter Kit is a lightweight Python template for comparing two CSV files with a configurable matching key and selected fields. Use it to spot: - Records missing from file A - Records missing from file B - Duplicate matching IDs - Field-level differences - Summary counts for a quick review Included: - Python reconciliation script - Sample CSV input files - Editable rules.yml - Example output reports - Quick-start README - CSV/JSON report exports - Optional Excel workbook output when openpyxl is installed - Bonus Shopify CSV Audit Kit Requirements: - Python 3.10+ - No paid API key - CSV support works with Python standard library - Excel input/output requires optional openpyxl Important boundary: this is not accounting, tax, legal, financial, security, or business advice. It helps surface differences between files; it does not certify correctness or replace professional review.
It compares two CSV files by a matching key, then checks selected fields for differences. Excel support is optional with openpyxl.
No. It reports differences so you can review them. It does not rewrite source files.
You should be comfortable running a basic Python command and editing a small YAML file. The included sample files give you a working starting point.
Need help adapting the kit to your files? Express CSV audit: $79 Send one sanitized file pair and the output you want. I return findings, mismatch examples, and the smallest next fix. Reconciliation cleanup sprint: $199 I adapt the rules to one concrete file pair, run the reports, and return the script, output folder, README, and verification notes.