Skip to content

Deposit / Withdraw — PW

Processing principles

  1. Fetch eligible transactions from the correct API/vendor.
  2. Apply status filters and approved exclusions.
  3. Deduplicate on stable transaction ID, not the amount alone.
  4. Write through GAS only when the correct date section is prepared.
  5. 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.