A 1099 Express source record for Form 5498-IRA looks like this:

B|L|SSN|Cor|Frgn|Box7|CS|Name1|Name2|Addr|City|ST|Zip|Acct |Amt1|Amt2|Amt3|Amt4|Amt5|Amt6|Amt7|Amt8|Amt9|Amt10
empty|empty|1|mm-dd-yyyy|Amt11|Amt12|2008|FD|Amt13|QR|Amt14|BK

Field 1: Capital "B", This is the Record Identifier.
Field 2: Capital "L", Indicating Form 5498-IRA.
Filed 3: Participant's Social Security Number.
Field 4: Correction Indicator.
Field 5: Set to "1" if payee is Foreign (outside USA).
Field 6: Box 7, Plan Type: "A"=IRA, "B"=SEP, "D"=Simple, "H"=Roth IRA. These are mutually exclusive.
Field 7: Combined State Code.
Field 8: Participant Name 1 Field.
Field 9: Participant Name 2 Field, usually empty.
Field 10: Participant Address.
Field 11: Participant City.
Field 12: Participant State Code.
Field 13: Participant Zip Code.
Field 14: Participant Account Information. Must be unique to distinguish corrections for duplicate recipients.
Field 15: Amt01-Box 1 IRA contributions (see form).
Field 16: Amt02-Box 2 Rollover contributions.
Field 17: Amt03-Box 3 Roth Conversion amount.
Field 18: Amt04-Box 4 Re-characterized contributions.
Field 19: Amt05-Box 5 Fair Market value of account.
Field 20: Amt06-Box 6 Life insurance cost included in Amount Code 1.
Field 21: Amt07-Not used. Must be empty.
Field 22: Amt08-Box 8 SEP Contributions.
Field 23: Amt09-Box 9 SIMPLE contributions.
Field 24: Amt10-Box 10 Roth IRA contributions.
Field 25: Not used. Must be empty.
Field 26: Ignored, if present.
Field 27: Box 11 - Required Minimum Distribution (RMD)="1" else empty.
Field 28: Box 12a - RMD date, MM-DD-YYYY converted to IRS format of YYYYMMDD for IRS file.
Field 29: Amt11-Box 12b - RMD amount.
Field 30: Amt12-Box 13a - Postponed contribution a dollar amount.
Field 31: Box 13b - Year of Postponed contribution, YYYY
Field 32: Box 13c - Postponed Contribution Code, 2 chars: FD, AF, JE, EF or IF (war codes)
 In 2012 Field 32 is lengthened to 8 characters to hold longer codes for Executive Order Numbers.
Field 33: Amt13-Box 14a - Repayments a dollar amount.
Field 34: Box 14b - Repayment Code, 2 chars: QR or DD
Field 35: Amt14-Box 15a - Other Contributions a dollar amount.
Field 36: Box 15b - Bankruptcy Code, BK or blank.

 
All Fields are normal Ascii strings, without a Ascii Zero trailer. Each record is terminated by a carriage return, line feed sequence.
 
Back to Source Record Formats
Back to Main Menu