Log In

Description

The transactions CSV is a list of transactions that occurred in the reporting period. This includes both purchase and refunds.

Note, as above, that because Catch does not pull funds, the transactions in this CSV may be different from those in the settlement events CSV. For example, if a merchant carries a negative balance into the reporting period, we may include transactions from prior to the reporting period in the settlement events CSV but not here. If a merchant carries a negative balance out of the reporting window, we may include transactions here but not in the settlement events CSV.

Columns

Column NameDescriptionReport Version
Catch Transaction IDCatch’s unique internal identifier for the transactionv2.0+
TimestampThe timestamp when the transaction occurredv2.0+
Transaction TypeThe type of the transaction (either purchase or refund)v2.0+
Related Catch Transaction IDOnly populated for refunds: The ID of the purchase that is being refundedv2.0+
Merchant Transaction IDThe ID the merchant provided to Catch for the transaction

Note: This value will only be populated if supplied by the merchant
v2.0+
Catch User IDCatch’s unique internal identifier for the user that created the transactionv2.0+
Merchant User IDThe ID the merchant provided to Catch for the user

Note: This value will be blank on Refund transactions and will only be populated on Purchase transactions if supplied by the merchant
v2.0+
External AmountThe amount the merchant provided to Catch for the transaction. This amount is prior to any reward adjustments or fees.v2.0+
Net Redeemed RewardsThe impact reward redemptions had on the Net Transaction Amount.

A reward redemption would result in a negative value. A refund of a purchase on which credits were redeemed would result in a positive value.
v2.0+
Catch FeesThe total amount of Catch Fees charged for this transactionv2.0+
Transaction Adjustment AmountThe impact of transaction adjustments on the Net Transaction Amount.v2.0+
Net Transaction AmountThe amount owed to the merchant based on this transaction, after taking into account rewards and fees

Net Transaction Amount = External Amount + Net Redeemed Rewards + Catch Fees
v2.0+
Merchant IDCatch identifier for brand; This can be used to distinguish between brand reports when managing multiple Catch integrated brands.v2.1+