Ohio.gov State Agencies  |  Online Services
Skip Ribbon Commands
Skip to main content
Sign In
CRL-L.jpg

Ohio Department of Transportation
Civil Rights and Labor Information
PAYROLL

CRL-R.jpg
 

 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.  https://xml.cloverleaf.net
 
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 Spreadsheet 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 spreadsheet. 
 
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.
 
 

 Related forms and materials

 
Transitions - Resource Guide
 

 Updates - Week of 05/03/2015

 

Training Schedule Published

Updates - Week of 04/19/2015
ViewPoint Contractors - ViewPoint has created a utility for the XML extract.  Please contact ViewPoint Support in order to receive the utility. 

Ethnicity Codes Listed

Week of 03/29/2015
Payroll Template/Spreadsheet Updated to Fix Locked Cells on Employee Tab.

Week of 03/22/2015
Foundation Software Inc - Successful Import into CRL!!!

Craft Codes Listed

Labor Codes Listed

Payroll Template/Spreadsheet Updated to Include Employee Information Tab.

 

The Web Part has timed out.