Deposit / Withdraw — PW¶
Processing principles¶
- Fetch eligible transactions from the correct API/vendor.
- Apply status filters and approved exclusions.
- Deduplicate on stable transaction ID, not the amount alone.
- Write through GAS only when the correct date section is prepared.
- Record failures with enough sanitized metadata to replay safely.
Important past issue patterns¶
DATE_SECTION_NOT_READY_OR_FULL: do not advance a cursor as though a transaction were successfully written; investigate section capacity and writer competition.- API transactions missing from Sheet: reconcile and use idempotent controlled backfill rather than manual copying without checks.
- Vendor bank/name mismatches: preserve validation warnings for review.
These are historical issue patterns, not assertions that any incident is currently active.