Daily Settlement Detail Report
Last updated: Aug 15th, 7:19am
Important: Bill Pay is a limited release product, available only to merchants in the US who have completed an approval process.
Daily settlement detail report
This daily report contains details of all the transactions, disputes, and returns for all your billers that were included in the settlement for the date.
View a detailed, annotated sample of a Daily Settlement Detail Report.
Data availability
The data for each day is generally available by 7:30 AM ET on the next processing day.
Report format
Report named "\<PartnerName > _ Daily _ Settlement _ Report.csv" is delivered as a CSV file.
Report frequency
This is a daily report based on the calendar day.
Supported payment methods
Credit and Debit Cards, NFC Wallets, US Bank Accounts, Venmo, PayPal.
Data dictionary
The following table provides descriptions of all the columns in the report.
Field# | Field Name | Description | Sample Data | Data Type | Max Field Length | Nullable? | Possible Values |
1 | Merchant Account ID | The token for the merchant account that was used to process the transaction. Within your Braintree gateway, you can have multiple merchant accounts to process transactions for different businesses or currencies. | MerchantABC | character varying(256) | 256 | No | Braintree assigned value created at time of onboarding. |
2 | Profile ID | The merchant Id in Venmo. | 2831851426875050000 | character varying(256) | 256 | Yes | Braintree assigned value created at time of onboarding. |
3 | Transaction ID | Braintree’s unique identifier for the transaction – can be used to search for transactions in the Braintree Control Panel. Note - This is the "legacyId" returned in GraphQL response. | fbad0mty | character varying(8) | 256 | No | Braintree generated alphanumeric string. |
4 | Transaction Type | "sale" - Settled sale transaction. applies to all payment instrument types | sale | character varying(256) | 256 | No | "sale" |
5 | Created Datetime | The date and time the transaction was created | 06/21/2020 21:45:00 EDT | timestamp | 29 | No | The timestamp of the creation date for the transaction. For chargebacks and returns, this will be the date the chargeback or return was received in MM/DD/YYYY format and without a timestamp. |
6 | Presentment Currency | The 3-letter ISO code that identifies the currency the customer was charged in | USD | character varying(256) | 256 | No | The ISO code for the currency presented to the customer for the transaction. Full list of supported currencies can be found here. |
7 | Settlement Amount | The amount (in your settlement currency) deposited into your account | 243.24 | BigDecimal | 19 | No | |
8 | Order ID | 10000002 | character varying(256) | 256 | Yes | Merchant generated string passed Via the API at time of transaction creation | |
9 | Descriptor Name | The descriptor value passed on transaction in "descriptorName" parameter (populated for credit card, Apple Pay, Google Pay, Samsung Pay, and PayPal). If no value is passed in the transaction sale call, this field will be blank. | company*product12345 | character varying(256) | 256 | Yes | Merchant generated string passed via the API at time of transaction creation. More details can be found here: https://articles.braintreepayments.com/wells-ic/transactions/descriptors |
10 | Payment Instrument Type | The method of payment used to process the transaction | Credit Card | character varying(256) | 256 | No | "credit_card" |
11 | Card Brand | Brand of the card that was used for the transaction | Visa | character varying(256) | 256 | Yes | "Visa" |
12 | Customer ID | Unique identifier for the customer authorizing the transaction | 10000001 | character varying(256) | 256 | Yes | Can either be a Braintree generated ID, or an ID generate by the merchant at time of customer record creation. |
13 | Authorization Code | 6-digit code confirming that a credit card purchase has been approved | 8KZX08 | character varying(256) | 256 | Yes | Value generated by the card issuing bank at time of transaction creation |
14 | Settlement Currency | The 3-letter ISO code that identifies the currency the transaction was deposited to your account in | USD | character varying(256) | 256 | No | The ISO code of the settlement currency. The full list of currencies supported by Braintree can be found here. |
15 | ACH Return Code | The NACHA return code applied to the ACH reject, unauth, etc. See link on wiki (also need link on wiki). | R01 | character varying(256) | 256 | Yes | R01 |
16 | Dispute ID | The ID of the dispute in the PayPal system | kdf9d220dk2as | character varying(256) | 256 | Yes | PayPal generated ID |
Specification notes
Values will not be double quoted.
Use the Column Headers in the first row of the CSV for parsing, as the order of the columns is not fixed.