Home / Issuing / Generate Reports
Note: ATM and manual cash-related transactions, such as withdrawals, deposits, and balance inquiries, are excluded from this report because they are billed differently.
This report contains transaction-level card interchange and settlement activity across all financial accounts for your organization.
Data for this report is available as follows:
Field Name | Data type | Description |
---|---|---|
posted_date_time | DateTime (ISO 8601: YYYY-MM-DDTHH:MM:SSZ) | The date when the transaction was posted to the financial account |
platform_settlement_date | Date | The date when the transaction was settled on the platform, 5 PM Pacific Standard Time (PST) cutoff |
card_product_id | String | Unique identifier for the card product |
card_product_name | String | Name of the card product with the ledger entry |
card_profile_set_id | String | Unique id of the card profile for a given card product |
network_name | String | The name of the card network provider (Visa, Mastercard) |
classification | String | The network BIN product type (consumer, commercial, business, etc.) |
funding_type | String | Card funding type according to the network BIN product type (credit, prepaid, debit) |
payment_card_id | String | Unique identifier for the card |
processing_network_code | String | Card transaction network; possible values are VNT (Visanet), MCC (Mastercard Dual Message), MDS (Maestro Single Message), PUL (PULSE), MPS (Moneypass) |
financial_event_id | String | Unique identifier for the financial event |
financial_event | String | Categorizes the activity of the financial event (e.g., AUTHORIZE_AND_CLEAR , REVERSAL , CLEAR ) |
transaction_id | String | Transaction lifecycle identifier; for example, two transaction events (AUTH and CLEAR) make up one complete transaction lifecycle, so both events will have the same transaction lifecycle id. Multi-clearing transaction events with different financial_event_id s will share the same transaction_id |
transaction_settlement_amount | Decimal | The amount of the transaction that was settled. A positive entry is a debit transaction, for example, purchases. A negative entry is a credit transaction, for example, returns |
transaction_settlement_amount_currency_code | String | The ISO 4217 currency code representing the currency of the settlement amount |
interchange_amount | Decimal | The interchange amount for the transaction; positive for income, negative for expense |
interchange_amount_currency_code | String | The ISO 4217 currency code representing the currency of the interchange amount |
network_interchange_rate_code | String | A code provided by the card network that denotes the interchange category or rate applied to the transaction; only available for VNT and MCC |
merchant_category_code | String | Merchant Category Code (MCC) is a four-digit number listed in ISO 18245 for retail financial services; MCC is used to classify the business by the type of goods or services it provides |
merchant_name | String | The name of the merchant where the transaction took place |
merchant_description | String | The name of the location where the transaction took place |
merchant_country | String | The ISO3166 Alpha3 Country code representing the country where the merchant is located |