EAMS is the Employer Account Management System for filing quarterly wage reports and paying unemployment taxes. If you’re eligible to upgrade, you’ll see an upgrade alert after logging in. We are gradually making this upgrade available to all customers in time to file fourth-quarter reports. The updated EAMS is designed to perform better and improve your experience. Show
If you submit files in bulk or if you need to make amendments to your report: How to upgrade to the new EAMS
Learn more about the upgrade:
2. Update your files and software with our new payment addresses. The Employment Security Department (ESD) changed to U.S. Bank for unemployment insurance taxes and benefits. As a result, our payment addresses for employers also changed. Please update any processes, forms, files or software with these new addresses by Dec. 31, 2022. 3. Stay informed about issues important to employers. Sign up for our newsletter and see past issues.
The information on this page:
Data file formats we acceptEAMS accepts wage data import files created in any of the following data file formats:
Data file formats we do not acceptUpgraded EAMS does not accept wage data import files created in any of the following data file formats:
Editing your data in MS Excel (or another spreadsheet tool) to create an import file in any data formatIf you are preparing your own wage data file — regardless of which data file format you want to import — you will likely find it easiest to use Microsoft Excel, Google Sheets, or another spreadsheet tool. Your spreadsheet must have the following eight columns. Three of the columns must contain data. The columns marked with an asterisk are required, meaning that they must be populated with data for each wage record row.Do not include any extra columns, headers, footers, totals, notations, explanatory comments, etc., in the spreadsheet. Social Security number (SSN) or Individual Taxpayer Identification Number (ITIN) *Last Name First Name Middle Name Suffix *Hours *Gross Wages This field requires a positive number and will accept a decimal point. If one is entered, you will be permitted to include two digits to the right of the decimal (e.g., ‘12345.67’). If you do not enter a decimal, the system will assume that the amount you entered is a whole number and it will add a decimal point followed by two zeros (e.g., ‘12345’ is interpreted as ‘$12,345.00’). Do not enter a negative value. SOC Saving your spreadsheet in comma-delimited (.csv) formatNote: The following instructions are for Excel. Directions for other software tools will vary slightly. To convert your data from a spreadsheet into a comma-delimited file:
Comma-delimited (.csv) format exampleYour .csv format file will look something like this: 400-11-1111,Pink,Janet,A,Jr,400,98765,111021 402-22-2222,Brown,John,B,,456,87654.01,439199 403-33-3333,White,James,C,Sr,500,76543.15 404-44-4444,Black,Joe,D,,501,65432.20 405555555,Red,Jill,,III,502,44444 Saving your spreadsheet as an Excel spreadsheetNote: The following instructions are for Excel. Directions for other spreadsheet tools will vary slightly. To save your data as an Excel spreadsheet:
Excel exampleFiles of each of the approved data file formats can be created in Microsoft Excel, Google Sheets, or another spreadsheet tool. If you plan to submit an Excel spreadsheet, your data will look something like this sample; if you are converting your file to a different format, your data will look something like this before you convert it. 400-11-1111 Pink Janet A Jr 400 98765 111021 402-22-2222 Brown John B 456 87654.01 439199 403-33-3333 White James C Sr 500 76543.15
404-44-4444 Black Joe D 501 65432.20
405555555 Red Jill III 502 44444
Saving your spreadsheet in tab-delimited text (.txt) formatNote: The following instructions are for Excel. Directions for other spreadsheet tools will vary slightly. To convert your data from a spreadsheet into a tab-delimited text file:
Tab-delimited text (.txt) format exampleYour .txt format file will look something like this: 400-11-1111 Pink Janet A Jr 400 98765 111021 402-22-2222 Brown John B 456 87654.01 439199 403-33-3332 White James C Sr 500 76543.15 404-44-4444 Black Joe D 501 65432.20 405555555 Red Jill III 502 44444 Error messages and warning messagesWhen you import a file, edits are automatically performed on the imported data. Three scenarios can unfold, depending on what kinds of problems are found, if any.
Maximum recordsThe maximum number of records that can be imported in a single filing is 5,000. If you have more than that number of records, consider bulk filing in EAMS. Or, you can split your file into segments that each contain up to 5,000 wage records, and submit them in succession. |