Skip to Main Content

Contributions Supported File Formats - Unemployment Insurance

Supported Wage and Contribution Formats

  1. Federal (mmref-1) Wage Format
  2. Maryland (34-character) Wage Format
  3. Maryland (80-character) Wage Format
  4. ICESA Wage Format
  5. Contributions (Tax) Format

Federal (mmref-1) Wage Format

Record Length – 512

LOCATION FIELD LENGTH DESCRIPTION
1 - 2 Record Identifier 2 Enter "RS"
3 – 4 State Code 2 Enter "24" to indicate a Maryland Wage; otherwise, the record will be ignored.
10 – 18 Employee’s SSN 9 Enter the employee’s SSN. If unknown, enter all 1s. Numeric only. Omit hyphens, and spaces.
19 – 33 Employee’s First Name 15 Enter the employee’s first name. Left justify; fill with spaces.
34 Employee’s Middle Initial 1 Enter the employee’s middle initial. If no middle initial, leave blank.
49 – 68 Employee’s Last Name 20 Enter the employee’s last name. Left justify; fill with spaces.
197 – 202 Reporting Period (MMCCYY) 6 Enter the last month and year for the calendar quarter for which this report applied: E.G. "032000" for Jan – Mar 2000.
203 – 213 State Quarterly UI Total 11 Enter employee wages; right justify and zero fill. Numerics only. Do not include decimals or commas. (E.G. $17,077.74, enter 00001707774).
248 – 267 State Employer Account Number 20 Enter your Maryland Unemployment Insurance Account Number. The first 10 positions must be entered as zeros. Starting with position 258 enter your 10 digit Maryland Unemployment Insurance Account Number. All Maryland Unemployment Account Numbers start with 2 zeros. For example: if your Maryland Unemployment Account Number is 0012345678 it must be entered in positions 248 to 267 as 00000000000012345678. Omit hyphens, spaces, right justify.

The Revised Federal Format is taken from the SSA Publication MMREF-1 dated July 2000. Maryland requires data as described above and will ignore other locations.

Maryland (34-character) Wage Format
(must be readable by IBM compatible PCs running Windows operating system 1995 or later)

Record Length – 34

LOCATION FIELD LENGTH DESCRIPTION
1 – 10 Employer Account Number 10 As assigned by State Of Maryland. THIS NUMBER IS NOT YOUR FEDERAL ID#, OR YOUR CENTRAL REGISTRATION NUMBER.
11 - 13 Reporting Period YYQ 3 Enter the last 2 digits of the year and the quarter number i.e. 041
14 - 22 Employee Social Security Number 9 All numeric 111111111, if unknown.
23 Employee Initial 1 First letter of the first name.
24 - 26 Employee’s Last Name 3 Only the first 3 letters of the last name (omit hyphens, apostrophes or special characters)
27 Blank 1 Blank
28 - 34 Employee’s Wages 7 Total wages paid for the quarter in question (zero fill). Cents of 49 or less, round down to the lowest whole dollar. Cents of 50 or more, round up to the next whole dollar. Example of wages, $255,429.50 report as 0255430

Maryland (80-character) Wage Format
(must be readable by IBM compatible PCs running Windows operating system 1995 or later)

(THIS FORMAT IS NOT VALID FOR FTP FILING)

Record Length – 80

LOCATION FIELD LENGTH DESCRIPTION
1 Blank 1 Must Be Blank
2 - 11 State Employer Account Number 10 Enter the 10-digit employer account number assigned by the State of Maryland. 1st two digits are 0’s. Omit hyphens, spaces.
12 - 14 Reporting Period (YYQ) 2 Enter the last two digits of the year and the calendar quarter (e.g., 153)
18 - 26 Employee's SSN 9 Enter the employee’s SSN. If unknown, enter all 1’s. Numeric only. Omit hyphens and spaces.
27 Employee's First Initial 1 Enter the 1st character of first name.
29 - 31 Employee's Last Name 3 Enter the 1st three characters of last name. Omit hyphens and apostrophes.
33 - 40 State Quarterly UI Total 8 Enter the employee’s wages. Right-Justify and zero-fill. Numeric only. Do not include decimals or commas. (e.g., $8,009.49, enter 00800949)
67 - 70 Constant 4 Enter 9999
71 - 80 Blanks 10  
81 End of Line 0 Enter a carriage return (Enter Key)

FTP Maryland ICESA Format S Record – Employee Format

Record Length – 275

LOCATION FIELD LENGTH DESCRIPTION
1 Record Identifier 1 Enter "S"
2 – 10 Social Security Number 9 Enter the employee’s SSN. If unknown, enter all 1s. Numeric only. Omit hyphens, and spaces.
11 – 30 Employee’s Last Name 20 Enter the employee’s last name. Left justify; fill with spaces.
31 – 42 Employee’s First Name 12 Enter the employee’s first name. Left justify; fill with spaces.
43 Employee’s Middle Initial 1 Enter the employee’s middle initial. If no middle initial, leave blank.
44 – 45 State Code 2 Enter "24" to indicate a Maryland Wage; otherwise, the record will be ignored.
64 – 77 State Quarterly UI Total 14 Enter the employee’s wage. Right justify and zero fill. Numeric only. Do not include commas. (E.G. $38,994.17, enter 00000003899417).
147 – 156 State Employer Account Number 10 Enter the 10-digit employer account number assigned by State of Maryland. 1st two digits are 0s. Omit hyphens, spaces.
215 – 220 Reporting Month and Year 6 Enter the 2 digit month and 4 digit year for the calendar quarter for which the report applies, E.G. "031999" for Jan – Mar 1999. Format is MMYYYY.
221-275 Data Fields Not Used by DLLR 55 Must be filled with spaces.

Contribution (Tax) Reporting (Employer contribution return) – Employee Format

Record Length – 155

LOCATION LENGTH DESCRIPTION PICTURE
1 - 14 14 BLANKS X(14)
15 1 Remit Type - constant "1" 9(1)
16 - 24 9 Remit Amount. 9(7)V99
25 -34 10 MD U.I. Employer Number. 9(10)
35 - 37 3 Year Quarter (YYQ) 9(3)
38 - 41 4 Rate (format 2.5% - 0250). 99V99
42 - 46 5 Employment 1st Month (for zero employment, use "00000) S9(5)
47 - 51 5 Employment 2nd Month (for zero employment, use "00000) S9(5)
52 - 56 5 Employment 3rd Month (for zero employment, use "00000) S9(5)
57 - 67 11 Total Wages Paid by Employer 9(9)V99
68 - 78 11 Excess Wages (wage base = $7,000 through 12/31/92; $8,500 as of 1/1/93). 9(9)V99
79 - 89 11 Taxable Wages (Total Wages less excess wages). 9(9)V99
90 - 98 9 Computed Tax (Taxable wages times rate). 9(7)V99
99 1 Wage report code (constant 0). X(1)
100 - 155 56 BLANKS X(56)