Follow

Importing Data with the ftwilliam.com Import Power Tool

The ftwilliam.com Import Power Tool allows users to onboard initial data easily and efficiently into PensionPro. Users can import Clients, Plans, and Contacts from ftwilliam.com using their FTW API Key. This article provides information on how to Access and utilize the ftwilliam.com Import Power Tool to import new information into PensionPro.

 

Tier Availability: All

Security Rights Required: Access Power Tools

 

 

Menu:

 

What Records are Created with the Power Tool?

The ftwilliam.com Import Power Tool is only used for creating new information in PensionPro. It should not be used for editing established data. Users importing data with the ftwilliam.com Import Power Tool will create the following data records:

  • Client
    • Employer Data for each plan year
    • Client Address
  • Plan
  • Plan Cycle
    • Plan Cycle records for each 5500 filed with FTW

For a Plan Cycle to be eligible for this import, users need the following items set up with FTW:

  • Users must have at least a client and a Plan with Plan Cycles
    • The client must be linked to an FTW Client
    • The plan must be linked to an FTW Plan
    • Under the Plan record, Plan Cycles must exist
    • Plan Cycle must have Period Start and Period End which must match the year of what was filed through ftwilliam.com
  • The ftwilliam.com Import Power tool will only attempt to sync Plan Cycles for records that have not been previously synced.

 

Set Up ftwilliam.com API Key

Before users can import data with the ftwilliam.com Import Power Tool, users must confirm their FTW API key is entered in the General ftwilliam.com Settings Information page. Users can find directions on how to enter their FTW API key in the Setup section of Integrating Ftwilliam.Com Software With PensionPro.

 

Accessing the Power Tool

The ftwilliam.com Import Power Tool is accessed by clicking Power Tools > Import > Pension Pro Setup > ftwilliam.com Express Import. The Power Tool will open in the user's default browser. 

 

Importing Data 

  1. Once the ftwilliam.com Import Power Tool site opens, enter the FTW API key into Step 1 and click Continue.
  2. Select the box in the top left of the Plans table of Step 2 to select All Plans. Once selections are completed, click Continue.
    • Users may choose individual plans if necessary.
    • Filtering is available by clicking on the Filter button.
    • Users can sort by clicking a column header to sort by that column.
  3. In Step 3, users may click the box in the top-left of the Contacts table to select All Contacts. Once selections are completed, click Continue.
    • Users can select individual contacts.
    • Filtering is available by clicking the Filter button.
    • Users can sort by clicking a column header to sort by that column.
  4. In Step 4, an overview of the import will display as well as items that will be created as a result of the import. Confirm the information is correct and click Continue.
    • Once the import is successful an email will be sent advising the client of the import results.
  5. Import Results will display in Step 5. Users should confirm the data imported successfully.
  6. Clicking the Export Result button allows the user to export a spreadsheet of the imported results.

 

Data Mappings

5500 Forms Data Mappings

Fields synced with ftwilliam.com:

  • Invited 5500 On
  • Accepted 5500 On
  • Filed 5500 On
  • Signed Status
    • PensionPro receives an integer from FTW and then convert it to one of three values
      • Unknown
      • Not Signed
      • Signed
      • Invited
    • Filing Status
      • PensionPro receives an integer from FTW and then convert it to one of six values
        • Unknown
        • Accepted
        • Not Accepted
        • Submitted
        • Rejected
        • Not Submitted
    • Sponsor Signed On
    • Admin Signed On
    • DFE Signed On
    • Filed 5558

Compliance Forms Data Mappings

Fields synced with ftwilliam.com:

  • ADP
  • ACP
  • 401(a)(4) General Nondiscrimination
  • Top Heavy
  • 415 Limit
  • 404 Deduction Limit
  • 410(b) Coverage – ER Match
  • 410(b) Coverage – ER PS
  • 410(b) Coverage – 401(k)

For the fields listed below, PensionPro sets values based off of the following strings of information from FTW and then sets the below value in PensionPro.

  • “Not-OK” & “FAIL”
    • Failed
  • “OK” & “PASS”
    • Passed
  • All others
    • Unknown

 

 

 

 

 

 

 Feature feedback

 

 

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

Comments