Recent Changes:

6.101 - Initial Creation

The CSV file format is used for importing the Schedule P, Illinois Withholding Payroll Schedule file directly to a Withholding account.

The CSV file format is as follows:

Field Name Max Length Data Type Description SmartFusion Source
EmployeeName 30 characters AlphaNumeric The full name of the employee. Do not enter periods after initials. For example, John R. Doe should be entered as "John R Doe". From hr180.cfirstname, hr180.cmi (middle initial), and hr180.clastname concatenated together.
SSN 9 characters Numeric The social security number of the employee. No hyphens are necessary. For example, 000-00-0000 should be entered as "000000000". From hrR180.cssn
Income 13 characters Numeric The employee's income for the quarter. Enter as unformatted dollars/cents. For example, $1,234.56 should be entered as "1234.56 and $1,234.00 should be entered as "1234". From a total of pr158.ystatewage
Withholding 13 characters Numeric The amount withheld on behalf of the employee for the quarter. Enter as unformatted dollars/cents. For example, $1,234.56 should be entered as "1234.56" and $1,234.00 should be entered as "1234". From a sum of pr158.ysttax