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
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.