Excel Spreadsheet

Requirements for Your Excel Spreadsheet
of Realized Gains and Losses

Create your spreadsheet of realized gain and loss information as follows:

COLUMN HEADINGS AND DATA

The first row of the spreadsheet should contain column headings. Our program keys off the text in the headings. The columns do not have to be in the order shown here.

The supported headings are listed here. They are not case sensitive.

  1. Quantity
    • Enter the number of shares sold. Use of this column is optional. You may include the quantity in next column, if you wish.
  2. Security (Alternate: Description)
    • Security description. If you use the quantity column, do not also include the quantity (number of shares) in this column.
  3. Date Acquired (Alternate: Open Date)
    • You may enter "Various" where applicable. "VariousL" will print "Various" but get long-term treatment.
    • Note: Make sure Excel cells containing dates are in "Date" format, not "General" format.
    • For a short sale, enter the date you acquired the property delivered to the broker or lender to close the short sale.
  4. Date Sold (Alternate: Close Date)
    • Note: Make sure Excel cells containing dates are in "Date" format, not "General" format.
    • For a short sale, enter the date you delivered the property to the broker or lender to close the short sale.
  5. Sales Price (Alternates: Sales, Gross Proceeds)
  6. Cost (Alternate: Basis)
  7. Wash Sale Loss Disallowed (Alternate: Wash Sale Adjustment)
  8. Basis reported to IRS
    • Enter No if broker indicates cost or other basis amount was not reported to IRS. Yes is assumed if left blank. Transactions so noted are reported on a separate copy of Form 8949 (with box B checked).
  9. Reported on 1099-B
    • Enter No if sale was not reported on a Form 1099-B. Yes is assumed if left blank. Transactions so noted are reported on a separate copy of Form 8949 (with box C checked).

TEMPLATE

Download Spreadsheet Template

XLS VERSUS XLSX

You may save your spreadsheet in either the older XLS (Excel 97 - 2004) format or the newer XLSX format.