A 1099 Express source record for Form 1099-B Broker Barter Exchange for 2010 looks like this:
B|A|SSN|Cor|Frgn|Sales|CS|Name1|Name2|Addr|City|State|Zip|Account|Amt1|Amt2|...Amt12
Field 1: Capital "B", This is the Record Identifier.
Field 2: Capital "B", Identifies the form as 1099-B.
Filed 3: Payee's Social Security Number.
Field 4: Correction Indicator.
Field 5: Set to "1" if payee is Foreign (outside USA).
Field 6: Set to "1" if Box12 is checked, else empty.
Field 7: Combined State Code, not used by 1099-B.
Field 8: Payee Name 1 Field.
Field 9: Payee Name 2 Field, usually empty.
Field 10: Payee Address.
Field 11: Payee City.
Field 12: Payee State Code.
Field 13: Payee Zip Code.
Field 14: Account Information. Must be unique to distinguish corrections for duplicate recipients.
Field 15: Box 2b, Gross indicator, 1 is gross, 2 is gross less commissions and options premimus.
Field 16: Box 1a, Date of sale, enter as MM-DD-YYYY, converted in IRS file to yyyymmdd. See
Excel date tips.
Field 17: Box 1b, For broker transactions only. CUSIP No. of the item
reported for Box2. Leave empty, (blank) if aggregate trans. Enter 13 zeros if number not available.
Program will Rjust and left blank fill. Max 13.
Field 18: Box 7, Descripiton, Ex: 100 shares of XYZ Corp, Ljust and right blank fill,
Max 39.
Field 19: Box 5, Number of shares exchanged.
Not a Money amount, Rjust Zfill in IRS file, Max 8.
Field 20: Box 6, Class of stock exchanged,
Max 10.
Field 21: Amt1-Empty Not used, see Field 16-17 for Box 1.
Field 22: Amt2-Box2, Stocks, Bonds, etc.
may be negative.
Field 23: Amt3-Box3, Bartering, must be positive.
Field 24: Amt4-Box4, Federal income tax withheld, must be positive.
Field 25: Amt5-Empty Not Used, Box 5 is not a money amount.
Field 26: Amt6-Box8, Profit or (negative, loss) realized in this tax
year.
Field 27: Amt7-Box9, Unrealized profit or (negative, loss) on open contracts 12/31/previous
tax year.
Field 28: Amt8-Box10, Unrealized profit or (negative, loss) on open contracts 12/31/this
tax year.
Field 29: Amt9-Box11, Aggregate profit or (negative, loss), regulated
futures or foreign currency contracts.
Field 30: AmtA-Not used, in 2003 was Box6b, Post 5/5/2003 Profit or loss realized.
Field 31: AmtB-Not used, in 2003 was Box9b,Post 5/5/2003 Aggregate profit or loss.
Field 32: 2nd Tin Notice: If checked the IRS will not send further notices.
See 1099-B Instructions
for rules.
All Fields are normal Ascii strings, without a Ascii Zero trailer. Each record is terminated by a carriage return, line feed sequence.
There are no state, local or other money boxes on the form. 1099-B does not support combined states reporting. The IRS added, dropped, and changed titles for various boxes on form 1099-B, between 2003 and 2004. Therefore, if you import or bring money amounts from 2003 to 2004, you must be sure all data is in the correct box. Does not support "Corporation's name" box. The Corporation's name box has no field designation in IRS Publication 1220, thus is not included in data which is e-Filed to the IRS.