Sign In
An Official Site

CRL Payroll

Civil Rights and Labor

Civil Rights and Labor has MOVED to ODOT's ne​w public website. Please update your bookmarks and click the link to be redir​ected.


 ‭(Hidden)‬ Content Editor Web Part


Ohio Department of Transportation
Civil Rights and Labor Information



 ‭(Hidden)‬ Payroll XML Resources

This site contains resources for those contractors with existing payroll systems to aid creation of an extract of payroll data for upload into CRL.
For Contractors
Contractors and other firms that need to deliver valid Payroll XML files to agencies that use AASHTOWare Project software will be best served by using a payroll or project management system that already supports producing valid Payroll XML files. Alternatively, they can use the spreadsheet and online conversion utility in the AASHTOWare Project Payroll Spreadsheet Conversion Utility section of this site to manually enter their data into a Microsoft Excel spreadsheet and convert it from there into valid Payroll XML.
For Payroll System Developers 
Developers of payroll systems who want to produce valid Payroll XML files from their payroll systems to be passed to AASHTOWare Project software will find numerous useful resources in the AASHTOWare Project Payroll XML Resource Kit section of this site, including all needed XML schemas, examples showing creation of valid files, and both online and downloadable Payroll XML validators.
Contractors Using Payroll Excel Workbook for Payroll Submission 
The best way to produce Payroll XML files is to use a software system to manage the data that can also produce this format directly. However, not all end users will have such a system available to them. In that case, data can be produced using an Excel workbook. 
For contractors without in-house payroll systems Ohio DOT is providing an Excel workbook for entry of up to 50 employee payrolls. The Excel Workbook needs to be downloaded from this site to get started. Once populated users can keep payroll records by period and simply update the hours accordingly for subsequent pay periods. 

 ‭(Hidden)‬ Related forms and materials