Skip to Main Content

COVID-19 INFORMATION

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.7 (Current) - Updated 09/21/21
    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 02/19/21
    Sample Excel Spreadsheet and Corresponding XML

Computer Based Trainings (CBT)
    Step 1A | Manually Add a Payroll 
    Step 1B | No Work Performed
    Step 1C | Create a Payroll Spreadsheet
    Step 2 | Convert a Payroll Spreadsheet
    Step 3 | Import and Validate a Payroll
    Step 4 | Sign a Payroll
    Step 5 | Tiered Review of Payrolls
    Step 6 | Modify a Rejected Payroll

Quick Reference Guides (QRG)
    Step 1A | Manually Add a Payroll
    Step 1B | No Work Performed - Updated 09/28/21
    Step 1C | Create a Payroll Spreadsheet
    Step 2 | Convert a Payroll Spreadsheet
    Step 3 | Import and Validate a Payroll
    Step 4 | Sign a Payroll
    Step 5 | Tiered Review of Payrolls
    Step 6 | Modify a Rejected Payroll