Follow

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.    

Tier Availability: Team, Core, Essential, Premium, Business
Security Rights Required: Maintenance

 

Setup

To link information between PensionPro and ftwilliam.com, users must obtain API Sign-In Credentials from ftwilliam.com containing an API Key and 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 by clicking here to open a pre-formatted email to request 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 FT William 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

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 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 FT William 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.”  

 

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.

Linking a 5500 Signer already on ftwilliam

At the beginning of each year, users will need to link your portal users using the Portal User Linking tool found in Maintenance > Preferences > Integrations > ftwilliam.com.  When users link them using the tool they will be set up in PensionPro as the 5500 Signer. If they have different usernames or are set up more than once in ftwilliam.com then they will not be linked correctly. 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, they need to be created in ftwilliam.com with the correct rights and signing role. You should make sure in ftwilliam.com that the user is set up only once in ftwilliam.com and linked to each of the plans that you want them linked to in PensionPro. The person also needs to be set up as a plan contact in Plan Details\People\Contacts in PensionPro. Once that is done, 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.   

After they have been linked they should see the Sign My 5500 button in PSL. Once they click on this they will be taken to the ftwilliam site to sign. Any 5500s they are supposed to sign will show up on that page, our linking tool does not control this.

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.

 

FAQ

  • Is there a way to view plans that are unlinked with FTW? Yes, users can view the Plans Missing Integration Link report. This report will provide a listing of any plans that are not linked between PensionPro and ftwilliam.com. Users can find information on navigating to that report and what is displayed within this report in Navigating PensionPro Reports.
  • A number of the FTW linked fields are not populating on Plan Cycles for a few plans. How can I make sure these are linked correctly? Users should first confirm the General ftwilliam.com Settings Information is entered on the Home tab of Preferences > Integrations > ftwilliam.com. The API key must be entered and verified. Government Forms Enabled and Compliance must be enabled. Secondly, the user can manually unlink the Plan and Client on the Plan Details and Client Details tabs (If the Client is linked to multiple Plans, all Plans must be unlinked prior to unlinking the Client record). Once the Plan and Client are unlinked, relink the Client from the Integration field at the bottom of the Client Details > Home tab by clicking the Link to Existing button. Users can then relink the plan from the Integration button at the bottom of the Plan Details > Home tab by clicking the Link to Existing button. Once the Client and Plan are relinked to ftwilliam, click the Refresh from ftwilliam.com button on the Plan Cycle Filings tab for this plan.
  • My API Key was verified in the General ftwilliam.com Settings Information preferences, but I do not see the Integration field on Client Details or Plan Details. What am I missing? Create Records in ftwilliam.com must be set to "Yes" on the General ftwilliam.com Settings Information. 

 

 

 Feature feedback

Was this article helpful?
4 out of 4 found this helpful
Have more questions? Submit a request

Comments

  • Avatar
    Jessica King

    Have other users done the intergration? I'm concerned about linking plans from Pension Pro to FT William - will we receive notification if there is different data in FT William than in PP and that it is changing? I'm interested to hear from someone who has been using it in the Beta version and whether there have been any issues. It is scary to jump in head first in the middle of reporting season. Thanks!

  • Avatar
    Sue Michalski

    Can you still use this integration if you use the FTW 5500 and extension but use Relius for the administration?

  • Avatar
    Matthew Knorr

    Sue,
    Yes, the integration can be done for clients only using FTW's 5500 software. Follow the instructions in this article to obtain the credentials from FTW and link the plans. Feel free to submit a Help Center ticket if you have specific questions. Thank you.

  • Avatar
    Jesse King
    Edited by Jesse King