Access Stripe in Excel

Balance History

Returns a list of transactions that have contributed to the Stripe account balance (e.g., charges, transfers, and so forth).

Parameters

  • Transaction Type

Fields

  • NextPageToken
  • Id
  • Amount
  • Currency
  • Available On
  • Created
  • Description
  • Exchange Rate
  • Fee
  • Net
  • Source
  • Status
  • Type

Customers

Returns a list of your customers.

Parameters

  • Filter by email - A filter on the list based on the customer’s email field

Fields

  • NextPageToken
  • Id
  • Email
  • Description
  • Account Balance
  • Created
  • Currency
  • Default Source
  • Delinquent
  • Discount
  • Invoice Prefix
  • Metadata
  • Shipping

Charges

Returns a list of charges you’ve previously created.

Parameters

  • Filter by customer

Fields

  • NextPageToken
  • Id
  • Amount
  • Currency
  • Available On
  • Created
  • Description
  • Exchange Rate
  • Fee
  • Net
  • Source
  • Status
  • Type

Disputes

Returns a list of your disputes.

Fields

  • NextPageToken
  • Id
  • Amount
  • Balance Transaction
  • Charge Id
  • Created
  • Currency
  • Charge is Refundable
  • Evidence Due By
  • Has Evidence
  • Evidence Past Due
  • Evidence Details Submission Count
  • Access Activity Log
  • Billing Address
  • Cancellation Policy
  • Cancellation Policy Disclosure
  • ECancellation Rebuttal
  • Customer Communication
  • Customer Email Address
  • Customer Name
  • Customer Purchase Ip
  • Customer Signature
  • Duplicate Charge Documentation
  • Duplicate Charge Explanation
  • Duplicate Charge Id
  • Product Description
  • Receipt
  • Refund Policy
  • Refund Policy Disclosure
  • Refund Refusal Explanation
  • Service Date
  • Service Documentation
  • Shipping Address
  • EShipping Carrier
  • Shipping Date
  • Shipping Documentation
  • Shipping Tracking Number
  • Uncategorized File
  • Uncategorized Text

Events

List events, going back up to 30 days.

Fields

  • NextPageToken
  • Id
  • Event Type
  • Customer Id
  • Currency
  • Customer
  • Date
  • Description

Payouts

Returns a list of existing payouts sent to third-party bank accounts or that Stripe has sent you.

Fields

  • NextPageToken
  • Id
  • Object
  • Amount
  • Arrival Date
  • Automatic
  • Balance Transaction
  • Created
  • Currency
  • Description
  • Destination
  • Failure Balance Transaction
  • Failure Code
  • Failure Message

Products

Returns a list of your products.

Parameters

  • Only return active products
  • Filter by product type

Fields

  • NextPageToken
  • Id
  • Active
  • Attributes
  • Caption
  • Created
  • Deactivate On
  • Description
  • Name
  • Package Dimensions
  • Shippable
  • Type
  • Updated
  • Url

Refunds

Returns a list of all refunds you’ve previously created.

Fields

  • NextPageToken
  • Id
  • Amount
  • Balance Transaction
  • Charge
  • Created
  • Currency
  • Metadata
  • Reason
  • Receipt Number
  • Status

Customer Bank Accounts

A list of the bank accounts belonging to a Customer.

Parameters

  • Customer Id

Fields

  • NextPageToken
  • Id
  • Holder Name
  • Holder Type
  • Bank Name
  • Country
  • Currency
  • Customer
  • Fingerprint
  • Last4
  • Metadata
  • Routing Number
  • Status

Coupons

Returns a list of your coupons.

Fields

  • NextPageToken
  • Id
  • Amount Off
  • Created
  • Currency
  • Duration
  • Duration In Months
  • Max Redemptions
  • Name
  • Percent Off
  • Redeem By
  • Times Redeemed
  • Valid

Invoices

List all invoices, or list the invoices for a specific customer.

Parameters

  • Customer Id

Fields

  • NextPageToken
  • Id
  • Object
  • Amount Due
  • Amount Paid
  • Amount Remaining
  • Application Fee
  • Attempt Count
  • Attempted
  • Auto Advance
  • Billing
  • Billing Reason
  • Charge
  • Closed
  • Currency
  • Customer
  • Date
  • Description
  • Discount
  • Due Date
  • Ending Balance
  • Forgiven
  • Invoice Url
  • Invoice PDF Url

Invoice Items

Returns a list of your invoice items.

Parameters

  • Filter by customer Id
  • Filter by Invoice Id

Fields

  • NextPageToken
  • Id
  • Amount
  • Currency
  • Customer
  • Date
  • Description
  • Discountable
  • Invoice
  • Metadata
  • Period Start
  • Period End
  • Plan
  • Proration
  • Quantity
  • Subscription
  • Unit Amount

Plans

Returns a list of your plans

Parameters

  • Filter by product - Only products of type 'service' can be used
  • Filter by status

Fields

  • NextPageToken
  • Id
  • Active
  • Aggregate Usage
  • Amount
  • Billing Scheme
  • Created
  • Currency
  • Interval
  • Interval Count
  • Nickname
  • Product
  • Tiers
  • Tiers Mode
  • Transform Usage
  • Trial Period Days
  • Usage Type

Subscriptions

Returns a list of subscriptions

Parameters

  • Filter by customer
  • Filter by plan
  • Filter by status

Fields

  • NextPageToken
  • Id
  • Application Fee Percent
  • Billing
  • Billing Cycle Anchor
  • Cancel At Period End
  • Canceled At
  • Created
  • Current Period End
  • Current Period Start
  • Customer
  • Days Until Due
  • Ended At
  • Quantity
  • Start
  • Status
  • Tax Percent
  • Trial End
  • Trial Start
  • Plan Id
  • Plan Nickname
  • Plan Product

Subscription Items

Returns a list of your subscription items for a given subscription.

Parameters

  • Subscription Id
  • Filter by status

Fields

  • NextPageToken
  • Id
  • Application Fee Percent
  • Created
  • Quantity
  • Plan Id
  • Plan Nickname
  • Plan Product
  • Metadata
  • Subscription

Account Details

Retrieves the details of the account.

Fields

  • Id
  • Business Name
  • Business Url
  • Charges Enabled
  • Country
  • Created
  • Default Currency
  • Details Submitted
  • Display Name
  • Email
  • Debit Negative Balances
  • Decline Charge On AVS Failure
  • Decline Charge On CVC Failure
  • Payout Schedule Delay Days
  • Payout Schedule Interval
  • Payout Statement Descriptor
  • Payouts Enabled
  • Product Description
  • Statement Descriptor
  • Support Email
  • Support Phone
  • Timezone
  • Type
  • Legal Entity Type
  • Legal Entity Business Name
  • Legal Entity Business Tax Id Provided
  • Legal Entity First Name
  • Legal Entity Last Name
  • Legal Entity Address City
  • Legal Entity Address Country
  • Legal Entity Address Line1
  • Legal Entity Address Line2
  • Legal Entity Address Postal Code
  • Legal Entity Address State
  • Legal Entity Personal Address City
  • Legal Entity Personal Address Country
  • Legal Entity Personal Address Line1
  • Legal Entity Personal Address Line2
  • Legal Entity Personal Address Postal Code
  • Legal Entity Personal Address State
  • Legal Entity Personal Id Number Provided
  • Legal Entity Ssn Last 4 Provided
  • Legal Entity Verification Status

Connected Accounts

Returns a list of accounts connected to your platform via Connect. If you’re not a platform, the list is empty.

Fields

  • NextPageToken
  • Id
  • Business Name
  • Business Url
  • Charges Enabled
  • Country
  • Created
  • Default Currency
  • Details Submitted
  • Display Name
  • Email
  • Debit Negative Balances
  • Decline Charge On AVS Failure
  • Decline Charge On CVC Failure
  • Payout Schedule Delay Days
  • Payout Schedule Interval
  • Payout Statement Descriptor
  • Payouts Enabled
  • Product Description
  • Statement Descriptor
  • Support Email
  • Support Phone
  • Timezone
  • Type
  • Legal Entity Type
  • Legal Entity Business Name
  • Legal Entity Business Tax Id Provided
  • Legal Entity First Name
  • Legal Entity Last Name
  • Legal Entity Address City
  • Legal Entity Address Country
  • Legal Entity Address Line1
  • Legal Entity Address Line2
  • Legal Entity Address Postal Code
  • Legal Entity Address State
  • Legal Entity Personal Address City
  • Legal Entity Personal Address Country
  • Legal Entity Personal Address Line1
  • Legal Entity Personal Address Line2
  • Legal Entity Personal Address Postal Code
  • Legal Entity Personal Address State
  • Legal Entity Personal Id Number Provided
  • Legal Entity Ssn Last 4 Provided
  • Legal Entity Verification Status

Application Fees

Returns a list of application fees you’ve previously collected.

Fields

  • NextPageToken
  • Id
  • Account
  • Amount
  • Amount Refunded
  • Application
  • Balance Transaction
  • Charge
  • Created
  • Currency
  • Originating Transaction
  • Refunded

Recipients

Returns a list of your recipients.

Fields

  • NextPageToken
  • Id
  • Active Account
  • Cards
  • Created
  • Default Card
  • Description
  • Email
  • Migrated To
  • Name
  • Type
  • Verified

Transfers

Returns a list of existing transfers sent to connected accounts.

Parameters

  • Filter by account Id

Fields

  • NextPageToken
  • Id
  • Amount
  • Amount Reversed
  • Balance Transaction
  • Created
  • Currency
  • Description
  • Destination
  • Destination Payment
  • Reversed
  • Source Transaction
  • Source Type
  • Transfer Group

Transfer Reversals

List of the reversals belonging to a specific transfer.

Parameters

  • Filter by account Id

Fields

  • NextPageToken
  • Id
  • Amount
  • Balance Transaction
  • Created
  • Currency
  • Transfer

Orders

Returns a list of your orders.

Parameters

  • Filter by customer
  • Filter by status

Fields

  • NextPageToken
  • Id
  • Amount
  • Amount Returned
  • Application
  • Application Fee
  • Charge
  • Created
  • Currency
  • Customer
  • Email
  • Shipping Method
  • City
  • Country
  • Address Line1
  • Address Line2
  • Postal Code
  • State
  • Shipping Carrier
  • Shipping Name
  • Shipping Phone
  • Tracking Number
  • Shipping Methods
  • Status
  • Canceled
  • Fulfiled
  • Paid
  • Returned
  • Updated

Returns

Returns a list of your order returns.

Parameters

  • Filter by order
  • Filter by status

Fields

  • NextPageToken
  • Id
  • Active
  • Attributes
  • Created
  • Currency
  • Image
  • Inventory
  • Package Dimensions
  • Price
  • Product
  • Updated

SKUs

Returns a list of your SKUs.

Parameters

  • Filter by status
  • Filter by availability

Fields

  • NextPageToken
  • Id
  • Active
  • Attributes
  • Created
  • Currency
  • Image
  • Inventory Quantity
  • Inventory Type
  • Inventory Value
  • Package Dimensions
  • Price
  • Product
  • Updated

Access

In order to use Stripe connector, you need an API key. You can find your API keys in your dashboard. Copy and paste the secret key to the settings dialog inside Stripe connector.

Add from Manager

The Stripe Connector is available in the Connectors Manager in the top ribbon:

Select the Finance category and install Stripe:


Contribute

This connector suite is open-sourced on GitHub.


See

Official Documentation

Stripe API reference

Resources


Get help with this function in the community →