Payroll Data Exchange Information

You must have Microsoft Excel, a Windows operating system and a modem. Kinol Sharie Leyh & Associates will provide you with a Microsoft Excel spreadsheet that is pre-formatted. Please do not make any changes to this format. The following information is included on the spreadsheet for each payroll:
column A - payroll date
column B - name
column C - social security number
column D - deferral amount
column E - match amount
column F - wages earned for that pay period
column G - hours worked for that pay period
column H - hire date
column I - termination date (if applicable)
column J - gender
column K - date of birth.

After above information is entered into the Excel spreadsheet the file should be saved using the following naming convention; first three letters of Company name, the payroll date and .xls extension. i.e. If your Company name is Smith, Inc. and the payroll date is August 26, your file name should be: SMI0826.XLS.

For new clients, we will request a YTD payroll file prior to processing the first payroll with 401(k) deferrals.

Each Data Exchange can be performed via the internet. Kinol Sharie Leyh & Associates internet address is tpa1@kslassociates.com or tpa2@kslassociates.com. When your Excel file is ready, send to our address and call to let us know that the file is ready.

Upon completion of the data transfer, we will confirm the total 401(k) deferral and match for each pay period with you. At this time you can then prepare a check made payable to Alliance Fund Services, Inc. and mail to the address found at the bottom of this screen.