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
- Account
- Description
- Symbol
- CUSIP
- Date Acquired
- Date Sold
- Gross Proceeds
- Cost or Other Basis
- Gain/(Loss)
- Wash Sale Loss Disallowed
- Federal Income Tax Withheld
- Type of Gain(Loss)
- Noncovered Securities
- Reporting Category
- null
2
- Account
- Description
- Symbol
- CUSIP
- Date Acquired
- Date Sold
- Gross Proceeds
- Cost or Other Basis
- Gain/(Loss)
- Wash Sale Loss Disallowed
- Federal Income Tax Withheld
- Type of Gain(Loss)
- Noncovered Securities
- Reporting Category
3
- Disclosure and Header
- null
- null
- null
- null
- null
- null
- null
- null
- null
- null
- null
- null
- null
- null
- null
- null
- null
- null
- null
- null
- null
4
- 1099 Summary
- Account
- Customer Name
- SSN/TIN
- DUPLICATE
- DEMINIMIS
- Correction Date
- 1099-DIV-1A Total Ordinary Dividends
- 1099-DIV-1B Qualified Dividends
- 1099-DIV-5 Section 199A Dividends
- 1099-DIV-2A Total Capital Gain Distributions
- 1099-DIV-2B Unrecap. Sec 1250 Gain
- 1099-DIV-2C Section 1202 Gain
- 1099-DIV-2D Collectibles (28%) Gain
- 1099-DIV-3 Nondividend Distributions
- 1099-DIV-4 Federal Income Tax Withheld
- 1099-DIV-6 Investment Expenses
- 1099-DIV-7 Foreign Tax Paid
- 1099-DIV-8 Foreign Country or U.S. Possession
- 1099-DIV-9 Cash Liquidation Distributions
- 1099-DIV-10 Non-Cash Liquidation Distributions
- 1099-DIV-11 Exempt Interest Dividends
- 1099-DIV-12 Specified Private Activity Bond Interest Dividends
- 1099-DIV-13 State
- 1099-DIV-14 State Identification No.
- 1099-DIV-15 State Tax Withheld
- 1099-INT-1 Interest Income
- 1099-INT-2 Early Withdrawal Penalty
- 1099-INT-3 Interest on U.S. Savings Bonds and Treas. Obligations
- 1099-INT-4 Federal Income Tax Withheld
- 1099-INT-5 Investment Expenses
- 1099-INT-6 Foreign Tax Paid
- 1099-INT-7 Foreign Country or U.S. Possession
- 1099-INT-8 Tax-Exempt Interest
- 1099-INT-9 Specified Private Activity Bond Interest
- 1099-INT-10 Market Discount
- 1099-INT-11 Bond Premium
- 1099-INT-12 Bond premium on U.S. Treasury Obligations
- 1099-INT-13 Bond Premium on Tax-Exempt Bond
- 1099-INT-14 Tax-Exempt Bond CUSIP No.
- 1099-INT-15 State
- 1099-INT-16 State Identification No.
- 1099-INT-17 State Tax Withheld
- 1099-MISC-2 Royalties
- 1099-MISC-3 Other Income
- 1099-MISC-4 Federal Income Tax Withheld
- 1099-MISC-8 Substitute Payments In Lieu of Dividends and Interest
- 1099-MISC-16 State Tax Withheld
- 1099-MISC-17 State/Payer's State No.
- 1099-MISC-18 State Income
- 1099-B-Total Proceeds
- 1099-B-Total Cost Basis
- 1099-B-Total Market Discount
- 1099-B-Total Wash Sales
- 1099-B-Realized Gain/Loss
- 1099-B-Federal Income Tax Withheld
- 1099-OID-Total Original Issue Discount
- 1099-OID-Total Original Issue Discount On U.S. Treas. Obligations
- 1099-OID-Tax-Exempt OID
- 1099-OID Total Original Issue Discount - REMIC
5
- 1099 Summary
- Account
- Customer Name
- SSN/TIN
- DUPLICATE
- DEMINIMIS
- Correction Date
- 1099-DIV-1A Total Ordinary Dividends
- 1099-DIV-1B Qualified Dividends
- 1099-DIV-5 Section 199A Dividends
- 1099-DIV-2A Total Capital Gain Distributions
- 1099-DIV-2B Unrecap. Sec 1250 Gain
- 1099-DIV-2C Section 1202 Gain
- 1099-DIV-2D Collectibles (28%) Gain
- 1099-DIV-3 Nondividend Distributions
- 1099-DIV-4 Federal Income Tax Withheld
- 1099-DIV-6 Investment Expenses
- 1099-DIV-7 Foreign Tax Paid
- 1099-DIV-8 Foreign Country or U.S. Possession
- 1099-DIV-9 Cash Liquidation Distributions
- 1099-DIV-10 Non-Cash Liquidation Distributions
- 1099-DIV-11 Exempt Interest Dividends
- 1099-DIV-12 Specified Private Activity Bond Interest Dividends
- 1099-DIV-13 State
- 1099-DIV-14 State Identification No.
- 1099-DIV-15 State Tax Withheld
- 1099-INT-1 Interest Income
- 1099-INT-2 Early Withdrawal Penalty
- 1099-INT-3 Interest on U.S. Savings Bonds and Treas. Obligations
- 1099-INT-4 Federal Income Tax Withheld
- 1099-INT-5 Investment Expenses
- 1099-INT-6 Foreign Tax Paid
- 1099-INT-7 Foreign Country or U.S. Possession
- 1099-INT-8 Tax-Exempt Interest
- 1099-INT-9 Specified Private Activity Bond Interest
- 1099-INT-10 Market Discount
- 1099-INT-11 Bond Premium
- 1099-INT-12 Bond premium on U.S. Treasury Obligations
- 1099-INT-13 Bond Premium on Tax-Exempt Bond
- 1099-INT-14 Tax-Exempt Bond CUSIP No.
- 1099-INT-15 State
- 1099-INT-16 State Identification No.
- 1099-INT-17 State Tax Withheld
- 1099-MISC-2 Royalties
- 1099-MISC-3 Other Income
- 1099-MISC-4 Federal Income Tax Withheld
- 1099-MISC-8 Substitute Payments In Lieu of Dividends and Interest
- 1099-MISC-15 State Tax Withheld
- 1099-MISC-16 State/Payer's State No.
- 1099-MISC-17 State Income
- 1099-B-Total Proceeds
- 1099-B-Total Cost Basis
- 1099-B-Total Market Discount
- 1099-B-Total Wash Sales
- 1099-B-Realized Gain/Loss
- 1099-B-Federal Income Tax Withheld
- 1099-OID-Total Original Issue Discount
- 1099-OID-Total Original Issue Discount On U.S. Treas. Obligations
- 1099-OID-Tax-Exempt OID
- 1099-OID Total Original Issue Discount - REMIC
6
- TAX YEAR
- FILE_CLOSING_DATE
- CLOSE_DATE
- OPENING_TRANSACTION
- OPEN_DATE
- UNDERLYING_SYMBOL
- SECURITY_DESCRIPTION
- QUANTITY
- PROCEEDS
- COST
- CODE
- GAIN_LOSS_ADJ
- TERM
- 8949_BOX
- GAIN_LOSS
- CLOSING_TRANSACTION
7
- Account Summary
- null
- null
- null
- null
- null
- null
- null
- null
- null
- null
8
- Account Summary
- null
- null
- null
- null
- null
- null
- null
- null
- null
- null
- null
- null
9
- Account Summary
- null
- null
- null
- null
- null
- null
- null
- null
- null
- null
- null
10
- Quantity
- Security
- Date acquired
- Date sold
- Sales price
- Cost
- Wash sale loss disallowed
- Accrued market discount
- Basis adjustment
- QOF deferral adjustment
- Other adjustment
- Total adjustments
- Gain (Loss)
- Nominee adjustment
- Net Gain (Loss)
- Basis reported to IRS
- Reported on 1099-B
- Type of gain is incorrect
- Expired Purchased Option
- Expired Granted Option
- Collectible
- Ordinary
- Term
- Internal Use
11
- 1099-B
- ACCOUNT NUMBER
- TAX YEAR
- DATE ACQUIRED
- SALE DATE
- DESCRIPTION
- SHARES
- COST BASIS
- SALES PRICE
- TERM
- ORDINARY
- FED TAX WITHHELD
- WASH AMT DISALLOWED
- ACCRDMKTDISCOUNT
- FORM8949CODE
- GROSSPROCEEDSINDICATOR
- LOSSNOTALLOWED
- NON COVERED
- BASIS NOT SHOWN
- FORM 1099 NOT REC
- COLLECTIBLE
- QOF
- PROFIT
- UNRELPROFITPREV
- UNRELPROFIT
- AGGPROFIT
- STATECODE
- FATCA
- STATEIDNUM
- STATETAXWHELD
- PAYER FED ID
- PAYER NAME1
- PAYER NAME2
- PAYER ADDR1
- PAYER ADDR2
- PAYER ADDR3
- PAYER CITY
- PAYER STATE
- PAYER ZIP
- PAYER PHONE
12
- 1099-INT
- ACCOUNT NUMBER
- TAX YEAR
- PAYER RTN
- INT INCOME
- EARLY WD PENALTY
- INT USBONDS
- FED TAX WH
- INV EXPENSE
- FOR TAX PD
- FORCNT
- TAX EXPMT INT
- SPECIFIED PAB INT
- MARKETDISCOUNT
- BONDPREMIUM
- BONDPREMUSOBLIGATIONS
- TEBONDPREMIUM
- FATCA
- STATECODE
- STATEIDNUM
- STATETAXWHELD
- PAYER FED ID
- PAYER NAME1
- PAYER NAME2
- PAYER ADDR1
- PAYER ADDR2
- PAYER ADDR3
- PAYER CITY
- PAYER STATE
- PAYER ZIP
- PAYER PHONE
13
- 1099-DIV
- ACCOUNT NUMBER
- TAX YEAR
- ORDINARY DIV
- QUALIFIED DIV
- TOTAL CAP GAIN
- UNRECSEC1250
- SEC1202
- P28 GAIN
- SEC897DIV
- SEC897GAIN
- NONTAXDIST
- FEDTAXWH
- SEC199A
- INVESTEXP
- FORTAXPD
- FORCNT
- CASHLIQ
- NONCASHLIQ
- EXEMPTINTDIV
- SPECIFIEDPABINTDIV
- FATCA
- STATECODE
- STATEIDNUM
- STATETAXWHELD
- PAYER FED ID
- PAYER NAME1
- PAYER NAME2
- PAYER ADDR1
- PAYER ADDR2
- PAYER ADDR3
- PAYER CITY
- PAYER STATE
- PAYER ZIP
- PAYER PHONE
14
- Timestamp (UTC)
- Transaction Description
- Currency
- Amount
- To Currency
- To Amount
- Native Currency
- Native Amount
- Native Amount (in USD)
- Transaction Kind
15
- Type
- Buy
- Cur.
- Sell
- Cur.
- Fee
- Cur.
- Exchange
- Group
- Comment
- Date
16
- Symbol
- Security
- Quantity of Shares
- Share Price
- Total Purchase Price
- Date Bought
- Account Number
- Status
- Date Sold
- Value per Share Sold
- Total Proceeds
- Reportable Gain/Loss
- Disallowed Wash Sale
- Covered
- Original Cost
- Original Acquisition Date
17
- Description
- Quantity
- Date Acquired
- Cost/Share $
- Total Cost $
- Date Sold
- Sales Proceed
- Proceeds $
- Gain $
- Deferred Loss $
18
- Date
- Received Quantity
- Received Currency
- Sent Quantity
- Sent Currency
- Fee Amount
- Fee Currency
19
- Transactions
- Quantity
- Description of Property
- Cusip
- Date of Acquisition
- Date of Sale or Exchange
- Sales Price (see Schedule D instructions)
- Cost Basis
- Accrued Market Discount
- Wash Sale Loss Disallowed
- Gain or (Loss)
- Transaction Description
- YTD Amortization/Accretion
- LTD Amortization/Accretion
- Proceeds from Collectibles
20
- Symbol
- Description
- Open Date
- Close Date
- Proceeds
- Cost Basis
- Codes
- Amount of Adjustment
- Gain or Loss
21
- Close Date
- Rec type
- Open Date
- Security
- Shares Sold
- Proceeds
- Cost
- Code
- Gain/Loss Adjustment
- ST/LT
- Box
- Gain/Loss