How Do I Run a 1099 Report in Quickbooks?

1099 report in quickbooks

Home » Accounting and Tax Solutions » How Do I Run a 1099 Report in Quickbooks?

Share

January is here already (!) and it’s time once again to prepare Form 1099-MISC’s before the January 31, 2019 deadline.   Using QB’s desktop here is the answer to the important question, “how do I run a 1099 report in Quickbooks?”

How to find and produce 1099 reports in Quickbooks

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

  1. From the left menu, select Reports.
  2. Search for “Vendor Contact List” and open the report.
  3. Select Customize.
  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 and then Vendors.
  2. Select the vendor.
  3. Select Edit.
  4. Select or remove the Track 1099 payments checkbox.
  5. Select Save.

tax reform updates

To create a report of payments to vendors that need to go on Form 1099-MISC

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.

To run a report of payments excluded from a vendor’s 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.

As always, if you have questions or run into problems with creating the 1099-MISC forms, give your accounting specialist a call at PayTech to make sure you meet the deadline this month.


Share

Ready for Award-Winning HR,
Payroll, and Accounting
Solutions with PayTech?

Paytech-2D-Assets

Latest Tips from Our Blog

2020 Guide to Arizona Sick Time Laws and Existing PTO Plans

Share

ShareThe passing of Prop 206 in Arizona created new payroll changes to businesses everywhere, including Arizona paid sick time laws. After Arizona Proposition 206 was…


Share
Read More...

5 Diversity and Inclusion Activities in the Workplace You Have to Try

Share

ShareDiversity and inclusion are absolute necessities in today’s business market. Having people of all orientation, creed, and background as representatives is going to bring you…


Share
Read More...

5 Important HSA Employer Contribution Rules Every Business Owner Should Know

Share

ShareWith the rising cost of healthcare, the health savings account (HSA) option is growing in popularity among employers and employees alike. HSA’s are typically paired…


Share
Read More...