FreshBooks 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 FreshBooks 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 FreshBooks

In FreshBooks, the Expense Report grouped by vendor gives what you paid each contractor. Export it to CSV, then add a tax ID and address column from each contractor's W-9. Menu and report names change between versions, so yours may differ a little.

Only payments for services count toward Box 1; leave out reimbursed expenses and card payments.

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.