Accounting reports v2.1

Accounting reports v2.0 are the default version of our reports. You may be upgraded to v2.1 by request.

Notable changes from v2.0 to v.2.1 include:

Reordering of report columns to improve usability of reports
Removal of duplicative columns (e.g. Related Merchant Transaction ID) to improve usability of reports
Addition of new Merchant ID column for purposes of report identification

Below you will find the new order of all columns per CSV. Please see individual CSV documentation (linked) for additional information on column definitions.

summary.csv

Start Timestamp
End Timestamp
Purchase Amount
Refund Amount
Catch Fees
Net Redeemed Rewards
Transaction Adjustment Amount
Net Transaction Amount
Unsettled Balance
Total Settled in Period
Rewards Granted
Rewards Canceled
Rewards Expired
Change in Outstanding Rewards
Total Outstanding Rewards
Report ID
Merchant ID

settlements.csv

Timestamp
Settlement Description
Amount
Settlement ID
Merchant ID

settlement_events.csv

Transaction Type
Amount
Settlement Event ID
Catch Transaction ID
Settlement ID
Merchant ID

transactions.csv

Timestamp
Merchant Transaction ID
Merchant User ID
Transaction Type
External Amount
Net Redeemed Rewards
Catch Fees
Transaction Adjustment Amount
Net Transaction Amount
Catch Transaction ID
Related Catch Transaction ID
Catch User ID
Merchant ID

transaction_adjustments.csv

Adjustment Type
Adjustment Amount
Catch Transaction ID
Merchant ID

reward_events.csv

Timestamp
Event Type
Triggering Transaction Type
Change in Outstanding Rewards
Net Redeemed Rewards
Reward Expiration Timestamp
Reward Event ID
Reward ID
Triggering Transaction ID
Catch User ID
Merchant ID