Batch Fill 1099-S Forms from Excel

Proceeds from Real Estate Transactions

Power PDF Filler lets closing attorneys, title companies, and settlement agents batch fill IRS 1099-S forms for all real estate transactions directly from Excel. Set up your closing data (transferor name, SSN/EIN, property address, gross proceeds), map columns to 1099-S fields once, and generate all forms in seconds.

What is IRS Form 1099-S?

IRS Form 1099-S (Proceeds from Real Estate Transactions) is used to report the sale or exchange of real property. The person responsible for closing the transaction — typically the closing attorney, title company, or settlement agent — must file a 1099-S for each transferor (seller) and report the gross proceeds from the sale. The IRS uses this information to verify that sellers report capital gains on their tax returns.

The official fillable PDF is available from irs.gov.

Who needs to batch fill 1099-S forms?

Closing attorneys — Filing 1099-S forms for every real estate closing they handle throughout the year. High-volume practices may close hundreds of transactions annually.
Title companies — Processing 1099-S forms for all property transfers they facilitate, often tracking closings in spreadsheets exported from their title production software.
Settlement agents — Filing 1099-S as the person responsible for closing when no attorney or title company is involved.
Real estate investment firms — Reporting proceeds from multiple property dispositions in a single tax year.

How to batch fill 1099-S forms from Excel

Select your PDF form. Open Power PDF Filler from the Excel ribbon and select the official 1099-S fillable PDF (download it from irs.gov if you don't have it). The add-in detects all fillable fields — filer information, transferor details, property address, closing date, and gross proceeds.
Select & map your Excel data. Each row represents one closing transaction. Columns include transferor name, SSN or EIN, address, property address, closing date, gross proceeds, and buyer's part of real estate tax. Save the mapping as a reusable template.
Click "Ready, Go." Power PDF Filler generates one filled 1099-S per row. Download individually or as a ZIP file.

What Excel columns do you need?

Excel Column	1099-S Field	Example
transferor_name	Transferor's name	Robert and Lisa Johnson
transferor_tin	Transferor's TIN (SSN/EIN)	123-45-6789
transferor_address	Transferor's address	321 Elm St, Austin, TX 78701
closing_date	Date of closing	06/15/2025
gross_proceeds	Gross proceeds	425000
property_address	Address or description of property	100 Lakewood Dr, Austin, TX 78704
buyer_re_tax	Buyer's part of real estate tax	2400

Common mistakes to avoid

Joint transferors. When a property is sold by married couples or multiple owners, each transferor may need a separate 1099-S. Check IRS instructions for when joint filing is appropriate vs. separate forms.
Gross proceeds vs. net proceeds. Report gross proceeds (the full sale price), not net proceeds after closing costs. This is one of the most common 1099-S errors.
TIN formatting. Use XXX-XX-XXXX for SSNs or XX-XXXXXXX for EINs. Format the column as text in Excel to prevent leading zeros from being dropped.

Filing other tax forms too?

See our guides for batch filling W-2, 1099, and other tax forms from Excel →

1099-S — Frequently Asked Questions

Can I batch fill 1099-S forms from Excel? ▼

Yes. Set up your transaction data in Excel with one row per real estate closing — transferor name, SSN/EIN, property address, closing date, and gross proceeds. Map columns to 1099-S fields and fill all forms in one click.

Who is required to file Form 1099-S? ▼

The person responsible for closing a real estate transaction must file 1099-S. This is typically the closing attorney, title company, or settlement agent. The form reports gross proceeds from the sale or exchange of real property.

What Excel columns do I need for 1099-S forms? ▼

You need transferor name, SSN or EIN, address, closing date, gross proceeds, property address, and a checkbox for whether the transferor received or will receive property or services as part of the consideration.

When is the deadline for filing 1099-S? ▼

Form 1099-S must be filed with the IRS by February 28 (paper) or March 31 (electronic) of the year following the closing. Copies must be furnished to the transferor by January 31.

Can I fill 1099-S forms for multiple closings at once? ▼

Yes. Each row in your Excel spreadsheet represents one closing transaction. Select all rows and Power PDF Filler generates one filled 1099-S per row. There is no limit on batch size.

Ready to stop filling PDFs manually?

Start your free trial — no credit card required.

Try Free on Microsoft Excel