Wage Report Formatting

Simple 58 Character Text Layout for CD

  • Standard CD 
  • PC Format
  • Same as Plain Text File
  • No Headings or Totals
  • No Delimiters

The external label should include the following information:

Tennessee Employer Account Number
Quarter/Year
Contact Person's Name and Phone Number

The premium report, wage report, cd, and your check must be mailed together. In lieu of the items being listed on the wage report, mark the notation "Wages reported on CD" on the bottom of the wage report.

Questions? Call us at  615-741-3280.

Column Description
 SOCIAL SECURITY NUMBER 9 TEXT CHARACTERS
NO DASHES/HYPHENS
(SS# 012-34-5678 EX. 012345678)

EMPLOYEE NAME
27 TEXT CHARACTERS/SPACES
LAST, FIRST, MIDDLE INITIAL
(JOHN A. DOE EX. DOE JOHN A)
Please do no use punctuation or space between last two names.
TOTAL WAGES 11 TEXT CHARACTERS
NO DECIMALS OR COMMAS 
NO ZERO WAGES OR NEGATIVE WAGES
($100.00 EX. 00000010000)
QUARTER YEAR 3 TEXT CHARACTERS
1 DIGIT FOR QTR., 2 DIGITS FOR YR.
(1ST QUARTER OF 2007 EX. 107)
ACCOUNT NUMBER 8 TEXT CHARACTERS
NO DASH/HYPHEN
(ACCT# 0012-345 6 EX. 00123456)

Abbreviated ICESA Format for Wage Reporting 

Data must be sent in ASCII Text Format.
All Records must have carriage return/line feed.
External Label must be included with employer name, quarter year and contact person's name and phone number.

The premium report, wage report, cd, and your check must be mailed together. In lieu of the items being listed on the wage report, mark the notation "Wages reported on CD" on the bottom of the wage report.

Questions? Call us at  615-741-3280.

 

E-Record

Location Field Name Length Type Description
1 - 1 Record Identifier 1 A/N Constant "E" --denotes E record
2 - 5 Payment Year 4 A/N 4 digit year of the report being prepared
6 - 14 Federal EIN 9 A/N Numeric characters only--Omit hyphens or other editing
15 - 160 Filler 146 A/N Enter spaces
161 - 162 Blocking Factor 2 A/N Must be "25"
163 - 170 Filler 8 A/N Enter spaces
171 - 172 State Identifier Code 2 A/N Must be "47" for Tennessee employers
173 - 180 TN Unemployment Insurance Employer Account Number 8 A/N 8-digit number employer account number found on the quarterly premium report--Omit any hyphens or other editing
181 - 187 Filler 7 A/N Enter spaces
188 - 189 Reporting Period 2 N Enter the last month of the calendar quarter to which the report applies:
"03" --- First quarter
"06" --- Second quarter 
"09" --- Third quarter
"12" --- Fourth quarter
190 Filler 1 A/N Enter zeros
191 - 275 Filler 85 A/N Enter spaces

 

S-Record

Location Field Name Length Type Description
1 - 1 Record Identified 1 A/N Constant "S" -- denotes S record
2 - 10 Social Security Number 9 A/N Employee's social security number--if not known enter "l" in position '2' and blanks in positions '3' - '10'
11 - 30 Employee's Last Name 10 A/N Employee's Last Name (no punctuations or space between 2 last names)
31 - 42 Employee's First Name 12 A/N Employee's First Name (no punctuation)
43 - 43 Employee's Middle Initial 1 A/N Employee's Middle Initial
44 - 45 State Code 2 A/N Must be '47' for Tennessee employees
46 - 49 Filler 4 A/N Enter Blanks
50 - 63 Filler 14
N
Enter Zeros
64 - 77 Employee's Quarterly Unemployment Insurance
Total Wages
14 N Enter quarterly wages subject to unemployment taxes--include tips, 401k, cafeteria plans, etc.
78 - 275 Filler 198   Enter spaces

 

F-Record

Location Field Name Length Type Description
1 - 1 Record Identifier 1 A/N Constant "F" - denotes F record
2 - 275 Filler 274   Enter spaces

 

The premium report, wage report, cd, and your check must be mailed together. In lieu of the items being listed on the wage report, mark the notation "Wages reported on CD" on the bottom of the wage report.

Questions? Call us at  615-741-3280.