This article describes how to configure a client for the Merrill Lynch (Bank of America) Deduction Feedback to PrimePay GPAY moov definition used for 360 integration. Each client configuration will vary based on their plan specification and will need to be configured accordingly.
Merrill Lynch Feedback File Format
The Merrill Lynch feedback file is a fixed length format where multiple deductions appear on a single record. For example, the Pre-Tax, Post-Tax and Catch Up deductions are all on the single 10 Record. The positions for each deduction will include either the amount/percent the employee elected, or the position will be zero-filled. detamoov cannot determine if a zero-filled position denotes the employee ending a deduction, or that they have not opted into the deduction. Because of this detamoov will send zero-filled records to payroll as an ended deduction. You have the ability to filter out certain deduction codes during the moov. These directions are available in the Filter Overrides section further on in this article.
To add a moov to your account, click on moovs on the left hand menu and click the ADD button in the upper right.
Then expand the Retirement - Retirement to Payroll panel, select the moov you wish to adopt and click the USE THIS MOOV button on the right.
Merrill Lynch (Bank of America) may send a 11 Record which includes bonus deduction changes. detamoov doesn't send these updates and they are filtered out of the file send to payroll. During the validation step, we will notify you if an 11 Record is found on the feedback file. To ensure that you receive the notification, configure the Validation Step and provide an email address and reply to address.
To configure the 11 Records validation step, click the cog icon on Step 3: Action - Validate File and toggle the 'Use default parameters' switch off. Then enter one or more email addresses into the 'Send results to email addresses (comma separated) field, and one email address in the 'Reply To' field. Then click Save Changes.
Validate file for Catch Up and Roth Bonus
Merrill Lynch (Bank of America) may send a Roth Bonus on the 65 Record which includes bonus deduction changes. detamoov doesn't send these updates and they are filtered out of the file send to payroll. During the validation step, we will notify you if an a Roth Bonus amount is found on the 65 Record within the feedback file.
detamoov will also validate the feedback data coming from Merrill Lynch (Bank of America) for any Catch Up records. If a Catch Up record is found, a validation report will be sent and the Catch Up records will be filtered out of the data sent to PrimePay GPAY. These records are filtered out as a result of our implementation team being notified that Catch Up is automatically configured in PrimePay GPAY. To ensure that you receive the notification, configure the Validation Step and provide an email address and reply to address.
To configure the Catch Up and Roth Bonus validation step, click the cog icon on Step 5: Action - Validate File and toggle the 'Use default parameters' switch off. Then enter one or more email addresses into the 'Send results to email addresses (comma separated) field, and one email address in the 'Reply To' field. Then click Save Changes.
The Merrill Lynch (Bank of America) Deduction Feedback to PrimePay GPAY moov provides a notification once the moov is complete with a summary of the retirement plan changes that were made in PrimePay GPAY. The notification can be sent to any email address you wish and can also be configured to send to multiple email addresses.
To edit the send file step, click on the cog icon under the Action - Send File step on the left. Then toggle the "Use default parameters" off and enter in the email addresses you would like to receive the notification. If you would like to enter multiple email addresses, separate them with a comma. A Reply to email is also required in the event that a recipient of the notification replies to the email.
Note: these settings apply to any client configuration you set up for this specific moov. You also have the ability to configure the send file step for each client configuration if you wish to add or remove email addresses per client.
To save your parameters click on the Save Changes button.
In the moov configuration section, click the Add button to add a new client to the moov.
Client/Entity - either select an existing client or click the + sign to create a new client.
Status - Set to Active
Expected Frequency - the client's payroll frequency
File Name Starts With - SR[ML Plan Id]
(This value is generated by Merrill Lynch. Please confirm the exact file name to ensure the files for your client are pulled from their SFTP successfully)
File Name Contains -
Note: make sure that the File Name Starts with field matches as this can cause issues pulling the Merrill Lynch feedback file and updating PrimePay GPAY.
To automate the 360 integration, configure the SFTP schedule. Click the SFTP banner under the Trigger - SFTP Pull Data Trigger step and click Add.
On the New SFTP Configuration section on the right, select the SFTP Pull option from the Premier Integration menu. Then select either "Every X weeks" or "On certain days of the month", depending on how often you would like detamoov to check for new feedback files. We recommend that you check for feedback files at least twice a week. In the example below, we have set up a schedule to check for files twice a week on Tuesdays and Fridays.
Click OK once you have created your SFTP configuration.
The beginning of this article described the fixed-length format of the Merrill Lynch (Bank of America) feedback file and that deductions can be zero-filled. detamoov cannot determine if a zero-filled position denotes the employee ending a deduction, or that they have not opted into the deduction. Because of this detamoov will send zero-filled records to payroll as an ended deduction.
By default, the 401k PostTax records will be filtered out of the data sent to PrimePay GPAY. If your client's plan participates in a Post Tax deferral, you can remove the filter with an override. Otherwise, you can leave the filter as is.
To override the filter, locate the Step 8: Action - Filter, expand the Filter Overrides panel and click ADD.
Then select 'Filter 1: Deduction Code' from the dropdown menu and click ADD OVERRIDE.
In the Value In List of Values field remove the ",401k PostTax" value (make sure the preceding comma is removed) and click OK.
You can also filter out deduction codes if the plan does not participate in them. For example, if the plan has a PreTax deferral but not a Roth deferral, you can add '401k Roth' to the list of values to filter out.
The following is a list of the available codes you can use to filter out specific Deductions Codes from being sent to PrimePay GPAY:
401k
401k Roth
To filter out '401k Roth' records, click the ADD RULE button, select the Deduction Code field, select the Value Equals rule, enter '401k Roth' into the Compare Value field, and click OK.
Configure the PrimePay GPAY Retirement 360 Step
To configure the PrimePay GPAY Retirement 360 step for you client, locate the Action - PrimePay GPAY Retirement 360 step, expand the PrimePay GPAY API panel and click ADD.
On the side panel that appears, select your PrimePay GPAY Premier Integration and enter in the following credentials:
Employer Unique ID - the Employer # in PrimePay GPAY
Loan Deduction Codes - this field can be left blank as Merrill Lynch (Bank of America) sends loan changes in a separate feedback file
You can also enter in one or more email addresses in the Error Messages Email. If left blank, all detamoov users on your account will receive emails if the PrimePay GPAY API import fails.
Click OK to complete the PrimePay GPAY Retirement 360 configuration.
At the beginning of this article you configured the send file step for the moov to send a notification once the moov had completed. You also have the ability to configure the send file step for each client configuration if you wish to add or remove email addresses per client.
To override the send file step, locate the Action - Send File step and toggle the "Use default parameters" off and enter/remove email addresses from Email Address and Reply To fields. If you would like to enter multiple email addresses, separate them with a comma.
To complete the configuration for your client, click the Next button at the bottom of the page and then the Save button on the moov summary page.
Plans with Merrill Lynch (Bank of America) Loans
Merrill Lynch (Bank of America) sends the updates to loans in a separate file and requires that you configure the Merrill Lynch (Bank of America) Loan Feedback to PrimePay GPAY moov. If your client's plan has loans, please see the How to configure the Merrill Lynch (Bank of America) Loan Feedback to PrimePay GPAY moov article.
