Employer Data for Clients

Annual plan administration requires a lot of data that pertains to the sponsor company, and isn't directly related to the plan itself—such as payroll information, business entity type, and who owns the company. In PensionPro, this type of information is recorded yearly and saved under the Client record as Employer Data. This article details how to collect Employer Data and manage it once it's safely in PensionPro.

 

Tier Availability: Track, Team, Business

 

Note: Some items may not be available in all tiers.

 

Article Contents

 

 


 

Overview of Employer Data

 

Employer Data records the yearly company information needed for annual administration—entity type, EIN, ownership information, family members, other businesses, etc.—and saves a copy of this data for each plan year to the Client tab.

 

While the TPA can enter this information directly into PensionPro, it is most commonly added by a Plan Contact when using Annual Data Collection via PlanSponsorLink.

 


 

Employer Data on the Client Tab

 

To manage a Client's Employer Data, navigate to their Client tab and select Employer Data from the Views list on the left. Each entry in the Employer Data grid is a record of the company information collected for a given plan year.

 

Entity Type

The type of business entity, such as a Corporation or LLC.

  • Options are defined by List Values, under Core > Client\Employer > Entity Type.
Fiscal Year End The day and month the company's fiscal year ends.
Period Start, Period End The beginning and end dates for the entry's plan year.
EIN The company's EIN during this plan year.
NAICS Code The company's business/industry code during this plan year.
Payroll Frequency

Payroll information for this plan year.

  • Options are defined by List Values, under Core > Client\Employer > Payroll Frequency.
Payroll Provider

Payroll information for this plan year.

  • Options are defined by List Values, under Core > Client\Employer > Payroll Provider.
Columns on the Employer Data grid

 

To view additional company information for a given plan year (such as principals and family members), double-click the appropriate entry in the grid. A new Employer Data tab opens to the Company view.

 


 

Adding & Editing Employer Data Records

 

Requires Security Rights: Add/Edit Client

 

To add a new Employer Data record for a plan year:

 

  1. Select Addadd.png at the top-right of the Employer Data grid. The Add Company Information window displays.
  2. Use Fiscal Year End Month and Fiscal Year End Day to set the end date of the Client's fiscal year.
  3. Enter the beginning and end dates of the plan year into the Period Start and Period End fields.
  4. (optional) Enter any other available information as needed.
  5. Select Save. The Employer Data entry will be created and added to the grid.

 

To make changes to an Employer Data record, hover over its entry in the Employer Data grid and select Editedit.png or Deletedelete.png on the right-hand side.

 


 

Working with Employer Data Views

 

Double-clicking an entry in the Employer Data grid of the Client tab will open that record in a new Employer Data tab. This provides access to more information than is displayed on the Client tab itself.

 

Company Basic company information, such as fiscal year end and EIN.
Principals Company owners, officers, and other similar individuals.
Family Family members of principals who are employed by the company.
Other Businesses Unrelated businesses that are also owned by company principals.
Views under the Employer Data tab

 

Each of these views is discussed in more detail in the following sections.

 


 

Company View

 

The Company view includes details such as the plan year start and end dates, company EIN and NAICS code, and payroll information. This matches the information that was available in the Employer Data grid, as listed in the section Employer Data on the Client Tab; refer that section for more information.

 

Editing Company Data

 

Requires Security Rights: Add/Edit Client

 

To edit information on the Company view, select Editedit.png at the top-right of the grid.

 


 

Principals View

 

The Principles view includes the names and details of any company owners and officers.

 

Name The full name of the individual.
SSN

The principal's Social Security number.

  • This information is used to connect this principal to an individual on the employee census, if applicable.
Officer Indicates whether or not the principal is a company officer.
Is Not Employee Indicates whether or not the principal is employed by the company.
Title

The principal's relationship to the company.

  • Options are defined by List Values, under Core > Client\Employer > Officer Title.
Ownership The principal's ownership percentage.
Columns on the Principles grid

 

Adding & Editing Principal Data

 

Requires Security Rights: Add/Edit Client

 

To add a new Principal entry:

 

  1. Select Addadd.png at the top-right of the Principals grid. The corresponding window displays.
  2. Enter the principal's Name.
  3. If needed, enter an SSN.
    • SSN is required if the principal is also a company employee, as indicated on the employee census for the plan year. If Is Not Employee is selected in this window, an SSN is not required.
  4. (optional) Select Is Not Employee and/or Officer if applicable.
  5. Select a Title and enter an Ownership Percentage.
  6. Select Save. The new principal entry is added to the grid.

 

To make changes to a Principal record, hover over its entry in the grid and select Editedit.png or Deletedelete.png on the right-hand side.

 


 

Family View

 

The Family view contains the names and details of any employees who are related to company principals.

 

Name The full name of the individual.
SSN

The family member's Social Security number.

  • This information is used to connect this family member to an individual on the employee census.
Relationship

The family member's relationship to the principal.

  • Options are defined by List Values, under Core > Client\Employer > Family Relationship.
Related To The principal this individual is a relation of.
Columns on the Family grid

 

Adding & Editing Family Data

 

Requires Security Rights: Add/Edit Client

 

To add a new Family entry:

 

  1. Select Addadd.png at the top-right of the Family grid. The corresponding window displays.
  2. Enter the family member's Name and SSN.
  3. Select their Relationship to the principal, and who they are Related To.
  4. Select Save. The new family entry is added to the grid.

 

To make changes to a Family record, hover over its entry in the grid and select Editedit.png or Deletedelete.png on the right-hand side.

 


 

Other Businesses View

 

The Other Businesses view records the business information of any additional companies that a principal has an ownership stake in.

 

Name The name of the company.
EIN The company's EIN.
Address, City, State, Zip The company's address information.
Number The company's phone number.
Qualified Whether or not the company is a qualified plan sponsor.
Has Employees Whether or not the company has employees on staff.
Columns on the Other Businesses grid

 

Double-clicking on a company in the Other Businesses grid displays the owners of that company. Use the breadcrumb links at the top-left of the Owners grid to return to Other Businesses.

 

Name The full name of the individual.
Percentage Owner The individual's ownership percentage.
Columns on the Other Businesses > Owners grid

 

Adding & Editing Other Businesses & Owners

 

To add a new company to Other Businesses:

 

  1. Select Addadd.png at the top-right of the grid. The corresponding window displays.
  2. Enter the Company Name.
  3. Select the Entity Type and whether the company is Qualified Plan Sponsored.
  4. (optional) Complete the remaining fields as needed.
  5. Select Save. The new company is added to the grid.

 

To add an owner for an Other Business:

 

  1. If needed, double-click an entry in the Other Businesses grid to view its owners.
  2. Select Addadd.png at the top-right of the Owners grid. The corresponding window displays.
  3. Enter the owner's Name and ownership Percentage.
  4. Select Save. The new owner is added to the grid.

 

Both Other Business and Owners can be managed by hovering over the entry in the appropriate grid and selecting Editedit.png or Deletedelete.png on the right-hand side.

 


 

Employer Data and Annual Data Collection

 

Tier Availability: Team, Business

 

Using Data Collection via PlanSponsorLink will greatly simplify the management of Employer Data—largely as much of it will be entered by the Plan Sponsor directly. Employer Data integrates with Annual Data Collection in the following ways:

 

  • When Annual Data Collection is launched, if an Employer Data record doesn't already exist for the plan year, it will be created.
    • Additionally, if Employer Data was added for the previous plan year, it will be rolled forward to the new plan year.
  • Updates made by a Contact in PlanSponsorLink will be reflected in the Employer Data record immediately.
    • This is also true if an Employee updates the Data Collection in PensionPro.

 

For more information, refer to the article Data Collection - Annual Data Collection.

 


 

Importing Employer Data via Power Tools

 

Some Employer Data can optionally be imported into PensionPro from a spreadsheet file. This option can be useful for backfilling older company data or adding information such as the EIN in cases where Data Collection won't be used.

 

Note: Only information found on the Company View of Employer Data can be imported at this time.

 

For more information, refer to the article Data Import - Employer Data / Company Information.