Skip to content
PerfrowFormatting tool, not tax advice

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

  1. 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.
  2. Download the blank 1099-NEC template from your IRIS dashboard.
  3. Drop both into Perfrow. It skips the report's title rows and total line, and guesses the column mapping.
  4. Check the mapping, type your business details once, and review the fixes.
  5. Download CSVs of at most 250 records and upload them.

What usually needs fixing in an accounting export

In the exportIn 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 numberText with dashes, leading zeros restored
Address in one cellStreet, city, state and ZIP in separate columns
0.00 in every unused boxEmpty cells
No check box columnsN 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 fixer

Questions

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.

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