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

Recurly transactions can be categorized into three types and four statuses, providing detailed insights into payment flows.

Transaction types

Authorization: A $1 or $0 transaction created to validate payment information usability after billing updates.
Purchase: A positive charge sent to the processor for fund collection and transfer to your merchant bank.
Refund: A negative charge sent to the processor to reimburse and transfer funds back to the customer’s bank.

Transaction Statuses

Success: The transaction was accepted by the gateway for processing.
Declined: The transaction was rejected by the gateway and will not be processed.
Void: Processing was stopped before settlement (e.g., when issuing full refunds before a purchase is fully settled).
Processing: The payment is in progress with the gateway, commonly seen with direct debit transactions.

Exports table

Download Button Download our complete export schema

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.