Welcome to the Sunburst Software Solutions, Inc. Training, Support & Resource Area!
The Sunburst Software Solutions, Inc. "Support, Training & QuickBooks Resource Area" has been designed to provide you with written training articles, as well as Audio/Video training for our QuickBooks integrated applications for Certified Payroll, AIA® style billing, weighted-average overtime, and payroll wage management add-on software.
The home page of our Support & Resource Area (which you are viewing now) is used to notify customers (and visitors) of new program updates and/or enhancements that are available, and recently added training articles for both our software and QuickBooks.
Find the help you need...FAST! Click a link below.
![]() |
![]() |
![]() |
![]() |
![]() |
Check out our latest announcements and most requested support articles below!
Nevada DOT AASHTO Certified Payroll Upload Available
Nevada Department of Transportation (NDOT) 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 Nevada DOT.
7-13-21: US DOL Releases Final WH-347 Form
The WH-347 form was set to expire on 4/30/2021, however, the U.S. Department of Labor issued 3 temporary Form WH-347 Revisions before releasing the final version for use.
The expiration date is the ONLY major thing that has changed - the new expiration date of this form is 07/31/2024.
How this impacts you:
Another Update for Illinois DOL Electronic Uploads
Illinois Department of Labor has released a new Affidavit/Weekly Statement of Compliance for their Certified Transcript of Payroll Portal, replacing the one that has been required for years. Electronic reporting requirements initially went into effect on 9/1/2020.
Illinois DOL Certified Payroll Portal Upload Compatibility
Certified Payroll Solution for QuickBooks is now compatible with the Illinois Department of Labor (IDOL) Certified Transcript of Payroll Portal. Quickly and easily complete the Certified Transcript of Payroll import template (xls) and the Fringe Benefit Affidavit (docx) files provided by Illinois Department of Labor (IDOL). Electronic upload/submission requirements begin 9/1/2020. Paper reports will no longer be accepted.
Montana DOT AASHTOW Certified Payroll Upload Available
Montana Department of Transportation (MDT) 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. 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.
Washington (State) L&I Electronic (XML) Upload Available
There is a new XML upload format specified by Washington L&I which goes into effect on January 1, 2020. We have completed the necessary coding changes to Certified Payroll Solution and have run through initial testing.
City of New York Certified Payroll Update Available
10/29/2019
The City of New York - Office of the Comptroller - Bureau of Labor Law has released a REVISED/UPDATED Certified Payroll reporting form, which went into effect IMMEDIATELY upon the release of the revised form.
This updated report includes 2 pages of instructions, that MUST BE PRINTED AND SUBMITTED when you submit the actual report.
New Jersey Certified Payroll Major Changes 10-2019
Earlier this year, New Jersey Governor Murphy enacted the Diane B. Allen Equal Pay Act an gave the actual certified payroll reporting form an overhaul.
Now, the New Jersey Department of Labor (NJDOL), Division of Wage and Hour Compliance has made major changes to the Statement of Compliance. Among the changes to the form, there is now a section (table) requiring that where the fringe benefit due employees is paid to approved plans, funds or programs (rather than to the employee in cash), contractors must MUST indicate which part of the total fringe benefit amount was paid to each of the following plans/funds/programs:
- health/welfare,
- vacation/holiday,
- apprenticeship/training,
- pension
- and "Other" - which you are required to explain.
The form also requires that for each plan/fund/program, the contractor must include the hourly rate paid, the name and address of the fund, plan or program administrator, the USDOL benefit plan filing number or EIN, and any third-party trustee and/or contact person.
No other state (to date) requires contractors to submit THIS MUCH information.
Errors When Printing Certified Payrolls or Billings
Below are the most common errors or problems that you could encounter when attempting to Preview or Print your final reports - including a SPINNING HOURGLASS, Run Time Error 91, Run Time Error 429 - Active X Component, Error 80010105 Automation Error, Invalid Registration, and more.
This article also addresses what happens when Office 2016/365 has NOT been licensed or activated and when more than one version of Office is installed on your computer.
Windows 10/Office Printing Issue
A recent Windows 10 update has caused issues when previewing and printing AIA Billings and Certified Payroll Reports. While we have put in some workarounds they are only band-aids. There are two ways to resolve this - a quick fix and what is hopefully the "real" resolution. This article deals with both programs as the resolution is similar for each
California DIR eCPR, PRISM, LCPtracker upload feature for QuickBooks
There is a LOT going on in California regarding certified payroll reports, prevailing wage requirements and electronic certified payroll (eCPR) submissions. Briefly, here is the lastest news regarding California DIR eCPR, City of San Diego and PRISM Compliance Management, and LCPtracker requirements and how they will impact your company if you use QuickBooks.
Compatibility Virginia DOT AASHTO Trns•port® Payroll Spreadsheet
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.
California eCPR (Electronic Certified Payroll) for QuickBooks
As most of you are aware, the California DIR's (Department of Industrial Relations) electronic certified payroll reporting (eCPR) system has been updated with new requirements in place for public works projects awareded on or after April 1, 2015. The new eCPR system became effective on 6/4/2015.
The new eCPR requirements involve submitting an XML file and replaces the previous .pdf upload. XML stands for Extensible Markup Language and defines a set of rules for encoding documents in a file format which can be read by both humans and machines. This language, in my opinion, is far easier for a machine to read than a human!
QuickBooks Connection Error Messages
The solutions below are used to diagnose and solve the following QuickBooks Error Codes: 80040401, 80040402, 80040403, 80040404, 80040405, 80040406, 80040407, 80040408, 80040409, 8004040A, 8004040B, 8004040C, 80040416, 80040417, 80040418, 8004041B, 8004041C, and 8004041D.
Installing Your Software on a new computer
Are you planning on purchasing a new computer -or- do you have a new computer? Follow these instruction for moving your Certified Payroll, AIA Billing or Crew Overtime Entry Solution program and data to a new computer.
Make sure your computer tech reads this article and Is There a New Computer in your future? Buying a New Computer.
AIA® Style Billing Best Practices
AND Resolving Common User Errors When Using Construction Application for Payment Solution
Common QuickBooks user errors not only compromise the integrity of your billing history in Construction Application for Payment Solution; but do not leave a visible documented history of the projects progress in QuickBooks. This article will teach you best practices when generating your AIA® Style Billings when using CAPS in conjunction with QuickBooks.
Employee Work Classifications Not Showing As Desired
While a normal or familiar error message box will not appear when employees are not being classified correctly on the final certified payroll reports, it will be easily recognized when you preview or print your certified payroll reports. Use the following information to diagnose WHY your employees are not being classified correctly. HINT this is not a program error!
Matching QuickBooks Paycheck Totals With Certified Payroll Report Totals
A guide for verifying and troubleshooting the accuracy of your final certified payroll reports before you submit them is an important step in your overall success in using Certified Payroll Solution and getting paid on time. TIP: on the Federal WH-347 form the dollar amounts from Gross Wages All Jobs through Net Wages for the week SHOULD match the QuickBooks paycheck.
Special Announcements:
- Nevada DOT AASHTO Certified Payroll Upload Available
- QuickBooks 2023 Compatibility Announced
- Resolution for problems with initial QuickBooks 2022 release
- IMPORTANT! Problems with QuickBooks 2022 - Don't Upgrade
- Important News About QuickBooks Desktop 2021 & 2022
- 7-13-21: US DOL Releases Final WH-347 Form
- U.S. DOL issues temporary WH-347
- Another Update for Illinois DOL Electronic Uploads
- QuickBooks DESKTOP 2021 Compatibility IS AVAILABLE
- Illinois DOL Certified Payroll Portal Upload Compatibility