A Service of iTips
Internet Tax Information Processing Services, Inc

Form 1099-B in CSV Format

Many brokers provide a downloadable CSV file with Form 1099-B data.

The problem is that there is no standard for 1099-B CSV formats.

We call on brokers to provide 1099-B data in industry-standard data formats.

Below is a partial list of 1099-B CSV formats is use that we are aware of.

1

  1. Account
  2. Description
  3. Symbol
  4. CUSIP
  5. Date Acquired
  6. Date Sold
  7. Gross Proceeds
  8. Cost or Other Basis
  9. Gain/(Loss)
  10. Wash Sale Loss Disallowed
  11. Federal Income Tax Withheld
  12. Type of Gain(Loss)
  13. Noncovered Securities
  14. Reporting Category
  15. null

2

  1. Account
  2. Description
  3. Symbol
  4. CUSIP
  5. Date Acquired
  6. Date Sold
  7. Gross Proceeds
  8. Cost or Other Basis
  9. Gain/(Loss)
  10. Wash Sale Loss Disallowed
  11. Federal Income Tax Withheld
  12. Type of Gain(Loss)
  13. Noncovered Securities
  14. Reporting Category

3

  1. Disclosure and Header
  2. null
  3. null
  4. null
  5. null
  6. null
  7. null
  8. null
  9. null
  10. null
  11. null
  12. null
  13. null
  14. null
  15. null
  16. null
  17. null
  18. null
  19. null
  20. null
  21. null
  22. null

4

  1. 1099 Summary
  2. Account
  3. Customer Name
  4. SSN/TIN
  5. DUPLICATE
  6. DEMINIMIS
  7. Correction Date
  8. 1099-DIV-1A Total Ordinary Dividends
  9. 1099-DIV-1B Qualified Dividends
  10. 1099-DIV-5 Section 199A Dividends
  11. 1099-DIV-2A Total Capital Gain Distributions
  12. 1099-DIV-2B Unrecap. Sec 1250 Gain
  13. 1099-DIV-2C Section 1202 Gain
  14. 1099-DIV-2D Collectibles (28%) Gain
  15. 1099-DIV-3 Nondividend Distributions
  16. 1099-DIV-4 Federal Income Tax Withheld
  17. 1099-DIV-6 Investment Expenses
  18. 1099-DIV-7 Foreign Tax Paid
  19. 1099-DIV-8 Foreign Country or U.S. Possession
  20. 1099-DIV-9 Cash Liquidation Distributions
  21. 1099-DIV-10 Non-Cash Liquidation Distributions
  22. 1099-DIV-11 Exempt Interest Dividends
  23. 1099-DIV-12 Specified Private Activity Bond Interest Dividends
  24. 1099-DIV-13 State
  25. 1099-DIV-14 State Identification No.
  26. 1099-DIV-15 State Tax Withheld
  27. 1099-INT-1 Interest Income
  28. 1099-INT-2 Early Withdrawal Penalty
  29. 1099-INT-3 Interest on U.S. Savings Bonds and Treas. Obligations
  30. 1099-INT-4 Federal Income Tax Withheld
  31. 1099-INT-5 Investment Expenses
  32. 1099-INT-6 Foreign Tax Paid
  33. 1099-INT-7 Foreign Country or U.S. Possession
  34. 1099-INT-8 Tax-Exempt Interest
  35. 1099-INT-9 Specified Private Activity Bond Interest
  36. 1099-INT-10 Market Discount
  37. 1099-INT-11 Bond Premium
  38. 1099-INT-12 Bond premium on U.S. Treasury Obligations
  39. 1099-INT-13 Bond Premium on Tax-Exempt Bond
  40. 1099-INT-14 Tax-Exempt Bond CUSIP No.
  41. 1099-INT-15 State
  42. 1099-INT-16 State Identification No.
  43. 1099-INT-17 State Tax Withheld
  44. 1099-MISC-2 Royalties
  45. 1099-MISC-3 Other Income
  46. 1099-MISC-4 Federal Income Tax Withheld
  47. 1099-MISC-8 Substitute Payments In Lieu of Dividends and Interest
  48. 1099-MISC-16 State Tax Withheld
  49. 1099-MISC-17 State/Payer's State No.
  50. 1099-MISC-18 State Income
  51. 1099-B-Total Proceeds
  52. 1099-B-Total Cost Basis
  53. 1099-B-Total Market Discount
  54. 1099-B-Total Wash Sales
  55. 1099-B-Realized Gain/Loss
  56. 1099-B-Federal Income Tax Withheld
  57. 1099-OID-Total Original Issue Discount
  58. 1099-OID-Total Original Issue Discount On U.S. Treas. Obligations
  59. 1099-OID-Tax-Exempt OID
  60. 1099-OID Total Original Issue Discount - REMIC

5

  1. 1099 Summary
  2. Account
  3. Customer Name
  4. SSN/TIN
  5. DUPLICATE
  6. DEMINIMIS
  7. Correction Date
  8. 1099-DIV-1A Total Ordinary Dividends
  9. 1099-DIV-1B Qualified Dividends
  10. 1099-DIV-5 Section 199A Dividends
  11. 1099-DIV-2A Total Capital Gain Distributions
  12. 1099-DIV-2B Unrecap. Sec 1250 Gain
  13. 1099-DIV-2C Section 1202 Gain
  14. 1099-DIV-2D Collectibles (28%) Gain
  15. 1099-DIV-3 Nondividend Distributions
  16. 1099-DIV-4 Federal Income Tax Withheld
  17. 1099-DIV-6 Investment Expenses
  18. 1099-DIV-7 Foreign Tax Paid
  19. 1099-DIV-8 Foreign Country or U.S. Possession
  20. 1099-DIV-9 Cash Liquidation Distributions
  21. 1099-DIV-10 Non-Cash Liquidation Distributions
  22. 1099-DIV-11 Exempt Interest Dividends
  23. 1099-DIV-12 Specified Private Activity Bond Interest Dividends
  24. 1099-DIV-13 State
  25. 1099-DIV-14 State Identification No.
  26. 1099-DIV-15 State Tax Withheld
  27. 1099-INT-1 Interest Income
  28. 1099-INT-2 Early Withdrawal Penalty
  29. 1099-INT-3 Interest on U.S. Savings Bonds and Treas. Obligations
  30. 1099-INT-4 Federal Income Tax Withheld
  31. 1099-INT-5 Investment Expenses
  32. 1099-INT-6 Foreign Tax Paid
  33. 1099-INT-7 Foreign Country or U.S. Possession
  34. 1099-INT-8 Tax-Exempt Interest
  35. 1099-INT-9 Specified Private Activity Bond Interest
  36. 1099-INT-10 Market Discount
  37. 1099-INT-11 Bond Premium
  38. 1099-INT-12 Bond premium on U.S. Treasury Obligations
  39. 1099-INT-13 Bond Premium on Tax-Exempt Bond
  40. 1099-INT-14 Tax-Exempt Bond CUSIP No.
  41. 1099-INT-15 State
  42. 1099-INT-16 State Identification No.
  43. 1099-INT-17 State Tax Withheld
  44. 1099-MISC-2 Royalties
  45. 1099-MISC-3 Other Income
  46. 1099-MISC-4 Federal Income Tax Withheld
  47. 1099-MISC-8 Substitute Payments In Lieu of Dividends and Interest
  48. 1099-MISC-15 State Tax Withheld
  49. 1099-MISC-16 State/Payer's State No.
  50. 1099-MISC-17 State Income
  51. 1099-B-Total Proceeds
  52. 1099-B-Total Cost Basis
  53. 1099-B-Total Market Discount
  54. 1099-B-Total Wash Sales
  55. 1099-B-Realized Gain/Loss
  56. 1099-B-Federal Income Tax Withheld
  57. 1099-OID-Total Original Issue Discount
  58. 1099-OID-Total Original Issue Discount On U.S. Treas. Obligations
  59. 1099-OID-Tax-Exempt OID
  60. 1099-OID Total Original Issue Discount - REMIC

6

  1. TAX YEAR
  2. FILE_CLOSING_DATE
  3. CLOSE_DATE
  4. OPENING_TRANSACTION
  5. OPEN_DATE
  6. UNDERLYING_SYMBOL
  7. SECURITY_DESCRIPTION
  8. QUANTITY
  9. PROCEEDS
  10. COST
  11. CODE
  12. GAIN_LOSS_ADJ
  13. TERM
  14. 8949_BOX
  15. GAIN_LOSS
  16. CLOSING_TRANSACTION

7

  1. Account Summary
  2. null
  3. null
  4. null
  5. null
  6. null
  7. null
  8. null
  9. null
  10. null
  11. null

8

  1. Account Summary
  2. null
  3. null
  4. null
  5. null
  6. null
  7. null
  8. null
  9. null
  10. null
  11. null
  12. null
  13. null

9

  1. Account Summary
  2. null
  3. null
  4. null
  5. null
  6. null
  7. null
  8. null
  9. null
  10. null
  11. null
  12. null

10

  1. Quantity
  2. Security
  3. Date acquired
  4. Date sold
  5. Sales price
  6. Cost
  7. Wash sale loss disallowed
  8. Accrued market discount
  9. Basis adjustment
  10. QOF deferral adjustment
  11. Other adjustment
  12. Total adjustments
  13. Gain (Loss)
  14. Nominee adjustment
  15. Net Gain (Loss)
  16. Basis reported to IRS
  17. Reported on 1099-B
  18. Type of gain is incorrect
  19. Expired Purchased Option
  20. Expired Granted Option
  21. Collectible
  22. Ordinary
  23. Term
  24. Internal Use

11

  1. 1099-B
  2. ACCOUNT NUMBER
  3. TAX YEAR
  4. DATE ACQUIRED
  5. SALE DATE
  6. DESCRIPTION
  7. SHARES
  8. COST BASIS
  9. SALES PRICE
  10. TERM
  11. ORDINARY
  12. FED TAX WITHHELD
  13. WASH AMT DISALLOWED
  14. ACCRDMKTDISCOUNT
  15. FORM8949CODE
  16. GROSSPROCEEDSINDICATOR
  17. LOSSNOTALLOWED
  18. NON COVERED
  19. BASIS NOT SHOWN
  20. FORM 1099 NOT REC
  21. COLLECTIBLE
  22. QOF
  23. PROFIT
  24. UNRELPROFITPREV
  25. UNRELPROFIT
  26. AGGPROFIT
  27. STATECODE
  28. FATCA
  29. STATEIDNUM
  30. STATETAXWHELD
  31. PAYER FED ID
  32. PAYER NAME1
  33. PAYER NAME2
  34. PAYER ADDR1
  35. PAYER ADDR2
  36. PAYER ADDR3
  37. PAYER CITY
  38. PAYER STATE
  39. PAYER ZIP
  40. PAYER PHONE

12

  1. 1099-INT
  2. ACCOUNT NUMBER
  3. TAX YEAR
  4. PAYER RTN
  5. INT INCOME
  6. EARLY WD PENALTY
  7. INT USBONDS
  8. FED TAX WH
  9. INV EXPENSE
  10. FOR TAX PD
  11. FORCNT
  12. TAX EXPMT INT
  13. SPECIFIED PAB INT
  14. MARKETDISCOUNT
  15. BONDPREMIUM
  16. BONDPREMUSOBLIGATIONS
  17. TEBONDPREMIUM
  18. FATCA
  19. STATECODE
  20. STATEIDNUM
  21. STATETAXWHELD
  22. PAYER FED ID
  23. PAYER NAME1
  24. PAYER NAME2
  25. PAYER ADDR1
  26. PAYER ADDR2
  27. PAYER ADDR3
  28. PAYER CITY
  29. PAYER STATE
  30. PAYER ZIP
  31. PAYER PHONE

13

  1. 1099-DIV
  2. ACCOUNT NUMBER
  3. TAX YEAR
  4. ORDINARY DIV
  5. QUALIFIED DIV
  6. TOTAL CAP GAIN
  7. UNRECSEC1250
  8. SEC1202
  9. P28 GAIN
  10. SEC897DIV
  11. SEC897GAIN
  12. NONTAXDIST
  13. FEDTAXWH
  14. SEC199A
  15. INVESTEXP
  16. FORTAXPD
  17. FORCNT
  18. CASHLIQ
  19. NONCASHLIQ
  20. EXEMPTINTDIV
  21. SPECIFIEDPABINTDIV
  22. FATCA
  23. STATECODE
  24. STATEIDNUM
  25. STATETAXWHELD
  26. PAYER FED ID
  27. PAYER NAME1
  28. PAYER NAME2
  29. PAYER ADDR1
  30. PAYER ADDR2
  31. PAYER ADDR3
  32. PAYER CITY
  33. PAYER STATE
  34. PAYER ZIP
  35. PAYER PHONE

14

  1. Timestamp (UTC)
  2. Transaction Description
  3. Currency
  4. Amount
  5. To Currency
  6. To Amount
  7. Native Currency
  8. Native Amount
  9. Native Amount (in USD)
  10. Transaction Kind

15

  1. Type
  2. Buy
  3. Cur.
  4. Sell
  5. Cur.
  6. Fee
  7. Cur.
  8. Exchange
  9. Group
  10. Comment
  11. Date

16

  1. Symbol
  2. Security
  3. Quantity of Shares
  4. Share Price
  5. Total Purchase Price
  6. Date Bought
  7. Account Number
  8. Status
  9. Date Sold
  10. Value per Share Sold
  11. Total Proceeds
  12. Reportable Gain/Loss
  13. Disallowed Wash Sale
  14. Covered
  15. Original Cost
  16. Original Acquisition Date

17

  1. Description
  2. Quantity
  3. Date Acquired
  4. Cost/Share $
  5. Total Cost $
  6. Date Sold
  7. Sales Proceed
  8. Proceeds $
  9. Gain $
  10. Deferred Loss $

18

  1. Date
  2. Received Quantity
  3. Received Currency
  4. Sent Quantity
  5. Sent Currency
  6. Fee Amount
  7. Fee Currency

19

  1. Transactions
  2. Quantity
  3. Description of Property
  4. Cusip
  5. Date of Acquisition
  6. Date of Sale or Exchange
  7. Sales Price (see Schedule D instructions)
  8. Cost Basis
  9. Accrued Market Discount
  10. Wash Sale Loss Disallowed
  11. Gain or (Loss)
  12. Transaction Description
  13. YTD Amortization/Accretion
  14. LTD Amortization/Accretion
  15. Proceeds from Collectibles

20

  1. Symbol
  2. Description
  3. Open Date
  4. Close Date
  5. Proceeds
  6. Cost Basis
  7. Codes
  8. Amount of Adjustment
  9. Gain or Loss

21

  1. Close Date
  2. Rec type
  3. Open Date
  4. Security
  5. Shares Sold
  6. Proceeds
  7. Cost
  8. Code
  9. Gain/Loss Adjustment
  10. ST/LT
  11. Box
  12. Gain/Loss