The monthly CSV report includes the following parameters:
- Transaction Reference
- Order ID
- Activity Date
- Time Zone
- Event Type
- Amount
- Currency
- Subtotal Amount
- Shipping Amount
- Tax Amount
- Discount Amount
- Exchange Rate
- Payment Method
- State
- Network
- Merchant Division
Event Types
The Event Type column may include the following values:
| Event type |
Description |
authorize |
The authorization event for a payment transaction. |
capture |
The capture event for a payment transaction. |
refund |
The refund transaction. |
platform_fee |
The platform fee charged for a specific transaction capture event. |
risk_fee |
The risk fee charged for a specific transaction capture event. |
network_fee |
The network fee charged for a specific transaction capture event. |
settled_net |
The net amount at settlement for either a capture or refund event. |
settled_processing_fee |
The processing fee at settlement for a capture event. |
settled_risk_fee |
The Bolt fee at settlement for a capture event. |
settled_network_fee |
The network fee at settlement. |
settled_apm_fee |
The APM fee at settlement. |
settled_bolt_account_fee |
The Bolt Account fee at settlement. |
total_fee_adjustment |
Sum of fees that have been adjusted against daily funding balance. |
funding_transfer |
The credit of funds to a merchant. |
funding_withdrawal |
The debit of funds from a merchant. |
funding_transfer_reversal |
The reversal of funding_transfer due to rejection or failure. |
funding_withdrawal_reversal |
The reversal of funding_withdrawal due to rejection or failure. |
merchant_credit |
The adjustment to credit funds to merchant. |
merchant_debit |
The adjustment to debit funds from merchant. |
Payment Methods
Cards:
alliance_data: Private label credit cards (PLCC)
payment_card: A card payment method (for example, credit card, debit card, etc.)
Alternative payment methods (APMs):
affirm
afterpay
applepay
amazon_pay
credova
klarna
paypal
radial_paypal
sezzle
Custom Calculations
Use the raw report data to build custom calculations. For example:
| Calculation |
Description |
Source |
| Total transaction amount |
Sum of all capture events |
Daily or monthly transaction statement |
| Total settled net amount (after fees) |
Sum of all settled_net events |
Bank transfer statement |
| Total fee amount |
Sum of all fee-related events |
Bank transfer statement |