Oops! It appears that you have disabled your Javascript. In order for you to see this page as it is meant to appear, we ask that you please re-enable your Javascript!

Certified Payroll Report in QuickBooks

What Is Certified Payroll Report ?

Genrate Certified Payroll Report Intuit QB
Certified Payroll Report is another imperative report generated under QuickBooks Payroll Desktop software. In order to generate it, user first needs to be aware about its internal working process and related functions that aid in its creation. User can also find How to Start using Reports in QuickBooks Payroll in easy steps .

There are certain projects taken up by the companies in which the funds are acquired through public. Under this the contractor has to provide the worker with prevailing wages at rate decided under Davis-Bacon wages. To provide details regarding the same, contractor has to prepare Certified payroll report for each and every payroll period.

Certified Payroll Report acts as the basic alternative for the Federal Form WH-347 with all the required details enabled in it. The report consists of details regarding the company, related project, employee’s name and social security number’s last four digit along with the job classification. The report also provide information on how much hours are put in by the employees, rate of their pay, gross wages and net pay along with deductions. The report at the end is printed out and then signed on by the authorized personal of the company to ensure authenticity of the report.

Requirements for Prevailing Wages & Certified Payroll Report


It is assumed that the user has an active subscription of QuickBooks Desktop software which is latest and up to date.


User must ensure that following criteria are met in full to generate a working Certified Payroll Report:

  • User must be in possession of complete up to date version of Microsoft Excel.If they are using a trial version, then they need to ensure that trial period has not expired yet.

NOTE: QuickBooks Desktop 2013 and 2014 are not compatible with any version of Microsoft Excel 2003.

  • Use the QuickBooks Desktop time tracking feature.

Create QuickBooks Certified Payroll Report

Enter time by job for each employee using the payroll items that user uses to pay employees. It is best if they enter time and then pay the employees using that time so that the time records and hours paid will be in tandem. User can still use the same report without using the time feature, but they will need to input their daily hours directly on the report. You have to check out QuickBooks Payroll By Job Report in full mode to clear your doubts.

  • Users will be required to generate Weekly Timesheets for swift record of wages
  • Classes assigned on timesheets should match the classes on paychecks.
  • Weekly payroll: users have created a weekly payroll and have included their certified payroll job on their paycheckswhich occurs only when time tracking is set to start automatically.
  • Users paychecks employ earnings items named after their work categories. For example, user might use hourly items with names like Carpentry, Electrical, or General Labor for their work classification codes. The item names they use will appear on their
  • If the employees work overtime or doublethe time allotted to them , then the user has to pay the employees with the actual Overtime Earnings field, not just a regular item named overtime. (they need to check to see if they are using a special overtime item by editing the item from their Payroll Items list and looking for the Define Overtime slide. If it does not appear, the item isn’t an overtime item).

Problem Fixing Generating Intuit QB Certified Payroll Report

The above details regarding the Certified Payroll Report should help to generate the report successfully. However, if faced with any issues, user can call the QuickBooks Payroll Customer Support team setup by Intuit who are proficient in tackling all sorts of QuickBooks payroll issues. They are extensively knowledgeable and intensively trained to interpret and resolve all payroll issues faced with QuickBooks. In case the connection with QuickBooks support team is unable to get established alternative support agency can be called on by the user through live chat at QBPayrollHelp and call via toll free number – Call QB Payroll Support 1844 827 3817.

Leave a Reply

Your email address will not be published. Required fields are marked *

Call Now: 1-844-827-3817