QuickBooks Desktop to IRIS 1099-NEC CSV

The IRS's IRIS Taxpayer Portal takes 1099-NECs as a CSV in its own template. Here's how to get your contractor list out of QuickBooks Desktop and turn it into that file in a few minutes.

Open the spreadsheet to IRIS converter Free for up to 5 forms. Nothing is uploaded.

1. Get a contractor spreadsheet out of QuickBooks Desktop

In QuickBooks Desktop, the 1099 Summary report (Reports, Vendors & Payables) gives each contractor's total, and the Vendor Contact List gives addresses and tax IDs once you customize its columns. Export both to Excel and combine them into one sheet, one row per contractor. Menu and report names change between versions, so yours may differ a little.

If your QuickBooks Desktop or a 1099 add-on writes a Publication 1220 (FIRE) file, use the FIRE to IRIS converter on that file instead.

2. Convert it

Open the spreadsheet to IRIS 1099-NEC converter, fill in your own business details as the payer, and drop the CSV. It matches your columns, splits names into first and last, works out SSN or EIN, turns state names into codes and puts back the ZIP zeros Excel drops. It lists anything to check, like missing tax IDs or amounts under the filing threshold, and gives you the IRIS CSV, split into files of up to 100 forms.

It runs in your browser, so your contractors' tax IDs never leave your computer. Up to 5 forms are free; more is $49 for the filing season.

3. Upload it to IRIS

More on the change: FIRE is closing and filing moves to IRIS.

Open the spreadsheet to IRIS converter Free for up to 5 forms. Nothing is uploaded.

Microsoft Publisher, Word and PowerPoint are trademarks of Microsoft; PageMaker and InDesign of Adobe; Canva and Affinity of Canva. I'm not affiliated with any of them.