DEMONSTRATION CASE · SYNTHETIC DATA
Turn two Excel sheets into one exception list.
A small Python workflow matched orders to payment records, calculated expected differences, and separated the rows that needed a human decision.
THE PROBLEM
Manual matching hides the rows that actually matter.
The demonstration workbook contained an order sheet and a platform-payment sheet. A useful result required more than a lookup: missing transactions, refunds, and amount differences had to be labelled consistently without changing the source sheets.
Read separate sources
Load the original order and payment worksheets independently.
Match and calculate
Join on order number and calculate differences with explicit refund handling.
Classify exceptions
Mark missing payments and non-zero amount differences for review.
Deliver review sheets
Produce a full reconciliation sheet and a smaller exception-only sheet.
DELIVERABLES
Results that can be checked without reading the script.
- Reconciled workbook with source fields, difference, and status
- Exception-only worksheet for follow-up
- Reusable Python script and simple operating instructions
- Validation summary with row and exception counts
SIMILAR WORKFLOW?
Show the before and expected after.
A redacted sample and a written rule are usually enough for an initial feasibility and price assessment.