If you are using Simpluris as your third party administrator to make Safe Harbor payments, you will need to export two Excel files. The first file will include the employee information (name/address/SSN/payment amount) and the second file will include the pay period data for Simpluris to use for the required statement that must accompany the payment.
Follow the workflow and instructions in our prior blog post here. When you get to the point where you are exporting the statement data, use the “Standard AB 1513 Statement Export” definition. When exporting this file, be sure to use a “.xlsx” extension on the filename. (This is a newer file format that supports more rows than the older “.xls” format.)
When you export the Safe Harbor Employee information, use the “Simpluris Export” definition. Column P in the employee file will contain the payment amount. To verify that the correct total payment amount has been exported to the file, open the file in Excel and add a sum formula on Column P and verify that this matches your Create Checks report. (Be sure not to save the spreadsheet with the sum formula included!)
Both of these export definition files are included with the latest program update. If you do not see the definition files when you try to import the definitions, download the latest update using the Tools->Check for Updates option.
If Simpluris has not already sent you the instructions for setting up an account on their secure file upload service, request the instructions, create and account, then upload these files after you have verified the payment totals contain in them are correct.