1099Q Detail Report/Forms (FPSDR154) |
  
|
Navigation: Deposit Reports > Deposit Reports - Numerical Order >
1099Q Detail Report/Forms (FPSDR154) |
|
Availability
This report and these forms are run in November on the October 31st file every year as a test. On December 31st of every year, this report and these forms are printed to meet IRS reporting requirements for ESA distributions and earnings.
Purpose
The 1099Q Detail Report/Forms (FPSDR154) shows the relationship between ESA accounts, their owners, and distributions made from those accounts. This report can be sorted by short name or by Tax Identification Number (TIN). If the account holder has more than one account, only one account number will be printed. This account number must be used for any corrections created after year-end.
|
GOLDPoint Systems Only: •Create one setup for forms and another one for the report. •Set misc opts 1 to “Y” to print the report. Set misc opts 2 to “Y” to print forms. •To combine notices by Social Security number, the sort fields and lengths are as follows
86 Mail code (1) 81 Social security number (5) 89 Plan number (2)
•To combine notices by short name, both the short name and the Social Security number sort fields must be used, and used in this order. Sort fields and lengths are as follows:
86 Mail code (1) 82 Short name (10) 81 Social security number (5) 89 Plan number (2)
This sort order is not optional. •Set the critical field as follows: “1-4” for notices, “1-12” for the report sorted by Social Security number, and “1-22” for the report sorted by short name. •For forms only, the subprog cntrls print field should be set to “Y.” |
|---|
Report Column Information
See FPSDR154 Example for an example of this report.
Column |
Description |
|---|---|
SSN |
This is the Social Security number of the IRS account owner (MNSSFI) pulled from the CIF System (Application 9). |
Account Number |
This is the office number (DMACTO), account number (DMACTA), and check digit (DMCKDG) pulled from the Account field on the Deposit Master Fields screen (function 1/2). |
Plan# |
This is the Retirement Plan Number (DMPLAN) for the retirement account. It is pulled from the Deposit Master Fields screen (function 1/2). |
Owner’s Short Name |
This is the IRS owner’s short name (SHNAME) pulled from the CIF System (Application 9). |
YTD Distributions |
This column displays the year-to-date total of distributions made from this account. This amount is pulled from the Amount YTD field (DMDSYD) on the Account Distribution Totals screen (function 53/54, then click <Distributions>). |
YTD Federal Withholding |
This column displays the year-to-date total of federal withholding for this account pulled from the Federal field (DMDFWH) on the Account Distribution Totals screen (function 53/54, then click <Distributions>). |
YTD State Withholding |
This column displays the year-to-date total of state withholding for this account pulled from the State field (DMSTWH) on the Account Distribution Totals screen (function 53/54, then click <Distributions>). |
End of Year Balance |
This is the Current Balance (DMCRBL) at the end of the calendar year. It is pulled from the Deposit Master Fields screen (function 1/2). |
Totals and Subtotals Provided
See 1099Q Detail Notice Example.
Security Access Records
The notice above is an example only. Please note that the form is subject to change based on Federal Regulation and may appear different from the one illustrated above. A statement sequence number will be printed at the end of the name line.
