Skip to Content

Simple 5 Column Spreadsheet Layout for CD or Diskette

  • STANDARD CD OR 3.5" DISKETTE
  • PC FORMAT
  • SPREADSHEET FILE
  • NO HEADINGS OR TOTALS
COLUMN DESCRIPTION
A - SOCIAL SECURITY NUMBER 9 TEXT CHARACTERS
NO DASHES/HYPHENS
(SS# 012-34-5678 EX. 012345678)
B - EMPLOYEE NAME UP TO 27 TEXT CHARACTERS/SPACES
LAST, FIRST, MIDDLE INITIAL
(JOHN A. DOE EX. DOE JOHN A)
C - TOTAL WAGES UP TO 11 NUMERIC CHARACTERS
WITH TWO DECIMAL PLACES
NO ZERO WAGES OR NEGATIVE WAGES
($100.00 EX. 100.00)
D - QUARTER YEAR 3 TEXT CHARACTERS
1 DIGIT FOR QTR., 2 DIGITS FOR YR.
(1ST QUARTER OF 2007 EX. 107)
E - ACCOUNT NUMBER 8 TEXT CHARACTERS
NO DASH/HYPHEN
(ACCT# 0012-345 6 EX. 00123456)
  • THE EXTERNAL LABEL SHOULD INCLUDE THE FOLLOWING INFORMATION:

    TENNESSEE EMPLOYER ACCOUNT NUMBER
    QUARTER/YEAR
    CONTACT PERSON'S NAME AND PHONE NUMBER
  • THE PREMIUM REPORT, THE WAGE REPORT, THE CD OR DISKETTE, 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/DISKETTE" ON THE BOTTOM OF THE WAGE REPORT.
IF YOU HAVE ANY QUESTIONS ABOUT REPORTING ON CD OR DISKETTE, PLEASE CALL 615-741-3280.