Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

1099R Detail Report (FPSDR152-1)

Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

1099R Detail Report (FPSDR152-1)

Previous pageReturn to chapter overviewNext page  Print this Topic

Availability

This report is run in November on the October monthend file every year as a test. On December 31st every year, the report is run for IRS reporting deadlines.  This report can be printed to paper and to GOLDView as per institution request on year-end letters.

 

Purpose

The 1099R Detail Report shows the relationship between retirement accounts, their owners, and distributions made from those retirement accounts. This report can be sorted by short name or by Social Security Number (SSN). It will list every account by Social Security Number, distribution amount, and distribution code.

 

Accounts will be excluded from the report if the account owner has an SSN/EIN type of 020, 021, 022, 120, 121, or 122 in theName/SSN/Citizenship type field (NDCTYP) on the Detailed Name Information screen (function 15/16) and the Household Names screen (function 13/14) in the CIF System (Application 9). In addition, 1099R forms will not print for these accounts.

 

Report Column Information

See FPSDR152-1 Example for an example of this report.

 

Column

Description

SSN#

This column displays the Social Security Number of the person indicated by the IRS owner (MNSSFI).

Account Number

This column displays the account number associated with the account.  It consists of the office number (DMACTO), account number (DMACTA), and check digit (DMCKDG).

IRS Owner

This column displays the short name of the IRS owner associated with the account.  It is taken from the CIF System (SHNAME).

Dist Code

This column displays the distribution code used for this distribution (DMDSCA).  The following is a list of possible distribution codes:

1

Premature Distribution

-TRAD, SIMP, QUAL, ESA

2

Premature Exception

-TRAD, QUAL

3

Disability Distribution

-TRAD, SIMP, QUAL

4

Death Distribution

-TRAD, SIMP, QUAL

4A

Death Distribution

-QUAL

4G

Death Distribution

-TRAD, SIMP, QUAL

5

Proh Tran Distribution

-All IRAs

5J

Proh Tran Distribution

-ROTH

7

Normal Distribution

-TRAD, SIMP, QUAL, ESA

7A

Normal Distribution

-TRAD, QUAL

8

Current Year Excess

-TRAD, ROTH, QUAL, ESA

81

Current Year Excess

-TRAD, ROTH, QUAL, ESA

82

Current Year Excess

-TRAD, ROTH, QUAL, ESA

84

Current Year Excess

-TRAD, ROTH, QUAL, ESA

8J

Current Year Excess

-ROTH

10

Current Yr Interest Excess

-TRAD, ROTH, QUAL

11

Prior Year Interest Excess              

-TRAD, ROTH, QUAL

B

Designated Roth Distribution

-ROTH

D

Prior Year Excess Additions

-TRAD, ROTH

E

Excess Additions

-TRAD, ROTH

H

Direct Rollover-Qualified Retirement Plan (QRP)

-TRAD, QUAL

G

Direct Rollover-IRA    

-TRAD, SIMP, QUAL

J

Early Dis Roth IRA

-ROTH

N

Cur Yr Rchr IRA Ct

-TRAD, SIMP, ROTH

P

Prior Year Excess

-TRAD, ROTH, QUAL

P1

Prior Year Excess

-TRAD, SIMP, QUAL

P2

Prior Year Excess

-TRAD, SIMP, QUAL

P4

Prior Year Excess

-TRAD, SIMP, QUAL

PJ

Prior Year Excess

-ROTH

Q

Prior Year Excess

-ROTH

R

Pri Yr Rchr IRA Ct

-TRAD, SIMP, ROTH

S

Simple Dist

-SIMP

T

Roth IRA Dist Excp

-ROTH

YTD Dist

This column displays the year-to-date total of distributions made from this account (DMDSYD).

YTD Federal Withholding

This column displays the year-to-date total of federal withholding for this account (DMDFWH).

YTD State Withholding

This column displays the year-to-date total of state withholding for this account (DMSTWH).

Type

This column displays the type of retirement account.  The retirement type can be found on the Retirement Fields screen (function 53/54).  Valid types include IRA (DMRIRA), QRP (DMSTAR), SIM (DMSIMP), SEP (DMSEPP), ROTH (DMROTH), and ROL (DMCOND).

 

Totals and Subtotals Provided

This report provides totals for the number of distributions, amount of federal withholding, amount of state withholding, and the total dollar amount of distributions including withholdings.

 

Totals are displayed on the last page of the report. See FPSDR152-1 Example for an example of this report.

 

1099-R Form

The notice below is an example only. Please note that the form is subject to change based on federal regulation and may appear different from the one pictured. A statement sequence number will be printed at the end of the name line.

 

fpsdr1521form

fpsdr1521form2

©2021 GOLDPoint Systems. All rights reserved.