Readable source
A single Python script with sample inputs, a small rules file, and plain output folders that are easy to inspect.
Launch price USD 9
CSV Reconciliation Starter Kit for Python
Compare two CSV or Excel files by ID, then export missing-row, duplicate, mismatch, JSON, and optional Excel reports.
reconciliation_demo
passed sample run
Matched keys
3
Mismatches
2
Duplicates
1
id
field
left
right
1003
status
paid
pending
1004
amount
49.00
59.00
Runs locally
No paid API key
Inputs
CSV, XLSX, XLSM
Outputs
CSV, JSON, XLSX
Verified
v1: 11 tests, sample JSON and CSV outputs
Choose the smallest useful scope
Get the starter kit or send a small CSV cleanup request.
The paid zip is not linked from this public preview. Use the request form to ask for the $9 launch kit, a $79 express audit, or a $199 cleanup sprint. Share only sanitized examples and do not post payment details, credentials, or private customer data.
What buyers get
A practical starter kit, not another empty template.
Operator-friendly reports
Missing records, duplicate IDs, field mismatches, and summary counts are exported as files a non-developer can review.
Shopify audit bonus
Includes a bonus product CSV checker for duplicate SKUs, empty descriptions, missing alt text, and SEO field gaps. Unofficial; not affiliated with Shopify.
Run the sample
One command produces the included report files.
python reconcile.py --left sample_data/source_a.csv --right sample_data/source_b.csv --rules rules.yml --out output/reconciliation_demoFree copy-paste brief
Use this tiny spec to request a CSV reconciliation script.
Goal:
Compare two CSV exports by customer_id and produce mismatch reports.
Input files:
- source_a.csv
- source_b.csv
Fields to compare:
- name
- email
- amount
- status
Expected output:
- summary.json with counts for matched keys, missing rows, mismatches, and duplicates
- mismatches.csv with customer_id, field, left, right
- optional Excel report if needed
Sample result:
summary.json: 3 matched keys, 2 mismatches, 1 duplicate
mismatches.csv:
customer_id,field,left,right
C002,email,user_b_old,user_b_new
C003,amount,42.00,40.00Clear support boundary
Self-serve code kit.
Includes setup instructions, sample data, and example output. Custom integration, accounting advice, tax advice, and guaranteed business outcomes are not included. Digital-download refunds and support should follow the checkout platform's published policy.