Skip to main content
Important Announcements:


8/18/23 - The software that our website is built on underwent a major upgrade.  As with many upgrades, things break!  We're still working diligently to correct the problems, but this is a HUGE website with almost 23 years of information.  We appreciate your patience.  

Compatibility for AASHTO Certified Payroll Upload for Connecticut DOT Released.

Last Updated: 27 February 2024
Share this!
Pin It

Connecticut Department of Transportation (CTDOT) has teamed up with the American Association of State Highway and Transportation Officials (AASHTO) and is now requiring ALL prime and subcontractors working on DOT projects with federal funding to submit certified payrolls into the AASHTOWare Project Civil Rights and Labor™ (CRL) Management System.  Sunburst is pleased to announce the release of compatibility for the AASHTO Certified Payroll Upload for Connecticut DOT.

The system processes contractors’ payrolls against the appropriate wage decision allowing for increased accuracy and timeliness.

You can create this spreadsheet with most of the data filled in by Certified Payroll Solution; however, there is NO WAY to provide this as a 100% accurate form that can be submitted due to complicated requirements. You will need to check this form carefully before submitting it.

The spreadsheet is provided by the vendor who developed the AASHTO Trans*port® system and many aspects of it cannot be changed or modified. This form has been provided in the NEWER Excel .XLXS format, therefore, Office/Excel 2010 or newer is required per their specifications.

The most important thing that you need to be aware of is that this spreadsheet CANNOT be printed by CPS, nor will the print preview be readable by the human eye.

DO NOT call and tell us that the Preview of the report is wrong, as there is NOTHING we can do about this.

You MUST click the preview button on the Print Window in order for CPS to create the Excel spreadsheet for you so that you can upload it. Once the spreadsheet is in the Excel format, you can then open it and look at it and verify that the data is accurate and add any missing information that is required.

QuickBooks on its own, doesn’t provide you with all of the necessary information for you be able to import or convert the payroll data directly.

AASHTO requirements are very complex and require quite a bit of setup in Certified Payroll Solution, please follow the step-by-step instructions provided in the pdf Connecticut AASHTO Setup Instructions (1.67 MB)  

Wondering what the AASHTOWare certified payroll report looks like?  Here's a   pdf sample that has been completed with Certified Payroll Solution (458 KB) .

One-on-one setup assistance is billable at $125 per hour. 

Certified Payroll Solution has been successfully completing the AASHTO upload format since 2014.