Employers can upload formatted wage file through KansasEmployer.gov.
Requirements:
- Employer must be registered with KansasEmployer.gov
- Employer must be able to format your wage data to the required file specifications
Note about spreadsheet uploading: Employers can now upload employee wage data from a properly formatted Microsoft Excel spreadsheet for filing their Quarterly Wage Reports. The spreadsheet data (including Social Security numbers, employee names and gross wages) can be imported to our secure Internet Web form, which can then be reviewed for errors and calculated prior to submitting the report. Up to 4,000 employees can be imported on a spreadsheet. The spreadsheet upload serves as a time-saving alternative to the manual data entry for KDOL’s online Web form.
Microsoft Excel Spreadsheet
Note: Tax contribution information is automatically calculated for you. You can make your tax payment online as well.
MMREF-1 Technical Specification:
The Kansas Department of Labor will accept the MMREF-1 file format used by the Social Security Administration. We only require the records and fields that we need. Any record or field that is not required by the Kansas Department of Labor will be IGNORED. The layout defined below indicates only the fields required by the Kansas Department of Labor. For a complete specification you can visit the Social Security Administration website. Please review KDOL’s specification carefully to determine exactly what records and fields are required.
The following requirements apply to the entire file:
- Must be readable.
- Must be ASCII text data format.
- Must not put your organization over the 100MB maximum submission per day.
- All Records must be 512 characters in length (each record is a separate line ended by CR LF)
- Must have at least one RA, at least one RE, and at least one RS record.
- File must be of type zip, gz, bz2, txt, or dat. All other files will be rejected. Any compressed file must be of type txt or dat after it is decompressed. Any compressed file can only contain one file.
- File name must be less than 75 characters.
- File must not exceed 5MB. If a file is larger than 5MB then we suggest either compressing it using zip, gz, or bz2 or breaking it up into multiple files.
The following requirements apply to employers:
- Individual fields must meet the minimum format (use layout below to determine).
- Wage detail will not be accepted for future quarters. For example, data will be not be accepted for 3rd quarter of 2018 in January of 2018.
- Total taxable wages must not exceed total wages.
- Individual employer record must not contain greater than 99 employee records with no SSN.
- Employer account must be currently active.
- Total wages must not exceed $1,000,000. Employees whose earnings exceed $1,000,000 must be broken down into multiple records that are less than $1,000,000.
- Each employer can only be submitted once per quarter.
- If any individual Employee Records (RS) do not meet the minimum data requirements, the entire Employer Record (RE) will be rejected.
- If multiple Employer Records (RE) are being submitted, the Employee Records (RS) for an employer must be grouped directly under the Employer Record (RE).
NASWA File Technical Specification:
The Kansas Department of Labor will accept the NASWA (formerly ICESA) file format. KDOL only requires the records and fields that we need. Any record or field that is not required by KDOL will be IGNORED. The layout defined below only indicated the fields required by the KDOL. Please review our specification carefully to determine exactly what records and fields are required.
The following requirements are used to reject an entire file:
- Must be readable.
- Must be ASCII text data format.
- Must not put your organization over the 100MB maximum submission per day.
- All Records must be 275 characters in length (each record is a separate line ended by CR LF)
- Must have only one Code A, only one Code B, one or more Code E, and one or more Code S records.
- File must be of type zip, gz, bz2, txt, or dat. All other files will be rejected. Any compressed file must be of type txt or dat after it is decompressed. Any compressed file can only contain one file.
- File name must be less than 75 characters.
- File must not exceed 5MB. If a file is larger than 5MB than we suggest either compressing it using zip, gz, or bz2 or breaking it up into multiple files.
The following requirements are used to reject individual employers:
- Individual fields must meet the minimum format (use layout below to determine).
- Wage detail will not be accepted for future quarters. For example, data will be not be accepted for 3rd quarter of 2018 in January of 2018.
- Total excess wages must not exceed total wages.
- Individual employer record contains greater than 99 employee records with no SSN.
- Employer account must be currently active.
- Total wages or Excess wages must not exceed $1,000,000. Employees whose earnings exceed $1,000,000 must be broken down into multiple records that are less than $1,000,000.
- Each employer can only be submitted once per quarter.
- If any individual Employee Records (Code S) do not meet the minimum data requirements, the entire Employer Record (Code E) will be rejected.
The Kansas Department of Labor will accept the Payment file format found below. The layout defined below only indicates the fields required by the Kansas Department of Labor. Please review our specification carefully to determine exactly what records and fields are required.
The following requirements are used to reject an entire file:
- Must be readable.
- Must be ASCII text data format.
- Must not put your organization over the 100MB maximum submission per day.
- All records must be 381 characters in length (each record is a separate line ended by CR LF).
- File must be of type zip, gz, bz2, txt, or dat. All other files will be rejected. Any compressed file must be of type txt or dat after it is decompressed. Any compressed file can only contain one file.
- File name must be less than 75 characters.
- File must not exceed 5MB. If a file is larger than 5mb than we suggest either compressing it using zip, gz, or bz2 or breaking it up into multiple files.
Click on any of the sample files below to download the corresponding zip file.