Deposit Reports > Deposit Reports - Numerical Order

Availability

This file is only processed at year-end and after April 15th for clients that use Fiserv for their retirement account contribution reporting. It is processed manually after the completion of year-end and after April 15.

Purpose

The purpose of this program is to create a file to be sent to Fiserv for clients that use Fiserv as a third-party processor for their contribution reporting on retirement accounts. This program does not create a report. It is an optional service and is not required because GOLDPoint Systems can process all year-end forms and reports and forward them to the IRS for our clients. If you choose to use this third party, you must send a work order to process this file at year-end and then again after the April 15th deadline for contributions. In addition, all your distributions must be handled directly through Fiserv using their methods and procedures; we do not send any files to them for distribution transactions.

Fiserv should assign you a customer number up to four digits long that we need to enter in the setup for this program.

When Fiserv requires format changes to this file, we will split the programming costs (at the standard programming amount) with all the clients that utilize this service. We do not receive this information from Fiserv, so you are responsible for forwarding it to us, along with a work order. A $300.00 fee will be charged to process this file each time we process it. We will create one CD and send it to Fiserv for all our clients combined.

GOLDPoint Systems Only: This program creates the output that 5498 T then reads by using Fiservye.F JCL. This JCL formats the header and trailer records and creates a tape for each institution. The tape needs to be converted to one CD, combining all clients together.

The Misc Parm field must be set to “LINCOLN XXXX” on the report setup, where either XXX is the three-digit customer number or XXXX is the four-digit customer number that has been assigned by Fiserv. LINCOLN is the standard in this field because this bank originally received the file, but Fiserv bought the program as of 2005.

Input Records are DM and MN, and criticals must be 1-4. Set the When to Run field to “UPSI20.”

File Information Header

Field Name	Start Position	End Position	Description
Institution Number	1	4	Institution control number (assigned to each institution by Lincoln Retirement Services)
Filler	5	35	Zero fill
Record Code	36	36	Zero constant
Institution Name	37	66	Name of the institution
Filler	67	105	Spaces

Detail Record

Field Name	Start Position	End Position	Description
Institution Identifier	1	4	Institution identifier assigned by Lincoln Retirement Services
Social Security Number	5	15	Identifies the individual and includes dashes (111-11-1111)
Account Number	16	35	Identifies the account number. Left justify and blank fill. Include dashes if applicable.
Record Code	36	36	"A" constant

	Note: All contribution fields must be right justified, preceded by zeros, and include two places to the right of the assumed decimal place. Do not include commas. Also, the decimal character must not be signed.

Regular IRA Contributions for Tax Year 20XX	37	45	Contributory IRA account deposits made from 01/01/20XX to 04/15/20XX for reporting tax year 20XX. Exclude trustee to trustee transfers and internal accounts. Transfers due to type or rate changes.
Rollover IRA Contributions for Tax Year 20XX	46	54	Rollover contributions made between 01/01/20XX and 12/31/20XX
Account Value as of 12/31/20XX	55	63	Fair market value of the IRA or SEP account as of 12/31/20XX
Employer SEP Contributions	64	72	Employers’ contributions to a SEP Plan for 20XX
Roth Conversion Contribution	73	81	Roth conversion contributions for 20XX
Roth IRA Contribution	82	90	Roth contributions for 20XX
Filler	91	99	Zero fill
Recharacterization Contribution	100	108	Recharacterization contributions for 20XX
IRA Indicator	109	109	“X” if this is an IRA Plan
SEP Indicator	110	110	“X” if this is an SEP Plan
Roth IRA Indicator	111	111	“X” if this is a Roth Plan
Filler	112	113	Blank
Self Directed Plan Indicator	114	114	“X” if this is a Self-Directed Plan

Trailer Record

Field Name	Start Position	End Position	Description
Institution Identifier	1	4	Institution identifier assigned by Lincoln Retirement Services
Filler	5	35	All 9’s
Record Code	36	36	“9” constant
Total Number of Detail Records	37	45	Total count of all detail records for the institution
Filler	46	114	Spaces

Fiserv 5498 File Creation Program (FPSDR097)

Fiserv 5498 File Creation Program (FPSDR097)