Transactions CSV Description

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 NameDescription
Catch Transaction IDCatch’s unique internal identifier for the transaction
TimestampThe timestamp when the transaction occurred
Transaction TypeThe type of the transaction (either purchase or refund)
Related Catch Transaction IDOnly populated for refunds: The ID of the purchase that is being refunded
Merchant Transaction IDThe ID the merchant provided to Catch for the transaction

Note: This value will only be populated if supplied by the merchant
Catch User IDCatch’s unique internal identifier for the user that created the transaction
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
External AmountThe amount the merchant provided to Catch for the transaction. This amount is prior to any reward adjustments or fees.
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.
Catch FeesThe total amount of Catch Fees charged for this transaction
Transaction Adjustment AmountThe impact of transaction adjustments on the Net Transaction Amount.
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
Related Merchant Transaction IDOnly populated for refunds: this related ID will point back to the Merchant Transaction ID of the Purchase. New field for reports version 2.2.
Platform Transaction IDFor Shopify merchants, this will be the Shopify Order ID for purchases, and the Shopify Refund ID for refunds. For merchants not on Shopify, it will be empty. New field in reports version 2.2.
Merchant IDCatch identifier for brand; This can be used to distinguish between brand reports when managing multiple Catch integrated brands.