Integrating ftwilliam.com Software With PensionPro

The partnership between PensionPro and ftwilliam.com provides users the ability to link certain information between the applications. This article walks users through creating a new Client, Plan, and 5500 Signer on ftwilliam.com using the PensionPro user interface. It also walks users through the process of linking current Clients, Plans, and 5500 Signers so information such as 5500 filing dates and compliance testing results can be updated in PensionPro when completed on ftwilliam.com.

Security Rights Required:AccountMaintenance

Setup

To link information between PensionPro and ftwilliam.com, users must obtain API Sign-In Credentials from ftwilliam.com containing an API Keyand SSO Source Reference. Only request the SSO Source Reference if you are a PlanSponsorLink user and you intend to direct 5500 Signers to PlanSponsorLink to file their Form 5500. To obtain this information, email ftwilliam.com byclicking here to open a pre-formatted emailtorequest an API Key and an SSO Source Reference if applicable.

Upon receipt of API credentials from ftwilliam.com, go into PensionPro and click on Maintenance\Preferences\Integrations\ftwilliams.com. This will take you to the home tab of General ftwilliams.com Settings. On the right click on the edit button and a slider menu will appear. Enter the API Key and the SSO Source Reference code, if applicable.

In addition to the information provided by ftwilliam.com the following options appear on the Home tab:

PSL SSO Enabled: Stands for PlanSponsorLink Single Sign On Enabled. Click on the checkbox if clients will be directed to PlanSponsorLink to sign their Form 5500. Enabling this feature will link the ftwilliam.com 5500 Portal to PlanSponsorLink, which allows the Form 5500 signer to login directly to PlanSponsorLink to sign their Form 5500.

Government Forms Enabled: Click on the checkbox to allow the integration and linking of information between PensionPro and ftwilliam.com’s Form 5500 software. Once enabled, the following fields from the Plan’s Plan Cycle\Filings tab will update hourly in PensionPro after completion on ftwilliam.com.

· 5500 Invited Date

· Sponsor Signed Date

· Admin Signed Date

· DFE Signed Date

· 5500 Filed Date

· 5500 Accepted Date

· Sign Status

· Acceptance Status

· 5558 Filed Date (must be part of a 5558 batch on ftwilliam.com marked as "Completed")

Once enabled, PensionPro will also back-fill the above Form 5500 information for any plan that has a plan cycle in PensionPro with filing information on ftwilliam.com prior to the integration. This information is generally populated within 72 hours of linking client and plan information between the applications.

Compliance Enabled: Click on the checkbox to allow the integration and linking of information between PensionPro and ftwilliam.com’s compliance software. Only click on the checkbox if you are a ftwilliam.com compliance software user. Once enabled, the following fields from the Plan’s Plan Cycle\Test Results tab will update hourly in PensionPro after completion on ftwilliam.com.

· ADP

· ACP

· 401(a)(4) General Nondiscrimination

· Top Heavy

· 415 Limit

· 404 Deduction Limit

· 410(b) Coverage – 401(k)

· 410(b) Coverage – ER Match

· 410(b) Coverage – ER PS

Create Records in ftwilliam.com: Click on the checkbox to allow Client, Plan, and Contact information to be created in ftwilliam.com via the PensionPro user interface. Information that can be created in ftwilliam.com through PensionPro is as follows:

· Client Fields

· Client Name

· Client Address (address must be set to Primary in PensionPro)

· Client ID

· Phone# (Phone# must be set to Primary in PensionPro)

· Entity Type (Currently defaults to “other” on ft.william.com)

· EIN

· Fiscal Year-End

· Plan Fields

· Plan Name

· Plan Type (Currently defaults to “WL”)

· Checklist (Currently defaults to “Misc”)

· IRS Plan #

· Plan Year-End

· Trust EIN

· Added On

· Form 5500 Signers

· Name

· Email Address

· Form 5500 Year

· Signing As

· Username

Update Records in ftwilliam.com. Clicking on the checkbox will allow certain information that is updated in PensionPro to be updated in ftwilliam.com. Client Name, Client ID, Plan Name, and Plan ID are synced fields that will update on ftwilliam.com if changed in PensionPro.

When you click save the Verified field will indicate Yes if a correct API Key has been entered. If an incorrect API Key is entered on the slider and the user selects the Save button, a popup will display: “Settings cannot be verified. API Key might be wrong.” The Verified field must be displayed as Yes for the integration to function properly.

Creating New Client, Plan, 5500 Signer in ftwilliam.com with PensionPro’s Interface

Client

To create a client record in ftwilliam.com, first complete the above setup steps. Once that is completed, create a new client in PensionPro using the standard client creation process. After the client has been created select the Create New link located in the Integration field of the Client Home tab. Selecting the Create New link will immediately create a new client on ftwilliam.com. The information that will be created on ftwilliam.com is Client Name, Client ID, Address (primary address only), Phone# (primary phone# only), Entity Type, EIN, and Fiscal Year-End.

The system will scan the current database for duplicate EIN and Client ID’s before creating a new client record. If a duplicate is found the user will receive a notification, “record is unable to be created due to a duplicate client.”

Plan

To create a plan in ftwilliam.com using PensionPro, a client must first be created in PensionPro and ftwilliam.com. Create a new plan in PensionPro using the standard plan creation process. After the plan has been created select the Create New link located in the Integration field of the plan's Home tab. Selecting the Create New link will immediately create a new plan on ftwilliam.com. Information that will be created on ftwilliam.com is Plan Name, Plan Type, TPA Plan ID, IRS plan#, Plan Year-End, and Trust EIN.

The system will scan the current database for duplicate EIN and IRS Plan# before creating a new Plan record. If a duplicate is found the user will receive a notification, “record is unable to be created due to a duplicate plan.”

5500 Signer

To create a Form 5500 signer on ftwilliam.com using PensionPro, a client and plan must be created in PensionPro and ftwilliam.com. Setting the Form 5500 signer up in PensionPro will link the ftwilliam.com 5500 Portal to PlanSponsorLink which allows the Form 5500 signer to login directly to PlanSponsorLink to sign their Form 5500.

Setup the Form 5500 signer by searching for the Plan and selecting Plan Cycles from the Plan’s Home tab. Select the appropriate plan cycle for the Form 5500 filing period and navigate to the 5500 Signing Roles tab. Select the Add button and the Add Plan Cycle 5500 Signer slider menu will appear. Type the contact’s name, a dropdown menu will appear to select the name. If the contact name is not recognized, make sure the contact has already been added to PensionPro. Type a Login Name for the contact. The Login Name is typically the contact’s email address although there are no restrictions to this field. The 5500 Signer Role is a drop down menu containing the Form 5500 signing authority. The options are signing as both Administrator/Sponsor, Administrator Only, Sponsor Only, and DFE. Saving the slider will create the 5500 signer on ftwilliam.com.

The system will scan the current database for duplicate contact email addresses on ftwilliam.com before creating a new portal user. If a duplicate is found the user will receive a notification, “record is unable to be created due to a duplicate portal user.”

Linking Current Clients, Plans, and 5500 Signers Between PensionPro and ftwilliam.com

Client and Plan

Link existing clients and plans from the Plan Linking tab under the Maintenance\Preferences\ Integrations\ftwilliam.com section of PensionPro. To link current Client, Plan, or Contacts between ftwilliam.com and PensionPro the ftwilliam.com Settings Home tab must be completed. The API Key must be entered. The Verified field, Government Forms Enabled field, Create Records in ftwilliams.com field, and Update Records in ftwilliams.com field must be Yes.

To link Plans, click on the Plan Linking Tab and select the green refresh button to populate a listing of plans and clients that are unlinked between PensionPro and ftwilliam.com. Select the Suggested Links button on the right hand side of the grid, which will populate the New Linked Plans column with plans that appear to be a match between PensionPro and ftwilliam.com. The system will link plans that match both the EIN and IRS Plan# between applications.

Plans can manually be linked by selecting the plan from the PensionPro Unlinked Plans column and the ftwilliam.com Unlinked Plans column and select the right arrow button to move the linking to the New Linked Plans column.

Select the Save button to link all plans in the New Linked Plans column between PensionPro and ftwilliam.com. When a plan is linked they will no longer show in either the PensionPro Unlinked Plans column or the ftwilliam.com Unlinked Plans column.

Please note that linking a Plan using the Plan Linking tool will also link the client to ftwilliam.com. No steps are required by the user to link the client.

An exception report named Plans Missing Integration Link is available under the Reports/Exception Reports menu. This report will provide a listing of any plans that are not linked between PensionPro and ftwilliam.com.

5500 Signer

Linking a contact and portal user between PensionPro and ftwilliam.com is only necessary if the client uses PlanSponsorLink.com and the TPA wants to direct their clients to PSL to file the Form 5500.

To link a portal user, click on the Portal User Linking Tab and select the green refresh button to populate a listing of unlinked contacts between PensionPro and ftwilliam.com for Form 5500 signing purposes. The PensionPro unlinked contacts will be populated with all plan contacts that have a plan cycle created for the particular year being linked. Contacts can be filtered by selecting a particular Role from the dropdown menu. The ftwilliam.com Unlinked Portal Users will populate with portal users assigned to a Plan for the plan year being linked that have a 5500 signing role assigned to them. The Form 5500 does not need to be locked on ftwilliam.com. Results may be limited if portal users have not been rolled forward from the prior year’s Form 5500 on ftwilliam.com.

Select the Suggested Links button on the right hand side of the grid, which will populate the New Linked Portal Users column with portal users that appear to be a match between PensionPro and ftwilliam.com. The system will link portal users that have identical email addresses on PensionPro and ftwiliam.com.

Portal Users can be manually linked by selecting the contact from the PensionPro Unlinked Contacts column and the ftwilliam.com Unlinked Portal Users column and select the right arrow button to move the linking to the New Linked Portal Users column.

Select the Save button to link all Portal Users in the New Linked Portal Users column between PensionPro and ftwilliam.com. When a portal user is linked they will no longer show in either the PensionPro Unlinked Contacts column or the ftwilliam.com Unlinked Portal Users column. Linking the portal users will also update the 5500 Signing Roles tab in PensionPro under the Plan Cycle Details.

Unlinking Clients, Plans, and 5500 Signer Between PensionPro and ftwilliam.com

All 5500 Signers must be removed before a plan or client can be unlinked in PensionPro. To remove a 5500 Signer from PensionPro search for the Plan and select Plan Cycles from the Plan’s Home tab. Select the appropriate plan cycle for the Form 5500 filing period and navigate to the 5500 Signing Roles tab. Select the 5500 Signers name and click on the delete button on the right hand side of the grid to remove the 5500 Signer. Note, deleting the contact as a 5500 Signer will not delete them as a plan contact in other areas of the system. Also note that removing the contact as a 5500 Signer in PensionPro will not remove them as a portal user in ftwilliam.com. Portal users will have to manually be removed from ftwilliam.com.

Unlinking an individual plan with ftwilliam.com is done through the plan’s Home tab. On the General Plan Information screen, the Integration field will be filled with “Yes (Unlink)” if the plan is linked to ftwilliam.com. Selecting Unlink will unlink PensionPro to ftwilliam.com, which will stop the flow of all plan information between the applications.

To unlink a Client, all associated plans must first be unlinked. On the Client Details Home tab, the Integration field will be filled with “Yes (Unlink)” if the Client is linked to ftwilliam.com. Selecting Unlink will unlink PensionPro to ftwilliam.com, which will stop the flow of all Client information between the systems.