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)
    • Will appear on Form 8949 with adjustment code W.
  8. Accrued market discount
    • Will appear on Form 8949 with adjustment code D.
  9. Basis adjustment
    • Will appear on Form 8949 with code B.
  10. Other adjustments
    • Will appear on Form 8949 with code O.
  11. Total adjustments
    • Optional. Not used by app.
  12. Gain (Loss)
    • Optional. Not used by app.
  13. Nominee adjustment
    • Will appear on Form 8949 with code N.
    • Must be a value -- not a formula.
  14. Net Gain (Loss)
    • Optional. Not used by app.
  15. 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 or D checked).
  16. 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 or F checked).
  17. Type of gain is incorrect
    • Enter Yes if the type of gain or loss shown in Box 2 of Form 1099-B is incorrect.
    • Leave empty if this does not apply.
  18. Expired Purchased Option
    • Enter Yes if you purchased an option and let it expire. The word EXPIRED will appear in the proceeds column on Form 8949.
    • Leave empty if this does not apply.
  19. Expired Granted Option
    • Enter Yes if you granted an option which expired. The word EXPIRED will appear in the cost column on Form 8949.
    • Leave empty if this does not apply.
  20. Collectible
    • Enter Yes if the item sold was a "collectible".
    • Leave empty if this does not apply.
  21. Ordinary
    • Enter Yes if the item sold resulted in an "ordinary" gain or loss, as opposed to a capital gain or loss..
    • Leave empty if this does not apply.
  22. Term
    • Enter L to force long-term capital gain treatment.
    • Enter S to force short-term capital gain treatment.
    • Enter 6 to indicate this item should not be reported on Form 8949.
    • Leave empty to allow short or long term to be determined based on date acquired and date sold.
  23. Internal Use
    • Do not make an entry in this column.

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.