Important Announcements:

QuickBooks 2021 Compatibility is available!  Read more here.  Please note: Our software products ONLY work with QuickBooks DESKTOP.  NOT COMPATIBLE WITH QUICKBOOKS ONLINE or QUICKBOOKS MAC.

 
note
  • 7/14/21:  US DOL Releases Final WH-347 Form - Please update your software!  7-13-21: US DOL Releases Final WH-347 Form
  • 7/01/2021:  U.S. Department of Labor issues temporary WH-347 Form.  Read this article to see how this impacts you.
  • 12/07/20:  Illinois Department of Labor electronic Certified Transcript of Payroll system issues new Affidavit/Weekly Statement of Compliance.  More details can be found here, including updated setup instructions.
  • 8/24/20:  Program Update - Compatibility with Illinois Department of Labor electronic Certified Transcript of Payroll system.  For more information and step-by-step instructions for obtaining the update as well as required setup, Illinois DOL Certified Payroll Portal Upload Compatibility.
  • 8/24/20:  Program Update - Montana Department of Transportation (DOT) to require certified payroll data to be submitted via AASHTOWare Project Civil Rights and Labor™ (CRL) Management System.  For more information and complete step-by-step instructions for obtaining the update as well as detailed setup instructions please read - Montana DOT AASHTOW Certified Payroll Upload Available.
  • Washington (State) L&I Electronic (XML) Upload Available & Effective 01/01/2020.  For more information and complete instructions for how to obtain the update and setup visit this page - Washington (State) L&I Electronic (XML) Upload Available

 

FREE 30-Day Trials

FREE 30 day trial

Subscribe for News

Enter your email address:

Delivered by FeedBurner

Visit our other sites:

Compatibility Virginia DOT AASHTO Trns•port® Payroll Spreadsheet

Pin It

Virginia DOT has teamed up with the American Association of State Highway and Transportation Officials (AASHTO) and is now requiring ALL prime and subcontractors working on VDOT projects with federal funding to submit certified payrolls into the AASHTOWare Project Civil Rights and Labor™ (CRL) Management System.

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 Excel 2007 format, therefore, Office/Excel 2007 or newer is required.

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.

According to the Virginia DOT website “This new system provides a faster, easier, and more accurate way for contractors to meet government reporting requirements.” They also tell you that there are three ways in which to enter the data:

  1. Manually into the web based CRL system
  2. Import payroll data by using CRL System payroll spreadsheets with an XML converter tool
  3. Convert payroll program data to an XML file to import into the system.

What they don’t tell you is that both options 2 and 3 require some software coding experience or a lot of manipulation.

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 instructions in pdf this document (3.05 MB) carefully as this information is NOT yet in manuals or in program help.