QuickBooks 1099 export to IRIS CSV
QuickBooks will give you an Excel report of your 1099 vendors. It will not give you the IRIS template layout. This closes the gap.
What the QuickBooks Community says (we have not tested the menus ourselves):
- 3 February 2026, moderator reply: go to Reports, Standard reports, find the 1099 Transaction Detail Report, export it to Excel or CSV, then check the formatting against IRIS requirements.
- In a thread started 27 October 2023, a community reply: "it isn't possible to directly transfer 1099 CSV files into the template for uploading to the IRS portal, IRIS."
From the export to the upload
- Export a report that has one row per vendor with name, tax ID, address and the 1099-NEC total. If your report lists single transactions, total them per vendor first: each row in the IRIS file becomes one form.
- Download the blank 1099-NEC template from your IRIS dashboard.
- Drop both into Perfrow. It skips the report's title rows and total line, and guesses the column mapping.
- Check the mapping, type your business details once, and review the fixes.
- Download CSVs of at most 250 records and upload them.
What usually needs fixing in an accounting export
| In the export | In the IRIS file |
|---|---|
| One Vendor column: "O'Brien, Patrick J." | First, middle and last name in three columns, no apostrophe or period |
| Tax ID stored as a number | Text with dashes, leading zeros restored |
| Address in one cell | Street, city, state and ZIP in separate columns |
| 0.00 in every unused box | Empty cells |
| No check box columns | N in 2nd TIN Notice and Box 2 |
The same steps work for a Sage, Xero or Wave export, or a hand-kept spreadsheet: the tool only needs a header row and one row per recipient.
QuickBooks is a trademark of Intuit Inc. Perfrow is not affiliated with or endorsed by Intuit.
Fix the whole file at once
Drop in your blank IRIS template and your spreadsheet. Perfrow cleans every row, tells you which ones need you, and writes CSVs of at most 250 records. It runs in your browser, so names and TINs stay on your computer.
Open the 1099-NEC CSV fixerQuestions
- Can QuickBooks export a file in the IRIS CSV format?
- Not directly, according to QuickBooks Community replies from 2023 and 2026. You export a 1099 report to Excel or CSV and reformat it to the IRIS template.
- QuickBooks Community thread, 3 February 2026: How do I file 1099s myself via IRS
- QuickBooks Community thread, 27 October 2023: efile 1099
- IRS Publication 5717 (Rev. 9-2026), IRIS Taxpayer Portal User Guide, processing year 2027
- IRS 1099-NEC Template Formatting Guidelines, tax year 2025 (inside the guidelines ZIP the IRS lists as updated 01/14/2026)
Other answers: All 54 columns · Required fields · Character limits · State codes · 250-record limit · Why files get rejected · Scientific notation · ZIP code format · Date format · Line breaks · Extra spaces · Periods and # · $0.00 cells · Y/N check boxes · Tax year · Error types · Headers do not match · TIN format · Key dates