Start your taxes FREE with TurboTax Online!

Custom Tax Data Imports For Stripe Marketplaces

Last Updated:
December 28, 2016

By connecting to your Stripe account, Payable will import all relevant details needed to generate a 1099 directly from your Stripe data.

For transfers using the Marketplace Recipients API, we will calculate the gross payment amount as the full amount of the transfer. For Stripe Connect transfers with an originating customer Charge, we will use the full Charge amount (including any platform fees you’ve taken) as the gross.

From there, we’ll attribute the totals to the appropriate form (1099-K or 1099-MISC) and income box that you specify in your company’s Tax Settings. In the event that the gross amounts pulled from Stripe don’t represent the earnings to be reported on the 1099, you can make adjustments/override each transaction using the Stripe Transfer ID. More details on the fields available and an example CSV to make these changes are below:

Stripe Adjustment Import

This import keys off of the required Stripe Transfer ID (e.g. ‘tr_17I9Ir2DsmEdflgJkXdxecAz’), and all other fields are optional.

Click to download an example CSV

Fields

stripe_transfer_id (required)

  • The string id of the transfer you’d like to override default values for
  • Example: ‘tr_17I9Ir2DsmEdflgJkXdxecAz’

gross_amount_cents

  • Integer number of cents representing total taxable income
  • example: $601.00 => 60100

net_amount_cents

  • Integer number of cents paid to the vendor
  • Not used for tax forms but helpful for audit purposes if available
  • Example: $601.00 => 60100

state

  • Two character state code that this transaction should be reported to
  • (e.g ‘CA’, ‘WI’, …)

form_type

  • Options: [‘1099-K’, ‘1099-MISC’, ‘NONE’]

gross_pay_box

  • Only relevant to 1099-MISC.
  • Specifies which box this income should be reported in.
  • Options: [ 'box_1', 'box_2', 'box_3', 'box_5', 'box_6', 'box_7', 'box_8', 'box_10', 'box_13', 'box_14', 'box_15a', 'box_15b']

card_not_present

  • Only relevant to 1099-K
  • ‘TRUE’ or ‘FALSE’ to indicate if the payer’s card was present at the time of the charge

Augmenting Stripe Data

Use this type of import for reporting any payment transactions that were not processed through Stripe.

Important: You will be responsible for paying for the e-filing fees for any vendors that have payments outside of Stripe.

Vendor Import

This import is for specifying any vendors that have not been added to Stripe.

Click to download an example CSV file

Fields

vendor_id (required)

  • The id in YOUR system for this vendor. This id will be used as a reference for importing transactions

display_name (required)

  • Display Name is not needed if both First and Last name are supplied

first_name

  • First name of the individual or business representative

last_name

  • Last name of the individual or business representative

stripe_id

  • The id for this vendor in Stripe (if they have a record)
  • Important to make sure two vendor records aren’t created in Payable
  • Accepts either Account or Recipient id’s
  • Example: ‘acct_17IaDkE3IlTP7AZz’ or ‘rp_17IaghE3IlTP7AZzcZOxb02G’

email

  • Required to invite your vendors to Payable in order to confirm tax details and perform e-delivery. Can be updated later in product.

phone

  • Handles any valid E.164 phone numbers including punctuation: ‘()-.’
  • Assumes +1 country code

address_line1

  • Legal address for delivering 1099 forms

address_line2

  • Legal address for delivering 1099 forms

city

  • Legal address for delivering 1099 forms

state

  • Two character state code that this transaction should be reported to
  • (e.g ‘CA’, ‘WI’, …)

zip

  • 5 or 9 digit US zip code, or foreign postal code

country

  • Two digit country code
  • (e.g ‘US’, ‘CA’, …)

business_type

  • Options: ‘INDIVIDUAL’, ‘CORPORATION’, ‘LLC_SINGLE’, LLC_C_CORP’, ‘LLC_S_CORP’, ‘LLC_PARTNER’, ‘C_CORP’, ‘S_CORP’, ‘PARTNERSHIP’, ’NON_PROFIT’

tin_type

  • Required if specifying TIN
  • Options: ‘SSN, ‘EIN’

tin

  • 9 digit US Tax Identification number
  • Requires tin_type to be set

Transaction Import

Use this type of import for specifying any payment transactions that were not processed through Stripe.

Click to download an example CSV file

Fields

vendor_id (required)

  • The id in YOUR system for this vendor. This needs to match a vendor_id you have already supplied in a Vendor Import (see above)

transaction_id (required)

  • The id in YOUR system for this transaction. This will be used for audit purposes and to de-duplicate any future updates to this transaction

paid_at (required)

  • ISO 8601 formatted date and time
  • ex: 2015-12-10T16:00:30-08:00

gross_amount_cents (required)

  • Integer number of cents representing total taxable income
  • $601.00 => 60100

net_amount_cents

  • Integer number of cents paid to the vendor
  • Not used for tax forms but helpful for audit purposes if available
  • $601.00 => 60100

state

  • Two character state code that this transaction should be reported to
  • (e.g ‘CA’, ‘WI’, …)

form_type

  • Options: [‘1099-K’, ‘1099-MISC’, ‘NONE’]

gross_pay_box

  • Only relevant to 1099-MISC.
  • Specifies which box this income should be reported in.
  • Options: [ 'box_1', 'box_2', 'box_3', 'box_5', 'box_6', 'box_7', 'box_8', 'box_10', 'box_13', 'box_14', 'box_15a', 'box_15b']

card_not_present

  • Only relevant to 1099-K
  • ‘TRUE’ or ‘FALSE’ to indicate if the payer’s card was present at the time of the charge

Pay your contractors with Payable!

$0.99 per payment

Learn more