by Sunburst Software Solutions, Inc.
Archives by Month

New Certified Payroll Solution Support Article

Print Friendly, PDF & Email

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

  1. When employee Work Classifications are not correct
  2. When Straight Time and Overtime hours do not show correctly, are displayed under 2 different Work Classifications, or are missing
  3. When Column 6 does not display the correct base rate of pay and/or cash fringe rate
  4. 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
  5. 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
  6. 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.

Leave a Reply

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.

Search our site
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