Quick Search Results

    Not finding your answer?

    View More Results

    Certified Payroll

    Article ID: 1000692


    This article explains how to create a Certified Payroll Report in QuickBooks.

    Projects that are publicly funded typically require the contractor to pay a prevailing wage (Davis-Bacon wage) rate for workers on the job. Then, for each payroll period, the contractor must create a certified payroll report that shows the wages paid to each worker.

    QuickBooks Certified Payroll reporting is a substitute for the federal form WH-347. It lists information about the company and the project, the employee's name, last four digits of their Social Security number and job classification. It also shows hours worked by each employee, rate of pay, gross wages, deductions and net pay. The reports must be printed and signed by an authorized official of the company to certify accuracy.

    Expected Outcome

    You will be able produce a certified payroll report showing prevailing wages (Davis-Bacon wages).


    You have an active, up-to-date version of QuickBooks.



    You must meet the following criteria in order to create a Certified Payroll report:

    • You must have full version of Microsoft Excel. If you are using a trial version, make sure that trial period has not expired yet.
      NOTE: QuickBooks 2013 and 2014 are not compatible with any version of Microsoft Excel 2003.
    • Use the QuickBooks time tracking feature.

      Enter time by job for each employee using the payroll items you use to pay employees. It is best if you enter time and then pay the employees using that time so that the time records and hours paid will be the same. You can still use this report without using the time feature, but you ll need to input your daily hours directly on the report.
      • Weekly payroll: you have created a weekly payroll and have included your certified payroll job on your paychecks (this happens automatically when you use time tracking). To learn how to use timesheet information in paycheck creation, see How to create paychecks based on timesheet hours or single-activity items.
      • Your paychecks use earnings items named after your work classifications.
        For example, you might use hourly items with names like Carpentry, Electrical, or General Labor for your work classification codes. The item names you use will appear on your report.
      • If your employees work overtime or double-time, pay the employees with an actual Overtime Earnings item, not just a regular item named overtime. (Check to see if you are using a special overtime item by editing the item from our Payroll Items list and looking for the Define Overtime slide. If it does not appear, the item isn't an overtime item.)

        To learn how to create an overtime payroll item, see Set up an hourly wage payroll item.

    Create a report

    1. From the Reports menu, choose Employees & Payroll > More Payroll Reports in Excel > Certified Payroll Report.
    2. Follow the on-screen instructions to create the report.
      • As you follow the instructions, the Certified Payroll Report Interview window will open to gather additional information.

    Related Articles

    For an industry-specific report for contractors entitled "Certified Payroll - Box 1 Employee Information report," see How to fill out box 1 of the Certified Payroll form. This report is only available in QuickBooks Premier/Premier Accountants Edition and Enterprise Solutions/Enterprise Solutions for Accountants company files that include an Assisted or Enhanced Payroll subscription.

    Excel based payroll reports
    Create Deferred Compensation report for 401K and more in Excel

    Top Answers


    Most Used Forms

    Find and download individual and federal forms required for your business.

    Payroll Tax Support

    Stay in compliance, ensure you're up to date on all necessary tax agency information from Federal to State agency


    Give employees 24/7 access to payroll information they need.