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• CRLMS®) module, or produced using an Excel spreadsheet.
This section contains a downloadable general-purpose Microsoft Excel 2007 (XLSX) 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.
Download the general-purpose version of the Payroll spreadsheet here. You will need Microsoft Excel 2007 - 2013 to use this file.
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.
Once you have a correctly formatted spreadsheet with your data entered, you can create a Payroll XML file online with this tool.
You can now deliver the Payroll XML file to the agency via whatever method they have established.