by Sunburst Software Solutions, Inc.
Archives by Month

Texas Department of Transportation Requires Electronic Certified Payrolls (E-Payrolls)

Print Friendly, PDF & Email

The Texas Department of Transportation, like many other state agencies, is requiring electronic submission of certified payroll reports, through its Electronic Project Records System (EPRS).

Texas Department of Transportation E-PayrollsTxDOT EPRS provides contractors with multiple functions which they can utilize; however, one of the primary functions of the EPRS is that of collecting Electronic Certified Payrolls (E-Payrolls), instead of requiring contractors to submit paper certified payroll report forms for review.

E-Payrolls may be uploaded into the EPRS from a contractor’s computer IF they have the proper information, in a specific data order, and it is a .CSV file format – otherwise the contractor will have to take his printed paper certified payroll report and manually input it in the EPRS System.

Some software companies are updating their payroll systems to provide their construction clients with the ability to create electronic output files, such as the .CSV file required by TxDOT, in addition to printing a standard paper report for the contractor to keep in his job file.  However, the problem for the software companies is that there is no standard output file that is used consistently and each state or agency wants the electronic file to not only contain ALL of the information that is required on their “paper form” but include additional information as well.

For example:

  • Texas Department of Transportation requires a .CSV file
  • Elation Systems, Inc. requires an XML file
  • TRS Consultants, Inc. requires an XML file
  • LCPtracker requires an .XLS file
  • Sandia National Laboratory requires an XML file
  • Alaska Department of Labor & Workforce Development requires a .TXT file
  • Wisconsin Department of Transportation requires an XML file
  • Wisconsin Department of Workforce Development requires an .XLS file

Some computer savvy contractors create a “master” certified payroll reporting form (based on the requirements of the State agency that they must submit them to) in Excel, manually input the payroll data each week and attempt to “save” it in any of the above mentioned file formats listed above – only to discover that the file is rejected and they have to log and manually type the information into the Labor Compliance System.


Certified Payroll Solution, a QuickBooks integrated application, will read your QuickBooks payroll data and generate paper forms and/or all of the required electronic upload formats noted above – included the format required by the Texas Department of Transportation .CSV format (this functionality will be released via a program update on 7/30/2010 and has been thoroughly tested by TxDOT).

Request a FREE 30-day trial to see for yourself.

One Response to Texas Department of Transportation Requires Electronic Certified Payrolls (E-Payrolls)

    About Your Host:

    Nancy Smyth, Certified QuickBooks ProAdvisor

    Nancy Smyth, Sunburst Software Solutions, Inc.
    QuickBooks Construction & Payroll Expert

    I've been using and supporting QuickBooks products since the early 1990's. I've worked with thousands of contractors, assisting them with QuickBooks setup, Certified Payroll Reporting requirements, AIA Billing and Weighted-Average Overtime.

    QuickBooks is a powerful product, but learning how to use it in your construction business can be difficult. I hope you find resources available here to be helpful.

    Top QuickBooks blogs to read in 2018
    We've been selected by TSheets as a Top QuickBooks blog to read in 2018!
    Stay updated!

    Sign up to receive our latest QuickBooks Tips, Tricks & News via email:

    Enter your email address:

    Delivered by FeedBurner

    We promise NOT to sell, rent, or otherwise distribute your name and email address!

    FREE 30-Day Trials

    Request FREE 30-day Trials of QuickBooks add-ons for Certified Payroll, AIA Billing & Payroll Wage Management. Save time and increase accuracy on time-consuming error prone tasks; so you get paid on time!

    Free 30 day trials of QuickBooks integrated add-ons for certified payroll, aia billing and weighted-average overtime

    Certified Payroll Training:
    Learn how to complete a Certified Payroll (Prevailing Wage) Report and fulfill your reporting requirements - 2 hour recorded webinar - $99.99. Click here for more info.

    certified payroll requirements webinar
    QuickBooks Training

    Frustrated with QuickBooks?

    QuickBooks Premier ContractorLearn how to get the MAXIMUM possible results from QuickBooks in your construction business! Visit our new QuickBooks training website, Learn to use QuickBooks in your construction business.

    QuickBooks Time Tracking

    Save 10%/FREE 14-day trial!

    QuickBooks Time Tracker