Braintree logo

Sync Braintree data to Sourcetable

Braintree

Braintree facilitates payments among all types of business sizes so they can accept, process and split payments, and grow their revenue. It offers a simple way to enable buying from almost anywhere from the comfort of your mobile app. The platform can be used to calculate important KPIs such as your monthly recurring revenue or ARPU (average revenue per user).

Sync Braintree data to Sourcetable


Braintree logo
Sourcetable logo

Find out how to make the most of your Braintree data with Sourcetable

Sourcetable Benefits

Query financial data quickly & easily

Braintree offers a robust set of building blocks to form a payments infrastructure for your business, and help to identify new opportunities for business. Syncing payments data from Braintree to Sourcetable allows users to combine it with inputs from other platforms and databases, create auto-updating models, and analyze financial key metrics for their businesses at a glance.

Accessibility

Syncing Braintree data to Sourcetable allows users to compare financial metrics with other KPIs quickly and easily, without having to learn SQL or other database languages. This means your key data can be made available to all members of your team.

Auto-update your data

Sourcetable brings together key data from Braintree and other platforms quickly and intuitively, allowing users to automate processes and free up time to focus on other important aspects of their business.

Two circular arrows representing how your data refreshes when any of the sources changes

Find out how to get the most from Braintree with Sourcetable

A Magic Wand

Smart Templates

Use out-of-the-box, tried and tested templates in order to merge databases and enable data collaboration across your entire organisation

A Magic Wand

Quick Analysis

Analyse your Braintree financial data instantly in cross-channel reports

A Magic Wand

Ease Of use

Query all your Braintree data in one easy-to-use spreadsheet, to find the business insights behind the numbers and grow your business.

Who uses Braintree data in Sourcetable

💸 CFOs & Accountants

📈 Marketing and Advertising professionals

👷🏿 Sales and Sales Ops folk

🚀 Founders

🏢 Ecommerce businesses

Here's a sample of the Braintree data that will be available
in your Sourcetable spreadsheets:

Show all (27)

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

Link icon

APPLE_PAY_CARD

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

Link icon

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

Link icon

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

Link icon

CUSTOMER_ADDRESS

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

Link icon

DISPUTE

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

Link icon

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

Link icon

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

Link icon

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

Link icon

PAYPAL_DETAILS

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

Link icon

PAYPAL_HERE_DETAILS

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

Link icon

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

Link icon

REGISTERED_CUSTOMER

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

Link icon

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

Link icon

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

Link icon

SUBSCRIPTION_ADD_ON

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

Link icon

SUBSCRIPTION_DISCOUNT

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

Link icon

SUBSCRIPTION_STATUS_HISTORY

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

Link icon

TRANSACTION

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

Link icon

TRANSACTION_ADD_ON

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

Link icon

TRANSACTION_DISCOUNT

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

Link icon

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

Link icon

TRANSACTION_STATUS_HISTORY

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

Link icon

UNREGISTERED_CUSTOMER

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

Link icon

US_BANK_ACCOUNT_DETAILS

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

Link icon

VENMO_DETAILS

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

Link icon

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

Link icon

Sample companies

Online businesses integrating Braintree with Sourcetable can quickly access all relevant data on income, expenses, statements, estimates, churn and inventory.

  • Small to Medium sized businesses

    (eCommerce)
  • Retail offline stores

  • B2B Platforms

  • Software as a Service

    (SaaS) companies
  • B2C Marketplaces

What makes Sourcetable special?

A Magic Wand

Interconnectivity

Connect, sync and query your Braintree payments data with data from 30+ other sources, without SQL.

A Magic Wand

Collaboration

Sourcetable can automatically create and back up sales receipts and alert you about new transactions using Braintree data.

A Magic Wand

Automation

Create intuitive workflow templates based on data from Braintree and other platforms, and share among team members quickly and easily to enhance data collaboration

Frequently Asked Questions

How do I sync my Braintree data to Sourcetable?
Sourcetable is currently in Closed Beta. Sign up to the Beta here to tell us a little about yourself and request information on how to sync your Braintree data.
What common integrations do Sourcetable users combine with Braintree?
Sourcetable spreadsheets are designed to be intuitive and user-friendly, so anyone can view key data from Braintree - and other payments platforms such as Stripe - at a glance without SQL.
Which payments platform works best with Sourcetable – Stripe or Braintree?
Sourcetable enables users to combine data from both platforms, enabling businesses to better understand the relationships among available data, and gain new insights for making better decisions or identifying new opportunities.




Connect your Braintree Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.