This article will describe how to use the default contributions upload template to submit contributions to your retirement plan.
What Is the Default Contributions Upload Template?
The default contributions upload template is a spreadsheet-based template that allows you to upload your contribution information into the contributions tool for processing. Essentially, it is a set of standard column headings that our system will automatically recognize when you upload your file. The order in which the columns appear is not important, only that you use the recommended column headings.
What Column Headings Should I Be Using?
The following column headings should be used for proper processing.
-
SSN - the Social Security Number of each employee. This is required.
-
First Name - first name of the employee.
-
Last Name - last name of the employee.
- Date of Birth - birth date of the employee.
-
Pre-Tax Contribution - the amount withheld from the employee’s paycheck for pre-tax retirement contributions.
-
Roth Contribution - the amount withheld from the employee’s paycheck for Roth retirement contributions.
- Catch-Up Contributions - Although there is no column for Catch-Up Pre-Tax nor Catch-Up Roth contributions, J.P. Morgan can accept catch-up contributions as part of existing Roth and Pre-Tax brackets.
-
Employer Mandatory Contribution (Safe Harbor) - an employer contribution in the form of either a mandatory matching amount or a mandatory non-elective amount based on a predetermined formula within the plan’s rules.
-
Profit-Sharing Contribution - used if your company is contributing profit-sharing funds to your employees’ retirement accounts. If your plan has profit-sharing, this column will be included in your template and grid view.
-
Loan Repayment - the amount an employee contributes to repay an outstanding loan from their retirement account. (If the employee has multiple loans, this should be the aggregate of all loan payments) If your plan has loan payments, this column will be included on your template and grid view.
-
Period Hours Worked - number of hours worked by the employee in this pay cycle.
- Period Gross Pay - the gross amount of pay earned by the employee in this pay cycle. (For off-cycle payments, please only include the supplemental payment amount.)
-
Date of Hire - the date the employee was originally hired. (If the Date of Hire is later than the Date of Termination, we will treat this as a rehire. However, if your payroll system allows, it is best to report the Date of Rehire separately so that we will have both the original hire date and the rehire date.)
-
Date of Termination - the date that the employee was terminated. (If an employee has been rehired and subsequently terminated again, provide the most recent Date of Termination.)
-
Date of Rehire - the date the employee was hired if they were employed by the company previously. (If an employee is rehired and subsequently terminated, the Date of Rehire should be left blank. If an employee has been rehired multiple times, provide the most recent Date of Rehire.)
-
Phone Number - phone number of the employee.
-
Address Line 1 - street address of the employee.
-
Address Line 2 - additional street address data for the employee.
-
City - city of the employee’s address.
-
State - state of the employee’s address.
-
Postal Code - postal code for the employee’s address.
- Work Email - work email of the employee.
- External Payroll ID - If used by your payroll provider.
Formatting Tips:
-
Social Security Numbers - the tool will accept the number with or without dashes.
-
Numbers - the tool will accept commas and dollar signs $, so no need to remove them.
-
Dates - are accepted in almost any format, such as mm/dd/yyyy, m/d/yyyy, m/d/yy, yyyymmdd, etc.
-
Phone Numbers - the tool will accept values with or without parentheses and dashes.
- Names - first name and last name must be in separate columns.
That seems like a lot of columns. How do I go about creating this file?
To streamline the creation of this file, we have included a template under the main contributions page. You can access it by selecting the Download button. The spreadsheet's first row will contain column headings and registered employees will be populated. Once you have revised and added the necessary data, you can save the template as an Excel (*.xls and *.xlsx) or CSV (*.csv) file.
Tips:
-
The file should include 1 row for every employee at your company who has been paid in the current year. You can remove terminated employees, but make sure you submit them with a date of termination at least once so we know they have been terminated.
-
To save yourself some time for your next submission, we recommend saving the file on your computer or shared drive in an easily accessible place. This way, you can simply open it up during your next submission, make any changes or additions, and upload.
If you have any questions, please reach out to us at everyday401k.success@vestwell.com.