When submitting your employee payroll contributions, you have three options for entering that information:
- Manually enter the required data directly into the contribution grid
- Upload a payroll file (or Download template)
- Copy contribution details from the previously completed payroll contribution submission of the same type, e.g., regular or off-cycle.
In this article we will review how to submit contributions by uploading a file into ProgramPay.
If you have many employees or are downloading a contribution file from your payroll system, uploading a file may be the best approach.
When submitting your contributions, you may choose to upload your own excel file from your computer OR download the pre-populated default template in the upper right corner of the grid to populate contribution and loan payments.
File Upload
Sample Download
The below template will download to your computer after selecting "Download" in the upper right corner of the grid. The template already includes the proper headers and formatting required to easily upload and process contributions.
Formatting Your Contribution File:
If you use the Download feature in ProgramPay, you will receive a Microsoft Excel file that is formatted with all the required and optional column headers. It will be pre-populated with participant names, social security numbers, and if applicable, loan information.
Then, update the file with the other contribution details before uploading it into the portal.
If you are using your own contribution excel file from some other source, please consider these requirements for the best experience:
- Your file must be in Excel or CSV format,
- Your file is required to have columns that contain:
- Social Security Number (SSN) - Formatted with or without dashes
- First Name - First and Last must be in two separate columns
- Last Name - First and Last must be in two separate columns
- Include the appropriate contribution columns for your plan (Pre-Tax, After-Tax, Safe Harbor, Employer Discretionary, etc)
- If the participant is contributing or repaying a loan, this amount must also be in its own column. Please see this article for further information about what column headers to use
- Column header names don't need to be an exact match. ProgramPay will recognize a wide variety of nomenclature. If your column heading is not recognized, you'll be asked to map it during the upload process
- If you have other columns on your payroll file, that’s okay; those will be ignored in the upload process. Just be sure to include the required columns noted above
- Missing information or other errors will restrict you from continuing until all are corrected. You'll be prompted to make corrections in the contribution grid in the portal.
Once your file is formatted correctly, you are ready to begin:
- Click on “Upload Payroll File”
- Select the appropriate file from your device’s File Manager or Finder
- If all required columns aren't recognized, you will be asked to map a column from your file to ProgramPay's required headers.
- Click the drop down to select from available columns.
- Click on link to see how all columns were matched.
- Uploading can take several seconds; please be patient.
- Once uploaded, the system will verify that all required data was included in the file.
-
On the contribution grid you can sort any column by clicking on that column header (please see below image). After you enter the contribution values, click on the column header and you will see an arrow up or down. Click again one the same column header to change the direction of the sorting. This feature is applicable to all column headers.
- The columns will sort by:
- Greatest value to least value
- Least value to greatest value
Once complete, review the contribution totals summarized at the bottom of the screen
- To continue, please click on the blue “Send & Validate” button. Notice that if the button is still gray, there may be missing or invalid information.
- If there are errors in the uploaded data, the problematic fields will be highlighted in red. During this step, errors are based on missing or poorly formatted data and unrecognized participants.
- You will not be able to proceed to the next step until all red boxes are resolved. Click on each red box to learn how to proceed. You will have the option to resolve the issue or exclude the row in order to proceed.
- If your file contains any unrecognized participants, you will have the option to add them during this step. To learn how to add new participants during the contribution process, click here.
- ProgramPay also evaluates your contribution submission for any unallowable contributions. If unallowable contributions are detected you will be redirected to the Unallowed Contribution screen for more information. Learn more about unallowable contributions here.
- Once you've reviewed and taken note of any Unallowed Contributions, press Save & Continue to move on to the next step.
- On the Review Submission page you will have the opportunity to take several actions:
- "Complete Submission" = Fully submit the contributions for further processing in the record keeping system
- "Edit Submission" = Go back and make further edits to the submission
- "Cancel" = Delete the submission and start over
Note - Just below the "cancel submission" button, there is an "On/Off" toggle that can be used to view Employees with $0 contributions. If the switch is On, the Contribution Details will include employees who have not contributed in the submission. If the switch is Off, you will only see employees who have contributed.
As the "Contribution Details" provides a brief summary of the submission on the Review Submission page, you may use the pagination feature to view the remainder of participants and their contributions (as seen below).
If you do not need to make any edits to the contributions and are ready to submit, select Complete Submission and the following screen will pop up as a confirmation that you have successfully submitted the contributions for further processing.
Click the "Back to Transaction" button and you will be returned to the Contribution Dashboard.
Additional Formatting Tips for your File Upload:
- The file should include one row for every employee at your company who has been paid in the current year. You can remove terminated employees, but make sure you submitted them with a Date of Termination at least once so we may update our records accordingly.
- To save time on the next submission, save the file on your computer in an easily accessible place. You can simply open it up during your next submission, make any necessary changes, and upload.
Need help?
Please contact: contactus@abaretirement.com for further assistance.