IRS Release Status: FINAL

Sample Excel Import File: 5498 2017.xlsx

What's New for 2017

Reporting late rollover contributions to an IRA.
Report late rollover contributions certified by the participant in boxes 13a and 13b on Form 5498. Report the self-certification code in box 13c.

Import Form Fields:

Field NameSizeType DescriptionNotes
See Form Filer Common FieldsFiler fields common to all form types.
See Recipient Common FieldsRecipient fields common to all form types.

Box 1 Amount

12AmountBox 1: IRA contributions (other than amounts in...)
Box 2 Amount12AmountBox 2: Rollover contributions

Box 3 Amount

12Amount

Box 3: Roth IRA conversion amount


Box 4 Amount

12AmountBox 4: Recharacterized contributions
Box 5 Amount12AmountBox 5: Fair market value of account

Box 6 Amount

12Amount

Box 6: Life insurance cost included in box 1


Box 7 Checkbox 11CheckboxBox 7: IRAX / Y / T / 1 = Checked
Box 7 Checkbox 21CheckboxBox 7: SEPX / Y / T / 1 = Checked
Box 7 Checkbox 31CheckboxBox 7: SIMPLEX / Y / T / 1 = Checked
Box 7 Checkbox 41CheckboxBox 7: Roth IRAX / Y / T / 1 = Checked
Box 8 Amount12AmountBox 8: SEP contributions
Box 9 Amount12AmountBox 9: SIMPLE contributions
Box 10 Amount12AmountBox 10: Roth IRA contributions
Box 11 Checkbox1CheckboxBox 11: Check if RMD for 2016X / Y / T / 1 = Checked
Box 12a Date10DateBox 12a: RMD dateMM/DD/YYYY or M/D/YYYY
Box 12b Amount12AmountBox 12b: RMD amount
Box 13a Amount12AmountBox 13a: Postponed contribution
Box 13b Year4NumericBox 13b: Year
Box 13c Code8TextBox 13c: CodeE012744 / E013119 / E013239 / FD / PL106-21
Box 14a Amount12AmountBox 14a: Repayments
Box 14b Code2TextBox 14b: CodeDD / QR
Box 15a Amount12AmountBox 15a: FMV of certain specified assets
Box 15b Code2TextBox 15b: Code(s)See IRS Instructions
See Form Common FieldsForm fields common to all form types.

5498 Form:

IRS 5498 Form:  5498 Form

IRS 5498 Instructions:  5498 Instructions

  • No labels