Excel Template - For contractors without in-house payroll systems Ohio DOT is providing an Excel Template for entry of up to 50 employee payrolls.  The spreadsheet/template 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. 

Template Conversion Tool - Upon completion for a pay period users can convert the Ohio provided template to XML for upload into CRL.  The XML conversion utillity is free to use and does not store any information.  The site takes the Excel file, converts it and provides the correctly formatted XML file back to the contractor for upload into CRL.

• XML Upload from Payroll System: This option will most likely be used for larger sized contractors who have payrolls systems and the capacity format extracted data per the provided XML schema.
• Requirements for XML Formatting​. Contractors will utilize this to work with their payroll vendors or internal IT staff to export payrolls to XML format. Provides all required schemas to allow conversion to XML format.
• Job Classifications Standardization. This is the second tab on the payroll spreadsheet. This will house all job classifications associated with Ohio DOT projects.​
• CRL Support Contacts​. This list contains your first line of contacts when you have issues with your CRL payroll process.

​Upon implementation, all Ohio DOT Construction Contracts will go through Ohio CRL System (date:  projects sold after April 15, 2015).  Requests for projects sold prior to this date should be submitted to dot.pweeo@ohio.gov. 

The system manages Ohio DOT's Civil Right requirement and provides contractors electronic access to submit Certified Payrolls, Bidder/Quoter Information, and Prompt Payment Reports.  It provides faster, easier and more accurate ways for contractors to meet government reporting requirements. 

Columbus, Ohio 43223
DOT.CRL.Support

Click here to take a CRL Training Survey