The IRIS 1099-S CSV template, column by column

The IRIS Taxpayer Portal lets you upload 1099-S forms (proceeds from real estate sales, usually filed by title and escrow companies) as a CSV file instead of typing them in one by one. Here are all 42 columns of the template in order, and how the amounts in a FIRE (Publication 1220) file map onto them.

Convert a FIRE file to the 1099-S template Free check and preview in your browser. Nothing is uploaded.

Where the template comes from

Sign in to the IRIS Taxpayer Portal, choose to upload a CSV with form data, and download the blank 1099-S template. IRIS checks the header row of your upload against that template, so keep the header exactly as it is: same columns, same order, same wording. The column names below are the ones in the IRS's published formatting guidelines for IRIS CSV files.

Use one file per form type and per payer, and keep each file to 100 forms or fewer.

Publication 1220 amount codes to 1099-S boxes

In a FIRE file, each payee (B) record holds up to 18 payment amounts, numbered 1–9 and A–J. Which box each one belongs to depends on the form, and the codes don't always line up with box numbers.

Pub 1220 amount codeIRIS 1099-S column
2Box 2 - Gross proceeds
5Box 6 - Buyer's part of real estate tax

Formatting that trips people up

All 42 columns, in order

#ColumnFrom a FIRE file
1Form Type
2Tax Year
3Filer Taxpayer ID Type
4Filer Taxpayer ID Number
5Filer Name Type
6Filer Business or Entity Name Line 1
7Filer Business or Entity Name Line 2
8Filer First Name
9Filer Middle Name
10Filer Last Name
11Filer Suffix
12Filer Country
13Filer Address Line 1
14Filer Address Line 2
15Filer City/Town
16Filer State/Province/Territory
17Filer ZIP/Postal Code
18Filer Phone Type
19Filer Phone
20Transferor Taxpayer ID Type
21Transferor Taxpayer ID Number
22Transferor Name Type
23Transferor Business or Entity Name Line 1
24Transferor Business or Entity Name Line 2
25Transferor First Name
26Transferor Middle Name
27Transferor Last Name
28Transferor Suffix
29Transferor Country
30Transferor Address Line 1
31Transferor Address Line 2
32Transferor City/Town
33Transferor State/Province/Territory
34Transferor ZIP/Postal Code
35Office Code
36Form Account Number
37Box 1 - Date of closing
38Box 2 - Gross proceedsAmount code 2
39Box 3 - Address or Legal Description Note: City/Town, State/Territory, and Zip/Postal Code must be entered if address is provided.
40Box 4 - Check here if the transferor received or will receive property or services (other than cash or notes) as part of the consideration
41Box 5 - Check here if the Transferor is a foreign person (nonresident alien, foreign partnership, foreign estate, or foreign trust)
42Box 6 - Buyer's part of real estate taxAmount code 5

Doing it by hand, or not

For a handful of forms, typing them straight into the IRIS portal is quickest. For more, you can fill this template in a spreadsheet using the tables above. If your accounting software only exports a Publication 1220 file, my FIRE to IRIS converter does the mapping, name splitting and file splitting for you, in your browser, so the SSNs in the file are never uploaded.

This page describes file formats, not tax rules. Check what belongs on each form with the IRS instructions or your tax professional.

Convert a FIRE file to the 1099-S template Free check and preview in your browser. 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.