Network Sponsor Reporting
Stripe Reports
All reports are provided as CSV files over SFTP. The available reports are:
- Daily Settlement Report: a same-day summary report of transaction volume
- Clearing Transaction Detail Report: a daily transaction-level report of cleared transactions
- Dispute Event Report: a daily transaction-level report of events related to disputes
- Transaction Summary Report: a periodic per-merchant summary of processed volume
- Merchant Report: a list of events related to merchant metadata
Filenames are customizable.
CSV
CSV files are as described in RFC 4180:
- Fields are optionally delimited by
"
quotes.- When they are,
""
inside is used to represent a single quote and fields can contain commas - In the example below, the first value is
"quoted, field"
- When they are,
- Dates will always be in
YYYY-MM-DD
format and in UTC time. - Headers will always be present
- Blank fields will either be an empty delimited field (
""
) or just nothing between commas. Both theexample_header
anda_date_field
values in the second row of the below sample are empty.
Sample
example_header,a_date_field,an_amount,a_currency """quoted, field""",2016-06-03,12345,usd "",,12345,jpy
Amounts
Amounts are always:
- provided as an integer
- accompanied by a three-letter currency code
- in the smallest unit for the currency (cents, pence, centavos, etc)
For example 12345,usd
is USD $123.45 and 12345,jpy
is JPY ¥12345
Backwards-Compatibility
In the same vein as our API Backwards-Compatibility Guidelines, we consider the following changes to be backwards compatible:
- Adding new rightmost columns to the CSV reports
- Adding new values to
type
fields
Daily Settlement Report
Each line of this report is a summary of transactions for one reconciliation window for Visa and Mastercard.
Fields
brand
: eithervisa
ormastercard
network_numeric
: for Visa, the BIN; for Mastercard, the ICA.settlement_service
: an identifier for the settlement service used for the transactions- For Visa, see the full list of possible values below
- For Mastercard, the identifier from the Settlement Manual is used
reconciliation_date
: the processing date inYYYY-MM-DD
format.reconciliation_cycle
: which cycle is summarizedtype
: which transactions are included in the aggregation. Valid values are:first_presentment
first_chargeback
second_presentment
second_chargeback
(includes prearbitration withdrawals for Visa)interchange
(interchange reimbursement fees)scheme_fee
miscellaneous
amount
: the amount as an integer number of minor units, possibly with a leading-
to denote a negative amount. Amounts in this report are relative to Stripe, so a positive amount means money flowing to Stripe.currency
: the three-letter currency code
Sample
brand,network_numeric,settlement_service,reconciliation_date,reconciliation_cycle,type,amount,currency mastercard,010100,US00000001,2017-03-24,1,first_presentment,3800,usd mastercard,010100,US00000001,2017-03-24,1,interchange,-21,usd mastercard,010100,US00000001,2017-03-24,2,scheme_fee,-1000,usd visa,444000,international,2017-03-24,1,first_presentment,247400,usd visa,444000,international,2017-03-24,1,interchange,-784,usd
Clearing Transaction Detail Report
This report contains records for cleared charges and refunds. It has a number of limitations:
- Some of the listed transactions may later fail in clearing. This means that this report cannot be reconciled against other reports counting successfully settled transactions.
- The clearing date in this report reflects the date the clearing attempt was created internally within Stripe, and may not be the same as the date the transaction is eventually processed.
- The amount is in the presentment currency of the transaction, so cannot be used to reconcile to cash.
Fields
date
: the date this transaction was submitted for clearingbrand
: eithervisa
ormastercard
merchant
: the unique identifier assigned by Stripecard_number
: the first six and last four digits of the card number, separated with an asterisk*
acquirer_reference_number
: the acquirer reference number sent with clearingtype
: the type of transaction. One of:charge
refund
amount
: the transaction amountcurrency
: the three-letter transaction currency coderaw__visa_moto
: the raw Visa MOTO/ECI value. Only populated for Visa transactionsraw__mastercard_sli
: the raw Mastercard Security Level Indicator value. Only populated for Mastercard transactions
Sample
date,brand,merchant,card_number,acquirer_reference_number,type,amount,currency,raw__visa_moto,raw__mastercard_sli 2017-03-22,visa,400009*1234,ZX2DSEDKGX7WDYZMWFAQEPG,74242429888000000000011,charge,1800,usd,07, 2017-03-23,visa,456721*0017,ZX2DSEDKGX7WDYZMWFAQEPG,74242429888000000000029,charge,1000,usd,01, 2017-03-24,mastercard,510789*2010,ZX2DSEDKGX7WDYZMWFAQEPG,85242429888000000000055,refund,523,gbp,,210, 2017-03-24,visa,400009*1234,XZPWCHXWVG9ZRK6JFPFSZC4,74242429888000000000034,charge,6400,eur,05,
Dispute Events Report
This report contains records of events related to transaction Disputes.
Fields
date
: the date of the incoming recordbrand
: eithervisa
ormastercard
merchant
: the unique identifier assigned by Stripecard_number
: the first six and last four digits of the card number, separated with an asterisk*
acquirer_reference_number
: the acquirer reference number sent with clearingtype
: the type of event. One of:retrieval
first_chargeback
first_chargeback_reversal
representment
representment_reversal
second_chargeback
second_chargeback_reversal
prearbitration
amount
: the chargeback amountcurrency
: the three-letter currency codereason_code
: the raw Visa or Mastercard reason code
Sample
date,brand,merchant,card_number,acquirer_reference_number,type,amount,currency,reason_code 2017-03-24,visa,400009*1234,ZX2DSEDKGX7WDYZMWFAQEPG,74242429888000000000011,first_chargeback,1800,usd,78 2017-03-24,mastercard,510789*2010,ZX2DSEDKGX7WDYZMWFAQEPG,85242429888000000000055,second_chargeback,900,gbp,3001
Transaction Summary Report
This report breaks down transactions by merchant for a given period of time. It is available on a daily, weekly, or monthly basis. Rows are aggregated by:
- Merchant
- Transaction Type
- Presentment Currency
Chargebacks and refunds are counted in the time period that they themselves occur, not the one in which the original transaction did.
Fields
merchant
: the unique identifier assigned by Striperange_start
: the first date included in this aggregation, inYYYY-MM-DD
formatrange_end
: the last date included in this aggregation, inYYYY-MM-DD
formatbrand
: eithervisa
ormastercard
type
: what type of transaction is being aggregatedcharge
full_refund
partial_refund
chargeback
count
: the number of transactionsamount
: the sum of the transaction amountscurrency
: the three-letter currency code of the transaction
Sample
merchant,range_start,range_end,brand,type,count,amount,currency ZX2DSEDKGX7WDYZMWFAQEPG,2017-03-01,2017-03-31,visa,charge,3,1500,usd ZX2DSEDKGX7WDYZMWFAQEPG,2017-03-01,2017-03-31,mastercard,charge,2,1000,usd ZX2DSEDKGX7WDYZMWFAQEPG,2017-03-01,2017-03-31,visa,charge,1,600,gbp ZX2DSEDKGX7WDYZMWFAQEPG,2017-03-01,2017-03-31,mastercard,full_refund,1,500,usd ZX2DSEDKGX7WDYZMWFAQEPG,2017-03-01,2017-03-31,visa,partial_refund,1,200,gbp ZX2DSEDKGX7WDYZMWFAQEPG,2017-03-01,2017-03-31,visa,chargeback,1,500,usd XZPWCHXWVG9ZRK6JFPFSZC4,2017-03-01,2017-03-31,mastercard,charge,2,66998,usd XZPWCHXWVG9ZRK6JFPFSZC4,2017-03-01,2017-03-31,visa,charge,1,333333,jpy
Merchant Report
This report provides information about the merchants transacting on Stripe.
It can be provided daily, weekly, monthly, or quarterly. Monthly or quarterly reports will be a full copy of the portfolio each time, whereas weekly or daily ones will be just changes.
The exact selection and ordering of fields in this report can be configured depending on the details of the Network Sponsor’s requirements and the country of operation.
Merchants are included in this report when they have settled three live transactions.
Available Fields
report_date
: the date of the report and event, inYYYY-MM-DD
formatevent
: what happened to this merchant?onboarded
: this is a new merchantupdated
: the merchant has updated information. When a merchant is updated, the row for them in this report will still include all of their information.offboarded
: the merchant is no longer processing with Stripe
merchant
: the unique identifier assigned by Stripebusiness_dba
: the merchant’s business namebusiness_type
: the merchant’s business typetax_id
: a tax identification number for this merchant. It will be blank if it does not applyaddress_line1
: merchant’s address line 1address_line2
: merchant’s address line 2city
: merchant cityregion
: merchant region, meaning depends on countrypostal_code
: merchant postal code, meaning depends on country, might be blankcountry
: merchant countryrepresentative_first_name
: the first name of the merchant’s legal representativerepresentative_last_name
: the first name of the merchant’s legal representativerepresentative_dob
: the Date of Birth for a representative, inYYYY-MM-DD
format.merchant_url
: the merchant’s websitemcc
: the MCC the merchant will be usingemail
: the MCC the merchant will be usingbank_account_last4
: the last four digits of the merchant’s attached bank account. Will be blank if the merchant hasn’t yet attached a bank account.
Sample
report_date,merchant,event,tax_id,business_dba 2017-03-31,ZX2DSEDKGX7WDYZMWFAQEPG,updated,123-45-6789,"Computers, and More" 2017-03-31,XZPWCHXWVG9ZRK6JFPFSZC4,onboarded,987-65-4321,"Delivery Cupcakes" 2017-03-31,8MPJSJC3OVHR0VCM4Z0OJOV,offboarded,111-111-1111,"Prohibited Business Llc."