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.