You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Standard 401k to Wespath
print icon

This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the Wespath Format file specifications.  This transformation is used in a detamoov integration with Wespath.

 

Source File Destination file
Standard 401k Wespath

 

File Specifications

 

File Type Generated CSV
Header Row(s) Generated YES
Footer Row(s) Generated  
End of Row Character CRLF
File Naming Generated

[Plan ID]-[Payroll Check Date in MMddyyyy]-[GUID].csv

 

Field Mappings

 

The table below details the specific field mapping and transformation rules applied to ensure the Wespath Payroll Contribution csv format is created correctly from the standard 401k format.

 

Wespath Field Name Standard 401k Field Name Field Type Details
FEIN COMPANY EIN STRING NO DASHES
SSN SSN STRING NO DASHES
Payroll Date PAYROLL CHECK DATE DATE MM/DD/YYYY
UMPIP Plan PLAN ID STRING  
UMPIP BeforeTax CURRENT PAYROLL EMPLOYEE PRETAX NUMBER Remove $, separators, leave decimal
UMPIP Roth CURRENT PAYROLL EMPLOYEE ROTH NUMBER Remove $, separators, leave decimal
UMPIP AfterTax CURRENT PAYROLL EMPLOYEE POSTTAX NUMBER Remove $, separators, leave decimal
UMPIP Matching CURRENT PAYROLL EMPLOYER MATCH
CURRENT PAYROLL SH EMPLOYER MATCH
NUMBER SUM, Remove $, separators, leave decimal
UMPIP NonMatching   NUMBER Remove $, separators, leave decimal
UMPIP Conditional   NUMBER Remove $, separators, leave decimal
UMPIP Discretionary CURRENT PAYROLL NON ELECTIVE CONTRIBUTION NUMBER Remove $, separators, leave decimal
CRSP/RPGA Plan   STRING  
CRSP/RPGA NonMatching   NUMBER  
CRSP/RPGA Matching   NUMBER  
CPP Plan   NUMBER  
CPP Premium   NUMBER  
Horizon Plan   STRING  
Horizon NonMatching   NUMBER  
Horizon Matching   NUMBER  
Horizon BeforeTax   NUMBER  
Horizon Roth   NUMBER  
Loan Number 401K LOAN 1 ID NUMBER  
Loan Payment 401K LOAN 1 REPAYMENT NUMBER Remove $, separators, leave decimal

 

scroll to top icon