cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Intuit
86 helpful votes

Create a 1099 report for vendors and vendor payments

Learn how to run reports that show the vendors you need to send 1099s to and what you paid them.

You can run a couple different reports to help file your 1099s. We’ll show you how to run reports that list:

  • Vendors you set up for 1099s.
  • Payments to those vendors that you need to report to the IRS.
  • Payments you don’t need to report because a financial institution reports them for you.

Here's how to get the report that lists all of your 1099 vendors:

  1. Select Reports.
  2. Search for "Vendor Contact List" and open the report.
  3. Select Customized.
  4. From the Rows/Columns drop-down menu, select Change columns.
  5. Select the Track 1099 checkbox.
  6. Select Run Report.

If you want to sort the report by 1099 vendors:

  1. Select the Sort drop-down menu.
  2. From the Sort by drop-down menu, select Track 1099.
  3. Select anywhere to refresh the report.

To change whether you track a vendor for 1099s, update the vendor on your vendor list.

  1. Select Expenses > Vendors.
  2. Select the vendor.
  3. Select Edit.
  4. Select or remove the Track 1099 payments checkbox.
  5. Select Save.

To help with end-of-year filings, run a report of all the payments you made this year to your 1099 vendors.

  1. From the Expenses menu, select Vendors.
  2. Select Prepare 1099s.
  3. Select Let’s get started or Continue your 1099s.
  4. Follow the steps to prepare 1099s. The report you’re looking for is on “Step 4: Review - Check that the payments add up.”

By default, the list is filtered to show only vendors that meet the $600 threshold.

The All Payments column displays the total of a vendor’s payments for the year. Select the dollar amount in the All Payments column to open the report.

Tip: If a vendor is missing from the list, you can change the filter to find them.

  1. Above the Contractor column, select the Filter icon.
  2. From the Type of contractors drop-down menu, select 1099 contractors below threshold or Contractors not marked for 1099.

Important: Payments you make to vendors using a credit or debit card, or a third-party provider like PayPal, aren't included on a 1099-MISC. These payments are reported by your financial institution and you don’t need to report them.

To prevent duplicate reporting to the IRS, your vendors’ 1099-MISC should only include cash, check, EFT, ACH, and direct deposit payments.

  1. From the Expenses menu, select Vendors.
  2. Select Prepare 1099s.
  3. Select Let’s get started or Continue your 1099s.
  4. Follow the steps to prepare 1099s. The report you’re looking for is on “Step 4: Review - Check that the payments add up.”

By default, the list is filtered to show only vendors that meet the $600 threshold.

The Excluded column displays the total of a vendor’s excluded payments for the year. Select the dollar amount in the Excluded column to open the report.

Tip: If a vendor is missing from the list, you can change the filter to find them.

  1. Above the Contractor column, select the Filter icon.
  2. From the Type of contractors drop-down menu, select 1099 contractors below threshold or Contractors not marked for 1099.

Was this helpful?

You must sign in to vote, reply, or post