Stripe an internet business software platform that helps you accept payments from anyone, anywhere, and build your business. A Stripe/Grow integration lets you view your Stripe data in real time, allowing you to stay up-to-date on your business.
Connecting to Stripe
Before you get started you will need your Stripe Secret Key.
- In Grow, click on the Data tab at the top left of the global navigation. You will be brought to your Data Connections.
- Click on the Connect button and search for Stripe.
- Click on the Stripe logo.
- This will pop up a modal asking for the Stripe Secret Key.
- To find your Secret Key, log in to your Stripe account. If you do not see a menu on the left side of the page, click the drop-down arrow next to your account name. From that menu, click the heading API.
- On this page, you will see four different API keys. The one that you will copy into Grow is the Live Secret Key.
- If you do not see your API Keys, you do not have the admin permissions in Stripe. You will need to speak to the administrator for your Stripe account to access the keys.
- Copy your Live Secret Key into Grow and press Connect.
Data Warehousing
We recommend you use the tables available on the Grow Data warehouse to configure Stripe. For more information about warehousing your data, visit the Data Warehouse Help Article.
Warehousing Your Data
Starting with the Connections Overview page, navigate to your Stripe connection. Click on it to open the Connection Details page.
Select the Manage Connection button within the Connection Details section to open the warehouse table selection flow.
Select the data you want stored in the Data Warehouse and click the Sync & Store button at the bottom of the Manage Connection page.
This begins the initial population of your warehouse with the tables you defined. Populating your data warehouse for the first time may take a while, even up to several hours.
You may continue working within the app while your data is In Queue or Processing.
If your data source is not already connected, refer to the Connecting to a Data Source for more details.
Tables
The list of tables available depend on your unique Stripe project. You can expect to see one table per dataset associated with the project ID in your connection.
Suggested Tables
Balance
- Balance (Formatted)
Balance History
- Balance History (Formatted)
- Balance History Fee Details
Charges
- Charges (Formatted)
- Charge Refunds
Coupons
- Coupons (Formatted)
Customers
- Customers (Formatted)
- Customer Sources
- Customer Tax ID
Disputes
- Disputes (Formatted)
- Dispute Balance Transactions
Invoices
- Invoices (Formatted)
- Invoice Default Tax Rates
- Invoice Line Items
- Invoice Total Discount Amounts
- Invoice Total Tax Amounts
Orders
- Orders (Formatted)
- Order Items
- Order Shipping Methods
Plans
- Plans (Formatted)
Products
- Products (Formatted)
Refunds
- Refunds (Formatted)
Skus
- Skus (Formatted)
Subscriptions
- Subscriptions (Formatted)
- Subscription Default Tax Rates
- Subscription Items
Other Tables
Order Returns
- Order Returns (Formatted)
- Order Return Items
Payments
- Payments (Formatted)
- Payment - Refunds
Subscription Schedules
- Subscription Schedule (Formatted)
- Subscription Schedule - Phases
Transfers
- Transfers (Formatted)
- Transfer Reversals
Endpoints
Below is a list of the available reports from Stripe, along with a short description of each.
- Balance: Available Balance, Currency, Pending Amount, Available Amount
- Balance History: Available Amount, Pending Amount, Fees, Number of Transfers, Previous Amounts, Currency
- Charges: Amount Charged, Amount Refunded, Card Type, Country, Transaction Status, Date, Currency, Fees
- Coupons: Coupon Amount, Currency, Coupon Duration
- Customers: Number of Customers, Customer Account Balance, Customer Email, Subscriptions
- Disputes: Dispute Amounts, Currency, Reason, Status
- Invoices: Amount Due, Application Fee, Currency, Date, Subtotal, Tax, Total
- Orders: Amount, Amount Returned, Application, Charge, Date, Currency, Customer, Email, Items, Objects, Returns, Shipping Address, Delivery Estimate
- Order Returns: Amount for items returned, Created, Currency, Items returned, Order returned from, ID of refund issued for return
- Plans: Amount, Date, Currency, Interval, Name, Trial Period
- Products: Active, Attributes, Captions, Created, Name, Shippable, URL
- Refunds: Amount, Date, Currency, Reason, Status
- SKUs: Created, Currency, Inventory, Price, Product, Active
- Subscriptions: Number of Subscriptions, Number of Cancellations, Date, Created Date, Canceled Date, Customer, Discount, Amount, Currency, Interval, Status, Tax, Percent, Trial End, Trial Start
- Transfers: Amount, Balance Transaction, Bank Account, Country, Currency, Date, Status, Type, Transaction Fees
FAQs + Tips and Tricks
Currencies
Stripe will always provide the amount in the smallest common currency unit (i.e. for USD or EUR, 100 cents instead of $1.00). However, for zero-decimal currencies (i.e. JPY, Japanese Yen), the smallest currency is the regular denomination (1 for 1 Yen).
When you pull Stripe data into Grow, it remains consistent with the setup of Stripe and returns the smallest unit of currency. If you have a decimal currency, your data will pull in in cents (or pence, or whatever similar unit exists in your currency). This means that in order to show the values in larger units, you will need to divide your data by 100.
Is Revenue Cash Based or Accrual Based?
There are no accounting settings in Stripe, so the software itself doesn't determine which accounting system you use. Grow will pull in exactly what is in your Stripe account. You can set your Stripe reports to monthly in your Stripe settings, but this doesn't impact the data Grow pulls in.
Cancelled Subscriptions
If you want to calculate churn and LTV from Stripe in Grow, you will need to have access to cancelled subscriptions. To access the cancelled subscriptions, Stripe requires users to use the API Version 2016-07-06 or later.
You can double check your version at https://dashboard.stripe.com/account/apikeys. Go ahead and log in with your Stripe account. Once you have logged in, you should be on a page where you can see your API Keys and version.
If you have a version before 2016-07-06, you can click the Upgrade available button, which will help you upgrade to a version you need. You should then be able to access your cancelled subscriptions.