Transactions - export
Maximize your understanding of every payment interaction with the comprehensive Transactions export.
Overview
Required plan
This feature or setting is available to all customers on any Recurly subscription plan.
Definition
The Transactions export section provides a detailed report of all interactions communicated to and received from the payment gateway while processing a transaction. This data gives you a deeper understanding of every payment interaction to help you manage your financial transactions better.
Filters
Date Range Filters
Created
Involves transactions created within a chosen time span, utilizing the "date" column in the export.
Modified
Entails transactions modified in a selected time range, reflected in the "modified_at" column in the export.
Exports table
To help you identify and organize information effectively, the export provides a structured table that contains the following columns:
| Column Name | Example | Description |
|---|---|---|
| account_code | 123sd341 | The specific account code charged during the transaction. |
| name | JJ Smith | Customer name as stated in their billing data. |
| transaction_id | 6c17ba39e8734ebaa5bf98fff6d91bb9 | Unique identifier for the transaction within Recurly. |
| type | authorization, purchase, refund | Specifies the type of transaction reported to the gateway. |
| amount | 9.95 | The total amount of the transaction sent to the payment gateway. |
| tax_amount | 15.00 | The tax charges associated with the transaction. |
| currency | USD | The currency reported to the payment gateway for transaction processing. |
| date | 2012-01-19 11:16:41 PST | The date and time the transaction took place. Used for "created" date range filter. |
| status | declined, void, success, processing | The response received from the payment gateway concerning the transaction. |
| message | This transaction has been approved | Message received from the payment gateway regarding the transaction. |
| test | TRUE, FALSE | Indicates if the transaction was carried out on a production gateway. |
| cc_type | visa, master, discover, amex, jcb, diners | The type of credit card utilized for the transaction. |
| cvv_result | M, N | The result from checking the CVV/CVC value on the transaction when it was processed. |
| avs_result | N, P, D | The overall AVS result from checking the transaction when it was processed. |
| avs_result_postal | N, Y | The result from verifying the zip code on the transaction when it was processed. |
| avs_result_street | N, Y | The result from verifying the address 1 value on the transaction when it was processed. |
| reference | 4119385445 | The identifier for the transaction from the payment gateway. |
| approval_code | varies by gateway | The approval code for the transaction from the payment gateway. |
| description | varies by gateway | The description sent to the payment gateway for the transaction. |
| state | CA | The state value from the customer's billing information on the account. |
| country | US | The country value from the customer's billing information on the account. |
| ip_address_country | US | The country associated with the IP address of the customer's location when the transaction was processed. |
| original_transaction_id | 6b9fc18e2497498b9e3700cd55e2ea84 | For refunds, this field identifies the payment being refunded. |
| invoice_id | 4bdb2171cebe4ecfb0cb129bd1a65746 | References the invoice that generated this transaction. |
| subscription_id | 3252sdasdbe4ecfb0cb129bd1a65746 | References the subscription or list of subscriptions that instigated this transaction. |
| po_number | AE12523 | The purchase order number for the invoice. |
| collection_method | automatic, manual | The type of collection method used for the invoice. |
| transaction_gateway_type | test, wirecard, authorize, etc | The payment gateway utilized to process the transaction. |
| modified_at | 2014-01-01 10:00:00 PST | The date/time the transaction was last updated. Used for the "modified" date range filter. |
| origin | recurring, API, hpp | Identifies what initiated the transaction. |
| gateway_error_codes | 500 | Lists the gateway error code for declined transactions, if applicable. |
| payment_method | PayPal, Amazon Payment, Credit Card, etc | Specifies the method used for payment. |
| collected_at | 2014-01-01 10:00:00 PST | For manually recorded payments, this reflects the specified date when recording the transaction. |
| fraud_decision | DECLINE, REVIEW, APPROVE | Contains the decision returned by the Kount risk check service for this transaction. This data mirrors the fraud info api object. |
| fraud_score | 36 (between 1 and 99) | The risk score assigned by Kount's risk check service for this transaction. This data mirrors the fraud info api object. |
| fraud_message | "848742"=>"BIN <> Billing Country" | Contains all the rules triggered during the Kount's risk check service. Each number is the fraud_risk_rule code and the text that follows is the fraud_risk_rule message. This data mirrors the fraud info api object. |
| failure_type | invalid_payment_method_hard | Provides additional information regarding the failure type of a transaction. |
| gateway_code | ih06u98jfoto | The gateway used for each transaction is denoted here. |
| cc_first_6 | 111111 | The first six digits of the credit card used for processing the transaction. |
| vat_number | EU12345678 | The VAT or Tax ID number of the customer during the transaction in the export. |
| backup_payment_method_used | TRUE, FALSE | Indicates whether a backup payment method was used in the transaction attempt. |
| vat_number | 123456 | Indicates vat number. |
| card_brand | Mastercard | Card brand |
| card_type | credit | Card type |
| card_level | prepaid | Card level |
| card_issuer | JP Morgan Chase Bank NA | Card issuer |
| card_issuing_country | US | Card issuing country |
| transaction_api_id | gyqgg0d3v9n1 | v3 API identifier for the transaction within Recurly. |
Version changelog
Version 8 - 10/5/2024
- Column Additions: Addition of transaction_api_id.
Version 7 - 9/24/2024
- Column Additions: Addition of card_brand, card_type, card_level, card_issuer, card_issuing_country columns.
Version 6 - 8/1/2023
- Column Changes: Introduced "vat_number" column for merchants to capture customer's VAT or Tax ID number during a transaction in the export.
Version 5 - 4/20/21
- Column Changes: The 'backup_payment_method_used' column was added at the end of the export to identify transactions initiated through a backup payment method attempt.
Version 4 - 5/23/2019
- Column Changes: 'cc_first_6' column incorporated at the end of the export.
Version 3 - 4/25/2019
- Column Additions: Addition of "cc_first_6" column.
Version 2 - 1/15/2019
- Mapping: New payment gateway mappings included for Adyen, Qiwi, SEPA, SOFORT, and iDeal.
Updated 12 days ago