Start your taxes FREE with TurboTax Online!

How to Set Up a 1099-MISC & 1099-K Full Form Import

Last Updated:
January 15, 2017

Let's continue where we left off from Importing Your Tax Forms Into Payable. In this part, we’ll go over how to format your CSVs for 1099-MISC and 1099-K form importing. 

Recipient Identification Fields

Payable Worker ID

Every recipient in Payable has an ID that we assign them. It can be found in the user’s profile in the app, through the Team Export, or the API.

  • The ID Payable assigns to the recipient.
  • This reference ID is required if you're updating existing Tax Forms or importing new tax forms for existing recipients.

External Worker ID

Recipients in Payable that you had previously imported through the Team Import sometimes have the ID you provided for them via the External Worker Id field.

  • The unique ID your system uses for this recipient.
  • It’s important to make sure we do not create duplicate recipients in Payable if you have multiple forms or corrections for the same recipient. So please make sure this information matches with all existing data we have for each recipient.

Stripe ID

If you have taken advantage of our Stripe integration, we may have pulled in your Stripe payments and recipients data. If this is the case, you can also reference the recipients through their Stripe Id.

  • The ID for this vendor in Stripe (if applicable).
  • Important to make sure we do not create duplicate recipients in Payable if we have imported recipient information from Stripe. So please make sure this information matches with all existing data we have for each recipient.
  • Accepts either Stripe Account or Stripe Recipient ID’s.
  • Example: ‘acct_17IaDkE3IlTP7AZz’ or ‘rp_17IaghE3IlTP7AZzcZOxb02G’.

Display Name (required)

  • The name of the recipient as you would like it to appear in Payable.
  • Not required if both First and Last name are supplied.
  • Not used as the recipient's Full Tax Name.

First Name

  • First name of the individual or business representative.

Last Name

  • Last name of the individual or business representative.

Business Name

  • Business name if the recipient is a Business.

Email

  • Required to invite your recipients to your company in Payable in order to update and/or confirm tax details and perform e-delivery. 
  • An email address can only be used for one recipient.

Address Line 1

  • Line one of the recipient's legal address for delivering 1099 forms.

Address Line 2

  • Line two of the recipient's legal address for delivering 1099 forms.

City

  • City of the recipient's legal address for delivering 1099 forms.

Region

  • Two character state code that this transaction should be reported to (e.g ‘CA’, ‘WI’, …), or foreign region.
  • ‍Must be a valid abbreviation or full name.

Postal Code

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

Country

  • Must be a valid 2 or 3 character ISO Country Code (e.g ‘US’, ‘CA’, …).
  • Country is required if postal code is present.

Business Type

  • Recipient's tax information declared on their W-9 and registered with the IRS.
  • Must be one of: ‘INDIVIDUAL’, ‘CORPORATION’, ‘LLC_SINGLE’, LLC_C_CORP’, ‘LLC_S_CORP’, ‘LLC_PARTNER’, ‘C_CORP’, ‘S_CORP’, ‘PARTNERSHIP’, ’NON_PROFIT’.

SSN

  • Recipient's tax information declared on their W-9 and registered with the IRS.
  • Recipient’s 9-digit Social Security Number (if Individual).

EIN

  • Recipient's tax information declared on their W-9 and registered with the IRS.
  • Recipient’s 9 digit Employer Identification Number (if Business).

1099 Tax Forms Fields

Because each form requires different information, we’ll go over both the 1099-MISC formatting and the 1099-K’s. Additionally:

  • All values must be in USD
  • You may include $ symbols and commas for thousands separators
  • Examples: 601, $5543.00, $5,324.32

- 1099-MISC Form CSV Format

Here is a sample file of the CSV with all the supported headers: Payable 1099-MISC Form Sample CSV.

The format of the CSV is straightforward. The column headings can appear in any order.

FATCA Filing Requirement

  • Identifies you have a requirement to satisfy any situations covered under Regulations section 1.1471-4

Box Fields

These fields map directly to boxes on the 1099-MISC form. With the exception of Box 17. We ask for the State Abbreviation and your State ID Number separately to ensure proper formatting and filing. All box fields are monetary unless otherwise noted. 

Please see our How To Prepare 1099 Forms guide for more guidance on how to interpret and calculate these values.

  • Box 1 -  Rents
  • Box 2 -  Royalties
  • Box 3 -  Other Income
  • Box 4 -  Federal Income Tax Withheld
  • Box 5 -  Fishing Boat Proceeds
  • Box 6 -  Medical and Health Care Payments
  • Box 7 -  Nonemployee Compensation
  • Box 8 -  Substitute Payments
  • Box 9 -  Payer direct sales >= $5000
    TRUE or FALSE
    Default FALSE
  • Box 10 -  Crop Insurance Proceeds
  • Box 13 -  Excess Golden Parachute Payments
  • Box 14 -   Gross Proceeds Paid to an Attorney
  • Box 15a -  Section 409A Deferrals
  • Box 15b -  Section 409A Income
  • Box 16 (State) -  State Tax Withheld
  • Box 16 (Other State) -  Other State Tax Withheld
  • Box 17 (State) -  State Abbreviation
    Two character state code that this transaction should be reported to (e.g ‘CA’, ‘WI’, …)
  • Box 17 (State ID) -  Payer’s State ID
    ID number assigned to you by the state
  • Box 17 (Other State) -  Other State Abbreviation
    Two character state code that this transaction should be reported to (e.g ‘CA’, ‘WI’, …)
  • Box 17 (Other State ID) -  Payer's Other State ID
    ID number assigned to you by the state
  • Box 18 (State) -  State Income
  • Box 18 (Other State) -  Other State Income

- 1099-K Form CSV Format

Here is a sample file of the CSV with all the supported headers: Payable 1099-K Form Sample CSV.

The format of the CSV is straightforward. The column headings can appear in any order.

Filer Is

  • Indicates if FILER is a PSE or EPF/Other third party
  • Options: ‘PSE’, ‘EPF Other’
  • Learn more about a PSE vs. EPF: 1099-K Basics

Transactions Reported Are

  • Indicates that transactions reported are a part of Payment Card or Third Party Network
  • Options: ‘Payment Card’, ‘Third Party Network’

PSE's Name

  • Name of the Payment Settlement Entity (PSE) if the FILER is not a PSE

PSE's Phone

  • Phone number of the Payment Settlement Entity (PSE) if the FILER is not a PSE

Box Fields

These fields map directly to boxes on the 1099-K form.

Please see our guide for more guidance on how to interpret and calculate these values: How to Prepare the 1099-MISC and 1099-K

  • Box 1a -  Gross Amount of Transactions
  • Box 1b -  Card Not Present Transactions
  • Box 2 -  Merchant Category Code
    Four digit code assigned by Payment Card association, if applicable
  • Box 3 -  Number of Payment Transactions
    The total count of all payment transactions for the Payee in the given tax year
  • Box 4 -  Federal Income Tax Withheld
  • Box 5a -  Jan
  • Box 5b -  Feb
  • Box 5c -  Mar
  • Box 5d -  Apr
  • Box 5e -  May
  • Box 5f -  Jun
  • Box 5g -  Jul
  • Box 5h -  Aug
  • Box 5i -  Sep
  • Box 5j -  Oct
  • Box 5k -  Nov
  • Box 5l -  Dec
  • Box 6 -  State Abbreviation
    Two character state code that this transaction should be reported to (e.g ‘CA’, ‘WI’, …)
  • Box 6 (Other State) -  Other State Abbreviation
    Two character state code that this transaction should be reported to (e.g ‘CA’, ‘WI’, …)
  • Box 7 -  Filer's State ID
    ID number assigned to you by the state
  • Box 7 (Other State) -  Filer's Other State ID
    ID number assigned to you by the state
  • Box 8 -  State Tax Withheld
  • Box 8 (Other State) -  Other State Tax Withheld

What's next? 

See the next part of the process for:

- Importing Your Tax Forms CSV File into Payable

Pay your contractors with Payable!

$0.99 per payment

Learn more