Data Import Overview

One of the most important aspects of implementing a new PensionPro setup is transferring existing data into its new home. PensionPro provides new firms with a number of import tools to get data added quickly. This article discusses PensionPro's available import options and provides some insight to using them effectively.

 

PensionPro includes many data fields, though not all are required to be filled before the application can begin to be used effectively. That said, it is ideal to complete as much information as possible during the initial import stages to avoid manually populating the data in the future.

 

Tier Availability: Track, Team, Business

 

Requires Security Rights: Access Power Tools

 

Article Contents

 

 


 

Essential Data Imports

 

The import tools named in this section will be used early on in nearly every new PensionPro setup.

 

Order

Import

Used for

1

Clients & Plans Basic functionality, Plan organization

2

Employees User account creation & management

3

Contacts Customer relations, sales

4

Employee Plan Roles Project workflows, Plan communications

5

Plan Contact Roles Customer relations, Plan communications, PlanSponsorLink management
List of essential import types

 


 

Clients & Plans

 

Plans are the heart of PensionPro, and many later imports add data to existing Plans. Clients are the companies sponsoring these Plans. Client data must be imported first; then, each imported Plan is linked to an existing Client record. Multiple Plans may be linked to a single Client.

 

See also: Data Import - Clients & Plans

 


 

Employees

 

Each Employee record represents an employee at the TPA firm. Not only does this record store general employee information, but also establishes the employee's PensionPro account. In other words, an Employee record should be added for each PensionPro user.

 

See also: Data Import - Employees

 


 

Contacts

 

Each Contact record represents an individual known to the firm. This could be a plan sponsor, an advisor, a potential sales lead, or anything else. It can be helpful to think of this step like importing an address book full of names, addresses, and numbers.

 

Although not required, each Contact can be linked with a Company, which can help keep Contacts organized. Company records are distinct from Client records, and simply represent any organization, regardless of whether or not they do business with the firm. If using Companies, keep the following in mind:

 

  • If a Contact's Company cannot be found in PensionPro, a new Company record is created upon import.
  • PensionPro will not consolidate any variations in Company name used for multiple Contacts. If the Company names differ in any way, multiple records will be created.
  • Creating a Client record also creates a matching Company record; this means that Company data already exists by the time this step is reached. If importing Contacts employed with a client company, be sure to match the Company spelling to what's listed in PensionPro.

 

The aim of this step is simply to add Contacts and their information. Linking these Contacts to Plans comes in a later step.

 

See also: Data Import - Contacts

 


 

Employee Plan Roles & Plan Contact Roles

 

These two imports establish links between Plans and Employees/Contacts, and dictate the responsibilities that an individual has in service of the Plan. An Employee might be an administrator, a billing specialist, or distribution processor, whereas a Contact might be a main contact, accountant, investment provider, or payroll contact.

 

Each import will require an existing Employee or Contact, an existing Plan, and the Role to which they are being assigned.

 

See also:

 


 

Supplemental Data Imports

 

The imports listed in the following table are not critical to a successful PensionPro implementation, and thus can be performed optionally, or at a later time. They can be completed in any order.

 

Import

Used for

Employer Data Reference of Client business & fiscal information, easier Data Collection
Investment Providers Reference of Plan investment information
Services Provided Identifying services the firm is providing for a Plan
Prior Year Census Data Pre-population of census data for easier Data Collection
Plan Cycles Reference & population of historical 5500 information
Notes Reference of miscellaneous information attached to a Client or Plan
List of supplemental imports