A new Certified Payroll Solution support article has been added to our main website – Matching Your QuickBooks Paycheck Totals With Your 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.
This mini-manual focuses on the Federal WH-347 form – which everyone has access to, 99% of the time, if the WH-347 form is accurate, any other state specific form that you are required to complete will be also. It will teach you how to:
Match your QuickBooks paycheck totals with your Certified Payroll Report totals
Correct the 6 most common problems, based on over 10 years worth of support calls
- When employee Work Classifications are not correct
- When Straight Time and Overtime hours do not show correctly, are displayed under 2 different Work Classifications, or are missing
- When Column 6 does not display the correct base rate of pay and/or cash fringe rate
- When Gross Amount Earned ALL JOBS (the lower number in Column 7) does not match the total Earnings PLUS any Additions included on the paycheck
- When Total Deductions do not match the Taxes PLUS any Deductions withheld on the employees paycheck AND when Net Wages Paid for Week (Column 9) does not match the amount of the paycheck
- When the “Other Deductions Key Coding” does not accurately reflect the deductions taken from the employee paychecks
Verify where every piece of information on both the Certified Payroll Report AND the Statement of Compliance comes from so there are no “empty” spaces or missing information
This 37-page document is divided into 3 sections and procedures for matching your paycheck totals with your final certified payroll report totals. The procedures are different depending on how you pay the fringe benefit portion of the prevailing wage:
- Full fringe amount is paid to the employee as part of gross hourly wage
- Full fringe amount is paid to a Union or into a bona-fide plan
- A portion of the full fringe is paid to a bona-fide plan and the balance is paid to the employee in cash
If you use Certified Payroll Solution, download your copy of Matching Your QuickBooks Paycheck Totals With Your Certified Payroll Report Totals today.
Back 2000 who would have thought that developing a QuickBooks integrated add-on would become a very popular trend among software developers?
Heck, there wasn’t even a widely known, let alone an “Intuit approved method” of accessing QuickBooks data at that time, so WHY would anyone want to form a company that would read QuickBooks data to generate certified payroll reports for construction contractors?
Yet, on August 16, 2000 that is exactly what Ben & Nancy Smyth of Sunburst Software Solutions, Inc. decided to do – write QuickBooks integrated software that would produce Certified Payroll Reports for government construction projects.
Ten years and almost 4,000 contractors using QuickBooks later; Sunburst is still going strong.
We would like to say “thank you” to all of our current and past customers for their support and feedback; you’ve only helped us provide more functionality than we initially planned for.
We’ve been testing, debugging, and documenting numerous certified payroll and AIA billing updates for the last few weeks – I’ve posted some of the information behind the changes here in our blog.
Today, I just send out a newsletter to over 2,000 construction companies (in all 50 states) who use our software – Glad I use Constant Contact to keep everyone up to date, otherwise they would get me for spamming 
Below are highlights from the newsletter.
Certified Payroll Solution Updates:
There are several new enhancements, changes, and requirements available for Certified Payroll Solution; some at the State level for certified payroll reporting and others at the Federal level for EEOC Reporting – each item has a link to our website where you will find complete instructions. Be sure to visit our website to obtain the instruction on how to download & install the updates and implement any new changes that you will need to make.
- California DIR established Compliance Monitoring Unit and requires electronic certified payroll reports via a Labor Compliance Program (LCP) developed by TRS Consultants, Inc. Click here for details.
- New FHWA 1391 & 1392 Annual EEO Reports for Federal Highway Contractors – the U.S. Department of Transportation Federal Highway Administration revised both the 1391 & 1392 in June 2010. The new forms print on LEGAL SIZE paper and require that you report employees who are of two or more races separately. Click here for details.
- Texas DOT Requires Electronic Certified Payrolls {E-Payrolls} – 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). We have worked closely with representatives of Texas DOT to ensure that CPS will create the required .CSV file. The electronic upload has been tested and approved by Texas DOT. Click here for details.
- Revised Mississippi CAD-880 & CAD-881 Forms – Mississippi Department of Transportation (DOT) has revised their CAD-880 & CAD-881 Forms and updated forms are available to download. The Certified Payroll Report now includes the Race & Gender of each employee. Click here for complete details.
- New York City Housing Department Form Update – The New York City Housing Department is requiring that ALL certified payroll reports submitted on the Federal WH-347 form include the”Public Burden Statement”. Click here for complete details.
- Wisconsin Bug Fixes – corrects DOT Statement of Compliance check boxes and Department of Workforce Development Electronic upload error. Download CPS Version 5.0.440 and then download Wisconsin DOL forms.
- More Missouri revisions – including the ability to print the certified payroll report forms on either standard or legal-sized paper. Download CPS Version 5.0.440 and then download new State of Missouri forms.
- Alaska Electronic Certified Payroll Upload News – Over a year ago we were contacted by the Alaska Department of Labor & Workforce Development to provide an electronic upload for their new on-line certified payroll filing. We worked closely with them to provide them with the correct information and upload type. A couple of weeks ago, we were contacted again and the system is now live. Download this brochure from the Alaska Department of Labor & Workforce Development, download this article for setting up CPS to generate the required files.
Construction Application for Payment Solution (AIA Billing Updates)
We’ve also been working on the Construction Application for Payment Solution (for AIA Billing). We’ve added new functionality and forms that have been requested by YOU, our customers. Each new item is listed below, if there are “special” instructions for implementing the new feature – be sure to click the link to visit our website and download ALL of the download & setup instructions that are available.
- Quantities on the Continuation Sheet – Currently this is a tested ALPHA release (Version 5.0.219), which provides Quantity Tracking (estimated, previous, current, stored, previously stored quantities and unit price can be tracked and printed with CAPS). New forms have been added with quantities. In some cases, prior form selection on jobs may be incorrect – check the Form Printing Options for each Job (Edit menu -> Jobs -> select Job -> Edit -> Printing tab -> check selection in the Select a plain paper form for this job. CAPS now provides 22 different plain paper invoicing formats for you to choose from.
- Contractor Qualification Statement – In April we released in BETA a Contractor Qualification Statement as part of the Construction Application for Payment Solution Program. Some, but not all of you have downloaded this update (Version 5.1.214) and it is currently in BETA until we hear more feedback from you.
- Plain Paper 706, 706A, 707 & 707A forms – In March, we released in BETA the ability to create complete 706, 706A, 707, & 707A forms using plain paper – rather than having to purchase AIA originals. Some, but not all of you have downloaded this update (Version 5.0.184) and it is currently still in BETA until we hear more feedback from you.
PRESS RELEASE
For Immediate Release
Contact
Nancy Smyth
Sunburst Software Solutions, Inc.
(888) 348-2877 phone
(866) 684-5157 fax
sales@sunburstsoftwaresolutions.com
http://www.sunburstsoftwaresolutions.com
SUNBURST SOFTWARE SOLUTIONS, INC. RELEASES FEDERAL WH-347 COMPLIANCE UPDATE FOR “CERTIFIED PAYROLL SOLUTION” AND CONTRACTORS USING QUICKBOOKS.
“Certified Payroll Solution” Integrates with QuickBooks to Help Contractors Working on Government Funded Construction Projects Comply With Certified Payroll Reporting Requirements, Saving Them Time And Money.
West Charleston, VT – January 16, 2009
Sunburst Software Solutions, Inc., an Intuit Gold Developer, is pleased to announce the release of a compliance update, on January 14, 2009, for their flagship QuickBooks integrated application “Certified Payroll Solution.” This compliance update meets new Federal WH-347 certified payroll reporting requirements which become effective January 18, 2009, as mandated by the U.S. Department of Labor on December 18, 2008.
“Certified Payroll Solution” utilizes QuickBooks Pro, Premier, and Enterprise Solutions timesheet, employee, job, and payroll data to automate the creation of Federal and/or State mandated certified payroll reports, statements of compliance, “No Work” performed payrolls, EEOC Reports and Union/Bona-fide Plan Fringe Benefit Reports. This exchange of critical data helps contractors working on prevailing wage construction projects to manage their compliance reporting more efficiently – saving them valuable time, money and resources.
“Manually creating certified payroll reports is simply a horrendous, time-consuming, error-prone process and if your reports aren’t accurate, you simply don’t get paid in a timely fashion. Before developing ‘Certified Payroll Solution,’ I created my certified payroll reports for years using an Excel spreadsheet and several reports from QuickBooks, and no matter how careful I was, there was always a mistake somewhere,” says Nancy Smyth, Sunburst Software Solutions, Inc. President, also a Certified QuickBooks ProAdvisor. ”I knew there had to be a better way and that way involved using data that I had already entered in QuickBooks.” She continues, “Essentially, without having to re-enter data manually into another program, errors were eliminated. Although this left the middleman – me – out of the picture, the savings to the small and mid-size business owner was tremendous!”
There are more than 12 million small businesses currently using computers in the United States (TowerGroup, 2001). Developing a QuickBooks integrated certified payroll program, and later an AIA type billing program, made sense to the husband and wife team, Ben & Nancy Smyth, principals of Sunburst Software Solutions, Inc. Nearly three million small businesses (and almost 200,000 are contractors) use QuickBooks and 80 percent of those users want QuickBooks to integrate with other software and devises (QuickBooks 2000 User Study).
The “Certified Payroll Solution” updates provides compatibility with new WH-347 reporting requirements, which no longer require the reporting of full employee social security numbers and home address; but rather just a unique employee identification number, usually the last 4 digits of the employee social security number. Additionally, Sunburst Software Solutions, Inc. has built in the ability for current users to easily change these reporting requirements on State specific reports and/or electronically filed reports as new requirements are announced.
About Sunburst Software Solutions, Inc.
Sunburst Software Solutions, Inc. has been providing contractors using QuickBooks Financial Software with a fully automated, integrated means to generate certified payroll reports and AIA type billings since October 2000. For more information, visit http://www.sunburstsoftwaresolutions.com
About Intuit Inc.
Intuit, the Intuit logo, Quicken, QuickBooks, QuickBooks Pro, QuickBooks Premier, Turbo Tax, ProSeries, and Lacert, among others, are registered trademarks and/or registered service marks of Intuit Inc. in the United States and other countries. Other parties’ trademarks or service marks are the property of their respective owners and should be treated as such.
# # #
Important Note: As of January 16, 2009 there was no new or revised WH-347 form available from the U.S. Department of Labor, we will continue to monitor the site for the availability of a new form, if applicable.
###
View this PRLog.org http://www.prlog.org/10168568-wh-347-compliance-update-for-certified-payroll-solution-and-contractors-using-quickbooks.html
