AASHTO Trns•port® Payroll Spreadsheet Conversion Utility 1.03.000

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 Civil Rights and Labor Management System (Trns•port CRLMS®) module, or produced using an Excel spreadsheet.

This section contains a downloadable general-purpose Microsoft Excel 2007 spreadsheet that can be used to enter payroll data and an online conversion utility that can take a filled-in spreadsheet and return a valid Payroll XML file for delivery to an agency.

Spreadsheet

Download the general-purpose version of the Payroll spreadsheet here. You will need Microsoft Excel 2007 or 2010 to use this file.

Instructions:

Once you have saved a spreadsheet with your data, you can convert it to Payroll XML using the online converter below, and then deliver the Payroll XML file to the agency via whatever method they have specified.

Converter

Once you have a correctly formatted spreadsheet with your data entered, you can create a Payroll XML file online with this tool.

Instructions:

You can now deliver the Payroll XML file to the agency via whatever method they have established.