After clicking on "Add New Year End", enter the Year end you will be testing and click on "Add Year End". When you add the very first plan year end, the software will copy plan specifications from the plan document, if it's on ftwilliam.com. If not then the software will use the default provisions for whatever document type you selected. You can customize one or more default plans for the admin system. To do this, on the Select Company screen select ZZZ - Default Plans from the drop-down box and click 'Select Company'. On the 'Select Plan' screen, choose a plan type, typically the document type that you use most often. Click 'Select Plan'; you can now enter your plan provisions section by section. Once you have done this, any plan you add of that document type will default to the provisions you entered. You can add additional default plans for other document types that you use.

When you add another year end, depending on the history in the system, you will be given options to copy specifications from a prior year end or, if the document is on ftwilliam.com, from the plan document.

Plan Set Up - Plan Specifications.Top

Select this link to set up, review or edit the plan specifications; it is very important to ensure the plan specifications are accurate and that overrides are correctly selected. Please see the Help buttons for questions on specific plan specification options and for examples of how to complete the specifications for certain plan designs.

Setting or Editing Plan Specifications. Top

As stated above, if you use ftwilliam.com for plan documents, the plan specifications will automatically be loaded onto the admin system for the plan. Otherwise specifications will be based on defaults that you have set up (in ZZZ-Default plans described under Select Company ). To make a change to plan specifications, click on one of the sections, 'Contributions', Eligibility' etc and complete or change the checklist item as required. You may need to change some checklist items if the plan document has changes that do not take effect until a future year. Also, you should also check the following under 'General Features/Sources and Investment Accounts':

• Under 'General Plan Features' make sure all dates are in numeric format as specified in the instructions to the left of the date field.
• Under 'General Plan Features' if you want to use employee number, rather than social security number as the unique participant identifier, you should indicate here under 'Enter ID for Participant Upload/Download:'.
• Under 'Contribution Sources' make sure all the sources active in the plan are listed.
• Under 'Accounts/Sources' indicate whether the plan will be tracking participant balances by investment account. If you are using an asset custodian and not tracking participant loans then this should be 'No,. If you have more than one investment you will need to indicate 'Yes' here; then click the 'Refresh link' and set up the investments as specified below:
• Under 'Accounts/Sources' you can indicate whether plan assets are held with an asset custodian and you plan to upload transaction files. If so you should select the asset custodian from the drop-down box and also enter your TPA account ID. If you plan to upload files from a custodian not listed you should select 'Generic'. Check with support@ftwilliam.com to get a sample format for your upload.
• Under 'Eligibility' indicate whether the eligibility computation period will switch to the plan year.
• Under 'Contributions' indicate whether the plan will make safe harbor contributions.

• Seq - this is a sequence number which determines the order in which the investments are listed. If you want an investment to appear lower in the list you can change the sequence number to something higher. When you click 'Update' the investments will be reordered.
• AccountID - this is the unique identifier for the investment used by the system. For amounts held with an asset custodian you should use 'Vendor'. Other typical IDs are 'Pooled' for a pooled account, 'Brokerage' for a brokerage account and 'Loan' for the loan fund.
• Account Name - you can assign a name to the investment; this name will be used to identify the investment on other screens and on reports. You may want to use the name of the asset custodian for the vendor account; otherwise you should use something that will easily identify the investment both to you and other system users.
• Account Description - this is a field you can use to enter more detailed information about the investment; it is not used in any other areas or reports.
• Type - select 'Brokerage' for brokerage accounts and 'Cash' for all other investments. 'Unit' is not currently an active option.

  If the plan is using the Loan Module you will also want to indicate which investments can be used for loan issue. Select 'Investment Accounts Available for Loans' and indicate 'Yes' from the drop down box for each of the investments that can be used for loans. Note that the Loan Fund should always have 'No' selected. You should also ensure that the designated loan fund is correct under 'Select Loan Account'. Next click 'Hierarchy' and indicate whether loans should be issued pro-rata from all applicable investments or whether the ordering rule is used. If you choose 'Ordering Rule' you will need to indicate the order by using the sequence numbers.

  Having set up your investments you now need to tell the software which of these investments are available to each source. Go to "Plan Set Up/Plan Specifications/General Features/Sources and Investment Accounts". Scroll down to "Accounts/Sources" and click on "Work with Sources".

• Del - Pressing the 'Del' link will delete the applicable investment account. Only investment accounts that are not in any pending or posted batches in any current or prior plan year can be deleted.

The "Print Reports" options you see on this page along the right-hand side will print standardized reports to a Word document or Excel file; note that the 'Print Reports' link will not appear as a live link until you have completed the proper set-up steps. For example, the 'Print Reports' link for allocations will not be active until you have run the allocations.

As much as possible, we have tried to arrange the items on the Plan Administration Menu page so that you will typically work your way from the top to the bottom for a particular plan year (once the initial set-up options at the bottom of the page have been completed for the first plan year end of the plan).

You may edit, add or delete items in the census by clicking on "edit census". A data entry grid will appear in a new page with the fields you selected for in the Work With Data Entry Grids menu. You can enter data directly into the grid - to update a field, simply double-click on it and enter the new information. To add a participant, enter the SSN or Employee ID number in the box above the grid and click on "Add Participant". You will then be able to enter data in each of the fields for the new participant. Generally however you will want to upload data into the grid. The system will try to ensure the formatting is within certain limits for certain fields. If you enter data with incorrect formatting you may see the error "Not Valid" and the field will not be updated. If you enter a date as "1/1/01", the system will update the date to the correct formatting ("1/1/2001").

When initially adding census data to the software it is generally easier to upload it. You may also use the ftwilliam Portal (ftwPortal Pro or ftwPortal Express) to input census information in a similar format to the census data entry grid. Or you can download the grid to Microsoft Excel format, enter your data then upload the spreadsheet.

The following columns should generally always be included in your participant census; if you need more information on what the options are for a particular column you can click on the 'Help' link at the top of the column:

• Last name
• First name
• Social Security Number, or Employee number
• Date of birth
• Date of hire
• Date of termination
• Reason for termination
• Date of hire (2)
• Date of termination (2)
• Reason for termination (2)
• Hours
• Plan Compensation
• A column for each contribution type that the plan uses
• Officer - Yes or No
• Ownership %
• Family Group - enter a different letter for each owner, A thru N are available. Assign the same letter as the owner to that owner's family members
• Family Group Relationship - each owner should be coded 'Principal' and all family members should show their relationship to the owner - Spouse, Child etc.
• Employee Class - Normal, Union, Self-Employed etc.
• Employee Type - Full Time, Part Time -there are three part time options; see 'Help' for the specific definitions

Some default grids described above contain linked fields (Participant Lookup and Participation Status, for example).

If you select to "edit" the "Participant Lookup" grid in the Other Import/Export/Reports Menu, you will see links to all the linked fields in the data entry grid (shown at right) since this grid consists of all the linked fields. Each of the links displayed will be explained in more detail below.

• Eligibility Status
• HCE/KEY Status
• Key Status Next Year

   

Set Combined Test Parameters / Do Combined Test. Top

This is where you can run the 415 Limit test, 410(b) Coverage test, and the 404 and 414(s) Limit tests. If you click on "Set Combined Test Parameters" from the Plan Administration Menu page, you will be taken to the "Combined Testing Parameters" screen. Here you can enter details about how the Combined Tests should be handled in the plan.

On the "Combined Testing Parameters" screen there are a number of options regarding Aggregation/Disaggregation that will apply to the ADP/ACP tests and the General Test as well as those covered under the Combined Test. These answers will be displayed in the ADP/ACP and General Test Parameters screen but can only be modified in the Combined Test Parameters.

For more information and examples, click on the help button for a particular question.

You can simply click on "Do Combined Test" to run all of the tests. You will be taken to the "Combined Test" page where results are shown for the 415, 404 and 414(s) test (PASS/FAIL/Not Needed) (shown at right). 410(b) ratio percentage test details will be shown for each contribution type.

You can print the test report directly from the "Combined Test" page or once you return to the Plan Administration Menu page, click on "Print Reports" to view the test results report. In addition, you can review most standard reports as they are completed within the ‘Do’ task. The Print Reports feature allows you to review the details without redoing the task.

As is the case for all the default reports on the system, if there is information you would like to see that is not in one of the predefined reports, go to the Other Import/Export/UD Report Menu and review some of the more detailed report grids there or set up your own report under the Work With Data Entry Grids menu. In addition, you can review most standard reports as they are completed within the ‘Do’ task. The Print Reports feature allows you to review the details without redoing the task.

Set ADP/ACP Testing Parameters / Do ADP/ACP Test.Top

If you click on "Set ADP/ACP Testing Parameters" from the Plan Administration Menu page, you will be taken to the "ADP ACP Parameters" screen. Here you can enter details about how ADP/ACP Testing should be handled in the plan. Note that if you want to use disaggregation of otherwise excludable employees, you select this option on the 'Combined Test Parameters' screen as it will apply to all of the required tests.

For more information and examples, click on the help button for a particular question.

If you click on "Do ADP/ACP Test" from the Plan Administration Menu page, the ADP/ACP Tests will be calculated based on the testing parameters. You will be taken to the "ADP ACP Test Results" page where test results will be displayed (PASS/FAIL). ADR (Actual Deferral Ratio), ACR (Actual Contribution Ratio), ADP (Actual Deferral Percentage) and ACP (Actual Contribution Percentage) will be shown if applicable for nonhighly and highly compensated employees. You can print the test report directly from the "ADP ACP Test Results" page or once you return to the Plan Administration Menu page, click on "Print Reports" to view the ADP/ACP test results.

Set General Test Parameters / Do General Test. Top

If you click on "Set General Test Parameters" from the Plan Administration Menu page, you will be taken to the "General Test Parameters" screen. Here you can enter details about how the general test should be handled in the plan.

410(b)/401(a)(4)/ADP/ACP Testing Options (Modify Responses in Combined Test)

These options pull from the combined test parameters screen. To change these options return to the main Plan Administration Menu and click on Set Combined Test Parameters. The options set here must apply to the 410(b), 401(a)(4) and ADP/ACP tests. If you modify these options, you must rerun all applicable tests.

General Test

The General Test options affect the rate group test, average benefit test and/or gateway test.

Type of General Test

The ‘Type of General Test’ selected will impact the following three things:

• How the General Test is run (whether or not the test is run on allocation % or the allocation projected to retirement age)
• The benchmark at which the Rate Group Test results will be shown (either pass/fail at either midpoint or 70%)
• The benchmark the auto-solve feature will correct to (either midpoint or 70%)

 Type of General Test options are:

• None (system default)
  • Selecting none will grey out the option to run the General Test. If the general test is not required to be run (pro-rata or integrated allocation with no complicated situations, for example) set this to None.

• Cross Test RG at Midpoint
  • Selecting Cross Test RG at Midpoint will run the general test based on the allocation projected to retirement age. 
  • Rate Group test results will be displayed as applicable to the midpoint benchmark.
  • The auto-solve options (to be used for initial failing results) will correct to pass at the midpoint percentage.
  • Note: If the Rate Group passes at midpoint, the Average Benefit Test must also pass for the General Test to be satisfied.
  • Please be aware that it is possible for the Rate Group Test to pass at 70%, yet show only passing at midpoint when using this option. If you happen across this situation and want your report to show Pass at 70%, please change the Type of General Test to “Cross Test at 70%”

• Standard RG at Midpoint
  • Selecting Standard RG at Midpoint will run the general test using actual allocation rates (does not project benefits into the future).
  • Rate Group test results will be displayed as applicable to the midpoint benchmark.
  • The auto-solve options (to be used for initial failing results) will correct to pass at the midpoint percentage.
  • Note: If the Rate Group passes at midpoint, the Average Benefit Test must also pass for the General Test to be satisfied.
  • Please be aware that it is possible for the Rate Group Test to pass at 70%, yet show only passing at midpoint when using this option. If you happen across this situation and want your report to show Pass at 70%, please change the Type of General Test to “Standard at 70%”

• Cross Test at 70%
  • Selecting Cross Test at 70% will run the general test based on the allocation projected to retirement age. 
  • Rate Group test results will be displayed as applicable to the 70% benchmark.
  • The auto-solve options (to be used for initial failing results) will correct to pass at 70%.
  • Note: If the Rate Group test passes at 70% the General Test has been satisfied.

• Standard at 70%
  • Selecting Standard will run the general test using actual allocation rates (does not project benefits into the future).
  • Rate Group test results will be displayed as applicable to 70%.
  • The auto-solve options (to be used for initial failing results) will correct to pass at 70%.
  • Note: If the Rate Group test passes at 70% the General Test has been satisfied.
  • Please note that the gateway test is not required to be met using this option.

Testing Period:

• Current Year– Selecting current year will run the general test based on current year allocations. This is the system default.
• Account Balances – Selecting Account Balances will run the general test using participant’s account balances divided by the number of participation years of service.
  • Aparticipant’s account balance is calculated when statements are run.
    • Transactions must be uploaded in the system for the current year.
    • Correct end balance batch must be posted for the current year.
    • Statements must be run to have the system pull the correct account balance data. Note: statements must be re-run any time changes are made to participation years or when balance information is changed.
    • The account balance is split by source type as follows:
    • GenTestAllocationPermDisp GenTestAllocationNoPermDisp, GenTestAllocationOtherSource GenTestAllocationOtherPlan as applicable
  • Participation years of service 
    • Go to Other Import/Export/Reports and select ‘Sample Census Supplemental w disagg no OR with prior participation yos (638be22)’ in one of the user defined spots and press update. Then press the ‘Edit Data’ link next to the grid. Enter the number of prior years of participation each participant has earned for Service_ParticipationPrYrCummMT and Service_ParticipationPrYrCummPS. If the values are different, the system will select the higher number.
    • Note: If it is the first year on the system you will not need to set the individual participant overrides to ‘Yes’ since the global override is automatically set to yes. If it is not the first year on the system, you will need to set the individual participant override (Service_ParticipationPrYrCummOverride) to ‘Yes’ for all individuals you will be overriding. Or, you can set the global override for prior year participation service by clicking Scrub/Eligibilty Parameters and setting Override calculation of prior year participation service to yes.
    • After all changes are made to prior year participation service, run the data scrub, then run one of the statement options in the Transaction/Statement menu.

If Testing Period is "Account Balances" override calc of balances:

• No – If No is selected, account balances will be pulled from the statements (after one of the transaction/statement options are run).
• Yes – If Yes is selected, the user should go to Other Import/Export/Reports and select Sample General Test Acct Bal grid. The following fields are added together and will need to be changed (as applicable). Note: these fields are normally system generated as described below, but once you set the override to yes, you can just overwrite the data in these fields.
  • Acct Bal Non Elective Perm Disp: Non-elective contributions.
  • Acct Bal Non Elective Perm Disp – Adj: Enter any distributions (as a positive amount) from the non-elective source here.
  • Acct Bal Non Elective No Perm Disp: Safe harbor non-elective contributions, QNECs.
  • Acct Bal Non Elective No Perm Disp – Adj: Enter any distributions (as a positive amount) from the Safe harbor non-elective contributions and QNEC source.
  • Acct Bal Other Source: 401k, Roth, Match, Safe Harbor Match
  • Acct Bal Other Plan: Balances from other plans (ex. Defined Benefit)      

Override NRA:

• No – If No is selected, the normal retirement age that was selected in Plan Specifications will be used in the general test.
• Yes – If Yes is selected the normal retirement age selected in the following question will be used in the general test.

Determination of age:

• Last - Selecting Last uses a Participant's age at the end of the Plan Year.
• Nearest - Selecting Nearest could skew test results, depending on birth dates of HCE and NHCE. The testing age for anyone born in the first six months of a Plan Year (assuming a calendar year plan year) is the age attained during the Plan Year. For anyone born after June 30th, the testing age would be attained age on the next birthday (January 1 to June 30 of the next Plan Year).

Impute Disparity (May not be Yes if NRA < 55)

• Yes – Selecting yes will run the general test with imputing disparity.
• No – Selecting no will run the general test without imputing disparity. Note: Imputed disparity cannot be used if NRA is less than 55.

Interest: The interest rate is a factor in cross testing when projecting the allocation to retirement age. A higher interest rate will produce a larger value at retirement age.

• Select "7.5%", "8.0%", or "8.5%".

Actuarial Table: Actuarial tables determine one of the factors used in cross testing when projecting the allocation to retirement age.

• Select one of the actuarial tables listed from the drop down box.

Override Gateway Test

• No: This is the system default. Selecting No allows the system to calculate the gateway test.
• Yes: Select "Yes" to override system calculated result. This will show an automatic PASS result.

Do General Test Top

If you click on "Do General Test" from the Plan Administration Menu page, the general test will be calculated based on the parameters. You will be taken to the "General Test" page where testing parameters will be shown as well as the Rate Group Test, Gateway Test and Average Benefit Test (shown at right). You can print the test report directly from the "General Test" page or once you return to the Plan Administration Menu page, click on "Print Reports" to view allocation calculations and eligibility for each contribution type.

If you fail one or more of the tests, the Auto Solve options to correct a failed test will be displayed on the General Test screen. You will see two options to correct each test - either to increase amounts given to NHCEs or to decrease amounts to NHCEs. Clicking one of the links will show you the change required to pass the test and you will see a 'View Changes' link that you can click to see the cost or the amount of the reduction for each group.

For each failed test you can select the preferred correction method and click 'Revise Allocations and Re-run Test' to correct.

As is the case for all the default reports on the system, if there is information you would like to see that is not in one of the predefined reports, go to the Other Import/Export/UD Report Menu and review some of the more detailed report grids there or set up your own report under the Work With Data Entry Grids menu. In addition, you can review most standard reports as they are completed within the ‘Do’ task. The Print Reports feature allows you to review the details without redoing the task.

Set Top Heavy Test Parameters / Do Top Heavy Test. Top

The Top Heavy calculations are run at the end of an annual cycle after allocations have been run and transactions have been posted in the system. Transactions must be up-to-date as of the determination date for the applicable testing year. Note that one of the parameters that you need to set under 'Top Heavy for Next Year' is whether to use all transactions or just ending balances. Generally the software calculates ending balances from the other transactions - beginning balances, plus contributions and other gains, minus distributions, fees etc. So unless you actually have a batch of ending balances posted in the Transaction menu you need to select 'All transactions other than ending balance' from the 'Transactions to use when calculating Participant balances:' drop-down box.

If the employer has multiple plans the Top Heavy test must be run on an aggregated basis. This can be accomplished by entering an aggregation code, which is the same for all plans of the employer. The indication that aggregation is used and aggregation IDs are found on the ADP/ACP Test Parameters screen (the ID code is one you may make up and must be the same for all aggregation group members). If for some reason account information is not available for other plans (e.g. the plans are not on the ftwilliam.com admin system) you can manually enter ending balances for the other plans (Under the "Set Top Heavy Test Parameters" menu, there are fields to enter Key and Non-Key Balances for other plan).

If you click on "Set Top Heavy Test Parameters" from the Plan Administration Menu page, you will be taken to the "TopHeavy Menu" screen.

To override the system calculation of the Top Heavy ratio, set the override at the top of the "Set Top Heavy Test Parameters" menu to “Yes”. Set the order of Top Heavy allocations and select which Participants will share in Top Heavy minimum allocations. Also, make sure that all Key Employees are identified as such, especially for the first Plan Year the Plan is on ftwilliam.com’s admin system.

For more information and examples, click on the help button for a particular question.

If you click on "Do Top Heavy Test" from the Plan Administration Menu page, the top heavy test will be calculated based on the parameters and the balances in the Transaction Menu. You will be taken to the "Top Heavy Calculation" page where basic top heavy status information will be displayed (shown at right). You can print the test report directly from the "Top Heavy Calculation" page or once you return to the Plan Administration Menu page, click on "Print Reports" to view Top Heavy Calculations.

As is the case for all the default reports on the system, if there is information you would like to see that is not in one of the predefined reports, go to the Other Import/Export/UD Report Menu and review some of the more detailed report grids there or set up your own report under the Work With Data Entry Grids menu. In addition, you can review most standard reports as they are completed within the ‘Do’ task. The Print Reports feature allows you to review the details without redoing the task.

Printing Parameters/Client Package. Top

The software allows you to select a package of reports and statements that you can send to your client; this section of the User Guide describes how to customize this package. You will do this from the three links under 'Printing Parameters/Client Package' in the Select Task box shown at the right. The steps in the process are as follows: Create one or more custom styles to use for all your reports and statements (or you can use one of the default styles). Add a default client letter that will be available for all your clients. Assign a style to each of your reports and statements - you do this plan by plan. Select which reports and statements to include in the client package - again this is done plan by plan. Print the package, plan by plan.

The style of reports and statements can be customized to suit your preferences. To select styles and customize styles, on the Plan Administration Menu you will see the link 'Set Printing Parameters' in the Select Task box.

Set Printing Parameters Top

When you click on 'Set Printing Parameters' you'll be taken to the 'Set Printing Parameters' page, shown on the right. Here you have options to add a default cover letter, select a printing style and orientation for this cover letter and each of your reports. You can also design your own styles and save them as options for future selection and modify the default client letter. To access the screen where you can design your own styles and modify the default cover letter, click on the link: 'Edit/Create Custom Styles - Set Default Client Letter' at the top of the 'Set Printing Parameters' page.

Edit/Create Custom Styles

After clicking on 'Edit/Create Custom Styles - Set Default Client Letter' at the top of the 'Set Printing Parameters' page, you will be taken to the 'Edit/Create Custom Styles' page shown at right. The first box on the 'Edit/Create Custom Styles' screen is where you can edit/design one or more custom styles for your client letter and reports. The style options include using one of the default styles already set up, or adding your own custom style. You'll see the following options in the drop-down box on this screen: Default Cover Letter Style Default Plain Default Intermediate Default Elaborate To create your own custom client letter style, select 'Default Cover Letter Style' in the drop-down box on the 'Edit/Create Custom Style' screen shown to the right and click 'Copy This Style'.

Custom Cover Letter Styles. You will see the 'Edit Print Styles' screen shown to the lower right. You should edit the description field to indicate who owns it (e.g. call it 'John's Cover Letter'), then you can change the font type, margins and font size to reflect your own preferences. After you click 'Return' this new style will be available to select for all your client letters. Please note that you cannot edit a default style; you need to copy it and then you can edit the copy.

Custom Report Styles. You can also set a default style for your reports and statements from the same screen as the default letter style (the 'Edit/Create Custom Styles' page). There are three default styles set up already - 'Default Plain', 'Default Intermediate' and 'Default Elaborate'. Again these are not editable but you can either use one of them as is, or you can copy and edit one or more of them to create your own custom styles. To do this, select one of the three default styles from the drop-down box and select 'Copy This Style'. You can change the description to reflect who created it and what style it was copied from. You can also select the font type, color and size for the different sections of the reports as well as margin width. To the right is the top of the screen that you'll see when you select a style and elect to copy (or, if it has already been copied, edit it):

Custom Report Styles - Statement Options. As well as selecting a print style for your statements as described above, you can include plan specific messages on the statements and also display the investment related notice required by the 2006 Pension Protection Act (PPA) for certain plans. Plans are required to provide the statement (copied below) if the plan is an individual account plan (other than a one-participant plan) and allows participants/beneficiaries to direct the investment of assets in his or her account under the plan. See the screen shot to the right - this is the statement section of the 'Edit Print Styles' screen and is available for both statement formats, the Individual Participant Statement and the Custom Participant Statement. There's more information about the difference between the two formats below.

The text you enter in the 'Message 1' box shown above will be printed at the top right of the first page of the statement. Please note that the 'Message 2' box is only available for the Custom Participant Statement (hence the note about limited availability) and prints in the section 'Your Account at a Glance'.

You can select whether or not to add the PPA investment language from the drop-down box. If you opt to include it, the text that will be printed on the statements is as follows:

"To help achieve long-term retirement security, you should give careful consideration to the benefits of a well-balanced and diversified investment portfolio. Spreading your assets among different types of investments can help you achieve a favorable rate of return, while minimizing your overall risk of losing money. This is because market or other economic conditions that cause one category of assets, or one particular security, to perform very well often cause another asset category, or another particular security, to perform poorly. If you invest more than 20% of your retirement savings in any one company or industry, your savings may not be properly diversified. Although diversification is not a guarantee against loss, it is an effective strategy to help you manage investment risk.

In deciding how to invest your retirement savings, you should take into account all of your assets, including any retirement savings outside of the Plan. No single approach is right for everyone because, among other factors, individuals have different financial goals, different time horizons for meeting their goals, and different tolerances for risk.

It is also important to periodically review your investment portfolio, your investment objectives, and the investment options under the Plan to help ensure that your retirement savings will meet your retirement goals.

Department of Labor information. For more information regarding individual investing and diversification, see the internet website of the U.S. Department of Labor at: www.dol.gov/ebsa/investing.html"

There is also an option to add your own custom PPA related message, which will appear above the standard PPA language on the statement. You enter this in the 'Custom PPA Information' box.

Set Default Client Letter

When you click on the 'Edit/Create Custom Styles - Set Default Client Letter' link on the 'Select Printing Parameters' screen, you can add the text for a default global letter that will be available for use with all your clients. Type or paste the text for the letter in the lower block of the 'Edit/Create Custom Style' screen, then click 'Update'. This letter can be the default for all of your clients so you will just need to customize it for the particular client and package you are sending.

Having designed custom styles for your letters and reports, you are now ready to select a style or styles to use and their orientation. The custom styles you created will show as options in the drop-down box when you return to the 'Select Printing Parameters' screen. On this screen you can select a print style for your client letter, and for each of your reports and statements. You can either select one style for all reports and statements or you can select the styles individually for each report and each statement type. See the screen shot to the right - the box in the middle allows you to select a single style for all reports and statements whereas the box below is where you make the individual selections for reports. A further option is the orientation for the report - whether you prefer Portrait or Landscape

See the screen shot to the right - this is the statement section of the 'Edit Print Styles' screen and is available for both statement formats. If you opt to make individual style selections for statements, you do this directly below where you select report styles.

Select Reports Top

When you have made your style selections, you can return to the main Plan Administration Menu screen, click on the 'Select Reports' link to choose what to include in the client package. The first box on the left 'Edit Client Letter' is used for the cover letter that is included with the client package. You will see a link: 'Update Default Letter' at the top of this box; clicking this link will populate the box with the text entered for the global client letter on the Edit/Create Custom Styles screen. You can now customize the letter for this particular client. The first box on the right, 'Prepared By' will feed to the cover page for the client package. You can add or modify your firm name in this box to determine how the name is displayed on the cover page, which appears after the cover letter and before the table of contents in the package. Note that first entry that you make to this box will populate globally, across all plans. Any changes you make subsequently will only be made on a plan by plan basis. Next you can indicate which reports and statements you want to include in the client package by adding a number in the box on the right for each report you want to include; the number indicates the order that you want the reports to appear in the package. The cover letter will always be first followed by a Table of Contents. If you want the Eligibility Report to appear first, enter '01' next to it. Enter '11' next to the report you wish to appear second and so on. These numbers do not have to be consecutive; the software just looks at the value and orders the reports based on the relative value. Using numbers that are a few units apart allows you to more flexibility to change the order of the reports, or add additional reports to the package at a later date. Please note that there are two alternate formats for participant statements. One is the Individual Participant Statement, a one page per participant summary of activity, and the second is the Custom Participant Statement which is typically is a two page statement and includes the following: An additional section showing a 'Your account at a glance'. A second custom message option - all messages are added on the 'Edit Print Styles' screen described above. Separate tables showing the breakdown of assets by investment and by source. Available in portrait format only.

Print Package. Top

To print your reports package, after you have indicated which reports and statements to include, return to the main Plan Administration menu and click the 'Print Client Package' link. This will generate a document in Microsoft Word© containing all the reports and statements that you selected for the package. Note that it is still editable - you can make changes to the formatting if you wish. Once the package is as you want, you can print it, or send electronically to your client.

If you are just printing statements, you can also do this from the 'Transaction/Statement' menu, also accessible from the main Plan Administration Menu screen.

Miscellaneous Tasks. Top

Required Minimum Distributions

Overview

The Required Minimum Distribution (RMD) rules were created to ensure that the payment of benefits is not postponed indefinitely. These distributions are generally required within a certain timeframe once a participant reaches age 70 ½. The distribution amount a participant must take is called the Required Minimum Distribution (RMD). The date the participant must take their first RMD is called the Required Beginning Date (RBD).

For the system to calculate the RBD and RMD correctly, the following data must be in the system (as applicable):

• Participant's vested account balance for the valuation calendar year
• Participant's date of birth
• Participant's ownership data as of the calendar year they attain 70 ½
• Termination date and reason for termination
• Beneficiary's date of birth

Transactions/Statement Menu Top

The value of the participant's vested account balance is determined in the valuation calendar year. To obtain a participant's vested account balance for the valuation calendar year, account balance activity must be posted in the Transaction Menu for that year. Additionally, statements need to be run in order for the system to be able to pick up the balances. Please note: if the valuation calendar year is a conversion year with the only activity on the system being an ending balance batch, the system will not recognize those balances for RMD purposes. In this instance the account balance will need to be overridden and manually entered. Please refer to the RMD override section for additional instructions.

Do Data Scrub/Elig Calc Top

The following census data must be uploaded or keyed into the system in the distribution calendar year: participant date of birth, beneficiary's date of birth, participant's ownership, termination date and reason for termination (as applicable). The data scrub must then be run before the RMD Menu will become available.

RMD Menu Top

To access the Required Minimum Distribution Screen where you can calculate the RBD and RMD, click on "RMD Menu".

Calculating the Required Beginning Date

Do RBD Calculation Top

Under the "Do Calculation" options the user has the option to calculate the RBD on a plan level or global level.  The RBD can also be calculated for either the current year or the next year. 

To run the RBD calculation, click "RBD For YYYY" under Do Calculation. In addition to calculating the RBD, the 5% Owner for RMD purposes, Death Date, 70-1/2 Date, 1st Distribution Cal Year and Non 5% Term Date will also be calculated at this time.

When the RBD calculation is run the "Req Beg Date Error List" screen will open. This screen lists every participant with an error for RBD purposes.  For example, if a participant's beneficiary's birth date is missing, an error message will appear on this screen to alert the user of invalid data.

Print RBD Report Top

After running the RBD calculation, click "RBD For YYYY" under Print Report. This opens the Required Beginning Date Report in which all participants who have attained age 70 ½ are listed. Users also have the option to open this report in excel format by clicking 'csv' next to the report.

RBD calculation for a 5% Owner for RMD purposes

The RBD for a participant who is a 5 percent owner for RMD purposes is April 1st of the calendar year following the year that the participant attains age 70 ½.

RBD calculation for a non-5% Owner for RMD purposes

The RBD for a participant who is a non-5% owner for RMD purposes is April 1st of the calendar year following the year that the participant attains age 70 ½ or, if later following the year in which he or she terminates employment.

RBD calculation for a deceased participant

The RBD for a participant who dies before attaining age 70 ½ will be calculated as December 31st in the calendar year following the year in which the participant died.

The RBD will already have been calculated by the system for 5 Percent Owners who die on or after attaining age 70 ½ and for non-5 Percent Owners who die on or after attaining age 70 ½ and have terminated employment.  

RBD Overrides Top

The Edit Participant Master File Data" link appears when the RBD calculation is run. Clicking on this link opens a screen where the RBD and the data on the screen below can be edited for a given participant.   

Override Calculation of Required Beginning Date

The "Override Calculation of Required Beginning Date" should be set to 'Yes' if the user wishes to bypass the recalculation of:

• The Date the Participant attained age 70-1/2
• Date of death
• RMD first distribution calendar year, or
• RMD required beginning date for the year  

Link to FAQ

Date the Participant attained age 70-1/2

The "Date the Participant attained age 70-1/2" field equals the date the participant reached age 70 ½ in MM/DD/YYYY format.  It is based on the participant's date of birth in the system and is calculated when the RBD calculation is run. To override the system calculation of this value in the year the participant attains 70 ½, enter a valid date (MM/DD/YYYY) and set "Override Calculation of RMD" to 'Yes'. To override the system calculation of this value in any other year, simply enter a valid date (MM/DD/YYYY).

Enter the employee's date of death

The date of death field will populate (in MM/DD/YYYY format) if a valid termination date is in the system with the reason of termination due to death. The date of death is calculated when the RBD calculation is run if it is not already populated with a value. To delete this date entirely the user must set "Override Calculation of RBD" to yes.

Participant was a 5% owner in the plan year ending in the calendar year in which the Participant attained age 70-1/2 

The system will calculate whether or not a participant was a 5% owner for RMD purposes if the value of 5% Owner for RMD purposes equals "unknown" and the participant has attained age 70 ½.  If census data is not in the system for the year the participant has attained age 70 ½, the 5% Owner for RMD purposes field will be set to no.  

If not a 5% owner for purposes of RMDs, Termination date of Participant after the Participant attained age 70-1/2

If a participant is marked as a non-5% owner for RMD purposes and has a valid termination date, this field will populate with that termination date when the RBD calculation is run.

Birth Date of Designated Beneficiary

The designated beneficiary's date of birth is used to calculate the factor when the Single Life Table is selected and also used with the participant's date of birth to determine the factor when Joint and Survivor Life Table is selected.  The user will enter the date of birth using the census grid or directly in the participant master file. To override this field simply enter a new date of birth in MM/DD/YYYY format.

Life expectancy table to use

Life expectancy tables determine what factor will be used to calculate the RMD.  The Single Life Table, Uniform Lifetime Table, or Joint and Last Survivor Table will be populated by the system when the RBD calculation is run.  This selection is based on individual circumstances of the participant. To override this field use the drop-down box to select a different lifetime table to use.

Enter the RMD first distribution calendar year

RMD first distribution calendar year field equals the calendar year in which the participant reached age 70 ½.  The value is calculated when the RBD calculation is run. To change the system calculation of this value the user may enter a valid four digit year (YYYY).  Link to FAQ

Enter the RMD required beginning date

This field equals the date the participant must take their first RMD. The value is calculated when the RBD calculation is run. To change the system calculation of this value, simply enter a valid date (MM/DD/YYYY). Link to FAQ

Calculating the Required Minimum Distribution

Do RMD Calculation

Under the "Do Calculation" options the user has the option to calculate the RMD on a plan level or global level.  The RMD can also be calculated for either the current year or the next year. 

To run the RMD calculation, click "RMD For YYYY" under Do Calculation. In addition to calculating the participant's RMD, the RMD factor, total account balance and vested account balance will also be determined at this time.

When the RMD calculation is run the "Req Minimum Distribution Error List" screen will open. This screen lists every participant with an error for RMD purposes. 

Print RMD Report

After running the RMD calculation, click "RMD For YYYY" under Print Report. This opens the Required Minimum Distribution Report in which all participants who the system evaluates should receive a RMD is listed. Users also have the option to open this report in excel format by clicking 'csv' next to the report.

How the RMD is calculated if the participant is alive:

The RMD is equal to the vested account balance as of the last valuation date in the valuation year divided by the RMD factor. The factor is determined by the age of the participant as of the distribution year. The default life expectancy table used to obtain the RMD factor will be the uniform table.

Note: If the spouse is the sole beneficiary and is greater than ten years younger than the participant, the regulations state that the Joint and Last Survivor Table must be used to obtain the RMD factor.  In this situation, the user must override and change the table to the Joint and Last Survivor Table.

Note: The RMD will calculate even if the Required Begin Date setting in the document is 'Election of later of age 70-1/2 or retirement'.

How the RMD is calculated if the participant is deceased:

The RMD is equal to the vested account balance as of the last valuation date in the valuation year divided the RMD factor.

In general, if death occurs before the RBD, the benefit should be distributed over the life expectancy of the designated beneficiary as outlined in IRC §401(a)(9). In this instance, the user only needs to verify that the Life Expectancy Table is set to Single Life Table. Once the Life Expectancy Table is verified and the RMD is run (or re-run), the system will determine the factor using the designated beneficiary's date of birth.

Note: If death occurs before the RBD and there is no designated beneficiary, the 5-year method should be used.  The 5 year method requires that the entire vested balance must be distributed in full by the end of the calendar year that contains the 5th anniversary of the participant's death. In this case, the factor must be manually entered.  For example, if the balance must be distributed in three years (two payments have already been made), the user should enter "3" for the factor so the RMD is correctly calculated.

If death occurs on or after the RBD, the user must determine the correct factor that should be used, using the Single Life Table as outlined in IRC §401(a)(9)-5.  In the system, the user must set the override calculation of Participant RMD Factor to 'Yes' and enter the user determined factor in the "Factor used to calculate Participant RMD" field. When the RMD calculation is run, the RMD will be calculated based on the manually entered factor.

RMD Overrides

To edit a participant's balance data or the RMD factor, click on "Edit YYYY Data".  The YYYY is the distribution calendar year for the RMD.

Override calculation of Participant account balance

If "Override Calculation of Participant account balance" is set to 'Yes', the system will calculate the RMD based on the balance data manually entered in this screen. If set to 'No', when the RMD calculation is run, the account balance data will repopulate based on the data in the system.

Participant total balance for purposes of calculating RMD

This field equals the participant's ending balance in the valuation calendar year. To override, set "Override Calculation of Participant account balance" to 'Yes' and enter the new total account balance.

Participant vested balance for purposes of calculating RMD

This field equals the participant's ending vested balance in the valuation calendar year. To override, set "Override Calculation of Participant account balance" to 'Yes' and enter the new vested account balance.

Override calculation of Participant RMD Factor

If "Override Calculation of Participant RMD Factor" is set to 'Yes', the system will calculate the RMD based on the factor manually entered in this screen. If set to 'No', when the RMD calculation is run, the factor will repopulate based on the data in the system.

Factor used to calculate Participant RMD

This field equals the factor that will be used to calculate the RMD.  To override the system calculated factor, set "Override calculation of Participant RMD Factor" to 'Yes' and enter the new factor you wish to use.

RMD Definitions

Valuation Calendar Year:

The valuation calendar year is the calendar year prior to the distribution calendar year.

Distribution Calendar Year:

The distribution calendar year is the calendar year in which an RMD is due.

5% Owner for RMD purposes:

A participant will be considered a 5% owner for RMD purposes if they have an ownership percentage greater than 5% in the calendar year that they turned 70 ½.

Note: If the RBD calculation is run for a future year the 5% owner calculation will be determined based on current plan year data.  Once this field is calculated, the user must override if ownership changes prior to the year a participant attains 70 ½.

Non- 5% Owner for RMD purposes:

A participant will be considered a Non-5% owner for RMD purposes if their ownership percentage is not greater than 5% in the calendar year that they turned 70 ½.

Note: If the RBD calculation is run for a future year the 5% owner calculation will be determined based on current plan year data.  Once this field is calculated, the user must override if ownership changes prior to the year a participant attains 70 ½.

Single Life Expectancy Table:

If the participant is deceased, the system will default to the Single Life Table. The system uses the designated beneficiary's date of birth to calculate the life expectancy factor.  Note: If a participant dies after this has already been populated with Uniform Life Table, the user must override to change the Life Expectancy Table to Single Life Table. Link

Uniform Life Expectancy Table:

If the participant is alive the system will default to the Uniform Lifetime Table. The system uses the participant's date of birth to calculate the life expectancy factor.  Link

Joint and Last Survivor Life Expectancy Table:

If a participant's spouse is the sole beneficiary and the spouse is ten years younger than the participant, the Joint and Last Survivor Table must be used to determine the factor that will be used in the RMD calculation. The user must manually change the Life Expectancy Table option to Joint and Last Survivor Table in this instance. The system uses both the participant's and the designated beneficiary's date of birth to calculate the life expectancy factor.   Link

Death Date:

To determine if a participant is deceased the system will look to see if a valid "death date" is entered.  If no death date is found, the system will check the service history for a termination date due to death. If a valid death date is found or there is a termination date due to death in the service history, the system will assume the participant is dead.

RMD FAQ's Top

How does the system determine if a participant is a 5% Owner for RMD purposes?

To determine if a participant is a 5% owner, the system first finds a year end that is less than or equal to the calendar year end in which the participant turned 70 ½.  The system then looks to see if the participant was a 5% owner in that plan year.  The system performs this calculation if the 5% Owner for RMD purposes variable is equal to "Unknown" and if the participant turns 70 ½ in the calendar year.  Please note that if no census data is found for that person for the year end, 5% Owner for RMD purposes will be set to "No".

When will the system calculate the RBD for a participant?

The system calculates the RBD if the participant has a valid date of birth, the RMD first distribution calendar year field is blank, the Required Beginning Date field is blank, and if the participant is a 5% owner and turns 70 ½ in the calendar year or if a non-5% owner attains 70 ½ and terminates employment or if the participant dies.

I've overridden the RBD, how do I make the system recalculate it?

First make sure that the "Override Calculation of Required Beginning Date" is set to 'No'. Then delete the RBD and 1st Distribution Calendar Year fields in "Edit Participant Master File Data" screen. Finally, re-run the RBD calculation.

How does the system determine if a participant is 70 ½?

The system looks to calculate the date the participant attained age 70 ½ if there is not a valid date in the system already. If there is no valid date in the system, the system will look at the participant's date of birth to determine if the participant has reached age 70 ½. If they have, the date the participant attained age 70 ½ is recorded.

What are the rules of IRC §401(a)(9)-5?

If the participant dies on or after the RBD, the RMD amount for that year is calculated as if the participant was still alive. In subsequent years the factor is determined as follows:

If the sole beneficiary is the participant's spouse, the factor should be determined using the longer of either:

• The spouse's life expectancy determined each year using the surviving spouse's birthday as of the distribution calendar year, or
• The participant's life expectancy at time of death, reduced by one for each calendar year that has elapsed after the calendar year of the participant's death.

If the sole beneficiary is not the participant's spouse, the factor should be determined by using the longer of either:

• The designated beneficiary's life expectancy in the year following the participant's death reduced by one each following year, or
• The participant's life expectancy at time of death, reduced by one for each calendar year that has elapsed after the calendar year of the participant's death.

If the participant has more than one designated beneficiary the rules above that reference non-spousal beneficiary's apply except, the designated beneficiary with the shortest life expectancy will be the designated beneficiary for purposes of determining the factor.

Vesting Export Report Top

There are four vesting report options. The links for these reports are located under Miscellaneous Tasks and will become available only after the data scrub has been run. Note: These reports will only populate with data after sources have been set up in Plan Specifications à General Features/Sources and Inv Accounts.

The ‘Vesting Export’ report contains data for a single plan that is used to help calculate a participant’s vested account balance. Next to ‘Vesting Export’ is a link for ‘All Plans’. The ‘All Plans’ link will print all of the data in the ‘Vesting Export’ report for all plans. FTW Company Number, FTW Plan Number and Customer ID columns were added to the ‘All Plans’ reports to help users identify and sort companies and plans more easily.

• Participant Name, SSN and Birth Date: This data will populate from the uploaded census grid.
• Yrs Service: This column shows the total number of years (current plus prior years) of vesting service attained.
• Participation Start: Populates with the earliest date of participation from the participant master record if normal retirement age includes a service requirement. The system will not calculate earliest participation date for those who have not attained the age component of NRA
• NRA: This populates with “Yes” if the participant has attained normal retirement age and “No” if they have not.
• NRA Date: If a participant has attained normal retirement age, this column will populate with the date they attained it. If a participant has not yet reached normal retirement age this column will show “N/A”.
• FTW Source: These are the sources that are setup/available as selected in General Features/Sources and Inv Accounts.
• External Source: If you upload transaction data from an external source, the sources must be mapped from the external source to the FTW sources. This will have been done in the Transactions/Statements menu. This column shows which external sources were mapped to each FTW source.
• Vesting Override: This will populate with “Yes” only if the vesting percentage was overridden in the vesting override screen.
• Prior Distribution: Include distributions in years ending before the plan year begins. This includes distributions, in-service, loan default, ADP/ACP corrections (that are coded as such in the Transactions/Statements menu as such).

The ‘Vesting Detail Export’ report is very similar to the ‘Vesting Export’ report. It includes all of the same columns for a single plan, but also adds two historical columns.

• Hire/Term History: The first row for each participant will display the hire date and any termination dates applicable to the participant.
• Service History: The first row for each participant will display service hours earned for each year. If no historical data was entered for years prior to the first plan year on the system, the system will show ‘9999’ hours earned to denote 1 year of service, then will show the number of prior years of service earned. For example, “2011-12-31 =>9999/6; 2012-12-31=>2080” means that a participant earned 6 prior years of service plus one year of service for 2012, for a total of 7 years of service as of 2012.

The ‘All Plans’ option prints the same data as the ‘Vesting Detail Export’ for all plans. Additionally, FTW Company Number, FTW Plan Number and Customer ID columns were added to the ‘All Plans’ reports to help users identify and sort companies and plans more easily.

8955-SSA Export Menu Top

The 8955-SSA Export Menu enables users to calculate data pertinent to the Form 8955-SSA and export that data directly from the Plan Administration Menu to the 5500 System.

The system uses the following data to determine who should be on the SSA (as applicable):

• Participant’s termination date
• Participant’s vested account balance (statements must be run for the account balance to be recognized)
• Participant forfeitures/distributions (from the Transaction/Statement Menu)

Click 8955-SSA Export Menu from the Plan Administration Menu under Miscellaneous Tasks. Here you will have the option to create SSA transfer records, view/edit SSA transfer records and transfer the SSA data.

Create SSA Transfer Records Top

Select Plan Month/Year End

The Plan Month/Year End that the user selects determines the Form 8955-SSA that the data will be exported to. The participant account balance information is also taken from the same year from the administration software.

Select Termination Year

If “Current Year” is selected, the Entry Codes for Page 2, Part III, column (a) will be determined as follows:

• Code A: Participants with a vested balance that terminated in the current year in which the Form 8955-SSA is being filed.
• Code D: Participants that terminated in any prior year and distributed/forfeited entire balance in current year.
• None: Participants whose entire balance has been forfeited/distributed in the current year and who were rehired during the current year. These participants will not be exported to the Form 8955-SSA.

If “Prior Year” is selected, the Entry Code for Page 2, Part III, column (a) will be determined as follows:

• Code A: Participants with a vested balance that terminated in the year prior to the year in which the Form 8955-SSA is being filed.
• Code D: Participants that terminated two years or more prior to the year in which the Form 8955-SSA is being filed and distributed/forfeited entire balance in the current year.
• None: Participants whose entire balance has been forfeited/distributed in the current or prior year and who were rehired in the current year. These participants will not be exported to the Form 8955-SSA.

*If prior year was a conversion year all results must be reviewed with care.

Calculate for This Plan/Calculate for All Plans

With the click of a button, this menu option will first calculate transfer records based on service history and transactions posted in the system. Then the system will print the results and create transfer records with the following information either for a single plan or for all plans as selected by user:

• Entry Code
• Annuity Type – System will default the annuity type to code A. Will only transfer if the entry code is set to A or B.
• Payment Frequency– System will default the annuity frequency to code A. Will only transfer if the entry code is set to A or B.
• Participant Name
• Social Security Number
• Termination Date
• Termination Reason
• Ending balance
• Vested balance - Will only transfer if the entry code is set to A or B.
• Status - Status messages will be shown here (e.g. no statements, rehire date, or OK)

Please Note: Any existing SSA transfer records for the plan or for all plans (as selected by user) will be overwritten when new transfer records are created.

Review/Edit SSA Transfer Records

Select Plan Month/Year End

Select a plan month/year end for the 8955-SSA data you wish to review/edit.

Select type of report

If the csv file option is selected, the system prints all SSA Transfer records to a csv (excel) file, either for a single plan or for all plans as selected by user.

If the web page option is selected, the system prints all SSA Transfer records, either for a single plan or for all plans as selected by user to a web page for the user to review.  This option also permits the user to edit all data in the SSA Transfer records for that participant by clicking the link available in each record. When editing data, please be sure to click the update button in the edit screen to save your changes then press the refresh button in the 8955-SSA list to view changes.

Transfer SSA Data to 5500 System Top

Select Plan Month/Year End

Select a plan month/year end for the 8955-SSA data you wish to transfer.

Select mode of transfer

Choosing create csv will print the results to a csv (excel) file. This file can then be uploaded into the system. Please refer to the 8955-SSA instructions for additional information for uploading this data.

Choosing Automatic Push transfers all calculated SSA data to the 5500 system with the push of a button, either by plan or for All Plans* as selected by user. If there is existing data already in the form all plan level data will remain intact and all participant data will be replaced. If there is no prior Form 8955-SSA, the system will create one.

Warning: If you have completed 8955-SSA’s already you may not want to Transfer SSA Data for All Plans* as this will overwrite all SSA’s previously completed!

*Automatic Push will not available for All Plans option until the 2012 filing season.

1099-R Export Menu

The 1099-R Export Menu enables users to calculate data pertinent to the Form 1099-R and export that data directly from the Plan Administration Menu to the 1099 System!

The system uses the following data to determine who and what data should be transferred to the 1099-R (as applicable):

• Participant distributions (in Transaction Menu
• Participant’s date of birth
• Participant’s address

From the Plan Administration Menu under Miscellaneous Tasks, click 1099-R Export Menu. Here you will have the option to create 1099-R transfer records, view/edit 1099-R transfer records and transfer the 1099-R data.

Create 1099-R Transfer Records Top

The Calendar Year End that the user selects determines the Form 1099-R that the data will be exported to. The participant distribution information is also taken from the chosen year.

This menu option will first calculate transfer records based on distribution transactions posted in the system. Then the system will print the results and create transfer records with applicable data to populate the fields in the 1099-R.

Please Note: Any existing 1099-R transfer records for the plan or globally (as selected by user) will be overwritten when new transfer records are created.

The distribution codes and withholding percentages are determined by the system as follows:

*If the distribution is taken in the year the participant attains age 59 ½, user must review the code selection and edit as applicable.

* Withholding amount is based on distribution amount and withholding percentage. Withholding percentage is based on distribution type as shown above.

Review/Edit 1099-R Transfer Records Top

This menu option prints all 1099-R Transfer records, either by plan or for all plans as selected by user.  

Select a calendar year end for the 1099-R data you wish to review/edit.

If web page is selected the system will direct the user to the results page online.  The page will contain all a list of all participants with 1099-R records for the calendar year selected. There is a link for each participant’s record. Clicking on a link permits the user to edit data in the 1099-R Transfer records for that participant.

If csv file is selected the system will print the results to a csv (excel) file for the user to review.

Transfer 1099-R Data to 1099 System Top

Select a calendar year end for the 1099-R data you wish to transfer.

Choosing ‘Create CSV’ will print the results to a csv (excel) file. This file can then be uploaded into the system.

Choosing ‘Automatic Push’ transfers all calculated 1099-R data to the 1099 system, either by plan or for all plans as selected by user. If there is existing data already in the form all data will be replaced. If there is no prior 1099-R, the system will create one.

**Warning: If you have completed any 1099-R’s you may not want to Transfer 1099-R Data for all plans as this will overwrite all 1099-R’s previously completed!

5500 Data Report.Top

Clicking this link will provide information for the participant count fields for the plan's Form 5500/5500-SF/5500-EZ. When you click the link you will see a list of all the participants in the plan with indicators as to whether they are eligible, active, have a balance etc. The block below provides the actual numbers. If you are comfortable with the data you can use it t populate the appropriate fields on the 5500. When you open Form 5500/5500-SF or EZ on ftwilliam.com you will see a link 'Populate Line 5 & 6 from Admin' (or just Line 5 for 5500 SF or EZ. Clicking this link will populate the fields.

Global Participant Search

The Global Participant Search enables a user to search for a participant across all companies and plans within a user’s company code. Then, with the click of a button the user can be directed to the plan in which the participant belongs. In order to access this feature, click on Global Participant Search from the Plan Administration Menu. 

Inside Global Participant Search, the user has three search options: last name, social security number or employee number. If searching by social security number or employee number the participant(s) who exactly match the number entered will be listed in a drop-down box.  That is, no partial searches are done for those two options.  If you search by last name, however, you can type in the entire last name or just part of and the search results will contain all participants matching your entry.

Once you have entered your search criteria and pressed the search button, all participants matching that criteria will be listed in the “Results’ drop-down box. Click on the drop-down box to review the list of participants. The plan that each participant is associated with is shown in parenthesis next to the participant name. To go to that plan, select the participant and click ‘Go to Plan’.

Note: If divisions are used and a participant is located in a plan the user does not have accessibility rights to, the user will be able to see that a participant is in that plan but will not be able to access the plan.

Summary of Test Results Top

The Summary of Test Results report gives an overview of the results of compliance tests run. It will also let the user know if a test had not been run.

Limits test

The limits test includes:

• IRC §415 test - Tests to make sure no participant exceeds the annual additions limit for the applicable plan year.
• IRC §402(g) test - Tests to make sure no participant exceeds individual deferral contribution limit set for the applicable plan year.
• Plan limit test - Tests to make sure no participant exceeds plan limits set by the plan document (as applicable).

Each test will show either, “Not run”, “PASS” or “FAIL”. If any of the tests fail, the overall result will be FAIL.

410(b) Ratio Percentage Test

The 410(b) Ratio Percentage Test includes a separate coverage test for:

• Elective Deferrals
• Match
• Non-Elective

Each test will show either, “Not run”, “PASS” or “FAIL”. If any of the tests fail, the overall result will be FAIL.

Deduction Limit

The Deduction Limit tests to total employer contributions against total eligible compensation to verify that the deduction limit for the plan has not been exceeded.

Each test will show either, “Not run”, “PASS” or “FAIL”.

Compensation Testing

The Compensation Test includes a separate test for:

• Match
• Non-Elective

The tests compare the applicable HCE compensation ratio with the applicable NHCE compensation ratio to verify that the difference is not greater than the de minimis amount entered.

Each test will show either, “Not run”, “PASS” or “FAIL”. If either of the tests fails the overall result will be FAIL.

ADP Test

The ADP test will either show “PASS” or “FAIL”. If the plan is a safe harbor plan, the ADP test will not appear in this report. If the ADP test shows a “PASS” result, then the ‘Refunds due’ and ‘Estimated QNEC’ will show as “N/A”. If the ADP test shows a “FAIL” result, the ‘Refunds due’ will show a dollar amount of total refunds due to be distributed. If the ADP test fails and the plan specifications permit a QNEC as a correction method, the ‘Estimated QNEC’ will show a dollar amount equal to the total amount estimated to provide a passing result.

ACP Test

The ACP test will either show “PASS” or “FAIL”. If the ACP test shows a “PASS” result, then the ‘Refunds due’ and ‘Estimated QNEC’ will show as “N/A”. If the ACP test shows a “FAIL” result, the ‘Refunds due’ will show a dollar amount of total refunds due to be distributed. If the ACP test fails and the plan specifications permit a QNEC as a correction method, the ‘Estimated QNEC’ will show a dollar amount equal to the total amount estimated to provide a passing result.

Associated Match Forfeitures

If the ADP test fails and refunds result in associated match forfeitures, the total amount of associated match forfeitures will appear here. If no associated match forfeitures are required this row will show “N/A”.

General Test

The General Test shows a separate test for:

• Rate Group Test (at 70%) – Note: if the Rate Group Test passes at midpoint, this line will not appear on the report.
• Rate Group Test (at midpoint)
• Gateway Test
• General Test - Average Benefits Test - Note this line will appear if Rate Group Test (at 70%) fails.

Each test will show either, “Not run”, “PASS” or “FAIL”.

Top Heavy Test

The top heavy test will show either “Not run”, “PASS” or “FAIL”. The Top Heavy Percentage will show the key employee asset percentage in comparison to the total assets in the plan as outlined in the IRC for either a “PASS” or “FAIL” result. If the top heavy test was not run the Top Heavy Percentage will show “???”.

Plan Highlights Report

Workflow Grid.

This is a global grid, listing each plan under a customer's account to which a year end has been added in the Administration software and showing whether or not each task has been run. Most entries in the grid are automatically updated by the software when the task in question is performed. A screenshot of the grid is shown below. Note that you can sort any column by clicking on the column name; you can also export the grid to Microsoft Excel via the 'Download Spreadsheet' link.

The grid includes the following columns:

• Plan Name.
• Year End.
• Census Prep - whether the census has been prepared and posted to the portal (for portal customers only).
• Census Send - whether the census has been sent to the client via the portal (for portal customers only).
• Census Rec - whether the census has been uploaded.
• Scrub - whether the data scrub has been run.
• Alloc - whether the allocation has been run.
• ADP/ACP - whether the ADP/ACP tests have been run.
• Comb - whether the Combined Test has been run.
• Gen Test - whether the General Test has been run.
• Top Hvy - whether the Top Heavy Test has been run.
• C Pack - whether the Client Package has been prepared.
• Resp - for customer use to indicate whether responsible for the plan.
• Admin - for customer use to assign an Admin to the plan. All system users with Admin access will be available to select from the drop-down box.

Transactions/Statements. Top

When you first open the Transaction Menu page, you will see three boxes as follows:

• Select Batch - this is where transaction batches are displayed, either as pending or posted batches.
• Statement/Bal Frwd Earnings Period - this is where you select options for your statements and financial reports and print them.
• Create/Compare batch - this is where you add batches; you will likely begin here.

Create/Compare Batch.

There are several ways to add transaction batches to the Select Batch box:

• Uploading a file from the asset custodian.
• Creating batches from allocations you have previously run.
• Adding a manual batch.
• Using the loan module and adding loan distributions or repayments - please see the Loan Module for information.

We will address each of these below.

Uploading Transaction Files from an Asset Custodian Top

ftwilliam.com offers the option of importing financial data from an asset custodian or vendor. You would download a transaction file from the vendor's TPA website, and then upload the file on the ftwilliam site. Uploads from the following vendors are available:

Vendor	File Type
American Funds	.csv
Ascensus	.txt
AUL One America	.csv
Eplan	.csv
Expert Plans	.csv
Great West	.pas
Great West V2	.pas2
Guardian	.txt
Hartford	.csv
Hartford-MFS	.csv
ING	.fi1
ING-Omni	.fi1
Interactive Ret. Sys	.csv
John Hancock	.txt
Lincoln	.csv
Lincoln V2	.csv
Nationwide	.txt
Principal	.csv
Securian	.txt
Transamerica	.csv
Generic	.csv
SRT	.csv

The generic upload format is available for uploads from vendors that we do not have a custom tool for; you would need to reformat the data into a specific layout to upload it. You can request a sample layout from ftwilliam.com - it's an Excel spreadsheet.

Uploading Transactions from the Asset Custodian for a Single Plan Top

The steps for set up and uploading files are as follows:

1. From the main Plan Administration Menu page select 'Plan Specifications', then select 'General Features/Sources and Inv Accounts'. Scroll down to the Accounts/Sources box and select the Financial data import vendor from the drop-down box. Enter the plan's vendor account number (usually their contract number) into the Financial data import ID code box. You will also need to click on the 'Work with Sources' link to review the sources allowed by the document.

   See the screen shot on the right.

    

2. Go to the vendor's TPA website, log in and download a transaction file for the period you need. The format of the file you need differs from vendor to vendor so you need to make sure you get the correct file format - see the different types in the table above.
3. Save the file on your hard drive or server. You should not open it; just save with the appropriate suffix.
4. Return to the main Plan Administration Menu on ftwilliam.com, then select the 'Transaction/Statement Menu'. Scroll to the bottom of the screen and click 'Map "name of vendor" Sources' (the name of the selected vendor will be displayed in this link). You will see a list of all the sources that may be used by this vendor and you need to indicate for each source this plan has, which ftwilliam source they should be mapped to. Once you have completed this, click on 'Update' and then return to the previous screen.
5. Still on the Transaction/Statement Menu click 'Upload "name of vendor" Transaction File'. Browse for the file on your hard drive or server, select it and click 'Submit'.
6. The uploaded transactions will be displayed as batches in the 'Pending' area in the 'Select Batch' box. You can edit or delete any of the batches at this point, or post them. We do suggest that you do not post an 'Ending Balances' batch if that is included; rather you should let the software calculate the ending balances.

Uploading Transactions from Lincoln Financial for Multiple Plans Top

Working with Lincoln Financial, ftwilliam.com has developed a tool to import transactions for multiple plans at one time. Follow the steps below to import from Lincoln:

• Log on to the Lincoln website and enter 'Data Direct'.
• Click on 'Data Download' on the Navigation Bar on the left. Select 'Report Request'.
• Enter your search criteria and click 'Search'. The screen will populate with a list of plans meeting your search criteria.
• Check the 'Select' box for all the plans you want to download transactions for. Scroll to the bottom of the page and click 'Next' to go to the 'Report Request' page.
• On the 'Report Request' page select 'Activity Import File' from the 'Report Type' drop-down box. Enter the date range you want and indicate whether you wish to receive an e-mail notification when the report is available. You should also indicate the 'Result Type' as a 'CSV' file. Click 'Submit'.
• When the report is available, go to the 'Active Downloads' screen to retrieve it. Save the file to your hard drive or server as a .csv file.
• On ftwilliam.com you should complete steps 1 and 4 described above for each plan in the Lincoln download.
• Go to the Transaction/Statement Menu on ftwilliam.com from any of the plans.
• Select 'Batch Upload Lincoln Financial Transaction File', browse for the file and click 'Submit'.

See the screen shot on the right.

• Follow step 6 above under each of the plans included in the batch.
• Note that once the upload is complete, if it contained any transactions for plans that are not set up already, with the appropriate year, on ftwilliam you will receive an error message. If you receive such messages you can make the corrections on ftwilliam, i.e. add the appropriate plan(s) and/or year(s), then do the upload again. Only the batches not previously uploaded will be added in this second round so you will not see duplicate batches.

Creating Batches from Allocations You Have Previously Run. Top

After you have run allocations for a plan year, you will see options to create batch from the different allocation types in the "Create/Compare Batch" box. If you click on "Create XXX Batch from Allocations" (where "XXX" could be 401K, ROTH, etc), you will be provided with an allocation date and will be prompted to enter the contribution date. Each is explained below:

• The Allocation Date will be provided as the last day of the current testing year; this indicates the allocation was made for that plan year even if actually contributed in a later year.
• The Contribution Date is the date that the contributions were actually made to the plan (for top heavy testing purposes). If a profit sharing allocation is not actually made until February of the next plan year, enter that date. If you are entering elective deferral contributions that were all made during and throughout the plan year, you may just enter the last day of the plan year.

Once you click on "Add Batch", the batch will be added to the Select Batch Menu under 'Pending'. There are options will to "Delete, Upload, csv, xml, and Post". In addition, under the Create/Compare Batch menu, you will now have the option "Compare XXX to Allocations". Each will be explained below.

Creating a Manual Batch. Top

To create your own batch, click on "Create New Batch". You will be taken to the "Create Batch" page where you can select the transaction type from a drop-down box. Choices include the following:

• TransferIn: transfers to the plan
• Earn: account earnings
• Fees: fees paid
• UnrealGain: unrealized gains
• LoanDist: loan distributions
• LoanRepay: loan repayments
• Forfeit: forfeitures
• ForfeitAlloc: forfeiture allocations
• TransferOut: transfers out of the plan
• Distribution: distributions
• Inservice: inservice distributions
• LoanDef: Loan default
• ADPACPCorr: ADP/ACP test failure corrections
• InsPrem: insurance premiums
• End Bal: ending balance

After you have selected the type of batch to add, you may want to provide your own description in the box provided and then click on "Add Batch". The Batch you created will now appear as a "Pending" batch in the "Select Batch" box.

You may add transactions to a batch via an upload or by manually entering them for each applicable participant on the batch data entry grid. To upload transactions, from the 'Select Batch' box under 'Pending', click on the 'csv' link to the right of the batch. Open the file and add your transactions to the spreadsheet; save it as a .csv file on your hard drive. Then click the 'Upload' link to the right of the batch, browse for the file and upload it. To add transactions manually for a particular Participant, double click on the batch in the "Select Batch" box. A data entry grid will open and at the bottom of the page you should see options to "Add Transaction" with a drop-down box to select a participant. After selecting the participant and clicking on "Add transaction", you can enter data into the grid for the participant.

Modifying and Posting Batches. Whenever you upload, create or add batches, they appear as a "Pending" batch in the 'Select Batch' box. Whilst pending, batches can be deleted, modified or posted; you do need to move each batch to the 'Posted' area for the transactions to be included in the participant statements and financial reports. To post a batch, from 'Select Batch' box check the small box to the right of the batch and click the 'Post' button. This moves the batch to the Posted Batches area - you can always unpost it later if you find that you need to make a correction etc.

Adding a 'Create Beginning Balance' Batch. If this is the first testing year the plan is on the system, unless it is the first year a plan is in existence, you will want to create a new batch for the beginning balances. Click on "Create New Batch" and select the default transaction type labeled "BegBal". Save the batch and add your transaction amounts by participant and by source as described above.

If it is the second year the plan is on the ftwilliam.com administration system and transactions were completed in the prior year, you will have the option to "Create Beginning Balance from Prior Year Ending Balance" in the "Create/Compare Batch" menu. Simply click on the link and the software will create a batch bring forward on the prior year ending balances - see below. Again the batch will be added as a pending batch and you can modify the beginning balances before posting them.

Adding a 'Create Ending Balance' Batch. Ending balances are normally calculated fields, based on the beginning balance and the financial activity during the period. So you would not normally create an ending balances batch until you have finished all the annual work on the plan and are ready to add a new plan year. Adding the ending balances batch will populate the fixed ending balance fields from which the next year's beginning balances can be brought forward.

Using the 'Compare XXX to Allocations' Feature. Clicking this link will compare the allocations created in the admin system to the transactions (whether posted or unposted). It will show the grand total and "NO ERRORS" if there are no differences between the two files. If there are differences between the two files, it will provide a list of participants with differing balances and the amount in the allocation file and the transaction file for that participant.

Distribution Report Top

The distribution report is located in the Statement/Bal Frwd Earnings Period box in the Transaction/Statement Menu. Before running the distribution report, the data scrub must be run, distributions must be posted and one of the statement options (such as ‘Statements – Individual Participant’) must be run.

The distribution report contains the following fields:

• SSN
• Last Name
• First Name
• Hire Date – First hire date on the system
• Term Date – Last termination date on the system
• Status – Either Active or Term. Based on the status as of the last day of the plan year.
• Source Type:
  • 401K
  • Roth
  • Match
  • QNEC
  • QMAC
  • PS
  • SH NE
  • SH MA
  • Rollover
  • Roth Rollover

• Distribution Amount –The distribution amount will be a sum of all distribution types, listed by source, then total of all sources.
• Remaining Balance – This is the end balance as of the end of the plan year by source, then total of all sources.
• Vesting % - The vesting percentage will be displayed for each source type.
• Remaining Vested Balance – This is the total vested balance by source.
• Distribution Type – Pulls from the different distribution batch types as coded in the system. Note: if the participant is not active on the last day of the plan year, the type will be classified as ‘Distribution’. Otherwise the system will display the last distribution type in the plan year
  • Inservice
  • ADPACPCorr
  • LoanDef
  • Distribution

The distribution report is a great tool to use to determine which terminated participants still have account balances that can be distributed. The report is split by active participants, inactive participants with current year distributions and terminated participants with a remaining balance. This report can be printed either as a .csv or word file.

Loan Module. Top

1. Loan Investment and Source Set Up. Top

   Prior to working in the loan module, you should set-up loan distribution hierarchies for investments and sources. Note that loans are tracked as an investment in the ftwilliam software.

   Loan Investment Account. Select 'Plan Specifications' from the 'Plan Administration Menu' page. Then select 'General Features/Sources and Inv Accounts'. Make sure that 'Use Investment Accounts to track Participant balances' is 'Yes'; if not, select 'Yes' and click 'Refresh'. Next select 'Work with Inv Accounts'; add an investment account for loans typically the AccountID would be 'LOAN' and the Account Name and Account Description would both be 'Loan Fund' though you may certainly use something different. Investment Type would be 'Cash'. Note that if you do not have any other investment listed on this screen you should add one, typically the AccountID would be 'Vendor', 'Brokerage' or 'Pooled' and you can add your own account name and description. Click 'Update to save your changes.

   Next on this same screen click on 'Loan Inv Account Distribution/Hierarchy'. For each investment select 'Yes' or 'No' from the 'Allow Loans' drop-down to indicate whether money in that investment is available for loans. Note that the loan fund should not be available for loans. Make sure that the loan fund is selected in the 'Select Loan Account' drop-down. Click 'Update' to save your changes. Click on the 'Hierarchy' button to establish the loan distribution hierarchy - either pro rata or ordering rule. If you select the latter you will need to enter sequence numbers to indicate how the investments should be ordered when a loan distribution is processed.

    

    

   • Source Set Up for Loans.

     Select 'Work with Sources'; you'll go to the 'Source Setup' page. Click the 'Loan Source Distribution/Hierarchy' at the top; this will open the 'Select Sources Available for Loans' screen. Make sure the sources that loans can be taken from have 'Yes' selected and others have 'No'. Be sure to click 'Update' to save your changes. Click the 'Hierarchy' button to set up the hierarchy for loan distributions by source, again either pro rata or ordering rule. Click 'Update' to save your changes, then return to the Source Setup page.

      

      

     On the 'Source Setup' page, you should click to 'Edit' or 'Add' each source for which loans are allowed; this is located to the far right of each source under 'Account Information'. Here you need to ensure that the loan fund is listed as an available investment for each source that permits loans. Also any other investments permitted to be used for that source should also be listed. Click 'Update' to save your changes, then return to the main Plan Administration Menu page.

2. Adding New Loans and Servicing Loans. Top

   Assuming you have up-to-date account balances in the Transactions Menu, you are ready to work in the loan module. Under the 'Transactions/Statements' box of the 'Plan Administration Menu' page there are options for 'New Loan', 'Service Loan', and 'Loan Report'. Each is explained below.

   

    

   New Loan Select the link 'New Loan' and you will be taken to the 'New Loans' page. Under 'Create a New Loan' you should see a list of participants in the plan. Select the participant from the list and click 'Create New Loan'. Clicking ‘Create a new loan’ will create a 'Pending Loan' for the selected participant. Users will be directed to the next page (also called ‘New Loans’) where the following loan specifications can be entered. Description – Enter a description of the loan that will be taken. This description can be any set of values and is determined at user discretion. Origination date – This date is the date the loan is taken by the participant. Clicking the box will prompt a pop-up calendar. Use the years at the bottom to scroll through the years. Use the arrows at the top to move back or forth through the months or the drop down box to select a month. Click on a day to select the day of the month/year. Double-click in the field to manually enter a date in mm/dd/yyyy format. Principal – The principal amount is the amount to be taken from the plan as a loan to the participant. The system will calculate the maximum loan amount available, shown at the right of this field. The principal amount cannot exceed the maximum amount. Note that in some cases the system may not have all the information it needs to calculate the maximum available loan. Click on 'Review/Edit' to review and update the amount. Review/Edit – This link is located on the right-hand side of the screen. Here users can change the amounts available by source and investment, and/or the vesting percentage. Enter applicable amounts for any outstanding loans previously taken in 'Highest Balance' and 'Current Balance' if the loan is not appearing in the ‘Outstanding Loans’ total above. Click 'Update' to save your changes and have the system recalculate the maximum loan amount; then return to the New Loans screen. Note that any changes you make here will not feed to any other part of the system; you are only impacting the amount available for a loan. Click ‘Go to Transactions’ at the bottom of the screen to be brought to the Transaction/Statement menu. This is handy if the amount available is not what you expected and you want to review the posted batches or statements. Annual interest rate – Enter the interest rate to be applied to the loan as a number to two decimal places, e.g. 5.25. Look up prime rate – Plan administrators may refer to the prime rate currently in effect to determine a fair interest rate to use for loans. Clicking the ‘Look up prime rate’ link will display the prime rate shown by bankrate.com in a new web page. Repayment Type – Select either ‘Number of Payments’ or ‘Payment Amount’. Additional selections will be made below, based on the selection made here. Number of Payments – Enter the total number of payments the participant will make. The system will calculate the payment amount to satisfy principal and interest amounts needed to pay off the loan within the total number of payments entered. Payment Amount – Enter the amount the participant wishes to make per payment. The system will calculate total number of payments needed to pay off the loan in the amortization schedule. First repayment date – This is the date the participant will make their first payment. This date cannot be prior to the origination date nor can it be greater than 90 days past the origination date. Clicking the box will prompt a pop-up calendar. Use the years at the bottom to scroll through the years. Use the arrows at the top to move back or forth through the months or the drop down box to select a month. Click on a day to select the day of the month/year. Double-click in the field to manually enter a date in mm/dd/yyyy format. Number of outstanding loans permitted – This number is pulled from the plan document. If changes are needed to this number, they must be made in the plan document. A warning message will appear if the number of loans created, exceeds this number. Allow extended term for principal residence – The plan document may permit an extended repayment time for loans that will be used to purchase a principal residence. Choose either yes or no from the drop down box to change the answer here. Select ‘yes’ if the loan will be used to purchase a principal residence. The default answer is no. The answer under the loan policy column will display yes or no. If ‘yes’ is displayed, the plan document does permit the extended repayment. Payment frequency – Using the drop-down box, select the frequency in which payments will be made. The response from the plan document system will be displayed to the right. Payable in full on termination – If the loan is payable in full upon termination of employment, set this to yes. Answers should be based on the plan document. The response from the plan document system will be displayed to the right. Prepay loan – This is determined by the plan document. The response from the plan document system will be displayed to the right. Options include: None  –  No prepayment permitted Prepay in full only – Only a full repayment is permitted Prepay in full or in part – More than the minimum payment is permitted, up to full repayment. Repay by payroll deduction – Determined by the plan document (the response from the plan document system will be displayed to the right.). Usually loan repayments are done through payroll deduction, so the default here is ‘yes’. Set this to ‘no’ if the plan document dictates otherwise. Loan processing fee – If there is a loan processing fee, set this to ‘yes’, otherwise, set to ‘no’. The response from the plan document system will be displayed to the right. Loan processing fee amount – If ‘Loan processing fee’ is ‘yes’, enter the dollar amount of the loan processing fee here. The response from the plan document system will be displayed to the right. Loan maintenance fee - If there is a fee for maintaining a loan, set this to ‘yes’, otherwise, set to ‘no’. Please note that this fee is separate from the loan processing fee and is usually applied on an annual basis (or other periodic time frame). The response from the plan document system will be displayed to the right. Loan maintenance fee amount - If ‘Loan maintenance fee’ is ‘yes’, enter the dollar amount of the loan maintenance fee here. The response from the plan document system will be displayed to the right. Loan default period – Select the timeframe in which the loan will go into default if payment is not timely made. Options are ‘maximum cure period’ and ‘specified number of days’. The response from the plan document system will be displayed to the right. If ‘Specified day’, number of days – If ‘Loan default period’ is ‘specified number of days’, enter the number of days in which the loan will go into default once a payment is not made. Once all applicable data for the loan has been entered, click 'Update Loan Info', then click 'Print Loan Document and Post Transactions' to continue. This brings you to a screen that summarizes the loan details, provides links to 'Amortization Schedule (csv) (doc)', 'Promissory Note (doc)', 'Note and Amortization (doc)', and 'Post Loan'. In general, you will want to print and save the documents before posting the loan (although these forms can be accessed later). Once posted, the loan will be added as a pending batch transaction in the 'Transactions Menu' and you can access amortization schedules and other loan documents under 'Loan Report'.

   Service Loan To service a loan (post payments), select 'Service Loan' from the 'Plan Administration Menu' page and follow these steps: At the top of the next screen, there are multiple options to sort and view existing loans (sort by date or participant, active/defaulted only, etc.). Select payments To select a payment, click to select along the left-hand side of the page. To select several payments within a date range, enter the begin and end date and press ‘Update’. Clicking the date boxes will prompt a pop-up calendar. Use the years at the bottom to scroll through years. Use the arrows at the top to move back or forth through the months or the drop down box to select a month. Click on a day to select the day of the month/year. Double-click in the field to manually enter a date in mm/dd/yyyy format. All payments that fall within that time frame will be automatically checked. If pre-payment is applicable, enter any pre-payment interest and principal (as a dollar amount) for the payment date and click 'Update' to view the total payment selected. Note that you can only enter principal pre-payment amount for one payment at a time. To enter principal pre-payment for more than one payment. Post the first payment first, then the second. Also note that the remaining balance will not be recalculated until after the payment has been posted. Once you are ready, click 'Post Loan Payments'. You will be taken to a page to confirm the amount to post, and once confirmed, the loan payment(s) will be added as a pending batch transaction in the 'Transactions Menu'.

   Loan Report - Default Loan There are multiple reports, functions and documents that can be accessed in the Loan Reports screen. To delete a loan, select the participant under 'Active Loans' and click 'Delete'. You will be asked to confirm the delete. To default or offset a loan, access amortization schedules and other loan documents, select the participant under 'Active Loans' and click on 'Select'. You will see similar documents as were available before the loan was posted, plus the additional options to unpost payments and 'Default Loan'. To default a loan, click on 'Default Loan', update the default date and click on 'Post Loan Default'. You will be asked to confirm 'Post Loan Default' and be taken back to the loan data for that participant. You will have a new option to 'Perform Loan Offset' after defaulting the loan and the loan will be listed as defaulted. Offsets can be performed here to close the loan and offsets will appear as pending batches in the Transactions Menu. Other reports available include loans as of a certain date, 'Print Current Active Loans', 'Print Current Defaulted Loans', 'Print Current Closed Loans' and ‘Annual Report for YYYY’.

Age

Life

Expectancy

0

..........................................................................................................

82.4

1

..........................................................................................................

81.6

2

..........................................................................................................

80.6

3

..........................................................................................................

79.7

4

..........................................................................................................

78.7

5

..........................................................................................................

77.7

6

..........................................................................................................

76.7

7

..........................................................................................................

75.8

8

..........................................................................................................

74.8

9

..........................................................................................................

73.8

10

..........................................................................................................

72.8

11

..........................................................................................................

71.8

12

..........................................................................................................

70.8

13

..........................................................................................................

69.9

14

..........................................................................................................

68.9

15

..........................................................................................................

67.9

16

..........................................................................................................

66.9

17

..........................................................................................................

66.0

18

..........................................................................................................

65.0

19

..........................................................................................................

64.0

20

..........................................................................................................

63.0

21

..........................................................................................................

62.1

22

..........................................................................................................

61.1

23

..........................................................................................................

60.1

24

..........................................................................................................

59.1

25

..........................................................................................................

58.2

26

..........................................................................................................

57.2

27

..........................................................................................................

56.2

28

..........................................................................................................

55.3

29

..........................................................................................................

54.3

30

..........................................................................................................

53.3

31

..........................................................................................................

52.4

32

..........................................................................................................

51.4

33

..........................................................................................................

50.4

34

..........................................................................................................

49.4

35

..........................................................................................................

48.5

36

..........................................................................................................

47.5

37

..........................................................................................................

46.5

38

..........................................................................................................

45.6

39

..........................................................................................................

44.6

40

..........................................................................................................

43.6

41

..........................................................................................................

42.7

42

..........................................................................................................

41.7

43

..........................................................................................................

40.7

44

..........................................................................................................

39.8

45

..........................................................................................................

38.8

46

..........................................................................................................

37.9

47

..........................................................................................................

37.0

48

..........................................................................................................

36.0

49

..........................................................................................................

35.1

50

..........................................................................................................

34.2

51

..........................................................................................................

33.3

52

..........................................................................................................

32.3

53

..........................................................................................................

31.4

54

..........................................................................................................

30.5

55

..........................................................................................................

29.6

56

..........................................................................................................

28.7

57

..........................................................................................................

27.9

58

..........................................................................................................

27.0

59

..........................................................................................................

26.1

60

..........................................................................................................

25.2

61

..........................................................................................................

24.4

62

..........................................................................................................

23.5

63

..........................................................................................................

22.7

64

..........................................................................................................

21.8

65

..........................................................................................................

21.0

66

..........................................................................................................

20.2

67

..........................................................................................................

19.4

68

..........................................................................................................

18.6

69

..........................................................................................................

17.8

70

..........................................................................................................

17.0

71

..........................................................................................................

16.3

72

..........................................................................................................

15.5

73

..........................................................................................................

14.8

74

..........................................................................................................

14.1

75

..........................................................................................................

13.4

76

..........................................................................................................

12.7

77

..........................................................................................................

12.1

78

..........................................................................................................

11.4

79

..........................................................................................................

10.8

80

..........................................................................................................

10.2

81

..........................................................................................................

9.7

82

..........................................................................................................

9.1

83

..........................................................................................................

8.6

84

..........................................................................................................

8.1

85

..........................................................................................................

7.6

86

..........................................................................................................

7.1

87

..........................................................................................................

6.7

88

..........................................................................................................

6.3

89

..........................................................................................................

5.9

90

..........................................................................................................

5.5

91

..........................................................................................................

5.2

92

..........................................................................................................

4.9

93

..........................................................................................................

4.6

94

..........................................................................................................

4.3

95

..........................................................................................................

4.1

96

..........................................................................................................

3.8

97

..........................................................................................................

3.6

98

..........................................................................................................

3.4

99

..........................................................................................................

3.1

100

..........................................................................................................

2.9

101

..........................................................................................................

2.7

102

..........................................................................................................

2.5

103

..........................................................................................................

2.3

104

..........................................................................................................

2.1

105

..........................................................................................................

1.9

106

..........................................................................................................

1.7

107

..........................................................................................................

1.5

108

..........................................................................................................

1.4

109

..........................................................................................................

1.2

110

..........................................................................................................

1.1

111

+.......................................................................................................

1.0

Age of employee

Life Expectancy

70......................................................................................................

27.4

71......................................................................................................

26.5

72......................................................................................................

25.6

73......................................................................................................

24.7

74......................................................................................................

23.8

75......................................................................................................

22.9

76......................................................................................................

22.0

77......................................................................................................

21.2

78......................................................................................................

20.3

79......................................................................................................

19.5

80......................................................................................................

18.7

81......................................................................................................

17.9

82......................................................................................................

17.1

83......................................................................................................

16.3

84......................................................................................................

15.5

85......................................................................................................

14.8

86......................................................................................................

14.1

87......................................................................................................

13.4

88......................................................................................................

12.7

89......................................................................................................

12.0

90......................................................................................................

11.4

91......................................................................................................

10.8

92......................................................................................................

10.2

93......................................................................................................

9.6

94......................................................................................................

9.1

95......................................................................................................

8.6

96......................................................................................................

8.1

97......................................................................................................

7.6

98......................................................................................................

7.1

99......................................................................................................

6.7

100....................................................................................................

6.3

101....................................................................................................

5.9

102....................................................................................................

5.5

103....................................................................................................

5.2

104....................................................................................................

4.9

105....................................................................................................

4.5

106....................................................................................................

4.2

107....................................................................................................

3.9

108....................................................................................................

3.7

109....................................................................................................

3.4

110....................................................................................................

3.1

111....................................................................................................

2.9

112....................................................................................................

2.6

113....................................................................................................

2.4

114....................................................................................................

2.1

115+..................................................................................................

1.9

Ages

0

1

2

3

4

5

6

7

8

9

0

90.0

89.5

89.0

88.6

88.2

87.8

87.4

87.1

86.8

86.5

1

89.5

89.0

88.5

88.1

87.6

87.2

86.8

86.5

86.1

85.8

2

89.0

88.5

88.0

87.5

87.1

86.6

86.2

85.8

85.5

85.1

3

88.6

88.1

87.5

87.0

86.5

86.1

85.6

85.2

84.8

84.5

4

88.2

87.6

87.1

86.5

86.0

85.5

85.1

84.6

84.2

83.8

5

87.8

87.2

86.6

86.1

85.5

85.0

84.5

84.1

83.6

83.2

6

87.4

86.8

86.2

85.6

85.1

84.5

84.0

83.5

83.1

82.6

7

87.1

86.5

85.8

85.2

84.6

84.1

83.5

83.0

82.5

82.1

8

86.8

86.1

85.5

84.8

84.2

83.6

83.1

82.5

82.0

81.6

9

86.5

85.8

85.1

84.5

83.8

83.2

82.6

82.1

81.6

81.0

10

86.2

85.5

84.8

84.1

83.5

82.8

82.2

81.6

81.1

80.6

11

85.9

85.2

84.5

83.8

83.1

82.5

81.8

81.2

80.7

80.1

12

85.7

84.9

84.2

83.5

82.8

82.1

81.5

80.8

80.2

79.7

13

85.4

84.7

84.0

83.2

82.5

81.8

81.1

80.5

79.9

79.2

14

85.2

84.5

83.7

83.0

82.2

81.5

80.8

80.1

79.5

78.9

15

85.0

84.3

83.5

82.7

82.0

81.2

80.5

79.8

79.1

78.5

16

84.9

84.1

83.3

82.5

81.7

81.0

80.2

79.5

78.8

78.1

17

84.7

83.9

83.1

82.3

81.5

80.7

80.0

79.2

78.5

77.8

18

84.5

83.7

82.9

82.1

81.3

80.5

79.7

79.0

78.2

77.5

19

84.4

83.6

82.7

81.9

81.1

80.3

79.5

78.7

78.0

77.3

20

84.3

83.4

82.6

81.8

80.9

80.1

79.3

78.5

77.7

77.0

21

84.1

83.3

82.4

81.6

80.8

79.9

79.1

78.3

77.5

76.8

22

84.0

83.2

82.3

81.5

80.6

79.8

78.9

78.1

77.3

76.5

23

83.9

83.1

82.2

81.3

80.5

79.6

78.8

77.9

77.1

76.3

24

83.8

83.0

82.1

81.2

80.3

79.5

78.6

77.8

76.9

76.1

25

83.7

82.9

82.0

81.1

80.2

79.3

78.5

77.6

76.8

75.9

26

83.6

82.8

81.9

81.0

80.1

79.2

78.3

77.5

76.6

75.8

27

83.6

82.7

81.8

80.9

80.0

79.1

78.2

77.4

76.5

75.6

28

83.5

82.6

81.7

80.8

79.9

79.0

78.1

77.2

76.4

75.5

29

83.4

82.6

81.6

80.7

79.8

78.9

78.0

77.1

76.2

75.4

30

83.4

82.5

81.6

80.7

79.7

78.8

77.9

77.0

76.1

75.2

31

83.3

82.4

81.5

80.6

79.7

78.8

77.8

76.9

76.0

75.1

32

83.3

82.4

81.5

80.5

79.6

78.7

77.8

76.8

75.9

75.0

33

83.2

82.3

81.4

80.5

79.5

78.6

77.7

76.8

75.9

74.9

34

83.2

82.3

81.3

80.4

79.5

78.5

77.6

76.7

75.8

74.9

35

83.1

82.2

81.3

80.4

79.4

78.5

77.6

76.6

75.7

74.8

36

83.1

82.2

81.3

80.3

79.4

78.4

77.5

76.6

75.6

74.7

37

83.0

82.2

81.2

80.3

79.3

78.4

77.4

76.5

75.6

74.6

38

83.0

82.1

81.2

80.2

79.3

78.3

77.4

76.4

75.5

74.6

39

83.0

82.1

81.1

80.2

79.2

78.3

77.3

76.4

75.5

74.5

40

82.9

82.1

81.1

80.2

79.2

78.3

77.3

76.4

75.4

74.5

41

82.9

82.0

81.1

80.1

79.2

78.2

77.3

76.3

75.4

74.4

42

82.9

82.0

81.1

80.1

79.1

78.2

77.2

76.3

75.3

74.4

43

82.9

82.0

81.0

80.1

79.1

78.2

77.2

76.2

75.3

74.3

44

82.8

81.9

81.0

80.0

79.1

78.1

77.2

76.2

75.2

74.3

45

82.8

81.9

81.0

80.0

79.1

78.1

77.1

76.2

75.2

74.3

46

82.8

81.9

81.0

80.0

79.0

78.1

77.1

76.1

75.2

74.2

47

82.8

81.9

80.9

80.0

79.0

78.0

77.1

76.1

75.2

74.2

48

82.8

81.9

80.9

80.0

79.0

78.0

77.1

76.1

75.1

74.2

49

82.7

81.8

80.9

79.9

79.0

78.0

77.0

76.1

75.1

74.1

50

82.7

81.8

80.9

79.9

79.0

78.0

77.0

76.0

75.1

74.1

51

82.7

81.8

80.9

79.9

78.9

78.0

77.0

76.0

75.1

74.1

52

82.7

81.8

80.9

79.9

78.9

78.0

77.0

76.0

75.0

74.1

53

82.7

81.8

80.8

79.9

78.9

77.9

77.0

76.0

75.0

74.0

54

82.7

81.8

80.8

79.9

78.9

77.9

76.9

76.0

75.0

74.0

55

82.6

81.8

80.8

79.8

78.9

77.9

76.9

76.0

75.0

74.0

56

82.6

81.7

80.8

79.8

78.9

77.9

76.9

75.9

75.0

74.0

57

82.6

81.7

80.8

79.8

78.9

77.9

76.9

75.9

75.0

74.0

58

82.6

81.7

80.8

79.8

78.8

77.9

76.9

75.9

74.9

74.0

59

82.6

81.7

80.8

79.8

78.8

77.9

76.9

75.9

74.9

74.0

60

82.6

81.7

80.8

79.8

78.8

77.8

76.9

75.9

74.9

73.9

61

82.6

81.7

80.8

79.8

78.8

77.8

76.9

75.9

74.9

73.9

62

82.6

81.7

80.7

79.8

78.8

77.8

76.9

75.9

74.9

73.9

63

82.6

81.7

80.7

79.8

78.8

77.8

76.8

75.9

74.9

73.9

64

82.5

81.7

80.7

79.8

78.8

77.8

76.8

75.9

74.9

73.9

65

82.5

81.7

80.7

79.8

78.8

77.8

76.8

75.8

74.9

73.9

66

82.5

81.7

80.7

79.7

78.8

77.8

76.8

75.8

74.9

73.9

67

82.5

81.7

80.7

79.7

78.8

77.8

76.8

75.8

74.9

73.9

68

82.5

81.6

80.7

79.7

78.8

77.8

76.8

75.8

74.8

73.9

69

82.5

81.6

80.7

79.7

78.8

77.8

76.8

75.8

74.8

73.9

70

82.5

81.6

80.7

79.7

78.8

77.8

76.8

75.8

74.8

73.9

71

82.5

81.6

80.7

79.7

78.7

77.8

76.8

75.8

74.8

73.8

72

82.5

81.6

80.7

79.7

78.7

77.8

76.8

75.8

74.8

73.8

73

82.5

81.6

80.7

79.7

78.7

77.8

76.8

75.8

74.8

73.8

74

82.5

81.6

80.7

79.7

78.7

77.8

76.8

75.8

74.8

73.8

75

82.5

81.6

80.7

79.7

78.7

77.8

76.8

75.8

74.8

73.8

76

82.5

81.6

80.7

79.7

78.7

77.8

76.8

75.8

74.8

73.8

77

82.5

81.6

80.7

79.7

78.7

77.7

76.8

75.8

74.8

73.8

78

82.5

81.6

80.7

79.7

78.7

77.7

76.8

75.8

74.8

73.8

79

82.5

81.6

80.7

79.7

78.7

77.7

76.8

75.8

74.8

73.8

80

82.5

81.6

80.7

79.7

78.7

77.7

76.8

75.8

74.8

73.8

81

82.4

81.6

80.7

79.7

78.7

77.7

76.8

75.8

74.8

73.8

82

82.4

81.6

80.7

79.7

78.7

77.7

76.8

75.8

74.8

73.8

83

82.4

81.6

80.7

79.7

78.7

77.7

76.8

75.8

74.8

73.8

84

82.4

81.6

80.7

79.7

78.7

77.7

76.8

75.8

74.8

73.8

85

82.4

81.6

80.6

79.7

78.7

77.7

76.8

75.8

74.8

73.8

86

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

87

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

88

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

89

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

90

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

91

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

92

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

93

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

94

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

95

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

96

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

97

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

98

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

99

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

100

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

101

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

102

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

103

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

104

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

105

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

106

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

107

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

108

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

109

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

110

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

111

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

112

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

113

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

114

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

115+

82.4

81.6

80.6

79.7

78.7

77.7

76.7

75.8

74.8

73.8

Ages

10

11

12

13

14

15

16

17

18

19

10

80.0

79.6

79.1

78.7

78.2

77.9

77.5

77.2

76.8

76.5

11

79.6

79.0

78.6

78.1

77.7

77.3

76.9

76.5

76.2

75.8

12

79.1

78.6

78.1

77.6

77.1

76.7

76.3

75.9

75.5

75.2

13

78.7

78.1

77.6

77.1

76.6

76.1

75.7

75.3

74.9

74.5

14

78.2

77.7

77.1

76.6

76.1

75.6

75.1

74.7

74.3

73.9

15

77.9

77.3

76.7

76.1

75.6

75.1

74.6

74.1

73.7

73.3

16

77.5

76.9

76.3

75.7

75.1

74.6

74.1

73.6

73.1

72.7

17

77.2

76.5

75.9

75.3

74.7

74.1

73.6

73.1

72.6

72.1

18

76.8

76.2

75.5

74.9

74.3

73.7

73.1

72.6

72.1

71.6

19

76.5

75.8

75.2

74.5

73.9

73.3

72.7

72.1

71.6

71.1

20

76.3

75.5

74.8

74.2

73.5

72.9

72.3

71.7

71.1

70.6

21

76.0

75.3

74.5

73.8

73.2

72.5

71.9

71.3

70.7

70.1

22

75.8

75.0

74.3

73.5

72.9

72.2

71.5

70.9

70.3

69.7

23

75.5

74.8

74.0

73.3

72.6

71.9

71.2

70.5

69.9

69.3

24

75.3

74.5

73.8

73.0

72.3

71.6

70.9

70.2

69.5

68.9

25

75.1

74.3

73.5

72.8

72.0

71.3

70.6

69.9

69.2

68.5

26

75.0

74.1

73.3

72.5

71.8

71.0

70.3

69.6

68.9

68.2

27

74.8

74.0

73.1

72.3

71.6

70.8

70.0

69.3

68.6

67.9

28

74.6

73.8

73.0

72.2

71.3

70.6

69.8

69.0

68.3

67.6

29

74.5

73.6

72.8

72.0

71.2

70.4

69.6

68.8

68.0

67.3

30

74.4

73.5

72.7

71.8

71.0

70.2

69.4

68.6

67.8

67.1

31

74.3

73.4

72.5

71.7

70.8

70.0

69.2

68.4

67.6

66.8

32

74.1

73.3

72.4

71.5

70.7

69.8

69.0

68.2

67.4

66.6

33

74.0

73.2

72.3

71.4

70.5

69.7

68.8

68.0

67.2

66.4

34

73.9

73.0

72.2

71.3

70.4

69.5

68.7

67.8

67.0

66.2

35

73.9

73.0

72.1

71.2

70.3

69.4

68.5

67.7

66.8

66.0

36

73.8

72.9

72.0

71.1

70.2

69.3

68.4

67.6

66.7

65.9

37

73.7

72.8

71.9

71.0

70.1

69.2

68.3

67.4

66.6

65.7

38

73.6

72.7

71.8

70.9

70.0

69.1

68.2

67.3

66.4

65.6

39

73.6

72.7

71.7

70.8

69.9

69.0

68.1

67.2

66.3

65.4

40

73.5

72.6

71.7

70.7

69.8

68.9

68.0

67.1

66.2

65.3

41

73.5

72.5

71.6

70.7

69.7

68.8

67.9

67.0

66.1

65.2

42

73.4

72.5

71.5

70.6

69.7

68.8

67.8

66.9

66.0

65.1

43

73.4

72.4

71.5

70.6

69.6

68.7

67.8

66.8

65.9

65.0

44

73.3

72.4

71.4

70.5

69.6

68.6

67.7

66.8

65.9

64.9

45

73.3

72.3

71.4

70.5

69.5

68.6

67.6

66.7

65.8

64.9

46

73.3

72.3

71.4

70.4

69.5

68.5

67.6

66.6

65.7

64.8

47

73.2

72.3

71.3

70.4

69.4

68.5

67.5

66.6

65.7

64.7

48