Thomas Eapen · Selected work
From source records to a reviewable audit
A conceptual reconciliation flow that makes differences and missing records visible for review.
SOURCE A / ILLUSTRATIVE
Workforce totals
Four prepared records in a common unit: minutes for one invented reporting period.
SOURCE B / ILLUSTRATIVE
Submitted totals
Four corresponding submission records. One differs, and the two sources have unmatched keys.
01 / PREPARE
Normalise
Align record keys, reporting periods and units.
02 / COMPARE
Retain both sides
Use all keys so missing counterparts stay visible.
03 / EXPLAIN
Flag exceptions
Distinguish a difference from an absent record.
04 / REVIEW
Resolve with context
Return the comparison to a reviewer before any correction.
| Record | Workforce | Submitted | Difference | Status |
|---|---|---|---|---|
| Record A | 480 | 480 | 0 | Match |
| Record B | 420 | 450 | +30 | Review difference |
| Record C | 300 | — | — | Missing submission |
| Record D | — | 240 | — | Missing reference |
| Record E | 360 | 360 | 0 | Match |
- Record B: 450 − 420 = +30 minutes.
- Record C: no submission; the difference remains unknown.
- Record D: no workforce counterpart; retain it for investigation.
A clear exception is more useful than an unexplained total. Compare prepared totals under a common key and unit. This example does not calculate pay, apply employment rules or automatically correct a source record.