Stripe

Stripe is an online payment processing platform which business can use to accept payments, send payouts, and manage their businesses online.

Sync Stripe data to Sourcetable

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

Popular Use Cases

Stripe connector Sourcetable connector
Analyze Stripe payments history without SQL
Stripe + Sourcetable
Stripe connector Sourcetable connector
Build MRR and ARR reports using Stripe data
Stripe + Sourcetable
Stripe connector Sourcetable connector
Understand churn of paying users using Stripe data
Stripe + Sourcetable
Stripe connector Segment connector
Build lead to paying customer funnels by combining Stripe and Segment data
Stripe + Segment
Mailchimp connector Stripe connector
Segment Mailchimp newsletters by paying customers
Mailchimp + Stripe
Here's a sample of the Stripe data that will be available in your Sourcetable spreadsheets:
ACCOUNT

Account object contains stripe account information like email address, company, country, type of account etc

APPLICATION_FEE

Transaction fee which is collected in addition to charge applicable on a user

APPLICATION_FEE_REFUND

In case you need to refund the application fees collected but not yet refunded you can use the application refund object

ATTRIBUTE

An attribute object contains the SKU (Stock keeping Units) id, name and value properties

AU_BECS_DEBIT

A hash value denoting bank account details in case the payment method used is au_becs

AUTHORIZATION

Authorization object is created in case an issued card is used to make a purchase, authorizations should be approved if we want the purchase to complete successfully

BALANCE_TRANSACTION

The transactions which comes into or goes out of your stripe account

BANK_ACCOUNT

The bank account object contains the bank details like the account holder name, bank name, country, currency, status, type of account etc

CARD

The debit card or credit card object containing the expiration year and month

CARDHOLDER

The issuing authority of a card that may be an individual or a business

CHARGE

In order to charge or deduct amount from a credit or debit card a charge object is created

COUPON

Coupons are a way to give discount to your customers, they can be in the form of amount or a percentage

CREDIT_NOTE

If we need to adjust the invoice amount once the invoice has been finalized we can use the credit note

CREDIT_NOTE_LINE_ITEM

The line item or the description mentioned in the credit note

CUSTOMER

Customer is the user from which the payment is deducted, if we need to track multiple charges that are linked to a same customer or perform recurring charges we can make use of customer object

CUSTOMER _DISCOUNT

The discount which the customer will get once the coupon is applied, it contains information about discount expiry and its details

CUSTOMER_BALANCE_TRANSACTION

The balance value which a customer currently has and that will be applied to the upcoming invoice once it gets finalized

DISPUTE

The dispute occurs if the customer is not satisfied with the charge being applied by the application and there is some discrepancy in the charge applied with his card issuer

DISPUTE_BALANCE_TRANSACTION

no information available

EARLY_FRAUD_WARNING

Early fraud warning indicates that a card issuer has informed the stripe that the charge can be fradulent

FEE

Fees contain the balance transaction, account id, currency etc to tell that flow of funds

FILE

File that is hosted at Stripe's server. This file can be created by the integration party using the Create File request or it may be created by Stripe

FILE_LINKS

If we need to share the contents of a file with non stripe users we can use file links

FPX

A hash value which contains the details about the FPX Payment method

IDEAL

A hash value which contains the details about the ideal Payment method

INVOICE

Amount statement owed by a customer which generally generates from the periodic subscriptions

INVOICE _DISCOUNT

A discount applicable on the invoice

INVOICE _LINE_ITEM

A line item or the description of an item present in the invoice

INVOICE_ITEM

Invoice item contains the description, price, quantity, type, discount information

INVOICE_ITEM

Invoice item contains the description, price, quantity, type, discount information

ISSUING_CARD

It may be a physical or virtual cards that can be issued to a customer

ISSUING_DISPUTE

A dispute can be issued by a card holder if he belives there is an issue with a transaction such as he does not recognise or considers it as a Fraudulant

ORDER

A customer can purchase a product via placing an order

ORDER_ITEM

Order item represents the product he is purchasing

ORDER_RETURN

Order can be returned by the customer if he is not willing to purchase it or finds any issue with the order

ORDER_RETURN_ITEM

Order return item object contains the product information which is to be returned

PAYMENT_INTENT

Process of collecting the payment against an invoice from the customer is payment intent

PAYMENT_METHOD

Mode of customer payment or the instructions of payment defines the payment method

PAYMENT_METHOD_CARD

If the customer wishes to pay the payment via card that payment_method_card object is created which contains the details of card and the payment

PAYOUT

In order to receive the funds from stripe or to process a payout to bank account or debit card of a connected stripe account a payout object is created

PERSON

A person may be a user using the Stripe having the basic details like name, gender, email, place etc

PHASE

A phase represents the position or step of a schedule

PHASE_PLAN

A phase plan contains the subscription schedule and start and end dates of a schedule

PLAN

Purchases of products can be managed by plans as they define the price and currency details for recurring purchases of products

PRODUCT

A product is a service or an item that company provides to it's customers

REFUND

Refund object helps to rollback a charge that has been created but not yet refunded

REVIEW

Reviews are useful for fraud detection but they require human help

SEPA_DEBIT

A hash value which contains details about SEPA debit bank account

SETUP_INTENT

If we need to setup customer's payment credentials for future refrence we can use setup intent object

SHIPPING_METHOD

A list of methods that can be chosen for shipping of an order

SKU

SKU means Stock keeping Units that takes into account various attributes, currency and price

SOURCE

If we want to use various payment methods we can use a source object

SUBSCRIPTION

If we want to charge a customer on a recurring basis we can use subscription

SUBSCRIPTION _DISCOUNT

Discount applicable on a subscription is known as subscription discount

SUBSCRIPTION_ITEM

If we want to use complex billing relationships by creating subscriptions with more than one plan we can make use of subscription item.

SUBSCRIPTION_SCHEDULE

subscription schedule manages the lifecycle of subscriptions thereby taking into account any predefined changes.

TAX_RATE

The rate of tax applicable on invoice item

TAX_RATE_INVOICE_ITEM_MAPPING

Contains mapping of invoice item and tax rate

TAX_RATE_SUBSCRIPTION_MAPPING

Contains mapping of subscription and tax rate

TIER

Contains the plan id, amounts section for flat and unit amounts

TOPUP

For recharging the stripe account we can use the topup object

TRANSACTION

Whenever funds enter or leaves an account by using a card such as a refund or purchase it is represented by a transaction object

TRANSFER

If we migrate our funds between Stripe accounts as a part of connect we can make use of transfer object

TRANSFER_REVERSAL

By using Stripe connect platforms we can reverse the transfers either partially or completely and it is represented by transfer reversal object

USAGE_RECORD

In case of metered billing of subscription prices, usage records can help to report customer usage