Thomas Eapen · Selected work

From source records to a reviewable audit

A conceptual reconciliation flow that makes differences and missing records visible for review.

Conceptual example · invented labels and relationshipsOne-page print edition · A3 landscape

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.

  1. 01 / PREPARE

    Normalise

    Align record keys, reporting periods and units.

  2. 02 / COMPARE

    Retain both sides

    Use all keys so missing counterparts stay visible.

  3. 03 / EXPLAIN

    Flag exceptions

    Distinguish a difference from an absent record.

  4. 04 / REVIEW

    Resolve with context

    Return the comparison to a reviewer before any correction.

Independently invented reconciliation; all quantities are minutes
RecordWorkforceSubmittedDifferenceStatus
Record A4804800Match
Record B420450+30Review difference
Record C300——Missing submission
Record D—240—Missing reference
Record E3603600Match
2matching records
3items needing review
  • 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.