; FAQ 868: Cash Balance - How do you print plan statements?

FAQ 868: Cash Balance - How do you print plan statements?

Problem:

How do you print participant certificates/statements?


Solution:

There are 3 cash balance statement options available within the system:
1. Val System Cash Balance
2. Reporter Cash Balance
3. Val System Combined Cash Balance and DC

1. Val System Cash Balance
The standard cash balance statement is available on the Reports \ Employee Statements \ Cash Balance menu. The following options are available with the standard statement for cash balance plans:
- Select all employees or a subset of employees.
- Print statements for terminated status codes you input.
- Include accrual start, vesting, and early retirement dates.
- Print vested accrued benefit.
- Print Maximum Lump Sum.
- Include "Prepared By" and/or "Date" options.
- Print separate files for each employee.
- Mask social security number.
- Customize the disclaimer that prints at the bottom of the statement.
- Print statements for input locations.

2. Reporter Cash Balance
There are four cash balance statements in the DB.RMS file that is located in the \ASCNET\REPORTS directory. To print one of the statements, do the following:
- Choose "Reports" and "Reporter" from the ASC Main Menu.
- Click on the spyglass next to the "File Name" box, change to the \ASCNET\REPORTS directory, choose "DB.RMS" as the file to use, and click on the "Open" button.
- Click on the spyglass next to the "Report Name" box to retrieve the reports. Click on the down-pointing arrow and choose either the "CSHBLEOY" (end of year statement) or "CSHBLBOY" (beginning of year statement). If you have a plan that is coded as a traditional plan converted to a cash balance plan, you can choose "CBTDEOY" (end of year statement) or "CBTDBOY" (beginning of year statement). The CBTDEOY/CBTDBOY will print an "Additional Benefit Earned" section for participants that have an add-on benefit coded in the Benefits>PROJBENF screen of their employee record.
- If you want to print individual employee statements, check the box that says "Employee Subset" and click on the spyglass next to the "Key of First EE" box and choose the employee to be printed.
- Click on the "Printer Setup" button and select the desired printer.
- Click "OK" and wait (it will say "Processing Completed" in the Reporter window when the report is done building and is ready to print).

3. Val System Combined Cash Balance and DC
For cash balance plans paired in ASC with a DC 401k Plan, a combined DC/DB statement is available from the DC menu on the DC: Reports \ Employee Statements \ DCDB Combo menu.
To use this statement, it is important to ensure that the Cash Balance and DC 401k Plan are set up correctly. Chapter 14 of the DB Reference Manual provides best practice reminders on proper setup.
The following options are available with the DCDB combo statement:
- Select all employees or a subset of employees.
- Print statements for terminated status codes you input.
- Include interest crediting rate, accrued benefit, expected contribution credit (for BOY valuation dates), additional accrued benefits (add-on annuity benefit prior to cash balance conversion), and additional accrued benefit lump sum.
- Print vested accrued benefit.
- Print Maximum Lump Sum.
- Print DC annuity benefit, combined CB and DC annuity benefit, estimated lump sum value of the combined benefit.
- Print compensation.
- Print estimated Social Security benefit.
- Include "Prepared By" and/or "Date" options.
- Print separate files for each employee.
- Mask Social Security Number.
- Customize the disclaimer that prints at the bottom of the statement.
- Print statements for input location codes.