Review the exported data for different payment types.
Stripe won’t change our export format. New processors can filter, map, and adjust the format of export files as needed. Our standard service level agreement (SLA) is 10 days to complete an export after we receive all valid data (excluding BACS).
We export ACH, SEPA, BACS, and PADs/ACSS as a CSV. We can also export card data in both CSV and JSON formats.
Card export fields
Card exports include the following fields.
CSV exports don’t include unique metadata fields by default, but we can include them if you provide an exact list of field names.
Small JSON exports include the customer metadata by default.
Field
Description
description
Text attached to the customer object
name
Name associated with the customer
email
Customer’s email
id
Stripe’s unique identifier of the customer (cus_XXXXX format)
card.address_city
City associated with the card
card.address_country
Country associated with the card
card.address_line1
First address line associated with the card
card.address_line2
Second address line associated with the card
card.address_state
State or province associated with the card
card.address_zip
Postal code associated with the card
card.exp_month
The month the card expires
card.exp_year
The year the card expires
card.id
The Stripe card ID object (card_XXXXX format)
card.name
Customer’s name on the card
card.number
The PAN (credit card number)
default_source
Stripe object associated with the customer’s default payment method (could be card_ID, pm_ID, src_ID, or ba_ID)
card.transaction_ids
Network transaction ID status for SCA compliance
Example card data export
DESCRIPTION
NAME
EMAIL
ID
CARD.ADDRESS_CITY
CARD.ADDRESS_COUNTRY
CARD.ADDRESS_LINE1
CARD.ADDRESS_LINE2
CARD.ADDRESS_STATE
CARD.ADDRESS_ZIP
CARD.EXP_MONTH
CARD.EXP_YEAR
CARD.ID
CARD.NAME
CARD.NUMBER
DEFAULT_SOURCE
CARD.TRANSACTION_IDS
User description
Stripey McStripe
test@example.com
cus_JeGmWqYRVUNu44
Anytown
US
101 1st Ave
Apt 1
CA
90210
9
2021
card_1J0yEyH65PkfON7E6pXEeoyZ
Stripey McStripe
5555551BT8Gs4444
card_1J0yEyH65PkfON7EQ0Owsy3Q
012345678901234
User description
Stripey McStripe
test@example.com
cus_JeGmWqYRVUNu44
Anytown
US
101 1st Ave
Apt 1
CA
90210
9
2021
card_1J0yEyH65PkfON7EQ0Owsy3Q
Stripey McStripe
424242TPSa0L4242
card_1J0yEyH65PkfON7EQ0Owsy3Q
012345678901234
User description
Stripey McStripe
test@example.com
cus_JeGmJLltEqM9jd
Anytown
US
101 1st Ave
Apt 1
CA
90210
9
2021
card_1J0yEyH65PkfON7EzGiGLo9c
Stripey McStripe
424242TPSa0L4242
card_1J0yEyH65PkfON7EzGiGLo9c
012345678901234
User description
Stripey McStripe
test@example.com
cus_JeGmdHOz48B3XA
Anytown
US
101 1st Ave
Apt 1
CA
90210
9
2021
card_1J0yExH65PkfON7E7ZHA0keF
Stripey McStripe
424242TPSa0L4242
card_1J0yExH65PkfON7E7ZHA0keF
012345678901234
ACH Export Fields
ACH exports include the following fields.
Field
Description
customer_id
Stripe’s unique identifier of the customer (cus_XXXXX format)
customer_created
Date that the customer object was created in Stripe
email
Customer’s email
description
Description text attached to the customer object
default_source
Stripe object associated with the customer’s default payment method (could be card_ID, pm_ID, src_ID, or ba_ID)
bank_account_id
The Stripe bank account object ID (ba_XXXXX format)
routing_number
Bank routing number
account_number
Customer’s bank account number
account_holder_name
Customer name associated with the bank account
account_holder_type
Boolean value that marks whether the account is owned by an individual or company
country
Country associated with the bank account
Example ACH data export
customer_id
customer_created
name
email
description
default_source
bank_account_id
routing_number
account_number
account_holder_name
account_holder_type
country
use
cus_JdW0ZauDFfHkfi
2021-06-09T00:08:59.062Z
Stripey McStripe
test@example.com
User description
ba_1J0EydH65PkfON7EQIkjVJUb
ba_1J0EydH65PkfON7EQIkjVJUb
110000000
000123456789
Stripey McStripe
individual
US
checking
cus_JdW0wbOcikkCIK
2021-06-09T00:08:59.659Z
Stripey McStripe
test@example.com
User description
ba_1J0EydH65PkfON7EuWIUgHnw
ba_1J0EydH65PkfON7EuWIUgHnw
110000000
000123456789
Stripey McStripe
individual
US
checking
cus_JdW05ASZDyr9mS
2021-06-09T00:09:00.161Z
Stripey McStripe
test@example.com
User description
ba_1J0EyeH65PkfON7E98oBUhwD
ba_1J0EyeH65PkfON7E98oBUhwD
110000000
000123456789
Stripey McStripe
individual
US
checking
cus_JdW02JwM87cx9r
2021-06-09T00:09:00.711Z
Stripey McStripe
test@example.com
User description
ba_1J0EyeH65PkfON7EfaUw4Exc
ba_1J0EyeH65PkfON7EfaUw4Exc
110000000
000123456789
Stripey McStripe
individual
US
checking
cus_JdW02JwM87cx9r
2021-06-09T00:09:00.711Z
Stripey McStripe
test@example.com
User description
ba_1J0EyeH65PkfON7EfaUw4Exc
ba_1J0EyfH65PkfON7EyHeoTbF9
110000000
000444444440
Stripey McStripe
individual
US
checking
SEPA export fields
SEPA exports include the following fields.
Field
Description
customer_id
Stripe’s unique identifier of the customer (cus_XXXXX format)
email
Customer’s email
description
Description text attached to the customer object
source_id
Stripe source ID associated with the customer’s payment method
payment_method_id
Stripe payment method ID associated with the customer’s payment method
owner_name
Customer name associated with the direct debit account
iban
IBAN associated with the mandate
mandate_reference
Unique identifier of the direct debit mandate on Stripe
currency
Currency associated with the payment method
Example SEPA data export
CUSTOMER_ID
EMAIL
DESCRIPTION
SOURCE_ID
PAYMENT_METHOD_ID
OWNER_NAME
IBAN
MANDATE_REFERENCE
CURRENCY
cus_111111111
test@example.com
Description1
src_1111111
Stripey McStripe
GB22TESTBB20201555555555
mandate_xxxx
eur
cus_222222222
test@example.com
Description2
pm_2222222
Rory O’D
DE22TESTBB20201555555555
mandate_yyyy
eur
cus_333333333
test2@example.com
Description3
pm_3333333
Frankie C
IE22TESTBB20201555555555
mandate_zzzz
eur
Bacs export fields
Bacs exports include the following fields.
Field
Description
merchant
The unique identifier of the Stripe account we’re exporting from (acct_XXXXX format)
customer_id
The Stripe unique identifier of the customer (cus_XXXXX format)
bacs_id Stripe payment method object associated with the customer’s direct debit mandate (in the format pm_XXXXX)
mandate_reference
Unique identifier of the direct debit mandate on Stripe
token
sort_code
Customer’s bank account sort code (6 digits in length and might include leading zeros)
account_number
Customer’s bank account number (8 digits in length and might include leading zeros)
effective_date
Date the mandate was activated on Stripe
recipient name
Customer’s name on the bank account
recipient_address_street
Customer’s street address associated with the customer’s bank account
recipient_address_city
Customer’s city address associated with the customer’s bank account
recipient_address_state
Customer’s state address associated with the customer’s bank account
recipient_address_zip
Customer’s postal code associated with their bank account