Illinois certified payroll upload files (IDOL)

Build the import file for IDOL's Certified Transcript of Payroll portal from your payroll data, one project per file. A person signs in, uploads, attaches the fringe document, and certifies.

IDOL import: Sample Project 01 (sample)
1 to fix before upload
Full-CTP-Upload: one row, by column
A PayrollStart 03/01/2026
B PayrollEnd 03/07/2026
D ProjectNumber Sample 01
AQ Last4SSN 0000
AT WorkClassification Carpenter
AU GeographicDivision ALL
AV ClassType BLD
BE Race (blank)
BH IsaVeteran 0
BR WednsdayPrevailingHoursWorked 8
BX SatdayPrevailingHoursWorked 0
CX NoWorktoReport 0

Wednsday and Satday are IDOL's own header spellings.

File checks
CheckResult
Projects in file1 project
Headers102 of 102
Race, veteran1 blank
ClassTypeValid
Fringe documentPerson attaches

ClassType options: ALL, BLD, FLT, HWY, O&C, RIV.

Sample data. Every name and number here is made up.

How it runs.

Illinois wants certified payroll filed by the 15th of the next month, by project. IDOL's template has 102 columns, and prior-month payrolls cannot be withdrawn after the 15th.

  1. Payroll by project

    Daily hours, rates, fringe amounts and worker details for each project.

    Your data
  2. Build the import

    IDOL's template columns, then checks for blanks, classifications and hour totals.

    Automated
  3. A person uploads, certifies

    Staff use the company's Illinois Public ID, attach the fringe document, and certify.

    A person
  4. CTP number saved

    Staff save the CTP number beside the file and project.

    Automated

IDOL Certified Transcript of Payroll portal / Illinois Public ID / Full-CTP-Upload template / Fringe Benefit Affidavit / Payroll system export

The rules and limits.

CSV or Excel
IDOL posts an Excel template. Its 2026 training says Full Import needs a CSV that follows the template's column names. Test one real file before relying on either.
One project, one company
Payroll goes in by individual project, never several in one file. Two companies need separate logins, each through an Illinois Public ID account.
Template columns
Full-CTP-Upload has 102 columns for use from July 1, 2025, including GeographicDivision, ClassType, ClassCode, HourlyOtherInsurance, AddOT15 and AddOT20.
The 15th
File in IDOL's database by the 15th of the following month. After the 15th, prior-month payrolls cannot be withdrawn. Keep supporting records 5 years.
Worker data
Race, ethnicity and veteran fields are in the template. If you do not know them, IDOL says to ask your employees, because the Act requires the information.

What a person does.

  • Sign in with the company's own Illinois Public ID and upload.
  • Attach the fringe benefit document unless it is a No Work Report.
  • Check the Review Page, then type your name to certify.
  • Request any withdrawal before the 15th cutoff.

Where we stand: we have not shipped this. Your staff upload each file and certify it under your company's login. We would not sign in.

Common questions.

Does IDOL want CSV or Excel?+

Its posted template is an Excel file and its FAQ says Excel template. Its 2026 training slides say Full Import requires a CSV. We would build to the template's columns and test one real file first.

Can someone else file for our company?+

IDOL's FAQ says each company needs its own login and recommends every contractor file its own payroll, because liability stays with that contractor. It does not address outside payroll firms. Ask IDOL.

Does this make us compliant?+

No. It prepares a file in IDOL's format. Rates, classifications and the certification stay with you, and you remain responsible for what you certify.

Sources

General information, not legal, tax, or compliance advice. Rules change; confirm against the current source and your own advisers.

Bring us your version of this.

Intro calls are 30 minutes, free, and useful even if we never work together. We'll be honest about whether this is the right fit for your construction team.