AASHTOWare Project™ Payroll Spreadsheet Conversion Utility 1.03.002.00
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 manually entered
directly into the AASHTOWare Project Civil Rights & Labor Management System™ (formerly Trns•Port CRLMS®)
module, or produced using an Excel spreadsheet.
This section contains a downloadable AASHTO provides a general-purpose Microsoft Excel 2007 (XLSX) spreadsheet to agencies that can be used to enter payroll data (Payroll Spreadsheet) and an online conversion utility that can take a filled-in spreadsheet and return a valid Payroll XML file for delivery to an agency.
Download the Payroll Spreadsheet: Log into Cloverleaf > Software Downloads >AASHTOWare Project section/Related Documentation Tab.
Populate the tabs Ethnicity, Craft, Labor, and State with your agency's specific values prior to distributing to the contractor.
Please contact your agency to request a copy of their customized Payroll Spreadsheet.
Completed Payroll spreadsheets can be used with the Conversion Utility below.
Once you have a payroll spreadsheet with your data
entered, you can create a Payroll XML file online with this
If the online spreadsheet conversion utility fails to work correctly, this may be the result of an error caused by Windows Update KB2962872. Please refer to this document for instructions on how to resolve this issue.
Use the following form to select the spreadsheet you have created,
Check the box agreeing to the
click the Convert button to send your spreadsheet to
the online conversion utility.
Save the Payroll XML file that is returned from the online converter.
You can now deliver the Payroll XML file to the agency via whatever
method they have established.