Skip to content

Reconciliation — PL

Reconciliation should compare eligible approved API transactions with recorded Sheet transactions by stable identifiers, dates and relevant amount/status fields.

Diagnostic categories

Category Meaning Action
MATCHED Approved API record corresponds to Sheet record No action
API_ONLY API record not found in Sheet Investigate / controlled backfill
SHEET_ONLY Sheet record not found in eligible API set Investigate source and eligibility
FIELD_MISMATCH Same ID but field mismatch Verify before correction

The exact production categories, exclusions and lifecycle rules must be confirmed against current code.