event_processed_at.
Columns
event_amount is unsigned in this report — a refund of 97.00 appears as
97.00, not -97.00. Use event_type to determine direction. The settlement
report signs the same amount negative, because there the column feeds an
arithmetic total.Refunds
Refunds need care, because two different identifiers are in play.payment_idis the original payment being refunded, prefixedPAYM_. It is the same value that appears on the correspondingSALEorCAPTURErow.event_ididentifies the refund itself, prefixedREFN_.
event_type, but it is not a
substitute for it — match on event_type in your logic and treat the identifier
itself as opaque.
Example
report_transactions_succeeded-my_merchant-20260801_to_20260831.csv