- Transactions

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

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 NameExampleDescription
account_code123sd341The specific account code charged during the transaction.
nameJJ SmithCustomer name as stated in their billing data.
transaction_id6c17ba39e8734ebaa5bf98fff6d91bb9Unique identifier for the transaction within Recurly.
typeauthorization, purchase, refundSpecifies the type of transaction reported to the gateway.
amount9.95The total amount of the transaction sent to the payment gateway.
tax_amount15.00The tax charges associated with the transaction.
currencyUSDThe currency reported to the payment gateway for transaction processing.
date2012-01-19 11:16:41 PSTThe date and time the transaction took place. Used for "created" date range filter.
statusdeclined, void, success, processingThe response received from the payment gateway concerning the transaction.
messageThis transaction has been approvedMessage received from the payment gateway regarding the transaction.
testTRUE, FALSEIndicates if the transaction was carried out on a production gateway.
cc_typevisa, master, discover, amex, jcb, dinersThe type of credit card utilized for the transaction.
cvv_resultM, NThe result from checking the CVV/CVC value on the transaction when it was processed.
avs_resultN, P, DThe overall AVS result from checking the transaction when it was processed.
avs_result_postalN, YThe result from verifying the zip code on the transaction when it was processed.
avs_result_streetN, YThe result from verifying the address 1 value on the transaction when it was processed.
reference4119385445The identifier for the transaction from the payment gateway.
approval_codevaries by gatewayThe approval code for the transaction from the payment gateway.
descriptionvaries by gatewayThe description sent to the payment gateway for the transaction.
stateCAThe state value from the customer's billing information on the account.
countryUSThe country value from the customer's billing information on the account.
ip_address_countryUSThe country associated with the IP address of the customer's location when the transaction was processed.
original_transaction_id6b9fc18e2497498b9e3700cd55e2ea84For refunds, this field identifies the payment being refunded.
invoice_id4bdb2171cebe4ecfb0cb129bd1a65746References the invoice that generated this transaction.
subscription_id3252sdasdbe4ecfb0cb129bd1a65746References the subscription that instigated this transaction.
po_numberAE12523The purchase order number for the invoice.
collection_methodautomatic, manualThe type of collection method used for the invoice.
transaction_gateway_typetest, wirecard, authorize, etcThe payment gateway utilized to process the transaction.
modified_at2014-01-01 10:00:00 PSTThe date/time the transaction was last updated. Used for the "modified" date range filter.
originrecurring, API, hppIdentifies what initiated the transaction.
gateway_error_codes500Lists the gateway error code for declined transactions, if applicable.
payment_methodPayPal, Amazon Payment, Credit Card, etcSpecifies the method used for payment.
collected_at2014-01-01 10:00:00 PSTFor manually recorded payments, this reflects the specified date when recording the transaction.
fraud_decisionDECLINE, REVIEW, APPROVEContains the decision returned by the Kount risk check service for this transaction.
fraud_score36 (between 1 and 99)The risk score assigned by Kount's risk check service for this transaction.
fraud_message"848742"=>"BIN <> Billing Country"Contains all the rules triggered during the risk check service.
failure_typeinvalid_payment_method_hardProvides additional information regarding the failure type of a transaction.
gateway_codeih06u98jfotoThe gateway used for each transaction is denoted here.
cc_first_6111111The first six digits of the credit card used for processing the transaction.
vat_numberEU12345678The VAT or Tax ID number of the customer during the transaction in the export.
backup_payment_method_usedTRUE, FALSEIndicates whether a backup payment method was used in the transaction attempt.
vat_number123456Indicates vat number.

Version changelog

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.