A 1099 Express source record for Form 1099-R for 2020 forward:
B|9|SSN|Cor|Frgn|Bar|CS|Name1|Name2|Addr|City|Sate|Zip|Acct|Field1|Field2...|Field41
For more information on Form 1099-R, please see 1099-R Special Requirements. The 1099 Express source record format for Form 1099-R has been changed from the format shown in the previous help file. It is now as follows:
Field 1: Capital "B", This is the Record Identifier.
Field 2: Holds the character '9' indicating 1099-R.
Filed 3: Payee's Social Security Number.
Field 4: Correction Indicator.
Field 5: Set to "1" if payee is Foreign (outside USA).
Field 6: Barcode or null, effective ver 2003.54.
Field 7: Combined State Code.
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 7. Distribution Code per instructions. Max 2 chars.
Field 16: Box 2b1, Taxable amount not determined box. 1=checked, empty=unchecked. If checked, Box 2a must be empty,
unless box 7b is checked.
Field 17: Box 7b, IRA/SEP/SIMPLE box. 1=checked, empty=unchecked. If checked, Box 1 must have an amount.
Field 18: Box 2b2, Total Distribution box. 1=checked, empty=unchecked.
Field 19: Box 9a. Your percentage of total distribution. Must be 2 numeric digits from 01 to 99, or empty for 100%.
Field 20: Box 14, $ State tax withheld. e-Filed in 723-734 of the IRS B Record.
Field 21: Box 15. State/Payer's state no.
Field 22: Box 16, $ State Distribution.
Field 23: Not Used.
Field 24: Not Used.
Field 25: Not Used.
Field 26: Box 17, $ Local Tax withheld. e-Filed in 735-746 of the IRS B Record.
Field 27: Box 18, Name of locality.
Field 28: Box 19, $ Local Distribution.
Field 29: Not Used.
Field 30: Not Used.
Field 31: Not Used.
Field 32: Amt01-Box 1. $ Gross Distribution.
Field 33: Amt02-Box 2a. $ Taxable Amount.
Field 34: Amt03-Box 3. $ Capital gain (included in box 2a).
Field 35: Amt04-Box 4. $ Federal income tax withheld.
Field 36: Amt05-Box 5. $ Employee contributions, Des Roth cont, or ins. premiums.
Field 37: Amt06-Box 6. $ Net unrealized appreciation in employer's securities.
Field 38: Always empty, do not use. was Amt07-Box 7.
Field 39: Amt08-Box 8. $ Other.
Field 40: Amt09-Box 9b. $ Total employee contributions.
Field 41: Always empty, do not use. was Amt10-Box 10.
Field 42: Box 11. - 1st Year of Designated Roth Contributions. Format is YYYY, Pos 552-555.
Field 43: Amt11-Box 10. $ Amount allocable to IRR within 5 years.
Field 44: Box 12. FATCA filing requirement. Header is FATCA, new in 2016.
Field 45: Box 13. Date of payment for reportable death benefits under section 6050Y. Data format is MM/dd/YYYY or mm-dd-yyyy.
Form 1099-R Notes:
The first character of Field 15 (Box 7 Distribution code), must be a 1 through 9,
or one the letters ABEFGJLNPQRST. Any other characters will be rejected.
If the IRS/SEP/SIMPLE check box is checked, an amount must be present is Box 1.
If paying the same recipient/ssn in 2 or more states, then 2 or more separate 1099-R
forms are required, if there was withholding.
For more information on about Form 1099-R please see the
1099-R Instructions at the IRS web site www.irs.gov./pub/irs-pdf/i1099r.pdf.
For more help on Form 1099-R, please click here
1099-R Special Requirements.
All Fields are normal Ascii strings, without a Ascii Zero trailer. Each record is terminated by a
carriage return, line feed sequence.