Certified Payrolls

TDOT is anticipating implementation of the certified payroll functionality in CRL during Spring 2021. This will allow payrolls to be imported and tracked in a singular database. Various payroll components will be calculated and checked in CRL, including pay rates, hours worked, OJT hours, etc. There are three methods to enter payrolls in CRL:

    (1)     Manual Entry – only recommended for small companies (≤10 employees);
    (2)     Excel Spreadsheet and Conversion – only recommended for smaller companies with no payroll system (≤50 employees);
    (3)     XML Export from your Company’s Payroll System – Recommended method for importing payrolls, takes the longest to develop but is the quickest method to import once developed.

The below resources may be used to develop an XML export from your payroll system. Limited access to a test environment of AASHTOWare Project CRL may be provided upon request to evaluate if the export developed from your payroll system is valid.

If your company is using a bought payroll system (“off the shelf”), please provide them with the below resources.

If you have questions or encounter any problems, please email TDOT.CONSTRUCTIONLaborUsers@tn.gov. If you have a question about an XML file specifically, please include the file with the email.

Certified Payrolls Resources:
Frequently Asked Questions

Excel Spreadsheet Resources:
Excel Spreadsheet Version 1.8 (Current) - Updated 10/13/22
Spreadsheet Conversion Tool (.xlsx to .XML)

XML Export Resources:
    XML Resource Kit from AASHTOWare (Template)
    XML Validation Tool from AASHTOWare
    Craft and Labor Codes - Revised 09/21/21
    XML Schema Tag Formats - Revised 06/29/22
    Sample Excel Spreadsheet and Corresponding XML