Free Spreadsheet Reconciliation Learning Path
The matching desk

GOAL
Reconcile two transaction lists, identify missing and mismatched records and build a review sheet that preserves the original data.

START
Read workbook.html, inspect case-data.csv, complete the five stage outputs, then the capstone. Use evidence-log.csv to record only actions actually performed.

CASE
A fictional club compares its internal payment log with a bank export. Match by a unique reference after trimming spaces. Do not match by amount alone. The dates are outside this simplified exercise; all amounts are teaching units.

TOOLS
Basic spreadsheet formulas. Use Excel if available or a free spreadsheet with equivalent lookup and conditional functions.

LOCAL COMMANDS / OPENING
python reconcile.py

ASSESSMENT
Score at least 80/100, supply every required artifact, and satisfy the path-specific critical condition. Rework missing evidence before marking complete.
Critical condition: No unexplained difference is hidden in an adjustment row and missing values remain distinguishable from zero.

SOURCE COURSES
Excel Formulas and Functions: Free Course — https://wikifree.com/courses/free-simon-sez-it-excel-formulas-functions/

RIGHTS AND SCOPE
Original WikiFree teaching case and exercises. All case data are synthetic. Provider lessons are linked, not redistributed. No certificate, real project delivery or unperformed runtime test is claimed.
