Braintree

Braintree facilitates payments among all types of business sizes where they can accept, process and split payments, and grow their revenue

Sync Sourcetable data to Sourcetable

Build reports once. Connect to Braintree and start modeling from live data.

Popular Use Cases

Braintree connector Sourcetable connector
Create a daily report of Braintree transactions
Braintree + Sourcetable
Braintree connector Sourcetable connector
Create dashboards using Braintree data
Braintree + Sourcetable
Braintree connector Xero connector
Compare Braintree transactions against Xero invoices
Braintree + Xero
Braintree connector Quickbooks Online connector
Compare Braintree transactions against Quickbooks Online sales receipts
Braintree + Quickbooks Online
Braintree connector Mailchimp connector
Create a marketing funnel using Braintree transactions and Mailchimp Subscriber data
Braintree + Mailchimp
Here's a sample of the Braintree data that will be available in your Sourcetable spreadsheets:
ANDROID_PAY_DETAILS

Contains transaction information, card type, expiration month, year, last4, google transaction id, source card last4, source card type, description, token and virtual card4 and virtual card type

APPLE_PAY_CARD

Contains transaction information, card type, expiration month, year, last4, source description, token

CREDIT_CARD

Contains credit card information like card type, expiration date, month, and year, image url, last4, prepaid, payroll, debit, token, product id ad unique identification number

CREDIT_CARD_VERIFICATION

Contains credit card unique number identifier, merchant account, amount, avs error respinse code, avs postal code response, currency iso code, cvv response code, gateway rejection reason, network response code and text, processor response code, text and type

CUSTOMER_ADDRESS

Contains customer address information like company, name, postal code, region, county name

DISPUTE

Contains tranasaction id, amount, kind, reason, received date, reply by date, status date, won date

LOCAL_PAYMENT_DETAILS

Contains transaction id, capture id, custom field, debug id, description, funding source, payment id, refund from transaction fee amount and currency iso code, and transaction fee amount and currency iso code

MASTERPASS_CARD_DETAILS

Contains transaction id, bin, card type, card holder name, last4, expiration month and year, image url, healthcare, payroll, prepaid, token, country of issuance

MERCHANT_ACCOUNT

Contains currency iso code, date of birthm email, first name, funding details account number last4, funding details descriptor, destination, email, mobile phone and routing number

PAYPAL_DETAILS

Contains transaction id, authorization id, capture id, custom field. payee information, refund id, token and transaction fee amount and currency iso code

PAYPAL_HERE_DETAILS

Contains transaction id, authorization id, capture id, payment id and type, refund id, and transaction fee amount and currency iso code

PLAN

Contains plan information like billing day of month, billing frequency, currency iso code, description, name, price, trial duration and unit, and number of billing cycles

REGISTERED_CUSTOMER

Contains company, email, first name, last name, phone, website and timestamps of created at and updated at

SAMSUG_PAY_CARD_DETAILS

Contains transaction, bin, card holder name, card type, last4, payroll, prepaid, product id, token, expiration details, debit, durbin regulated, commercial and country of issuance

SUBSCRIPTION

Contains merchant account, plan, balance, billing day of month, billing period end date and start date, current billing cycle, failure count, first billing date, number of billing cycles, payment method token, price, status and trial duration and unit

SUBSCRIPTION_ADD_ON

Contains subscription, plan, amount, current billing cycle, description, kind, name, never expires, quantity and number of billing cycles

SUBSCRIPTION_DISCOUNT

Contains subscription, plan, amount, current billing cycle, description, kind, name, never expires, quantity and number of billing cycles

SUBSCRIPTION_STATUS_HISTORY

Contains subscription, balance, price,source, status, timestamp and user

TRANSACTION

Contains registerd customer, merchant account, plan, subscription, amount, authorization expires at and transaction id, payment information, tax information, shipping information and address information

TRANSACTION_ADD_ON

Contains transaction id, plan id, amount, current billing cycle, description, kind, name, never expires, quantity

TRANSACTION_DISCOUNT

Contains transaction, plan, amount, current billing cycle, description, kind, name, never expires, quantity

TRANSACTION_LINE_ITEM

Contains transaction, commodity code, description, discount amount, kind, name, product code, quantity, tax amount, total amount, unit amount, url, unit tax amount

TRANSACTION_STATUS_HISTORY

Contains transaction, amount, source, status, timestamp and user

UNREGISTERED_CUSTOMER

Contains transaction, company, email, first name, last name, phone, website and timestamps of created at and updated at

US_BANK_ACCOUNT_DETAILS

Contains transaction, account holder name, account type, ach mandate, bank name, image url, last4, routing number and token

VENMO_DETAILS

Contains transaction id, image url, source description, token, username, venmo user id

VISA_CHECKOUT_DETAILS

Contains transaction id, bin, card type, card holder name, last4, expiration month and year, image url, healthcare, payroll, prepaid, token, country of issuance