# Export file formats 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 | | `use` | Enum value identifying the account type as either `checking` or `savings` | ### 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 | ## UK Bacs export fields UK 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 | | `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 | | `recipient_address_country` | Country associated with the bank account | ### Example BACS data export | MERCHANT | CUSTOMER_ID | BACS_ID | MANDATE_REFERENCE | TOKEN | SORT_CODE | ACCOUNT_NUMBER | EFFECTIVE_DATE | RECIPIENT__NAME | RECIPIENT__ADDRESS__STREET | RECIPIENT__ADDRESS__CITY | RECIPIENT__ADDRESS__STATE | RECIPIENT__ADDRESS__ZIP | RECIPIENT__ADDRESS__COUNTRY | | ----------- | ----------- | ------- | ----------------- | -------- | --------- | -------------- | -------------------- | --------------- | -------------------------- | ------------------------ | ------------------------- | ----------------------- | --------------------------- | | acct_111111 | cus_1111 | pm_111 | xxx*USER | xxx*USER | 111111 | 11111111 | 2022*06*09T00:00:00Z | JOHN DOE | 25 Avenue | LONDON | LONDON | EXXXXX | GB | | acct_111111 | cus_2222 | pm_222 | yyy*USER | yyy*USER | 111111 | 11111111 | 2022*06*09T00:00:00Z | Stripe McStripe | 26 Street | LONDON | LONDON | EXXXXX | GB | | acct_111111 | cus_3333 | pm_333 | zzz*USER | zzz*USER | 111111 | 11111111 | 2022*06*09T00:00:00Z | Rory C | 27 Way | LONDON | LONDON | EXXXXX | GB | ## AU BECS export fields AU BECS exports include the following fields. | Field | Description | | ---------------- | ---------------------------------------------------------------------- | | `customer_id` | The Stripe unique identifier of the customer (cus_XXXXX format) | | `name` | Name associated with the customer | | `email` | Customer’s email | | `description` | Text attached to the customer object | | `source_id` | Stripe payment method ID associated with the customer’s payment method | | `owner_name` | Customer name associated with the bank account | | `bsb_number` | The 6 digit bank state branch number of the bank account | | `account_number` | Customer’s bank account number | ### Example AU BECS data export | CUSTOMER_ID | NAME | EMAIL | DESCRIPTION | SOURCE_ID | OWNER_NAME | BSB_NUMBER | ACCOUNT_NUMBER | | ----------- | ------------ | ---------------- | ----------- | --------- | ------------ | ---------- | -------------- | | cus_1111 | JOHN DOE | test@example.com | yyy*USER | pm_111 | JOHN DOE | 111111 | 21212121 | | cus_2222 | JANE SMITH | jane@example.com | xxx*USER | pm_222 | JANE SMITH | 222222 | 43434343 | | cus_3333 | ALEX JOHNSON | alex@example.com | zzz*USER | pm_333 | ALEX JOHNSON | 333333 | 65656565 |