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.9 (Current) - Updated 07/09/24
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 07/09/24
XML Schema Tag Formats - Revised 06/29/22
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