Importing Contact Data (Desktop)

The initial population of contact data into PensionPro requires that a pre-formatted excel data sheet be completed for import. The Contact Data Import allows users to add new contact records to PensionPro at a single time. This import is for creating new contact records only. 
Tier Availability: All Tiers
Add-On Availability: SalesPitch 
Security Rights Required: Access Power Tools


Prior to importing contact data, all List Values entered in the template should be created as active List Values in PensionPro with no trailing spaces. Note: Importing contact data will not overwrite existing information in the system. Importing additional contact information merely imports the new data. Prior data is untouched. 

To Import Contact Data:

  1. Click on Power Tools > Import > PensionPro Setup > Contacts.
  2. Click on the Download a Template button.
  3. Using the empty template, organize and compile the data for import.
    • Do not edit or delete any of the column headers in the template. It will cause the import to not function properly.
    • New columns cannot be added to bring over additional fields.
    • Ignore the Plan ID and Type of Plan Contact fields. These are to assign Plan Contact Roles. The user can separately use the Plan Contact Role Import Power Tool to assign new Plan Contact Roles for multiple contacts and plans at one time.
    • Save the template once it has been completed.
  4. To import the completed template, click on Power Tools > Import > PensionPro Setup > Contacts. This will open the browser to the Contact Import page.
  5. Click on the Select a spreadsheet button and select the file for import.
  6. Click on the Upload button to import the data.
  7. Any errors encountered in importing the data will appear when the data is submitted for Import. Once all data has been scrubbed and the errors corrected, the import will show as completed once processed. All data must be formatted correctly before the import will complete.

Note: The system will not allow for duplicate emails. An existing contact record cannot have an email that is identical to another. PensionPro will allow for only 1 email to be notated in the system.

Instructions Tab

  • The Instructions tab is a color-coded Column Legend with instructions for filling out the import template. The color-coded columns in the spreadsheet allow the user to see what fields are required, related, recommended, or not required.
  • The Instructions tab should not be edited or deleted prior to importing the template. It will cause the import to not function properly.

Contact Tab

  • Required fields: First Name, Last Name, Status, Active
  • List Values: Prefix, Suffix, Status, Contact Profession, Contact Preference, Contact Grouping, Contact Category, Address Type, Number Type, Contact Source, Sales Territory/Team, Broker Dealer, Platform Preference, Investment Provider, Plan Provider, Note Category


 Checklist to avoid errors when importing:

  1. All entries for fields that are List Values are entered in the appropriate List Value List Type in PensionPro with no trailing spaces.
  2. All required fields are entered.
  3. The value in the Company Name field is the firm the contact works for.
  4. The value in the Company Name field matches the Client Name record entered in PensionPro where applicable.
  5. Addresses are complete (Address 1, City, State, Zip Code are all entered for a complete address).
  6. Address State is entered in two-letter abbreviation for the state.
  7. Addresses are not foreign.
  8. If no Company Name is entered, Number is Personal must be marked "Yes."
  9. Phone Number entries are complete and contain only numbers.
  10. Email Address field contains a single, complete email address if entered.
  11. Email Addresses are not shared between any two contact records.
  12. Active is entered as either "Yes" or "No" for each contact record.
  13. If Note Text is entered, it is less than 2000 characters.


 Feature feedback